Financial Data Warehouse - BASEL II compliant

Logo BASEL II BASEL II's main challenge from a technological perspective is not only calculating your Risk Weighted Assets, it is consolidating your data to be able to do the correct calculations.
This is true especially if you are a larger banking group with heterogenous IT landscape, lots of systems capturing your data, without semantical data integration already done in the past.

What IDS_Open can do for you consolidating your database landscape

  • Defining your logical data model (Contribution of your business people required)
  • Building an integrated and consolidated database holding your data
  • Building the necessary data transports and logistics
  • Documenting the data (static and dynamic Metadata Management)
  • Forwarding the required data to your calculation engine

How BASEL II impacts Datawarehousing

BASEL II basically impacts all requirements for data-integration and data collection:

"Data management is considered to be the top-challenge facing Banks in their BASEL-II compliance strategy" (Peoplesoft)
  1. The definition of target data consolidation architecture is crucial for achieving Basel-2 compliance
    Cost driving factors:
    1. Definition of logical data model
    2. Database licence costs
    3. Data logistics
    4. Hardware investments
    5. Data Quality Management
    6. Statistics and calculations
    7. DWH maintenance and future change requests

    Database licence costs (2) and maintenance (7) sum up to 70% of 5 years TCO costs. Using MySql technology reduces the DBMS license and maintenance and delivers scalable, high-performant and high-available DWH solution at minimum costs.

  2. Technical key competences are required:
    1. Project Manager (tech)
    2. DWH Architect
    3. Data Analyst
    4. Database Designer
    5. ETL Engineer(s)...depends on the number of source systems
    6. Data Quality Manager
    7. Data Integration Analyst
    8. QA-Engineer
    9. Rollout coordinator(s)..depends on number of sites

  3. The data model
    (image shows the conceptual logical data model for implementing BASEL-II. A complete logical and physical data model for MySQL-DBMS (including attributes and relationships) is available on request.