TO: Members of the City Council
FROM: Mayor Angela Birney
DEPARTMENT DIRECTOR CONTACT(S):
Executive
Malisa Files
425-556-2166
DEPARTMENT STAFF:
Technology and Information Services
Dawn Johnson
PMO Manager
TITLE:
title
Approval of an Addendum to the Big Four Project: D365 Financial System Upgrade Contract in the Amount of $310,000
OVERVIEW STATEMENT:
recommendation
The contract for implementation of an upgrade to the City's finance system was approved and executed on October 6, 2020 (Attachment B) An addendum (Attachment A) to the original contract is needed and represents a Statement of Work for the development and deployment of a Data Warehouse (DWH). The DWH establishes a means for continued access to legacy financial data and supports consolidated reporting across both historic as well as new financial transactions. While developed and deployed by HSO, the DWH will eventually be incorporated into the City's new Enterprise Data Platform and managed by the City's Enterprise Data Management team.
The DWH work represents a $310,000 increase to the existing HSO contract. This work was planned and budgeted for in the overall D365 Project budget.
body
? Additional Background Information/Description of Proposal Attached
REQUESTED ACTION:
? Receive Information ? Provide Direction ? Approve
REQUEST RATIONALE:
* Relevant Plans/Policies:
The D365 upgrade is one of the Big Four technology projects planned for the next several years along with the City's Workforce Management (WFM) project, records management and Energov upgrades.
* Required:
Historic financial transactional data will not be migrated to the upgraded D365 system. This DWH will provide continued and necessary access to the data and should be in place in June of 2021 when the City transitions from Dynamics 2012 to D365.
* Council Request:
N/A
* Other Key Facts:
The Statement of Work references a Phase 1a of the DWH work. This work was completed under an HSO support and maintenance cont...
Click here for full text