header-left
File #: 1099-2024    Version: 1
Type: Ordinance Status: Passed
File created: 4/9/2024 In control: Public Utilities & Sustainability Committee
On agenda: 5/13/2024 Final action: 5/15/2024
Title: To authorize the Director of the Department of Public Utilities to enter into a contract with RCC Global, LLC for the Customer Information System (CIS) and Integrated Systems Upgrade Project; and to authorize the expenditure of $5,997,529.00 split among the Electricity, Water, Sanitary Sewer, and Stormwater Operating Funds. ($5,997,529.00)
Attachments: 1. ORD 1099-2024 Financial Coding - Red Clay - CIS Replacement

Explanation

 

This legislation authorizes the Director of Public Utilities to enter into a contract with RCC Global, LLC (RCC) for the Customer Information System (CIS) and Integrated Systems Upgrade Project. The project is expected to be complete sometime in 2026.

 

DPU’s current CIS, Hansen’s Banner, was implemented in 1999. The CIS is used to calculate and generate bills. It includes the database that is the primary repository for all utility rates, fees, charges, service orders and customer information. As business requirements evolved over the years, DPU has added several custom programs, as well as workaround solutions to the existing platform which has significantly added to system complexity and operating risk.

 

DPU implemented Oracle’s Customer Cloud Service (CCS) for meter data management in 2022 as part of the Enhanced Metering Project (EMP). AMI Meter installation is expected to continue through 2027. 

 

Numerous custom integrations were created to sync meter data between Oracle’s CCS and Hansen Banner. It is challenging to manage the lifecycle of meters with two separate systems. Since DPU is already using Oracle CCS for meter data management and analyzed the functionality of the CIS side of Oracle CCS, DPU would like to implement the entire Oracle CCS solution, including Oracle Reporting and Analytics tools. Merging these systems into one platform should reduce system complexity, increase data and billing accuracy and make it easier to support the system into the future. In addition, similar benefits are expected with the implementation of Oracle Field Services (OFS), which is also developed by Oracle and built to integrate with Oracle CCS. OFS will replace DPU’s current Mobile Dispatching System, CGI’s PragmaCAD.

 

A Customer Self-Service Portal, Electronic and Traditional Bill Presentment and Job scheduling software are components of the CIS Ecosystem that are critical to the success of this project. 

 

PROCUREMENT: 

 

The Department of Public Utilities solicited competitive bids through the Vendor Services and Bonfire websites from October 13, 2023 to November 10, 2023 for this project in accordance with the relevant provisions of Chapter 329 of City Code (RFQ026106). Four (4) bids, all by majority vendors, were received. The bids were deemed responsive and were evaluated on November 16, 2023. The Committee felt RCC Global, LLC submitted the strongest proposal overall for the following reasons:

 

1.                     RCC Global, LLC presented the most thorough and logical project approach.

2.                     RCC Global, LLC demonstrated a highly skilled project team, which includes numerous Oracle Certified resources.

3.                     Project team provided thorough overall understanding of DPU needs and included a good plan for change management.

 

Included in the RFQ was the request to perform an evaluation, selection and implementation of three components of the CIS ecosystem: Electronic and Traditional Bill Presentment, Customer Self-Service Portal and Job Scheduling Software. These were included in the RFQ because they are critical integration points with Oracle CCS and OFS. The selection process for these systems will be based on the vendor’s experience integrating with Oracle’s Utility Software solutions with Utilities that are similar to DPU. In addition, RCC Global, LLC will work with DPU to document and compile a Functional and Technical Capabilities Matrix to score the vendors. 

 

All of these systems must work together seamlessly and go-live simultaneously to avoid costly rework.  Contracting with RCC Global, LLC to implement the entire solution set helps to ensure we have a complete system at go-live and achieve the following goals:

 

1.                     Evaluate and reengineer our existing business processes related to the CIS ecosystem by adhering to best practices and out of the box Oracle CCS and OFS functionality in order to reduce business process and system complexity. 

2.                     Improve Customer Experience by providing a “One Stop Shop” customer portal for customers to obtain information, pay their bills, utilize self-service options etc. By providing more services online, DPU will also be reducing call center call volumes, reduce work redundancy and focus resources in more critical areas to increase operational efficiency. 

3.                     Streamline existing integrations to reduce complexity in our CIS ecosystem.

4.                     Implement Software as a Service (SaaS) solutions to help keep our CIS ecosystem current with more frequent technology and functional updates. 

 

The implementation project will include 3 phases:

 

1.                     Vendor Selection, engagement and discovery

2.                     Implementation of Oracle’s Utilities Customer Cloud Service (CCS), Oracle Field Service (OFS) and other software in the Oracle solution set. This phase also includes system integration support.

