Michael Shi
Senior Consultant @BMO
Signup · Get unlimited contacts
WORK HISTORY
Senior Consultant @BMO
Toronto, ON, CA
Spearheaded the automation of 30+ SAS and Power BI reporting processes, driving a $120K annual cost savings through increased accuracy and efficiency- Developed end-to-end data pipelines using Python and BigQuery, integrating diverse data sources, including enterprise warehouses, analytical data, and Google CM360/GA4 data- Migrated legacy SAS reports and data to Google Cloud Platform (GCP), leveraging Python and BigQuery for scalable analytics- Conducted exploratory data analysis (EDA) and feature engineering for machine learning models using Python and Jupyter Notebook, leveraging GCP Vertex AI, AWS SageMaker, and on-premise environments- Established a SAS macro library and automated data quality control workflows, improving speed and accuracy in marketing mix modeling- Pioneered the development of an interactive forecasting tool powered by linear regression models, utilizing Microsoft PowerApps and Power Automate to enhance forecasting accuracy and streamline workflows.
EDUCATION
Xi'an Jiaotong University
Bachelor of Science (B.S.), Computer Science
SKILLS
ABOUT MICHAEL SHI
With years of extensive experience and knowledge, I contribute to building efficient, automated reporting processes and scalable data solutions. My work focuses on leveraging Python, BigQuery, and SAS to develop end-to-end data pipelines, integrate diverse data sources, and migrate legacy systems to the Google Cloud Platform. These efforts have driven cost savings and improved accuracy for the organization. My expertise extends to exploratory data analysis and feature engineering for machine learning models, utilizing tools like Jupyter Notebook, GCP Vertex AI, and AWS SageMaker. By streamlining workflows and enhancing data quality, I help enable data-driven decision-making across the enterprise.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.