Hanwen Olivia Cao
Data Analyst @MaRS Discovery District
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @MaRS Discovery District
Supported large-scale venture analytics and reporting initiatives, tracking outcomes and development metrics across ventures, supporting government funding and accountability reporting for federal stakeholders• Designed and implemented a scalable survey framework, pre-populating surveys with existing venture data and incorporating targeted follow-up campaigns to streamline data collection and improve response rates• Consolidated data from multiple internal and external sources, applying data cleaning, validation, and data layering to resolve discrepancies across sources and ensure reliable metrics for analysis and reporting• Developed reusable routines to generate core topline business metrics across jobs, funding, revenue, and intellectual property, translating integrated data into consistent performance tracking and reporting outputs• Built dashboards by Power BI to visualize data source coverage, providing ongoing visibility into data quality and supporting continuous improvement in reporting• Developed an automated data quality validation framework in Python, reducing manual QA effort by over 50% while improving the reliability of analytical outputs.• Contributed to the design of a Salesforce Data Cloud-based data foundation, supporting data harmonization across sources and enabling a unified view of venture metrics for analytics and reporting
EDUCATION
University of Toronto - Rotman School of Management
Master's degree, Management Analytics
McMaster University
Bachelor's degree, Mathematics and Statistics
York University
IBM Workplace Education Program, Business Analyst
ABOUT HANWEN OLIVIA CAO
Data Scientist with strong experience in massive data analysis, specializing in statistical modeling, SQL-based data processing, and business-facing insights. Proven ability to translate complex analytical outputs into actionable recommendations that support growth, efficiency, and strategic decision-making.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.