Peter Brungs
DWH Warehouse Consultant
Experience
Jul 2022 - Present
2 years 11 months Bern, Switzerland
DWH Warehouse Consultant
Mobiliar Insurance
- Development of a new data warehouse core and the corresponding data modelling
- Definition and review of data mappings
- Design of data load procedures with DataStage and PL/SQL
- Analysis of data quality and development of test procedures
- Extending SAP BO Reports
May 2021 - Jun 2023
2 years 2 months Frankfurt, Germany
DWH Warehouse Consultant
Federal Reserve Bank
- Data modelling using data vault principles
- Prepare data mapping specifications and extension of data model and database structures
- Design of data load jobs with IBM DataStage (Unix Scripts and C-Programming) and SQL Procedures
- Built new, prototyping and update DataStage sequences and jobs
Jan 2020 - Dec 2021
1 year Bern, Switzerland
DWH Warehouse Consultant
PostFinance
- Improving SQL queries
- Extending ETL procedures and improving the data load time
- Overall maintenance duty to keep the system error free running
May 2020 - Dec 2020
8 months Frankfurt, Germany
DWH Warehouse Consultant
Federal Reserve Bank
- Data modelling of landing zone for international data from cooperating banks
- Data modelling of a core data warehouse using data vault principles
- Design of data load jobs with IBM DataStage into data vault satellites
Mar 2016 - May 2020
4 years 3 months Bern, Switzerland
DWH Warehouse Consultant
Mobiliar Insurance
Development of a new data warehouse core and the corresponding data modelling
Definition and review of data mappings
Design of data load procedures with DataStage and PL/SQL
Analysis of data quality and development of test procedures
Prototyping of QuerySurge routines and integration into DataStage ETL procedures
Overall assistance in technical problems and data issues
Nov 2014 - Mar 2016
1 year 5 months Auckland, New Zealand
Manager and Business Systems Analyst
Ernst & Young
- Introduced a new insurance data model based on IBM IAA (Party, Policy, Commission, Claims and Product domains) and data warehouse architecture
- Assisting in all technical questions around ETL, database and programming (SSIS, SSRS)
- Designed new project management solution based on MS Project data in Tableau
- Designed prototypes for big data and RESTful government site access
- Setting-up virtual Hadoop cluster, MapReduce, Spark/Storm, Pig/Hive data analysis
- Prototyping with SAP DS, BO and SAP HANA for future projects
Apr 2014 - Sep 2014
6 months Wiesbaden, Germany
Team Lead and Data Migration Expert
SoKa-Bau Insurance
- Team lead and team organization with problem solving activities between departments
- Data quality analysis of contract and collection/disbursement data in a staging DB and in SAP GUI
- Data migration of several external systems into a new SAP FS-CD/PM system
Oct 2012 - Dec 2014
1 year 3 months Heidelberg, Germany
Data Warehouse Consultant and Technical Project Leader
Janitos Insurance
- Analysis, defining, designing and implementation of complex ad-hoc queries for management information system in PL/SQL
- Mapping realization with Informatica and filling data marts for SAP BO Universe (star-schema and the new data warehouse is according the hub-spoke-architecture)
- Optimizing SQL queries in execution time and structure through Oracle pragmas and analytical functions
- Designing reports in SAP BO Web Intelligence (dash boards)
- Supporting the design of a new general insurance data model and data warehouse infrastructure
Jan 2011 - Sep 2012
9 months Walldorf, Germany
IBM Websphere DataStage Expert
SAP
- Direct support for error detection and functional improvement in CRM system
- Functional testing of SOAP components and assistance in developing software solutions
- Designed special data extracting ETL jobs and SQL optimization for business need
- Prepared development and testing documentation about ETL implementations
May 2008 - Jun 2012
4 years 2 months Cologne, Germany
ETL-Expert Data Integration
Talanx-HDI-Gerling Insurance
- Served as interface between business and development defining technical specifications for migrating data from external sources (e.g. Cobol CopyBooks, Oracle databases (SQL Loader in batch))
- Design new and extended old ETL mappings according business requests
- Unit tests and documentation of realized ETL mappings
- Developed an error audit system controlling the daily data update of master data
- Designed, edited and maintained operating procedures and standards manuals
- Maintained current knowledge of new hardware and software and recommends upgrading to maintain efficient operation
- Designed, extended and generated front end representation of master data content
- Improved the data warehouse system to a strategic and central source for company wide customer and insurance related data
Apr 2008 - May 2008
2 months Frankfurt, Germany
Informatica-ETL Consultant
EuroHypo
- Realization, documentation and unit tests of ETL mappings
- Configuration and execution of unit test within database environment
- Extension of former ETL mappings according business requests
- Programming of PL/SQL stored procedures for data handling
- Documentation and validation of data warehouse processes, scheduling, mapping and environment
Jan 2007 - Dec 2008
1 year Leverkusen, Germany
Review and Optimization ETL Processes in Master Data Management
Bayer CropScience
- Review of master data project data warehouse architecture and implementation
- Designed a blueprint documentation for master data project (SDLC planning, configuration management, analyse of recent data models in source systems (SAP) and target systems (Oracle), design of a reporting data model, ETL mapping solutions, data validation recommendations, i.e. dynamically during the ETL process or statically through a TAT/UAT)
- Proposed solutions to improve the actual process of data extraction and transfer between source- and target systems
- Translated business requirements into functional specifications
- Data modelling within the master data system (analyse of data structures, profiling of data content and design new data models)
Apr 2006 - Dec 2006
9 months Vienna, Austria
ETL Consultant in BASELII Realization
Raiffeisen Zentral Bank
- Worked with business users to document functional requirements and criteria
- Actively participated in planning, coordination, testing, implementation and post implementation support for enhancements and maintenance upgrades
- Verification of data content and data structure quality during the realization with self developed test routines in SQL
- Data- and entity relation validation and introduction where data improvement is necessary
- Developed data extraction logic in SQL for a number of different database server software types
- Designed and managed DataStage jobs through UNIX scripts
- Evaluated and improved ETL mappings
Apr 2004 - Nov 2005
1 year 8 months Brussels, Belgium
IS Solutions Analyst
DHL GCC Europe
- Designed and extended revenue data models in Teradata database
- Conceptualized and programmed ETL applications, including performance analysis, testing and integration within HP Unix/Oracle environment and DB2 database
- Validation with self developed stored procedures and verification with Ascential ProfileStage
- Developed data extraction logic in SQL for a number of different database types
- Specified country associated standards for data transfer with Unix scripts and supervised their implementation for data load to unified DWH in Teradata DB with DataStage jobs
- Assurance of data quality in ETL process through specification of validation standards for Ascential DataStage jobs and additional checks on probes of production data for Cognos Reporting
- Developed specification of a web user interface for versioned management of the complete ETL process for business people
- Established new documentation standard for specifications and data analysis
Jan 2001 - Dec 2004
4 years Cologne, Germany
Educator in Computer Science and Electronics
Unknown
- Instructed students in object-oriented programming and relational databases
- Organized and held courses in Java, C, C++, C# and script languages
- Implemented LAMP-servers with Samba and Apache/Tomcat and coached students in building internet sites
- Advised students in problem solving and computer hardware diagnostics
- Instructed students in networks, computer hardware and electronics
Jan 2001 - Dec 2002
1 year Ismaning, Germany
C/C++ and Internet Software Developer
Dynapel and DPG
- Designed dynamic web application with XML/XSLT, VRML and databases
- Conceptualized dynamic webpages with JSP to visualize database content
- Developed C/C++ modules for video applications with AD Embedded SDK
- Designed 3D virtual world internet-presentation for DPG members
- Developed new ways to combine VRML, HTML and Java/JavaScript and Java3D application
Jan 1998 - Dec 2000
3 years Munich, Germany
Systems Analyst in Data Migration
ARAG Insurance
- Analysis, design and implementation of insurance software for client/server and mainframe systems with static and dynamic database access technique (IBM DB2 and OS/2 + OS/390)
- Data migration of IBM mainframe DB2 databases into a client/server Windows and OS/2 environment
- Quality management of existent health insurance systems
- Designed graphical user interfaces in HTML and C/C++ backend
- Improving of data processing software through new dynamic SQL and C++ database access modules and instructed colleagues in their application
- Developed C/C++ software solutions for data mappings of health and life insurance data
- Designed Java/JDBC and JSP solutions for point of sales application with Borland JBuilder (J2EE)
- Implemented distributed versions of data mapping programs for faster data processing through a database lockup mechanism
Summary
I am looking for a position to manage quality assurance, verification and validation (inspection) of complex data warehouse, database and software applications. According business requirements, I will create ETL specifications, high-level technical documents and conduct design reviews. Play an active role in planning, implementing and controlling new processes. Provide technical guidance to other software engineers. Open for new ideas and technologies and every time a huge partner in analytical challenges and drive the tactical and strategic development.
Languages
German
Native
English
Advanced
French
Elementary
Education
University of Bonn
Master Degree in Computer Science, Major: Computer Science, Minor: Physics · Computer Science · Bonn, Germany
Certifications & licenses
Electronics
Prince 2 Project Management
Similar Freelancers
Discover other experts with similar qualifications and experience