Alexandria Urology Hospital - Pharmacy & Clinical Inventory ERP
Enterprise hospital pharmacy ERP and clinical inventory platform built with Vue.js and Node.js. Features custom-built drag-and-drop drug hierarchy tree canvas and legacy HIS integration.
Project Overview
Alexandria Urology Hospital Pharmacy ERP is a mission-critical clinical pharmacy and pharmaceutical inventory platform developed for Alexandria Urology Hospital. The system orchestrates end-to-end pharmacy operations across inpatient departments and outpatient dispensaries, handling complex multi-unit medication conversions, batch expiry tracking (FEFO), and real-time cashier shift reconciliation. A signature engineering achievement of the platform is its custom-crafted Interactive Active Ingredient Tree Graph—built from the ground up on interactive canvas with drag-and-drop manipulation without external libraries to visualize drug classifications and therapeutic equivalents. To ensure unified hospital workflows, the platform seamlessly integrated with the hospital's legacy Hospital Information System (HIS), engineering resilient middleware adapters to synchronize clinical dispensing with patient billing in a private, high-security on-premise hospital environment.
Key Highlights & Features
Interactive Drag-and-Drop Drug Hierarchy Canvas: Custom-engineered tree graph visualization built from scratch for navigating active ingredients, pharmacological classes, and therapeutic drug equivalents.
Legacy Hospital Information System (HIS) Integration: Robust middleware bridge seamlessly synchronizing clinical dispensing orders, patient records, and medical billing with legacy hospital databases.
Multi-Unit Fractional Inventory & Batch Tracking: Precise conversion ratios (box, blister strip, unit) coupled with First-Expired-First-Out (FEFO) batch expiration auditing to eliminate stock discrepancies.
Pharmacist Shift & Financial Reconciliation: Shift handover tracking with automated cashier tallying, credit ledger balances, and insurance claim accounting.
High-Security On-Premise Deployment: Self-hosted architecture operating within the hospital's private local network ensuring sub-second response times and zero clinical downtime.