Yuan Gao
Summary
Energetic and cheerful personality with strong teamwork and communication skills. Able to handle pressure and adapt to an English-speaking work environment.
Overview
2
2
years of professional experience
Work History
Data Analyst Intern
Shandong Energy Group
03.2022 - 06.2022
- Streamlined business processes from raw material intake, storage, processing, to finished goods sales and distribution.
- Conducted business data analysis using internal software and Excel, improving resource allocation efficiency.
- Utilized BI software to create visual reports for decision-making support.
- Monitored daily business data such as mineral transportation volumes, transit warehouse inventory, and transportation routes. Addressed anomalies in coordination with relevant departments.
- Compiled reports based on data monitoring, identifying root causes of issues and suggesting improvements.
Business Analyst Intern
Inspur Group
06.2021 - 08.2021
- Extracted sales-related data from the data warehouse using SQL queries.
- Developed a market sales data system based on sales volume, customer groups, sales regions, and profit margins.
- Analyzed and optimized sales data using ARIMA models and A/B testing, contributing to a 4% increase in departmental profits.
- Created data visualization reports using Python and Tableau, and provided optimization recommendations to the leadership team.
Project Team Intern
PreIPO Capital Private Equity Funds
08.2020 - 09.2020
- Conducted on-site financial research and participated in the Kunshan Tongri Pre-IPO project, verifying the company's audit reports and financial documents from the past five years.
- Researched equity investment and the operations of private equity firms, gathering industry data from Wind and Yahoo Finance.
- Assisted in creating the due diligence report for Hunan Derong Medical Group, supporting departmental staff in data retrieval, and participated in meetings with visiting government and business teams.
Education
Master of Arts - Statistics
Columbia University in The City of New York
New York, NY02.2024
Bachelor of Science - Statistics
University of Minnesota - Twin Cities
Minneapolis, MN05.2021
Bachelor of Science - Statistics
Shandong University of Finance And Economics
Jinan, Shandong05.2020
Skills
SQL
Timeline
Data Analyst Intern
Shandong Energy Group
03.2022 - 06.2022
Business Analyst Intern
Inspur Group
06.2021 - 08.2021
Project Team Intern
PreIPO Capital Private Equity Funds
08.2020 - 09.2020
Master of Arts - Statistics
Columbia University in The City of New York
Bachelor of Science - Statistics
University of Minnesota - Twin Cities
Bachelor of Science - Statistics
Shandong University of Finance And Economics
Similar Profiles
Qiyue JiaoQiyue Jiao
Intern at Shandong Bairen Energy Group Co.Intern at Shandong Bairen Energy Group Co.
Yibei WangYibei Wang
Internship Coordinator at Shandong Lebang Tax Service Group Co.Internship Coordinator at Shandong Lebang Tax Service Group Co.
Yu ShiYu Shi
Human Resource Commissioner at Shandong Weigao Group Medical Polymer CompanyHuman Resource Commissioner at Shandong Weigao Group Medical Polymer Company
Jetta OskirkoJetta Oskirko
Data Research/Data Analyst Intern at Metrowest Economic Research CenterData Research/Data Analyst Intern at Metrowest Economic Research Center
Tommy VanTommy Van
Business Analyst/Data Analyst Intern at Hillsdale Properties CorporationBusiness Analyst/Data Analyst Intern at Hillsdale Properties Corporation