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 Plan 7 Days
Total Time: 140 Days
Phase 2 Schedule
The schedule for phase 2 will be developed as part of the Phase 1, Task 5 Final Integration-Management Plan.
FISCAL IMPACT: $286,981.00 is needed for Phase 1 of this project.
SUPPLIER: Woolpert Inc (20-1391406)
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)
Body
WHEREAS, the City of Columbus, Department of Public Utilities (DPU) is preparing to integrate existing computer applications and business functions to form an enterprise architecture of solutions and shared data sources focused on optimizing operational efficiencies and improve 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 as part of the Department of Public Utilities Techology Master Plan, and
WHEREAS, 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 standards and creating a comprehensive integration management plan, and
WHEREAS, Phase 2 of this project will be developed upon completion of Phase 1, and
WHEREAS, the Director of Public Utilities received proposals on March 9, 2006, eight (8) proposals were received, and
WHEREAS, after review of the proposals an evaluation committee selected Woolpert Inc, now, therefore
BE IT ORDAINED BY THE COUNCIL OF THE CITY OF COLUMBUS:
Section 1. That the Director of Public Utilities be and is hereby authorized to enter into an agreement with Woolpert, Inc. for consulting services for the Enterprise Application Integration for the Division of Operational Support.
Section 2. That the expenditure of $286,981.00 or so much thereof as may be needed, be and the same hereby is authorized as follows:
FUND: 650
OCA: 605006
OBJECT LEVEL 1: 03
OBJECT LEVEL 3: 3326
AMOUNT: $102,452.22
FUND: 600
OCA: 601849
OBJECT LEVEL 1: 03
OBJECT LEVEL 3: 3326
AMOUNT: $103,887.12
FUND: 675
OCA: 675002
OBJECT LEVEL 1: 03
OBJECT LEVEL 3: 3326
AMOUNT: $75,189.02
FUND: 550
OCA: 600700
OBJECT LEVEL 1: 03
OBJECT LEVEL 3: 3326
AMOUNT: $5,452.64
TOTAL AMOUNT: $286,981.00
Section 3. That this Ordinance shall take effect and be in force from and after the earliest period allowed by law.