REPORT/RECOMMENDATION TO THE BOARD OF SUPERVISORS
OF SAN BERNARDINO COUNTY
AND RECORD OF ACTION
October 24, 2023
FROM
ENSEN MASON, Auditor-Controller/Treasurer/Tax Collector
SUBJECT
Title
Employment Contract for Auditor-Controller/Treasurer/Tax Collector Programmer Analyst I
End
RECOMMENDATION(S)
Recommendation
1. Approve employment contract with Tran Nguyen to provide service and support to the Auditor-Controller/Treasurer/Tax Collector’s Information Technology Division as a Programmer Analyst I for the period of November 4, 2023, through October 30, 2026, for the estimated annual cost of $112,180 (Salary - $73,008, Benefits - $39,172), with the option to extend the term of the contract for a maximum of three successive one-year periods.
2. Authorize the Auditor-Controller/Treasurer/Tax Collector to execute amendments to the employment contract to extend the contract term for a maximum of three successive one-year periods on behalf of the County, subject to review by County Counsel.
3. Direct the Auditor-Controller/Treasurer/Tax Collector to transmit all amendments in relation to this employment contract to the Clerk of the Board of Supervisors within 30 days of execution.
(Presenter: John Johnson, Assistant Auditor-Controller/Treasurer/Tax Collector, 382-7005)
Body
COUNTY AND CHIEF EXECUTIVE OFFICER GOALS & OBJECTIVES
Improve County Government Operations.
Operate in a Fiscally-Responsible and Business-Like Manner.
FINANCIAL IMPACT
Approval of the recommended employment contract will not result in the use of additional Discretionary General Funding (Net County Cost). Position funding, including implementation costs, was funded by the Asset Replacement Reserve as part of the 2022-23 budget approved by the Board of Supervisors on June 14, 2022 (Item No. 103). Sufficient appropriation has been included in the Auditor-Controller/Treasurer/Tax Collector’s (ATC) 2023-24 budget and will be included in future recommended budgets.
BACKGROUND INFORMATION
ATC’s Revenue Recovery Division operations rely on an outdated, legacy collections and accounting application with limited support. This system is fragile, with system designs and architectures that are difficult to maintain and support. The challenges of this system necessitate a replacement. Request for Proposal (RFP) No. ACT122-ACTT-4463 for the Debt Collection System Replacement Project (Project) has concluded, and implementation with the chosen vendor is underway to implement the new system, marking a significant step toward operational optimization.
ATC’s Information Technology Division (ATC-ITD) is responsible for providing business analysis and project management services for the Project, as well as providing enterprise technical support to all ATC divisions. Currently, ATC-ITD has a demanding workload while facing a staffing deficiency and cannot provide a dedicated Programmer Analyst I resource required to support the Project needs. Given the Project's transition into the implementation phase, the demand for a dedicated Programmer Analyst I has become imperative and will ensure a successful project execution. The designated contract Programmer Analyst I will function as the technical liaison, providing assistance in managing integration planning, supporting testing and quality assurance endeavors, configuring workflows and business rules, administering system security, and facilitating communications between the customer and vendor regarding system requirements and design.
Recommendation No. 1 will allow ATC to utilize the recommended employment contract to employ Tran Nguyen as a Programmer Analyst I who will play a vital role in the Project team. This individual will be tasked with various responsibilities, including the development and configuration of workflows, system scripting, aiding in the data mapping and migration process, performing data validation and quality assurance, conducting requirements analysis, providing troubleshooting and support, collaborating closely with vendors, and maintaining technical documentation.
Recommendation No. 2 will allow ATC to execute a maximum of three successive one-year amendments to the employment contract with Ms. Nguyen as provided for in the contract. The employment contract can be terminated by either party at any time without cause, with 14 days’ prior written notice. The contract may be terminated immediately by the County, for just cause.
PROCUREMENT
Internal candidates were considered for the contract Programmer Analyst I position, and ATC recommends the appointment of Ms. Nguyen due to her experience in programming and application development. Ms. Nguyen is currently a Public Service Employee with ATC. She commenced her tenure on June 18, 2022, and has been an integral part of the Property Tax Legacy Systems Replacement (PTLSR) Project. Ms. Nguyen's technical background has provided critical contribution to the project and has been integral in the development of the web application programming interface components, integrating Azure Cloud data lake storage, and encryption technologies, allowing ATC to meet critical project deliverables.
In addition to her work on the PTLSR Project, Ms. Nguyen has made significant contributions to other ATC-ITD projects. Notably, she has played a key role in the development of the Countywide Wells Fargo Image Check Viewer application, focusing on designing and developing the front-end interface with Microsoft React, building and optimizing core back-end functionalities through the utilization of Azure Cloud infrastructure, .NET frameworks, and structured query language (SQL) databases. Ms. Nguyen was also a main developer of the ATC Apparel Online Store, an internal e-commerce website built with PowerApps and SharePoint List, providing ATC employees an effortless purchasing merchandise experience and facilitating store admins’ managing orders process.
Ms. Nguyen’s experience and education qualify her for the Programmer Analyst I position.
REVIEW BY OTHERS
This item has been reviewed by County Counsel (Cynthia O’Neill, Principal Assistant County Counsel, 387-5455) on September 28, 2023; Human Resources (Sandra Wakcher, Employee Benefits and Services Division Chief, 387-5858) on September 27, 2023; Finance (Penelope Chang, Administrative Analyst, 387-4886) on October 2, 2023; and County Finance and Administration (Paloma Hernandez-Barker, Deputy Executive Officer, 387-5423) on October 5, 2023.