Jiawei Sun
Toronto,ON
Summary
- Proficient in multiple programming languages and data analysis tools such as R, SQL, Python, Excel, Tableau - Skilled in various analytical methods, including descriptive analysis, hypothesis testing, regression analysis, and ANOVA - Strong sensitivity to data and logical thinking, with excellent abilities in information integration and analysis Strengths: - Experience in consulting, providing a deep understanding of business operations, and integrating it with data analysis skills - Strong communication, teamwork, and self-learning abilities, with the capacity to collaborate with colleagues across departments and deliver effective solutions
Overview
1
1
year of professional experience
Work History
Intern
Shanghai Credit Information Co., Ltd., Technology Division
Shanghai
05.2024 - 08.2024
- - Tree Table Creation and Data Import: Enriched public data dimensions and improved data structure by creating tree tables and successfully importing large datasets in SQL, including mapping tables for high-tech service and manufacturing industries and strategic emerging industry classification
- - Model Optimization: Enhanced data accuracy by optimizing industry mappings for high-tech and emerging industries, adjusting existing three-level industry mapping to four-level industry mapping, reducing errors by 43% and improving data querying and analysis efficiency
- -Designed multi-dimensional evaluation models including 100+ indicators for innovative technology companies . Determined weightings using industry standards and data analysis methods to optimize scoring formulas. Created SQL structures for data retrieval and computation.
Intern, Strategy Consulting
KPMG Advisory (China) Co., Ltd.
Shanghai
06.2023 - 08.2023
- - Project Work: Contributed to a strategic study for the e-commerce transition of a leading Japanese daily-use company by conducting company analysis, market research, industry studies, and final strategy formulation
- - Client Interviews: Supported organizing brand expert and internal interviews, including preparing materials, scheduling, and drafting meeting minutes
- - Financial Analysis: Analyzed company financial statements, gathered data, and assisted in financial forecasts post-transition
- - Market & Industry Analysis: Researched the operational methods of different e-commerce platforms and utilized visualization models (e.g., winning model) to score brand performance; conducted benchmarking on similar industry transformation cases
- - Data Visualization: Presented findings using Excel and Tableau; delivered10+ PPT reports
Education
Bachelor of Science - Applied Statistics Specialist, Mathematics Minor
University of Toronto
06.2026
Skills
- Languages:
- - English (IELTS75), Mandarin (native)
- Technical Skills:
- - Proficient in Excel (visualization, pivot tables, VBA) and Tableau for data visualization
- - Skilled in R and Python programming languages
- - Experienced in MySQL for data retrieval, updates, and analysis, including advanced operations such as grouping, subqueries, and table joins
Timeline
Intern
Shanghai Credit Information Co., Ltd., Technology Division
05.2024 - 08.2024
Intern, Strategy Consulting
KPMG Advisory (China) Co., Ltd.
06.2023 - 08.2023
Bachelor of Science - Applied Statistics Specialist, Mathematics Minor
University of Toronto