Summary
Overview
Work History
Education
Skills
Project Experience
Timeline
Generic

Zhiao He

Ottawa,ON

Summary

Data Scientist with a robust academic and professional background in analytics, specializing in machine learning and advanced data analysis. Proven expertise in uncovering complex data patterns using statistical methods and a variety of software languages to drive significant business impact. Proficient in a range of machine learning techniques and data visualization tools, I excel at transforming large datasets into actionable insights. My skills are complemented by a creative approach to problem-solving and a track record of delivering data-driven solutions that enhance business strategies and decision-making.

Overview

5
5
years of professional experience

Work History

Program Manager, BI Reporting & Analyst

N-able
Ottawa, ON
06.2022 - 11.2023
  • Developed and implemented predictive models using machine learning algorithms such as SVM, Logistic Regression, and Decision Trees, which directly enhanced financial forecasting accuracy by 25%, reducing risk and aiding in the allocation of a $3M operational budget.
  • Applied expertise in Python, SQL, and BI tools (Tableau, Power BI) to conduct deep financial data analysis, uncovering trends that shaped product pricing strategies, and led to a 5% profit margin improvement.
  • Utilized AWS and GCP to create scalable data analytics solutions, ensuring the agility of the analytics infrastructure to support rapid business growth and complex data workloads.
  • Directed key initiatives in financial data analysis and risk management, applying advanced statistical and machine learning techniques. Focused on developing robust models for risk assessment and capital adequacy, essential for strategic decision-making in financial contexts.

Data Analyst

Canopy Growth Corporation
Ottawa, ON
03.2019 - 03.2022
  • Acted as a key stakeholder in decision-making processes for Supply Chain Operation and Finance teams by providing ongoing data and reporting capabilities, leveraging tools such as Sage, SAP, and Cognos.
  • Led data analysis initiatives using Python, SQL, and Tableau Prep to identify and interpret data patterns. This analysis directly supported strategic planning, resulting in a 20% increase in supply chain efficiency and a more responsive financial planning structure.
  • Translated complex business requirements into analytical projects, delivering actionable insights and solving challenging operational problems.
  • Facilitated the migration from ERP to Snowflake, employing Amazon Athena and S3, which streamlined data management and enhanced reporting efficiency.
  • Developed and presented comprehensive reports and Tableau Dashboards to VPs and COO, offering a clear view of business status and driving data-informed decisions.

Education

Master of Science - Mathematics And Statistics

University Of Ottawa
Ottawa, ON

Bachelor of Science - Statistics & Economics

Xiamen University
Fujian, China

Skills

Programming Languages:

  • Python (including libraries like pandas, NumPy, SciPy, scikit-learn)
  • R
  • SQL

Machine Learning:

  • Supervised and unsupervised learning
  • Neural networks and deep learning
  • Natural Language Processing (NLP)

Data Analysis and Visualization:

  • Data cleaning and preprocessing
  • Statistical analysis
  • Visualization tools (eg, Tableau, Power BI, Matplotlib, Seaborn)

Big Data Technologies:

  • Apache Hadoop
  • Apache Spark
  • AWS, Azure, Snowflake

Other Technical Skills:

  • Database Management (MySQL, MongoDB)
  • Version Control (Git)

Soft Skills:

  • Creative problem-solving
  • Strong analytical and quantitative skills
  • Effective communication and teamwork

Project Experience

Credit Card Fraud Detection

  • Spearheaded the development of a predictive model to combat credit card fraud, applying sophisticated analytics and machine learning techniques. This resulted in the model successfully identifying fraudulent transactions, which, when deployed, could potentially save millions in fraudulent claims.
  • Conducted meticulous data preprocessing and exploratory analysis, revealing critical predictors of fraud that were instrumental in reducing false positives by 20% and increasing the fraud detection rate.
  • Through careful model selection and tuning of Logistic Regression, Random Forest, and XGBoost algorithms, I achieved precision and recall scores that outperformed industry benchmarks. The enhanced accuracy of these models can lead to a 30% reduction in the cost associated with fraud investigations.

Sentiment Spectrum: Analyzing TripAdvisor Hotel Reviews

  • Engineered a TensorFlow/Keras-based NLP model that classified hotel reviews by sentiment. The model’s high accuracy in categorizing sentiments supports improved customer experience management and could guide strategic marketing initiatives.
  • Addressed class imbalance issues by adjusting class weights and tuning thresholds, particularly enhancing the detection of 'neutral' sentiments. This nuanced understanding of customer feedback is vital for businesses looking to refine their service offerings.
  • Applied EarlyStopping and ReduceLROnPlateau callbacks to optimize model training, which not only prevented overfitting but also streamlined computational resources, illustrating the model’s scalability for wider application across the hospitality industry.

Timeline

Program Manager, BI Reporting & Analyst

N-able
06.2022 - 11.2023

Data Analyst

Canopy Growth Corporation
03.2019 - 03.2022

Master of Science - Mathematics And Statistics

University Of Ottawa

Bachelor of Science - Statistics & Economics

Xiamen University

Similar Profiles

CREATE PROFILE
Zhiao He