Recommended expert

Peter Brungs

Data Warehouse Consultant (Development and Analysis)

Peter Brungs
Cologne, Germany

Experience

Jan 2025 - Dec 2025
1 year
Karlsruhe, Germany

Data Warehouse Consultant (Development and Analysis)

Atruvia AG

  • Developed and extended ETL data loading jobs using IBM DataStage and optimized SQL in an IBM DB2 environment as part of the Agree21 data migration
  • Analyzed data quality and developed testing procedures
  • Created scripts in MS PowerShell and documented Git deployment processes
  • Technologies: RedHat Linux, IBM DB2 with DB Visualizer, IBM InfoSphere DataStage 11.7, JIRA, TortoiseGIT, TortoiseSVN, PowerShell scripts
Jan 2022 - Dec 2025
4 years
Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

Mobiliar Insurance

  • Developed and data-modeled a new data warehouse core in consultation with the business department
  • Performed ad-hoc reporting and risk analysis on the data warehouse core for the business side
  • Supported the creation of a business layer based on the data warehouse core
  • Defined and reviewed data mappings
  • Developed and expanded ETL data loading jobs with IBM DataStage and PL/SQL in Oracle, IBM DB2 (with IDAA), and MS SQL environments
  • Analyzed data quality and developed testing procedures
  • Prototyped QuerySurge routines and integrated them into IBM DataStage
  • Introduced a new data compression functionality into the data warehouse
  • Integrated data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework into IBM DataStage using the Java integration stage
  • Worked on data domains: contract, partner, object, product, location, and claims
  • Updated SAP BO reports, universes, and lists of values
  • Tested and updated InfoBurst configurations
  • Reverse-engineered historical ETL processes and resolved errors
  • Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL processes
  • Technologies: RedHat Linux, MS-SQL, IBM DB2, and Oracle 19c (JSON SQL), AQT/TOAD/SQL Developer, IBM InfoSphere DataStage 11.7, IBM CDC 11.4, Kafka/Avro framework, Schema Registry, QuerySurge, Enterprise Architect, JIRA, TortoiseGIT, SAP BO, InfoBurst
Jan 2021 - Dec 2021
1 year
Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

Postfinance

  • Analyzed data quality and tested consistency
  • Created and optimized ad-hoc SQL queries for runtime and index performance
  • Prototyped partition and tablespace distribution for large tables
  • Developed ETL data loading jobs in Python (Pandas) within an IntelliJ environment
  • Optimized data query speed in Oracle DB using indexes, pragmas, and partitioning
  • Technologies: Oracle 19c, TOAD, SQL Developer, IntelliJ with Python (Pandas), JIRA, TortoiseGIT
Jan 2020 - Dec 2023
4 years
Frankfurt, Germany

Data Warehouse Consultant (Development and Analysis)

Deutsche Bundesbank

  • Modeled the core data warehouse (Data Vault 2.0) for international banking data
  • Developed ETL data loading jobs using IBM DataStage and Unix bash scripting
  • Prototyped DataStage processes with Unix control for generic ETL data loading
  • Created and loaded error log tables and views
  • Created mapping specifications
  • Created XML-SQL queries, views, and extractions
  • Analyzed data quality and tested consistency
  • Connected CRDM master data and RTGS/CLM transaction data to Target2
  • Technologies: IBM DB2, DB-Visualizer, IBM InfoSphere DataStage 11.7, SAP PowerDesigner, JIRA, TortoiseSVN
Jan 2016 - Dec 2020
5 years
Bern, Switzerland

Data Warehouse Consultant (Development and Analysis)

