Business Analyst Supply Chain

Mingcheng Li

570-***-**** ad642s@r.postjobfree.com

EDUCATION

The Pennsylvania State University University Park, PA

Smeal College of Business August 2023

Master of Science in Business Analytics GPA: 3.79

Relevant Courses: Business Data Management, Descriptive Analytics for Business, Data Visualization for Business,

Programming skills for Business Analytics, Data Mining, Predictive Analytics for Business, Supply Chain Management,

Ethical leadership, Prescriptive Analytics.

Skills: Advanced in Microsoft Excel, SQL, Tableau, R, Power BI, Problem solving, Data Analysis, and Communication.

Thomas Jefferson University Philadephia, PA

Kanbar College of Design Engineering and Commerce August 2019

Master of Science in Business Administration GPA: 3.36

Harbin University of Commerce Harbin, China

Bachelor of Science in Finance August 2017

CAPSTONE PROJECTS

Penn State Smeal College of Business University Park, PA

Store Sales - Time Series Forecasting

Business Analyst June 2023 – August 2023

•Built three predictive models in R, Holt-Winters, seasonal Arima, and Auto. Arima, to enhance the company's understanding of predictive capabilities.

•Developed R code to analyze historical sales data for different product families, identifying overall sales trends over time and created reports using Excel and MS PowerBI, including data gathering, processing.

•Communicated effectively with team members to analyze project data and collaborated on presenting findings to non-statistically trained executives at the end of the capstone course.

Boston Housing Multiple Regression Case

Business Analyst January2023 – May 2023

•Evaluated the relationship between house selling price and variables such as size, number of bedrooms, and number of bathrooms by summarizing and plotting data in R and used graphs, infographics and other methods to visualize data.

•Developed and characterized a regression model to predict average selling price based on home characteristics.

•Predicted selling price for a 2500 sq ft, 4-bedroom, 3-bathroom house with a 95% confidence interval for the average and prediction interval for individual home sales.

EXPERIENCE

New Oriental Education & Technology Group Inc Beijing, China

Teacher October 2020 – October 2021

•Conducted daily English reading classes for high school-level students, aiding in their preparation for college entrance exams.

•Created slides and other teaching materials using Microsoft Word and PowerPoint.

Uschinapress.com Philadephia, PA

Journalist October 2019 – June 2020

•Covered daily business news with a focus on Philadelphia's Chinatown, providing in- depth analysis of financial trends and market developments.

•Utilized Microsoft Excel, Word, and PowerPoint to conduct research, analyze data, and create informative reports.

•Conducted interviews with industry experts and stakeholders, ensuring accurate and comprehensive news coverage.

Contact this candidate