Audited and redesigned data architecture for an IoT water usage monitoring application, then designed and implemented a new billing and bill estimation system.
Role
Data & Backend Engineer
Challenge
A new team within Metron-Farnier needed to build billing and bill estimation applications on top of their existing IoT water monitoring platform. The existing data architecture required assessment and the new billing system needed careful design to integrate with downstream applications.
Contributions
- Architecture Audit: Conducted comprehensive review of existing data architecture, identifying opportunities for improvement and integration points
- Database Design: Designed data architecture for new billing and bill estimation applications, implementing designs at the individual database table level
- Backend Development: Built the web backend and APIs for interacting with billing databases
- Requirements Definition: Expanded requirements to include downstream billing applications, ensuring the system could scale with business needs
- Documentation: Created comprehensive documentation for the new billing system architecture
Results
Delivered a complete billing system overhaul over 5 months, including rate table design and implementation, API development, and full documentation for ongoing maintenance.
Technologies
- Golang backend development
- PostgreSQL database design
- REST API development
- Azure DevOps
- AWS infrastructure
