Anna Mao Email & Phone Number

Toronto, On, Ca

Toronto, On, Ca

Montreal, Quebec, Canada

Stock price prediction. Assess the impact of private interactions on earnings forecast accuracy using financial reports across various institutional setups, while performing ad hoc data cleaning and analysis with SQL, Python, and PowerPoint, and regularly presenting outcome dashboards to the research team using Tableau.

Global Hub

* South Africa start-up tech company in fundraising Strategy

During my two months in datalit, I completed a business analytics project to help a fast food company "Hungry Jacks" in seasonal burger product launching strategy and I was coached by professionals work at McKinsey, KPMG. - Established in-depth research on fast-food company in Montreal areas and construct market analysis report to compare competitors- Carefully cleaned all the data from cloud database by using intermediate-SQL language- Identified 20 key influenceable factors incorporated in quantitative matrix, conducted comprehensive analysis using redash PostgreSQL database-Developed visual analysis of qualitative and quantitative data with Tableau to help generate reports.-Presented results of analysis and implications by issue trees for seasonal burger strategy to McKinsey consultants.

Montreal, Quebec, Canada

Shanghai, China

I joined as a business analyst in new department at WeWork it's called Shangoffice.Shangoffice("Shanglouhui") is a new department in WeWork with its own commercial platform in O2O form for real estate consulting service and commercial space renting.-Deeply involved in the creation of an office space rental platform by organizing 2000+ property attributes data and building data visualization dashboard using Power BI, concluded trend for determining further deployment strategy-Conducted research for office space pricing strategy for 10 districts in Shanghai by creating competitors heatmap with detailed analysis on office take up rate and pricing percentile-Designed and implemented an automation program using python to extract property attributes data directly from SQL database, which greatly reduced time in preparing clients meeting presentation by 40%

Master Of Management Analytics, Business

Activities and Societies: Club: Rotman Business Analytics Club; Management Consulting Association 1st place NaviGate Case Competition

Bachelor Of Arts - Ba, Statistics&Economics, 3.77/4

Activities and Societies: 2021/2022 DEAN HONOUR LIST, McGill Consulting Association-member, Consulting Preparation Program (CPP)