City of Columbus - File #: 0958-2007

• File #: 0958-2007
• Version: 1
• Type: Ordinance
• Status: Passed
• File created: 6/7/2007
• In control: Administration Committee
• On agenda: 7/9/2007
• Final action: 7/11/2007
• Title: To authorize the Director of Finance and Management, on behalf of the Department of Technology, for the Department of Public Utilities, to establish a purchase order with Mythics Corporation for the purchase of Oracle software licenses and support for the WASIMS and electricity billing; to authorize the expenditure of $109,274.86 from the Sewerage System Operating Fund, $78,920.72 from the Stormwater Operating Fund, $6,070.82 from the Electricity Operating Fund, $109,274.86 from the Water Operating Fund; and to declare an emergency. ($303,541.26)

Date	Ver.	Action By	Action	Result
7/11/2007	1	CITY CLERK	Attest
7/10/2007	1	MAYOR	Signed
7/9/2007	1	Columbus City Council	Approved
7/9/2007	1	COUNCIL PRESIDENT	Signed
6/25/2007	1	Auditor Reviewer	Reviewed and Approved
6/25/2007	1	CITY AUDITOR	Reviewed and Approved
6/25/2007	1	Technology Drafter	Sent for Approval
6/25/2007	1	CITY ATTORNEY	Reviewed and Approved
6/25/2007	1	Technology Drafter	Sent to Clerk's Office for Council
6/22/2007	1	Finance - Purchasing Reviewer	Reviewed and Approved
6/22/2007	1	FINANCE DIRECTOR	Reviewed and Approved
6/22/2007	1	Technology Drafter	Sent for Approval
6/20/2007	1	Finance Reviewer	Reviewed and Approved
6/20/2007	1	Finance Reviewer	Reviewed and Approved
6/19/2007	1	Technology Drafter	Sent for Approval
6/18/2007	1	Finance Reviewer	Reviewed and Approved
6/18/2007	1	Finance Reviewer	Sent for Approval
6/18/2007	1	Finance Reviewer	Reviewed and Disapproved
6/14/2007	1	UTILITIES DIRECTOR	Reviewed and Approved
6/14/2007	1	Technology Drafter	Sent for Approval
6/13/2007	1	Utilities Reviewer	Sent for Approval
6/12/2007	1	ODI DIRECTOR	Reviewed and Approved
6/12/2007	1	Technology Drafter	Sent for Approval
6/11/2007	1	Technology Drafter	Sent for Approval
6/11/2007	1	EBOCO Reviewer	Sent for Approval
6/8/2007	1	Technology Drafter	Sent for Approval
6/8/2007	1	TECHNOLOGY DIRECTOR	Reviewed and Approved

Explanation
The purpose of this legislation is to authorize the Director of Finance and Management to enter into contract with Mythics Corporation for the purchase of Oracle software licenses and support, for the Department of Technology on behalf of the Department of Public Utilities. These software licenses and support are required for the planned upgrade of the Banner platform which supports the WASIMS (Water and Sewer information Management System) application and the electricity billing system.

The current WASIMS system was implemented in 1999 and was implemented only to support the billing of City water, sewer and stormwater customers. This system is old, outdated, and is very limited in that special software must be used to access and use the system. Additionally, the current electricity billing system is older than the WASIMS system and is in need of an upgrade. The overall upgrade to WASIMS, including these related Oracle licenses and support services, will allow the Department of Public Utilities to move to a system that will allow citizen access to their own billing information through the internet; allow DPU to maintain and manage one billing system by retiring the current electricity billing system and replace it with the upgraded WASIMS system.

This purchase will allow the Department of Technology, on behalf of the Department of Public Utilities, to implement and install planned upgrades and related services to the existing systems, of which the WASIMS is currently supported by Ventyx. Also, this purchase is in alignment with the Department of Public Utilities' Technology Master Plan; which recommends that the Department of Public Utilities standardize on one billing system for both water and electric power services.

Without the upgrades, licenses and support, the current systems will remain difficult to access and use, which may cause for potential failure of the current electric billing system; thus creating a negative impact...