The Boston Water and Sewer Commission (BWSC) manages the largest and oldest system of its kind in New England, providing drinking water and sewer services to more than one million people daily.
BWSC was using a legacy Customer Information System, based on Ingres Database, and built in the 1980s. Right after they went live with it, the company that designed it all folded, and BWSC was left managing the system themselves.
Main Challenges they encountered:
- No documentation around the business processes that were built into the code,
- The system was completely built on exceptions,
- Very little integration between the system and the other systems of BWSC,
- Data could only be integrated in other systems one day later,
- Most of the Subject Matter Experts in the old system were on the verge of retiring.