Sign in

Data Analyst, MBA, SQL, R, SAS

Columbus, Ohio, United States
August 29, 2018

Contact this candidate



*** ***** **** ***, ************, OH 43147 517-***-****


* *****’ programming skills in SAS (Certified Base Programmer), R, SQL,EXCEL,Python. Work Experience

Graduate Assistant of Marketing Department, Bowling Green State University 2016-2018

• Built predictive modeling to predict business behavior based on historical data, search for most influential demographic factors to customer decision. Consulting intern in Quzi Health & Weight Loss, LLC in Maumee,OH 2015- 2016

• Responsible for data cleaning, analysis and industry research Data Analyst Tianjin Tianhai Pharmaceuticals Co., Ltd. 2012- 2013

• Responsible for analyzing market and data to identify new business opportunities and routinely participated in the purchasing process.

• Worked for out-put and in-put management of warehouse by using SAP ERP system.

• Built classification models (Logistic Regression, Random Forest) to prevent fake reports from small distributors, and conducted Clustering Analysis for customer segmentation. Research Experience

Applied Statistics and Operation Rearch

• Data mining project:Analyzed and predicted the quality ranking of wines from chemical properties such as acidity ph value of them by using following supervised learning methods: logistic regression, CART decision tree, K nearest neighbor algorithm, and neural network.Performed model selection by cross-validation among different models .

• Multiple linear regression project: used Minitab, R, and SAS to analyze the relevant between potential predicted response and annual salaries of NFL’s players. And fitted them in a multiple linear regression model to predict the salaries of next calendar year.

• Database building and functionality project: created a database and managed the data for a digital music streaming application by using Microsoft SQL server and Visio. The database meets the functionality of the application in real world.

• Time series analysis project: weather forecasting with ARIMA models and Exponential Smoothing method using last five years’ data. Incorporated seasonal component into ARIMA model based on ACF / PACF plot and auto-forecasting algorithm.


• Supply chain management and logistics project: analyzed the problems of the warehouse layout of a pharmaceutical company, gave recommendation to prefect the utilization of the ERP system and increased shipping efficiency.

• Corn commodity project: fundamentally and technically analyzed and forecasted the corn commodity cash price by using time series model and simple linear regression, suggested sourcing strategy, compared the forecast and actual price then made a reflection report. Education

Bowling Green State University 2016-2018

• Master of Science in Applied Statistics and Operation Research Bowling Green State University 2013-2015

• Master of Business Admiration Specialized in Supply Chain Management Nankai University,Tianjin,China 2008-2015

• Bachelor of Economics and Finance

Contact this candidate