Xingjie Yao

Toronto,ON

Summary

Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.

Overview

year of professional experience

Work History

Data Analysis Intern

Zevnodata

Toronto, ON

03.2024 - Current

Cleansing automotive insurance industry data to ensure accuracy for further analysis
Analyzing healthcare industry data using Excel, employing advanced data analysis techniques and visualization tools for insightful reporting
Filtering and analyzing sales data using SQL to identify key data points for in-depth evaluation
Utilizing Power BI to present complex data analysis findings effectively to stakeholders

Market Research Assistant

Brookstone Capital

China, Shanghai

06.2023 - 09.2023

Contributed to research reports on industrial robotics and low-temperature dairy products, using data models built and updated via Wind Financial Terminal to enhance investment decisions
Utilized advanced statistical techniques to analyze complex datasets, uncovering hidden patterns and trends for strategic decisionmaking.
Enhanced consumer insights by conducting in-depth market research and data analysis.
Led a team to gather over 200 offline visit samples, analyzing findings into actionable insights

Data Analyst Intern

Deloitte Touche Tohmatsu Certified Public Accountants LLP, Beijing Branch

China, Beijing

07.2023 - 08.2023

Organized and validated order data from five e-commerce platforms, ensuring accuracy with merchant back-end data, which supported audit working papers for payment businesses
Utilized R and SQL at Shenzhen Collider Scientific to deliver market research with 95% precision in predictive insights
Performed regular audits on existing databases to maintain high levels of security and compliance with industry standards.
Interacted with clients for technical requests to understand business requirements in different project lifecycle phases.
Developed customized reports, summarizing and presenting data in visually appealing format.

Education

Honours Bachelor of Sciences - Actuarial Science & Statistics (Methods and Practice)

University of Toronto

Toronto, ON

06.2025

The PKU Summer School International Programme

Skills

Programming & Statistical Software: Python, R, SQL, SAS, STATA, SPSS
Data Visualization: Excel data visualization, Tableau, Power BI
Data Analysis: Regression Analysis, Big Data Analytics, Quantitative Analysis

Data Management: Managed and validated large datasets from multiple sources and utilized advanced data processing techniques with R and SQL, Data Cleaning, Data Processing
Business & Market Analysis: Business Analysis, Industry Trend Analysis, Wind Financial Terminal data model building and maintenance
Data Storytelling & Reporting: Data Interpretation, Reporting

Languages

English

Full Professional

Chinese (Mandarin)

Native or Bilingual

Timeline