Laserfiche WebLink
Amend Agreement with Chazey Partners, Inc. <br />February 4, 2020 <br />Page 3 <br />4. Automating project billing data entry into ePersonality: Because the City is engaged in <br />various projects funded through state and federal grants, labor hours allocated to each <br />project must be tracked for grants management and billing purposes. Chazey utilized <br />Robotics Process Automation (RPA) to automate data entry and allocation of project labor <br />hours from a timekeeping database directly into the City's ePersonality payroll system. <br />Currently this process is a highly manual, time-consuming effort that takes one FTE in PWA <br />approximately 2 days each month to complete. After the automation is complete, and <br />following a payroll software upgrade, the time to complete this process will be reduced to a <br />half -day of effort or less each month. <br />It was subsequently decided by PWA Management and the project governance committee that, <br />using the Opportunity Matrix as a guide, the remaining 58 opportunities would be prioritized and <br />implemented by PWA staff in conjunction with supporting City agencies. Chazey will complete the <br />four selected projects, providing software programming and implementation instructions, where <br />required. <br />The requested compensation increase of $91,735 will allow Chazey to be compensated for work <br />completed in the delivery of the expanded Scope of Work (Exhibit 1). As stated earlier, the <br />additional Scope of Work was to expand the scope of the Business Processes Assessment and <br />Implementation Project, including the administrative processes of the newly added Building <br />Maintenance, Fleet Services, Central Stores, and Corporate Yard operations from the Finance and <br />Management Services Agency to PWA. <br />STRATEGIC PLAN ALIGNMENT <br />Approval of this item supports the City's efforts to meet Goal #7 - Team Santa Ana, Objective #5 <br />(create a culture of innovation and efficiency within the organization), Strategy E (identify best <br />practices and opportunities for process improvement and automation across City departments in <br />order to provide efficient and effective delivery of City services to the community. <br />ENVIRONMENTAL IMPACT <br />There is no environmental impact associated with this action. <br />FISCAL IMPACT <br />Expenditures for the Chazey Partners, Inc., agreement amendment will be paid by Public Works <br />internal service funds, accounted for in the Public Works Administration & Planning fund, as <br />outlined below: <br />FISCAL <br />YEAR <br />ACCOUNTING <br />UNIT -ACCOUNT# <br />FUND <br />DESCRIPTION <br />ACCOUNTING UNIT, ACCOUNT <br />DESCRIPTION <br />AMOUNT <br />Public Works Admin <br />Public Works — Admin Services, <br />FY 2019-20 <br />10117601-62300 <br />$91,735 <br />& Planning <br />Contract Services — Professional <br />Amendment Total: <br />$91,735 <br />All funds are budgeted and available for expenditure in Fiscal Year 2019-20. <br />25B-3 <br />