Shangze(Mandy) He
Los Angeles,CA
Summary
Results-driven Data Analyst with 5 years experience in Tech industry. Specialized skills include data analysis, pipeline creation, and project management. Committed to leveraging analytical expertise and collaborative abilities for organizational success.
Overview
5
5
years of professional experience
Work History
GTM Operations Analyst
BlackLine
Los Angeles
01.2022 - 10.2024
- Built and maintained operational pipeline and booking performance reports to identify regional and timely bottlenecks, providing actionable insights for leadership.
- Improved data accuracy and stability by reconciling and maintaining engagement, booking, and pipeline data using ETL tools.
- Supported managerial decision-making by creating and maintaining interactive Tableau dashboards across operation and finance teams.
- Managed and executed a data migration project, transferring operational team data from Redshift to BigQuery, ensuring seamless system integration and minimal downtime.
- Led the Data Dictionary Project, standardizing naming conventions for operational subteams to ensure alignment and information consistency.
- Manipulated large datasets to improve analysis efficiency and data capability through advanced SQL queries, reducing manual data processing times.
- Saved 10+ hours per month for the Business Development team by developing and updating an interactive attainment report to monitor BDR performance.
- Reduced at least 3+ hours of manual effort weekly by automating data flows using Tableau Prep, enhancing workflow efficiency.
Business Analyst
RMDS Lab
Los Angeles
09.2020 - 01.2022
- Led 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, and business dashboards to various departments by using Tableau and Excel
- Directed data science solution projects in the completion of collecting requirements, cleaning unstructured datasets, conducting analysis activities, and reporting by using SQL
Marketing Analyst
RMDS Lab
Los Angeles
09.2019 - 09.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 Science - Information Studies
Trine University
Phoenix, AZ05-2026
Master of Science - Business Analytics
Loyola Marymount University
Los Angeles, CA08-2021
MBA -
Loyola Marymount University
Los Angeles, CA05-2020
Skills
- SQL
- Big Query
- Python
- Project management
- Tableau
- Tableau Prep
- Salesforce
- Google Analytics
Timeline
GTM Operations Analyst
BlackLine
01.2022 - 10.2024
Business Analyst
RMDS Lab
09.2020 - 01.2022
Marketing Analyst
RMDS Lab
09.2019 - 09.2020
Master of Science - Information Studies
Trine University
Master of Science - Business Analytics
Loyola Marymount University
MBA -
Loyola Marymount University
Similar Profiles
OSCAR CARREONOSCAR CARREON
Implementation Consultant at BlackLineImplementation Consultant at BlackLine
Kumar RanjanKumar Ranjan
Senior Software Engineer at BlackLineSenior Software Engineer at BlackLine
NEHA PANDITHNEHA PANDITH
Software Engineer in Test at BlacklineSoftware Engineer in Test at Blackline