SOHAIL ISLAM

Designed and implemented a data pipeline to gather data from 15+ facts and dimension table and dumping them in a single table to provide user an aggregated view. Designed and developed an analytics dashboard using Python, AWS Athena and Bitbucket. Hosted the same on Heroku. Starting to learn data science to implement ML models in production as first hire in data analytics domain.

Designed and developed an in-house open-source dashboard using Python, Dash (Plotly Framework), AWS RDS, SQL to show Plating process in all the Molex plants across globe along with Deloitte. This project saved around 15 million dollars annually. Automated data pull from SAP ABAP using Python & VBA to save 2-3 FTE resources during month end reporting and analytics activities. Designed and developed an ETL pipeline to create tables for recurring data points for effective reporting and resource utilization during month end activities. Developed and automated ETL that ingested data from SharePoint folders to Postgre tables and then further fetched in Power BI and Tableau dashboard.

Developed Looker dashboard using LookML code for multiple customers of Bidgely showing different Bidgely metrics. Took part in QA activities for different data science algorithms. Tested the data science by building out Python script.

Automated quarterly alliances data set tagging to save 36 hours using Python and achieved very high accuracy. Designed and developed OEM SKU Price tool using HTML, CSS, JavaScript (Front End) and Google Sheet (Backend).