Business Intelligence





The efficient reporting and distribution of information is essential to streamlining day-to-day operations in any office environment. The Saskatchewan Teachers' Superannuation Commission (STSC) identified the need to implement a solution that centralized information from different areas across the organization such as task management, staff scheduling, document management and reporting of payroll and pension data. To meet these needs, the STSC and ESTI worked together to create an internal use only site entitled the my.tsc.com website.

Business Intelligence (BI) is a term used to describe the applications and practices that are employed to integrate, analyze and present business information. Oracle has developed a tool called Application Express (APEX) that makes the development and deployment of web-based BI applications less dependant on a wealth of programming experience, allowing developers to concentrate more on what information is important to present rather than on the technical details of how to present it. ESTI has leveraged APEX to build the new my.tsc.com website. This site is a dashboard type application that displays the important business information using a single point of access with a simple interface that is intuitive and easy to navigate. Some key features include:

  • Direct access to the ESTI ticket system with real-time reporting of ticket statistics and statuses.
  • Task management allows staff to monitor on-going projects and important business events in their own area, as well as in other areas across the organization. This leads to greater accountability and a better understanding of how the STSC operates as a cohesive unit.

  • Document management and version control allows documents to be stored in and accessed from a centralized repository. Documents can also be attached to a specific task. The versioning component allows different versions of the same document to be stored so that changes can be easily tracked.

  • Real-time reporting of payroll summary information and pension statistics (including retirements, terminations and deaths) over a user-defined period of time.

Congratulations to the STSC on implementing the my.tsc.com website. The technology used to realize this solution ensures that the website can continue to change and evolve along with the needs of the STSC. The team for the project was made up of the following people:

STSC

  • Shirley Robertson (Acting Executive Director)
  • David Barnard (Former Executive Director)
  • Connie Kitz (Manager Financial Operations)
  • Yvonne Anderson (Manager Pension Programs)
  • Carol Moldovan (Manager Pension Payroll)
  • Marguerite Hyde (Assistant Manager Financial Operations)

ESTI

  • Mark Dick (Project Manager)
  • Bryce Allen (Lead Developer)