San Mateo County Logo
File #: 20-190    Version: 1 Name:
Type: Resolution Status: Passed
File created: 3/18/2020 Departments: ASSESSOR-COUNTY CLERK-RECORDER-ELECTIONS
On agenda: 4/7/2020 Final action: 4/7/2020
Title: Adopt a resolution authorizing an amendment to the agreement with Sapient Corporation for APAS Data Cleansing and Conversion project and increasing the amount of the agreement by $3,886,400 for a new not to exceed amount of $20,188,348.
Attachments: 1. 20200407_r_ APAS Data Clensing Sapient Amendment 2, 2. 20200407_a_APAS Data Cleansing Sapient Amendment 2, 3. 20200407_att_Appendix E1 - List of Apps requiring VPN Tunnel Final, 4. 20200407_att_Exhibit E - Statement of Work # 3 Final, 5. 20200407_att_Exhibit E-1.1 EZ-Access Data Dictionary for Business Personal Property Final, 6. 20200407_att_Exhibit E-1.2 EZ-Access Data Dictionary for Real Property Final, 7. 20200407_att_Exhibit E-2 Data Inventory for non-EZ Access Data Sources Final, 8. 20200407_att_Exhibit E-3 Deliverables Final, 9. 20200407_att_Exhibit E-4 Roles and Responsibilities Matrix Final, 10. 20200407_att_Exhibit E-5 Data Cleansing Project Plan Final, 11. 20200407_att_Exhibit F - Fee Methodology and Payments (SOW #3) Final, 12. 20200407_att_APAS Data Cleansing Sapient Amendment 1
Special Notice / Hearing: None__
Vote Required: Majority

To: Honorable Board of Supervisors
From: Mark Church, Assessor-County Clerk-Recorder & Chief Elections Officer
Subject: Assessor-County Clerk-Recorder-Elections (ACRE) Assessor Property Assessment System (APAS) Data Cleansing Project

RECOMMENDATION:
title
Adopt a resolution authorizing an amendment to the agreement with Sapient Corporation for APAS Data Cleansing and Conversion project and increasing the amount of the agreement by $3,886,400 for a new not to exceed amount of $20,188,348.
body

BACKGROUND:
At the core of the business operations of the Assessor-County Clerk-Recorder & Elections' (ACRE) Appraisal Services Division is a digital data management system which stores and processes data relating to the ownership, characteristics, and assessment values of all taxable properties in the County. This Board at its December 11, 2018 meeting approved the Assessor Property Assessment System (APAS) Project (Resolution # 076320) to replace the Assessor's legacy data management system (the EZ Access System).

An essential component of the APAS effort is the cleansing and conversion of data from the legacy systems to the newly developed APAS system. ACRE conducted an extensive evaluation of Assessor data sources that would be within the scope of the APAS Data Cleansing and Conversion Project and determined that the APAS development and the APAS Data Cleansing and Conversion Projects could run in parallel. ACRE determined, however, that the projects did not have to start at the same time.
In July 2019, the ACRE team completed the evaluation of data sources that need to be cleansed and converted and documented the Data Cleansing and Conversion Project requirements. In September 2019, ACRE submitted the APAS Data Cleansing and Conversion Project Requirements to Sapient for them to provide a fixed bid for the project. The data cleansing and conversion project will run in alignment wit...

Click here for full text