Post Job Free

Resume

Sign in

Expertise in SAS, R, SQL, ETL process

Location:
Syracuse, NY
Posted:
March 25, 2015

Contact this candidate

Resume:

Cell: ***---***---****

Qiong Wu

***B Remington Ave., Syracuse, NY 13210 E---Mail: acov2d@r.postjobfree.com

August 2013 – Present

EDUCATION

Syracuse University, Syracuse, NY (GPA: 3.96/4.00)

M.S. in Applied Statistics

Relevant Coursework: Advanced Database Management, Statistical Consulting, Statistical Simulation and Nonstandard Data

Analysis, Statistical Methods in Information Science and Technology, Time Series Analysis, Data mining, Data Warehousing.

September 2009 – June 2013

Capital University of Economics and Business, Beijing, China (3.50/4.00)

Bachelor in Economics – International Economics and Trade

Data Mapping Specialist, Amazon.cn, China July 2012 – September 2012

EXPERIENCE

• Screened data and conducted potential competitor analysis

• Performed data cleansing and analysis, using pivot tables, formulas (v---lookup and others), graphs and charts

manipulation.

• Compared two data sets with given comparison guidelines and matched them accordingly. Every match will result in

Amazon’s pricing decision for that particular product.

• Ensured the competitive edge in pricing and products on e--retailing of Amazon

Project Assistant, Salomon Group, China April 2012 – June 2012

• Assisted the instructor in market survey, market segmentation, and decision making with teammates in 8 countries

• Developed metrics to determine inefficiencies in market segmentation using excel modeling

• Bridged the quantitative and business words focused on customer preference to the French headquarter for strategy

drafting

Spring 2014

ACADEMIC PROJECTS

• Design a relational DBMS in MS Visio to organize, retrieve, search and change information for Jumei.com.

B2C Website of Cosmetics Database Management System

• Used SQL server to set up complex queries used by customers, sales executives, database administrators.

• Supported user interface at the database level, generated sales report and order report monthly

Spring 2014

• Build scoring models to predict if new applicants present a good or bad credit risk by customer profile

German Credit Scoring

• Applied variable selection approaches (LASSO, CART). By using classification and regression trees, miss classification

proportion was improved by 5%

• Developed query tools in MS excel by using selected variables and scoring model to identify potential client credit

risk

Spring 2015

• Built a model to classify the forest cover type and deal with a semi-supervised problem under the situation of

Forest Cover Type Prediction - A Kaggle Competition

unbalancing training data set (15120) and testing data set (565892).

• Implementing tentative algorithms in Weka to solve the multi-class prediction problem using various

classifiers(Decision Tree, Naïve Bayes, SVM, k-NN)

• Compared results between different classifiers, tuned parameters to improve models’ prediction accuracy

Spring 2015

• Developed detailed dimensional modeling in a team of five according to sorted business requirements

Netflix Data Warehouse Implementation

• Specialized in conducting, debugging and testing ETL processes for staging area and four data marts in SSIS

• Laid a technical foundation for generating BI report in SSAS, which was evaluated as the best work of seven

• Conducted a poster presentation for an audience of 150 comprising of students, colleagues, and faculty members

Data Processing Skills: SAS, SPSS, R, StatPlus, Tableau Software

TECHNICAL SKILLS

Software: MS Access, MS Visio2013, MS SQL Server2008/2014, Weka



Contact this candidate