HomeMy WebLinkAboutAgreement A-25-312 Second Amendment to Agreement with CalSAWS Consortium.pdf Agreement No. 25-312
California Statewide Automated Welfare
System (CaISAWS)
County Purchase FR-02-2024
Fresno County - Request for Purpose-Built,
Curated Data Set ("PBDS") Access in CaISAWS
Amazon Simple Storage Solution ("Amazon S3")
Location - Revision 2
Page I of 9 CaISAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docxCaISAWS County Purchase FR-02-2024
PBDS-Revision 2 convert to PDF.docx
Ca1SAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
I. Overview:
Pursuant to Section 4.6 of Exhibit X (Maintenance and Operations ("M&O") Extension) of the
Amended Restated and Revised Leader Replacement System Agreement dated August 16,2019
(the"Base Agreement")between Ca1SAWS Consortium and Accenture LLP ("Accenture"),Fresno
County ("County") has requested access to the County's data within the purpose-built,curated
data set ("PBDS") that currently resides in a Ca1SAWS Amazon Simple Storage Solution("Amazon
SY) location,as further described in this County order form(the"County Purchase").
The scope of Revision 2 to this County Purchase is to update Section III (the"Assumptions") and
Section V(the"Total Charges") to revise the recurring R&A Change Budget Services as follows:
• Extend the schedule for batch job execution support,refactoring support,Application
Architecture support, and Application Database Administration("DBA") support to
continue beyond July 31,2025.
There was an overall increase to the Total Charges included in Revision 2 to this County Purchase.
II. Scope:
The County identified a business need for Accenture to provide access to the PBDS to help meet
data and reporting goals after the County's migration to the Ca1SAWS System. This County
Purchase describes the Regulatory and Administrative ("R&A") Change Budget Services for
Accenture to provide technical consulting support to build the related infrastructure for,provide
access to,and support the County's egress of Ca1SAWS purpose-built data within Amazon S3.
The one-time R&A Change Budget Services include up to 1,820 hours to assist the County with the
following:
• Vending a new Amazon Web Services ("AWS") account for the County within the CaISAWS
main AWS account;
• Building and maintaining the infrastructure to support a copy of the County's data in
Amazon S3;
• Configuring the County-specific batch jobs to partition and store the data;
• Creating and configuring Amazon Glue Crawlers to organize the data;
• Providing access to individual users and/or service accounts within the County;
• Enabling Amazon Athena Console,Open Database Connectivity ("ODBC"), and Java
Database Connectivity ("JDBC") access for users and service accounts;
• Providing serverless architecture to ingest PBDS data into the County's AWS account;
• Providing a relational database for querying purpose-built data;
• Testing of individual jobs and validation of data subset;
• Providing documentation as requested by the County,which may include system diagrams,
presentation materials, or other documentation.
Page 2 of 9 Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docxCaISAWS County Purchase FR-02-2024 PBDS-Revision 2
convert to PDF.docx
CaISAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
• Support for connection/tool setup,query tuning,partition tuning,enhancements,and
training,which are optional, and an estimate of 400 hours has been included in this County
Purchase. Accenture will work with the County to develop a schedule for this support
should the County elect to use these hours.
This County Purchase also includes one-time R&A Change Budget Services of up to 60 hours for
administration of the County Purchase order. This includes management of the County Purchase
work plan,coordination with CaISAWS teams and the County,tracking of the County Purchase
progress, and providing status updates.
This County Purchase includes up to 160 hours per month for recurring R&A Change Budget
Services for Accenture staff to assist the County with providing batch job execution support as
needed and providing refactoring support,Technical Architecture and Operational support,DBA
support,Application Architecture support,and Application DBA support for changes that affect
the PBDS as follows:
• As part of the CaISAWS release process,provide up to twenty(20) hours per month for
batch job execution support.Specifically,when updates to the CaISAWS System impact
County-specific batch jobs configured as part of the scope of this County Purchase.
• Providing infrastructure support for AWS issues,configuration,Technical Operations,and
Technical Architecture for changes that affect the PBDS-estimated up to twenty(20) hours
per month.
• Providing DBA support for changes that are required as part of the CaISAWS process or
identified by the County or CaISAWS, estimated up to twenty (20) hours per month.
• Resolving and updating CaISAWS jobs that filter down to County-specific jobs that can
either be affected by Ca1SAWS defects or from other System Change Requests ("SCRs')
modifying the County data,estimated up to eighty (80)hours per month.
• Providing Application Architecture support for changes that affect the PBDS (such as
architectural changes relating to Reports releases,version upgrades, or data growth),
estimated up to ten (10) hours per month.
• Providing Application DBA support for changes that affect the PBDS,estimated up to ten
(10) hours per month.
This County Purchase also includes recurring R&A Change Budget Services of up to twenty (20)
hours per month for administration of the County Purchase order. This includes management of
the County Purchase work plan,coordination with CaISAWS teams and the County,tracking of the
County Purchase progress,and providing status updates.
The scope of this County Purchase includes the following:
• One-Time R&A Change Budget Services
• Recurring R&A Change Budget Services
Page 3 of 9 CaISAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
CaISAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
III. Assumptions:
• The charges set forth in Section V below (the"Total Charges') are based on the scope of
work outlined in this County Purchase. Any changes in scope must be mutually agreed
upon by Accenture and the County in writing and may result in additional charges. These
additional charges will be executed as a revision to this County Purchase.
• One-Time R&A Change Budget Services will be worked and invoiced on a time and
materials ("T&M") basis up to a maximum of 1,880 hours. Invoices for such charges will be
submitted to the Consortium monthly in arrears,and the Consortium will,in turn,invoice
the County. The County will be invoiced for actual hours worked.
o Up to 1,880 hours will be worked and invoiced in State Fiscal Year ("SFY") 2024/25,
estimated to commence August 1,2024 pending approval of this County Purchase,
and continue through the expiration of the Technical Infrastructure Services Base
Agreement (currently January 31,2025).
o If the County requests more hours for SFY 2024/25 prior to the expiration of the
Technical Infrastructure Services Base Agreement(currently January 31,2025), a
revision to this County Purchase would be required. If the County requires services
beyond the expiration of the Technical Infrastructure Services Base Agreement, a
new County Purchase will be required under a new CaISAWS agreement.
o If the County requests offshore/onshore staffing mix changes, then a revision to this
County Purchase would be required.
o This estimate for one-time R&A Change Budget Services excludes hours to support
activities that may be required to continue services beyond the expiration of the
Technical Infrastructure Services Base Agreement(currently January 31,2025).
o If the County causes delays that Accenture reasonably understands may extend the
schedule for the work outlined in this County Purchase beyond the expiration of the
Technical Infrastructure Services Base Agreement (currently January 31,2025),the
work shall be placed on hold until a new County Purchase is executed under a new
CaISAWS agreement. Accenture will be entitled to receive payment for full or partial
work performed under this County Purchase.
o Accenture and County will monitor the hours for R&A Change Budget Services and
discuss the addition of more hours with the County if necessary. Any additional
hours required for R&A Change Budget Services would result in additional charges.
Any additional charges will be provided to the County in a separate County
Purchase.
• Recurring R&A Change Budget Services will be worked and invoiced on a T&M basis.
Invoices for such charges will be submitted to the Consortium monthly in arrears, and the
Consortium will,in turn,invoice the County.The County will be invoiced for actual hours
worked. These charges are based on an estimate of 180 hours of support per month.
o Recurring R&A Change Budget Services continuing beyond July 31,2025 included in
Revision 2 to this County Purchase are contingent upon the extension of the Base
Agreement beyond the current term of the Base Agreement (July 31,2025).
■ In the event that the extension to the Application Development Services Base
Agreement is not approved,Accenture will stop all Work as of the expiration
Page 4 of 9 CaISAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
Ca1SAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
date of the Base Agreement,and recurring R&A Change Budget Services
included in this County Purchase beyond the expiration of the Base
Agreement will be considered null and void. The Work included in this
County Purchase will be placed on hold until a new County Purchase is
executed under a new Ca1SAWS agreement.Accenture will be entitled to
receive payment for full or partial Work performed under this County
Purchase.
o Recurring R&A Change Budget Services for infrastructure support for AWS issues,
configuration,Technical Operations and Technical Architecture support,and DBA
support are estimated to commence January 1,2025 and continue through the
expiration of the Technical Infrastructure Services Base Agreement(currently
January 31,2025).
■ If the County requests more hours for SFY 2024/25 prior to the expiration of
the Technical Infrastructure Services Base Agreement, a revision to this
County Purchase would be required. If the County requires services beyond
the expiration of the Technical Infrastructure Services Base Agreement,a new
County Purchase will be required under a new Ca1SAWS agreement.
o Recurring R&A Change Budget Services for providing batch execution support and
refactoring support are estimated to commence January 1,2025 and continue
through January 31,2026, subject to the approval of the extension of the Base
Agreement.
■ If the County requests more hours for SFY 2024/25 or 2025/26 prior to the
expiration of the Application Development Services Base Agreement,a
revision to this County Purchase would be required. If the County requires
services beyond the expiration of the Application Development Services Base
Agreement, a new County Purchase will be required under a new Ca1SAWS
agreement.
o Recurring R&A Change Budget Services for providing Application Architecture
support and Application DBA support are estimated to commence February 1,2025
and continue through January 31,2026, subject to the approval of the extension of
the Base Agreement.
■ If the County requests more hours for SFY 2024/25 or 2025/26 prior to the
expiration of the Application Development Services Base Agreement,a
revision to this County Purchase would be required. If the County requires
services beyond the expiration of the Application Development Services Base
Agreement,a new County Purchase will be required under a new CaISAWS
agreement.
o Recurring R&A Change Budget Services for administration of the County Purchase
order are estimated to commence November 1,2024 and continue through January
31,2026, subject to the approval of the extension of the Base Agreement.
■ If the County requests more hours for SFY 2024/25 or 2025/26 prior to the
expiration of the Application Development Services Base Agreement,a
revision to this County Purchase would be required. If the County requires
services beyond the expiration of the Application Development Services Base
Page 5 of 9 Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
Ca1SAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
Agreement,a new County Purchase will be required under a new Ca1SAWS
agreement.
o Up to 760 hours will be worked and invoiced in SFY 2024/25,not to commence prior
to January 1,2025, and continue through the end of SFY 2024/25,May 31,2025. If the
County requests more hours for SFY 2024/25,a revision to this County Purchase
would be required.
■ If the County requests such work to begin earlier than January 1,2025,then
additional recurring R&A Change Budget Services would be required. Such
charges would be provided to the County as a revision to this County
Purchase.
o Up to 1,120 hours will be worked and invoiced in SFY 2025/26,estimated to
commence June 1,2025 and continue through January 31,2026,subject to the
approval of the extension of the Base Agreement. If the County requests more hours
for SFY 2025/26 prior to the expiration of the Application Development Services
Base Agreement, a revision to this County Purchase would be required. If the
County requires services beyond the expiration of the Base Agreement, a new
County Purchase will be required under a new Ca1SAWS agreement.
o If the County requests offshore/onshore staffing mix changes,then a revision to this
County Purchase would be required.
o This estimate for recurring R&A Change Budget Services excludes hours to support
activities that may be required to continue services beyond the expiration of the Base
Agreement.
o If the County causes delays that Accenture reasonably understands may extend the
schedule for the work outlined in this County Purchase beyond the expiration of the
Base Agreement,the work shall be placed on hold until a new County Purchase is
executed under a new Ca1SAWS agreement. Accenture will be entitled to receive
payment for full or partial work performed under this County Purchase.
o Accenture and County will monitor the hours for recurring R&A Change Budget
Services and discuss the addition of more hours with the County if necessary. Any
additional hours required for recurring R&A Change Budget Services would result
in additional charges.These additional charges would be provided to the County in
a separate County Purchase. If a Ca1SAWS change impacts this County Purchase so
that the work effort needed to adapt the PBDS exceeds the budget in this County
Purchase,a separate County Purchase would be required.
• Accenture will work with the County to develop a schedule for this project upon approval
of this County Purchase.
o Revision 2 to County Purchase FR-02-2024 must be approved by July 18,2025 in
order for recurring R&A Change Budget Services for batch job execution support,
refactoring support,Application Architecture support, and Application DBA
support to continue beyond July 31,2025. If the County does not approve this
County Purchase by July 18,2025,the schedule for the delivery for the work outlined
in this County Purchase will be impacted and such work for batch job execution
support,refactoring support,Application Architecture support,and Application
DBA support shall be placed on hold until this revision is executed.
Page 6 of 9 Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
Ca1SAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
• The PBDS will be pushed into the County's Amazon S3 account via batch processing to take
place after each daily batch run has completed in full.
• The Performance Requirements set forth in Schedule 7(Performance Requirements) to
Exhibit X (Ca1SAWS M&O Extension) of the Base Agreement will not apply to this County
Purchase.
• The County will be responsible for assigning a County contact for security activities, such as
access requests to the County's AWS account or security incidents.
• Changes to access paths and methods will be reviewed and approved through the
Consortium Technical Change Advisory Board prior to implementation.
• Access credentials will be rotated by County in accordance with Consortium Security
Policy.
• The County will be responsible for obtaining access to County datasets from the
Consortium.
• The County's access to the Amazon S3 is read/egress only.
• Relational Database will be accessible via Wide Area Network ("WAN") Network Address
Translation("NATed") through Firewall ("F5") at exchange.
• The County will raise all defect or enhancement requests via the ServiceNow ticketing tool.
• The County will be responsible for the AWS costs associated with storage and egress of the
data from the PBDS.These costs will vary based on data volume and egress.
• The Total Charges for this County Purchase do not include charges for AWS compute
resources and services required for enhancements that will be deployed under this County
Purchase. An estimate of AWS compute resources and services costs is provided to the
County for budget allocation purposes. The Consortium will be fully responsible for making
such resources and services available for supporting the project,including the procurement
and payment for such services from AWS. The County will be responsible for reimbursing
the Consortium for all AWS charges required to support the solution.The estimate for AWS
compute resources charges is based on services for SFY 2024/25.
• This County Purchase does not include any incremental charges for network infrastructure.
If future changes to the CaISAWS System impact this County Purchase and would result in
the need for additional network infrastructure costs, a new County Purchase will be
required under a new Ca1SAWS agreement.
• The County will be responsible for designing and implementing queries and egress
methods to use and extract the data from Amazon S3.
• Testing of queries will leverage existing Ca1SAWS test environments and masked data.
• This estimate includes sixty (60) hours of data validation. The County will be responsible for
any additional data validation.
• The County will identify and provide the appropriate County staff to support project
activities throughout the term of this County Purchase.
• The County must (1) approve this County Purchase and (2) provide the corresponding
approved Advance Planning Document ("APD") or alternative form of authorized spending
from the Office of Technology and Solutions Integration("OTSI") that supports this
purchase by July 18,2025 to proceed with this purchase. Otherwise,the estimates provided
in this County Purchase will not be valid and a new County Purchase will be required.
Page 7 of 9 Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
Ca1SAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
IV. Schedule:
The charges associated with this County Purchase will be incurred during SFYs 2024/25 and
2025/26.
V. Total Charges:
The following table outlines the total charges for this County Purchase.
Total Charges (Revision 2 to
Total Charges (Revision 1 Revision 1
Total County Purchase Charges SFY 24/25 1 S FY 25/26 1 (Revision 2) 11 Approved) Approved)
One-Time R&A Change Budget Services $279,452.80 $0.00 $279,452.80 $279,452.80 $0.00
Recurring R&A Change Budget Services $115,520.40 $170,296.00 $285,816.40 $158,094.40 $127,722.00
Hardware and Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Production Operations Charges $0.00 $0.00 $0.00 $0.00 $0.00
One Time Charges $0.00 $0.00 $0.00 $0.00 $0.00
Recurring Charges $0.00 $0.00 $0.00 $0.00 $0.00
Total Charges $394,973.20 r $170,296.00 $565,269.20 $437,547.20 $127,722.00
VI. Attachment 1 to the County Purchase FR-02-2024-Pricing Schedules- Revision 2
Page 8 of 9 Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
CaISAWS Consortium
Fresno County Purchase FR-02-2024-Revision 2
COUNTY PURCHASE APPROVAL
Subject: County Purchase-FR-02-2024-Revision 2
The subject document is accepted as allowing Accenture LLP to proceed with the subject County
Purchase.
Fresno County
ATTEST:
By. , BERNICE E.SEIDEL
Printed Name:Ernest Buddy Mendes Clerk of the Board of supervisors
County of Fresno,State of California
Title:Chairman to the Board of Supervisors
By_ Deputy
Date: �-aoas -
Approved As to Form:
Fresno County Counsel
By:� `'S
Printed Name:Heather Kruthers
Title:Chief Deputy County Counsel
Date:4/7/25
Notice Address: For Accounting Use On1X
205 W.Pontiac Way Fund/Subclass:0001/10000
Building 2 Org:56108550
Clovis,CA 93612 Account: 7295
CaISAWS Consortium Accenture LLP
By: By:
Printed Name: Printed Name:
Title: Title:
Date: Date:
Notice Address:
CaISAWS Consortium
620 Roseville Parkway
Roseville,CA 95747
Page 9 of 9CaLSAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docxCaISAWS County Purchase FR-02-2024 PBDS-Revision 2
convert to PDF.docx
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 1 of 6
1 - Charges Summary
Charges I (Revision 1 to Revision
Total County Purchase ChargeA SFY 24/25,M SFY 25/26 (Revision 2,k. Approved) 1 Approved)
One-Time R&A Change Budget Services $279,452.80 $0.00 $279,452.80 $279,452.80 $0.00
Recurring R&A Change Budget Services $115,520.40 $170,296.00 $285,816.40 $158,094.40 $127,722.00
Hardware and Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Production Operations Charges $0.00 $0.00 $0.00 $0.00 $0.00
One Time Charges $0.001 $0.00 $0.00 $0.001 $0.00
Recurring Charges $0.00 $0.00 $0.00 $0.00 $0.00
Total Charges $394,973.20 $170,296.00 1$565,269.20 $437,547.20 1 $127,722.00
(OriginalTotal County Purchase Charges Charges Original
r Revision 1 Approved AL"SFY24/2 FSFY 25IF26 (RevisionAiApprovejdkLApprovedL
One-Time R&A Change Budget Services $279,452.80 $0.00 $279,452.80 $279,452.80 $0.00
Recurring R&A Change Budget Services $115,520.40 $42,574.00 $158,094.40 $167,086.80 ($8,992.40)
Hardware and Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Charges $0.00 $0.00 $0.00 $0.00 $0.00
Hardware Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Charges $0.00 $0.00 $0.00 $0.00 $0.00
Software Maintenance and Support Charges $0.00 $0.00 $0.00 $0.00 $0.00
Production Operations Charges $0.00 $0.00 $0.00 $0.00 $0.00
One Time Charges $0.001 $0.00 1 $0.00 $0.00 $0.00
Recurring Charges $0.00 $0.00 $0.00 $0.00 $0.00
Total Charges $394,973.20 1 $42,574.00 1$437,547.20 1$446,539.60 ($8,992.40)
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 2 of 6
1 - Charges Summary Continued
- .
7Dev/
ted AWS Compute Resource Costs $22,711.12 $0.00 $22,711.12
Test -> -200+ Cloud Watch logs for Cloud
and ingestion to S3, EMIR Serverless and
RIDS Serverless metrics $360.00 $0.00 $360.00
Dev/Test -S3 storage and egress - 1TB, 10M
PUT, GET, 1TB egress/mo., Athena 5000 1GB
queries $1,187.16 $0.00 $1,187.16
Dev/Test - EMIR Serverless for PBDS $7,594.80 $0.00 $7,594.80
Dev/Test -Aurora Serverless for PBDS (1 TB
storage) $2,379.00 $0.00 $2,379.00 *The County will reimburse the CaISAWS Project
for all charges. The charges associated with this
Dev/Test Secrets Manager for Credentials storage $9.60 $0.00 $9.60 County Purchase should not impact the CaISAWS
Prod -> -200+ Cloud Watch logs for Cloud Trail Project Budget.
and ingestion to S3, EMIR Serverless and RIDS
Serverless metrics $240.00 $0.00 $240.00 ** The Total County Purchase Charges do not
Prod-S3 storage and egress - 3TB, 25M PUT, include costs for AWS compute resources and
35M GET, 1TB egress/mo., Athena 10000 1GB services required for enhancements that will be
queries $1,417.56 $0.00 $1,417.56 deployed under this County Purchase. This estimate
Prod - EMIR Serverless for PBDS $4,219.32 $0.00 $4,219.32 of AWS compute resource and services costs is
3 TB storage) provided to the County for budget allocation
Prod -Aurora Serverless for PBDS ( g ) $4,215.80 $0.00 $4,215.80 purposes. The County will be responsible for
Prod Secrets Manager for Credentials storage $6.40 $0.00 $6.40 reimbursing the Consortium for all AWS costs
Enterprise Support Charges $1,081.48 $0.00 $1,081.48 required to support the solution. The estimate for
Total Estimated AWS Compute Resource Costs $22,711.12 $0.00 $22,711.12 AWS compute resources costs are based on
services for State Fiscal Year("SFY")2024/25.
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 3 of 6
2a - One-Time-Services
DescriptionHours Hourly Rate Charges
1,880 1,880 $279,452.80 $279,452.80
Initial required configuration:
•Vending a new Amazon Web Services("AWS")account for the County within the CaISAWS main AWS account;
•Building and maintaining the infrastructure to support a copy of the County's data in Amazon S3;
•Configuring the County-specific batch jobs to partition and store the data;
•Creating and configurating Amazon Glue Crawlers to organize the data;
•Providing access to individual users and/or service accounts within the County; Senior Programmer/Analyst 200 200 $208.40 $41,680.00 $41,680.00
•Enabling Amazon Athena Console,Open Database Connectivity("ODBC"),and Java Database Connectivity
("JDBC")access for users and service accounts;
•Providing serverless architecture to ingest PBDS data into the County's AWS account;
•Providing a relational database for querying purpose-built data;
•Testing of individual jobs and validation of data subset;
•Providing documentation as requested by the County,which may include system diagrams,presentation materials,
or other documentation as requested. Programmer/Analyst 500 500 $153.93 $76,965.00 $76,965.00
Global Delivery Network 720 720 $125.00 $90,000.00 $90,000.00
Support for connection/tool setup,query tuning,partition tuning,enhancements,and training(optional)** Programmer/Analyst 400 400 $153.93 $61,572.00 $619572.00
Administration of the County Purchase order Program mer/Anal st 60 60 $153.93 $9,235.80 $9,235.80
Insert tasks above here.Do not modify this line.
*The County will be responsible for all Services Charges. One-time Services are estimated to commence August 1, 2024 and
continue through the expiration of the Technical Infrastructure Services Base Agreement (currently January 31, 2025). One-time
Services will be invoiced on a time and materials ("T&M") basis.
**Accenture will work with the County to develop a schedule for this support should the County elect to use these hours.
*** If the County requests offshore/onshore staffing mix changes, then a revision to this County Purchase would be required.
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 4 of 6
2b - Recurring Services
Quantity Hourly Rate Monthly Charge (1/2025) Total Charges
[(1/2025-512025)
Recurring R&A Change Budget Services 180 $27,617.80 $ITSMIM IN$170,296.00 $285,816.40
Prodding infrastructure support for AWS issues,configuration,Technical Operations,and Technical Architecture for changes that
affect the PBDS-estimated up to twenty(20)hours per month(estimated to commence January 1,2025 and continue through 20 $158.27 $3,165.40 $3,165.40 $0.00 $3,165.40
January 31,2025
Prodding Database Administration("DBA")support for changes that affect the PBDS-estimated up to twenty(20)hours per month 20 $158.27 $3,165.40 $3,165.40 $0.00 $3,165.40
estimated to commence January 1,2025 and continue through January 31,2025
Prodding batch job execution support as needed-estimated up to twenty(20)hours per month(estimated to commence January 20 $125.00 $2,500.00 $12,500.00 $20,000.00 $32,500.00
1,2025 and continue through January 31,2026
Prodding refactoring support for changes that affect the PBDS,estimated up to eighty(80)hours per month(estimated to 80 $158.27 $12,661.60 $63,308.00 $101,292.80 $164,600.80
commence January 1,2025 and continue through January 31,2026
Prodding Application Architecture support for changes that affect the PBDS(such as Architectural changes relating to Reports
releases,version upgrades,or data growth)-estimated up to ten(10)hours per month(estimated to commence February 1,2025 10 $158.27 $1,582.70 $6,330.80 $12,661.60 $18,992.40
and continue through January 31,2026
Prodding Application DBA support for changes that affect the PBDS-estimated up to ten(10)hours per month(estimated to 10 $158.27 $1,582.70 $6,330.80 $12,661.60 $18,992.40
commence February1,2025 and continue through January31,2026
Administration of the Count Purchase order 20 $148.00 $2,960.00 $20,720.00 $23,680.00 $44,400.00
TOTAL $115,520.40 $170,296.00 $285,816.40
Hours per SFY
1 20 0 20
2 20 0 20
3 100 160 260
4 400 640 1,040
5 40 80 120
6 40 80 120
7 140 160 300
*The County will be responsible for all Services Charges.Recurring Services will be invoiced on a time and materials("T&W)basis.
**If the County requests offshore/onshore staffing mix changes,then a revision to this County Purchase would be required.
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 5 of 6
2b - Recurring Services Continued
Recurring R&A Change Budget Services
Revision 1 Approved WF
Quantity Hourly Rate Monthly Charge (112025) (6/2025-71202 otal Cha
Category (212025-5/2025)
Recurring R&A Change Budget Services 180 $27,617.80 $115,520.40 $42,574.00 $158,0 44.40
Promcling infrastructure support for AWS issues,configuration,Technical Operations,and Technical Architecture for changes that
affect the PBDS-estimated up to twenty(20)hours per month(estimated to commence January 1,2025 and continue through 20 $158.27 $3,165.40 $3,165.40 $0.00 $3,165.40
January 31,2025)
Prodding Database Administration("DBA")support for changes that affect the PBDS-estimated up to twenty(20)hours per month 20 $158.27 $3,165.40 $3,165.40 $0.00 $3,165.40
estimated to commence January 1,2025 and continue through January 31,2025
Prodding batch job execution support as needed-estimated up to twenty(20)hours per month(estimated to commence January 20 $125.00 $2,500.00 $12,500.00 $5,000.00 $17,500.00
1,2025 and continue through July 31,2025
Prodding refactoring support for changes that affect the PBDS,estimated up to eighty(80)hours per month(estimated to 80 $158.27 $12,661.60 $63,308.00 $25,323.20 $88,631.20
commence January 1,2025 and continue through July 31,2025
Prodding Application Architecture support for changes that affect the PBDS(such as Architectural changes relating to Reports
releases,version upgrades,or data growth)-estimated up to ten(10)hours per month(estimated to commence February 1,2025 10 $158.27 $1,582.70 $6,330.80 $3,165.40 $9,496.20
and continue through July 31,2025
Prodding Application DBA support for changes that affect the PBDS-estimated up to ten(10)hours per month(estimated to 10 $158.27 $1,582.70 $6,330.80 $3,165.40 $9,496.20
commence Februa 1,2025 and continue through Jul 31,2025
Administration of the County Purchase order 1 20 1 $148.00 1 $2,960.00 $20,720.00 $5,920.00 1 $26,640.00
TOTAL 180 $115,520.40 $42,574.00 $158,094.40
Attachment 1 to the County Purchase FR-04-2024 Revision 2 Page 6 of 6
3 -AWS Estimates
A WS I SFY 24/251 SFY 24/251 SFY 24/251 SFY 24/251 SFY 24/251 SFY 24/251 SFY 241251 SFY 24/25 SFY 24/25
If Invoice
known Month-> Oct-24 N-24 Dec-24 Jan-25 Feb-25 Mar-25 Alal Ma-25 Jul
� - � - SFY 24/25 TOTAlS
AWS:CloudWotch Security I 60.000 $ 60.00 • Dev/Test->-200+Cloud Watch logs 8/1/2024 113112025 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $0.00 $0.00 $0.00
**New** for Cloud Trail and ingestion to S3,
EMRServerless and RDS Serverless
metrics
$ 360.00 $ 360.00
A WS:S3 Analytics 1 197,860 $ 197.86 Test-S3 storage and egress-1TB, 81112024 V3112025 $197.86 $197.86 $197.86 $197.86 $197.86 $197.86 $0.00 $0.00 $0.00
**New** 10000000 PUT,GET,ITB egress/mo,
Athena 50001GB queries
$ 1,187.16 $ 1,187.16
Amazon EMR Analytics 1 1265.800 $1,265.80 Dev/Test-EMR for PBDS-Number 81112024 113112025 $1,265.80 $1,265.80 $1,265.80 $1,265.80 $1,265.80 $1,265.80 $0.00 $0.00 $0.00
Serverless **New** of vCPUs per job run(300),Amount
of memory perjob run(GB)(900),
Job runtime(60 hours),Total
ephemeral storage perjob run(GB) $ 7,594.80 $ 7,594.80
Amazon Aurora Analytics 1 396.500 $ 396.50 Dev/Test-RDS for pbds-Storage 81112024 V3112025 $396.50 $396.50 $396.50 $396.50 $396.50 $396.50 $0.00 $0.00 $0.00
MySQL- **New** amount(1TB)
Compatible
$ 2,379.00 $ 2,379.00
AWS Secrets Analytics 1 1.600 $ 1.60 Dev/Test-RDS,0racl a Secrets- 81112024 113112025 $1.60 $160 $160 $160 $1.60 $1.60 $0.00 $0.00 $0.00
Manager **New** N umber of secrets(4),Ave rage
duration of each secret(30 days),
Number of API calls(I per month) $ 9.60 $ 9.60
AWS:Cloud Watch Security 1 60.000 $ 60.00 Prod->-200+Cloud Watch logs for 10/1/2024 1,13112025 $0.00 $0.00 $60.00 $60.00 $60.00 $60.00 $0.00 $0.00 $0.00
**New** Cloud Trail and ingestion to S3,EMIR
Se live rless and RDS Serverless
metrics
$ 240.00 $ 240.00
A WS:S3 Analytics 1 354.390 $ 354.39 Prod-S3 storage and egress-3TB, 101112024 113112025 $0.00 $0.00 $354.39 $354.39 $354.39 $354.39 $0.00 $0.00 $0.00
**New** 25000000 PUT,35000000 GET,ITB
egress/mo,Athena 100001GB
queries
$ 1,417.56 $ 1,417.56
Amazon EMR Analytics 1 1054.830 $1,054.83 Prod-EMR for PODS-Number of 10/1/2024 113112025 $0.00 $0.00 $1,054.83 $1,054.83 $1,054.83 $1,054.83 $0.00 $0.00 $0.00
Serverless **New** vCPUs perjob run(300),Amount of
memory perjob run(GB)(900),Job
runtime(50 hours),Total
ephemeral storage perjob run(GB)
(1000) $ 4,219.32 $ 4,229.32
Amazon Aurora Analytics 1 1053.950 $1,053.95 Prod-RDS for pbds-Storage 101112024 113112025 $0.00 $0.00 $1,053.95 $1,053.95 $1,053.95 $1,053.95 $0.00 $0.00 $0.00
MySQL- **New** amount(3TB)
Compatible
$ 4,215.80 $ 4,215.80
AWS Secrets Analytics 1 1.600 $ 1.60 Dev/Test-RDS,Oracle Secrets- 10/1/2024 113112025 $0.00 $0.00 $1.60 $1.60 $1.60 $1.60 $0.00 $0.00 $0.00
Manager **New** N umber of secrets(4),Ave rage
duration of each secret(30 days),
Number of API calls(1 per month)
$ 6.40 $ 6.40
$ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 1 $ - $ -
Do not delete-Enter above this line
r $0.00 $0.00
Enterprise Support 5%of $96,09 $96.09 $222.33 $222.33 $222.33 $222.33 $0.00 $0.00 $0.00
Total Cost $ 1,091.48 $ 1,081.48
Grand Total $2,017.85 $2,017.85 .. , .. , .. $4,668.86 $0.00 $0.00 $0.00