An offline-first, multilingual healthcare PWA with 13-language localization, strict PostgreSQL Row-Level Security across 15 tables, PostGIS ST_DWithin spatial queries over 10,742 facilities, deterministic screening with patient-context-aware Gemini triage, and NRCES-aligned HL7 FHIR R4 clinical bundles.
- Engineered an offline-first healthcare PWA with 13-language localization, device-language detection, and GPS/LGD-based regional recommendations for patient, clinician, and administrator workflows
- Enforced strict PostgreSQL Row-Level Security and server-side role / care-relationship authorization; introduced a partial unique index (uq_provider_slot_scheduled) to prevent concurrent appointment double-bookings
- Optimized facility discovery through GiST-indexed PostGIS ST_DWithin searches across 10,742 indexed facilities; added an IndexedDB offline outbox with UUID-based idempotency and batch synchronization
- Integrated deterministic clinical screening for hypertension, diabetes, and high-risk antenatal cases, alongside a patient-context-aware Gemini assistant with PII sanitization and emergency-first routing
- Generated and locally validated NRCES-aligned HL7 FHIR R4 bundles; project quality checks include 210 unit tests, 22 integration contract tests, and 5 Playwright end-to-end journeys