National Breathe Free
Software Engineer
June 2025 — Present
Healthcare operations analytics, multi-facility reporting, and hybrid-cloud clinical data pipelines.
- Migrated a production TypeScript/PostgreSQL app to Drizzle ORM v1 across a 102-file blast radius, resolving 521 TypeScript errors while modernizing relation/query APIs and migration tooling.
- Built a PostgreSQL trigger-based normalization pipeline that turns raw medical appointment feeds into normalized patient, provider, referral, facility, and visit records with idempotent upserts.
- Built a Python clinical extraction service that checkpointed incremental ODBC pulls from on-prem MSSQL sources and landed partitioned Parquet in Amazon S3.
- Stabilized real-time collaborative editing across Supabase Realtime, PostgreSQL triggers, and Yjs by fixing channel/topic mismatches and separating cursor traffic from presence state.