We built the banking dashboard for one of the multinational banking and financial services companies of Singapore, which is the largest bank in South East Asia by assets and among the largest banks in Asia.
Problem Statement / Goals and Requirements
Goal was to create a regulatory reporting framework which can generate reports based on pre canned query. End users were top executives of Bank, mainly business users, not technical users.
Reports from the banking dashboard should also be allowed to be bulk generated and exported in various formats like text, excel and PDFs.
Framework should be built in such a way that adding new reports to it should not require code changes and could be done on the fly.
Reports should capture the lifecycle of trade, once front office system passes the booked trade to back office system.
Report should cater to the different user groups like Marketing, Finance, Compliance, SecOps, Institutional, Retail.
Collaborative Data – Business users required to export the reports from the banking dashboard in such an editable manner that the additional data like target, projections and other data can be added to the data from reports.
Data Retention – System should allow a better control on retention period of data through minor configuration.
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.
Audits - Reports are required for scheduled audits and regulatory requirements.
Solution - Key Highlights
Developed a strong understanding of the trading domain and life cycle.
Defined a downstream warehouse to an OLTP system.
The back office data was stored in Oracle Data warehouse.
Created a reporting framework with pre-defined SQL, using SAP crystal reports.
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.
Provided on-site senior level technical support for every major release of the banking dashbaord.
Completed the development of framework within ~14 calendar weeks.
The Reports from this financial dashboard are pdf files with header sections indicating report id, name, index and the body contains the date.
These reports can be sorted on columns and has reporting parameters on which it runs.
The report also carries sub totals and rows totals.