City of Columbus - File #: 1539-2006

• File #: 1539-2006
• Version: 1
• Type: Ordinance
• Status: Passed
• File created: 8/30/2006
• In control: Utilities Committee
• On agenda: 10/23/2006
• Final action: 10/25/2006
• Title: To authorize the Director of Public Utilities to enter into an agreement with Woolpert Inc for consulting services for the Enterprise Application Integration for the Division of Operational Support, to authorize the expenditure of $102,452.22 from the Sewerage System Operating Fund, $103,887.12 from the Water Operating Fund, $75,189.02 from the Storm Sewer System Operating Fund and $5,452.64 from the Electricity Operating Fund . ($286,981.00)

Date	Ver.	Action By	Action	Result
10/25/2006	1	CITY CLERK	Attest
10/24/2006	1	MAYOR	Signed
10/23/2006	1	Columbus City Council	Approved	Pass
10/23/2006	1	COUNCIL PRESIDENT	Signed
10/16/2006	1	Columbus City Council	Read for the First Time
9/26/2006	1	Utilities Drafter	Sent to Clerk's Office for Council
9/25/2006	1	ODI DIRECTOR	Reviewed and Approved
9/25/2006	1	Utilities Drafter	Sent for Approval
9/25/2006	1	Auditor Reviewer	Reviewed and Approved
9/25/2006	1	CITY AUDITOR	Reviewed and Approved
9/25/2006	1	Utilities Drafter	Sent for Approval
9/25/2006	1	CITY ATTORNEY	Reviewed and Approved
9/18/2006	1	EBOCO Reviewer	Reviewed and Approved
9/13/2006	1	FINANCE DIRECTOR	Reviewed and Approved
9/13/2006	1	Utilities Drafter	Sent for Approval
9/12/2006	1	Utilities Drafter	Sent for Approval
9/12/2006	1	Finance Reviewer	Reviewed and Approved
9/12/2006	1	Finance Reviewer	Reviewed and Approved
9/11/2006	1	UTILITIES DIRECTOR	Reviewed and Approved
9/7/2006	1	Utilities Reviewer	Sent for Approval
8/30/2006	1	Utilities Drafter	Sent for Approval

Explanation

The purpose of this legislation is to authorize the Director of Public Utilities to enter into an agreement with Woolpert Inc. for consulting services for the Enterprise Application Integration.

The purpose of the Enterprise Application Integration project, as highlighted in section 6.8 Integration Strategy of the Technology Master Plan for the City of Columbus, Department of Public Utilities (DPU), is to develop and implement a department wide integration strategy to facilitate the information exchange between DPU computer systems and data repositories.

The goals of this project are to identify and eliminate data silos and overlapping or redundant data. This project will integrate existing computer applications and business functions to form an enterprise architecture of solutions and shared data sources focused on optimizing operational efficiencies and improving customer service. This information management environment will leverage new and existing technologies to support and further promote best business practices as well as IT development and operational standards within DPU.

Phase I of this project will include reviewing critical business processes; reviewing existing computer systems, data and software integrations; performing system integration workshops; developing software and data standards to support integration; defining database design and metadata standards; creating a
comprehensive integration management plan.

Phase 2 of this project will include the implementation of the comprehensive integration management plan in a phased approach over several years to integrate all of the Department data and systems.

Phase 1 Schedule
Task Description Time
Task No. 1 Project Administration and Communication 140 Days
Task No. 2 Enterprise Architectural Development 49 Days
Task No. 3 Standards Development 34 Days
Task No. 4 Enterprise Database Design and Metadata Recommendations 15 Days
Task No. 5 Final Integration-Management ...