Peter Brungs
Data Warehouse Consultant (Development and Analysis)
Experience
Jan 2022 - Present
3 years 7 monthsBern, Switzerland
Data Warehouse Consultant (Development and Analysis)
Mobiliar Versicherung
- Developed and modeled a new Data Warehouse core in coordination with business units
- Performed ad-hoc reports and risk analysis based on the DWH core for business teams
- Assisted in building a business layer based on the DWH core
- Defined and reviewed data mappings
- Developed and enhanced ETL data load jobs using IBM DataStage and PL/SQL in an Oracle, IBM DB2 (with IDAA), and MS SQL environment
- Analyzed data quality and created test procedures
- Prototyped QuerySurge routines and integrated them into IBM DataStage
- Introduced a new data compression feature into the Data Warehouse
- Connected data from IBM CDC, Kafka/Avro, Schema Registry, and Kafka Connect Framework using IBM DataStage and Java Integration Stage
- Worked on domains: contract, partner, asset, product, location, claim
- Updated SAP BO reports, universes, and lists-of-values
- Tested and updated InfoBurst configurations
- Reverse engineered historical ETL pipelines and resolved errors
- Monitored daily data processing and resolved loading issues
Jan 2021 - Dec 2021
1 yearBern, Switzerland
Data Warehouse Consultant (Development and Analysis)
Postfinance
- Analyzed data quality and performed consistency tests
- Created and optimized ad-hoc SQL queries with index tuning
- Prototyped partition and tablespace distribution for large tables
- Developed ETL data load jobs in Python within an IntelliJ environment
- Improved query performance in Oracle DB using indexes, pragmas, and partitioning
Jan 2020 - Dec 2023
4 yearsFrankfurt am Main, 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 load jobs with IBM DataStage and Unix Bash scripting
- Prototyped DataStage control via Unix and generic ETL data loads
- Created and loaded error log tables and views
- Wrote mapping specifications
- Built XML-SQL queries, views, and extractions
- Analyzed data quality and ran consistency tests
- Integrated Target2 master data (CRDM) and transaction data (RTGS/CLM)
Jan 2016 - Dec 2020
5 yearsBern, Switzerland
Data Warehouse Consultant (Development and Analysis)
Mobiliar Versicherung
- Developed and modeled a new Data Warehouse core in coordination with business units
- Performed ad-hoc reports and risk analysis based on the DWH core for business teams
- Assisted in building a business layer based on the DWH core
- Defined and reviewed data mappings
- Developed and enhanced ETL data load jobs using IBM DataStage and PL/SQL in an Oracle, IBM DB2 (with IDAA), and MS SQL environment
- Analyzed data quality and created test procedures
- Prototyped QuerySurge routines and integrated them into IBM DataStage
- Introduced a new data compression feature into the Data Warehouse
- Connected data from IBM CDC, Kafka/Avro, Schema Registry, and Kafka Connect Framework using IBM DataStage and Java Integration Stage
- Worked on domains: contract, partner, asset, product, location, claim
- Updated SAP BO reports, universes, and lists-of-values
- Tested and updated InfoBurst configurations
- Reverse engineered historical ETL pipelines and resolved errors
- Monitored daily data processing and resolved loading issues
Jan 2014 - Dec 2016
3 yearsAuckland, New Zealand
Manager and Solutions Architect
Ernst & Young
- Introduced a new insurance data model based on IBM IAA (partner, contract, commission, claim, product system) with corresponding Data Warehouse architecture
- Connected open data sources using MS-SSIS ETL tools (WebServices/REST) for banks
- Migrated MS Project data into a Tableau application
- Authored a whitepaper on Big Data architectures based on Hadoop and related distributions
Jan 2014 - Dec 2014
1 yearWiesbaden, Germany
Team Lead and Data Migration Expert
SOKA-Bau Versorgungskasse
- Led the team and served as contact for technical and business issues
- Analyzed data quality of contract and collection data in a staging DB and SAP GUI
- Migrated data from external source systems into a new SAP FS-CD system
- Conducted as-is analysis, created data mappings, and analyzed data with business unit
Jan 2012 - Dec 2013
2 yearsHeidelberg, Germany
Data Warehouse Consultant
Janitos
- Technical lead in developing a neutral insurance data model in ETL with DataStage
- Populated data marts (star schema) and hub-spoke architecture
- Created ad-hoc queries for management information system in PL/SQL and optimized them
- Designed and implemented data extractions per business requirements for commission and claim reporting
- Optimized SQL for large data extractions in structure and runtime
- Used SVN for version control
Jan 2012 - Dec 2012
1 yearWalldorf, Germany
IBM WebSphere DataStage Specialist
SAP
- Supported troubleshooting and feature enhancements of ETL jobs for a CRM system
- Performed functional testing of SOAP components and assisted with software extensions
- Designed and implemented ETL jobs for data extraction
- Created development and test documentation for DataStage
- Optimized SQL for large data extractions in CRM system
- Integrated DataStage web services into SAP NetWeaver
Jan 2008 - Dec 2012
5 yearsCologne, Germany
ETL Expert Data Integration
Talanx-HDI-Gerling Versicherung
- Created design documents and specifications for migrating data from external sources into a transactional database system with master data (MDM)
- Modeled data and designed database including SQL optimization and guidelines for DBA
- Managed versioning with Jenkins and in-house tools
- Designed and implemented SQL scripts and ETL jobs for data analysis and extraction
- Migrated data from external systems and integrated into data model via UNIX SQL-Loader scripts
- Extended ETL mappings and documented and implemented business requirements
- Conducted unit tests (TAT/UAT) and test documentation
- Designed and built a web-based monitoring tool for daily data processing error analysis
- Wrote control scripts (ksh) for ETL and data extraction and integrated into job scheduling
- Maintained and enhanced a web-based master data frontend tool
Jan 2008 - Dec 2008
1 yearFrankfurt am Main, Germany
Informatica ETL DWH Consultant
EuroHypo
- Implemented, documented, and unit tested ETL mappings
- Configured and performed unit tests
- Extended existing ETL mappings per business requirements
- Conducted impact analysis and documented ETL mapping changes for SAP systems
- Developed PL/SQL stored procedures
- Built GUI diagnostic tools for DB interfaces using C#
Jan 2007 - Dec 2007
1 yearLeverkusen, Germany
ETL Process Review and Optimization in Master Data Management
Bayer CropScience
- Reviewed Data Warehouse architecture and implemented master data project
- Designed blueprint documentation for master data project
- Planned data extraction and transfer between source and target systems
- Translated business requirements into technical ETL specifications
- Modeled the master data system (MDM)
- Analyzed existing data structures, profiled data content, and designed new data model
Jan 2007 - Dec 2007
1 yearGermany
ETL Internet Consultant Informatica and DataStage
Daimler
- Created workshop presentation and project plan for Daimler Data Warehouse
- Implemented ETL mappings with Informatica PowerCenter and populated a DB2 data model
- Developed and documented a multithreading Linux application (C++ and GTK)
- Extended the app to generate 3D Mandelbrot sets viewable via VRML plug-ins in browsers
Jan 2007 - Dec 2007
1 yearStockholm, Sweden
Data Warehouse Consultant ETL Process Review
Nordea Bank
- Code reviews of DataStage ETL implementations and PowerCenter Informatica per business transformation rules
- Ensured and improved data quality by reviewing structures and models
- Evaluated mapping rules against stored procedures
- Introduced new documentation standards for stored procedures
- Designed process improvements and presented to management
Jan 2006 - Dec 2006
1 yearVienna, Austria
ETL Expert in Basel II Implementation
Raiffeisen Zentral Bank
- Validated data and entity relationships and supported business side in improving source data quality
- Developed SQL programs for data analysis in Oracle DB
- Designed and coded ETL routines for Ascential DataStage
- Integrated and tested in IBM AIX environment
- Documented and created ETL mappings based on business requirements
- Developed control mechanisms for DataStage jobs via custom UNIX scripts
Jan 2006 - Dec 2006
1 yearMunich, Germany
Data Warehouse ETL Expert
Versicherungskammer Bayern
- Validated data model using custom SQL scripts
- Developed ETL routines with DataStage EE (parallel jobs)
- Tested and integrated on IBM AIX and IBM DB2 databases
- Designed and implemented ETL interfaces for Data Warehouse projects
Jan 2004 - Dec 2005
2 yearsBrussels, Belgium
IS Solutions Analyst
DHL GCC Europe
- Developed ETL routines for Ascential DataStage Data Warehouse
- Conducted performance analysis and tuning, test and integration in HP Unix environment
- Created stored procedures for data validation
- Defined standards for data extraction and transfer in UNIX scripts and SQL
- Built a PHP web interface for managing the entire Data Warehouse process on HP Unix with Oracle DB
Jan 1900 - Dec 2003
104 yearsMunich, Germany
Lorem ipsum dolor sit amet
Versicherung, Bildungseinrichtung, Softwarehersteller
- Trained on object-oriented programming, database applications, and current computer architectures
- Developed dynamic spatial web applications with XML/XSLT and VRML
- Designed and built dynamic JSP web pages to display database content
- Created dialog-based data entry software in Java
- Analyzed and developed assembler modules and 3D visualization tech
- Built insurance software on client-server and mainframe with DB access (IBM DB2 and OS/2+OS/390)
- Migrated IBM mainframe DB2 data to client-server environments
- Managed quality of existing health insurance systems
- Tested and optimized C/C++ solutions for health and life insurance data mappings
- Implemented faster database access solutions with SQL and C/C++
- Designed Java/JDBC and JSP internet applications (POS frontend/backend)
Languages
German
NativeEnglish
AdvancedFrench
Elementary Education
University of Bonn
Diplom in Computer Science, major in Computer Science, minor in Physics · Computer Science · Bonn, Germany
Lorem ipsum dolor sit amet
General University Entrance Qualification (Abitur) · Germany
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
