RaPID© is a software based on a web interface (Edge, Firefox, Chrome and Safari) and an Oracle database (SE or EE) covering risk (credit, liquidity, market, interest rate risk), accounting / controlling, regulatory reporting and treasury.
- Banks are required to submit a set of standard reports to their supervisors/regulators as part of supervisory review. As such Banks in UAE registered at Dubai International Financial Centre (DIFC) are required to submit regular standard reports to the Dubai Financial Services Authority (DFSA).
- A robust internal reporting set up supported by comprehensive reporting tools embedded with a dedicated Risk database is a must for banks to comply with timely and accurate submission of their reporting. Here comes the role of RaPID©, a sophisticated database architecture with powerful reporting tool.
Salient Features of RaPID©
What makes RaPID© distinguishable from its competitors in the market are:
Easy integration
Core banking and other existing applications of the Bank.
Robust Data Sanctity
Checks and reconciliation framework.
Simple metadata mapping
framework with user friendly GUIs.
Full drill down
to the underlying data including cash flows.
Simple interaction GUIs
enables slicing and dicing of the reports with drill down facility coupled with capability of multi-dimensional filtering options such as Group level, affiliates or branch level, domestic or global, standalone or consolidated basis etc.
Integrated cash flow and risk engine
RaPID© – high level architecture design
- RaPID© allows quick mapping and loading of contract level as well as GL balances from the source systems through integrated ETL.
- A reconciliation report allows the comparison of the loaded financial instrument with a reference (usually from the general ledger).
- The job control allows automating all relevant process steps
- The administration module defines access rights, roles and main configuration of the system.
- Look-up tables enable the users to define data definition, set rules, filtering criteria, computation logics etc., of various reports.
- Validation process ensures checks and balances.
- For each step there is an audit trail
- When it comes to any reporting tools, the toughest part is data definition and mapping. In general, it is one of the times and resource consuming activities requiring heavy involvement of end-user and IT report developers and most cases it remains a challenge of bridging gaps between end-user and technical personnel.
- RaPID© solves this problem with a set of simple and flexible end-users’ options. With this feature, report designing by end-users’ becomes a hassle-free task without much dependency on technical assistance/personnel.
Simple & flexible user interface for report designing
The key features of RaPID© include among other things
- Unique reporting data identifies/coding - each and every data fields / group of fields in the Reporting are identified with a unique label to ensure consistency and accuracy of reporting lines and cross validation across various Reporting.
- Look up Tables provides an easy and flexible interface where user can quickly set up the data definition, rules for filtering, grouping, categorizing, segmenting, aggregating and dissecting data based on multi-dimensional user defined criteria.
- Computation logics & formula builder - RaPID© also provides a facility for user to define some computation logics /formulae to drive the required missing values/ data fields from the source data as according to the user defined criteria/ rules.
- User-friendly interface for the reports provides user an effective an instant report generation based on various user defined scenarios and other pre-defined aggregating / filtering criteria – no batch processing / end of day process required.
It also provides easy exporting options in XL format in order to directly upload the data into DFSA reporting portal.
Checks and Balances – Cross validations of the reports
RaPID© provides a robust framework for check and balances for DFSA reporting line validations across different reports to ensure consistency and accuracy as required by DFSA reporiting template.
It provides a comprehensive validation report after checking all the cross validation nodes and rules defined by the end-user.
Below is a print screen of the reporting framework of RaPID© (all data randomly generated).
Supported Reports
B10A, B10B-B, B10B-D, B10C, B10D, B100, B110, B120, B130, B130A, B130B, B130C, B130D, B140, B140A, B140B, B140C, B140D, B140E, B140F, B140G, B140H, B150, B180, B190, B20A, B20B-B, ,B20B-D, B20C, B20D, B20E, B210, B220, B230, B240, B250, B260, B270, B280A, B280B, B30, B310, B320, B330, B340, B350, B360, B370, B380, B40A, B40B, B410, B420, B430, B440, B450, B460, B470, B50A, B50B, B510, IN10, IN100, IN110, IN120, IN130, IN140, IN150, IN160, IN180, IN20, IN200, IN210, IN30, IN40, IN50, IN60, IN70, IN80, IN90