Data wrangling, modeling, staging EMR data, and wiring up downstream accelerators.
Developing data warehouse-ETL data flows and data marts to build integrated repositories for clinical and business analytics or vendor EDI.
Integrating quality of care and population health management benchmarks, targets, and results.
Standards conformance and testing for FHIR and HL7 messaging payloads and EDI implementations.
Developed data model for parsing Medicaid enrollment from MassHealth X12 834 EDI.

▪ Worked with SHCN data warehouse team and vendor to leverage data center as a service for data migration to replace legacy EDI.
▪ Developed data marts for ETL data flows and EDI management to replace legacy databases (e.g. new care management application suite).
▪ Developed data model for parsing Medicaid enrollment and member details from MassHealth X12 834 EDI.
▪ Mapped data, developed, and stood up new reports/data flows destined for vendor/EDI info sinks to replace legacy EDI.

▪ Engineered data to produce clinical business analytics for outcomes improvement.
▪ Guided data validation tests to ensure authentic and reproducible results.
▪ Developed data flows and visualizations by integrating EMR data with BIDW/data lakes
▪ Accountability for a queue of targeted and measurable quality improvement opportunities.
▪ Managed BIDW batch loads and EHR data transformation during SDLC design, build and testing phases.

▪ Managed performance improvement measurement and reporting metrics for Medicaid MCO compliance and External Quality Review (e.g., HEDIS, CAHPS, Star).
Built custom reference datasets for validation of care quality and data quality for Medicaid MCOs.
Performed HEOR research that generated new business.
Developed Mercer’s knowledge base in clinical efficiencies: low acuity non-emergent emergency room visits (LANE), potentially preventable hospitalizations and preventable readmissions.