Demo
OM
Data & integration · Centralized data pipelines

Data Pipeline & Patient Matching

Data from every system lands in one normalized, de-duplicated model, mapped to FHIR, coded with standard terminologies, quality-checked and loaded into a warehouse that powers dashboards, models and the agent. It runs on any major cloud.

ETL / ELTFHIR R4 normalizationMPI (Jaro-Winkler)data qualitystar schemaAWS · Azure · GCP
99.3%
records passing DQ
< 5 min
source → dashboard

Nightly + streaming pipeline

HL7 streams in real time; bulk sources run nightly

1 · Sources
9 connectors

EMR (FHIR + HL7), PM/billing, clearinghouse 835/837, fax/Document AI, phone/SMS, PT system

—
2 · Ingest
ECS listener · SQS · S3 (raw, KMS)

MLLP listener, FHIR $export (bulk), SFTP/X12 drops, webhooks → durable queue

—
3 · Normalize
Python workers · HealthLake

Map to FHIR R4, code systems (ICD-10, CPT, LOINC), patient matching, dedupe, data-quality checks

—
4 · Store
RDS Postgres · Redshift

Operational FHIR store + analytics warehouse (star schema), immutable audit log

—
5 · Serve
API Gateway · QuickSight · SageMaker

APIs for apps & agent, dashboards, ML features, scheduled reports

—

Patient matching (MPI)

Same person from two systems? Edit either record to see the score change

Auto-link
EMR (eClinicalWorks)
Referral fax (OCR)
Sim.
First name
1.00
Last name
0.95
Date of birth
1.00
Phone
1.00
ZIP
1.00
Weighted match score (auto-link ≥ 0.92 · review ≥ 0.78)
0.988

Accent-insensitive Jaro-Winkler on names, compound-surname handling, exact DOB and phone matching. Borderline pairs go to a review queue, never an automatic merge.

Data-quality checks

Failing records are quarantined with a reason, not dropped

  • Required fields present (PID-3, PID-5, PID-7)99.6%
    182 quarantined
  • Valid ICD-10-CM codes (no retired M54.5)99.1%
    41 quarantined
  • Appointment ↔ encounter reconciliation98.4%
    77 quarantined
  • Duplicate patients resolved by MPI99.8%
    12 quarantined
  • 835 payments matched to 837 claims97.9%
    64 quarantined

Terminology normalization

Local codes and free text → standard code systems

SourceRaw valueSystemStandard code
eCW localLBP w/ sciatica RICD-10-CMM54.41 · Lumbago with sciatica, right side
athena orderMRI L-SPINE WOCPT72148 · MRI lumbar spine w/o contrast
PT systemPain NRSLOINC72514-3 · Pain severity 0-10 (reported)
Intake formSmoker? NoLOINC72166-2 · Tobacco smoking status = Never
Fax OCRTFESI L4-5 RTCPT64483-RT · Transforaminal ESI, lumbar, single level

Warehouse query

Star schema: fact_authorization, fact_claim, fact_appointment + dimensions

-- Median authorization turnaround by payer, last 90 days
SELECT p.payer_name,
       COUNT(*)                                             AS requests,
       PERCENTILE_CONT(0.5) WITHIN GROUP
         (ORDER BY a.decided_at - a.submitted_at)           AS median_turnaround,
       AVG(CASE WHEN a.decision = 'denied' THEN 1 ELSE 0 END) AS denial_rate
FROM   fact_authorization a
JOIN   dim_payer p ON p.payer_key = a.payer_key
WHERE  a.submitted_at >= CURRENT_DATE - INTERVAL '90 days'
GROUP  BY p.payer_name
ORDER  BY median_turnaround DESC;
payer_namerequestsmediandenial_rate
UnitedHealthcare2143.4 d7.9%
Aetna1633.1 d6.1%
Empire BCBS1882.7 d5.3%
Humana MA971.9 d4.1%
Cigna722.2 d3.8%