Shangze (Mandy) He
Los Angeles,CA
Summary
Operations Analyst with 3 years of data manipulating and reporting experience. Thoroughly manages marketing and sales data, expertly providing dashboards for managerial team.
Overview
4
4
years of professional experience
Work History
GTM Operations Analyst
BlackLine System
Los Angeles, CA
01.2022 - Current
- Supporting managerial teams’ decision-making by creating and maintaining 20+ Tableau reports
- Providing visibility of pipeline and booking performance by building operational analytics report to identify timely and regional bottlenecks
- Saving 10 hours per month for the Business Development team by conducting interactive attainment dashboard to monitor BDR and Sales performance
- Enhancing data accuracy by reconciling and maintaining engagement, meeting, pipeline, and booking data by using ETL tools
- Manipulating datasets to improve data efficiency and increase the data capability of analysis by employing SQL
- Reducing at least 3 hours of manual effort per week by automating data flows through Tableau prep
Business Analyst
RMDS LAB
Los Angeles, CA
09.2020 - 01.2022
- Lead Business analytics projects to automate customer segmentation model and identify valuable customers, increasing customer retention rate by 5% quarterly on average
- Performed RFM analysis by using SQL and Python to enhance marketing channel campaigns’ conversion rate by 24%
- Provided KPI reports, analytics insights, business dashboard to various departments by using Tableau and Excel
- Directed data science solution projects in completion of collecting requirements, cleaning unstructured dataset, conducting analysis activities, and reporting by using SQL
Marketing Analytics Specialist Intern
RMDS LAB
Los Angeles, CA
10.2019 - 05.2020
- Built the CRM system and developed integrated communication strategies to manage 35k+ audiences
- Managed promotion, retention, and renewal campaigns that extended customer lifecycle and increase email click-through-rate by 21% on average
- Implemented Hubspot email AB testing to increase events ticket selling by 38%
Education
Master of Business Analytics (STEM) -
Loyola Marymount University
Los Angeles, CA08.2021
Master of Business Administration - Information Technology
Loyola Marymount University
Los Angeles, CA05.2020
Bachelor of Arts - Spanish
Tianjin Foreign Studies University
Tianjin05.2017
Skills
- Tableau
- Tableau Prep
- Excel
- SQL
- Python
- Salesforce
- AWS
- SPSS
- Google Analytics
- ArcGIS
Timeline
GTM Operations Analyst
BlackLine System
01.2022 - Current
Business Analyst
RMDS LAB
09.2020 - 01.2022
Marketing Analytics Specialist Intern
RMDS LAB
10.2019 - 05.2020
Master of Business Analytics (STEM) -
Loyola Marymount University
Master of Business Administration - Information Technology
Loyola Marymount University
Bachelor of Arts - Spanish
Tianjin Foreign Studies University