Mobiliar Insurance

  • Developed and data-modeled a new data warehouse core in consultation with the business department
  • Performed ad-hoc reporting and risk analysis on the data warehouse core for the business side
  • Supported the creation of a business layer based on the data warehouse core
  • Defined and reviewed data mappings
  • Developed and expanded ETL data loading jobs with IBM DataStage and PL/SQL in Oracle, IBM DB2 (with IDAA), and MS SQL environments
  • Analyzed data quality and developed testing procedures
  • Prototyped QuerySurge routines and integrated them into IBM DataStage
  • Introduced a new data compression functionality into the data warehouse
  • Integrated data from IBM CDC and the Kafka/Avro Schema Registry and Kafka Connect framework into IBM DataStage using the Java integration stage
  • Worked on data domains: contract, partner, object, product, location, and claims
  • Updated SAP BO reports, universes, and lists of values
  • Tested and updated InfoBurst configurations
  • Reverse-engineered historical ETL processes and resolved errors
  • Monitored daily data processing and resolved loading issues in PL/SQL, Unix scripts, and ETL processes
  • Technologies: RedHat Linux, MS-SQL, IBM DB2, and Oracle 19c (JSON SQL), AQT/TOAD/SQL Developer, IBM InfoSphere DataStage 11.7, IBM CDC 11.4, Kafka/Avro framework, Schema Registry, QuerySurge, Enterprise Architect, JIRA, TortoiseGIT, SAP BO, InfoBurst
Jan 2014 - Dec 2016
3 years
Auckland, New Zealand

Manager and Solutions Architect

Ernst & Young

  • Introduction of a new insurance data model based on IBM IAA (partner, policy, commission, claim, product business system) with the corresponding data warehouse architecture
  • Integration of OpenData sources using MS-SSIS ETL tool (WebServices/REST) for banks
  • Migration of MS Project data into a Tableau application
  • Creation of a whitepaper on big data architectures based on Hadoop and related distributions
  • Technologies: IBM IAA, MS-SQL Server (SSIS/SSRS), SAP PowerDesigner, Big Data (Hadoop), Tableau
Jan 2014 - Dec 2014
1 year
Wiesbaden, Germany

Team Lead and Data Migration Expert

SOKA-Bau Versorgungskasse

  • Team leadership and point of contact for resolving technical and functional issues
  • Data quality analysis of policy and collection/debt collection data in a staging DB and in the SAP GUI
  • Data migration from external source systems to a new SAP FS-CD system
  • As-is analysis, creation of data mappings, and data analysis in collaboration with the business unit
  • Technologies: IBM DB2, UNIX, SAP GUI, SQL analytic queries, and VBS scripts
Jan 2012 - Dec 2013
2 years
Heidelberg, Germany

Data Warehouse Consultant

Janitos

  • Technical lead in developing a neutral insurance data model in ETL with DataStage, populating data marts (star schema), and hub-and-spoke architecture
  • Ad-hoc queries for the management information system in PL/SQL with explain plans and parallelization
  • Design and implementation of data extractions according to business requirements for commission and claim reporting
  • Optimization of data extraction SQL for large data volumes
  • Version control with SVN
  • Technologies: Oracle 11g (PL/SQL), Oracle Data Modeler, SVN, SAP BO, DataStage 8.7, Talend
Jan 2012 - Dec 2012
1 year
Walldorf, Germany

IBM Websphere DataStage Specialist

SAP

  • Support in troubleshooting and extending ETL jobs for a CRM system
  • Functional testing of SOAP components and support for software enhancements
  • Design and implementation of ETL jobs for data extraction
  • Creation of development and test documentation for DataStage
  • Optimization of data extraction SQL for large data volumes in the CRM system
  • Integration of DataStage web services into SAP NetWeaver
  • Technologies: Windows Server 2003/2008, SAPGUI, DataStage 7.52, DB2, SoapUI, SAP NetWeaver
Jan 2008 - Dec 2012
5 years
Cologne, Germany

ETL Expert Data Integration

