Work

HIPAA Healthcare Apps: EDI, Smile CDR, Flask

Python
Flask
PostgreSQL
Azure DevOps
Docker

HIPAA-compliant healthcare tooling for Molina Healthcare — EDI file testing apps, Flask dashboards over Smile CDR (FHIR) data, with CI/CD and Docker deploys.

Abstract visualization of HIPAA healthcare EDI applications

The Challenge

Healthcare data exchange in the US runs on EDI (Electronic Data Interchange) — a family of standards (X12 837 for claims, 835 for payments, 270/271 for eligibility, and others) that are powerful but notoriously complex. A single malformed EDI file can cause a claim to be rejected, a payment to be delayed, or — worse — a compliance violation. Testing EDI files before they are sent to payers is critical, but the existing testing process was manual and inconsistent.

At the same time, the clinical team needed real-time visibility into patient encounter data stored in Smile CDR (a FHIR-compliant clinical data repository). The data was there, but accessing it required technical expertise that the clinical and operations teams did not have. They needed a way to query and visualize encounter data without writing code or waiting for IT to run a report.

The Approach

A Python-based EDI testing application parses, validates, and reports on EDI files across all the major transaction types. The application checks not just syntax (segment structure, element counts, code set validity) but also business logic — for example, that a claim total matches the sum of its line items, or that a patient identifier matches the eligibility response. The tool produces a clear, color-coded report that highlights exactly what is wrong and where, so the team can fix issues before files are transmitted.

For the encounter data, a Flask web application connects to Smile CDR and exposes a simple, role-based dashboard. The dashboard shows real-time encounter metrics — admissions, discharges, emergency visits, and key quality indicators — with filters for date range, department, and provider. The application is containerized with Docker and deploys through Azure DevOps CI/CD pipelines, so updates are tested and released automatically without manual intervention.

HIPAA compliance was designed in from the start: all PHI (Protected Health Information) was encrypted at rest and in transit, access was role-based with audit logging, and the application ran in a HIPAA-compliant Azure environment with a Business Associate Agreement (BAA) in place. Every access to patient data was logged, and the audit trail was available for compliance review.

The Outcome

The EDI testing application caught an average of 15-20 file errors per week that would previously have been discovered by payers — each one a potential claim rejection or payment delay. The team could now test files in minutes rather than hours, and the error rate on transmitted files dropped significantly. The tool became a standard part of the claims submission workflow.

The Flask encounter dashboard gave the clinical and operations teams self-service access to real-time data they had never had before. Decisions that previously required waiting for a weekly report could now be made daily. The Dockerized deployment on Azure DevOps meant the team could push updates confidently — every change went through automated testing before reaching production, and rollbacks were a single command if anything went wrong.

Key Learnings

The biggest lesson was that in healthcare, data quality is not a technical nicety — it is a business requirement. A claim that is rejected because of a malformed EDI file is not just an IT problem; it is a provider who gets paid late and a patient who gets a confusing bill. Building tools that catch these issues early has a direct and measurable impact on revenue and patient experience. The second lesson was the importance of designing for compliance from day one: retrofitting HIPAA controls onto an existing application is far more expensive and error-prone than building them in from the start.