What the operation needed.
Recurring pharmacy exports were fragmented across workbooks, limiting visibility of expiry risk, supplier exposure, and inventory value.
All systems
01
Pharmacy inventory intelligence
PharmGuard
Turns fragmented Excel reports into a secure, decision-ready inventory control system.
verified30,956 lot records and AED 29.13M reconciled; synthetic demonstration data.
How the system responds.
A reconciled data model and secure analytical interface that turns lot-level records into decision-ready expiry, supplier, and quality views.
Evidence register
What is on the record.
Implementation evidence is deliberately separated from modeled or illustrative benefit.
30,956 lot records reconciled
AED 29.13M inventory value represented
Supplier, brand, expiry, and data-quality views connected
My role
End-to-end solution design, data modeling, dashboard development, QA and deployment.
System screens
Designed as a workflow,
not a single dashboard.
