DRAFT FIRST AMENDMENT TO CONSULTANT SERVICES AGREEMENT BETWEEN
THE CITY OF SUNNYVALE AND PARK CONSULTING GROUP FOR PROJECT
MANAGEMENT FOR THE IMPLEMENTATION OF ENERGOV PERMITTING SYSTEM This First Amendment to Consultant Services Agreement, dated _________________, is by and between the CITY OF SUNNYVALE ("CITY"), a California chartered municipal corporation for the state of California, and PARK CONSULTANT GROUP ("CONSULTANT").
WHEREAS, the CITY and CONSULTANT entered into an Agreement on February 11, 2021, whereby CONSULTANT would provide professional services necessary for the project management of the implementation of EnerGov Permitting System services (“Agreement”); and WHEREAS, the CITY and CONSULTANT now agree that an Amendment to said Agreement is advisable;
NOW, THEREFORE, THE CITY AND AGENCY ENTER INTO THIS FIRST AMENDMENT TO CONSULTANT SERVICES AGREEMENT:
1. Section 1 entitled “Services by CONSULT ANT” is hereby amended, in part , to read as follows
1. Services by CONSULTANT
[Replace the first sentence of this section with the following:] CONSULTANT shall provide services in accordance with Exhibit "A" and Exhibit “A-1” attached and incorporated by reference.
2. Section 4 entitled “Compensation” is hereby amended, in part, to read as follows:
4. Compensation
[ Replace the first paragraph of this section with the following:] CITY agrees to pay CONSULTANT as full compensation for the services rendered pursuant to this Agreement, the amounts set forth in Exhibit “A” and Exhibit “A-1”. Total compensation shall not exceed Six Hundred Eighty Two Thousand Three Hundred Fifty and no/100 Dollars ($682,350.00).
3. Exhibit “A-1,” entitled “Additional Scope of Work,” is attached hereto and incorporated into this Agreement.
4. All other terms and conditions remain unchanged and are in effect.
Attachment 1
IN WITNESS WHEREOF, the parties have executed this Agreement Amendment.
CITY OF SUNNYVALE ("CITY") PARK CONSULTANT GROUP
(“CONSULTANT”)
By _____________________________ By _____________________________ City Manager
________________________________
Name and Title
ATTEST:
By ___________________________
City Clerk
APPROVED AS TO FORM:
By ___________________________
City Attorney
Attachment 1
Sunnyvale - Proposal for EnerGov Phase 2 and GIS Services Park Consulting Group
Title: Proposal – EnerGov Phase 2 and GIS Services Date: 03/06/2023
Client Contact: Dhiren Gandhi, IT Manager
PCG Contact: Glenn Park, President and Principal Consultant
PROPOSAL
Description of Work
The City of Sunnyvale is seeking the following services for EnerGov Phase 2 and GIS Services:
Dur
ation of Services: April 1, 2023 – June 30, 2024 (15 Months) En
erGov Issue Resolution and Enhancement Services:
- PCG will attend meetings, etc. as available. This will include working sessions. - Provide feedback on leading best practices to maximize EnerGov system capabilities. - PCG will provide EnerGov post-Go-Live support and enhancement services as requested by the City. This will include supporting, implementing, and reviewing EnerGov configuration including case types, workflows, custom fields, CSS configuration, and fees. - PCG will provide configuration walkthroughs or details for resolved issues and deployed enhancements. City may choose to record walkthroughs as needed. - PCG will review City-deployed configuration and developed reports as requested. - PCG will receive and respond to requests from the City’s primary point of contact (POC) from City’s IT (or designated back-up).
- PCG should have the full ability to deliver services remotely with no on-site visits and/ or incurred travel costs. If onsite visits are requested, travel expenses and time will be reimbursed. - Duration of Services:
o 4/1/2023 – 6/30/2023: Up to 80 hours per month
IT will request issues and enhancements to be owned by PCG. o 7/1/2023 – 6/30/2024: Up to 20 hours per month
IT will be primarily resolve issues and enhancements; PCG will provide advanced issue and configuration support as requested.
En
erGov Fee Configuration:
- TBD Prior to June 2024 - PCG will be responsible for the configuration of requested fee updates provided by the City’s Community Development, Public Safety, and Public Works departments related to the fiscal year 2023/24 fee schedule updates. The approved and adopted fee schedule will be provide as the reference source for the configuration.
En
erGov Report Development:
- Provide report development services to design, develop, and deploy non-standard forms and statistical reports generated from EnerGov.
- Reports and Forms will be developed with the use of Crystal Reports. - S tored procedures and queries required for reports and forms will be developed. - Prepare template and stored procedures development package to be sent by City to Tyler Tech - Coordinate with City POC to send RPT file and stored procedures/ queries to Tyler Tech Support - Coordinate access with City POC of required database back-up.
Exhibit A-1
Additional Scope of Work
Attachment 1
- Notify City POC of deployed reports within all applicable modules and case types. Respond to feedback and requested updates.
GIS Issue Resolution and Enhancement Services:
- GIS Support - As needed general GIS support tasks including data development, analysis, application development, training. This will include support focused on troubleshooting of GIS integration solutions or workflows related to EnerGov. Approach is to ramp down of GIS support services for the City to be the primary owners of support through the requested scope of services. - Troubleshooting GIS/EnerGov History Writer - Work with Tyler support team and Sunnyvale GIS staff to resolve ongoing problems with History Writer sync between EnerGov and GIS. Estimated 8 hours total.
- Importing and Displaying EnerGov Records in the Sunnyside GIS Platform - Work with Tyler support team and Sunnyvale GIS staff to design and automate tasks to pull EnerGov records into the Sunnyvale GIS platform for general mapping requirements. Estimated 20 hours total. - Implementation of full ArcGIS Enterprise test environment - Work with Sunnyvale GIS staff to implement a test environment of ArcGIS Enterprise. Estimated 40 hours total. - New WebGIS Tool for Editing Addresses - Develop a new WebGIS application that will allow for simple editing of the Sunnyvale Master Address Database. This new tool will work along side of the existing ArcGIS Pro solution. Estimated 20 hours total. - Decommission the SunGIS System for GIS Data - Work with Sunnyvale GIS staff to execute the final steps to decommission the SunGIS systems for GIS data purposes. Estimated 12 hours total. - Street Centerline Update Automation - Work with Sunnyvale GIS staff to design and automate a workflow of updated street centerlines from Santa Clara County to Sunnyvale. Estimated 36 hours total.
- ArcGIS Pro Migration - Portal Usage - Work with Sunnyvale GIS staff to review and implement best practices of ArcGIS Pro workflows related to Portal. Estimated 30 hours total. - Additional work on Parcel Update Automation - Work with Sunnyvale GIS staff to monitor and improve the existing parcel update automated routines. This may include the use of FME.
Estimated 45 hours total.
- Implementation of full ArcGIS Enterprise test environment - Work with Sunnyvale GIS staff to implement a test environment of ArcGIS Enterprise. This task would focus on implementing an ArcGIS Enterprise test platform that would be used to develop and test newer services and functionality prior to implementing production solutions. Additional discussions would occur to determine which components of the ArcGIS Enterprise platform are needed in the test environment.
Key City Responsibilities:
- City will provide a primary point of contacts (POCs) from IT available throughout the duration of services to manage issues and enhancements requested from City staff. The City POCs will manage tracking, communication, and follow-up with City staff. City will provide a designated back-up if the primary POC is unavailable.
- City’s POC will triage and prioritize issues and enhancement requests prior to submitting to PCG to be aware of all requested work and ensure work is within allocated budgeted hours. - City will ensure that sufficient requirements and details for all issues and enhancement requests are gathered prior to submitting to PCG, when available. - City will be responsible to submit Tyler Tech and ESRI support tickets and manage follow-up / responses when appropriate to resolve issues and requested enhancements. - City will be responsible for managing meetings related to EnerGov and ArcGIS including coordination, facilitation, and management of agendas, deliverables, and follow-up actions. - City will provide remote access and full system administrator access for PCG as required to complete the requested work. This includes, and is not limited to, access to VPN/virtual desktop logins, Google Chrome, EnerGov Application, EnerGov DB backups, Tyler Tech Project and City’s Sharepoint/ Shared/ SFTP Folders, and ESRI Applications and Environments.
Attachment 1
- City will work with Tyler Tech, ESRI, City IT, and other system vendors to provide login access and appropriate permissions to EnerGov environments and applicable systems for PCG to deliver requested services.
- City will manage version upgrades to EnerGov and ArcGIS directly with applicable system vendors. - City will seek training related to end-user onboarding, configuration, and admin training not included in the stated scope of services from Tyler Technologies and ESRI. - City will provide subject matter experts that are available throughout the duration of services to successfully deliver PCG services. In order to meet timelines, City will provide sufficient requirements and details for all issues and requests. City will provide answers to question and provide feedback and responses in a timely manner (within 2 business days). Issues and request lacking sufficient details or responsiveness may be cancelled.
Co
st Proposal:
The total not to exceed amount will be the following:
Requested Services Total
EnerGov Issue Resolution and Enhancement Services:
4/1/2023 – 6/30/2023 (3 months): Up to 80 hrs/ month (fixed $15,000/mo) 7/1/2023 – 6/30/2024 (12 months): Up to 20 hrs/ month (fixed $3,750/mo) EnerGov Fee Configuration: TBD Prior to June 2024 (Est. @ 180 hrs – billed @ $200/hr) EnerGov Report Development: 4/1/2023 – 6/30/2024 (Est. @ 100 hrs – billed @ $185/hr) GIS Support Services:
4/1/2023 – 6/30/2023 (3 months): Up to 20 hrs/ month (fixed $3,750/mo) 7/1/2023 – 6/30/2024 (12 months): Up to 20 hrs/ month (fixed $3,750/mo) GIS Enhancement Services: 4/1/2023 – 6/30/2024 (Est. @ 260 hrs – billed @ $185/hr) $45,000
$45,000
$36,000
$18,500
$11,
250
$45,000
$48,100
GRAND TOTAL $248,850
Attachment 1