Financial Trade Reporting Solution

crystal_reports@x

Financial Trade Company Overview

One of the Singaporean multinational banking and financial services company, which is the largest bank in South East Asia by assets and among the largest banks in Asia. With operations in 17 markets, the bank has a regional network spanning more than 250 branches and over 1,100 ATMs across 50 cities.

Problem Statement / Goals and Requirements

  1. Goal was to create a regulatory reporting framework which can generate reports based on pre canned query. End users were top executive of Bank, mainly business user, not technical users.
  2. Reports should also be allowed to bulk generated and exported in various format like text, excel and PDFs.
  3. Framework should be such that adding new reports to it should not require code changes and could be done on the fly.
  4. Reports should capture the lifecycle of trade, once front office system passes the booked trade to back office system
  5. Report should cater to the different user group Marketing, Finance, Compliance, SecOps, Institutional, Retail

Business Drivers

  1. Collaborative Data – Business users required to export the reports in such editable manner that additional data like target, projections and other data can be added to data from reports.
  2. Data Retention – System should allow a better control on retention period of data through minor configuration.
  3. Quick reports – System should have inbuilt queries, where user can simply click “Generate” to fetch reports with pre-defined queries, without having to create new queries every time.
  4. Audits – Reports are required for scheduled audits and regulatory requirements.

Solution – Key Highlights

  1. Developed a strong understanding of the trading domain and life cycle.
  2. Defined a downstream warehouse to an OLTP system.
  3. The back office data was stored in Oracle Data warehouse.
  4. Created a reporting framework with pre-defined SQL, using SAP crystal reports.
  5. Design, plan and milestones were validated at the start of project to make sure that all stakeholders are aligned. Agile methodology was adopted to fit the changing requirements of client.
  6. Provided on-site senior level technical support for every major release.
  7. Completed the development of framework within ~14 calendar weeks.

Result

The Reports are pdf files with header sections indicating report id, name, index and the body contains the date. The reports can be sorted on columns and has report parameters on which it runs. The report also carry sub totals and rows totals.

More case studies on Reporting services

Health Care Analytics & ReportingBanking Industry,  Social Dashboard Analytics


HashedIn provides consulting and professional services in business intelligence in finance and banking, reporting and analytics to help businesses derive actionable insights from various bits of data that is gathered. To learn how we can help you, contact us.