Md Sirajus Salayhin

- Spearheaded​ Data Lake and Data Warehouse in Google Cloud Storage and Google Big Query - Improved Data Pipeline framework which is primarily used for data collection from different data sources and transformed 1000+ attributes into Data Lake and Data Warehouse. - Collaborated with the team for developing a real-time data pipeline using Google Pub-Sub - Authored ​a reporting framework that runs periodically on Data Warehouse - Implemented ​data access control policy for Pathao

- Design & Implemented data models for different business verticals (rides, foods, couriers, etc) which guides stakeholders to understand the business matrix in a single dashboard. - Executed development of ​a data pipeline monitoring framework to check data integrity and data quality, which reports to stakeholders if any data quality breaks. - Maintained Data Pipelines for Data Lake and Data Warehouse, which includes an integrated monitoring dashboard for stakeholders.

- Programmed data pipelines for collecting terabytes of data sets into S3 & Redshift - Transformed terabytes of semi-structured data in S3 with proper partitioning Parquet format for analysis from AWS Athena - Design and Implemented data models for DNS records to prepare marts with useful information like host, ISP, country, etc. - Launched a dashboard with Redash where users have to search and compare from billions of DNS records and get useful information including host, ISP, country.

- Supervised Database Administration for troubleshot Architectural Design With Existing Data warehouse and data integration pipelines, which involves terabytes of data migration, replication, log shipping, database backup.

- Core contributor to building Data Lake and Data Warehouse in S3 and SQL Server 2016 - Integrated Data Pipeline framework which is primarily used for data collection from different data sources including 3rd Party APIs, Google Spreadsheet, MySQL and processed 100+ attributes into Data Lake and Data Warehouse. - Coordinated with the team to build a reporting framework that runs periodically on Data Warehouse - Coded development of backend API services

- Deployed a B2B marketplace application with multiple sellers, buyer for farmers, for the most unique, specialty foods from around the country (Ruby on Rails, MySQL) - Launched a web-based tool for social media data analysis and scheduled social media posts (Ruby on Rails, PostgreSQL) - Extended functionality of web-based school management system software (Ruby on Rails, PostgreSQL). - Core Maintainers of CI/CD pipelines and Cloud Infrastructure in AWS which increased development efficiency by 80%

- Co-operated with the development team for building an API for social media mobile application. - Co-Authored one of the largest auto sites in Canada owned by Toronto Star. - Programmed development of a B2C multilingual rental shop where customers could rent ski items from different shop owners. - Enhanced​ OMR reader for university online exams which reduced manual time upto 95%