1 von 91.893 IT- und Engineering-Profilen

Fachlicher Schwerpunkt dieses Freiberuflers

Entwicklung/Architektur Data Integration mit Informatica PowerCenter, XML-Verarb./unstrukturierte Daten mit Informatica B2B DT (DataTransformation)

verfügbar ab
01.01.2019
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

Schweiz

Städte
Zürich
100 km
Kontaktwunsch

Ich möchte bevorzugt für Projekte in diesen Einsatzorten kontaktiert werden.

Position

Kommentar

Senior Consultant Informatica Specialist

Projekte

11/2014 - 02/2018

3 Jahre 4 Monate

Introducing Informatica B2B DT for complex XML processing

Rolle
B2B DT (Data Transformation) expert/developer
Kunde
UBS Card Center AG, Zürich, Switzerland
Projektinhalte

Activities:

  • Administration support
  • Developer support
  • Development to process Way4 interfaces, PinMailer, CardProduction, Letters, Statements
  • Cooperation with Credit Card manufacturer Gemalto (formerly Trüb)
  • Cooperation with SPS (Swiss Post Solutions)
Produkte

Informatica PowerCenter

Oracle

XML

Informatica B2B DT

04/2014 - 11/2014

8 Monate

Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing

Rolle
Developer
Kunde
Arvato, München
Projektinhalte

Project description:
Arvato was setting up Informatica PIM (product information management) for his customer Gerry Weber to control the Gerry Weber internet shop. Due to the acquisition of its vendor Heiler Software by Informatica, a quality tool was missing (formerly an integrated third party tool). This gap was filled by a B2B DT service providing a validation module

Activities:

  • Installation and configuration of Informatica PowerCenter and B2B DT
  • Analyse the high level requirements
  • Developing several B2B DT services
  • Instructing the developer team
Produkte

Informatica PowerCenter

Oracle

XML

02/2013 - 04/2014

1 Jahr 3 Monate

Re-design of the existing "Teflos" system to extract check-in details for complex data analysis

Rolle
Developer
Kunde
Lufthansa Revenue Services, Norderstedt
Projektinhalte

Activities:

  • Installation and configuration of Informatica B2B DT
  • Developing several B2B DT Services of mid-complexity
  • Business analysis support
  • Instructing the developer team
Produkte

Informatica PowerCenter

Oracle

XML

10/2012 - 03/2013

6 Monate

In order to send risk metrics to external provider MSCI Inc. to perform extended risk management calculations, data had to be extracted out of Oracle and to be converted into XML format according to the provider's XML structure

Rolle
architect/administrator/developer
Kunde
Dekabank, Frankfurt/Main
Projektinhalte

