Data Engineering, Project Management, Architecture
Aktualisiert am 13.06.2023
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 18.06.2023
Verfügbar zu: 100%
davon vor Ort: 100%
DataStage
DB2
SQL
IBM QualityStage
IBM Information Governance Catalogue
Teradata
IBM Information Server
Scripting
BigQuery
Google Apps Script
Data Engineering
German
Muttersprache
English
Verhandlungssicher
Bulgarian
Grundkenntnisse
French
Grundkenntnisse

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 5 Monate
2017-10 - heute

Official Beta Test partner

Official Beta Test partner of IBM for IIS vNext, in particular the web-based DataStage Data Flow designer. Helping IBM to reshape DataStage.

IBM, Sofia/Bulgaria, USA
7 Jahre 5 Monate
2016-10 - heute

DataStage migration from 8.1 Linux Grid to 11.5 Linux Grid

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:

  • I supported the technical setup and how to perform the migration
  • Recompiled the Protegrity DataStage integration I built earlier for Unicredit
  • Mentoring our as well as the customers team.

 

Applied Technologies & Methodologies:

  • DataStage 8.1/11.5, Teradata
  • Protegrity Application Protectors
Unicredit, Vienna, Sofia
7 Jahre 5 Monate
2016-10 - heute

Common Data Warehouse migration project

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:

  • I held the initial migration and POC workshop with the customer and IBM. Prepared DataStage demo jobs.
  • I advised our lead DataStage developer on approach
  • Setup project reporting on Google Data Studio
  • Mentoring our as well as the customers team.

 

Applied Technologies & Methodologies:

  • DB2 10.5 LUW, Information Server 11.5, RedHat Linux
  • Atlassian Jira, Google Data Studio
Wüstenrot, Salzburg, Sofia
8 Jahre
2016-03 - heute

Stabilization of critical SLAs

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:

  • I reviewed the technical setup to meet the SLAs and reworked them from scratch. I prepared a comprehensive change document and also guided the implementation of it. After the implementation the SLA was met and data was consistent. Parts of the changes related to Unix and DataStage I implemented myself.
  • I acted as lead architect for the DataStage migration and rewrote Unix shell script to overcome the differences on OS level (AIX vs Linux). I was guiding and mentoring Nordea’s onsite as well as offshore team.
  • I acted as product owner for the performance engineering team which made significant performance improvements in DataStage and Teradata. Parts of the solutions I implemented myself in Teradata and DataStage / Unix.
  • I supported the Hadoop data lake project and the integration with DataStage
  • I mentored and trained the Core banking platform migration team in Gdynia, Poland, on DAtaStage. Initially they wanted to go with Java – after the initial trainings they went with DataStage instead.
  • I advised on implementing continuous integration and DevOps methods to DataStage development. We demonstrated MettleCI (a DataStage DevOps solution based on the Atlassian tool stack from our Australian Partner DataMigrators).

 

Applied Technologies & Methodologies:

  • DataStage 8.7, DataStage 11.3, AIX, RedHat Linux, Tivoli Workload Scheduler, Teradata 15.x
  • SQL, DataStage Parallel & Server Jobs, Unix shell scripting (ksh, bash)
  • Atlassian Jira, BitBucket, Bamboo
Nordea, Stockholm, Gdynia, Sofia
15 Jahre 5 Monate
2008-10 - heute

Enterprise Data Warehouse& Asset Liability Mgmt

Enterprise data warehouse program to enable consistent corporate financial reporting and to establish a group-wide data warehouse governance.

 