3.                     Implementation of supporting systems to be determined by phase one, which includes traditional bill printing and electronic bill presentment, customer self-service portal and a cloud-enabled batch scheduler. 

 

 

MINORITY AND WOMAN OWNED BUSINESS ENTERPRISE & SMALL LOCAL BUSINESS ENTERPRISE PROGRAM:

 

This contract opportunity was submitted to the City’s Office of Diversity and Inclusion (ODI) for review and assignment of an MBE/WBE goal prior to bidding. ODI determined there was not an opportunity for MBE/WBE participation in this contract and did not assign a goal. This contract was not bid with a City of Columbus MBE/WBE Program goal and the requirements of the City’s MBE/WBE Program are not applicable to this contract.

 

SUPPLIER: 

 

RCC Global, LLC | EIN on file | D365 #048789 | Expires April 11, 2026

 

The company is not debarred according to the Excluded Party Listing System of the Federal Government or prohibited from being awarded a contract according to the Auditor of State Unresolved Findings for Recovery Certified Search.

 

FISCAL IMPACT: 

 

$5,997,529.00 is available for this contract. It is about $2M over budget, but will be supported by forgoing or deferring other Computer Services’ related budget items.

 

$0.00 was spent in 2023

$0.00 was spent in 2022

 

 

Title

 

To authorize the Director of the Department of Public Utilities to enter into a contract with RCC Global, LLC for the Customer Information System (CIS) and Integrated Systems Upgrade Project; and to authorize the expenditure of $5,997,529.00 split among the Electricity, Water, Sanitary Sewer, and Stormwater Operating Funds. ($5,997,529.00)

 

 

Body

 

WHEREAS, the Department of Public Utilities (DPU) has a need to upgrade its Customer Information System (CIS) to integrate its various systems for Customer Information, Mobile Dispatching, and Smart Meter Installation and Data Management; and

 

WHEREAS, The Meter Data Management System is currently using Oracle’s Customer Cloud Service (CCS) platform and merging these systems under Oracle’s CCS should reduce system complexity, increase data and billing accuracy and make it easier to support the system into the future; and 

 

WHEREAS, The Department of Public Utilities solicited competitive bids through the Vendor Services and Bonfire websites from October 13, 2023 to November 10, 2023 for this project in accordance with the relevant provisions of Chapter 329 of City Code (RFQ026106) and four bids were received; and

 

WHEREAS, RCC Global, LLC was deemed to have the strongest proposal because they presented the most thorough and logical project approach, demonstrated a highly skilled project team, including numerous Oracle Certified resources, and their team provided thorough overall understanding of DPU needs and included a good plan for change management; and

 

WHEREAS, the implementation project will include 3 phases: Vendor Selection, engagement and discovery, implementation of Oracle’s Utilities Customer Cloud Service (CCS), Oracle Field Service (OFS) and other software in the Oracle solution set, including system integration support, and implementation of supporting systems to be determined by phase one, which includes traditional bill printing and electronic bill presentment, customer self-service portal and a cloud-enabled batch scheduler; and

 

WHEREAS, the estimated timeline for project completion is sometime in 2026 with additional phases and post-go live support occurring thereafter; and

 

WHEREAS, the expenditure of $5,997,529.00 or so much thereof as may be needed, is hereby authorized from object class 03, Services, split among the Electricity, Water, Sanitary Sewer, and Stormwater Operating Funds, per the accounting codes in the attachment to this ordinance; and

 

WHEREAS, it has become necessary in the usual daily operation of the Department of Public Utilities, to authorize the Director of Public Utilities to enter into a contract for the Customer Information System (CIS) and Integrated Systems Upgrade Project with RCC Global, LLC.; now, therefore

 

BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:

 

SECTION 1. That the Director of Public Utilities is hereby authorized to enter into a contract with RCC Global, LLC, 271 17th St. NW suite 610, Atlanta, GA 30363, for the Customer Information System (CIS) and Integrated Systems Upgrade Project.

 

SECTION 2. That this contract is in accordance with the relevant provisions of Chapter 329 of City Code.

 

SECTION 3. That the expenditure of $5,997,529.00 or so much thereof as may be needed, is hereby authorized from object class 03, Services, split among the Electricity, Water, Sanitary Sewer, and Stormwater Operating Funds, per the accounting codes in the attachment to this ordinance.

 

SECTION 4. That the funds necessary to carry out the purpose of this ordinance are hereby deemed appropriated and the City Auditor shall establish such accounting codes as necessary.

 

SECTION 5. That the City Auditor is authorized to make any accounting changes to revise the funding source for all contracts or contract modifications associated with this ordinance.

 

SECTION 6. That this Ordinance shall take effect and be in force from and after the earliest period allowed by law.