Case Study: Healthcare of Ontario Pension Plan achieves real-time trading, risk management, and faster reporting with SAP HANA

Maximizing Efficiencies with SAP HANA

HOOPP (Healthcare of Ontario Pension Plan) is one of Canada’s largest defined‑benefit pension plans, serving healthcare employees across 490 employers and paying C$1.9 billion in benefits annually. As trading became more complex and time sensitive, HOOPP needed faster, deeper, real‑time analysis from multiple data sources to support trading, risk management, and reporting and to replace inefficient, disparate data‑mart solutions.

HOOPP replaced its Microsoft SQL Server–based data mart with an SAP HANA–based agile data mart, using SAP Replication Server and SAP HANA Enterprise Cloud to deploy the solution in weeks. Traders gained near‑real‑time access to consolidated data, cutting trade‑report wait times from hours to about 1 second, reducing complex risk‑report build time to roughly 2 hours, shortening agile project turnarounds to two weeks, and lowering maintenance costs while enabling faster modeling and real‑time risk reporting.

Healthcare of Ontario Pension Plan

Jason Lee

Director of Information Services