Contribution:

  • Advised Unicredit in the definition of a new corporate DWH/ETL architecture for simplified ETL development, better scalability, robustness and quality
  • 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
  • Helped to customize the Teradata Financial Services Data Model (FSLDM) according to Unicredit needs
  • Helped to setup a metadata layer that supports data lineage from the source to the target systems.
  • Managed the development work stream of the German DWH site to add risk and asset liability management reporting capabilities to the DWH. We in particular added new investment banking XML real-time feeds to the EDWH leveraging Websphere MQ, DataStage and Teradata.
  • Supported the different DWH projects to setup connections to new sources. I especially trained the project staff how to read and write data to and from SAP, complex mainframe datasets or XML data efficiently with DataStage.
  • Managed a team of performance experts that improved the batch load time for the Austrian and CEE data warehouse sites from multiple days to less than 7 hours by identifying and resolving bottlenecks in Teradata as well as in the DataStage Grid. In particular we optimized the DataStage – Teradata connections to reduce wait times, TPT slot bottlenecks and global deadlock situations, we improved the Teradata Work Load Management to reduce Teradata overload situations as well as to speed up fast loads and fast export to and from Datastage. We extended the DataStage Parallel Job engine with seamless dataset compression reducing IO bottlenecks in the Datastage Grid and further reducing dataset disk space usage by up to 80%. We changed the storage and Grid configuration to leverage RAM for sort and buffer operations. We enhanced the DataStage Grid Architecture to better balance the workload across the Datastage compute nodes and towards Teradata.
  • Created the data protection architecture for the Austrian DWH site, which has strict data protection requirements. Implemented CA Access Control and Protegrity Application Protectors in Teradata and DataStage to allow data protection and encryption of sensitive fields as part of the ETL jobs and DWH tables.
  • Supported the migration of all Datastage installations 8.0/8.1FP2 towards DataStage 8.5FP2 and 9.1 and the migration of the legacy V12 Teradata Systems to V13.10.
  • Advised and reviewed the setup and configuration of Information Server 8.1, 8.5 and 9.1 including database connectivity to zDB2/LUW, Teradata V12/V13, Oracle and Websphere MQ. Added custom extension to the DataStage engine and the Grid Toolkit including seamless dataset compression, improved workload and resource management.

 

Applied Technologies:

  • IBM Information Server 8.0 (AIX), 8.1 (Redhat Grid), 8.5 (Redhat), 9.1 (Redhat), with connectivity to Teradata (Connector & Legacy Stages), Oracle (Connector & Legacy Stages), DB2 (zOS, AS400, Linux) Connector, ODBC Legacy Stage and Connector (for DB2 and SQL server connections), Websphere MQ 6/7, SAP IDOC, DataStage SAP PACK, Mainframe DataSets (V/QSAM), FTP, SFTP, Sharepoint Webservices, XML (Legacy XML Pack & New XML Stage), Parallel, Server & Sequence Jobs.
  • Teradata V12/13, TPT, BTEQ, Fastload/Fastexport, DBMON, Viewpoint
  • Oracle 11g R2
  • Redhat Enterprise 5.x/6.x, AIX 5.x, Korn/Bash Shell
  • Websphere MQ 6/7
  • Tivoli LoadLeveler
  • DataStage Grid Toolkit
  • DataStage Balanced Optimization (8.5 & 8.7)
  • Metadata Workbench for Data Lineage
  • Protegrity Enterprise Security Administrator V5.5, Teradata DataBase Application protector
  • zOS: JCL, Beta48, Tivoli / OPC
  • C++ development for custom DataStage BuildOps and Parallel Routines
  • Python development for custom deployment tool
  • SVN
  • VMWare ESX
  • Sharepoint
Unicredit, Vienna, Rome, Budapest, Sofia, Munich
3 Monate
2017-09 - 2017-11

Prototyping a DataStage

The engagement consisted of two parts:

  • Prototyping a DataStage / Oracle solution for the GDPR/ right to be forgotten regulation for ING Diba’s corporate data warehouse and
  • Recommending and advising on setting up version control and automated deployment for the DWH artefacts including DataStage

 

Applied Technologies & Methodologies:

  • IIS 11.5 (DataStage & IGC), Oracle Exadata
  • Git, Bitbucket, Bamboo, Linux shell
ING Diba, Nürnberg, Frankfurt, Sofia
1 Monat
2016-02 - 2016-02

DataStage Update Training

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:

  • I prepared the training material and exercises and conducted the hands-on training

 

Applied Technologies & Methodologies:

  • DataStage 8.1, 9.1.2, 11.5
  • XML, XSLT, XML Schema
Unicredit, Budapest
3 Monate
2015-11 - 2016-01

