Sohail Shaikh Email & Phone Number

Toronto, Ontario, Canada

- Developed and ran 100+ data pipelines on a weekly basis to update data across 20+ tables on AWS Redshift to create an easily accessible and central hub for four years worth of historical data. - Collaborated with business analysts, SEO specialists, QA analysts and senior management to provide clients with end-to-end wraparound supports for data analysis and secured client services for an additional five years through a request for proposal. - Coached two junior team members to design data architecture by transforming multiple data tables across 13 data granularities into a single consolidated data source for client’s analysis needs. - Led a process improvement and modernization project for ETL processes by migrating three years’ worth of data from Tableau online data source to AWS Redshift tables, improving efficiency and eliminating the need for an outdated ETL tool. - Improved data architecture management by reducing the number of pipelines running concurrently by 50 per cent which led to a reduction in BMWs monthly operational costs. - Delivering weekly sales and marketing data for new BMW vehicle models to the client’s cloud data platform, AWS S3 bucket using Rivery as an ETL tool to inform the client’s regional sales strategy. - Administered daily data governance and validation practices across 30+ data sources using SQL tools through DBeaver to more effectively track inaccuracies and inefficiencies. - Facilitated the use of ETL tools to power a client-facing Tableau dashboard that hosted 10+ kinds of reporting platforms with 100+ marketing data points, enabling the client to lead independent analysis.

Toronto, Ontario, Canada

- Streamlined the monthly website data delivery by automating the cleaning process through Python and Excel and pushing the data through Cyberduck on client’s S3 bucket, reducing analysis time by 50 per cent. - Mobilized data validation and QA by using SQL and data warehouse for regular data checkups to identify irregularities, confirm data integrity, track progress towards digital KPIs and flagging discrepancies. - Implemented high data governance standards by creating 30+ data Adobe alerts to automatically flag irregularities established in daily data thresholds, eliminating three hours of manual labour per day. - Adapted to 10 new metric and segment changes in Adobe data by leading 40+ hours of batch data processing in one week and uploading data to Redshift for data warehouse optimization. - Performed ETL and schema operations through Tableau Prep to push data to Tableau Online enabling dashboards to refresh in real time through Tableau Desktop, thus allowing clients to easily view real-time data and eliminating the need for team members to manually extract data. - Designed and implemented four end-to-end reporting architectures on data warehouse with ETL pipeline configurations using SQL and Rivery with AWS, enabling migration to a cloud environment to increase longevity. - Advanced problem-solving skills by creating a robust architecture that prevents future unintentional changes to the data schema that converted 45 columns of data from 15 databases into a centralized repository of over one million rows of historical data.

Toronto, Ontario, Canada

- Oversaw EDA with regression analysis on R studio and correlation models to inform expansion of measurement beyond web traffic by creating a set of tiered web KPIs to identify other website actions for vehicle sales and better understand customer purchasing decisions.- Utilized various machine learning models with Python to forecast the next year’s vehicle sales through a variety of digital and non-digital revenue streams and presented insights and predictions to client groups.- Exercised data governance skills by refining and categorizing incorrect data through the Adobe classification rule builder to more effectively track and partition data, resulting in 67% more accurate data segmentation. - Created Tableau dashboards to illustrate COVID-19 impacts on BMW USA digital marketing strategy during the pandemic to support clients in comparing data trends week over week and year over year and analyze and monetize peaks and fluctuations accordingly. - Operated Python to wrangle, clean and transform data to create weekly and monthly recurring data reports which illustrated the performance progress of BWM’s 39 vehicle models.

Toronto, Ontario, Canada

- Demonstrated exceptional customer service and communication skills while liaising with up to 40 clientsdaily for electronic repairs, increasing productivity by 5% for the Geek Squad team- Quickly and accurately collected solutions from multiple resources, improving efficiency in repairs by 20%- Pitched new ways of organizing and tracking progress of complex and long-term electronic repair jobs, leading to improved measurement of final results and reducing time consumption of tasks by 30%

Toronto, Canada Area

- Implemented fibre connectivity at five data centres a day to boost work performance by 20% per month- Tested network performance through a work site in two weeks for a month-long project and saved up to$20,000 in overhead costs- Expertly installed network cards in Microsoft’s data centre and increased their network connectivity by 10% in a timely manner

Professional Certificate, Data Analyst

Activities and Societies: Microsoft Azure Fundamentals Professional Certificate IBM Data Analyst Professional Certificate Junior Data.

Diploma, Data Science

Accelerated fast-paced bootcamp course with 400+ hours of class time dedicated to learning big data, data science, machine learning.

Post Graduate Certificate, Wireless Telecommunications

Bachelor Of Engineering, Electrical, Electronic And Communications Engineering Technology/Technician