Quning (Ning) Chen

A data analyst with reporting skills to tell brand stories contextually

ac4mfx@r.postjobfree.com 872-***-****

EDUCATION

Northwestern University

M.S. in Integrated Marketing Communications (IMC), Marketing Analytics Track, GPA:3.82 l Relevant coursework: Statistics and Marketing Research, Data Management, Analytic Techniques, Machine Learning for IMC, Consumer Insight, Strategic Planning in an E-commerce Environment, Digital Analytics Beijing Foreign Studies University

Bachelor of Law in Diplomacy & Bachelor of Arts in English Language Arts, GPA:3.81 l Relevant Coursework: Statistics, Consumer Behavior, International Finance SKILLS

l Data Analytics: Advanced Excel, R, SAS (Certified Base Programmer), SPSS, SQL, IBM Watson l Visualization & Presentation: Tableau, PowerPoint, Prezi, Photoshop, Final Cut Pro, Flash, Corel Video Studio WORK EXPERIENCE

Data Analyst, UnitedHealth Group Optum Division, UT, US June 2017-Aug 2017 l Predicted probability of attrition for two major markets by building machine learning models including Logistic Regression, Decision Tree, Random Forest and Boosted Tree in R and SPSS with 80% out of sample accuracy l Presented management with an attrition detection plan capable of saving 60% of revenue loss in a typical fiscal year l Identified most profitable and potential regions by mapping revenue and demographic data in Tableau l Evaluated business impact of Net Promoter Score (NPS) on customer behavior by merging and analyzing NPS survey data, transactional data and revenue data in R and Excel PR Campaign Analyst, Ogilvy Public Relations, Beijing, China Aug 2015-Dec 2015 l Measured effectiveness of UPS’s China Expansion Strategy Press Conference and Giant Solver Session Event by developing pre-, mid- and post-event reports on social media KPIs such as increase in number of followers and reposts l Contacted vendors to determine appropriate media coverage data sources; maintained UPS Asia Pacific News Coverage Dashboard by analyzing volume change, key topic trends and sentiment in Excel Marketing Analyst, Raleigh China, Shanghai, China Jan 2015-Feb 2015 l Analyzed 55 survey responses in Excel to measure effectiveness of events; created summary and managerial implications l Designed communication plan for Raleigh on WeChat public platform by analyzing background data and identifying most engaging content and optimal posting time in Excel; increased WeChat followers by over 500 in two months GRADUATE SCHOOL MARKETING PROJECTS

Media Automation Project for Shopping Mall R, SQL, IBM Watson May 2017-June 2017 l Identified social media trend and sentiment by performing text analysis using IBM Watson l Merged mobile app data and in-store transaction data with 1 million data points; identified impact of app activities on customer purchase behavior by building Linear Regression Model and Decision Tree using R and SQL Machine Learning Predictive Models R May 2017-June 2017 l Predicted purchase amount on books by building two-step model, ridge and lasso regression, random forest and boosted tree using R, ranking 20% in a Kaggle competition. l Predicted voting behavior with 95,373 TV program viewing time data points, reaching 78% out of sample accuracy using under/over sample technique, random forest and boosted tree in R. Segmentation and Customer Lifetime Value Analysis for Peapod SAS, SPSS, Excel Apr 2017-June 2017 l Built segmentation by conducting cluster analysis on customer demographic and transaction data using SAS and SPSS l Provided marketing communications suggestions with quantified financial impacts for target segments