Teradata DWH project review

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:

  • Conducted interview and handover sessions in Munich, Germany with the client’s team.
  • Performed the architecture and documentation review personally and large parts of the code review. The remainder of the code review was performed by my team of Teradata and DWH experts in Sofia under my guidance.

 

Applied Technologies & Methodologies:

  • Teradata V15, Teradata ETL Factory
  • Perl, Unix Shell Scripting, SVN
BMW, Sofia, Munich
1 Jahr 9 Monate
2014-03 - 2015-11

DWH Timeline improvements & Optimization

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:

  • Lead Architect for the performance optimization team
  • Refined the risk assessment, project plan and infrastructure architecture
  • Setup and guided a team of DataStage and Teradata experts
  • Setup and tuning of the new 11.3 Information Server environment.
  • Reviewed and analyzed the exiting code base and designed and implemented a series of improvements leading to several hundred hours of monthly saved elapsed batch time, many terabytes of saved table space in Teradata. Increased core load throughput up to 100 times. The solution was largely simplified removing many thousands of unnecessary job invocations every night leading to 60% less resource utilization on the DataStage server.
  • Revealed and fixed many flaws in the actual implementation which was performed by CapGemini, Teradata and Accenture. As a result the number of daily job aborts was significantly reduced and the production was more stable.
  • Integration of data lineage into Information Catalogue with CompactBI’s Metadex. 

 

Applied Technologies & Methodologies:

  • Teradata 14 / 15
  • IBM Information Server 8.7, 11.3 (AIX, Linux)
  • Compact BI Metadex
  • Unix Shell scripting
  • TWS Scheduling
Nordea, Stockholm, Sofia
1 Monat
2015-08 - 2015-08

DataStage Essentials training

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:

  • I prepared the training material and exercises and conducted the hands-on training
  • Did a quick review on the installation and hinted some improvements which led to a significant reduction in CPU utilization on the DataStage server.

 

Applied Technologies & Methodologies:

  • DataStage 11.3
  • zDB2
ARZ, Innsbruck
4 Monate
2013-09 - 2013-12

DataStage Migration

DataStage Migration from 7.1 (Windows) to 8.7 (AIX). Migration of non-GxP as well as GxP systems.

 

Contribution:

  • Helped to bring back the project on track
  • Refined the risk assessment, project plan and infrastructure architecture
  • Advised on IBM software licensing, the recovery concept and the migration concept for SAP BW
  • Performed detailed technical analysis and reverse-engineered missing technical documentation
  • Supported IQ and OQ testing

 

Applied Technologies & Methodologies:

  • IBM Information Server 8.7 (AIX), DataStage 7.1 Server Edition
  • SAP BW Pack
  • GxP and NNIT QA processes
NNIT, Copenhagen, Sofia
6 Monate
2012-04 - 2012-09

DataStage Migration

DataStage Migration 7.5 to 8.7

 

Contribution:

  • Prepared and conducted an upgrade workshop to present and discuss possible upgrade scenarios
  • Advised in creating the project plan and a detailed task list
  • Advised in selecting, configuring and setup of an Information Server deployment model
  • Supported the migration of the first pilot site including setting up connectivity to source and target systems

 

Applied Technologies:

  • DataStage 7.5 and IBM Information Server 8.7 (AIX, Windows 2008 Server & Redhat Linux 5.x), Server Jobs
  • Oracle 11gR2
  • DB2 9.5/.7 UDB
  • DataStage Connector Migration Tool
Raiffeisen, Vienna
1 Jahr 1 Monat
2010-11 - 2011-11

CFO Data Warehouse

Setup of a new enterprise data warehouse to enable group wide financial reporting.

 

Contribution:

  • Supported the main contractor and partner Teradata in building a scalable and robust ETL architecture with IBM Information Server and Teradata DBMS for the Enterprise Data Warehouse
  • Reviewed the current DataStage setup and recommended and implemented improvements to the DataStage setup like sizing of LPARs, improved DataStage configuration yielding much better I/O and sort performance.
  • Reviewed the current implementation and proposed enhancements.
  • Implemented an ETL performance reporting framework

 

Applied Technologies:

  • IBM Information Server 8.1 (AIX), Parallel & Sequence Job development
  • Teradata V12/13, TPT, BTEQ, CLI
