Medical Center Platform
A comprehensive multi-module healthcare platform built on Oracle APEX 26.1, featuring 170+ screens and a normalized schema of 150+ relational tables covering patients, appointments, billing, clinical records, inventory, and pharmacy.
Key Metrics
170+
Screens
150+
DB Tables
150+
PL/SQL Units
20+
REST APIs
70%
API Delivery Improvement
35%
Query Latency Reduction
The Problem
Healthcare facilities needed an integrated digital platform to manage complex medical workflows, from patient registration through diagnosis, billing, and pharmacy — replacing fragmented paper-based and legacy systems.
The Solution
Architected and delivered a full-stack enterprise healthcare platform with 170+ screens, 150+ PL/SQL business logic units, 20+ ORDS REST APIs for mobile sync, AI Vector Search for semantic medical records search, and containerized deployment with Docker.
Key Highlights
- Engineered 150+ PL/SQL business logic program units with centralized error logging
- Designed 20+ ORDS REST APIs with error-handling and retry mechanisms
- Integrated AI Vector Search for semantic search across patient records
- Containerized with Docker and Docker Compose for consistent deployment
- Automated database backups to GitHub for version control
- Designed 24 JasperReports reports and built APEX MAIL for notifications
Tech Stack
Oracle APEX 26.1PL/SQLORDSOracle AI Vector SearchDockerJasperReportsFlutterRAG