Talanx-HDI-Gerling Versicherung

  • Creation of technical design documents and specifications for migrating data from external sources into a decision-support database with master data management (MDM)
  • Data modeling and database design including SQL optimization and guidelines for the database administrator
  • Version control with Jenkins and an in-house tool
  • Design and implementation of SQL scripts and ETL jobs for data analysis and extraction
  • Migration of data from external systems and integration into the data model using SQL Loader scripts on UNIX
  • Extension of ETL mappings and documentation according to business requirements
  • Execution of unit tests (TAT/UAT) and test documentation
  • Design and implementation of a web-based monitoring tool for error analysis using Java (JSP) and web server integration
  • Design and extension of shell scripts (ksh) for ETL and data extraction in job scheduling
  • Maintenance and extension of a frontend tool for master data display in a web format
  • Technologies: AIX, DB2, Oracle 10, DataStage 7.52, SQL/XML, Tomcat, Java, Shell, Eclipse, Jenkins
Jan 2008 - Dec 2008
1 year
Frankfurt, Germany

Informatica ETL DWH Consultant

EuroHypo

  • Implementation, documentation and unit testing of ETL mappings
  • Configuration and execution of unit tests
  • Extension of existing ETL mappings according to business requirements
  • Impact analysis and documentation of ETL mapping extensions for SAP systems
  • Programming PL/SQL stored procedures
  • GUI programming of diagnostic tools for database interfaces using C#
  • Technologies: AIX 6.1, Oracle 10, Informatica 7.1.3, TOAD 9.5, PL/SQL, Stored Procedures
Jan 2007 - Dec 2007
1 year
Leverkusen, Germany

Review and Optimization of ETL Processes in Master Data Management

Bayer CropScience

  • Review of the data warehouse architecture and implementation of the master data project
  • Design of blueprint documentation for the master data project (SDLC planning, configuration management)
  • Analysis of the existing data model in the source system (SAP) and target system (Oracle)
  • Planning a reporting data model and mapping solutions
  • Data modeling of the master data system including data profiling and design of a new data model
  • Planning data extraction and data transfer between source and target systems
  • Translating business requirements into technical specifications for ETL
  • Technologies: IBM AIX, SAP, Oracle 10, DataStage 7.52, TOAD 9.5, PL/SQL, Stored Procedures
Jan 2007 - Dec 2007
1 year
Stockholm, Sweden

Data Warehouse Consultant, Review of ETL Processes

Nordea Bank

  • Code review of DataStage ETL implementations and PowerCenter Informatica according to business transformation rules
  • Ensuring and improving data quality by reconciling data, data structures and data model
  • Evaluating mapping rules against programmed stored procedures
  • Introducing a new documentation standard for stored procedures
  • Designing process improvements in the data warehouse and presenting them to management
  • Technologies: IBM AIX, MS SQL Server, DataStage 7.52, SQL, Stored Procedures
Jan 2006 - Dec 2006
1 year
Vienna, Austria

ETL Expert in the Basel II Implementation

Raiffeisen Zentral Bank

  • Data and relationship validation of entities and support for the business side to improve data quality
  • Creating SQL programs for data analysis on Oracle DB
  • Designing and programming ETL routines for Ascential DataStage and improving existing solutions
  • Testing and integration in the IBM AIX environment and Oracle database for the Fermat analysis tool
  • Documenting and creating ETL mappings based on business requirements
  • Controlling DataStage jobs with custom UNIX scripts
  • Technologies: IBM AIX, Oracle 10, DataStage 7.52, KSH-Scripts, SQL, Stored Procedures, SVN
Jan 2006 - Dec 2006
1 year
Munich, Germany

Data Warehouse ETL Expert

Versicherungskammer Bayern

  • Validating the data model with SQL scripts and supporting modelers on fact and dimension tables
  • Programming ETL routines with DataStage EE (parallel jobs)
  • Testing and integration in the IBM AIX environment and IBM DB2 databases with Ascential Profile Stage
  • ETL design and implementation of interfaces as part of the ETL and data warehouse project
  • Technologies: Windows, Unix, Oracle, Ascential DataStage 7.52 EE