Nordea (Teradata), Stockholm
1 Monat
2008-10 - 2008-10

DataStage Project Migration

Migration of Boston based DataStage development to Dublin and setup of DataStage 8.1 production system with active/passive high availability.

 

Contribution:

  • Advised in sizing the DataStage system
  • Supported the customer’s Solaris administrators to prepare and setup a new DataStage 8.1 production instance with high-availability
  • Trained the Dublin based development team to take over ongoing development from the Boston Datastage team.

 

Applied Technologies:

  • IBM Information Server 8.1 (Solaris)
  • Oracle 10g R1
  • DataStage High-Availability Setup
  • Solaris, Solaris Cluster
HypoVereinsbank (Unicredit), Dublin, Munich
1 Jahr
2007-10 - 2008-09

Customer Master Data Management

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:

  • Setup and scoped the subproject migration dealing with the data migration to the new system, including the initial load as well as near real-time synchronization and data quality
  • Created the high-level concept
  • Created a project and resource plan.
  • Defined the SOA architectures for the migration and data quality processes and created a detailed technical specification
  • Managed the IBM DataStage & QualityStage development team consisting of 12 specialists
  • Supported the setup and advised on the configuration of Information Server, DB2, WebSphere MQ and MDM Server

 

Applied Technologies:

  • IBM Information Server 8.1 (Solaris & AIX), Server and Parallel Job Development
  • IBM MDM Server
  • Oracle 10g R1
  • Websphere MQ
  • DataStage XML Pack
  • C++ development of a custom Datastage operator for guaranteed message delivery
  • OS: Solaris & AIX
Commerzbank, Frankfurt
1 Monat
2007-08 - 2007-08

SAP Connectivity

Setup of DataStage to/from SAP Connectivity

 

Contribution:

  • Configured and tested SAP R/3, SAP BW, Openhub to/from DataStage 8.x, SAP PACK

 

Applied Technologies

  • SAP BW 3.5
  • Open Hub
  • DataStage 8.x
  • SAP PACK / RFC
  • ABAP
  • IDOC 
Fielmann, Hamburg

Aus- und Weiterbildung

Aus- und Weiterbildung

5 Jahre 9 Monate
1999-10 - 2005-06

Informatik Studium

Diplom Informatik, LMU, München
Diplom Informatik
LMU, München

Programmierung und Grundlagen

Datenbanksysteme

Nebenfach Kommunikationswissenschaften

Position

Position

  • Technical Project Manager
  • Data Engineer
  • IT Architect
  • IT and Strategy Consultant
  • IT Analyst

Kompetenzen

Kompetenzen

Top-Skills

DataStage DB2 SQL IBM QualityStage IBM Information Governance Catalogue Teradata IBM Information Server Scripting BigQuery Google Apps Script Data Engineering

Produkte / Standards / Erfahrungen / Methoden

SCRUM
Fortgeschritten
SAFE
Fortgeschritten
ITIL
Basics
PMI
Basics
Lean 6 Sigma
Basics
  • Proven leadership in managing international and geographically dispersed teams, proficient in architecture, analysis, and development, with experience in onshore and near-shore delivery models.
  • Expertise in the design and implementation of scalable data architectures, adept in supporting batch or near real-time data analysis, transformation, cleansing, enrichment, and integration of heterogeneous data sources.
  • Broad industry experience with primary focus on banking and financial services, supplemented with exposure to the telecommunications and retail sectors.
  • Solid understanding of relevant industry regulations, including data privacy (GDPR) and banking standards (Basel II - IV).

Betriebssysteme

AIX
Basics
Linux Redhat
Fortgeschritten
USS (z/OS)
Basics
Windows
Fortgeschritten

Programmiersprachen

SQL
Experte
Unix Shell
Fortgeschritten
Java
Fortgeschritten
Python
Fortgeschritten
XSLT
Basics
Powershell
Fortgeschritten
JavaScript
Fortgeschritten
PL/SQL
Fortgeschritten


Datenbanken

Teradata
Experte
DB2
Fortgeschritten
Google BigQuery
Fortgeschritten
Snowflake
Basics
MS SQL Server
Basics
ODBC
Fortgeschritten
Oracle
Fortgeschritten
Progress
Basics
Netezza
Basics
DuckDB
Basics

