• Design and refactoring of logical and physical data model within a multi-tier DWH (Data Vault 2.0, data lake, STAGE, CORE layer design)
• ETL/ELT pipes ? design,development and orchestration, design deployment strategy (DevOps, CI/CD)
• Data provisioning / data injection from/into diverse legacy systems, performance tuning and quality assurance provisoned data. transformation into Datasphere (POC), definig alerting and notification methods and canals
• Business needs assesement according to the NIS2 directives and their prototypical (POC) implementation

• New data objects integration and data extraction from lagacy systems into hub/core/analytical layer of DWH (MS SQL)
• Migration SAP FI/CO to SAP S/4Hana (master-, transactional- and historical data) from div. SAP/NonSAP legacy systems (Ariba, SuccessFactors...). Preparation fand prerequisite work for DORA regulation
• Determine/define business and natural keys, build the SCD2 methods on the stage/ core layer ("Light Integration"), introduce of bi/multitemporal data historisation routins (within Wherescape RED templates and SAP Data Services)
• Orchestration of data pipes (ParTcl), packeting/versioning data models, perform the full and delta loads, scheduling and continuous monitoring loads across the envs
• Perform the developer and integration tests, document the tests results, prepare the automatic integrity test methods (incl. envs deployments and building performance metrics), develop the cleansing and notification rules

• Efficient data transfer DB2?2-Oracle incl. migration dashboard solution (retail customers and payment reports)
• The performance analysis and several optimizations of long running tasks and reports), run deployments across the envs, monitoring the production rollouts, enabling security protection, the orchestration and stabilisationof ELT processes
• Design and development data models, develop SAP migration strategy, build interfaces and aggregats for Metis's Chatbot solution, implement DSGVO guidelines

• several data migration projects from div. CRM?s SAP/Non SAP/legacy systems (Salesforce, MS.Dynamics) into SAP S/4 Hana
• Develop the migration strategy for transaction- and master data (MARA), build the mapping documents and GAP-analysis, propagate the changes via DevOps, data profiling and mitigate the data quality issues in SAP FI/CO
• Develop the data validation rules, preparation test cases, validate the integration tests results, visualisation data quality issues (via dashboarding), coordination of Delivery Owners, Go-Live support

• Design and implementation of the methods for ?selective data efface?, according to ?Art 17 DSGVO? (General Data Protection Regulation ? GDPR)
• Prototypical implementation of the fast ?delete routin? for the high volume database tables inside of the existing Enterprise Data Warehouse
• Development of the efficient Data Lineage Reports to reflect the hierarchical source- target dependency

• Project ?Decision Service Room ? DSR?, design and development enterprise DWH architecture (MySQL Server / PostgresSql on AWS RDS)
• Design/implementation logical and physical data model (stage, core and mart(s) layer with ?Row Level Security? enabled)
• Build ETL/ELT jobs, orchestration of loading processes cross over the DHW layers and legacy systems, RESTful API and Kafka interfaces
• Extension and customising of existing SAP SAC reports (?Smart Predict?, ?Smart Discovery?)
• Integration and E2E s, performance test preparation, UML

• Build functional Data Marts (PostgresSql with Data Vault 2.0 and Snowflake DB) and publish it to the customers via REST Api connectors
• Transfer existing Informatica workflows into the Amazon Cloud
• Several migration projects around the AWS Cloud Computing (data sourced from DB2, Oracle, flat files...).
• Transfer existing Informaticas workflows into the Amazon Cloud
• Redirection of existing reporting solution (SAP BOXI) from Oracle to AWS Redshift
• Collection and documentation of functional and non-functional requirements, requirements management
• Build an interface to the SAP PP "Production Planning" and to SAP sAFI (SAP HANA with Calculation Views ans SLT) and set up the daily load pipelines

Online shop interface

• Online shop interface, design the connectivity to DWH and SAP Hybris, 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 (the comparison of Informatica's PowerCenter 9.5 vs. SLTvs. BODS 4.1 vs. Oracle ODI 12c)
• 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)
• SAP Business Objects 4.2 SP1 (WebIntelligence, Lumira, Universe Designer, IDT etc.)
  

• 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, documentation

• 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