Sales Project

Xiaoran Wang

th

*** **** *** ******, *** York, NY 10025, 917-***-**** ******@********.***

EDUCATION

Columbia University, Graduate School of Art and Science New York, NY

MA in Statistics, GPA 3.9+/4.0 12/2014

Sun Yat-Sen University, School of Mathematics & Computational Science Guangzhou, Guangdong

BS in Statistics, GPA 3.8+/4.0 06/2013

Sun Yat-Sen University, Lingnan College 09/2011 – 01/2013

Minor in Public Finance, GPA 3.5/4.0

HONORS

Sun Yat-sen University, Scholarship of University Outstanding Student, 2010 - 2012

•

Sun Yat-sen University, School of Mathematics & Computational Science, Excellent Student Leader, September 2011

•

Sun Yat-sen University, Excellent League Member, September 2011

•

TECHNICAL SKILLS AND CERTIFICATION

Programing language: R, SAS, SPSS, Python, Latex, SQL

•

Computer: Microsoft Word, Excel, PowerPoint, PS

•

SAS9 Base Certificate, SAS9 Advance Certificate, FRM Level1 Certificate

•

RESEARCH & PROJECTS

Credit Default Prediction New York, NY

Group work 11/2014 – 12/2014

Analyzed customer data and did research to get information about their credit records

•

Used K-means, Logistic Regression, GEV Logistic Regression, Random Forest, Random Forest with Cost-Sensitive

•

Training to build models, used True-Positive, False-Positive, AUC, Overall Accuracy to compare results from different

methods, responsible for Logistic Regression, GEV Logistic Regression and generating final report

Marketing Research Project with Dental Insurance Company New York, NY

Group work 04/2014 – 05/2014

Learned the background of dental insurance regulations, products and company’s existing customers

•

• Designed questionnaires and conducted focus groups to learn more deeper into customers’ opinions

• Analyzed data and extracted information of customers in each level and formed analysis report and customer personas

Data Analysis Project on hepatic injury data using R New York, NY

Independence work 11/2013

Preprocessed data, eliminated high-correlation, inserted values for missing observations

•

Applied multiple statistical methods, like Multinomial Logistic Regression, LDA, Partial Least Squares Analysis,

•

Penalized Model, Nonlinear Discriminant Analysis, Neural Network, SVM, KNN, Naïve Bayes to analyze data

Compared models to find the optimal one, found important predictors using the optimal model

•

Others: Research on Cultural Influence on Social Infusion of People Living in Guangzhou, Data Analysis Projects on

Walmart sales data, Multi-Assets Portfolio Construction Project

EXPERIENCE

ISERP Consulting Group, Columbia University New York, NY

Consultant, provided statistical advisory for a market research project, which goal is to analyze customer's decision process.

Responsible for finding feasible analysis methods, coding and results interpretation. Carried out two-way anova with repeated

measures, two sample McNemar's test, mixed effect logistic model etc. 10/2014 – Now

Business & Economics Library (Thomas J. Watson Library), Columbia University New York, NY

Business Analyst, helped analyzing 2009-2014 periodicals & magazines & books subscription data to make subscription budget of

year 201*-****-**/014 – 07/2014

American Express Asia Network Consulting Company-Guangzhou Branch Guangzhou, Guangdong

Executive Associate, grasped sales data from system to generate daily & weekly sales report for cooperate banks in southern part

of China for further analysis, helped to analyze sales trend in each segment, contributed in sales promotion, kept daily office

administrative operation 11/2012 – 04/2013

Contact this candidate