Data Warehouse Expert, PM, BI, DWH, Informatica

01/2010 – 04/2011      Project Manager/BI Consultant/Analyst, 1&1, Montabaur, Germany

Conceptualisation of new DWH Workflows, BI Analysis (E2E), Modelling, Business Process Analysis, Technical specification (BI/DWH), Analysis/Migrating Telco Data to various Customers within the Company.

Merger Support and Project Management (Product server/ Billing/E2E/EBI).

Modelling/Creating DWH-Prototypes.

Merging Sybase IQ/ASE --> Oracle 11g.

Prototyping UTF-8 migration Unicode(Sybase IQ --> Oracle --> Business Objects).

Used Tools: PowerDesigner 15, Oracle 11g, Informatica  PowerCenter 8.6.1/ 9.0,
Sybase IQ 12.7, ASE15, MS Office 2010, MS Project Professional 2010, MS Visio
Professional 2010, TOAD 9.6, MOSS

 

04/2009 – 01/2010     Project Manager/BI Consultant/Analyst, Telekom, Darmstadt, Germany

Conceptualisation of new DWH Workflows, BI
Analysis (E2E), Modelling, Business Process Analysis, Technical specification
(BI/DWH), Analysis/Migrating Telekom Data to various Customers within the
Company. Merger Support and Project Management (Active Billing/E2E.).

 

Used Tools:Erwin, PowerDesigner 15, Oracle 11g, Informatica  PowerCenter 8.5.1, IBM DB2
(UDB), MS Office 2007, MS Project Professional 2007, MS Visio Professional
2007, GenIT, TOAD 9.6, ALTOVA XML Spy, MOSS

09/2008 - 04/2009     BI Consultant/Analyst, AXA Insurance, Cologne, Germany

 

Conceptualisation of new DWH Workflows, BI Analysis (MY Choice), Modelling, Business Process Analysis, Technical specification (BI/DWH), Migrating Data to the AXA DWH due to a merger..

Used Tools:       Erwin, PowerDesigner 12, Oracle 10g, Oracle 11g, Informatica  PowerCenter 8.6, IBM DB2 (UDB), MS Office 2007, MS Project Professional 2007, MS Visio Professional 2007, GenIT, TOAD 9.1

01/2008 - 8/2008 BI Consultant/Analyst, Eurohypo Bank, Frankfurt, Germany

 

Conceptualisation of new DWH Workflows, BI Analysis, Modelling, Business Process Analysis, Technical specification (BI/DWH/Report Layers).

Used Tools:       Erwin, PowerDesigner 12, Oracle 9a, Oracle 10g, Oracle 11g, Informatica  PowerCenter 8.5.1, IBM DB2 (UDB), MS Office 2007, MS Project Professional 2007, MS Visio Professional 2007, GenIT

04/2007 - 01/2008 Senior BI Expert, Volkswagen AG, Wolfsburg, Germany

 

