• Build a functional Data Mart (PostgresSql with Data Vault 2.0) and publish it to consumers via REST Api
• Several migration projects around the AWS Cloud Computing.
• Transfer existing Informatica workflows into the Amazon Cloud
• Redirection of existing reporting solution (SAP BOXI) from
  Oracle to Redshift

• Online shop interface, design the connectivity to DWH and SAP ERP, implementation, tests and roll-out
• Load performance optimisation (full and delta load)
• Design of the reporting framework for the hierarchical product composition

• Design and development of the data extraction process from HP Service Manager to Enterprise DataWarehouse (EDWH)
• Data modelling layered Enterprise DWH (including Performance Data Model and Security Concept)
• Cost Reports: Design, development and distribution
• Evaluation of real time data processing methods for the interface to a Cocpit Desktop Solution (Informatica's PowerCenter 9.5 vs. SLT  vs BODS 4.1)  
• Preparation of User Acceptance Tests, coaching of power users

• Design und build of regulatory reports acording to
  German Banking Lav (SolvV, GroMiKV)

• Several preliminary work for Solvency II (technical requirement analysis)

• Design of the data download from SAP BW (BODS Extractors, PL/SQL), MAN AG, Munich, Germany
• Implementation of the business semantic layer (Business Objects Universum)
• Design, implementation and tests of the standard reports (WebIntelligence)

• Design and development a large size data warehouse (>1 TB), SEB AG, Frankfurt/Main, Germany
• Several reporting tasks according to BaFin (Master KVGen, EAEG, “Anlegerentschädigunggesetz”)
• Splitt-off master data and transaction input data after die acquisition of SEB AG Bank by Santander Bank. The integration of “Mandator Concept” during the curving-out phase.
• Requirements analysis, sizing & modelling of the Star Schema
• Coordination between specialist- and development departments
• Design and development of ETL Interfaces (Informatica's PowerCenter)
• Release management across the working environments: Production, Testing, Development, Acceptance
• Performance tuning (SAP BO, Oracle10g) and harmonisation of the loading time (Informatica)
• System upgrade SAP BO 3.x to BO XI 4.1 (front-end and servers)
• Knowledge transfer to the end-user, internal trainings

• ETL development (SAP BO Data Integrator, former "BODI", now Data Services). The data extraction from SAP RMCA/FI. Kabel Deutschland AG, Munich, Bavaria
• ETL Lead, design of the extraction strategy from SAP RMCA /FI"
• Security concept (with BO CMC)
• Interface to SAP RMCA: design and implementation
• Unit and Integration (Regresion)Tests
• Projekt controlling, progress and status raporting
• Co-design of Reporting Data Model ( stage and output area), population of Hub / Satelite entities
• Release management

• Project Lead "Real Time DWH" (Data Office)
• Assessment external supplier
• P/L Responsible (ca. 1M €)
• Supervising of the whole Software Development Lifecycle (Business Objects XI3, BO Data Services 3.1, Oracle 10g)
• Development Mappings and workflows with BO Data Services
• Supervision of the start-up phase, roll-out and maintenence

• Web Intelligence, InfoView
• Evaluation several ETL tools: OWB, BO Data Services, PowerCenter
• DWH Design (stagging and output schema, R. Kimball methodology). Universe Designer, OWB.

Project description

• Volkswagen AG, Wolfsburg Business Intelligence Study and Quality Assurance with BO Voyager, Essbase Hyperion, Informatica's PowerCenter 8.1 and BO Data Services 3x
• Data Cube design and composition, (PowerCenter, BO Universe Designer)

• Various customer's projects across BI and Data Warehouses (relational, multidimensional database technologie)

• Prepaid System migration by Polkomtel (Poland), 9 Mio subscribers
• Migration Project Leader (up to 10 developers)
• Implementation of Operating Number Portability Directives. Cooperation with Sicap, Switzerlad
• RUP rules and methods

• Kenan/BP migration strategy
• PowerCenter 7.1 /PowerMart development (ETL, Informatica)
• Migration Strategy, Kenan/BP: GUI- unit and integration testing (WinRunner, TestDirector)
• Design and develop the PowerCenter's extention: Stored Procedures in Oracle 9i, DLLs
• Migration of the PowerMart's mappings into new PowerCenter environment
• Adoption of the "old" transaction mechanisms in PowerMart and re-utulize they in PowerCenter.

• OOA/OOD (Rational Rose XDE, Toogether Soft.)
• Framework development (J2EE), ETL interface (loading data into target system only)
• Customising and optimize of the PowerMart entities (mappings, DLLs, key generators) according to the requirements

• Migration from BSCS5.21 to MCBS
• 1 Million customer, 1Milion wireless contracts (TwinCard and TwinBill contracts included).
• Design of Data Mapping Tool (SQLoader based on ORACLE 8i, ERWIN, SQLPlus)
• Cowriting of scripts for the data export (PowerMart from
  INFORMATICA, SQLPlus)
• Responsible for the Analysis, Design, Implementation, Testing and Rollout
• Installation and administration of the PowerMart’s repository (including DB2Connector) in multiple server environment.
• Testing: Preparation for the test bill run in the new billing system.
• Supervising and Support of parallel working in the production environment

• Billing & rating system upgrade: BSCS5.0 to 5.21, only wireline customer.
• 5k private/business customer and 6k active contracts.
• Responsible for the staffing of the Design Team and the Migration Task Force.
• Co-operation and coaching during the Design, Development and Implementation of the Migration Client ("C" programmed, TCP/IP based tool worked with BSCS's CAS-Modul).
• Performance enhancement of the PowerMart’s mappings (by the optimize of SQL-statements and IO-transactions), design and implementation of the PM’s “schedule tasks” and notifications components.
• Writing test cases and acceptance protocols.
• Quality Management

• Responsible for the Change Request Management, Post-Migration-Phase, Germany
• Evaluation of the Migration from COPS to BSCS5.0
• Analyse and the 1st level Support for the rating problems
• Management of the migration related problem requests and customer requests

• Team Leader of CAS (Customer Administration Server) Development Group.
• Designed the System Upgrade Strategy
• Responsible for migrations into BSCS
• Design the extract, conversion and loading logic for customer’s migrations (PL/SQL, SQL, C++).
• Design, tuning and administration of our databases (ORACLE 7.3.4 and 8i)
• Designed and developed Migration Testing Strategy.
• Develop the templates for ETL reports (SQL, PL/SQL).
• Database design: entity relationship, logical/physical, process modeling, CASE tools.
• Relational database analysis/programming against Oracle, Sybase, DB2, SQLBase..., etc.
  SQL data definition, retrieval and manipulation; Coding of stored procedures, triggers, views.

• Developed and integrated Dynamic Linking Librarys and Shared Objects in C/C++.
• Customized billing and rating systems for the telecommunication service provider in EMEA (batch and online modules)
• Tested and fixed defect
• Evaluated new technologies for implementation throughout the organization