GT MCTO AMENDMENT 12V.6 - SOW.PDF

Maricopa County — Formal (2021-07-14)

View PDF Item 107 Meeting page

Extracted text (via pymupdf_layout) 8298 characters
AMENDMENT No. #12
To
TREASURER INFORMATION SYSTEM (TIS) CONSULTANT
SERIAL NO. 13123-RFP
Between
Grant Thornton, LLP
&
Maricopa County, Arizona
WHEREAS, Maricopa County, Arizona (“County”) and Grant Thornton, LLP
(“Contractor or Consultant”) have entered into a Contract for a Treasurer Information System
(TIS) Consultant dated February 26, 2014 (“Agreement”) and effective February 26, 2014 under
County Contract No. 13123-RFP.
WHEREAS, the parties agreed to Amendment No. 1 effective February 18, 2015 replacing
Exhibit A, B and D with a “NEW” Exhibit A, B and D;
WHEREAS, the parties agreed to Amendment No. 2 effective May 9, 2016 renewing the
contract terms; replacing Exhibit A, B with a “NEW” Exhibit A, B; and replacing Exhibit D with
a revised Exhibit D;
WHEREAS, the parties agreed to Amendment No. 3 effective February 31, 2017 for the
engagement of a resource assessment and staffing plan;
WHEREAS, the parties agreed to Amendment No. 4 effective March 22, 2017 renewing
the contract terms; replacing Exhibit A, B with a “NEW” Exhibit A, B; and replacing Exhibit D
with a revised Exhibit D;
WHEREAS, the parties agreed to Amendment No. 5 effective February 22, 2018 renewing
the contract terms; replacing Exhibit A, B with a “NEW” Exhibit A, B;
WHEREAS, the parties agreed to Amendment No. 6 effective May 7, 2018 for Sympro
design, set-up and testing;
WHEREAS, the parties agreed to Amendment No. 7 effective May 7, 2018 to review,
assessment and recommended updates to requirements, data maps and other processes;
WHEREAS, the parties agreed to Amendment No. 8 effective October 2, 2018 to revise
the travel budget;
WHEREAS, the parties agreed to Amendment No. 9 effective April 30, 2019 to adding
additional project resources;
WHEREAS, the parties agreed to Amendment No. 10 effective July 1, 2019 renewing the
contract terms and increasing the scope of services, adding additional resources and
extending the timeline.

WHEREAS, the parties agreed to Amendment No. 11 effective upon signing by both
parties, increasing the scope of services, and adding additional resources.
WHEREAS, County and Contractor have agreed to further modify the Agreement by
changing certain terms and conditions;
NOW, THEREFORE, in consideration of the foregoing, and for other good and valuable
consideration, receipt of which is hereby acknowledged, the parties hereto agree as follows:
1. Exhibit A
Revise Exhibit A based on the additional scope of work per attached Exhibit B-1
2. Exhibit B-1
Revise Exhibit B-1 based on the adjustments made per attached
ALL OTHER TERMS AND CONDITIONS REMAIN UNCHANGED.
IN WITNESS WHEREOF, this Contract Amendment is executed on the date set forth when
executed by Maricopa County.
CONTRACTOR:
Authorized Signature
Graeme Finley, Principal
Printed Name and Title
______________________ 7/8/21
Date
MARICOPA COUNTY:
Chairman, Board of Supervisors
Date

ATTESTED:
Clerk of the Board
Date
OFFICE OF TREASURER:
Treasurer
Date
APPROVED AS TO FORM:
Deputy County Attorney
Date

EXHIBIT A
PRICING
REVISED Phase IV Price per Deliverable and
Labor Pricing
The amendment will shift funds from the Technical Assessment Architect & Support project to
the Phase IV SI Support & Oversight Project. It will add 1 quarterly Quality Management
Activity Reports (June-Sep) at no cost ($0.00) per report. Overall total cost of project will remain
unchanged.
Phase Pricing:
Phase Labor Travel Total
II: Solution Options and $218,743.44
Verification
$57,674.69
III: Solution Funding, $259,743.50
Procurement, and Selection
IV: Data Quality Analysis $488,573.19 $35,000.00
Original Contract Totals: $967,060.13 $92,674.69 $1,059,734.82
IV: Initial Data Quality $449,845.60 $35,542.22
Remediation & Deep Dive
Amendment #1 Subtotal: $1,416,905.73 $128,216.91 $1,545,122.64
IV: Solution Implementation $3,255,876.00
Support
$400,000.00
IV: Solution Implementation $1,072,452.44
Oversight
Amendment #2 Subtotal: $4,328,328.44 $400,000.00 $4,728,328.44
Resource Assessment & Staffing $11,022.60 $0.00
Plan
Amendment #3 Subtotal: $11,022.60 $0.00 $11,022.60
IV: Solution Implementation $820,458.98
Support
-$250,000.00
IV: Solution Implementation $370,631.02
Oversight
Amendment #4 Subtotal: $ 1,191,090.00 -$250,000.00 $941,090.00
Amendment #5 Subtotal: $ - $ - $ -
Out of Scope Items $107, 011.08
Bridge Period Support $436,138.00
Amendments #6 and 7 $543,149.08 $543,149.08
Subtotal:
Travel Reduction -$122,542.00
Amendment #8 Subtotal: -$122,542.00 -$122,542.00
Database Development,
Technical Assessment, $145,800.00
Architectural & Support

