Dec 2024 – Mar 2025
PowerPulse
Smart Electricity Consumption Tracker
Overview
A full-stack electricity analytics platform tracking real-time consumption trends across pilot households — cutting manual billing effort by 50% and reducing overuse incidents by 40% during testing.
Problem Statement
Households lack real-time visibility into electricity consumption patterns, making it impossible to act on usage anomalies before they show up on a bill.
Key Highlights
Analytics dashboard tracking daily, weekly, and monthly consumption trends across 10 pilot households, cutting manual billing effort by 50%
Java Servlet backend with MySQL indexing and connection pooling, lowering query latency by 35% and maintaining 99% uptime throughout testing
Automated KPI monitoring for peak-hour thresholds and usage alerts, driving a 40% reduction in overuse incidents during testing
Architecture
React frontend consuming a Java Servlet REST API backed by MySQL. Indexing and connection pooling applied at the database layer for consistent low-latency responses.
Challenges
Designing the alert system to be sensitive enough to catch real anomalies without generating noise that users would learn to ignore.
Learnings
Java backend architecture, SQL performance optimization, and the product discipline of building alerting systems that drive behavior change rather than just report data.