Data Analyst Sales

Ziyi Cheng

Lincoln, NE • 443-***-**** • ****.*****@*************.***.*** • https://www.linkedin.com/in/ziyi-cheng/

\

SUMMRAY

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

University of Maryland College Park, MD Dec 2019

M.S. in Marketing Analytics GPA: 3.72/4.0

Honors: 1st Place Winner in Hiretual Case Competition; Scholarship Awarded Coursework: Data Science, Data Visualization, Marketing Strategy, Customer Analysis, SEM/SEO Weber State University Ogden, UT Dec 2017

B.S. in International Economics, Minor in Psychology GPA:3.6/4.0 Honors: Cam Laude Graduate Won, Scholarship Awarded SKILLS

Programming: SQL, SAS, R, Python (sklearn, pandas, numpy) Software/Technology: Tableau, Advanced Excel, Google Analytics, AB Testing Machine Learning: Classical & Penalized Regression Methods, KNN, Random Forest, Clustering, Regularization, etc. PROFESSIONAL EXPERIENCE

Neighborhood Rescue of America Remote

Research Analyst Intern May 2020 – Present

• Gather dashboards through Tableau to analyze the FBI crime data and visualize geographic mappings for stakeholders and partners.

• Conduct researches on demographic data of at-risk communities nationwide and identified hotspots for community turnarounds.

• Work with the advanced research team, providing Tableau and Python tutorials and evaluate research reports. FranConnect Herndon, VA

Marketing Data Analyst Intern May - Aug 2019

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

• Procured 20k client data from Salesforce and HubSpot, used SQL queries to aggregate and manage data.

• Orchestrated data visualizations in Python to find key features that impact Lead Scoring Model.

• Utilized Tableau to analyze data of 500 brands, drive and visualize the insights to evaluate effectiveness and performance for greater KPIs and business growth.

• Generated yearly statistical business reports by segmented industries for marketing activities. Noah Private Wealth Management Shanghai, China

Analyst Intern Jan – May 2018

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

• 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. DATA SCIENCE PROJECT

Google Analytics- Customer Segmentation & Strategy Optimization

• Built a web product sales forecast model in R and SAS to optimize commercial marketing channels.

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

• Built Logistic Regression Model to analyze and interpret buying behaviors, and 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. Banking Customer Churn Prediction & Analysis

• Developed algorithms to predict customer churn probability based on labeled data via Python programming.

• Preprocessed dataset including data cleaning, feature transformation, etc.

• Trained supervised machine learning models including Logistic Regression, Random Forest and KNN.

• Evaluated model performance of classification and analyzed feature importance to identify top factors.

Contact this candidate