Data Microsoft Office

WENWEN (WENDY) YANG

******@****.**.*** ● 513-***-**** ● 4579 Blue Jay Way, Mason, Ohio 45040

QUALIFICATION SUMMARY

Highly self-motivated with excellent record in data manipulation (big data loads and extracts), data mining (regression, clustering, and classification modeling, etc.), and statistical research (Hypothesis test, time series, and forecasting, etc.).

• Three years hands-on programing experience in SQL and R, two years hands-on programing experience in SAS

• High proficiency in data visualization software (Tableau) and office productivity software (MS Word, Excel, Access and PowerPoint)

EDUCATION

University of Cincinnati, Lindner College of Business, Cincinnati, OH December 2016 Master of Science, Business Analytics (GPA: 4.0/4.0)

• Relevant Coursework: Statistical Methods/Modeling, Probability Modeling, Data Mining, Simulation Modeling, Optimization Models/Methods, Data Visualization, Forecasting/Time Series Methods University of Cincinnati, Cincinnati, OH August 2015 Master of Science, Environmental Engineering (GPA: 3.8/4.0) Beijing University of Science and Technology, Beijing, China Bachelor of Science, Environmental Engineering (TOP 6/120, GPA: 3.7/4.0) July 2007 ACADEMIC PROJECTS

P&G Stock Price Forecast using SAS and R May 2016 – December 2016

• Performed time series analysis using the historical stock price data. Conducted ARIMA modeling in SAS (PROC ARIMA) and R (arima, respectively

• Applied the best ARIMA model chosen from the time series analysis to forecast the future 25 observations in SAS and R. Then compared the results with the actual stock prices. This project provided a detailed demonstration about how to perform time series forecasting using both SAS and R. United Way 211 Call Center Data Analysis January 2016 – April 2016

• Led a team of four members to analyze the call center data, including data cleaning, data manipulation and data mining using SAS and SQL

• Cleaned the four years’ data, grouped them using SQL into different categories, and then calculated the statistics in each group; Analyzed the caller profile and created ad-hoc reports in Tableau to answer business questions, which helped this call center better understand the callers and thus potentially improve their services in the future Heart Disease Prediction Analysis February 2016 – April 2016

• Cleaned data, and then performed exploratory data analysis using SAS and R to better understand the basic information of the dataset

• split the dataset into two subsets and built logistic regression model, linear discriminant model and decision tree model for both subsets to identify opportunities in similar subsets with different characteristics and then to find the best model which can be used to predict the presence of heart disease

• Built logistic regression model and decision tree model in SAS Enterprise Miner to further validate the results CERTIFICATION

SAS Certified Base Programmer for SAS 9 (Certificate No: BP063983v9) WORK EXPERIENCE

Pegasus Technical Services, Inc. (Pegasus), Cincinnati, OH January 2011-May 2015 Scientist (Work Assignment Leader) to U.S. EPA

• Collected experimental data, built several models and then conducted model verification

• Performed data analysis using SigmaPlot, R and Microsoft Office Excel (Solver)

• Wrote QA plans, health & safety plans, monthly reports, and published papers at national conferences UC, Department of Environmental Engineering, Cincinnati, OH September 2010 – December 2010 Graduate Assistant

• Built and monitored experiments, collected data to make sure the experiments went well

• Analyzed collected data using Excel and then drafted reports and also conducted modeling and model validation

Contact this candidate