Branchen

Branchen

Banking

Insurance

Telco

Retail

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz
nicht möglich

Projekte

Projekte

6 Jahre 5 Monate
2017-10 - heute

Official Beta Test partner

Official Beta Test partner of IBM for IIS vNext, in particular the web-based DataStage Data Flow designer. Helping IBM to reshape DataStage.

IBM, Sofia/Bulgaria, USA
7 Jahre 5 Monate
2016-10 - heute

DataStage migration from 8.1 Linux Grid to 11.5 Linux Grid

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:

  • I supported the technical setup and how to perform the migration
  • Recompiled the Protegrity DataStage integration I built earlier for Unicredit
  • Mentoring our as well as the customers team.

 

Applied Technologies & Methodologies:

  • DataStage 8.1/11.5, Teradata
  • Protegrity Application Protectors
Unicredit, Vienna, Sofia
7 Jahre 5 Monate
2016-10 - heute

Common Data Warehouse migration project

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:

  • I held the initial migration and POC workshop with the customer and IBM. Prepared DataStage demo jobs.
  • I advised our lead DataStage developer on approach
  • Setup project reporting on Google Data Studio
  • Mentoring our as well as the customers team.

 

Applied Technologies & Methodologies:

  • DB2 10.5 LUW, Information Server 11.5, RedHat Linux
  • Atlassian Jira, Google Data Studio
Wüstenrot, Salzburg, Sofia
8 Jahre
2016-03 - heute

Stabilization of critical SLAs

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:

  • I reviewed the technical setup to meet the SLAs and reworked them from scratch. I prepared a comprehensive change document and also guided the implementation of it. After the implementation the SLA was met and data was consistent. Parts of the changes related to Unix and DataStage I implemented myself.
  • I acted as lead architect for the DataStage migration and rewrote Unix shell script to overcome the differences on OS level (AIX vs Linux). I was guiding and mentoring Nordea’s onsite as well as offshore team.
  • I acted as product owner for the performance engineering team which made significant performance improvements in DataStage and Teradata. Parts of the solutions I implemented myself in Teradata and DataStage / Unix.
  • I supported the Hadoop data lake project and the integration with DataStage
  • I mentored and trained the Core banking platform migration team in Gdynia, Poland, on DAtaStage. Initially they wanted to go with Java – after the initial trainings they went with DataStage instead.
  • I advised on implementing continuous integration and DevOps methods to DataStage development. We demonstrated MettleCI (a DataStage DevOps solution based on the Atlassian tool stack from our Australian Partner DataMigrators).

 

Applied Technologies & Methodologies:

  • DataStage 8.7, DataStage 11.3, AIX, RedHat Linux, Tivoli Workload Scheduler, Teradata 15.x
  • SQL, DataStage Parallel & Server Jobs, Unix shell scripting (ksh, bash)
  • Atlassian Jira, BitBucket, Bamboo
Nordea, Stockholm, Gdynia, Sofia
15 Jahre 5 Monate
2008-10 - heute

Enterprise Data Warehouse& Asset Liability Mgmt

Enterprise data warehouse program to enable consistent corporate financial reporting and to establish a group-wide data warehouse governance.

 

