Yiyao (Clyde) Cai

**** ****** **** **** *** *** College Park, Maryland MD 20740 240-***-**** ac2b4i@r.postjobfree.com linkedin.com/in/yiyao-cai-29506710a

EDUCATION

Robert H. Smith School of Business, University of Maryland, College Park, MD 2017 Master of Science in Business Statistics (Marketing Analytics) GMAT: 710 GPA:3.44 (STEM Certified) Shanghai Maritime University, Shanghai 2016

Bachelor of Arts, Major: Executive Administration GPA: 3.15 PROFESSIONAL EXPERIENCE

Dihuni LLC, Mclean, Virginia Jul.2017-Sep.2017

A start-up company focusing on digital marketing analytics area and Internet of things (IoT) Digital Marketing Analyst Intern

Conducted market research on market and industry trends in 3 fields of Internet of Things (IoT).

Defined, designed, and developed customer surveys, interviews, and product demos. Web scrapped 7000 rows of data from multiple sources: online, emails and conversations. Created analytics dashboards by using “Shiny” package in R.

Extracted 500 reviews from Amazon. Applied sentiment analysis and derived 30 most frequent-used and generated word cloud. Haworth Inc., Shanghai, China Oct.2015-May.2016

A high-end office furniture company headquartered in Holland, Michigan Data Entry Specialist Intern

Cooperated with colleagues to analyze and categorize over 200 rival brand’s information in positioning new products.

Conducted market research on industry status, potential customers, and competitive market strategies on sample of more than 1,000 consumers, making customer profiles. Integrity increased by 12%. Shanghai Oriental TV, Department of Strategic Development, Shanghai, China Biggest TV station in East China, covering over 1.3 billion population and 20 cities. Jun.2014-Sep.2014 Digital Media & Communication Intern

Synthesized digital media research, reports, and trends to inform and create compelling 4 analytic reports and recommendations based on target audiences and client goals.

Developed and persuasively presented digital media recommendations to clients and potential clients through new business pitches. PROJECT EXPERIENCE

Action Learning Project: Pricing and Retention Rate Forecasting for Sport Technology Company (SQL, R and Excel) 2017

Leveraged R and SQL to remove noises from sales data and measured retention rate for its flagship product.

Deployed Trial and Repeat Model with price as covariate to predict attrition rate and calculated optimal price in Excel; resulted in 37% increase in revenue in next five years.

Advanced Marketing Analytics: Global Retailer International Market Segmentation Analysis (SAS, Glimmix and Excel) 2016

Applied Mixture Regression Model to identify different size and drivers for each segment.

Recommended targeted regions to enter and listed main factors for targeted segment. Customer Analysis: Sales Promotion Effects Evaluation for Laundry Detergent with Scanner Panel Data (SAS and Excel) 2016

Employed Multinomial Logit Model in SAS to measure efficiency of price discount, in-store display and feature advertising in influencing consumers’ purchase incidence and brand choice.

Identified price discount and in-store display as main drivers for purchase incidence and brand choice respectively. Data Science: IMDB Movie Dataset Analysis (SQL, R, Excel and Tableau) 2017

Utilized SQL and R to reorganize data structure. Applied Exponential Model, added covariates to better forecasting future sales.

Applied machine learning methods to predict data classification; resulted in 83% accuracy. TECHNICAL SKILLS/ANALYTICS/CERTIFICATIONS

Web Analytic Tools: Google Analytics (Certified), Google AdWords (Certified), Web Scrapping, Text Mining

Statistical Tools: SAS, R, Excel, Glimmix, SQL, Tableau

Machine Learning: k-NN, Naïve Bayes, SVM, Decision Tree, Random Forest

Course Related: Data Science, Web Analytics, Statistical Programming, Market Forecasting, Customer Equity Management ADDITIONAL INFORMATION

Languages: Mandarin Chinese (Native), Wu Chinese (Fluent)

Advanced sketcher (grade 9, highest grade for amateur); proficient in game of go (3 dan, 9 dan to become a pro)

Maryland Food Bank, Baltimore, Volunteer: Processed food and assembled items