Detroit Water and Sewerage Department
File #: 17-0014    Version: 1 Name:
Type: Contract Status: Passed
In control: Information Technology and Services
On agenda: 2/15/2017 Final action: 2/15/2017
Title: The Board of Water Commissioners for the City of Detroit, Water and Sewerage Department authorizes the Director to approve a purchase order in the amount not to exceed $387,327.00 to Oracle Corporation for Annual Software Maintenance for Oracle's WAM and Advanced Security Services, and also authorizes the Director to take such other action as may be necessary to accomplish the intent of this vote.
Indexes: Board of Water Commissioners

Title

The Board of Water Commissioners for the City of Detroit, Water and Sewerage Department authorizes the Director to approve a purchase order in the amount not to exceed $387,327.00 to Oracle Corporation for Annual Software Maintenance for Oracle’s WAM and Advanced Security Services, and also authorizes the Director to take such other action as may be necessary to accomplish the intent of this vote.

 

Body

Agenda of February 15, 2017

Item No. 17-0014

Amount: $387,327.00

 

TO:                                          The Honorable

                                          Board of Water Commissioners

                                          City of Detroit, Michigan

 

FROM:                           Gary Brown, Director

                                          Water and Sewerage Department

 

RE:                                          Annual Software Maintenance for Oracle’s WAM and Advanced Security Services ($387,327)

 

MOTION

Upon recommendation of Daniel A. Rainey, Chief Information Officer, the Board of Water Commissioners for the City of Detroit, Water and Sewerage Department authorizes the Director to approve a purchase order in the amount not to exceed $387,327.00 to Oracle Corporation for Annual Software Maintenance for Oracle’s WAM and Advanced Security Services and also authorizes the Director to take such other action as may be necessary to accomplish the intent of this vote.

 

JUSTIFICATION

DWSD installed Oracle WAM under CS-1476 and went live in July 2014. Enhancements that permitted DWSD and The Great Lakes Water Authority (GLWA) to maintain their own assets within the same system were then implement in June 2016. Today WAM serves as the core operations software package for both DWSD and the GLWA, where it is used to manage and record work orders and service requests, perform asset management functions, control inventory and manage procurement. Without this critical system, both the DWSD and GLWA would have material difficulty running day to day operations.

 

In the spring of 2016 DWSD changed its primary billing method to “by person” from “by street address” and began keeping track of specific customer information in order to facilitate that change. Oracle’s Advanced Security Services enables DWSD to protect that personally identifiable information by providing data encryption for the customer information file and the billing system.

 

 

BACKGROUND

Oracle Work and Asset Management (WAM) is a critical software package used by both the DWSD and the GLWA. Without this software, both organizations would have a very difficult time handling day to day activities like maintaining inventory, creating work orders, managing fixed and linear assets and issuing and receiving requisitions for goods and services.

 

WAM software maintenance makes up $379,742.00 of the Oracle costs with the Advanced Security functions totaling $7,585.00. Under an Information Technology Shared Services Agreement, DWSD will charge the GLWA a 60 percent allocation of the $379,742.00, or $227,845.00, for its share of the WAM maintenance, leaving $151,897.00 as DWSD’s share.

 

The net cost to DWSD for FY2017 for WAM software maintenance will be $157,897.00.

This item was reviewed by the Finance Committee on February 8, 2017 and is a budgeted O&M item.