Qing Chen

Global Supply Analyst + Data Analyst

Tesla Motors•  June 2019 - Present

• Translating business logic into SQL code, building and maintaining Ziplab tools and Tableau dashboards that help Tesla Energy Asset Management team monitor fleet health, measure service efficiency and effectiveness, and automate processes • Collaborating with 50+ suppliers from 10 different countries with a $300M annual budget on Model S/3/X/Y interior parts to assure competitive cost, consistent quality, timely delivery, and responsiveness. • Building and leveraging strong working relationships with product management, design engineering, quality engineering, material planning, production engineering, and project management teams • Analyzing current expenditure per vehicle interior commodity, evaluating supplier core competencies and competitiveness • Doing research on current automotive interior market, technology roadmaps, and identifying supply/demand challenges & opportunities

Data Analyst

Agrow Analytics•  December 2020 - Present

• Collecting satellite data, building SQL query and Tableau dashboard to demonstrate real-time land temperature, humidity and water usage • Utilizing random forest model to help clients decide which is the most suitable crop to grow and to better utilize their farmland resources • Predicting water consumption per plant through various Time series model (Auto Regression, Arima, Sarima, Prophet, XGBoost, Darts)

Data Analyst Intern

Forage•  October 2020 - March 2021

KPMG Data Analytics Consulting Virtual Internship • Explored 20k rows of preliminary data of a medium-sized bike & cycling accessories organization and identified ways to improve the quality of Customer Demographics, Customer Address, and Historical Transactions Data through Python Pandas • Built 3 Tableau dashboards to understand the sales trend as well as the correlation between critical demographic variables (customer segment, customer value, age, product line, etc) • Specified who the client's marketing team should be targeting out of the new 1k+ new customer list as well as the broader market segment to reach out to BCG Strategy Consulting Virtual Internship • Introduced the handset leasing program to drive profit improvements for a local telecom company • Did thorough market research and identified handset leasing industry trend, and analyzed the impact on revenue and profits for the telecom companies operating in those market • Analyzed the data from the client to forecast the impact of leasing handsets on financial performance, such as operating revenue, operating expenses, growth rate, EBITDA, and ARPU • Brainstormed and shortlisted criteria that customers may use to evaluate competing offers, collected data via online surveys with consumers, filled out the evaluation matrix and identified the target segment for this plan. • Developed an executive summary synthesizing all the findings from the project and mitigated the concerns that were raised by Finance and Commercial team