Jan 2004 - Dec 2005
2 years
Brussels, Belgium

IS Solutions Analyst

DHL GCC Europe

  • Programming ETL routines for the Ascential DataStage Data Warehouse with performance analysis, tuning, testing, and integration in an HP Unix environment and IBM DB2 databases
  • Defining data extraction and setting data transfer standards in Unix scripts and SQL
  • Ensuring data and process quality by defining standards for Ascential DataStage implementation
  • Defining country-specific database interface standards for Oracle, IBM, and MS-SQL
  • Specifying frontend and backend standards for a web user interface to manage the version-controlled Data Warehouse process with PHP on HP Unix
  • Technologies: HP Unix, Oracle, DB2, DataStage/ProfileStage 7.5, Erwin, PHP, Unix scripts
Cologne, Germany

Consultant

  • Training in object-oriented programming technologies, database applications, and computer architectures
  • Creating dynamic spatial web applications with XML/XSLT and VRML
  • Designing dynamic web pages with JSP to display database content
  • Developing dialog-based Java applications for data capture
  • Analyzing and developing assembler modules and 3D visualization technologies
  • Developing insurance software on client-server and mainframe systems with DB2
  • Migrating IBM mainframe DB2 data to Windows and OS/2 environments
  • Quality management and testing of C/C++ software solutions for insurance data
  • Implementing faster database access solutions with SQL and C++ on DB2
  • Designing Java/JDBC and JSP web applications

Skills

  • Data Warehouse

  • Business Intelligence

  • Big Data

  • Programming

  • Industry: Insurance

  • Industry: Banking

  • Industry: Logistics

  • Industry: Chemical

  • Industry: Government

  • Industry: Software Vendor

  • It: Data Warehouse Design And Architecture

  • It: Data Migration And Data Integration

  • It: Big Data Applications

  • It: Metadata Management

  • It: Programming

  • It: Data And Process Quality Assurance

  • Domain: Health / Life / Auto / Property Insurance

  • Domain: Master Data And Crm

  • Domain: Basel Ii / Target 2

  • Methods: Project Management

  • Methods: Requirements Management

  • Methods: Data Modeling

  • Methods: Software Engineering And Sdlc

  • Methods: System Analysis And System Integration

  • Methods: Quality Management

  • Methods: Release And Change Management

  • Methods: Training And User Coaching

  • Etl Tools: Ibm Datastage

  • Etl Tools: Informatica Powercenter

  • Etl Tools: Pentaho / Talend Data Integration

  • Etl Tools: Microsoft Ssis

  • Big Data: Kafka Framework With Connect, Avro Serialization, Schema Registry (Json)

  • Reporting Tools: Tableau

  • Reporting Tools: Sap Business Objects (+Ds)

  • Reporting Tools: Cognos

  • Data Modeling: Oracle Sql Developer Data Modeler

  • Data Modeling: Sap / Sybase Powerdesigner

  • Data Modeling: Ca Erwin Data Modeler

  • Programming Languages: C/c++/c# (Stl, Mfc, Generic Programming/templates)

  • Programming Languages: Java (Jsp, Servlets, Applets, J2ee (Struts/hibernate), Swing/awt)

  • Programming Languages: Python

  • Programming Languages: Php

  • Programming Tools: Eclipse Environment With Relevant Plug-ins

  • Programming Tools: Ms Visual Studio

  • Programming Tools: Make / Ant / Maven

  • Scripting Languages: Javascript / Vbscript

  • Scripting Languages: Shell (Ksh, Bash, Csh, Powershell)

  • Markup Languages: Xml/xslt

  • Markup Languages: Html

  • Markup Languages: Vrml

  • Virtualization: Vmware

  • Virtualization: Virtualpc

  • Operating Systems: Windows

  • Operating Systems: Linux/unix

  • Operating Systems: Os/2

  • Operating Systems: Mvs/os390

  • Databases: Ibm Db2 (Sql/xml+xpath/xquery), Ibm Cdc 11.4

  • Databases: Oracle (Sql, Pl/sql)

  • Databases: Mysql

  • Databases: Sybase

  • Databases: Ms Sql Server

  • Databases: Teradata

  • Databases: Firebird

  • Database Tools: Aqt

  • Database Tools: Toad 9.5

  • Database Tools: Dbvisualizer

  • Database Tools: Squirrel

  • Database Tools: Sql Developer

  • Database Tools: Sql Scripts

  • Database Tools: Rapidsql

  • Database Tools: Phpmyadmin

  • Database Tools: Oop With Embedded Sql User Defined Functions / Stored Procedures (Pl/sql, Transact Sql)

  • Database Tools: Querysurge

  • Software: Samba

  • Software: Version Control (Subversion / Cvs / Pvcs / Git), Tortoise

  • Software: Apache/tomcat Web Server

  • Software: Gnu Toolchain

  • Software: Directory Server (Ldap)

  • Office Applications: Ms Word

  • Office Applications: Ms Excel

  • Office Applications: Ms Access

  • Office Applications: Ms Powerpoint

  • Office Applications: Ms Visio

  • Office Applications: Ms Project

  • Protocols: Http

  • Protocols: Tcp/ip

  • Protocols: Ppp

  • Protocols: Client/server With Socket Programming

