Data Analyst

Yuechuan(Sauron) Wang

216-***-****, *********@*****.***, www.linkedin.com/in/yuechuan-wang

EDUCATION

Master of Science in Management, Operations Research & Supply Chain 05/2019 Weatherhead School of Management, Case Western Reserve University, Cleveland, OH

Relevant courses: Optimization Modeling, Machine Learning in R, Advanced Marketing, ERP, Probability and Statistics in R, Stochastic Models, Business Analysis

Certificate on Business Analytics

Bachelor of Engineering and Bachelor of Science 06/2017 Beihang University, Beijing, China

Major: Aircraft Design and Engineering and Applied Mathematics

Relevant Courses: Linear Algebra, Calculus, Mathematical Modeling

Study Abroad, University of Illinois at Urbana-Champaign, IL, Summer 2013 PROFESSIONAL EXPERIENCE

Cleveland Clinic-South Pointe Hospital, Cleveland, OH 06/2018 - 09/2018 Operations Intern in Continues Development Department

Built the Process Map of Nursing Department to improve the efficiency of daily work

Built macros in VBA to analyze the callback data in hospital and generated automatically a report to manager

Analyzed daily data from patients by VBA and show a trend of days/times/diagnoses to doctor in EXCEL Invacare Corporation, Cleveland, OH 09/2018 - 12/2018 Student Consultant for Six Sigma Project

Collected data on remake orders and built the database

Utilized SQL to categorize data and performed comprehensive EDA in Python

Analyzed data by regression models (linear and logistic) in Python to identify factors that lead to the remake order KEY ACADEMIC PROJECTS

Store Item Demand Forecasting, Cleveland, OH 01/2019 - 04/2019 Predicted demands of different items for class project

Collected and cleaned the store-item data in R in the past 5 years for 50 different items in 10 different stores

Run time-series models including Exponential Smoothing, Holt Winters, Arima model and Prophet model in R to forecast the future demand

Used slicing windows as the method of the Backtesting to do the cross-validation in these time-series models

Predicted the next three months demand based on the best model result (Prophet model) House Price Analysis, Cleveland, OH 09/2018 – 11/2018 Analyzed factors that will influence the house price in Cleveland Heights

Collected and arranged data including all information on the house in Cleveland Heights (price, location, size, year, etc)

Performed comprehensive data exploration analysis and conducted data visualization in Python

Developed different models including linear regression, lasso regression and XGBoost model to determine the factors which may influence the price of houses

Used k-fold cross-validation to decide the best model Shortest Path Analysis, Cleveland, OH 02/2018 - 04/2018 Calculated the shortest path from warehouses to retails locations

Built a data base using PANDAS in Python based on the location information of all warehouses and retails

Built a matching system in Python based on Bellman Ford algorithm to find the shortest path from any warehouse to any retail location

ADDITIONAL

Relevant skills: SQL, R, Python, Excel, SPSS, Tableau and VBA

Language: Mandarin (native) and English (fluent)

The Green Belt Certification in Six Sigma, 2018

Contact this candidate