🏥 Healthcare & Pharmaceutical Database System (MySQL & Python)
Role: Database Architect & SQL Developer
Tech Stack: MySQL 8.0, Python (Pandas, mysql-connector), Relational Modeling (3NF)
Overview
Designed and implemented an end-to-end relational healthcare database modeling interactions between patients, physicians, pharmacies, pharmaceutical manufacturers, and drug formularies.
Key Highlights & Technical Challenges
- Real-Time Clinical Safety (Database Trigger): Implemented an automated MySQL trigger (
AFTER INSERT ON prescriptions) that monitors incoming prescriptions against known contraindicated drug interactions (adverse_interactions), automatically logging real-time flags into analertsaudit table. - Supply Chain & Pricing Analytics: Engineered multi-tier CTE queries comparing wholesale manufacturer contract pricing against retail pharmacy markups, tracking margin spreads per medication.
- Turnaround Lead-Time Analysis: Applied SQL temporal functions (
TIMESTAMPDIFF) to measure average fulfillment latency between prescription issuance and pharmacy dispensing. - High-Risk Provider Profiling: Identified outlier prescribing behavior by ranking physicians responsible for generating adverse drug reaction alerts.