Data analyst

JIAHUI (JULIA) JIN

***** ******** **. *******, ** 94539 217-***-**** ac0l0w@r.postjobfree.com

EDUCATION

UNIVERSITY OF ILLINOIS Urbana-Champaign, IL

Master of Science in Technology Management GPA: 3.65/4.0

Concentration in Accountancy

Analytical Related Courses (Data Mining, Applied Statistics, Simulation and Risk Analysis, etc.) GPA: 3.73/4.0

Graduate Assistant for Marketing Management December 2016

GRE: Quantitative 167 Verbal 157 Analytical Writing 3.5

DONGHUA UNIVERSITY Shanghai, China

Bachelor in E-Commerce GPA: 3.63/5.0

Scholarship for Exceptional Studies, for 3 consecutive years June 2015

EXPERIENCE

BILL SMITH AUTO PARTS Urbana, Illinois

Data Analyst Intern June – August 2016

Conducted competitor analysis to optimize their website revenue, such as user experience, listing, and pricing; Sales went up by 63% after the implementation of new design

Recommended product strategy by researching top vehicle sales, top vehicles in car accidents in the U.S.; Used Python and Access to efficiently export and sort over 80,000 data entries

VOLVO CARS CHINA (SHANGHAI) DISTRIBUTION COMPANY Shanghai, China

Business Development Assistant Intern, Customer Service January – June 2015

Analyzed data and prepared 2015 Q1 dealer’s KPI report, displayed to the Customer Service department

Updated daily and monthly budget reports

Managed procedures for Budget Approval, Purchase Order, Payment Request, Internal Use Request and Fixed Asset Request for 4 teams in Customer Service Department; included signature approval, supporting materials auditing, relevant paperwork, and documentation, etc.

Assisted in closing the 2014 budget accounts for Customer Service Department

PRICEWATERHOUSECOOPERS ZHONG TIAN LLP Shanghai, China

Intern, Human Resources October – December 2014

Managed over 10,000 staff records; Summarized HR information and completed HR management report monthly

Assisted in weekly recruitment-related work, including checking acceptance from future employees/interns as well as decline information

Prepared for new employee onboarding process and training, prepared contracts and online personnel files

Processed 40 to 60 new hires and experienced hires combined per week

PROJECT & SKILLS

DIVVY BIKE OPEN SOURCE PROJECT February – April 2017

Led exploratory data analysis to research seasonality, popular routes, user membership and spend pattern to drive marketing recommendations based on 2016 Divvy data; Use R and MySQL to effectively process over 2,000,000 data records

Conduct customer segmentation and provide customized communication strategies

PROSPER LOAN DATA VISUALIZATION December – February 2017

Visualized data to find distribution and relationship in variables using Tableau

Applied exploratory data analysis to prove the patterns found in dashboard using R

Used GIS to visualize the output of analysis from R into Tableau

Skills: Microsoft Office (Excel, Visio, PowerPoint, Microsoft Project), Python, R, SQL, C, SAP, ERP, Tableau

Contact this candidate