Water Pump Management — SCMC
Pump status tracking with Excel reports shaped to what the user actually needs
- Year
- 2024 – 2025
- Role
- Full-stack developer
- Status
- Delivered
- Stack
- Next.jsTypeScriptPrismaPostgreSQLNextAuthMinIODocker
A pump-monitoring system for SCMC that shows pump status from operator readings and exports Excel reports on the user's own terms.
Reporting ate most of the time, because every department wanted different columns. Instead of hardcoding one report shape, I let users choose the date range, the meters and the columns themselves.
Deployed as a Docker image pulled from Docker Hub onto a Linux server, with a written production deployment guide and migration notes.
Highlights
- Excel export with user-selected columns and date ranges
- Chemical inventory and dosing records
- File attachments stored in MinIO
- Deployment and migration docs written for whoever takes it over
Private project (repository not public)