Water Distribution Performance Monitoring
Universal Utilities · freelance software developer
- Analysed performance limitations of the existing Node-RED, MySQL, and Tableau-based reporting system.
- Designed the new data and reporting architecture from the ground up to improve reporting performance and support time-series sensor data.
- Designed the InfluxDB data model and storage structure for sensor-generated time-series data.
- Designed data querying and processing workflows for analytics and reporting.
- Developed backend services using NestJS.
- Developed a web-based reporting system for monitoring and analysing water distribution performance, replacing the previous Tableau-based reporting workflow.
- Integrated the reporting system with sensor data stored in InfluxDB through an MQTT-based ingestion pipeline implemented by another team.
- NestJS
- InfluxDB