Frank (Haochen) Zhang Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

- Engineered a highly efficient data transformation pipeline by connecting SQL Server with Microsoft Bing Map API to effectively convert and update text addresses to geo-spatial data into the server- Saved up to 2 MM in HR benefit spending by developing complex queries to auto-detect new-hired employees’ benefit fraud- Boosted employees’ career potential.

Shanghai City, China

- Provided valuable insights and gave data driven recommendation to clients- Built a python script that automatically collect data from website/apps, prepared and cleaned the data for further analysis- Developed Power BI reports from scratch to monitor key KPIs and enable reporting automation- Weekly meetings with clients to track project progress and.

Shanghai City, China

- Published research report on graduate students’ career path decisions- Performed market research, prepared data collection strategy and designed compensation survey questionnaire to collect quality data- Performed exploratory data analysis (EDA) in Tableau to better visualize the data

Shanghai City, China

- Design data driven solutions and made recommendation to marketing team- Optimized marketing campaigns, improved email open rate by 30% leverage data science techniques- Built Tableau dashboard from scratch to keep track of marketing campaign performance and key KPIs

Master Of Engineering - Meng, Engineering/Industrial Management

Bachelor Of Applied Science - Basc