Loading...
HomeMy WebLinkAboutAgreement A-25-030 with Gainwell CalSAWS Consortium.pdf Agreement No. 25-030 CaISAWS Infrastructure County Purchase Fresno County F R - 12-2024 Fresno County - Request for Purpose-Built, Curated Data Set (" PBDS") Access in CaISAWS Amazon Simple Storage Solution ( "Amazon SY) Location December 5, 2024 © 2024 CaISAWS Consortium. All Rights Reserved. • 12/3/2024 1 .0 Created Document Michael Johnson 12/4/2024 2.0 Sent to CPMO for review Michael Johnson 12/5/2024 3.0 Incorporated Feedback Michael Johnson © 2024 CaISAWS Consortium. All Rights Reserved. CaISAWS - Infrastructure County Purchase—Fresno PBDS TABLE OF CONTENTS REQUESTEDSERVICES ............................................................................................................... 4 1. OVERVIEW............................................................................................................................. 4 2. SCOPE OF WORK: ONGOING OPERATIONS........................................................................ 4 3. ASSUMPTIONS....................................................................................................................... 4 4. TOTAL ESTIMATED CHARGES ................................................................................................ 6 COUNTY PURCHASE APPROVAL .............................................................................................. 7 - 3 - © 2021 CaISAWS Consortium. All Rights Reserved. CaISAWS - Infrastructure County Purchase—Fresno PBDS REQUESTED 1. OVERVIEW Pursuant to Section 8.7 of the CaISAWS Infrastructure Agreement between the CaISAWS Consortium and Gainwell Technologies LLC ("Gainwell") effective October 01, 2024, Consortium shall also have the right to order and purchase Work that is in connection with the CaISAWS System and which will be used by Consortium Members, by executing and delivering an order form that is agreed to in writing by Contractor and Consortium and executed by the applicable Consortium Member. In the event of a conflict or inconsistency between the terms and conditions of an order and this Agreement, the terms and conditions of this Agreement shall control to the extent of the conflict or inconsistency. Fresno County ("County") has requested access to the County's data within the purpose-built, curated data set ("PBDS") that currently resides in a CaISAWS Amazon Simple Storage Solution ("Amazon S3") location, which requires recurring infrastructure support as further described in this County order form (the "County Purchase"). 2. SCOPE OF WORK: ONGOING OPERATIONS The County identified a business need for access to the PBDS to help meet data and reporting goals after the County's migration to the CaISAWS System. This County Purchase includes up to 320 hours for recurring services for Gainwell staff to assist the County with technical architecture and operational support that affect the PBDS as follows: • 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. 3. ASSUMPTIONS 1. Financial Assumptions: a. The charges in Section 4 below, "Total Estimated Charges," are estimates and are subject to change. The estimates include taxes if appropriate. b. The Total Charges below reflect the scope of work outlined within this County Purchase. Any changes in scope must be mutually agreed upon by the parties involved and may result in additional charges. The additional charges will be executed as a revision/amendment to this County Purchase. c. Invoicing will occur through the Consortium through standard procedures as - 4 - ©2021 CaISAWS Consortium. All Rights Reserved. CaISAWS - Infrastructure County Purchase—Fresno PBDS time and materials not to exceed the total cost of this county purchase. Estimate includes 1 . Up to 80 hours to be worked and invoiced commencing February 1, 2025, through the end of SFY2024/25, May 31, 2025 2. Up to 240 hours to be worked and invoiced in SFY2025/26 commencing June 1, 2025, and continue through May 31, 2026 d. If the County requests more hours than those indicated above, a revision of this County Purchase would be required. e. Gainwell and the County will monitor the hours and discuss the addition of more hours with the County if necessary. Any additional hours required, or the addition of future fiscal years would result in additional charges. These additional charges would be provided to the County in a separate County Purchase. f. The Total Charges for this County Purchase do not include charges for AWS compute resources and services, including but not limited to storage and egress of the data from the PBDS required for ongoing operations under this County Purchase. The Consortium will make 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 AWS charges required to support the solution. g. This County Purchase does not include any incremental charges for network infrastructure. In the event that there is a need for additional network infrastructure costs, these additional charges would be provided to the County in a separate County Purchase. 2. General Assumptions: a. This County Purchase does not include services for Gainwell to assist with business process transformation efforts, batch execution support, database administration, or refactoring support for changes that affect the PBDS which must be procured through other contractor agreements. b. Access credentials will be rotated by the County in accordance with Consortium Security Policy. c. The County will be responsible for obtaining access to County datasets from the Consortium. d. The County's access to the Amazon S3 is read/egress only. - 5 - ©2021 CaISAWS Consortium. All Rights Reserved. CaISAWS - Infrastructure County Purchase—Fresno PBDS e. Relational Database will be accessible via Wide Area Network ("WAN") Network Address Translation ("NATed") through Firewall ("FY) at exchange. f. The County will raise defect or enhancement requests via the ServiceNow ticketing tool. g. The County will be responsible for designing and implementing queries and egress methods to use and extract the data from Amazon S3. To begin this project, the County must: Approve this County Purchase and provide the corresponding approved Advance Planning Document (APD) from the Office of Technology and Solutions Integration (OTSI) that supports this purchase to proceed with this County Purchase. Otherwise, the estimates provided in this County Purchase will not be valid and a new County Purchase will be required. Services are assumed to begin when the following are completed: • County approves this County Purchase • Consortium approves this County Purchase 4. TOTAL ESTIMATED CHARGES Total estimated charges are shown below. These are estimates based on information available as of the date of submission of this County Purchase document. The total amount of this county purchase for is $48,530.40, which can be found in the table below. SFY24/25 SFY25/26 Phase Hours Hours Activities Ongoing 80 240 Providing infrastructure support for AWS issues, Maintenance configuration, Technical Operations, and Technical Architecture for changes that affect the PBDS - estimated up to twenty (20) hours per month (estimated to commence February 1, 2025, and continue through May 31, 2026) Hours 80 240 Total Hours - 320 Cost $12,132.60 $36,397.80 Total Cost- $48,530.40 - 6 - ©2021 CaISAWS Consortium. All Rights Reserved. CaISAWS-Infrastructure County Purchase—Fresno PBDS COUNTY • Subject: County Purchase - FR-02-2024 The subject document is accepted as allowing Gainwell Technologies to proceed with the subject County Purchase. Fresno County By: ATTEST: 67, BERNICE E.SEIDEL Printed Name: Ernest Buddy Mendes Clerk of the Board of Supervisors County of Fresno,State of California Title: Chairman of the Board of Supervisors By—%_�4 Deputy Date: / d 8 -aoas Fresno County Counsel Approved as to Form �y , By: Printed Name: Heather Kruthers Title: Chief Deputy County Counsel Date:12/23/24 Notice Address: FOR ACCOUNTING USE ONLY: 205 W. Pontiac Way Fund/Subclass: 0001/10000 Building 2 Org: 56108550 Clovis, CA 93612 Account: 7295 - 7- ©2021 CaISAWS Consortium. All Rights Reserved. CaISAWS - Infrastructure County Purchase—Fresno PBDS CaISAWS Consortium By: Printed Name: Title: Date: Notice Address: CaISAWS Consortium 620 Roseville Parkway Roseville, CA 95747 Gainwell Technologies By: Printed Name: Title: Date: Notice Address: Gainwell Technologies 620 Roseville Parkway Roseville, CA 95747 - 8 - ©2021 CaISAWS Consortium. All Rights Reserved. Attachment 1 to County Purchase FR-12-2024 Page 1 of 2 Pricing Schedules 1- Schedule 8: County Purchase Staff Loading: February 2025-July 2025 1 Service Month Offshore Infras;ructur 6.0 Production Operations 62 Infrastructure Product-Support Infrastructure aoud Engineer $ 165.96 150 150 150 15.0 15.0 15.0 150 150 15.0 15.0 15.0 15.0 150 150 15.0 15.0 240.0 $ 39,830 Infrastructure Business Analyst $ 108.75 50 50 50 5.0 5.0 5.0 50 50 50 5.0 5.0 5.0 50 50 &0 5.0 80.0 $ 8,700 $ $ $ $ $ $ $ $ $ $ Infrastructure Production Support Subtotal 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 320.0 $ 48,530 Production Operations Subtotal 20.0 20.0 20.0 20.0 20.0 20.0 20.0 1 20.0 20.0 20.0 20.0 20.0 20.0 1 20.0 20.0 20.0 320.0 48,530.4 Infrastructure Staff Loading Total 20.0 20.0 20.0 20.0 20.0 20.0 20.0 1 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 20.0 320.0 $48,530.40 Ave Hourly Rate $151.66 Attachment 1 to County Purchase FR-12-2024 Page 2 of 2 1- Schedule 13: Base Infrastructure Hourly Rate Card through SPY 2030/31 Offshore # Staff Position Hourly Rate (Y/N) 1 Infrastructure Project Manager-Key $ 168.98 N 2 Infrastructure Project Management Office(PMO)Lead $ 144.13 N 3 Infrastructure Delivery Integration Manager $ 90.28 N 4 Infrastructure Transition Manager $ 115.03 N 5 Infrastructure Operations Manager $ 223.23 N 6 Infrastructure Security Manager $ 215.15 N 7 Infrastructure Operations Service Desk Lead $ 146.34 N 8 Infrastructure AWS Manager $ 223.23 N 9 Infrastructure System Administrator $ 111.13 N 10 Infrastructure System Administrator-Offshore $ 31.06 Y 11 Infrastructure Service Manager $ 89.14 N 12 Infrastructure Enterprise Architect $ 142.19 N 13 Infrastructure Data Scientist $ 180.56 N 14 Infrastructure Business Analyst $ 108.75 N 15 Infrastructure Developer $ 111.50 N 16 Infrastructure Engineer $ 117.62 N 17 Infrastructure Tools Manager $ 172.56 N 18 Infrastructure Tools Administrator $ 96.32 N 19 Infrastructure Operations Excellence Leader $ 146.34 N 20 Infrastructure ServiceNow Manager $ 144.42 N 21 11nfrastructure Network Operations Administrator $ 105.26 N 22 Infrastructure Network Operations Administrator-Offshor $ 29.73 Y 23 Infrastructure Technical Project Manager $ 113.55 N 24 Infrastructure Quality Assurance Manager $ 115.03 N 25 Infrastructure QA Advisor $ 110.41 N 26 Infrastructure Remote Maintenance Technician $ 58.35 N 27 Infrastructure Service Desk Analyst $ 60.08 N 28 Infrastructure Incident Manager $ 108.75 N 29 linfrastructure Associate Business Analyst $ 89.55 N 30 Infrastructure Depot Technician $ 58.35 N 31 Infrastructure Tester $ 104.26 N 32 Infrastructure Project Scheduler $ 115.03 N 33 Infrastructure Cultural Transformation Lead $ 90.24 N 34 Infrastructure Account Business Office Leader $ 122.24 N 35 Infrastructure Communications Specialist $ 92.60 N 36 Infrastructure Program Manager $ 113.55 N 37 linfrastructure Business Continuity Lead $ 108.75 N 38 Infrastructure Business-Technical Analyst $ 157.58 N 39 Infrastructure Cloud Architect $ 236.36 N 40 Infrastructure Cloud Engineer $ 165.96 N 41 Infrastructure Cloud Engineer-Offshore $ 38.38 Y 42 Infrastructure Cloud Network Engineer $ 187.88 N 43 Infrastructure DBA $ 146.97 N 44 Infrastructure DBA-Offshore $ 38.38 N 45 linfrastructure DevOps Engineer $ 175.51 N 46 Infrastructure Middleware Engineer $ 155.56 N 47 InfrastructureMiddlewareEngineer-Offshore $ 40.40 Y 48 Infrastructure Operations Project Manager $ 180.30 N 49 Infrastructure Security Analyst $ 150.51 N 50 Infrastructure Security Engineer $ 200.00 N 51 Infrastructure Service Delivery Manager $ 175.76 N 52 Infrastructure Network Operator-Offshore $ 21.31 Y 53 linfrastructure Security Operator-Offshore $ 21.31 Y 54 Infrastructure Reporting-Offshore $ 21.31 Y 55 Infrastructure Transition Lead $ 193.94 N 56 Imaging Manager $ 177.50 N 57 Imaging Supervisor $ 109.13 N 58 Imaging Support Application Analyst $ 102.16 N 59 Imaging Support Analyst-Triage 1 $ 92.46 N 60 Imaging Support Analyst-2 $ 92.46 N 61 Ilmaging Analyst-Production Support $ 92.46 N 62 Imaging Analyst Lead-Contact Center $ 131.03 N 63 Imaging Analyst-Contact Center $ 102.16 N 64 Infrastructure Business-Technical Analyst-Offshore $ 35.36 Y 65 Infrastructure Cloud Network Engineer-Offshore $ 49.19 Y 66 InfrastructureDevOpsEngineer-Offshore $ 49.19 Y 67 Infrastructure Project Manager-Offshore $ 49.19 Y 68 Infrastructure Security Analyst-Offshore $ 42.83 Y 69 linfrastructure Onshore NOC $ 103.03 IN 70 Infrastructure Onshore SOC $ 122.22 N 71 Infrastructure Onshore Reporting $ 153.54 IN