Contribution:

  • Advised Unicredit in the definition of a new corporate DWH/ETL architecture for simplified ETL development, better scalability, robustness and quality
  • 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
  • Helped to customize the Teradata Financial Services Data Model (FSLDM) according to Unicredit needs
  • Helped to setup a metadata layer that supports data lineage from the source to the target systems.
  • Managed the development work stream of the German DWH site to add risk and asset liability management reporting capabilities to the DWH. We in particular added new investment banking XML real-time feeds to the EDWH leveraging Websphere MQ, DataStage and Teradata.
  • Supported the different DWH projects to setup connections to new sources. I especially trained the project staff how to read and write data to and from SAP, complex mainframe datasets or XML data efficiently with DataStage.
  • Managed a team of performance experts that improved the batch load time for the Austrian and CEE data warehouse sites from multiple days to less than 7 hours by identifying and resolving bottlenecks in Teradata as well as in the DataStage Grid. In particular we optimized the DataStage – Teradata connections to reduce wait times, TPT slot bottlenecks and global deadlock situations, we improved the Teradata Work Load Management to reduce Teradata overload situations as well as to speed up fast loads and fast export to and from Datastage. We extended the DataStage Parallel Job engine with seamless dataset compression reducing IO bottlenecks in the Datastage Grid and further reducing dataset disk space usage by up to 80%. We changed the storage and Grid configuration to leverage RAM for sort and buffer operations. We enhanced the DataStage Grid Architecture to better balance the workload across the Datastage compute nodes and towards Teradata.
  • Created the data protection architecture for the Austrian DWH site, which has strict data protection requirements. Implemented CA Access Control and Protegrity Application Protectors in Teradata and DataStage to allow data protection and encryption of sensitive fields as part of the ETL jobs and DWH tables.
  • Supported the migration of all Datastage installations 8.0/8.1FP2 towards DataStage 8.5FP2 and 9.1 and the migration of the legacy V12 Teradata Systems to V13.10.
  • Advised and reviewed the setup and configuration of Information Server 8.1, 8.5 and 9.1 including database connectivity to zDB2/LUW, Teradata V12/V13, Oracle and Websphere MQ. Added custom extension to the DataStage engine and the Grid Toolkit including seamless dataset compression, improved workload and resource management.

 

Applied Technologies:

  • IBM Information Server 8.0 (AIX), 8.1 (Redhat Grid), 8.5 (Redhat), 9.1 (Redhat), with connectivity to Teradata (Connector & Legacy Stages), Oracle (Connector & Legacy Stages), DB2 (zOS, AS400, Linux) Connector, ODBC Legacy Stage and Connector (for DB2 and SQL server connections), Websphere MQ 6/7, SAP IDOC, DataStage SAP PACK, Mainframe DataSets (V/QSAM), FTP, SFTP, Sharepoint Webservices, XML (Legacy XML Pack & New XML Stage), Parallel, Server & Sequence Jobs.
  • Teradata V12/13, TPT, BTEQ, Fastload/Fastexport, DBMON, Viewpoint
  • Oracle 11g R2
  • Redhat Enterprise 5.x/6.x, AIX 5.x, Korn/Bash Shell
  • Websphere MQ 6/7
  • Tivoli LoadLeveler
  • DataStage Grid Toolkit
  • DataStage Balanced Optimization (8.5 & 8.7)
  • Metadata Workbench for Data Lineage
  • Protegrity Enterprise Security Administrator V5.5, Teradata DataBase Application protector
  • zOS: JCL, Beta48, Tivoli / OPC
  • C++ development for custom DataStage BuildOps and Parallel Routines
  • Python development for custom deployment tool
  • SVN
  • VMWare ESX
  • Sharepoint
Unicredit, Vienna, Rome, Budapest, Sofia, Munich
3 Monate
2017-09 - 2017-11

Prototyping a DataStage

The engagement consisted of two parts:

  • Prototyping a DataStage / Oracle solution for the GDPR/ right to be forgotten regulation for ING Diba’s corporate data warehouse and
  • Recommending and advising on setting up version control and automated deployment for the DWH artefacts including DataStage

 

Applied Technologies & Methodologies:

  • IIS 11.5 (DataStage & IGC), Oracle Exadata
  • Git, Bitbucket, Bamboo, Linux shell
ING Diba, Nürnberg, Frankfurt, Sofia
1 Monat
2016-02 - 2016-02

DataStage Update Training

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:

  • I prepared the training material and exercises and conducted the hands-on training

 

Applied Technologies & Methodologies:

  • DataStage 8.1, 9.1.2, 11.5
  • XML, XSLT, XML Schema
Unicredit, Budapest
3 Monate
2015-11 - 2016-01

Teradata DWH project review

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:

  • Conducted interview and handover sessions in Munich, Germany with the client’s team.
  • Performed the architecture and documentation review personally and large parts of the code review. The remainder of the code review was performed by my team of Teradata and DWH experts in Sofia under my guidance.

 

