Social Media Sales

Ziyi Cheng

College Park, MD • 443-***-**** • ****.*****@*******.***.*** • LinkedIn Profile

\

SUMMRAY

Recent Master Graduate offering advanced data analytics combined with a passion for utilizing data to understand key insights and provide decision-making recommendations. Strong knowledge of business intelligence, data visualization and machine learning, solid technical skills in SQL, Tableau and R. EDUCATION

University of Maryland, Robert H. Smith School of Business College Park, MD M.S. in Marketing Analytics Dec 2019

Honors: 1st Place Winner in Hiretual HR Analytics Case Competition, Scholarship Awarded Coursework: Data Science, Data Visualization, Database Management, Marketing Strategy, Customer Analysis Weber State University Ogden, UT

B.S. in International Economics, Minor in Psychology Dec 2017 Honors: Cam Laude Graduate Won, Scholarship Awarded Coursework: Probability and Statistics, Linear Modeling SKILLS

Computer: R, SAS, SQL Server, Python (Numpy, Pandas), Advanced Excel (VBA), Tableau, Google Analytics Bi-lingual: English and Mandarin

PROFESSIONAL EXPERIENCE

FranConnect Herndon, VA

Marketing Analyst Intern May - Aug 2019

Delivered exemplary technical support to a software company specializing in cloud-based platform sales.

• Procured 20k subscription data from Salesforce and HubSpot, managed data using SQL within SAS.

• Orchestrated correlation matrix visualization in Python to find key impacts and conduct client scoring model.

• Analyzed data of 500 brands using the software in Excel and Tableau to derive the insights and achieve ROI.

• Generated yearly statistical business reports by segmented industries for social media and customer workshops. Weber State University Ogden, UT

Research Assistant May – Dec 2017

Selected to participate in a governmental project investigating fishing behaviors to quantify the economic value of fishing.

• Assessed over 400 survey questionnaires and developed graphs and insights utilizing Excel to identify patterns.

• Presented research findings, drawing conclusions, and making recommendations based on data.

• Lauded by study leaders for making impactful contributions that guided the final conclusion. Noah Private Wealth Management Shanghai, China

Marketing Analyst Intern Jan – May 2018

Reviewed financial product (Health Insurance) sales data and created reports about effectiveness in customer conversion.

• Continuously updated data and sales performance using Pivot Tables and Vlookup to senior stakeholders.

• Organized, assembled, and interpreted fundamental data to analyze revenue and develop strategies on how to bolster sales with innovative marketing techniques. PROJECT EXPERIENCE

E-commerce Customer Analysis & Revenue Prediction Feb – Mar 2019

• Preprocessed 450K raw sales data in R and SAS by dealing with categorical feature encoding and feature scaling.

• Built Logistic Regression Model and Semi-Log Linear Model to analyze and interpret buying behaviors.

• Predicted revenues using Decision Tree Model (Regression Tree) with a 1.5 RMSE.

• Selected the best model based on RMSE and prediction accuracy, and presented the key factors. Technical Resources Retention Prediction Apr 2019

• Developed algorithms for 10k employee profile data to predict resignation possibility in R.

• Trained supervised machine learning models including Logistic Regression and Classification Tree.

• Analyzed and presented feature importance to identify top factors influencing employee resignation and awarded 1st Place in the Case Competition.

Contact this candidate