Legislation Details

File #: 692   
Type: Consent Status: Passed
File created: 7/16/2019 Department: Sheriff/Coroner/Public Administrator
On agenda: 7/23/2019 Final action: 7/23/2019
Subject: Amendment No. 1 to Contract with TriTech Software Systems for Upgrades to the Sheriff/Coroner/Public Administrator's Records Management System
Attachments: 1. COV-SHERIFF-7-23-19-AMENDMENT TO CONTRACT WITH TRITECH SOFTWARE SYSTEMS, 2. CON-SHERIFF-07-23-19 Amendment to Contract with TriTech Software Systems, 3. Item#42 Executed BAI, 4. Executed Contract # 18-26-A-1

REPORT/RECOMMENDATION TO THE BOARD OF SUPERVISORS

OF THE COUNTY OF SAN BERNARDINO

AND RECORD OF ACTION

 

July 23, 2019

 

FROM

JOHN McMAHON, Sheriff/Coroner/Public Administrator, Sheriff/Coroner/Public Administrator 

         

SUBJECT                      

Title                     

Amendment No. 1 to Contract with TriTech Software Systems for Upgrades to the Sheriff/Coroner/Public Administrator’s Records Management System

End

 

RECOMMENDATION(S)

Recommendation

1.                     Approve Amendment No. 1 to Contract No. 18-26 with TriTech Software Systems to provide software licenses, software installation, system configuration, data conversion, programming, custom databases interface, training, project management services, and a one-year maintenance agreement necessary to upgrade the Sheriff/Coroner/Public Administrator’s Records Management System, without changes to the original amount of $1,186,750, extending the term by nine months from July 1, 2019 through March 31, 2020.

2.                     Authorize the Sheriff/Coroner/Public Administrator to execute change orders to the contract as needed, subject to review by County Counsel, with an increase in amount not to exceed $35,000 (from $25,000) per change order as long as the total aggregate amount of such change orders does not exceed 18% of the original contract amount ($213,615) and the change orders do not amend the contract term.

3.                     Direct the Sheriff/Coroner/Public Administrator to transmit all contract change orders for the upgrade of the Records Management System with TriTech Software Systems to the Clerk of the Board within 30 days of execution.

(Presenter: John Ades, Captain, 387-0640)

Body

 

COUNTY AND CHIEF EXECUTIVE OFFICER GOALS & OBJECTIVES

Improve County Government Operations.

Operate in a Fiscally-Responsible and Business-Like Manner.

Provide for the Safety, Health and Social Service Needs of County Residents.

 

FINANCIAL IMPACT

Approval of this item will not result in the use of additional Discretionary General Funding (Net County Cost). The original contract amount of $1,186,750, and change orders in the amount of $72,294, were funded with one-time public safety sales tax revenue (Prop 172) carried over from prior years. Any additional change orders required through the remainder of the contract period, not to exceed $141,321, will be funded within the Sheriff/Coroner/Public Administrator’s (Department) 2019-20 budget (4430151000).

 

BACKGROUND INFORMATION

The Department’s Records Management System (RMS) was originally installed in 2002. The RMS provides the Department with a valuable document tracking system that is divided into a series of components and data subsystems. Each of these sub-systems interacts with each other to add, modify, or delete specific information. Examples include deputy reports, traffic accident reports, citations, sex registrants and field contacts.

 

Implementation of the Department’s RMS upgrade began in 2018 to take advantage of new and improved technologies, through a unified law enforcement records management software suite that provides personnel with an enhanced workflow to create, update, and submit reports from the field, in combination with information from other existing databases such as the Department’s Computer Aided Dispatch (CAD), Records Imaging System (RIS), and the District Attorney’s Storage Optical Records Management (STORM) system to file criminal complaints.

 

The Department’s RMS system is currently functioning; however, a core component of the application has been unable to be completed due to additional requirements placed on TriTech Software Systems (TriTech) by the Department. Without extending the term length, or ensuring the continuity of the contract after the June 30, 2019 date, the ability to successfully migrate criminal reports to the RIS would not be possible. The RIS is a key component in accessing reports after they are filed with the District Attorney; without the additional components that are currently needed reports will be inaccessible. These reports are required for services such as sealing records, public records requests, and requests from the public for copies of reports where the requestor is listed as a victim, suspect, or other participant who is legally entitled to a copy of the document.

 

PROCUREMENT

On January 23, 2018 (Item No. 47), the Board approved Contract No. 18-26 with TriTech in the amount of $1,186,750 to provide the software licenses, software installation, system configuration, data conversion, programming, custom databases interface, user training, and project management services, along with a one-year maintenance agreement related to the upgrade of the Department’s RMS for the period of January 24, 2018 through June 30, 2019. 

 

Between September 4, 2018 and April 3, 2019, the Department issued five (5) change orders to the contract with TriTech, for additional RMS Storm interface and implementation services, in the total aggregate amount of $72,294. During this time, the original go-live date of December 11, 2018 was delayed due to unforeseen changes that needed to be made to the software system. Once the system was live, and when testing was resumed in mid-June 2019, it was determined that additional changes were still necessary for the system to operate in a more stable manner, and a contract extension would allow for additional testing of the system. However, given the timeframe, it was not possible for the Department to schedule an item prior to the Contract’s original expiration date of June 30, 2019.

 

Essential change orders are still expected; total aggregate additional costs are approximated and not to exceed 18% of the original contracted amount ($213,615). Authorizing the Sheriff/Coroner/Public Administrator to execute contract change, as needed, shall allow the project to maintain an appropriate timeline to reach completion within the requested extension term length of nine (9) months, while providing appropriate Board-level control of the overall project.

 

The Department recommends approval of the proposed amendments to allow for the continued upgrade and testing of the Department’s RMS, extending the contract’s termination date to March 31, 2020 and increasing the aggregate change order amount to 18% of the total original contract amount ($213,615) with each change order not exceeding a maximum amount of $35,000. The contract provides for termination by either party with a ninety (90) day advance written notice of termination for all, or part, of the services described therein.

 

REVIEW BY OTHERS

This item has been reviewed by County Counsel (Richard D. Luczak Deputy County Counsel, 387-5455) on July 2, 2019; Purchasing Department (Michael Candelaria, Lead Buyer 387-2060) on July 2, 2019; Finance (Wen Mai, Administrative Analyst, 387-4020) on July 3, 2019; and County Finance and Administration (Kelly Welty, Deputy Executive Officer, 387-5423) on July 8, 2019.