Languages

German
Native
English
Advanced
French
Elementary

Education

Lorem ipsum dolor sit amet

State-certified Technical Assistant in Electrical Engineering · Electrical Engineering

University of Bonn

Diploma in Computer Science · Computer Science · Bonn, Germany

Lorem ipsum dolor sit amet

General University Entrance Qualification (Abitur)

Certifications & licenses

PRINCE2 Project Management

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Gerald Gastgeb
Gerald Gastgeb

Data Warehouse Architect and Lead Data Modeler

View Profile
Eric Bouendeu
Eric Bouendeu

Quality Assurance Manager (QSV)

View Profile
Marc Matt
Marc Matt

Freelance Data Specialist

View Profile
Henok Abraham
Henok Abraham

Founder and Managing Director

View Profile
German Popken
German Popken

Microsoft BI Specialist

View Profile
Serge Kalinin
Serge Kalinin

MLOps (machine learning operations)

View Profile
Tim Safarowsky
Tim Safarowsky

Freelance Business Intelligence Consultant

View Profile
Jonathan Staude
Jonathan Staude

AI Consultant

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Ronny Herold
Ronny Herold

Senior Business, IT and Data Analyst, Portfolio Analyst

View Profile
Benjamin Tsapfack
Benjamin Tsapfack

Test Manager and Software and Hardware Tester

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Guido Klein
Guido Klein

Power BI Report Developer

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Guino Ndjenndja
Guino Ndjenndja

Senior Data Engineer

View Profile
Stephan Martin
Stephan Martin

Sabbatical, professional development

View Profile
Simon Stegelmeier
Simon Stegelmeier

Cloud Data Platform Product Owner & Project Manager

View Profile
Rodrigo Herrán
Rodrigo Herrán

Data Engineer

View Profile
Evrim İlden
Evrim İlden

T-SQL Database Expert

View Profile
Ashkan Zadeh
Ashkan Zadeh

Microsoft Azure Senior Data Engineer / Senior Data Scientist

View Profile
Christian Schulz
Christian Schulz

Data-Scientist/AI Engineer

View Profile
Robert Wieland
Robert Wieland

Data Architecture Manager

View Profile
Ammad Tarar
Ammad Tarar

Senior Data Architect

View Profile
Michael Gonschor
Michael Gonschor

Scrummaster

View Profile
Dalia Cananau
Dalia Cananau

Oracle Developer

View Profile
Vitali Haberkorn
Vitali Haberkorn

Power BI Expert

View Profile
Joachim Bleichert
Joachim Bleichert

Oracle consulting and development

View Profile