Sarah Zheng
LEXINGTON,Massachusetts
Summary
Experienced Business Intelligence Developer with over 10 years of expertise in data analytics, database management, and report development. Skilled in transforming raw data into actionable insights, designing ETL processes, and creating interactive dashboards to support data-driven decision-making. Proficient in SQL, Python and Tableau, with a strong ability to collaborate with cross-functional teams and drive business impact through innovative data solutions.
Overview
16
16
years of professional experience
Work History
Business Intelligence Developer
Point32health
Canton
03.2015 - 07.2024
- 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
- Enhanced data quality by implementing data validation rules and automated alerts, reducing data discrepancies by 20%
- Optimized SQL queries and stored procedures, improving data retrieval performance by 30% across critical reports
- Used HEDIS data to develop and implement strategies aimed at improving healthcare quality and patient outcomes
Business Data Analyst
Eliza Corporation
Danvers
12.2013 - 11.2014
- Developed a XGBoost classification model to predict customer satisfaction using survey and feedback data, leading to a 12% 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 a 5% increase in client response rates
- Integrated new data sources into existing systems, enriching patient insights and improving data accuracy by 30%, leading to enhanced analysis and decision-making
Data Analyst
Health Dialog
Boston
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 a 10% 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 a 2% increase in conversion rates
Education
Master of Science - Public Health, Biostatistics
University South Carolina
SCSkills
- SSIS
- SSRS
- SQL
- Python
- R
- Tableau
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
Similar Profiles
Jamie JohnsonJamie Johnson
Intake Coordinator at Point32HealthIntake Coordinator at Point32Health
Kyle GreerKyle Greer
Provider Enrollment Supervisor at Point32HealthProvider Enrollment Supervisor at Point32Health
Fatima Cabrera WoodsonFatima Cabrera Woodson
Vice President, Provider Network Contracting at Point32HealthVice President, Provider Network Contracting at Point32Health
Celina Collazo DellaMorteCelina Collazo DellaMorte
Sr Compensation Analyst at Point32HealthSr Compensation Analyst at Point32Health
Sawyer WardSawyer Ward
Retail Cashier at Neillios Gourmet KitchenRetail Cashier at Neillios Gourmet Kitchen