Yaoguang Zhang https://www.linkedin.com/in/yaoguangzhang

APT1002, 100 Wells Street • Hartford, CT 06103 • 313-***-**** • acwae4@r.postjobfree.com Professional Summary

Over 3 years of experience in various areas including data analyst, human resource consultant, data mining, data modeling, reporting in highly quantitative environments in banking, energy industry, real estate. Expertise in using analytical and visualization tools such as SAS, SQL, advanced MS Excel, Tableau, R, Python, JMP, VBA.

Education

University of Connecticut, Business School 05/2016 M.S, Business Analytics and Project Management GPA:3.78/4.0

• Courses: Data Science with Python / Data Analytics using R/ Data Mining & Business Intelligence

/Predictive Modeling/ Process Modeling/Decision Modeling / Adaptive Business Intelligence/ Peking University, History Department 07/2011

M.A. Ancient Chinese History GPA: 3.76/4.0

Jilin University, Business School 07/2008

B.A., Management GPA: 3.56/4.0

Technical Skills

SPSS (6Years), SAS (6Years), VBA (6Years), JMP (3Years), SQL (3Years), R (2Years), Python(2Years), Tableau (2Years), MS Project (4Years), MS Office (10Years+) Certifications

Certified Base Programmer for SAS 9, Certified Adv Programmer for SAS 9 Experience

Research Assistant, University of Connecticut School of Business, Hartford, CT 09/16-12/2015

• Priceline.com: Email Marketing Strategy Optimization (SPSS, SAS, R, Tableau)

• Extracted and merge the data from the 5 distinct datasets and create a new dataset to create a model, which predicts the likelihood of a person to book with Priceline.com, and whether a customer is likely to engage with an email sent from Priceline.com

• Built customer segments and designed segment specific email content Senior Consultant, China Stone Management Consulting Group Beijing, China 04/2014-08/2014

• State Grid Corporation of China: The Model of Full-Covered Labor Cost Management Design. (SPSS, SAS, Tableau)

• Shanxi Xiehe Property Group: Qualification Management System and Competence Model Design. Consultant, China Stone Management Consulting Group Beijing, China 07/2011-03/2014

• State Grid Corporation of China: The Model of the Demand of Talent Resource Design (SPSS, SAS).

• Fengtai Comprehensive Investment Company: The System of Incentive and Salary Design (SAS, SQL, Tableau, VBA).

Academic Projects

Analyzing the Flights Departed from Houston in 2011 with R 01/2016-05/2016

• Conducted a comprehensive analysis on the delay situation of the fights departed from Huston

• Figured out the variables which has the most significant impact on the time of and provide suggestions for airport and airline

Decision Support System for Vera Film Products with VBA 09/2015-12/2015

• Designed an Excel user interface to reduce the amount of time operators and inspectors spent on reporting test and measurement results, which was from sampling

• Created an Excel VBA program to display the quality control charts helping the company to monitor and forecast quality issues

Main Honors & Awards

• “Top Consultant” China Stone Management Consulting Group (2013)

• 1st Prize in “Modeling Design for Jiangsu Electric Power Company’s Prospective HR Demand” by Management Consulting Committee of China Enterprise Confederation (2013)

Contact this candidate