Activities:

  • Installation and configuration of Informatica B2B DT (PowerCenter was in place for several years9
  • Developing a complex B2B DT Service to convert risk metrics data from relational model (DB) to XML
  • Handover and instruction of the developer team
Produkte

Informatica PowerCenter

Oracle

XML

04/2012 - 09/2012

6 Monate

Complex business rules, that could not be applied to SAP system directly, had to be applied to the data by bypassing the datastream to a system of PowerCenter mappings and re-inserting them again

Rolle
developer
Kunde
DZ Bank, Frankfurt/Main
Projektinhalte

Activities:

  • Extracting data out of SAP tables, applying complex business logic, mostly to enrich and to aggregate the existing data
Produkte

Informatica PowerCenter

Oracle

10/2011 - 03/2012

6 Monate

This project was an initiative to introduce Informatica PowerCenter, B2B DT (DataTransformation) and B2B DX (DataExchange) to the global wholesale department

Rolle
Developer
Kunde
ADIDAS, Herzogenaurach
Projektinhalte

Activities:

  • Installation and configuration of the Informatica platform on 4 environments
  • Creating concepts of administration (user privileges, administration of PowerCenter objects, deployment)
  • Instructing the developer team (onsite and remote)
Produkte

Oracle

XML

Informatica PowerCenter

01/2011 - 09/2011

9 Monate

The gCRM project (global customer relationship management) is designed receive customer data from multiple online platforms (daily updates via XML) in order to find the “golden” version and to provide the clean data for customer advertising campaigns.

Rolle
architect/administrator
Kunde
Panasonic, Hamburg
Projektinhalte

Activities:

  • Creating the all-over MDM data model
  • Configuring the MDM hub server
    • Cleansing rules
    • Match rules
  • Creating the PowerCenter workflows to process XML files provided by the source systems daily
  • Creating the PowerCenter workflows to provide updates backwards to all source systems
Produkte

Oracle

XML

11/2009 - 01/2011

1 Jahr 3 Monate

The GPL (Global Payment Link) project is about receiving and sending payments, payment format conversion with Informatica B2B DT (DataTransformation)

Rolle
Developer
Kunde
Royal Bank of Scotland, London
Projektinhalte

Messages are received in the formats AIR, BACS, ISO8583, MT103, MT202, NewBankline, PACS004, PACS008 plus the relevant PAN’s (Payment Advices) and PSN’s (Payment Status Notifications) and are being processed and converted by Informatica B2B DT (Data Transformation) into the formats BAI2, MT940, MT942, NewBankline, BFF, MT198, MT900, MT910, MT198, MT298 and PACS002 transformiert.

Activities:

  • Implementing DT services according to mapping rule documents
  • Testing the services and adapting them to the specific requirements
  • Instructing analysts how to use Informatica B2B DT studio as a validation tool
  • Documentation of the developed services and test approval
Produkte

Informatica PowerCenter

B2B

XML

Oracle

04/2009 - 10/2009

7 Monate

Assisting to build a best practices package for automated deployment of PowerCenter objects.

Rolle
Developer
Kunde
PowerFramework (Deployment Framework)
Projektinhalte

Activities:

  • Support at designing and building the installer
  • Test execution
  • Documentation
  • Installation
  • Training (enablement)
Produkte

Oracle

XML

02/2009 - 03/2009

2 Monate

Statistix project was created to analyze SWIFT messages

Rolle
Developer
Kunde
Deutsche Börse AG, Frankfurt
Projektinhalte

Project description:
Statistix project was created to analyze SWIFT messages. Bond-related Clearstream messages MT564 and MT566 transmitted by Merva are transformed using Informatica B2B DT, subsequent processing using Informatica PowerCenter establishes relations between events to monitor in due time dispatch of correspondent messages.

Activities:

  • Review of requests and existing process implemantations
  • Design and implementation of subsequent aggregation levels
  • Mentoring ETL developers
  • Documentation of the entire development and test approval
Produkte

Oracle

XML

10/2008 - 12/2008

3 Monate

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Rolle
Developer
Kunde
Volkswagen AG, Wolfsburg
Projektinhalte

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Produkte

Oracle

MS SQL Server

07/2007 - 09/2008

1 Jahr 3 Monate

Consulting at implementation of Book-of-Standards compliant technology, at most points including the implementation, participation at establishing a further so called “Gravitationzentrum” (internal name for a specialized Data Warehouse), the “Sales GZ”

Rolle
Developer
Kunde
Volkswagen AG, Wolfsburg
Projektinhalte

Activities:

  • Prototype design, mostly later unmodified used for production.
  • Project KometPro (currently KKP): Mapping design following mapping requests
  • Project Berichtswesen Deutschland (reporting system for Germany): Migration of ETL processes existing in C# to Informatica PowerCenter technology and integration into SalesGZ; mapping design following pseudo SQL, partly redesigned processes
  • Projects Konzernvertriebspartnerstammdaten (KVPS, enterprise distribution partner master data) , Masterdata Management (MDM) und Work Atmosphere: Mapping design following requests
Produkte

Oracle

MS SQL Server

DB/2

04/2007 - 06/2007

3 Monate

Purchase Data Warehouse was created to collect business transactions out of STAR system (previously GAS system) to display real savings in order to calculate bonuses

Rolle
Developer
Kunde
Volkswagen AG, Wolfsburg
Projektinhalte

Activities:

  • Enhancement of existing workflows of STAR system using PowerCenter 7 (later PowerCenter 8).
  • Mapping design following mapping instructions of medium complexity.
  • Mapping design implementing functional requests by the project leader
  • Performance tuning and consolidating existing mappings
  • Quality assurance, trouble shooting, bugfixing
Produkte

Oracle

MS SQL Server

Branchen

  • Financial industry
  • Clothing industry
  • Transportation industry
  • Financial service provider
  • Sports industry
  • Entertainment technology
  • Automotive industry

Kompetenzen

Sprachkenntnisse
Deutsch
Muttersprache
Englisch
fließend

Betriebssysteme
Linux
Windows

Datenbanken
DB/2
good
MS SQL Server
good
Oracle
very good

Programmiersprachen
C/C++/C#
Java
Shell-Script
VBA
Visual Basic

Produkte / Standards / Erfahrungen
Informatica B2B DT
very good
Informatica B2B DX
basic
Informatica MDM
basic
Informatica PowerCenter
very good
XML
very good

Aufgabenbereiche
Deployment
very good
Konfigurationsmanagement
good
Konzeption: Realisierung
good
Konzeption: Techn. Architektur
good
Release-Management
good
Schulung / Coaching / Präsentation
very good
Testen, Debugging, Tuning
very good

Ausbildungshistorie

09.1987 - 01.1991: Professional education to Radio- und Fernsehtechniker (radio and television technican) at Rat und Tat GmbH (Karstadt AG) in Braunschweig

Since 2000: Seminars/training:

  • Networking
  • Programming (VB6, Java, C#, JavaScript)
  • Database administration and development (Oracle, MS SQL Server)
  • Informatica PowerCenter
  • Informatica MDM
  • Informatica B2B DT (Silver Certification)
×
×