Healthcare Analytics & Marketing Data Specialist

Hongyi Lu

New Hyde Park, NY ***** 917-***-**** ***********@*****.***

Profile

Detail-oriented and results-driven data analyst with 8 years of experience in healthcare and strong background of applied statistical modeling in marketing analytics

Proven expertise in transforming complex datasets into actionable insights to inform operational, clinical, and business decisions

Adept in SQL, Power BI, SAS, and multiple advanced analytics tools within both healthcare and retail environments

Excellent communicator with demonstrated ability to collaborate with staff, management, business partners, and others at all organizational levels

Outstanding blend of organization, prioritization, leadership, and interpersonal skills

Provide sound consultative advice to senior management

Mentor and lead teams by example and with integrity to deliver service excellence

Consistent success is rooted within the combined concepts of quality, continuous improvement and effective process enhancements

Fully bilingual in English and Chinese

Key Strengths

Healthcare Analytics

Marketing and Consumer Analytics

Data Analysis and Modeling

Deep Technical Knowledge

Analytical Problem Solving

Team Contribution and Collaboration

Professional Experience

MVP Healthcare, New York, NY

Data Analyst

Lead data collection, cleansing, and ETL pipelines for large-scale healthcare data (claims, EHR, pharmacy, HEDIS), transforming raw data into analytic-ready datasets for operational and clinical insight generation, enabling sound decision-making in all business areas

Apply advanced analytics (SAS, Python, SQL) to identify trends in patient outcomes, service performance, and quality metrics, driving data-informed decisions across departments

Build and maintain interactive dashboards using Power BI, enabling stakeholders to track KPIs and understand member behavior dynamics

Collaborate with cross-functional teams in IT and data governance to validate and streamline data integration in Azure, DataLake, and Databricks environments

Macy’s Inc., New York, NY

Statistician / Manager, Marketing Statistics

Extracted and analyzed consumer behavior and transactional data to support marketing strategies and campaign optimization across digital and traditional channels

Developed and deployed predictive models (e.g., response, spend, profitability) using logistic regression, decision trees, and neural nets to inform campaign targeting and budget allocation

Conducted multivariate analyses (PCA, clustering, factor analysis) to create customer segments and improve retention and acquisition strategies

Delivered marketing performance analytics, ROI/ROAS tracking, and developed data pipelines for real-time marketing dashboards

Leveraged ArcGIS to link geographic and demographic data with customer behavior, enabling location-based promotional strategies

HIP Health Plan of NY, New York, NY

Statistician / Data Analyst, Marketing Statistics

Explored, examined, and gathered vast quantities of real-world healthcare data and performing data pre-processing / wrangling tasks to transform data into appropriate formats for further analyses focused on performance monitoring and service optimization

Supported clinical trial analytics through the analysis of cross-sectional and case-control data, assisting in A/B test design and statistical evaluation

Identified emerging business requirements by utilizing statistical database and programming skills

Developed dynamic member profiles using claims and clinical data, improving patient engagement and service delivery initiatives

Education and Additional Qualifications

Master Degree in Statistics, Columbia University, New York, NY

Bachelor Degree in Geography, Beijing Teachers College, Beijing, China

Additional Qualifications

Proficient in health data standards and regulatory metrics: HEDIS, CMS, NCQA

Strong understanding of healthcare coding systems: ICD-10, CPT, HCPCS, SNOMED, LOINC

Experienced in communicating technical insights to non-technical stakeholders to inform strategic business and clinical decisions

Additional Information

Technical Expertise

Healthcare Analytics: Claims, EMR/EHR, pharmacy, lab data, HEDIS, NCQA, CMS, ICD-10, CPT, HCPCS, MS-DRGs

Data Analysis and Modeling: Descriptive/exploratory analysis, predictive modeling, trend forecasting, anomaly detection, A/B testing, multivariate analysis

Marketing and Consumer Analytics: Customer segmentation, loyalty and retention analysis, CRM, eCommerce and omnichannel performance

Tools and Platforms:

oProgramming / Query Languages: SQL (T-SQL, TOAD, DBeaver), SAS (Base, Macro, EG, Miner), SPSS, Python

oData Visualization: Power BI, Tableau

oStatistical Modeling: Logistic and linear regression, clustering, factor analysis, neural networks, decision trees

oBig Data / Cloud: Hadoop, Hive, Azure, Databricks, DataLake

oOthers: ArcGIS, MS Excel (advanced), MS Access

Contact this candidate