Official Beta Test partner of IBM for IIS vNext, in particular the web-based DataStage Data Flow designer. Helping IBM to reshape DataStage.
DataStage migration from 8.1 Linux Grid to 11.5 Linux Grid. The migration is currently performed by 1 DataStage developer from our team and 1 PM from the customer. I am acting as advisor and helped out with setting up the new platform, especially the Protegrity ? Datastage implementation.
Contribution:
Applied Technologies & Methodologies:
Common Data Warehouse migration project from DB2 SQW to DataStage in order to establish a more robust ETL and to add full end to end data lineage based on Information Server Governance Catalogue. This project is fully delivered by my company with 4 developers and 1 PM. After the initial 20 days POC in 2016 the customer was convinced and contracted us for the full project. The project consists of 400 SQW control flows containing over 2600 SQL scripts and over 400 Unix shell scripts.
Contribution:
Applied Technologies & Methodologies:
Stabilization of critical SLAs from the common data warehouse platform to Group Treasury. SLAs were missed by many hours every day and data was found inconsistent.
Performance Optimization in Teradata, DataStage and TWS. DataStage Migration from 8.7 (AIX) to 11.3 (Linux)
Contribution:
Applied Technologies & Methodologies:
Enterprise data warehouse program to enable consistent corporate financial reporting and to establish a group-wide data warehouse governance.
Contribution:
Applied Technologies:
The engagement consisted of two parts:
Applied Technologies & Methodologies:
4 days tailored DataStage Update Training 8.1 to 9.x and 11.x for Unicredit’s near shore team with emphasis on XML processing.
Contribution:
Applied Technologies & Methodologies:
Teradata DWH project review. BMW asked for an independent review of their DWH solution as provided by Teradata before they are signing it off. The review revealed major architectural as well as implementation issues which are being fixed currently by Teradata.
Contribution:
Applied Technologies & Methodologies:
DWH Timeline improvements & Optimization. This project was all about to better leverage Information Server capabilities in order to enhance the Group Wide Data Warehouse for Nordea. This included setting up of lineage, a test migration to 11.3 Linux (from 8.7 AIX) and performance tuning of existing DataStage and Teradata production jobs.
Contribution:
Applied Technologies & Methodologies:
3 days DataStage Essentials training (on 11.3) and a tailored 2 days best practices training for ARZ’s DataStage team. The focus was on best practices and performance for a large DWH migration project (from zDB2 to Exasol).
Contribution:
Applied Technologies & Methodologies:
DataStage Migration from 7.1 (Windows) to 8.7 (AIX). Migration of non-GxP as well as GxP systems.
Contribution:
Applied Technologies & Methodologies:
DataStage Migration 7.5 to 8.7
Contribution:
Applied Technologies:
Setup of a new enterprise data warehouse to enable group wide financial reporting.
Contribution:
Applied Technologies:
Migration of Boston based DataStage development to Dublin and setup of DataStage 8.1 production system with active/passive high availability.
Contribution:
Applied Technologies:
The main business drivers for this customer master data project are compliance with requirements of German Capital Gains Tax, implementation of a company-wide view on customer data and the replacement of legacy customer data systems. The client has a number of systems to manage customer data, but none of the systems itself is capable to provide a complete picture of a customer with all relevant information and especially in regards to calculating the capital gain tax the customer has to pay. The systems are grown over years and suffer severe design fatigue leading to high maintenance costs and rendering it almost impossible to adjust these systems to new regulatory requirements in a timely manner. With the advent of the Capital Gains Tax the customer decided to consolidate all customer information into a new system built on SOA and IBM MDM Server. The implementation of the new system follows a phased approach incrementally extending the functionality with every phase until the legacy systems are fully replaced by the new system. Hence a requirement in this project is not only to load the customer data once to the new system, but to continuously synchronize the new system with the legacy systems in near real-time. This project used to be IBM largest MDM project worldwide.
Contribution:
Applied Technologies:
Setup of DataStage to/from SAP Connectivity
Contribution:
Applied Technologies
s.Oliver, Würzburg, Rottendorf
6/2007 - 10/2007
Build the ETL processes for the analytical data marts for the franchise and wholesales Point-of-Sale planning
Scoped the project. Created the statement of work, the solution architecture, work break-down structure, the project and engagement plan Managed the solution delivery, the development team and the hand-over to the customer.
HypoVereinsbank (Unicredit), Munich
07/2006 - 10/2007
The client was taken over by a large bank recently. In consequence most of the client's applications are migrated to the corporate core banking system. For the data migration IBM´s Information Server Suite with its data profiling and transformation capabilities has been established as the primary tool together with IBM´s standard practices. A client team of data integration specialists has been formed and trained to support the ongoing migration projects with IBM Information Server.
Supported the customer's IT team to position IBM Information Server as the enterprise data integration platform. Outlined and implemented different migration scenarios and prototypes Evaluated with the client different architectural options and computing platforms (Unix, zSeries USS) in respect to performance, flexibility and business needs. Developed customized standard practices for the client to support and accelerate their adoption of IBM Information Server.
HUK Coburg, Coburg, DataStage Server to Parallel Migration (DWH)
05/2006 - 06/2006
The customer had an ETL solution based on DataStage Server Edition in place for their Data
Warehouse. Because of growing data volumes the customer decided to migrate the existing
ETL solution based on DataStage Server to DataStage Enterprise Edition (DS EE) leveraging
the parallel processing framework.
Reviewed the overall architecture and the development process Trained the customer's development team how to migrate DataStage Server Jobs to Parallel Jobs Conducted daily workshops and reviewed with the customer the progress of the migration Ensured scalability of the new solution Helped in optimizing migrated parallel jobs.
SAP, Walldorf (Germany)
10/2005 - 05/2006
This project is all about customer data and enables the client to create an analytical capability that delivers actionable insights, fact-based decisioning and accelerating the client's ability to optimize marketing and sales activities. The foundation for this capability is a consolidation of all relevant information for each business partner into a single record. The primary goal of the project, started by the client's global marketing team, was to unify, match and link business partner information with marketing campaigns and related transactional data (activities, leads, opportunities) distributed over different national and international lead management and customer management systems, and to make this
information available for analytical reporting in SAP BW and MS Analysis Server.
Analyzed the business requirements and scoped the project. Defined the solution architecture based on DB2, DataStage and QualityStage and SAP BW and helped defining the multidimensional data model for SAP BW Implemented the ETL and data quality processes. Managed IBMs onsite development team Handed the solution over to the customer.
SAP, Walldorf (Germany), Atlanta (USA)
06/2005 - 10/2005
To speed up and improve the current representation of the regional target market within the Americas, the client's US Sales and Marketing Operations started the Market Landscape project. Market information is crucial for the client's sales planning process as well as other processes in sales and marketing. The primary goals of the Market Landscape project are to improve the data quality in the client's SAP CRM system, to improve the creation process of the planning data for the business planning process and to apply data quality standards and procedures on business critical processes and to move business critical planning data to the corporate systems.
Defined the solution architecture with business analysts, CRM and BW specialists. Implemented the data management processes and the interfaces to SAP CRM Contributed to the design of the core data model. Managed the development team for the ETL part of the solution Managed the system integration test and supported the user acceptance test. Supported the deployment to production.
IZB, Munich (DWH/Basel2)
11/2004 - 1/2005
Design and implementation of a data warehouse for Basel-2 and MaK regulations.
Designed and implemented the ETL job control framework for auditing, error logging and monitoring with job sequences and Unix shell scripts. Managed the deployment to the QA and to the production environment. Supported integration tests Trained the customer staff and supported them during the initial load.
Programmierung und Grundlagen
Datenbanksysteme
Nebenfach Kommunikationswissenschaften
2005
Dipl. Inf. (MSc in Computer Science), Ludwig-Maximilians-Universität, Munich, Germany
1996
Allgemeine Hochschulreife (high school diploma), Siebold-Gymnasium, Würzburg, Germany
Certifications
Banking
Insurance
Telco
Retail
Official Beta Test partner of IBM for IIS vNext, in particular the web-based DataStage Data Flow designer. Helping IBM to reshape DataStage.
DataStage migration from 8.1 Linux Grid to 11.5 Linux Grid. The migration is currently performed by 1 DataStage developer from our team and 1 PM from the customer. I am acting as advisor and helped out with setting up the new platform, especially the Protegrity ? Datastage implementation.
Contribution:
Applied Technologies & Methodologies:
Common Data Warehouse migration project from DB2 SQW to DataStage in order to establish a more robust ETL and to add full end to end data lineage based on Information Server Governance Catalogue. This project is fully delivered by my company with 4 developers and 1 PM. After the initial 20 days POC in 2016 the customer was convinced and contracted us for the full project. The project consists of 400 SQW control flows containing over 2600 SQL scripts and over 400 Unix shell scripts.
Contribution:
Applied Technologies & Methodologies:
Stabilization of critical SLAs from the common data warehouse platform to Group Treasury. SLAs were missed by many hours every day and data was found inconsistent.
Performance Optimization in Teradata, DataStage and TWS. DataStage Migration from 8.7 (AIX) to 11.3 (Linux)
Contribution:
Applied Technologies & Methodologies:
Enterprise data warehouse program to enable consistent corporate financial reporting and to establish a group-wide data warehouse governance.
Contribution:
Applied Technologies:
The engagement consisted of two parts:
Applied Technologies & Methodologies:
4 days tailored DataStage Update Training 8.1 to 9.x and 11.x for Unicredit’s near shore team with emphasis on XML processing.
Contribution:
Applied Technologies & Methodologies:
Teradata DWH project review. BMW asked for an independent review of their DWH solution as provided by Teradata before they are signing it off. The review revealed major architectural as well as implementation issues which are being fixed currently by Teradata.
Contribution:
Applied Technologies & Methodologies:
DWH Timeline improvements & Optimization. This project was all about to better leverage Information Server capabilities in order to enhance the Group Wide Data Warehouse for Nordea. This included setting up of lineage, a test migration to 11.3 Linux (from 8.7 AIX) and performance tuning of existing DataStage and Teradata production jobs.
Contribution:
Applied Technologies & Methodologies:
3 days DataStage Essentials training (on 11.3) and a tailored 2 days best practices training for ARZ’s DataStage team. The focus was on best practices and performance for a large DWH migration project (from zDB2 to Exasol).
Contribution:
Applied Technologies & Methodologies:
DataStage Migration from 7.1 (Windows) to 8.7 (AIX). Migration of non-GxP as well as GxP systems.
Contribution:
Applied Technologies & Methodologies:
DataStage Migration 7.5 to 8.7
Contribution:
Applied Technologies:
Setup of a new enterprise data warehouse to enable group wide financial reporting.
Contribution:
Applied Technologies:
Migration of Boston based DataStage development to Dublin and setup of DataStage 8.1 production system with active/passive high availability.
Contribution:
Applied Technologies:
The main business drivers for this customer master data project are compliance with requirements of German Capital Gains Tax, implementation of a company-wide view on customer data and the replacement of legacy customer data systems. The client has a number of systems to manage customer data, but none of the systems itself is capable to provide a complete picture of a customer with all relevant information and especially in regards to calculating the capital gain tax the customer has to pay. The systems are grown over years and suffer severe design fatigue leading to high maintenance costs and rendering it almost impossible to adjust these systems to new regulatory requirements in a timely manner. With the advent of the Capital Gains Tax the customer decided to consolidate all customer information into a new system built on SOA and IBM MDM Server. The implementation of the new system follows a phased approach incrementally extending the functionality with every phase until the legacy systems are fully replaced by the new system. Hence a requirement in this project is not only to load the customer data once to the new system, but to continuously synchronize the new system with the legacy systems in near real-time. This project used to be IBM largest MDM project worldwide.
Contribution:
Applied Technologies:
Setup of DataStage to/from SAP Connectivity
Contribution:
Applied Technologies
s.Oliver, Würzburg, Rottendorf
6/2007 - 10/2007
Build the ETL processes for the analytical data marts for the franchise and wholesales Point-of-Sale planning
Scoped the project. Created the statement of work, the solution architecture, work break-down structure, the project and engagement plan Managed the solution delivery, the development team and the hand-over to the customer.
HypoVereinsbank (Unicredit), Munich
07/2006 - 10/2007
The client was taken over by a large bank recently. In consequence most of the client's applications are migrated to the corporate core banking system. For the data migration IBM´s Information Server Suite with its data profiling and transformation capabilities has been established as the primary tool together with IBM´s standard practices. A client team of data integration specialists has been formed and trained to support the ongoing migration projects with IBM Information Server.
Supported the customer's IT team to position IBM Information Server as the enterprise data integration platform. Outlined and implemented different migration scenarios and prototypes Evaluated with the client different architectural options and computing platforms (Unix, zSeries USS) in respect to performance, flexibility and business needs. Developed customized standard practices for the client to support and accelerate their adoption of IBM Information Server.
HUK Coburg, Coburg, DataStage Server to Parallel Migration (DWH)
05/2006 - 06/2006
The customer had an ETL solution based on DataStage Server Edition in place for their Data
Warehouse. Because of growing data volumes the customer decided to migrate the existing
ETL solution based on DataStage Server to DataStage Enterprise Edition (DS EE) leveraging
the parallel processing framework.
Reviewed the overall architecture and the development process Trained the customer's development team how to migrate DataStage Server Jobs to Parallel Jobs Conducted daily workshops and reviewed with the customer the progress of the migration Ensured scalability of the new solution Helped in optimizing migrated parallel jobs.
SAP, Walldorf (Germany)
10/2005 - 05/2006
This project is all about customer data and enables the client to create an analytical capability that delivers actionable insights, fact-based decisioning and accelerating the client's ability to optimize marketing and sales activities. The foundation for this capability is a consolidation of all relevant information for each business partner into a single record. The primary goal of the project, started by the client's global marketing team, was to unify, match and link business partner information with marketing campaigns and related transactional data (activities, leads, opportunities) distributed over different national and international lead management and customer management systems, and to make this
information available for analytical reporting in SAP BW and MS Analysis Server.
Analyzed the business requirements and scoped the project. Defined the solution architecture based on DB2, DataStage and QualityStage and SAP BW and helped defining the multidimensional data model for SAP BW Implemented the ETL and data quality processes. Managed IBMs onsite development team Handed the solution over to the customer.
SAP, Walldorf (Germany), Atlanta (USA)
06/2005 - 10/2005
To speed up and improve the current representation of the regional target market within the Americas, the client's US Sales and Marketing Operations started the Market Landscape project. Market information is crucial for the client's sales planning process as well as other processes in sales and marketing. The primary goals of the Market Landscape project are to improve the data quality in the client's SAP CRM system, to improve the creation process of the planning data for the business planning process and to apply data quality standards and procedures on business critical processes and to move business critical planning data to the corporate systems.
Defined the solution architecture with business analysts, CRM and BW specialists. Implemented the data management processes and the interfaces to SAP CRM Contributed to the design of the core data model. Managed the development team for the ETL part of the solution Managed the system integration test and supported the user acceptance test. Supported the deployment to production.
IZB, Munich (DWH/Basel2)
11/2004 - 1/2005
Design and implementation of a data warehouse for Basel-2 and MaK regulations.
Designed and implemented the ETL job control framework for auditing, error logging and monitoring with job sequences and Unix shell scripts. Managed the deployment to the QA and to the production environment. Supported integration tests Trained the customer staff and supported them during the initial load.
Programmierung und Grundlagen
Datenbanksysteme
Nebenfach Kommunikationswissenschaften
2005
Dipl. Inf. (MSc in Computer Science), Ludwig-Maximilians-Universität, Munich, Germany
1996
Allgemeine Hochschulreife (high school diploma), Siebold-Gymnasium, Würzburg, Germany
Certifications
Banking
Insurance
Telco
Retail
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.