Amendment #9 Subtotal: $145,800.00 $145,800.00
IV: Solution Implementation $2,894,100.00
Support
IV: Solution Implementation $1,591,500.00
Oversight
IV: Technical Assessment, $679,904.00
Architectural & Support*
Amendment #10 Subtotal: $5,165,504.00 $5,165,503.00
IV. Solution Implementation -$37,592.62
Support
Travel Increase $37,592.62
Amendment #11 Subtotal: -$37,592.62 $37,592.62 $
Amendment #12 Subtotal: $ - $ - $ -
Amendment Contract Totals: $12,764,206.23 $193,266.53 $12,957,473.76
Period of Performance:
June 1, 2021 to September 30, 2021
REVISED Labor Pricing
Revised Revised Period of
Labor Role
Rate Performance
Project Manager $145.00 7/1/2019 to 10/31/2022
Project Coordinator $115.00 7/1/2019 to 10/31/2022
Testing Manager $145.00 7/1/2019 to 10/31/2022
QA Manager $118.00 6/1/2021 to 9/30/2021
Data Analyst Lead $148.00 7/1/2019 to 5/31/2021
Database Developer $122.00 7/1/2019 to 6/30/2022
Reports Analyst / Aumentum Database Analyst $90.00 7/1/2019 to 11/30/2020
Solution Architect $170.00 T&M
Senior Business Analyst $113.00 T&M
Cobol Programmer $96.00 9/1/2020 to 12/31/2021
REVISED Hours by Category
Labor Category Hours
Project Management Services 13,957
Test Management 6,436
Data Analysis & Reporting 6,916

Database Development 6,423
Solution Architecture Services 5,633
Total Project Hours 39,362
EXHIBIT B-1
ADDITIONAL SCOPE OF WORK
1.0 INTENT:
The purpose of this exhibit is to extend a resource, the timeline of Grant Thornton overall
services and scope are modified to add the additional responsibilities. The afore-
mentioned changes will net zero adjustments to the total contract amounts for the Grant
Thornton budget for the Phase IV Implementation in the ULTIS project.
2.0 SCOPE OF WORK:
The scope of services to be completed by Grant Thornton in the Phase IV will increase
from amendment 11.
The overall timeline for services provided by Grant Thornton will remain the same.
Background
MCTO is beginning technical work on the replacement of the property tax management
system. There is a need for a rigorous, organized and end to end testing and quality
assurance process.
Activities may include:
• Executes Data Migration activities
• Executes Quality Management activities
• Work with MCTO QA resources to provide a documented, structured approach to
Quality Assurance
• Defines scope and creates a plan for system testing, integration testing and user
acceptance testing
• Deploys and manages resources for testing
• Provide Quality Assurance metrics and reporting for accountability and
measurability

• Communicates with stakeholders to keep them appraised of quality concerns and
issues through reporting and standard communication methods- i.e., meetings
• Analyze data related to defects, process issues and provide recommendations
for improvement
• Evaluates and recommends tools, methodologies and automation to ensure
effective end to end testing and identification of defects.
• Recommends and supports as needed configuration management processes
and release management processes
• Validation that MCTO standards and practices are being followed and met
• Identification of challenges that may put the project at risk and provide
recommendations to resolve deficiencies
Estimated Timeline
The original timeline described in Amendment #11 is under review by MCTO. Any
changes to the timeline by MCTO and approved change orders may impact the Scope of
Work and project timeline. This amendment extends the Quality Assurance Manager
through 9/30/2021.
3.0 Deliverables
Grant Thornton will produce the following deliverables in accordance to the frequency
and/or project milestones identified in Exhibit A.
• 1 quarterly Quality Management Activity Report (June-Sep) at no cost ($0.00) per
report.