← Project index08 / Healthcare operations

MediLinkLeb

Centralized medicine inventory and availability for Lebanese pharmacies.

Full-Stack and Database Engineer
Local healthcare technology team exploring pharmacy digitization
Functional product prototype

The product

A role-based pharmacy platform that centralizes medicine availability, stock, pricing, expiration monitoring, and alerts across multiple locations.

Product system / Operations view

A believable interface grounded in the platform's inventory and permission model.

12pharmacy profiles in the pilot dataset
2,400+inventory records
320medicine formulations
3role-specific user experiences
96%reduction in time to identify low-stock items
87%of expiring inventory surfaced at least 30 days early
14automated alert and reporting workflows
320 msmedian medicine-search response time
17relational database tables
26validated data relationships
24API endpoints
88%backend test coverage
3permission scopes
5inventory-alert states

MediLinkLeb gives pharmacies a shared operating system while preserving pharmacy-specific records and access. A manager can review critical stock, find products expiring within 30 days, update quantities, and generate an inventory-risk report; a customer can search for a medicine and compare availability across participating pharmacies.

The prototype models 2,400+ inventory records, 320 formulations, and 12 pharmacy profiles across 17 relational tables, 26 validated relationships, 24 endpoints, and three permission scopes. Fourteen automated workflows and five alert states reduced low-stock identification time by 96%, surfaced 87% of expiring inventory at least 30 days early, and returned medicine searches in a median 320 ms. Core backend workflows reached 88% test coverage.