data, ms access, excel, visual basic, market research, math

KANRONG YU

*****.******@***.*** 508-***-**** ** Wachusett St, Apt 3, Worcester, MA 01609

OBJECTIVE

Business Intelligence/ Data Analyst; Data Scientist preferably using Python

EDUCATION

Worcester Polytechnic Institute (WPI)

Worcester, MA

Master of Science in Data Science, GPA: 4.0/4.0

Sep 2015 – May 2017

Shanghai University of Finance and Economics (SHUFE)

Shanghai, China

Bachelor of Science in Insurance, GPA: 3.3/4.0

Sep 2008 – Jun 2012

EXPERIENCE

EMC, VMAX Business Analytics and Pricing

Hopkinton, MA

Data Analyst Co-op

Jun 2016 – Present

Implemented Text Analytics through NLTK to pick the high-frequency words in consumer’s problem description and formatted them as features to categorize the problems into according function areas using Random Forest in Python

Established a decision-support model in Excel and then transferred to Tableau to help create proactive alerts by detecting the unusual service request rate spike under each function area, based on an interactive data visualization of the modified standard deviation and exponential weighted moving average

Automated the data cleansing, extraction and combination work by using Python xlrd to greatly save the manual work and improve the working efficiency and accuracy (saving 75% of time spent)

Developed a predictive model of the occurrence of error events by using Logistic Regression in Python scikit-learn and PostgreSQL to do data collection

Ipsos, Digital Intelligence

Shanghai, China

Senior Research Executive & Project Manager

Sep 2013 – Sep 2014

Evaluated consumers’ satisfaction level and review towards brand and products on E-commerce, Online Travel Agent Sites by using big data tools to find the driving factor

Combined the social media findings with online behavior data to evaluate the campaign effectiveness and provide suggestion to the brand future online media investment

Nielsen, Online

Shanghai, China

Analyst

Mar 2012 – Aug 2013

Focused on social media research by compiling, analyzing, and interpreting massive data to measure brand digital campaign's impact on consumers in terms of brand awareness, brand favorability and purchase intention

Worked closely with McKinsey & Co. as NM Incite to provide industry analysis

PROJECTS

Recipe Mobile App Design in Android Studio, WPI

Mar 2016

Normalized relationships, designed and created database in SQLite with data retrieving via Yummly API

Developed an Android App to provide functions like recipe search with filters and add customized recipes

Sudoku Solver Program in Python, WPI

Dec 2015

Coded a class that Reduce the domain of possible values for the empty cells before local search

Designed user-friendly interactive input and output interface

Successfully solved the hardest Sudoku (found online) in 8.3 seconds

Classification of Walmart Consumers’ Shopping Trips in R, WPI

Nov 2015

Preprocessed data by formatting imbalanced data and generalizing more discriminative features

Reduced the dimensionality of data by PCA to improve both accuracy and speed

Compared the performance of 3 models, random forests, boosting and XGBoost in classification

Social Network Analytics in Python, WPI

Sep 2015

Leveraged Twitter API to sample a collection of the topic Trump in Election 2016 in real time

Analyzed 10,000 tweets by trend, word frequency, retweet volume and account followers

SKILLS

Proficient in Python, R, SQL, PostgreSQL, D3.js, Tableau, Cognos, MS Access, Excel, PowerPoint, Visio, Word

Contact this candidate