Share to Facebook Share to Twitter Bookmark and Share
File #: 21-0980    Name: Change Order with Sierra-Cedar, LLC
Type: Resolution Status: Approved
In control: City Council Regular Meeting
On agenda: 11/2/2021 Final action: 11/2/2021
Title: Consider/Discuss/Act on a Resolution Authorizing the City Manager to Execute a Change Order with Sierra-Cedar, LLC to Engage Premier International for City Data Conversion Responsibilities in the Oracle ERP Cloud Implementation
Attachments: 1. Resolution, 2. Change Order
Title
Consider/Discuss/Act on a Resolution Authorizing the City Manager to Execute a Change Order with Sierra-Cedar, LLC to Engage Premier International for City Data Conversion Responsibilities in the Oracle ERP Cloud Implementation

Summary

COUNCIL GOAL: Operational Excellence

MEETING DATE: November 2, 2021

DEPARTMENT: Information Technology

CONTACT: Sid Hudson, Chief Information Officer


RECOMMENDED CITY COUNCIL ACTION:
* Approval of the Resolution

ITEM SUMMARY:
* This resolution authorizes the City Manager to execute a change order with Sierra-Cedar to engage Premier International for city data conversion responsibilities in the Oracle ERP cloud implementation. Additionally, this change order will approve a (3) month extension to the Sierra Cedar resources that have been allocated to this conversion effort. This includes, but is not limited to, extracting Naviline AS/400 data and converting to the format specified in the Oracle technical specifications. In addition, the extracted data will be cleansed/transformed to be inserted into predefined Oracle templates to be loaded into the Oracle cloud application.

BACKGROUND INFORMATION:
* The Oracle ERP Cloud Applications is inclusive of ERP (Financials, Procurement, and Projects/Grants) as well as HCM (Core HR, Time, Absence, Payroll, Performance) data objects for conversion from the Naviline application to Oracle Cloud Applications. McKinney staff completed much of the development for the HCM data objects but is still encountering data quality and integrity issues. Premier will not develop automated conversion programs to generate HCM load files. Instead, Premier will leverage the extract/load files generated by McKinney staff for HCM to develop, test, and run custom cleansing reports as directed by the McKinney team to help identify and correct issues identified during loads to comply with Oracle standards. For ERP conversion objects, Premier will be responsible for extracting, profiling, a...

Click here for full text