06 · HEALTHCARE DATA · APIs · UI VALIDATION

Healthcare Eligibility Data Integration & Benefit Summary Pipeline

Overview

Built and validated a healthcare eligibility data pipeline across DentalXchange, CareStack, SQL/analytics sources, and payer-specific mappings, then compared the old and new UI to find data-quality and business-rule gaps.

Details

Key result15–20 — data sources integrated

Links

GitHub

Stack

PythonREST APIsJSONDentalXchangeCareStackPostmanSQLBigQueryHealthcare EligibilityLLM Data Preparation

15–20source inputs

20→80%validated accuracy

~2 hrsmanual lookup saved / case

7deployments validated

Next projectAutomated Financial Data Pipeline — Oracle to Power BI →

The Python workflow loads shared CareStack lookups and begins collecting the patient, insurance, benefit, plan, and rule files needed for one eligibility bundle.

The classic view was used as a comparison point for deductible, maximum, and coverage values.

The redesigned view presents the same core benefit concepts more clearly, but each value still had to be validated against the source data.

The old view exposes code-level percentages and limitation notes used during mapping validation.

The new UI groups procedures into readable categories with plan percentage, frequency/usage, and status.

The fetch run completes by writing one prompt-ready merged patient file while also recording empty or failed endpoint responses for debugging.