Yiming Zhang
Los Angeles
Summary
- Data analyst with 6+ months of experience at Fortune 500 companies, skilled in Python/SQL/Tableau and supply chain optimization
- Delivered actionable insights through analysis of 30,000+ Amazon orders and 10,000+ employee compensation records
- Fluent bilingual communicator with proven cross-functional collaboration experience
Overview
1
1
year of professional experience
Work History
Business Analyst Intern
Accenture
05.2023 - 08.2023
- Spearheaded market entry strategy for Mengniu Dairy's new liquor division, analyzing $2.3B domestic baijiu market to identify 3 core product positioning opportunities.
- Developed brand architecture framework including pricing strategy, distribution channels, and risk mitigation plans, projected to capture 5% market share within 18 months.
- Designed sales force training program adopted across 200+ retail partners, incorporating CRM best practices and KPI tracking systems.
- Provided feasibility guidance for the operation and sales of new liquor products, including market channel expansion strategies, sales team formation guidance, risk and cost control measures, and financing methods.
Data Analyst Intern
Amazon
08.2023 - 11.2023
- Built Python ETL pipelines to analyze 30,000+ customer orders, identifying key patterns in repurchase rates (+18% YoY), product category preferences, and delivery time distributions.
- Conducted SQL-driven compensation analysis for 10,000+ employees, developing salary benchmarking models that reduced payroll discrepancies by 15%.
- Optimized U.S. supply chain operations across 30 states using Tableau visualization, decreasing average transportation costs by 12% through route optimization.
- Developed machine learning models to predict delivery times with 92% accuracy.
Education
Bachelor of Science - Applied Mathematics
University of California, Davis
Davis, CA06-2024
Master of Science - Applied Data Science
University of Southern California
Los Angeles, CA12-2026
Skills
- Python programming (Pandas, NumPy)
- Data cleaning
- Excel functions
- Tableau software
WORK HISTORY
New Channel International Education | Qingdao, China
Academic Tutor | Jun 2022 - Present
- Delivered 1:1 SAT/TOEFL tutoring with 92% student satisfaction rate, helping 15+ students achieve 1450+ SAT scores
- Created data-driven progress tracking system that improved average test scores by 22% across 50 students
LEADERSHIP
UC Davis Acapella Club | Vice President | Sep 2022 - Jun 2023
- Managed 40+ members and $15K annual budget, coordinating 12+ performances including international student festivals
- Introduced digital collaboration tools that increased member engagement by 35%
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Data Analyst Intern
Amazon
08.2023 - 11.2023
Business Analyst Intern
Accenture
05.2023 - 08.2023
Bachelor of Science - Applied Mathematics
University of California, Davis
Master of Science - Applied Data Science
University of Southern California
Similar Profiles
Mitesh Rao APPADOOMitesh Rao APPADOO
Category Manager - Technology (UK, IE and Africa) at AccentureCategory Manager - Technology (UK, IE and Africa) at Accenture
John Jethro E. GanzonJohn Jethro E. Ganzon
Cloud Infrastructure Team Lead at AccentureCloud Infrastructure Team Lead at Accenture
Prerana JadhavPrerana Jadhav
Software Development Senior Analyst at AccentureSoftware Development Senior Analyst at Accenture
Ritika RaoRitika Rao
Media and Graphic Design Analyst at AccentureMedia and Graphic Design Analyst at Accenture
Ava GarciaAva Garcia
Host/Server at Perfect Pear BistroHost/Server at Perfect Pear Bistro