In 2009, the city of Burbank Water and Power department (BWP) desired to implement Oracle Utilities Work and Asset Management (WAM) system that will aid BWP in the process of managing the assets lifecycle and establish FERC (Federal Energy Regulatory Commission) and NARUC (National Association of Regulatory Utility Commissioners) Accounting and Reporting functionality to our current financial system. The New system will be tightly integrated into the Oracle eBusiness Suite (EBS).
In November of 2009, BWP retained the services of Sophos Solutions to assist them in the design and implementation of their new CMMS. Utilizing the experience Sophos has in implementing and integrating WAM into existing ERP systems.
The project’s key functionality was the ability to: Managing work, assign materials necessary for work orders, create and manage capital work, use pre-defined compatible units, use templates to create work orders quickly, assign resources to the work order, track costs by asset, create preventive and condition-based work orders, create purchase requisitions, drive the required regulatory accounting and provide a work estimating, budgeting and cost management tool.
The key technical requirements were migrating data from legacy systems, interfacing the City’s Financial system and Utility billing system. ERP interfaces included: the chart of accounts, time keeping, material management, purchase orders, invoices, employees, projects. The Utility billing interfaces included, Customers, Premises, service orders and Meter for meter management and preventative maintenance. and
The BWP successfully implemented WAM 6 weeks prior to the fiscal year allowing users to get used to the new system and make final tweaks to the new system in preparation for the new fiscal year and regulatory accounting. With the successful implementation of WAM the next phase will be to implement WAM for the Public Works Department.