Inventory & Asset Management — Manager.io + M365
BCHPR logistics · multi-location Cameroon · 2023 – present
Manager.io-integrated inventory and asset-management system for CHPR logistics across multiple Cameroon sites — with Microsoft 365 ecosystem orchestration (Lists, Power Automate, Power BI) and automated procurement workflows.
Highlights
- Manager.io API integration for real-time GL balances and procurement data.
- Microsoft 365 orchestration: SharePoint Lists → Power Automate approval flows → Power BI dashboards.
- Multi-location asset assignment with full custodian history for audit-ready accountability (Yaoundé · Douala · Bamenda · Garoua).
- Automated depreciation calculation with tax-compliance tracking.
- Purchasing decision engine — EOQ, reorder points, supplier performance comparison.
- Predictive maintenance scheduling (condition + usage-based triggers).
- QR-code asset scanning for field inventory audits — integrated with the QR-tracking system.
Related projects
Designer & Lead Engineer
QR-Code Patient & Specimen Tracking System
Operational innovation deployed across 365+ primary health facilities and 25+ GeneXpert laboratories — now under active consideration by Cameroon's National TB Programme as national best practice.
Architect & Lead Developer
Request Management System — Power Platform End-to-End
Production-grade Microsoft Power Platform solution running the full lifecycle of financial and operational requests at BCHPR — submission, document validation, executive approval, payment, issue tracking, and reporting — built on SharePoint Lists, Power Automate, Teams Approval Cards, and a Power BI semantic model.
Lead BI Developer
Power BI Dashboards — 1,953 DAX measures across 8 models
Production Power BI estate with 8 major semantic models totalling 147 tables and 1,953 DAX measures — underpinning clinical decision-making, operational tracking, and executive reporting across every BCHPR research programme and the Admin Team Request Management System.