In June of 2007, the Saskatchewan Teachers' Superannuation Commission successfully completed a project to upgrade the Oracle 9i database to Oracle 10g Release 2.
ESTI is proud to share in the successful project that was undertaken jointly by the STSC and ESTI. This project represents another in a long history of successful projects dating back nearly 15 years.
After a considerable amount of analysis and strategic planning, the STSC decided to upgrade the database platform from Oracle 9i to Oracle 10g Release 2. One of the many factors included in the decision was the fact that Oracle 10g Release 2 has proven to be a solid performer and a stable environment for a number of ESTI clients. Oracle 10g will also provide the STSC with a platform to support new and exciting Internet based applications.
A key success factor for this project was a reliance on regression testing software to ensure all of the applications currently running at the STSC continued to run successfully on the new platform. The STSC staff was able to provide numerous test cases representing critical functionality that formed the basis for testing and verification. The test cases were plugged into an automated regression testing tool by ESTI analysts. The automated testing tool ensured a consistent process which could be re-used as many times as required to verify each application. Additional user acceptance testing was performed by STSC staff.
A number of major systems, used by the STSC administration staff to manage the day to day operations, were positively impacted by the upgrade through performance enhancements. Some of the systems impacted were the Retired Members System and Payroll application, a third party pension administration system and a number of benefit administration systems including Group Health and Long Term Disability.
Following is a key list of the new features contained in Oracle 10g Release 2:
ESTI Consulting Services provided end-to-end services for Oracle 10g Release 2 upgrade project including:
Congratulations to the Saskatchewan Teachers' Superannuation Commission on successfully completing this technology upgrade and ensuring timely service to its 14,000 active and retired members in Saskatchewan, other areas of Canada and Internationally.