Data analyst

SHUHONG CAO

*** * ******* **. *** ***, Madison, WI 53703 H: 608-***-**** **********@*****.***

Summary

Economic analyst specializing in corporate and government finance, data analysis and trend forecasting

Education

University of Wisconsin-Madison Madison, WI

Master of Science in Economics with an emphasis on Econometrics Expected Graduation: May 2019

GPA: 3.39 Relevant Courses: Advanced Econometrics, Machine Learning, Data Analysis

East China University of Political Science and Law Shanghai, China

Bachelor of Art in International Economics and Trade May 2017

GPA: 3.39 Relevant Courses: International Economics, Public Finance, Econometrics

Recent Project

Beer Consumption Report (Report & Code) Fall 2018

Designed a promotion strategy for the largest beer film based on Dominick’s dataset in R

Picked out market-influencing factors using hierarchical clustering and decision tree algorithm

Predicted effects of the strategy by random forest algorithm

How does income affect fertility rate (Reporthttps://docs.google.com/document/d/1WGHbj8DFX_v0mEs0fAKo6l79ZcfIpVZ4NyquI8Q8Ibc/edit & Code) Fall 2018

A data mining analysis report completed in Python

Plotted graphs to visualize numeric relationship of fertility rate in different groups

Set up regression models to interpret data

Experience

Hearst Media & Advertising Ltd (ELLE magazine) Shanghai City, Shanghai

Intern April 2017 to July 2017

Wrote advertisements for corporative brands and edited posts of official WeChat and Weblog page (Chinese social media) of ELLE

Made plans and slides for brand promotion activity

Designed storyboards of commercials and assisted to make commercials

Shanghai Yihaodian E-commerce Ltd Shanghai City, Shanghai

Intern Nov 2016 to Jan 2017

Collected customer and consumer use data to examine how customers use the site and shopping habits

Entered around 300 data points into Excel and used VBA and Excel functions to analyze data

Distribute over 1,000 coupons daily and follow-up to examine the success of coupon promotions

Selected and updated product information for monthly promotions

Shanghai City, Shanghai

Haitong Securities, Tongchuan Road Branch Office Jan 2016 to Feb 2016

Intern

Checked and verified all documentation for companies intending to go public including, assets, financial reports and qualifications as well as cross-referenced for Chinese-specific legal procedures

Wrote project application files, revised share transfer instructions, tidied financial

drafts for listing and additional issuances, and wrote internal auditing advice

Academic Experience

University of Wisconsin-Madison Business School Madison, Wisconsin

Grader Sept 2018 to present

Evaluated homework and exams of up to 180 students

Proctored exams and monitored students to ensure ethical conduct

Helped professor organize notes and reading materials for the class

Skills & Certificates

Computer: Microsoft Office, Stata, Python, SQL, R

Languages: Mandarin (native), English (fluent), Japanese (intermediate), French (basic)

Certifications: CFA Level II candidate

Contact this candidate