Audited and redesigned the data architecture for an IoT water-usage monitoring application, then designed and built 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 needed assessment, and the new billing system needed careful design to fit the downstream applications that would depend on it.
Contributions
- Architecture Audit: Reviewed the existing data architecture end to end, finding where to improve it and where the new system would integrate
- Database Design: Designed the data architecture for the new billing and bill-estimation applications, down to the individual table
- Backend Development: Built the web backend and the APIs for working with the billing databases
- Requirements Definition: Expanded the requirements to cover downstream billing applications, so the system could grow with the business instead of boxing it in
- Documentation: Documented the new billing system architecture for the team that would maintain it
Results
Delivered a full billing-system overhaul over five months: rate-table design and implementation, API development, and documentation for ongoing maintenance.
Technologies
- Golang backend development
- PostgreSQL database design
- REST API development
- Azure DevOps
- AWS infrastructure
