Public Health Regional Warehouse Management System

Context

A public sector project designed to address lost records, facilitate inter-unit transfers, generate reliable reports, and offer a short learning curve.

Problem

Without a dedicated inventory management system, movements were inefficient, reports were inaccurate, and communication between health units was ineffective.

Solution

We implemented a management system that controls movements with precision and traceability, unifying the entire workflow in a single lightweight, highly accurate application.

Technical Decisions

• Chose React for ease of interface componentization
• Used MySQL for robustness and reliability in inventory data relationships

Technical Implementation

Challenges

• Modeling a database that enables full item traceability without compromising system performance
• Creating a user-friendly interface for users with low digital literacy

What I Learned

• Deepened expertise in the Spring Boot ecosystem
• The importance of iterative feedback from real users during development

Results

• Enabled staff to access integrated information across units
• Improved workflow agility
• Reduced risk of product and record loss
• Accessible documentation
• Prototype running continuously for 9 months