Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sarah Zheng

Lexington,MA

Summary

Experienced Business Intelligence Developer with over 10 years of expertise in data analytics, database management, and report development. Proven ability to transform raw data into actionable insights and design efficient ETL processes. Skilled in creating interactive dashboards that support data-driven decision-making. Proficient in SQL, Python, and Tableau, with a strong track record of collaborating with cross-functional teams to drive business impact through innovative data solutions.

Overview

16
16
years of professional experience

Work History

Business Intelligence Developer

Point32health
03.2015 - 07.2024
  • Conducted detailed analyses of CAHPS survey data to assess patient satisfaction and experience across domains such as access to care, provider communication, and customer service
  • Analyzed trends and performance metrics to identify areas requiring improvement, resulting in a15% increase in patient satisfaction scores over two years
  • Collaborated with cross-functional teams to design and implement strategies that improved Medicare Stars ratings, achieving a5 star average across multiple reporting cycles
  • Led ETL processes using SSIS to transform and consolidate data from multiple sources (SQL Server and cloud storage) into a centralized data warehouse, improving data accessibility and reporting accuracy

Business Data Analyst

Eliza Corporation
12.2013 - 11.2014
  • Developed a XGBoost classification model to predict customer satisfaction using survey and feedback data, leading to a12% improvement in satisfaction scores by identifying key satisfaction drivers and informing targeted communication strategies
  • Conducted funnel analysis across communication channels in SQL, identified key gaps, and collaborated with engineering teams to implement improvements, resulting in a5% increase in client response rates
  • Integrated new data sources into existing systems, enriching patient insights and improving data accuracy by30%, leading to enhanced analysis and decision-making

Data Analyst

Health Dialog
07.2008 - 07.2009
  • Conducted a detailed analysis of patient engagement across various communication channels in SQL, identifying key gaps and optimizing strategies, leading to a10% increase in patient participation in health coaching programs
  • Developed and maintained dashboards using SQL and SSRS to track key performance indicators for health management programs, providing actionable insights that informed strategic planning and operational improvements
  • Designed and executed A/B experiments for various email campaigns, analyzing results with statistical methods; optimized marketing spend and campaign performance, resulting in a2% increase in conversion rates

Education

Master of Science - Public Health, Biostatistics

University South Carolina

Skills

  • BI Tools: Power BI, Tableau, SSRS (SQL Server Reporting Services)
  • Databases: SQL Server, MySQL, Oracle
  • Programming Languages: SQL, Python, R
  • ETL Tools: SSIS (SQL Server Integration Services), Informatica
  • Data Warehousing: Star Schema, Snowflake Schema, Dimensional Modeling

Timeline

Business Intelligence Developer

Point32health
03.2015 - 07.2024

Business Data Analyst

Eliza Corporation
12.2013 - 11.2014

Data Analyst

Health Dialog
07.2008 - 07.2009

Master of Science - Public Health, Biostatistics

University South Carolina
Sarah Zheng