We especially trained the project staff how to read complex mainframe datasets or XML data efficiently with DataStage. Supported the different DWH projects to setup connections to new sources.Added new investment banking XML real-time feeds to the EDWH leveraging Websphere MQ, DataStage and Teradata.Helped to setup a metadata layer that supports data lineage from the source to the target systems.Helped to customize the Teradata Financial Services Data Model (FSLDM) according to Unicredit needs.Designed the common ETL components and managed a specialist team that implemented and rolled-out the common components of this architecture to all projects in Austria, Italy, Germany and Eastern Europe.Advised Unicredit in the definition of a new corporate DWH/ETL architecture for simplified ETL development, better scalability, robustness and quality.
Enterprise data warehouse program to enable consistent corporate financial reporting and to establish a group-wide data warehouse governance.