City of Columbus - File #: 0720-2011

• File #: 0720-2011
• Version: 1
• Type: Ordinance
• Status: Passed
• File created: 4/29/2011
• In control: Public Utilities Committee
• On agenda: 6/13/2011
• Final action: 6/15/2011
• Title: To authorize the Director of Public Utilities to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC in the amount of $466,014.00; to authorize transfers and expenditures within the Water Build America Bonds Fund, the Sanitary Build America BondsFund, the Stormwater Build America Bonds Fund, and the Electric Build America Bonds Fund; and to amend the 2011 Capital Improvements Budget. ($466,014.00)

Date	Ver.	Action By	Action	Result
6/15/2011	1	MAYOR	Signed
6/15/2011	1	CITY CLERK	Attest
6/13/2011	1	Columbus City Council	Approved	Pass
6/13/2011	1	COUNCIL PRESIDENT	Signed
6/6/2011	1	Columbus City Council	Read for the First Time
5/25/2011	1	CITY ATTORNEY	Reviewed and Approved
5/25/2011	1	Utilities Drafter	Sent to Clerk's Office for Council
5/24/2011	1	ODI DIRECTOR	Reviewed and Approved
5/24/2011	1	Utilities Drafter	Sent for Approval
5/20/2011	1	EBOCO Reviewer	Sent for Approval
5/19/2011	1	Auditor Reviewer	Reviewed and Approved
5/19/2011	1	CITY AUDITOR	Reviewed and Approved
5/19/2011	1	Utilities Drafter	Sent for Approval
5/18/2011	1	Utilities Drafter	Sent for Approval
5/17/2011	1	Finance Reviewer	Reviewed and Approved
5/17/2011	1	FINANCE DIRECTOR	Reviewed and Approved
5/13/2011	1	Utilities Drafter	Sent for Approval
5/13/2011	1	Finance Reviewer	Reviewed and Approved
5/13/2011	1	Finance Reviewer	Reviewed and Approved
5/12/2011	1	Utilities Reviewer	Sent for Approval
5/12/2011	1	UTILITIES DIRECTOR	Reviewed and Approved
5/9/2011	1	Utilities Reviewer	Reviewed and Approved
5/9/2011	1	Utilities Drafter	Sent for Approval
5/6/2011	1	Utilities Drafter	Sent for Approval

Explanation

1. BACKGROUND: This ordinance authorizes the Director of Public Utilities to modify and increase the Enterprise Application Integration (EAI) agreement with Brown & Caldwell Ohio, LLC, in the amount of $466,014.00, for the Division of Power and Water.

The Department of Public Utilities (DPU) entered into contract with Brown and Caldwell in May 2010 to determine the Department's level of readiness for an Enterprise Application Integration (EAI) solution. The objective of the project was to look at options that allow software systems to share information to improve access to business data. DPU's goal was to evaluate options for pulling together the essential data DPU staff needed to perform their jobs. Brown and Caldwell Team has been researching and reporting the use of data and information systems and how employees use those systems to support the key business processes. It was determined that the Department of Public Utilities level of readiness is low to moderate due to lack of data consolidation, repetition and cohesive organization.

This modification (No. 1) is to begin to implement improvements of readiness, improve chances of successful EAI implementation, and lower risked associated with lack of data control and organization. The Brown and Caldwell Team will assist DPU in developing a Business Intelligence System (BIS) Pilot. The scope of work will include requirements gathering, prototype development, refinement and deployment of a BIS Pilot as well as assisting in software selection. The BIS Pilot will also include documentation of the system functional requirements in a Software Requirements Specification (SRS). The SRS will include a conceptual database structure and functional requirements of the BIS.

1.1 Amount of additional funds to be expended: $466,014.00
Original Contract Amount: $347,999.58
Modification 1 (current) $466,014.00
Total (Orig. + Mod. 1) $814,013.58

1.2. Reasons additional goods/services co...