09-06-2013 BPU RPT 06 - Laserfiche WebLink

Home

W A T E R E N E R G Y ' L F F E RIVERSIDE PUBLIC UTILITIES Board Memorandum PUBLIC UTILITIES BOARD OF PUBLIC UTILITIES SUBJECT: FIRST AMENDMENT TO AGREEMENT BETWEEN SOFTWARE SOLUTIONS REPLACEMENT PROJECT ISSUE: DATE: September 6, 2013 ITEM NO: 6 THE PROFESSIONAL CONSULTANT SERVICES THE CITY OF RIVERSIDE AND MILESTONE INC. - CUSTOMER INFORMATION SYSTEM The item for Board of Public Utilities consideration is approval of the First Amendment to the Professional Consultant Services Agreement with Milestone Software Solutions Inc. for on demand support services during implementation of the new Customer Information System (CIS). RECOMMENDATION: That the Board of Public Utilities approve the First Amendment to the Professional Consultant Services Agreement with Milestone Software Solutions Inc. in an amount not -to- exceed $150,000. BACKGROUND: The current CIS system, Banner, was implemented in 1999. Banner is a complex system that provides billing capabilities and information for Electric, Water, Refuse and Sewer services. The Banner CIS system provides customer and billing information necessary to support over 400,000 annual customer service contacts, 180,000 work orders; and generates over $400 million in billings annually. Beginning in July 2012, Riverside Public Utilities (RPU) began the task of replacing the Banner CIS system with the EnQuesta CIS platform ( "Enquesta "). An internal implementation team has been formed and the project is well underway. A key component of this replacement project is the evaluation and clean -up of the existing Banner CIS data in preparation for conversion. A significant amount of analysis and clean -up has already occurred; however, an in -depth analysis of the Banner database is needed to ensure a clean conversion that is transparent to RPU customers. The Banner CIS system was written in older and less supported computer language. Milestone Software Solutions Inc. has staff familiar with the Banner CIS application and specifically with Riverside's conversion to Banner in 1999. In July 2013, a Professional Consultant Services Agreement between the City and Milestone Software Solutions Inc. was executed for an amount not -to- exceed $49,500 to provide conversion support, data mapping and data cleanup on an as needed basis. Because of Milestone's historical knowledge of the Banner application and the outstanding services rendered to date, staff is requesting to enter into a First Amendment with Milestone Software Solutions Inc. for additional services, including legacy conversion and clean up support, which are needed for the implementation of the new system. Internal staff does not have the expertise to perform this work and this assistance will accelerate the cleanup of the Banner database information and enhance the quality of the conversion to EnQuesta.