MAURICE 

Volksbank is currently in the midst of a major change involving major steps in the in the development of a new data warehouse (DWH).  A new DWH built with new technology and new modeling approach is necessary to meet the increasing demand for data where the regulator has strict requirements for quality, content and timelines.

The DWH KWW (customer-will-won-won) team is one of the teams within the DWH domain and is responsible for all DWH-related issues within the customer-will-won-won reporting chain.

Under the ‘Force’ project, the current mid-office for mortgage applications will be replaced. The new system with the eponymous name “Force” will also need to connect to the new DWH.

From the source analysis, the source system Force is accessed one-to-one to the Teradata EDV environment (the Elementary DataVault layer) of the DWH. For this purpose, ETL software was built for loading the data. Then, using Powerdesigner, the mappings were modeled to the new FSLDM-based DWH data model.

Challenges are in the area of deadlines; modeling; dual periods where both the old mid-office and the new mid-office are in use and how do we ensure minimal impact on existing reporting chain.

In addition to providing access to the new mid-office system, the DWH KWW team is also responsible for functional management -think of changes and incidents- on the DWH ‘client-will-home’ reporting chain. The team is also the point of contact for all ‘Woon’ related DWH reporting needs.

The current team currently consists of a Product Ower, a Scrum Master, and five DWH engineers. Work is agile-driven with two-week sprints and periodic scrum meetings.