HomeMy WebLinkAboutSigned County Purchase - FR-02-2024 - Revision 2.pdf California Statewide Automated Welfare
System (CalSAWS)
County Purchase FR-02-2024
Fresno County - Request for Purpose-Built,
Curated Data Set ("PBDS") Access in CalSAWS
Amazon Simple Storage Solution ("Amazon S3")
Location - Revision 2
Page 1 of 9 CalSAWS 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 CaISAWS 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 Ca1SAWS
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
Ca1SAWS 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 Ca1SAWS 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 Ca1SAWS release process,provide up to twenty (20) hours per month for
batch job execution support.Specifically,when updates to the Ca1SAWS 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 Ca1SAWS process or
identified by the County or Ca1SAWS,estimated up to twenty (20) hours per month.
• Resolving and updating Ca1SAWS 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 Ca1SAWS 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
Ca1SAWS 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 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 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
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 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 CaiSAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docx
CaISAWS 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 CaiSAWS 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 ("175") 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 Ca1SAWS 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 CaiSAWS 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 I Revision I
Total County Purchase Charges SFY 24/25 SFY 25/26 (Revision 2) 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 $170,296.00 $565,269.20 $437,547.20 $127,722.00
VI. Attachment I to the County Purchase FR-02-2024- Pricing Schedules - Revision 2
Page 8 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
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: �o -aoas
Approved As to Form:
Fresno County Counsel
By:C:".��
Printed Name:Heather Kruthers
Title:Chief Deputy County Counsel
Date:4/7/25
Notice Address: For Accounting Use Only
205 W.Pontiac Way Fund/Subclass: 0001/10000
Building 2 Org: 56108550
Clovis,CA 93612 Account: 7295
Ca1SAWS Consortium Accenture LLP
B . iioJly Mur�hv B y. Lr;ra�SaCar
y imuv M��.Pnv law i.zozs is iaiop L s,i,_,w,n,?ms noa PDT,
Printed Name: Holly Murphy Printed Name: Lisa Salas
Title: CAO Title: Managing Director
Date: 07/01/2025 Date: 07/01/2025
Notice Address:
Ca1SAWS Consortium
620 Roseville Parkway
Roseville,CA 95747
Page 9 of 9Ca1SAWS County Purchase FR-02-2024 PBDS-Revision 2 convert to PDF.docxCalSAWS County Purchase FR-02-2024 PBDS-Revision 2
convert to PDF.docx