AquaSense - Intelligent Water Management
Associated Institution: Escuela Colombiana de Ingeniería Julio Garavito
Project Summary
Project Narrative
The project analyzed the systemic challenges faced by water utilities, including fragmented infrastructure, lack of SCADA/ERP/CRM systems, high water losses, climate-related operational risks, and limited real-time visibility. Using systems thinking methodologies, causal loop diagrams, and operational modeling, we identified key leverage points to support long-term modernization strategies.
Designed a TO-BE intelligent operational architecture integrating IoT concepts, AI-driven anomaly detection, and low-code automation technologies. The solution was built conceptually using n8n workflows deployed on Azure with Docker, Supabase as centralized data storage, Grafana dashboards for monitoring, and Gemini AI for anomaly detection and operational analytics.
Project Scope & Deliverables
- Systemic analysis and causal loop modeling
- Digital transformation strategy for water utilities
- Design of automated workflows and monitoring systems
- Data integration architecture simulating SCADA, ERP, CRM, and GIS
- KPI monitoring, telemetry, governance, and risk management
- AI-assisted detection of leaks, anomalies, and operational inefficiencies
Core Skills Archetype
Automation Stack
Media & Documentation Deliverables
Product Definition (PDD) & System Design (SDD)
Contains the core architectural guidelines, system interaction charts, node structures, and non-functional specifications.
System Overview Presentation
Final deck showcasing the flow of data across systems and the value of automation for smart water management.
Systemic Analysis Report
Evaluation of the data flow reliability, Azure configuration efficiency, and automation loop bottlenecks.
