Data-driven Marketing Data analysis

Yuan (Alex) Zhao

+1-702-***-**** ************@*.************.***.

LinkedIn Profile https://www.linkedin.com/in/yuan-zhao-805239112

Personal Website http://yuanzhao2016.wixsite.com/alexzhao

Empower Business through Data and Technology

EDUCATION

Northwestern University, Medill Evanston, IL, US

M.S. in Integrated Marketing Communications Sept 15 – Expected Dec 16

Data Analytics and Digital Marketing track (GPA: 3.9/4)

Coursework: Statistics and Market Research, Analytic Techniques, Data Management, Segmentation and Lifetime Value, Advanced Marketing Models, Digital Analytics, Marketing Measurement

Beijing Foreign Studies University, B.A. in Translation & Interpretation (GPA: 3.7/4) Sept 10 – Jun 14

University of Cambridge, Summer Exchange Program Jul 12 – Aug 12

SKILLS AND LANGUAGES

Data Analytics: SAS (Certified), SQL, R, SPSS, Alteryx, Excel, Python

Digital Analytics: Google Analytics (Certified), SiteCatalyst, Adobe Omniture, Radian6, Social Mention

Visualization: Tableau, Powerpoint, HTML, CSS

Languages: Mandarin, English and French

Interests Basketball, Ping Pong, Soccer, Poker, Reading

WORK EXPERIENCE

AutoZone Inc. Memphis, TN, US

Marketing and Ecommerce Analyst Tableau Excel Alteryx SQL Jun 16 – Aug 16

Facilitated CMO’s decision making process and shortened report-reading time by 80% by optimizing data analytics modules and introducing clearly visualized dashboard system called AutoDash

Cleaned, merged and analyzed customer satisfaction survey data (10M records) with Excel, Alteryx and SQL

Conducted comparison analysis between 50+ sales divisions and 20+ product categories with Tableau.

Redesigned internal data communication methodology and reduced process time by 90%.

Football Weekly Beijing, China

Digital Marketing Intern Google Analytics Python HTML SAS Aug 14 – Jun 15

Increased England’s national football team’s followers from 10k to 2M on social media within one year.

Reduced research time by 95% by collecting customer info and reviews with web crawlers written in Python.

Conducted text mining in SAS and divided customers into 8 segments based on the result and demographic information, increased numbers of review/repost/like by 300% in six months.

Monitored The FA website with Google Analytics and offered SEO solutions which increased traffic by 200%.

BrillianTech Shanghai, China

Market Research Intern SPSS Excel SAS Omniture Jun 13 – Sept 13

Designed questionnaires to collect user feedback, cleaned and analyzed the results with SPSS, identified 10+ user pain points and increased user satisfaction rate by 20% one month later.

Increased overall productivity and efficiency of business intelligence system by 30% by control group testing and monitoring customer experience with 20+ key performance metrics.

Identified target clients based on their website behaviors with predictive models and converted 20%.

State Grid Yangzhou, China

Data Management Intern Excel SQL Jun 12 – Sept 12

Cleaned, transformed and merged over 10 GB of data and streamlined data management process

CERTIFICATIONS

SAS Certified Base Programmer for SAS 9, Google Analytics Qualification

Contact this candidate