Laserfiche WebLink
The proposed upgrade changes are summarized below: <br />• Move from Oracle to SQL <br />• Update payroll to Time based <br />• Remove old tables (we currently have data back to 1994) <br />• Potential upgrade <br />• Project timeline likely 4+ months <br />• Proposal and supplemental documents attached <br />• SQL Server license has been purchased by IT. <br />The database move from Oracle to SQL is expected to significantly impact payroll <br />operations (EXHIBIT 1). <br />DISCUSSION: <br />Ongoing staff shortage and the pending retirement of P W 3 s Finance Manager is expected <br />to cause PW accounting issues the longer we go without being fully staffed. It might be <br />prudent to hire a Finance Manager in June and allow sufficient training prior to our <br />manager retiring on 12/3112022. While this action is not expected to fully alleviate work <br />program backlog, it is expected to help stabilize the Finance Division going into fiscal <br />year 2023. <br />PW's fiscal analyst specializing in payroll will likely need a fair amount of capacity <br />supporting the Cayenta software upgrade. Major software upgrades are generally <br />wrought with difficulties but by also changing the database management software more <br />pending issues need to be recognized. Currently tools are used to move data from the <br />financial system to third party software utilized within PW. These tools will likely be <br />obsolete once the upgrade takes place. Many of these tools have allowed efficiencies to <br />be gained that will now be lost. We cannot hire consultant support as no one knows the <br />current database and the related programs better than Scott Casey, our Fiscal Analyst <br />managing payroll. It is regrettable that we were not aware of the proposed software <br />upgrade until recently. We are not in a good position supporting the software upgrade <br />given current staffing shortages in PW. <br />FISCAL IMPACTS: <br />PW budgeted a Project Manager for 2022 that we have elected not to fill for the <br />remainder of 2022. The current savings to personnel budgeted in 2022 is estimated at <br />being: ($45.90/hr)(2080 hrs/yr) = $95,472. PW proposing utilizing personnel budget <br />unused in 2022 offsetting the expense of hiring a Finance Manager ahead of Remeto's <br />retirement on 12131/2022. Seven months of the current Finance Manager's salary equates <br />to: $54,782. <br />ATTACHMENTS: <br />EXHIBIT 1: CAYENTA UPGRADE DOCUMENTS <br />Page 2 of 3 <br />Public Works "Work Session Staff Report", 2022 <br />