FHIRETLSnowflake
FHIR ETL on Spark → Snowflake
Tech: Spark, PyArrow, Pandera, dbt (optional), Snowflake
End-to-end ingestion of HL7 FHIR (Patient, Encounter, Observation) JSON into curated Snowflake models.
Includes flattening, DQ checks, ICD-10/LOINC enrichment, features (e.g., lactate flags), and star schema for analytics.
💻 Code
📊 Architecture
📄 Case Study
ClaimsICD-10Anomaly
Healthcare Claims — Anomaly Detection
Tech: Python (pandas), feature engineering, dashboard
Profiling and anomaly signals across claim lines using ICD-10 and utilization patterns (cost outliers, frequency spikes).
Delivers prioritized review lists and a lightweight monitoring dashboard.
💻 Code
📄 Case Study