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
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.
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
Similar Profiles
Charlotte LuCharlotte Lu
Intern at Bilibili -Shanghai Huandian Information TechnologyIntern at Bilibili -Shanghai Huandian Information Technology
Ma JiyingMa Jiying
Senior Operations Manager (Grade: M3) at Shanghai Shizhuang Information Technology Co., LtdSenior Operations Manager (Grade: M3) at Shanghai Shizhuang Information Technology Co., Ltd
Loann MENIERLoann MENIER
Intern (Marketing Department) at Shanghai Insight Information Technology Co. Ltd.Intern (Marketing Department) at Shanghai Insight Information Technology Co. Ltd.