Hanwen Cao Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

· Collected and processed over 10 million customer records and Private Passenger Vehicles (PPV) collision claims data from cloud databases using R and SQL, ensuring data quality and integrity for subsequent analysis · Conducted feature selection and engineering using statistical techniques (e.g., correlation analysis), developing a total of 53 relevant features and streamlining them into 10+ key features for predictive modeling· Developed and validated two Generalized Linear Models (GLM) as benchmarks using true conviction and self-report conviction data from 100,000 profiles, providing a baseline for misrepresentation analysis · Identified tweedie distribution through data visualization (ggplot2 in R), enabling the development of GLM that effectively handled zero-inflated claim data, improving prediction accuracy by 20%· Built a logistic regression model with Markov Chain Monte Carlo optimization to predict customer misrepresentation, enabling targeted ordering of Motor Vehicle Records and reducing audit costs by 15% by focusing on high-risk customers’ report · Designed and implemented the final pure premium GLM model, integrating misrepresentation prevalence as a latent variable, achieving accuracy comparable to models using true conviction data, and increasing profit margins by 5%· Collaborated with senior management to translate model insights into fraud detection workflows and optimized pricing strategies, enhancing operational efficiency and risk management

· Conducted market research on emerging technologies, including AI, IoT, and SaaS models, to identify high-potential startups aligned with HP's strategic focus areas · Collected, cleaned, and organized investment data for 300+ startups using online analytical tools (e.g., Crunchbase, Pitchbook) and applied data cleaning methods (e.g., Open Refine) to maintain well-structured datasets in Excel for downstream analysis · Utilized Power Query and visualizations in Power BI to present key business metrics such as revenue trends, key influencers, customer growth, competitor analysis, and industry insights to senior leadership in a clear and intuitive manner, facilitating the recognition of promising companies for strategic investment opportunities · Presented investment recommendations for eight high-potential startups to HP Tech Ventures executives, influencing strategic funding allocations

Master'S Degree, Management Analytics

Bachelor'S Degree, Mathematics And Statistics

· Specialized in Statistics; Minor in Computer Science · Dean's Honor List: 4 consecutive years · Graduated with Distinction · Amassed.

Ibm Workplace Education Program, Business Analyst

• Conducted research on the digital transformation of Scotiabank’s Mortgage workflow. Built persona for their mortgage manager.