Case Study: Leading Security Exchange in APAC achieves centralized real-time reporting and high-volume trade processing with HCL

Leading Security Exchange In APAC - Customer Case Study

Leading Security Exchange in APAC engaged HCL to create a basic data‑warehouse framework and automated reporting capability that would support future expansion to a full DWH with real‑time reporting. The exchange needed to extract and consolidate trade/order data from its QUEST system; HCL applied its OMX domain expertise along with Microsoft SQL Server 2008 and SSRS (and developed LogB/QREAL components) to meet this requirement.

HCL designed the SQL Server 2008 schema, built LogB to retrieve data from QUEST, consolidated distributed functionality into the QREAL application, and used SSRS to deliver reports on a fixed‑cost engagement. As a result, HCL’s QREAL centralizes data across multiple servers and NASDAQ OMX Click partitions, handles at least 8 million orders and 1 million trades per day, delivers real‑time online reporting with role‑based access and easy customization, replaces most legacy reporting systems, and improved management reporting and user adoption.