2014 - 2022: fulfill all reporting and analytical requirements

Kunde: Banking Data Warehouse

Aufgaben:

• Create a new corporate wide Data Warehouse to fulfill all reporting and analytical requirements.
• As central data hub for all applications capture and store data from various new and modified operational systems and provide complete view of all business data for all business organizations and interfaces.
• My role as IT Architect was stream lead for data provisioning. For about 15 interface systems I?ve developed the interface design and specifications.
• Furthermore for the stream data modeling I?ve specified the modeling guidelines, guided the data modeler for the tool IBM Infosphere Data Architect.
• I was involved during the Pilot phase in the part database performance and administration as soon as IBM Industry model for banking.
• From October 2014 until March 2015 I was in the evaluation and design phase working in the stream data provisioning and data modeling
• From April 2015 until 2022 Administration for Database, Data Transformation and Loadi

Kunde: automotiv Industrie

Aufgaben:

• For a new part sampling application I was responsible to capture and define the business and technical requirements for the application and create the logical and physical data models
• The target architecture was a cloud solution with independent containers
• The physical data models have to be modelled for IBM DB2 and PostgreSQL