Home > Candidates > Peter Brungs
Peter Brungs

Cologne, Germany NW, Germany

Phone: xxx-xxx-xxxx

Email: xxx@xxxx.xxx



  • Looking For: Project Manager and Senior ETL Consultant, Business Intelligence Analyst

  • Occupation: IT and Math

  • Degree: Master's Degree

  • Career Level: Fully Competent

  • Languages: English, German, French

Career Information:

Sign up to view Peter Brungs's full profile.

Highlights:

Skills:Data Warehouse DataStage PX and Server Edition, ProfileStage, Erwin DataModeler, Informatica Powercenter, Cognos ReportNet, Pentaho Programming Languages C/C++/C# (STL, MFC, Generic Programming/Templates), Java (JSP, Servlets, Applets, J2EE (Struts/Hibernate), Swing/AWT), Pascal, Basic Script Languages PHP, JavaScript, REXX, VBScript, Shell (ksh, bash, csh ) Mark-up Languages XML/XSLT, HTML, VRML Assembler Languages XScale/ARM, 6502, Z80, AD/FRIO Operating Systems Windows 7/64Bit/XP/2000, Linux/Unix, OS/2, MVS/OS390, VMWare Programming Tools VisualAge / WebSphere / Eclipse, VisualC++, JBuilder, Forte for Java / NetBeans, Macromedia Dreamweaver, Visual Studio, Rational Rose/Together (UML 2.0), Make / ANT Databases and Tools IBM/DB2 9.5 (SQL/XML/Compression), Oracle, MySQL, Sybase/MS SQL Server, SQL, Transact SQL, AQT, RapidSQL, phpMyAdmin, object oriented programming with embedded SQL (Java/C++), User Defined Functions / Stored Procedures, TOAD 9.5, DB Visualizer 6.02 Software Samba, Version Control (SVN / CVS), Apache/Tomcat Webserver, GNU Toolchain, Directory Server (LDAP), MS SharePoint Knowledge of actual computer hardware and network technologies Languages German: native, English: fluent, French: basic, Project Lead, Business Analysis, Data Modelling, ETL

Goal: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.

Certification:Certification in Prince 2 Project Management Certification in Electronics


Experiences:

Data Warehouse Consultant and Technical Project Leader 10/2012 - 12/2013
Janitos, Heidelberg, BW Germany
Industry: Insurance
Environment: Windows Server 2008, Oracle 11G (PL/SQL), SQL Developer Data Modeler, Tortoise SVN, SAP BO Web Intelligence
• Analysis, defining, designing and implementation of AD-Hoc queries for Management Information System in PL/SQL • Designing Reporting's in SAP BO Web Intelligence • Development of a new insurance data model and data warehouse according customer requirements • Coordinating external development resources in Bratislava, Slovakia--
IBM Websphere DataStage Specialist 01/2012 - 09/2012
SAP, Walldorf, BW Germany
Industry: Software
Environment: Windows Server 2003/2008, SAPGUI, DataStage 7.52, DB2, SoapUI
• 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--
ETL-Expert Data Integration 04/2008 - 06/2012
Talanx-HDI-Gerling, Cologne, NRW Germany
Industry: Insurance
Environment: IBM AIX 6.1, DB2 9.7, Oracle 10, DataStage 7.52, SQL/XML, Tomcat, JAVA, Shell
• Served as interface between business and development defining technical specifications for migrating data from external sources • Developed and executed SQL statements and ETL Jobs for data analysis and research • Extension of existent ETL Mappings according business requests • Unit Tests and documentation of realized ETL Mappings • Communicating the data model extension and technical needs to the database and scheduling team • 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 • Could improve the data warehouse system to a strategic and central source for company wide customer and insurance related data • Data mining lectures about data integration with DataStage, Informatica and Pentaho in international insurance and finance environments--
Informatica-ETL Consultant 01/2008 - 03/2008
Eurohypo, Frankfurt, Hessen Germany
Industry: Finance
Environment: IBM AIX 6.1, Oracle 10, Informatica 7.1.3, TOAD 9.5, PL/SQL, Stored Procedures
• 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--
Review and Optimization ETL-Processes in Master Data Management 07/2007 - 12/2007
Bayer CropScience, Monheim, NRW Germany
Industry: Chemical
IBM AIX, SAP, Oracle 10, DataStage 7.52, TOAD 9.5, PL/SQL, Stored Procedures
• 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 the actual structure, profiling of the actual data content and design new data models )--
Data Warehouse Consultant for ETL-process review 01/2007 - 06/2007
Nordea, Stockholm, Sweden
Industry: Finance
IBM AIX, MS SQL Server, DataStage 7.52, SQL and Stored Procedures
• Analyzed current and target system functional requirements; identified and resolved gaps and proposed solutions to address issues. • Code review and evaluation of DataStage ETL mapping implementations, realized Stored Procedures and the according business transformation rules. • Reported status and issues to the Technical Product Manager • Assurance and improvement of data quality in the data warehouse environment • Suggested Data Warehouse process improvements--
ETL Consultant in BASELII Realization 07/2006 - 12/2006
Raiffeisen Zentral Bank, Vienna, Austria
Industry: Finance
Environment: IBM AIX, Oracle 10, DataStage 7.52, KSH-Scripts, SQL and Stored Procedures
• 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--
IS Solutions Analyst 04/2004 - 12/2005
DHL GCC Europe, Brussels, Belgium
Industry: Logistics
Environment: HP Unix, Oracle and DB2, DataStage/ProfileStage 7.5, Erwin, PHP, Unix Scripts
• Designed and extended revenue data models • 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 and application • 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 WebUser Interface (Frontend, Backend), which is used for a versioned management of the complete ETL Process for business people. • Established new documentation standard for specifications and data analysis--

Education:

Kollegschule 07/1985 - 07/1988
Kerpen, NW, Germany
Degree: Professional Degree
Major:Digital Electronics
Vocational Education in Electronics


University of Bonn 10/1990 - 06/1997
Bonn, NW, Germany
Degree: Master's Degree
Major:Computer Science
Minor:Physics
Distributed Systems Technical Computer Science Petri Nets Nuclear Physics

Download Resume(Available to Employers Only):

ETL Business Analyst Project Lead ETL Business Systems Analyst



More About Peter Brungs
Please sign in or sign up an employer to view Peter Brungs's personal information.

  • Phone: xxx-xxx-xxxx
  • Email:xxx@xxxx.xxx
  • Visa: -
  • Work Authorization: -
  • Expected Salary: -
  • Intests & Hobbies: -