Updating a database this complex was like building a 10,000 piece puzzle according to Software Developer, Lisa Steed.
Stanislaus County has saved over $1,000,000 by completing a required update to the Oracle PeopleSoft application version 9.2 with a team composed entirely of county staff. Outside consultants were not hired to complete the project, which is typical for this level of technical work. Beginning in December 2016, county staff across multiple departments, including Auditor-Controller Payroll, Chief Executive Office, Human Resources, Risk Management, and Strategic Business Technology launched a system upgrade in order to bring the application to the required version by December 2017 in compliance with Oracle maintenance requirements and to avoid additional maintenance costs.
This is the second time county staff alone have upgraded Oracle PeopleSoft. In 2011 a similar upgrade to version 9.1 was performed. Without the use of consultants, the extensive upgrades were challenging but saved a combined estimated $1.6 to $2 million to the county. Throughout the duration of the project, payroll processing remained seamless. Special thanks to Lisa Steed, Senior Software Developer for her diligence and hard work on the project.