Applied Technologies & Methodologies:

  • Teradata V15, Teradata ETL Factory
  • Perl, Unix Shell Scripting, SVN
BMW, Sofia, Munich
1 Jahr 9 Monate
2014-03 - 2015-11

DWH Timeline improvements & Optimization

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:

  • Lead Architect for the performance optimization team
  • Refined the risk assessment, project plan and infrastructure architecture
  • Setup and guided a team of DataStage and Teradata experts
  • Setup and tuning of the new 11.3 Information Server environment.
  • Reviewed and analyzed the exiting code base and designed and implemented a series of improvements leading to several hundred hours of monthly saved elapsed batch time, many terabytes of saved table space in Teradata. Increased core load throughput up to 100 times. The solution was largely simplified removing many thousands of unnecessary job invocations every night leading to 60% less resource utilization on the DataStage server.
  • Revealed and fixed many flaws in the actual implementation which was performed by CapGemini, Teradata and Accenture. As a result the number of daily job aborts was significantly reduced and the production was more stable.
  • Integration of data lineage into Information Catalogue with CompactBI’s Metadex. 

 

Applied Technologies & Methodologies:

  • Teradata 14 / 15
  • IBM Information Server 8.7, 11.3 (AIX, Linux)
  • Compact BI Metadex
  • Unix Shell scripting
  • TWS Scheduling
Nordea, Stockholm, Sofia
1 Monat
2015-08 - 2015-08

DataStage Essentials training

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:

  • I prepared the training material and exercises and conducted the hands-on training
  • Did a quick review on the installation and hinted some improvements which led to a significant reduction in CPU utilization on the DataStage server.

 

Applied Technologies & Methodologies:

  • DataStage 11.3
  • zDB2
ARZ, Innsbruck
4 Monate
2013-09 - 2013-12

DataStage Migration

DataStage Migration from 7.1 (Windows) to 8.7 (AIX). Migration of non-GxP as well as GxP systems.

 

Contribution:

  • Helped to bring back the project on track
  • Refined the risk assessment, project plan and infrastructure architecture
  • Advised on IBM software licensing, the recovery concept and the migration concept for SAP BW
  • Performed detailed technical analysis and reverse-engineered missing technical documentation
  • Supported IQ and OQ testing

 

Applied Technologies & Methodologies:

  • IBM Information Server 8.7 (AIX), DataStage 7.1 Server Edition
  • SAP BW Pack
  • GxP and NNIT QA processes
NNIT, Copenhagen, Sofia
6 Monate
2012-04 - 2012-09

DataStage Migration

DataStage Migration 7.5 to 8.7

 

Contribution:

  • Prepared and conducted an upgrade workshop to present and discuss possible upgrade scenarios
  • Advised in creating the project plan and a detailed task list
  • Advised in selecting, configuring and setup of an Information Server deployment model
  • Supported the migration of the first pilot site including setting up connectivity to source and target systems

 

Applied Technologies:

  • DataStage 7.5 and IBM Information Server 8.7 (AIX, Windows 2008 Server & Redhat Linux 5.x), Server Jobs
  • Oracle 11gR2
  • DB2 9.5/.7 UDB
  • DataStage Connector Migration Tool
Raiffeisen, Vienna
1 Jahr 1 Monat
2010-11 - 2011-11

CFO Data Warehouse

Setup of a new enterprise data warehouse to enable group wide financial reporting.

 

Contribution:

  • Supported the main contractor and partner Teradata in building a scalable and robust ETL architecture with IBM Information Server and Teradata DBMS for the Enterprise Data Warehouse
  • Reviewed the current DataStage setup and recommended and implemented improvements to the DataStage setup like sizing of LPARs, improved DataStage configuration yielding much better I/O and sort performance.
  • Reviewed the current implementation and proposed enhancements.
  • Implemented an ETL performance reporting framework

 

Applied Technologies:

  • IBM Information Server 8.1 (AIX), Parallel & Sequence Job development
  • Teradata V12/13, TPT, BTEQ, CLI
Nordea (Teradata), Stockholm
1 Monat
2008-10 - 2008-10

DataStage Project Migration

Migration of Boston based DataStage development to Dublin and setup of DataStage 8.1 production system with active/passive high availability.

 

