Julius BaerLead Business Analyst, Global Datamart for Analytical Reporting
Apr. 2013 - Oct. 2013Zurich, SwitzerlandA group of about 100 business experts created the tendency to order data in various historically grown, and uncoordinated ways.
Although the organization had no data warehouse infrastructure, in an attempt to overcome this situation, it was decided to build a datamart on top of SAP BO technology.
The vision of the project was, that people joining this fast growing organisation from major Swiss banks will recognise the common banking concepts like account holder, business relationship management, various direct and indirect service models, as well as detailed information about holdings and transactions.
In the absence of a business architecture, I had to provide a conceptual layer over the terminology, which was then used to create consistent, and easy to understand structures for the SAP BO business layer.
I developed an Excel based method to describe the SAP BO structures, and keep them in synch between the various releases of the data mart, as well as different variants for Asia, Swiss, and European booking centres.
To connect from the conceptual view to the physical layer, classical E/R modelling was used as a means of communication with the programmers.
The resulting solution allowed for the first time to:
• Compare analytical and MIS view on service models
• Connect usefully Position and Transaction Data
• Explain various asset classification systems in place In parallel I supported business management in setting up plans and structure for data management, introducing the concepts of data stewardship and data ownership.