Keqing Wang

2+ years of experience in data analytics and data science with strong analytical and quantitative skills in solving business problems. Experienced in collaborating with cross-functional stakeholders to analyze large, complex datasets from multiple sources, build storytelling dashboards, automate processes, and develop reports and presentations that deliver key performance insights. Advanced knowledge in data analysis, data visualization and process optimization tools: SQL, Python, Tableau, SAS, and Excel.

Result-driven and detail-oriented team player with excellent multiple-tasking, problem-solving, and written and communication skills.

Data Scientist Intern - IGM Financial Inc. - Toronto, Canada

(2026-01 - 2026-06)

• Developed actionable recommendations for financial advisors on targeting optimal engagement strategies to support client outcomes and maximize business value, resulting in a projected 35% revenue lift, enhancing workflow automation and business decision analytic efficiency
• Utilized SQL Server and BigQuery to integrate multiple databases containing over 10 million records, automating the data pipeline and establishing a unified data foundation for advanced analytics and reporting, reducing data retrieval time by 90%
• Analyzed 35K+ family groups using probabilistic modeling to determine channel attribution ROI through AI engineering techniques. Deliver analytical insight on optimal engagement approaches and frequency across seasonal, demographic, and geographic segments, improving customer retention rate by 30%
• Engineered XGBoost and Linear Regression models that quantified activity trends and identified the top contributing channels through feature importance analysis to drive incremental net flows, achieving an overall accuracy of 96%
• Leveraged EconML, placebo tests, and cumulative gain curves through 180K+ family group records to identify high-engagement client segments and channel preferences, supporting strategic decisions by distribution and data science teams
• Leveraged GitHub and Slack to streamline Agile team collaboration, task tracking, and documentation, reducing document processing delays and improving on-time project delivery

Data Scientist Intern - Industrial and Commercial Bank of China (ICBC) - Beijing, China

(2024-05 - 2024-07)

• Designed and deployed automated ETL pipelines in MySQL and Python using 500K+ transactions, delivering Tableau dashboards that monitored VaR and loan default rates, accelerating risk communication across departments and improving decision timelines
• Built a Logistic Regression risk-scoring model to predict loan defaults, increasing accuracy by 6% and strengthening loan approvals
• Partnered with risk management, compliance, and data science teams to ensure data integrity and refine risk assessment frameworks, streamlining communication workflows and supporting regulatory compliance
• Integrated multiple data sources into unified pipelines and automated Excel macros, cutting manual reporting time from 7 hours to 1 and boosting management's access to timely, high-quality data by 30%

Investment Analyst Intern - CITIC Securities Co., Ltd. - Beijing, China

(2023-05 - 2023-07)

• Conducted exploratory analysis of 30K+ datapoints across 35 industry peers using PySpark and Wind databases, identifying operational risks and investment opportunities to inform coverage and capital commitments
• Engineered datasets capturing upstream and downstream supply chain linkages to assess market exposure and integrated findings into investment risk evaluation frameworks, strengthening industry-level investment analysis
• Delivered insights on firm-level risks and opportunities that supported investment decisions, aligning data-driven recommendations with broader risk management strategy

Wealth Management Operations Analyst Intern - Bank of Montreal (BMO) - Toronto, Canada

(2022-05 - 2022-09)

• Analyzed client account and product performance data using Excel and Power BI to provide insights that improved investment recommendations and portfolio oversight, increasing reporting accuracy by 30% for senior advisors
• Processed and validated 450+ onboarding documentation, ensuring data completeness and compliance with internal controls
• Automated analysis of transaction flows and cross-border fund movements through Excel macros, generating compliance documentation that strengthened anti-money laundering (AML) reporting and supported internal risk reviews

Master of Management Analytics - Management Analytics - Rotman School of Management, University of Toronto (2026)

Bachelor of Commerce - Finance and Economics - University of Toronto (2025)