The Chief Information Officer recommends that City Council approve an ordinance to appropriate $2,385,000.00 from the Equipment Acquisition Consolidated Fund (1800) for the HITS Enterprise Application Support Services division. These appropriations are budgeted in the approved FY19 Capital Improvement Plan adopted by City Council.
The project descriptions will allocations are as follows:
PROJECT PROJECT NO. AMOUNT
1. Legacy Application Redesign X-680039 $300,000.00
Update several legacy applications that are end of life or need an update to meet current and future departmental and City needs. Several City of Houston legacy applications require immediate improvement to ensure that they can continue to properly function and deliver the needed software services. HITS is currently working with Strategic Purchasing Division (SPD) and based off vendor selection will return to Council for spending approval, as appropriate.
2. SAP Grievance Tracking and Filing X-800003 $50,000.00
Utilize the SAP grievance tracking system currently available in SAP. This module will allow all the data to be entered into one system for all steps of the grievance process and eliminate duplication of data. This process will reduce record retention expenses as well as employee travel time. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
3. Enterprise Data Warehouse & Analytics X-680048 $400,000.00
Creation of a centralized Enterprise Data and Analytical Center(EDAC) will support strategic planning, implementation and maintenance of the data warehouse and analytical environment; as well as other department initiatives that will upgrade and improve current applications. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
4. Master Data Management X-680040 $259,000.00
Establishment of a Master Data Management (MDM) strategy that will allow HITS to roadmap, design, implement MDM in the Enterprise Data Management platform which will work with all enterprise applications in the city to create a single version of all data. The objective is to streamline and create a single version of data that can be used consistently citywide. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
5. Benefit Data Warehouse/Aggregator X-800007 $200,000.00
Develop and implement an application that will allow employees to remotely enroll and track health benefits. This application will streamline the process as well as integrate with SAP. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
6. SAP CIP Enhancements X-640001 $51,000.00
provides improvements to the Capital Improvement Plan (CIP) transaction codes in SAP to include multi-profile WBS numbers, tracking posted budgets and business objects reporting. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
7. Business Warehouse Implementation X-680014 $525,000.00
Replacement for Rapid Marts which is no longer supported by SAP and will be replaces by SAP Business Warehouse. Business warehouse is a combination of databases and database management tools that are used to support management decision making with accurate information. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending approval, as appropriate.
8. Application Performance Testing Tools X-680012 $200,000.00
Allows for application testing automation tools to increase delivery confidence and minimize risk of incomplete testing due to limited resources. Will provide increase accuracy and productivity. HITS is currently working with Strategic Purchasing Division (SPD) and dependent upon vendor selection will return to Council for spending authority, as appropriate.
9. SAP Tools Optimization X-680026 $400,000.00
Minimize risks associated with implementation of SAP system modifications by implementing two previously purchased SAP products; Transport Manager and Change & Release Manager.
Fiscal Note
Funding for these items is included in the FY2019 Capital Improvement Plan budget.
__________________________________________
Lisa Kent, Chief Information Officer