Back to Portfolio

Masaka District Inventory Database

Comprehensive Inventory Management System — Nov 2023 – Dec 2024

Context

Masaka District Health Department needed a centralized system to track and manage their extensive inventory of medical equipment and vehicles. Previously, records were fragmented across multiple spreadsheets and paper files, making it difficult to maintain accurate inventory and prepare for audits.

Problem

The health department faced significant challenges:

• Fragmented equipment records across multiple systems
• Difficulty tracking 200+ pieces of equipment and vehicles
• Time-consuming manual inventory processes
• Poor audit readiness due to incomplete records
• Lack of real-time visibility into asset status

My Role

Database Engineer — responsible for:

• Designing and developing the comprehensive inventory database
• Creating data models for equipment and vehicle tracking
• Implementing efficient data organization structures
• Building reporting capabilities for audit readiness
• Ensuring data integrity and accuracy

Tech Stack

Solution

I developed a comprehensive inventory database system that:

• Centralizes all equipment and vehicle records in one system
• Tracks 200+ assets with detailed information
• Provides efficient data organization and retrieval
• Enables quick generation of audit reports
• Maintains data integrity through validation rules

Outcome

Impact

The Masaka District Inventory Database transformed how the health department manages its assets. By centralizing records and improving organization efficiency by 35%, the department can now quickly access accurate inventory data, prepare for audits more effectively, and make informed decisions about resource allocation.

Back to Portfolio