Pre- Analysis and Analysis for the Migration and Rebuild of the Customer and Quality DWH. Technical Lead PoC (Informatica. Technical Lead HW/SW Concepts BI Processes/Business Workflows. Workshops Management/Departments assessing new strategies. Re-build Customer DWH. Building an Teradata Competence Center.

Used Tools:       AIX , TOAD 9.1, MS Office 2003/7, Microsoft Share Point Portal Server 2003/7, MS PowerPoint 2003/7, Oracle 9,10g,11g, IBM DB2-UDB , TeraData, Business Objects XIR2,  Informatica 8.1.1, OWB 10.


02/2007 - 05/2007 Senior BI Expert, DHL-Excel, Hamburg, Germany

 

Pre- Analysis and Analysis for the Migration and Rebuild of the international DWH. Technical Lead PoC (MSPPS).
Technical Lead HW/SW Concepts BI Processes.

Used Tools:       Windows 2003 Server R2 , TOAD, MS Office 2003/7, Microsoft Share Point Portal Server 2003/7, MS PowerPoint 2003/7, Oracle 9,10g, Cognos8,  Informatica 8.1.1.


11/2006 - 02/2007 Senior BI Expert, Swisscom, Ostermundigen, Switzerland

 

Technical Lead for a new Billing System. Technical Lead PoC (Informatica).
Technical Lead HW/SW Concepts Billing/BI Processes.

Used Tools:       Windows 2003 Server R2 , TOAD, MS Office 2003/7, Microsoft Share Point Portal Server 2003/7, MS PowerPoint 2003/7, Oracle 9,10g, IBM DB2,  Informatica 8.1.1.



01/2006 - 10/2006 Senior BI Expert, MLC Business Consulting, Zwickau, Germany

 

Various BI Projects including a HW/SW Technical and Strategy Document for a new Financial IT Environment, Setting up a Process Designer within SharePoint Portal 2003, Writing the HW/SW Concepts for a micro technology company, leading a PoC for Cognos à Teradata, Authoring a criteria catalogue for a financial Organisation(Oracle 10g, OWB).
Writing professional training presentations incl. SAS 9.1.3, BO XIR2..
Leading and doing the conceptual work for a migration Strategy BO 5.1 à BO XIR2.
Implementing Office Automation (Exchange 2007, Office 2007 and SharePoint Portal Server 2007). Concept and Design of a Housing Database (SQL Server 2005).

Used Tools:       Windows 2003 Server R2 , TOAD, MS Office 2003/7, Microsoft Share Point Portal Server 2003/7, MS PowerPoint 2003/7, Oracle 9,10g, Teradata, SAS 9.0, Informatica 6.5,7.1, SQLServer 2005.

10/2005 - 1/2005 DWH Consultant, Proximus, Brussels, Belgium

 

Consulting/Analysing the UAT Concept, Analysis of the Teradata and Informatica Infrastructure. Shell scripting Migration Scenarios.

Used Tools:       Windows 2000, SUN-OS, Teradata, Informatica 7.X

07/2005 - 0/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 Keane, London

                Project/Line Manager, TFC Financial Programme (egg)

 

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 zefa Visual Media, Düsseldorf

                CTO, Senior Data Warehouse Expert

 

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 Deutsche Post IT Solutions, Düsseldorf

                Senior Data Warehouse Expert, Project Manager

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            Monitor Software                York, UK
Senior Application Developer

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           Deutsche Bank                   Eschborn, GER

Senior Application Developer

(Re-) development financial application for a leasing-company.
Supervision of Documentation and Testing

09/1999 - 11/1999          MoD Defensie                     Maasland, NL

Senior Application Developer

Y2K analysis of existing programs.

07/1999 - 08/1999        Monitor Software               York, UK

Senior Application Developer

Port of Sentinel Plus/Service to Centura 1.5.1.


06/1999 - 07/1999    UNCC                                 Geneva, Switzerland

Senior Application Developer

Development of the Grouping program for the United Nations Claims Commission.


05/1999 - 06/1999        Sunit Ltd.                            Dingwall, Scotland

Senior Application Developer

Development and Design of a Forestry program.

12/1998 - 05/1999     Deutsche Post (Mail)          Duesseldorf, Germany

Senior Application Developer
Development & Programming for the IPZ (International Mail Centre) - Frankfurt.

11/1998                   AIT plc                       Henley on Thames, UK

Senior Application Developer
Y2K fixing and compliance testing for the Halifax Explorer 1.


06/1998 - 10/1998              Softlab                              Redditch, UK

Senior Application Developer

Development of International Stock Management System for Rover.
Fixing bugs in existing Applications.

12/1997- 06/1998  Airclaims Ltd.         Heathrow Airport, UK

Senior Application Developer

(Re-)Programming CASE-Aircraft Application and Redesign of CASE Aviation Database.

9/1997-11/1997    SGS Forestry         Oxford, UK

Senior Analyst Programmer

Programming and writing Crystal Report-Libraries for LogTrak, Bug-fixing and testing of the application.

11/1996-04/1997   General Accident          York, UK

Senior Analyst Programmer

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).