REPORT/RECOMMENDATION TO THE BOARD OF SUPERVISORS
OF SAN BERNARDINO COUNTY
AND RECORD OF ACTION
December 14, 2021
FROM
JASON ANDERSON, District Attorney
SUBJECT
Title
Amendment to Contract with Microsoft Corporation for Integrated Justice Case Management System - Phase IV
End
RECOMMENDATION(S)
Recommendation
1. Approve Amendment No. 5, effective December 20, 2021, to Contract No. 19-776 (Work Order T002198-251306-296790) with Microsoft Corporation in the amount of $969,800, increasing the total amount from $2,727,531 to $3,697,331 for post-implementation enhancements for the District Attorney’s new case management system, and extend the term for an additional six months, for a total contract term of December 10, 2019 through June 30, 2022, to allow for completion of the enhancements.
2. Authorize the Purchasing Agent to issue future change orders up to $10,000 to change the project hours within and between tasks, change non-financial/non-material terms, and sign corresponding amendments to Work Order T002198-251306-296790 with Microsoft Corporation, subject to County Counsel review.
3. Authorize the Auditor-Controller/Treasurer/Tax Collector to post the necessary budget adjustments to the District Attorney’s 2020-21 budget, as detailed in the Financial Impact section (Four votes required).
(Presenter: Michael Fermin, Chief Assistant District Attorney, 382-7714)
Body
COUNTY AND CHIEF EXECUTIVE OFFICER GOALS & OBJECTIVES
Improve County Government Operations.
Operate in a Fiscally-Responsible and Business-Like Manner.
Pursue County Goals and Objectives by Working with Other Agencies and Stakeholders.
FINANCIAL IMPACT
Approval of this item will not result in the need for additional Discretionary General Funding (Net County Cost). The $969,800 cost of Amendment No. 5 with Microsoft Corporation (Microsoft) was not included in the District Attorney’s 2021-22 Adopted Budget but will be funded by a one-time use of AB109 reserves.
|
Fund Center |
Commitment Item |
Description |
Action |
Amount |
|
4500001000 |
40458711 |
Realignment 2011 |
Increase |
$969,800 |
|
4500001000 |
52002445 |
Professional Services |
Increase |
$969,800 |
BACKGROUND INFORMATION
The District Attorney (Department) is the public prosecutor and has the mandated responsibility to prosecute crimes committed within the County pursuant to Government Code 26500. Law enforcement agencies submit crime reports and investigative information to the Department for review and potentially prosecution. The Department submits cases electronically with the Superior Court to start the prosecution process.
The Department began identifying existing business processes and functionality to be automated in preparation for its new case management system in 2015. There have been four phases of the development and configuration of the new case management system. Phase I was approved May 24, 2016 (Item No. 70), Phase II was approved on June 13, 2017 (Item No. 46), Phase III was approved on September 25, 2018 (Item No. 19), and Phase IV was approved on December 10, 2019 (Item No. 16) and was set to expire on March 31, 2021.
The Phase IV Board Agenda Item on December 10, 2019 (Item No. 16), approved Contract No. 19-776 with Microsoft Corporation in the amount of $1,922,471 to design and configure functionality to enable mobile access from the Superior Court, provide discovery documents to the Public Defender, create portals for law enforcement agencies, create queries, and format report. This item included a delegation of authority to the Purchasing Department (Purchasing) to approve change orders up to $10,000 to change project hours within and between tasks, change non-financial/non-material items, and sign corresponding amendments to the Phase IV work order T002198-251306-296790. At that time, it was anticipated that the Department would go-live with the new case management system in the fall of 2020.
Phase IV consists of Contract No. 19-776 and five amendments. Four of those amendments have been approved by Purchasing as delegated by the Board of Supervisors (Board). Amendment No. 1, a non-financial change order, was approved by Purchasing on September 29, 2020. Due to ongoing travel restrictions from COVID-19, funds were moved from the travel budget to provide more support for user-acceptance testing and staff training.
Amendment No. 2 was approved by Purchasing on March 2, 2021, and extended the end date to December 31, 2021. As a result of COVID-19, aspects of the project, and correspondingly go-live, were delayed until the fall of 2021. Amendment No. 3 was approved by Purchasing on May 17, 2021, and made a correction to add the County’s electronic signature provision that is now a standard clause in County contracts. Amendment No. 4 was approved by the Board on June 22, 2021 (Item No. 43) in the amount of $805,060, bringing the total cost of the contract to $2,727,351, with no change to the end date of December 31, 2021. As a result of user-acceptance testing, additional functionality was identified as being critical to operational efficiency. This functionality included the ability to create subpoenas in bulk with editing capability, the prevention of duplicate entries, the ability to mask confidential information, and better tracking of cases that are turned down.
The Department implemented its new case management system, STAR:TNG on October 12, 2021. STAR:TNG was designed and built on a platform (Microsoft Dynamics 365) that offers the flexibility and scalability to adapt quickly to the evolution of the Department’s business needs. STAR:TNG is cloud-based and contains additional features and functionality that was not provided by the old legacy system.
As staff learn to efficiently use STAR:TNG, aspects are identified that can be improved upon. These aspects are submitted to the Department in the form of change requests. Some of the change requests, or enhancements, require research and programming and must be completed quickly to ensure the Department remains in compliance with Penal Code Section 825 in timely filing cases with the Superior Court. Other enhancements can wait until the Department is able to conduct a competitive solicitation to procure a contractor to provide post-production enhancements, maintenance, and support.
The Department plans to conduct the competitive solicitation for maintenance, support, and enhancements in the spring of 2022. Enhancements include improving the ease of use of the portal that contains discovery files for defense attorneys, improving interfaces with other agencies or departments including electronic filing with the Superior Court and case intake from the Sheriff’s Department. Other enhancements include automating paper submission process of cases from other law enforcement agencies in the County. Additional work is needed on the process that generates and reports on subpoenas, adding subsequent charges to suspects or defendants in the system, and streamlining the data entry process for misdemeanor cases.
The solicitation will include evaluating proposals based on many requirements, such as cost, experience with implementing and optimizing applications within the Microsoft Dynamics 365 platform, workload capacity, and helping the Department to create a road map for future case management system support and development.
The Department’s contract with Microsoft will end December 31, 2021. The Department requests Amendment No. 5 to extend the contract to June 30, 2022, and increase the contract amount by $969,800 to allow Microsoft to finish the high-priority enhancements and provide post-production support until a new vendor is under contract for those services.
PROCUREMENT
County Policy 11-04 requires departments to obtain Board of Supervisors approval for the competitive and non-competitive purchase of services exceeding $200,000 annually. Amendment No. 5 to Contract No. 19-776 is non-competitive due to maintaining system compatibility with the development in prior phases of the case management system, and also requires a continuation of specialized services provided by Microsoft. Amendment No. 5 will allow Microsoft to provide post-implementation support and configure enhancements until the Department can conduct a competitive solicitation in the spring of 2022. The Department plans to contract with a different vendor for post-production enhancements, maintenance and support. Purchasing concurs with the non-competitive justification of system compatibility and specialized services.
REVIEW BY OTHERS
This item has been reviewed by County Counsel (Katherine Hardy, Deputy County Counsel, 387-5455) on November 19, 2021; Purchasing Department (Michelle Churchill, Supervising Buyer, 387-2070) on November 19, 2021; Auditor-Controller/Treasurer/Tax Collector (Vanessa Doyle, Chief Deputy Controller, 382-3195) on November 22, 2021; Finance (Carl Lofton, Administrative Analyst III, 387-5404) on November 24, 2021; and County Finance and Administration (Robert Saldana Deputy Executive Officer, 387-5423) on November 24, 2021.