Contribution:

  • Advised in sizing the DataStage system
  • Supported the customer’s Solaris administrators to prepare and setup a new DataStage 8.1 production instance with high-availability
  • Trained the Dublin based development team to take over ongoing development from the Boston Datastage team.

 

Applied Technologies:

  • IBM Information Server 8.1 (Solaris)
  • Oracle 10g R1
  • DataStage High-Availability Setup
  • Solaris, Solaris Cluster
HypoVereinsbank (Unicredit), Dublin, Munich
1 Jahr
2007-10 - 2008-09

Customer Master Data Management

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:

  • Setup and scoped the subproject migration dealing with the data migration to the new system, including the initial load as well as near real-time synchronization and data quality
  • Created the high-level concept
  • Created a project and resource plan.
  • Defined the SOA architectures for the migration and data quality processes and created a detailed technical specification
  • Managed the IBM DataStage & QualityStage development team consisting of 12 specialists
  • Supported the setup and advised on the configuration of Information Server, DB2, WebSphere MQ and MDM Server

 

Applied Technologies:

  • IBM Information Server 8.1 (Solaris & AIX), Server and Parallel Job Development
  • IBM MDM Server
  • Oracle 10g R1
  • Websphere MQ
  • DataStage XML Pack
  • C++ development of a custom Datastage operator for guaranteed message delivery
  • OS: Solaris & AIX
Commerzbank, Frankfurt
1 Monat
2007-08 - 2007-08

SAP Connectivity

Setup of DataStage to/from SAP Connectivity

 

Contribution:

  • Configured and tested SAP R/3, SAP BW, Openhub to/from DataStage 8.x, SAP PACK

 

Applied Technologies

  • SAP BW 3.5
  • Open Hub
  • DataStage 8.x
  • SAP PACK / RFC
  • ABAP
  • IDOC 
Fielmann, Hamburg

Aus- und Weiterbildung

Aus- und Weiterbildung

5 Jahre 9 Monate
1999-10 - 2005-06

Informatik Studium

Diplom Informatik, LMU, München
Diplom Informatik
LMU, München

Programmierung und Grundlagen

Datenbanksysteme

Nebenfach Kommunikationswissenschaften

Position

Position

  • Technical Project Manager
  • Data Engineer
  • IT Architect
  • IT and Strategy Consultant
  • IT Analyst

Kompetenzen

Kompetenzen

Top-Skills

DataStage DB2 SQL IBM QualityStage IBM Information Governance Catalogue Teradata IBM Information Server Scripting BigQuery Google Apps Script Data Engineering

Produkte / Standards / Erfahrungen / Methoden

SCRUM
Fortgeschritten
SAFE
Fortgeschritten
ITIL
Basics
PMI
Basics
Lean 6 Sigma
Basics
  • Proven leadership in managing international and geographically dispersed teams, proficient in architecture, analysis, and development, with experience in onshore and near-shore delivery models.
  • Expertise in the design and implementation of scalable data architectures, adept in supporting batch or near real-time data analysis, transformation, cleansing, enrichment, and integration of heterogeneous data sources.
  • Broad industry experience with primary focus on banking and financial services, supplemented with exposure to the telecommunications and retail sectors.
  • Solid understanding of relevant industry regulations, including data privacy (GDPR) and banking standards (Basel II - IV).

Betriebssysteme

AIX
Basics
Linux Redhat
Fortgeschritten
USS (z/OS)
Basics
Windows
Fortgeschritten

Programmiersprachen

SQL
Experte
Unix Shell
Fortgeschritten
Java
Fortgeschritten
Python
Fortgeschritten
XSLT
Basics
Powershell
Fortgeschritten
JavaScript
Fortgeschritten
PL/SQL
Fortgeschritten


Datenbanken

Teradata
Experte
DB2
Fortgeschritten
Google BigQuery
Fortgeschritten
Snowflake
Basics
MS SQL Server
Basics
ODBC
Fortgeschritten
Oracle
Fortgeschritten
Progress
Basics
Netezza
Basics
DuckDB
Basics

Branchen

Branchen

Banking

Insurance

Telco

Retail

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.