05-09-2016 BPU RPT 08 - Laserfiche WebLink

Home

W A T E R E N E R ( , I W& PUBLIC UTILITIES BOARD OF PUBLIC UTILITIES RIVERSIDE PUBLIC UTILITIES Board Memorandum DATE: MAY 9, 2016 ITEM NO: 8 File ID — 16 -1237 — Discussion SUBJECT: OPERATIONAL DATA MANAGEMENT SYSTEM PROJECT; MODIFY SCOPE OF PROJECT, APPROVE ENTERPRISE SOFTWARE AGREEMENT WITH OSISOFT, AND APPROVE PROFESSIONAL SERVICES AGREEMENT WITH INDUSTRIAL EVOLUTION — IN THE AMOUNT OF $3,557,000 ISSUES: The items for Board of Public Utilities consideration are: 1) approval of Enterprise Agreement with OSlsoft, LLC for the installation of PI software and services; 2) approval of professional services agreement with Industrial Evolution; and 3) approval of Work Order No. 1619634. RECOMMENDATIONS: That the Board of Public Utilities: Approve the Enterprise Agreement with OSlsoft, LLC and authorize the City Manager or his designee to execute the agreement in the amount of $2,079,832; 2. Approve the Professional Services Agreement with Industrial Evolution and authorize the City Manager or his designee to execute the agreement in the amount of $698,000; 3. Approve Work Order No. 1619634 in the amount of $3,557,000; and 4. Reduce Work Order No. 1424073 from $4,430,427 to $2,530,400. BACKGROUND: All divisions within Riverside Public Utilities (RPU) rely on data to make operational and fiscal decisions. Thousands of data points are collected daily from field equipment and monitoring devices, electric and water meters, customer interactions and financial transactions. The data is stored in various formats, such as spreadsheets, Microsoft Access databases, and a variety of systems (such as enQuesta Customer Information System) that are not integrated with one another, which makes generating reports and analyzing data cumbersome and inefficient. The Operational Data Management System (ODMS) is foundational for Utility 2.0, as it will serve as a "data hub ", or central repository, to collect, analyze and make data - driven decisions from all systems that collect and store data throughout the utility. ODMS will be the backbone of future operational technologies such as distribution automation, outage management system, smart metering, meter data management system, and asset management. It integrates previously nonintegrated data and transforms it into meaningful information that can be displayed and consumed through visual tools such as dashboards and reports. In addition to providing readily available and easy to consume information, ODMS provides an enhanced analytics platform that RPU can leverage to improve operational performance (see Figure 1).