business analyst

Allen Jin

**** ********* **** #*** • Richardson, TX 75080 • 469-***-**** • *****.*********@*****.***

SAS Advanced Programming Certificate

Excel Spreadsheet Modeling; Marketing Research & Analytics; Database Management; Advanced Excel; SPSS; SAS; SQL;

WEKA; EVIEWS; Forecasting; Social Media; Strategy & Planning

Marketing internship in the CVSC-TNS RESEARCH

7/2013-8/2013

Data management on ctrchina.cn and consumer database built up by using excel

Exported, collected and managed customers data to avoid duplicate and redundancy

Collected the data of customer behavior in the second-and third-tier cities of China, and translated data into graphics

Compiled and launched online questionnaire which got high response rate

Performed SPSS and EXCEL to analyze the data from the online questionnaire

Conduct RFM analysis to segment the customer group and find loyalty customers

Manager assistant in the Postal Savings Bank of China

1/2012-4/2012

Reimbursement claims review, SAP input, forex trading application forms edit and print, checks issued, online banking

management, and Prepared in-depth cause and effect analysis on a variety of complex financial issues

Established and built historical performance results for comparison and evaluation of proposed programs to guide other

departments on program execution decisions

Conducted work with multiple systems, communicated directly with internal and external customers, analyzed and

validated data

Edited and reported information from manager, and coordinated tasks

Conagra marketing analytics competition

9/2013-12/2013

Organized data preprocessing including cleaned row data and retrieved the useful data

Developed survival analysis models using linear and logistic regression with SAS to determine how long the customer

would repurchase our product, which product is most popular among different categories, and decided the best time to make

promotion

Used SAS to develop the predictive model using logit and linear regression to determine which customer would purchase

our product based on past purchasing behavior

Chili’s customer segmentation and brand awareness

2/2013-4/2013

Performed SAS Enterprise Miner to deal with thousands of row data

Built the popular models, like linear regression, logistic, and neural network, compared the confusion matrix of these

models, and picked up the best one as the predictive model

Used SAS Enterprise Miner to build the decision tree model to choose salient attributes to affect customers’ consumption

New Target Customers Research for ReTrak

9/2012-12/2012

Organized the focus group discussion to collect useful information to help us write the questionnaire

Performed SPSS and SAS to analyze the data from the questionnaire

Performed cluster analysis and factor analysis to segment existed customer finding the loyalty group, made regression

model to justify every variables and picked up the salient variables affecting customer behavior, developed discriminant and

logit model with SAS to analyze exist data and compared different models, and chose the best model to predict the

prospective customer behavior

University of Texas at Dallas, Naveen Jindal School of Management

Richardson, TX

Master of Science in Marketing, focus on Marketing Analytics & Research

5/2014

Shanxi University of Finance and Economics

Taiyuan, China

Bachelor of Science in Statistics

7/2012

Excellent Student Leader Awards in Shanxi University of Finance and Economics

Excellent Student Awards in Shanxi University of Finance and Economics

Contact this candidate