Municipal Water Management System (MWMS) - City of North Bend, Washington
I designed and built a Web/database application to manage water production and purchase for compliance with required stream flows and municipal water rights. I worked with stakeholders and Golder water resources consultants to develop the list of requirements. The application automates the complex calculations needed to manage municipal water. Simple reports are provided for daily water system operations and more complex reports are provided for city management and other stakeholders. Developed in ASP.NET 2.0 with over 70 forms and reports built on over 30 tables. The database is on SQL Server 2005. I am the sole designer/developer.
Operator's daily report: On an ordinary day when everything is working correctly, the water system operator sees this report and pumps the amount of water specified in this report. When there has been adequate rainfall no additional water will be needed as reflected in this day's report.