Case study — 2026
Registre d'actifs terrain.
Equipment inventory for a health organisation deployed nationwide, modelled on the real health hierarchy: from province down to the individual facility.
Client
Organisation de santé publique (RDC)
Role
Design & full-stack development
Duration
In production
Year
2026
6
levels of geographic hierarchy
FR / EN
bilingual interface
Excel
exports generated natively
01 — The problem
Tracking equipment spread across a territory the size of the DRC means knowing not only *what*, but *where* — and "where" is not an address. It is a position in a health hierarchy: province, territory, health zone, health area, facility.
A conventional inventory with a free-text location field makes any aggregation by zone or by mission impossible, and falls apart as soon as equipment moves between operators and missions.
02 — The solution
I modelled the Congolese health hierarchy directly in the data schema: province, territory or city, site, health zone, health area and facility are linked entities, not strings.
Each asset carries a code generated from a category-specific prefix, and is tied to a mission, an operator and a responsible staff member. Lots track grouped acquisitions, and access control restricts visibility by scope.
The interface is bilingual French/English, Excel exports are produced with openpyxl, and email notifications go through a transactional service.
03 — The results
The inventory becomes queryable at any level: it can be aggregated by province, health zone, mission or operator with no post-processing.
That is the direct consequence of modelling health geography rather than storing it as free text — a choice that costs a few extra tables up front and avoids a full rewrite at the first reporting request.
Other projects
See all →Suite de gestion d'officine
Pharmacy management software designed for Kinshasa: dual FC/USD currency, strict FEFO, multi-branch and batch traceability — deployed across 6 pharmacies.
Pharmacie en ligne
Online medicine sales in Kinshasa: symptom search in plain language, delivery by district, and prescription handling with split purchases.