- Analyse, Vorbereitung, Dokumentation und Durchführung einer Informatica Migration von Version 9.6.1 auf Version 10.2 HF1.
- Analyse, Vorbereitung, Dokumentation und Durchführung einer Migration Microsoft Windows Server 2012 R2 à Microsoft Windows Server 2016, Microsoft SQL Server 2012/2014 à Microsoft SQL Server 2016.
- Erstellung der nötigen Dokumente sowie der Ablauf- und Projektpläne.
- Migration der bestehenden Informatica Repositories und Benutzer.
Fachlicher Schwerpunkt dieses Freiberuflers
Data Warehouse Experte, BI, Informatica, Talend, Oracle, Teradata, Informatica MDM, Tech Lead
D4
D5
Ich möchte bevorzugt für Projekte in diesen Einsatzorten kontaktiert werden.
Deutschland: D4 - Duesseldorf, Köln, Bonn, Aachen, Heinsberg,Collm,Wermsdorf, Oschatz, Leipzig, Dresden
Position
Finanz/Industrie Systeme
Projekte
Projekthistorie
07/2005 - 10/2005 DP-IT Solutions, Darmstadt, Germany
Consulting/Analysing the Hardware Concept, Analysis of the SPPS Infrastructure, Branding of the Product (Business Infrastructure Project), and Concepts for an international SPPS Rollout and Project Folder catering for approx. 3.000.000 User worldwide.
Designing IF for SAP/BW, Inspire P8 and Office Applications.
Used Tools: Windows 2003 Server Enterprise Edition, Sharepoint Portal Server, SAP/BW, Inspire P8
03/2005 - 7/2005 BI Consultant, Raiffeisenbank, St.Gallen, Switzerland
Consulting/Analysing the Business Workflow, Analysis of the existing ODS, Problem Management(Financial BWFs like Investment, Assets, Bonds/Shares(Depots) with regards to BASEL II conformity, Credit Risk and Anty money laundring), Module Development(TeleBanking/BOSS), Data Map Development
Used Tools: Informatica PowerCenter 7.1.1, Informatica PowerExchange 5.1.1, Teradata, Oracle 9/10g, ADABAS, SAP/BW, TOAD, GUPTA, Power Designer, Windows 2003 Advanced Server, MS Office 2003, Microsoft Share Point Portal Server 2003, MS Project 2003, MS PowerPoint 2003
10/2004 - 2/2004 DWH Lead, BI Consultant, Biogen-IDEC, Zug, Switzerland
Consulting/Analysing the Business Workflow, Analysis of the existing DWH, Problem Management
Used Tools: Informatica 6.1, Hummingbird Enterprise 2004, BO, WebIntelligence, Oracle 9/10g, SIEBEL Sales 6.5, TOAD, GUPTA, Power Designer, Windows 2003 Advanced Server, MS Office 2003, Microsoft Share Point Portal Server 2003, .net, MS Project 2003, MS PowerPoint 2003
03/2004 - 0/2004 Technical/ Project Manager, BI Consultant, Telekom Austria, Hutchinson 3G
Proof of Concept (BI/ETL Tools), Consulting/Analysing for an updated Business Workflow,
Including a presentation for an ADWH Project Migration. Analysis and Definition of a TMS Plan (including Various Systems e.g. CRM, Billing…) according to the specified and revised Business Rules. Presenting the Strategies to the Customer at Management and Developer Level. Analysing and adjusting the ETL Processes(Data Stage).
Used Tools: Informatica 7, Hummingbird Enterprise 2004, BO, WebIntelligence, Ascential Data Stage, Cognos PowerPlay, Oracle 9/10g, SAP/R3/BW, TOAD, GUPTA, Power Designer, Windows 2003 Advanced Server, MS Office 2003, Microsoft Share Point Portal Server 2003, MS Project 2003, MS PowerPoint 2003, UML, XML, BPML
11/2003 - 2/2004 Project/Line Manager, TFC Financial Programme (egg), Keane, London
Proof of Concept (Informatica), Design of Data Model and Migration Plan to drive the Interfaces for TFC (Basel II compliance) having 35 Source Systems including SAP/R3, Mainframe, Zero Byte Shift Files, etc. Project management, Revision of PM Plan and Re-scheduling.
Working in a team responsible for developing the functional framework and supporting roll out team, both belonging to a large Data Warehouse Project. Defining the data warehousing and data movement architectures. Establishing procedures and guidelines for the design, development and administration of the warehouse. Establishing architecture guidelines for the movement of data to the warehouse from heterogeneous systems. Establishing architectural guidelines for the movement of data from the warehouse to downstream systems Hands on implementation of oracle framework functions and Test Unit framework.
Used Tools: Informatica 6.2.1 Power Centre, Oracle 9.2.0.2, Solaris 9, Oracle Financials, TOAD, GUPTA, Power Designer, Windows 2003 Advanced Server, MS Office 2003, Microsoft Share Point Portal Server 2003, UML, BPML, XML, MS Project
04/2003 - 9/2003 CTO, Senior Data Warehouse Expert,zefa Visual Media, Düsseldorf
Analysing and Modelling the zefa Database for e-commerce to enable 24/7 and real-time rights management, Design of a Data Warehouse. Analysis and Implementation of MS SharePoint Portal Services 2.0(2003) with programming of GUPTA and MS Web parts.
CTO,Project Manager/ Team Leader DB Architecture. Building a Prototype Portal for zefa. Evaluating, test and procurement of Oracle Financials 11i / e-business Suite Gold (CRM used for online Rights management and Customer Care).
Used Tools: Oracle 9i, Oracle e-business suite (EU), Oracle Financials 11i (AR,GL,HR), Oracle Designer, Teradata, PL/SQL,TOAD, GUPTA 3.0, Intalio|n3, Windows 2003 Advanced Server, MS Office 2003, Microsoft Share Point Portal Server 2003, MS Project, CVS, Linux, Power Designer 9.5, Smart Draw/UML, Data Stage(Ascential).
01/2003 - 4/2003 Senior Data Warehouse Expert, Project Manager, Deutsche Post IT Solutions, Düsseldorf
Analysing and re-modelling the ZEBRA Warehouse,
Project/program Leader DB Architecture, Configuration Management,
Analysis and Reporting using CTD 1.5.1 Applications. Re-engineering Business Processes and the Reporting Strategies. Reorganization of the network system (LAN/WAN). Recommending new Security, Process and Engineering standards.
Used Tools: INTALIO|n3, Oracle 9i, PL/SQL, Teradata, TOAD, SQLNavigator, Centura/GUPTA, Visio Professional, MS Project, Informatica 6.0 Workflow within PowerCenter 6.0), Cognos, Power Designer 9.X, C.A.R.E. 2.0, Windows NT/XP
Using Oracle Financials with the integrated OF Intelligence and OF Analyzer to
establish and measure key financial drivers and monitor the company's financial performance.
Establishing business views to projected performance metrics to help the management
to decide and implement necessary corrections.
Developing new plans and revising budgets and forecasts and evaluating risks.
Used OF Products:
Assets, General ledger, Receivables, Risk management, Financial Analyzer, Financial Intelligence
05/2000 - 1/2002 Team Data Warehouse and Billing, Vodafone D2 and Amdocs, Düsseldorf, Germany
Reporting to the management with a department of various responsibilities include reacting to clients requirements, ensuring efficient delivery of solutions, performing necessary impact analysis( connecting AMDOCS CRM to Update5 and SAS), monitoring the update of documentation.
Managing, Supervising and performing various Implementation and Migration Tests( writing Test cases, managing and staging Prerequisites and monitoring and interacting with the attached Interfaces, Monitoring and supervising the Correct Processing of data provided by MAF/MPS, Billing using a self-programmed Centura Application) for the biggest Telecoms Data Warehouse(Teradata). Monitoring the parallel processes of several instances and verifying the Data Quality on the Oracle 9i and Teradata Databases. Writing supporting shell scripts and programs using UML, XML, Centura with implemented internal (self developed) Pro*C and C DLL's. Migrating BO Reports and Interfaces (WebI).
Major Achievement:
- Programmed and implemented a fully integrated Management Information System that improved management reporting and business analysis using Business Objects 5.x and PVCS , SAP R3/BW, Centura and RTM.
- Gaining further experience in Testing, QS and ORACLE management, programming(PL/SQL), scripting and setup under SUN OS and Solaris 8.Introduction to AbInitio(Theoretical, workshop, 1 day), Cognos PowerPlay (Workshop, Hands-on), Update Generation 5(Theoretical, workshop, update. web, update.pda, 1 day) and Informatica 6 PowerCenter, Informatica Power Exchange.
03/2000 - 05/2000 Senior Application Developer, Monitor Software, York, UK
Upgrading and reprogramming of a security system.
New development for the US and continental market (Billing System).
Systems Analysis and Impact Analysis for the Billing System.
Supervision of Documentation and Testing.
12/1999 - 3/2000 Senior Application Developer, Deutsche Bank, Eschborn, GER
(Re-) development financial application for a leasing-company.
Supervision of Documentation and Testing
09/1999 - 11/1999 Senior Application Developer, MoD Defensie, Maasland, NL
Y2K analysis of existing programs.
07/1999 - 08/1999 Senior Application Developer, Monitor Software, York, UK
Port of Sentinel Plus/Service to Centura 1.5.1.
06/1999 - 07/1999 Senior Application Developer, UNCC, Geneva, Switzerland
Development of the Grouping program for the United Nations Claims Commission.
05/1999 - 06/1999 Senior Application Developer, Sunit Ltd., Dingwall, Scotland
Development and Design of a Forestry program.
12/1998 - 05/1999 Senior Application Developer, Deutsche Post (Mail), Duesseldorf, Germany
Development & Programming for the IPZ (International Mail Centre) - Frankfurt.
11/1998 Senior Application Developer, AIT plc, Henley on Thames, UK
Y2K fixing and compliance testing for the Halifax Explorer 1.
06/1998 - 10/1998 Senior Application Developer, Softlab, Redditch, UK
Development of International Stock Management System for Rover.
Fixing bugs in existing Applications.
12/1997- 06/1998 Senior Application Developer, Airclaims Ltd., Heathrow Airport, UK
(Re-)Programming CASE-Aircraft Application and Redesign of CASE Aviation Database.
9/1997-11/1997 Senior Analyst Programmer, SGS Forestry, Oxford, UK
Programming and writing Crystal Report-Libraries for LogTrak, Bug-fixing and testing of the application.
11/1996-04/1997Senior Analyst Programmer, General Accident, York, UK
Design and programming a GUI prototype for System Development. The project consisted of programming a GUI to connect to the Mainframe and retrieve data, using an Internet Browser.
The major aim was to become platform independent and this led to the decision to program the application using Java (J++).
Redesign and programming the ScriptBuilder for the Tele Marketing Unit (TMU).
The project included the redesign and programming of the existing ScriptBuilder, user handling and administration programs for the TMU, as well as a complete redesign and restructuring of the existing database (SQLBase).
1991 - 11/1996 OPEC FUND, Vienna, AUSTRIA
Project Manager
Database Manager
Network Manager
Systems Analyst
Senior Programmer
Trainer
Design and programming a Management Information System (MIS).
Programmed Modules for MIS: Bank of Projects, Preliminary Analysis,
Operations under Consideration, Operations follow-up System,
Financing System, Personal System, Loan and Grants System, Fixed Assets and Bonds System. Design and programming an Internet Homepage.
User Training (Windows 95, NT4.0, MS Word, MS Excel, MS Schedule+,
MS PowerPoint).
Redesign and maintenance of the OPEC Fund LAN.
1984 -1991 Siemens AG, Vienna, AUSTRIA, Nuremberg, GERMANY, Karlsruhe, GERMANY, Taranto, ITALY, Riyadh, SAUDI ARABIA
Consultant
Systems Analyst
Project Leader
Programmer
Consultancy for various projects for Siemens AG.
The main projects were:
- A military project for the Ministry of Interior in Riyadh, Saudi Arabia.
- A database conversion interface for the "Bundesanstalt fur Arbeit" (Department of Labour) in Nuremberg, GERMANY
- Project Leader Quality Assurance in Munich, GERMANY
- Programming the measurement section for a steel-mill in Taranto, ITALY
Project Management/Team Leader experience
SIEMENS AG, KARLSRUHE, GERMANY
Team Leader in a military project in Saudi Arabia.
Finished in time with 4 engineers and 4 programmers.
SIEMENS AG, NUREMBERG, GERMANY
Team Leader in an interface project for the department of labour.
Finished in time with 2 programmers.
SIEMENS AG, MUNICH, GERMANY
Team Leader IX400 project, quality assurance, implementation, testing.
Finished in time with 4 engineers, various
Programmers and testers.
OPEC FUND, VIENNA, AUSTRIA
Team/Project Leader in the MIS Project with
3 programmers and various testers.
AMDOCS
Team Leader Development/Support with 5 Programmers and various testers(20).
Branchen
- Banken
- Versicherungen
- Automotive
- Medien
- Holzverarbeitende Industrie
- Gouvernement
- Luftfahrt
- Insurance, Lebensversicherung, Unfallversicherung
- Telecommunication, Billing, Usage
- Finanzorganisationen, Data Warehousing, ETL, BI
- Government, MIS, Analysen
Kompetenzen
Methoden:
Analyse von Geschäfts – Erfordernissen und Strategien, Beurteilung von Softwarelösungen ( SAS, BO, Crystal Reports, ORACLE, ORACLE Forms, Centura, Informatica, MSSPS, MS-SQL Server Integration/Reporting- Services).
Aufgaben:
- Untersuchung und Analyse von Datenbank-Strukturen inklusive Integrität und Inhalt. Zusammenarbeit mit anderen IT-Spezialisten und Anwendern für existierende und neue Berichte sowie Anforderungen. Analyse und Entwicklung mit ORACLE Financials (AR, GL, HR) sowie Siebel.
- Erstellung einiger Geschäfts-Prozess orientierter Management Informations- Systeme und (A)DWH für Konzerne, Klein- und Mittelbetriebe.
- Projekt- und Teamleiter, Entwickler, Senior BI Consultant
- PRINCE, DSDM, ITIL, CMMI
- Budgetplanung,
- Ressourcenplanung,
- Erstellung von Skill-Matritzen,
- Management Reporting,
- Anforderungsaufnahme,
- IT Solution Portfolio Management (McFarlan's IT portfolio matrix) – IT Architektur/ IT Governance
- Office Automation (PROFS)/Workflow Solutions (BPMN, BPML, WF…)
- Aufsetzen von End 2 End(E2E) Monitoring,
- SPPS Projekt und Reporting Sites,
- IT Service Management.
- Internationale Erfahrung in der Leitung komplexer, multilingualer, konzernübergreifender Projekte sowie Aufbau von Business Intelligence Competency Centers-BICC (TeraData, Informatica, Oracle).
- Etablierung Stakeholder Managements u.a. für den Bereich Workplace Solutions zur Verbesserung der Transparenz bzgl. Verfügbarer Lösungen, wie auch der Bündelung und Strukturierung von Anforderungen (DOORS).
- Koordination der Anforderungen im Bereich Workplace Solutions mit den IT Funktionen die die Lösungen erstellen und betreuen, zur gemeinamen Planung einer Roadmap.
- Damit Sicherstellung der Lieferung in Time in Budget.
- Analyse, Vereinfachung, Anpassung und Verbesserung bestehender Geschäftsprozesse.
- BASEL II Implementierungen bei Finanzorganisationen und Versicherungen.
- Unterstützung/Abwicklung bei Mergern im Telekommunikations –, Versicherungs- und Finanzbereich.
- Konzeption, Analyse und Erstellung von Sharepoint Lösungen(Applikationen, Serverfarmen).
- Schulung und Training für Informatica, MS Office.
- Screening, Beratung, Coaching
Fach-/Prozess-Kompetenz:
- Core Business Processes: Insurance, Management der Bestands-/Vertragssysteme, Reporting & Analysen (spezielle Rechnungslegung)
- Telekommunikation: ETL Prozesse, Analysen
Methodische Kompetenzen:
- (Management) Beratung, Moderation, Workshop, War-Room
- Konzeption, Logische Datenmodelle (UML, BPML), Fachkonzept, IT Konzept / technisches Design
- Projektmanagement, Teilprojektleitung / Teilprojektmanagement / Technischer Projektleiter
- SW-Engineering, Datenbankentwicklung, Datenbereinigung, Datenmigration, UML, Dokumentation (Anwendungsdokumentation, Systemdokumentation, Betriebshandbuch)
Standard-Software - Entwicklungswerkzeuge:
- MS SQL Management Studio
- Centura Team Developer(incl. Team Manager)
- GUPTA 3.0
- BCM (IT-Sicherheit, Informationssicherheit, Risikomanagement, Archivierung und Disaster Recovery )
- TOAD – 12.x
- Power Designer – 16.x
- Hummingbird Exceed
- Metadata Services(MDS) – Oracle/Teradata
- Symantec Visual Cafe
- Erwin RX – 5.X
- SAS Base/Statistics
- Business Objects – XIR2
- Informatica PowerCenter 6.1.2, 7.x.x, 8.1.1, 8.5.1, 8.6.0, 9.0, 9.1, 9.5.1, 9.6.1, 10.1.1
- Informatica PowerExchange 5.x.x, - 9.5.1, 10.1
- Informatica MDM-Masterdata Management, IDD, IDQ 10.2
- Teradata MDM
- Ab Initio
- Cognos Data Manager 10.x
- SAP R/3
- ORACLE Forms - 11.1.x.x
- ORACLE Data Integrator – 11g
- ORACLE Warehouse Builder
- MS SharePoint Portal Server – 2013
- SQL Server Integration Services, Reporting Services
- Prognosis (Integrated Research)
- Cognos 8
- Impromptu, Powerplay
- VMWare -10 Workstation/Server
- MS Virtual PC
- MS CRM
- Ascential DataStage
- DOORS
- Intalio|n3
- Hummingbird Enterprise 2004
- DynaSight
- Talend 6.5.1/ 7.0.1
Praktika:
- Forschungslabor McDonnell-Douglas, Torrance, Kalifornien
- Moskau (1982)
- Peking(1983)
- Tokyo (1984)
- Westerland (1984)
Kompetenzschwerpunkte:
- Analyse, Entwurf, Test, Prüfung, Schulung, Tuning, Unterstützung, Migrationen von Data Warehouses für Industrie, Versicherungen, Finanzorganisationen, Automotive, Luftfahrt,Telekommunikationsunternehmen, Makler, Sicherheitsfirmen, der holzverarbeitenden Industrie, Internationale Institutionen und Ministerien.
- Erstellung von Fachfeinkonzepten, Gutachten, Installationsrichtlinien, Frameworks, Dokumentationen.
- Datenbank- / Instanz-tuning, Foster-Handling unter Verwendung der Best Practices -Whitepaper und Dokumentationen (Hardware Tuning, Clustering, Hashing, Indexing, Denormalizing,..).
- BARC Dokumentation/White Paper/Studie für Oracle 9.
- Erstellung von Virtuellen Maschinen/Umgebungen mit MS Virtual PC und VMWare.
- Entwicklung und Design neuer Data Warehouses und Reports unter ORACLE, Teradata, DB2, MS-SQL Server Reporting- Services.
- Monitoring und Erstellung von Server Systemen mit Prognosis (Key Performace Views, Application Details, OLTP Overviews, Availability Central), PowerDesiger, ErWin..
- Entwicklung von Firmen Systemen mit ORACLE Financials und Siebel Reporting, Data Warehouses und Data Marts für MIS und Historische Informationen, sowie deren Befüllung mit OWB/ODI, Informatica und Abinitio.
- Einsatz von Informatica MDM um auf betriebliche Anforderungen bei der Stammdatenverwaltung einzugehen um mit Hilfe des Mehrdomänenansatzes bei der Stammdatenverwaltung die Betriebsabläufe zu verbessern um mit konsolidierten und zuverlässigen geschäftsentscheidenden Daten sowie Informationen über die Beziehungen zwischen den Daten arbeiten zu können, bzw. diese bereitzustellen.
- MDM-PoCs für Unternehmen in den Bereichen Finanzdienstleistungen, Pharmazeutik, Automotive, Ministerien und Einzelhandel sowie Einrichtungen im öffentlichen Sektor.
- Design, Entwicklung und Inbetriebnahme von Systemen unter Verwendung von Business Objects (BO) und ORACLE.
- Migration von Universen und Reports von BO 3.1 nach 4.1(5.1 à BO XI R2) auf Finanzsystemen und Anwendungen.
- Verwendung von SQL(ORACLE, SQLBase, MS Sqlserver), BO, Business Miner und verschiedenen Web-Basierten Anwendungen für Reportwesen im medizinischen Bereich, sowie Distribution zum Anwender via Dokument Agent und E-Mail.
- Platform übergreifende Portierungen und Daten-Extraktionen/Portierungen(ETL Prozesse) unter Verwendung von Informatica PowerCenter, Data Stage, Hummingbird (Genio), sowie Ab Initio.
- Migrationen und Migrationskonzepte Informatica V6 -> V7,V6 -> V8 -> V9.
- Übersiedlung von Rechenzentren (Erstellung Projekt- und Migrationspläne, Applikationsverantwortung)
- Proof of Concept Informatica vs. ODI sowie Informatica vs. Cognos.
- Erstellung von (A)DWHs, Financial Warehouses, Report Layern und Daten Repositories unter Verwendung von IBM Cognos Data Manager.
- Analyse und Planung von Portal Lösungen mit OAS, Hummingbird und MS SharePoint Portal Server(u.A. Erstellung von Webparts mit MS Visual Studio .net, Implementationen, Planung und Analyse).
- Analyse und Planung von Data Warehouse Lösungen mit OWB, Power Designer und Erwin.
- Installation, Test und Upgrade BO 4.1.3 nach BO 5.1 sowie nach BO XI R2.
- Empfehlung und Einführung von DB Änderungen für komplexe
Referenzen gerne auf Anfrage.
Ausbildungshistorie
Institution: Universität Los Angeles ( UCLA )
Ausbildung: Informatiker und Radartechniker, Stipendium von McDonnell-Douglas
Zertifikate:
2004:
Seminare TDWI
2000:
Einführung Ab Initio
2001:
Informatica Power Center/Exchange Schulung
2004:
Active Data Warehouse
2003/2004:
BASEL II Seminare
2005:
Teradata Expert/Customer Training
1999:
- Novell CNE
- Talend OIS – Verschiedene Webcasts (privat)



