Business Intelligence- und Data Warehouse Architekt, Integration- und Datenqualitätsexperte, Technicher Projektleiter und Anforderungsmanager.
Aktualisiert am 11.06.2025
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 07.07.2025
Verfügbar zu: 100%
davon vor Ort: 100%
Data Vault 2.0
DWH mit ETL (Wherescape-dbt-Talend-BODS)
Umsetzung der Regulatorik (DSGVO-DORA-NIS2) backend-frontend)
Anforderungsmanagement/Analyse
Wherescape (3D, RED)
Informatica PowerCenter - Developer - MDM
SAP BO 4.x (IDT - DesignStudio - WebI, Crystal, Universe)
ETL/ELT (SAP BODI, BODS, Informatica, Talend TOS)
DWH (3NF, Dimensional, Snowflake, DataVault 2.0)
Billing- und Ratingsysteme (Ericson BSCS-iX, Kenan FX)
Architekturmanagement (SPARX Enterprise Architect, ERWin)
Businessintelligence, Reporting und Dashboards (PowerBi, QlickSence, Lumira, SAP WebI)
Java 2 EE (RESTfull API, SpringBoot, Swagger/Postman clients, Keyclock, GitLab, SVN)
Amazon Webservices (RDS, S3, EC3, Lambda, DevOps, CloudWatch, CloudFormation)
PostgreSQL - Oracle - Multitenant - MariaDB - MS SQL Server - AWS Redshift
Snowflake (incl.snowpipes)
dbt (dbtvault)
SAP MDM MM PM PI FI CO Hana
Regulatorik -DSGVO MiFID II MIFIR
AWS MS Azure (Fabric...)
Atlassian Software und agile Methoden (SCRUM SAFe Jira Confluence Kanban ...)
SAP Analytics for Cloud (SAC) und Datasphere
SAP Migration (conversion analyse - simplification objects - mappings)
English
Practice
German
mother tongu
Polish
mother tongue
Russian
Basics

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz

Schweiz: Zürich

nicht möglich

Projekte

Projekte

1 Jahr 7 Monate
2023-11 - heute

Design and refactoring of logical and physical data model

Data Engineer / DWH Designer / Data Architect Innovator 15.2 SAP Hana Studio SAP Datasphere ...
Data Engineer / DWH Designer / Data Architect
  • 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
Innovator 15.2 SAP Hana Studio SAP Datasphere SAP Hana (incl. CDS/CS Views) HDBSQL NIS2UmsuCG Salesforce Jira/SCRAM CICD methods GitHub Apache Airflow Python 3.x SAP Fieldglass SQL/PLSQL
BG Phoenics
Hannover, Germany
8 Monate
2023-03 - 2023-10

New data objects integration

DEVOps/ ETL/ELT Developer Wherescape (RED BLUE) ParTcl ...
DEVOps/ ETL/ELT Developer
  • 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
Wherescape (RED BLUE) ParTcl Computer System Validation (CSV) guidelines MS SQL OpenShift MS Azure DevOps ?Digital Operational Resilience Act? ? DORA SAP FI/CO Fiori SAP S/4Hana SAP Powerdesigner / ArchiMate SQL/TSQL SAP LSMW SAP DS 4.3 MLOps Pipes GitHub
Zurich Insurance Group AG
Zürich (Switzerland)
2 Jahre
2021-04 - 2023-03

Active DataWarehouse

DWH Migration Developer AS400 DB2 and Oracle 19c Enterprise Edition SAP FI/CO (IDocs) SAP Data Services 4.x ...
DWH Migration Developer
  • 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
AS400 DB2 and Oracle 19c Enterprise Edition SAP FI/CO (IDocs) SAP Data Services 4.x SQL/PLSQL Quest's Toad Toad for DB2 Snowflake and Snowpipe dbt (data-base-tool) with dbtvault plugin Docker Desktop IntelliJ IDEA DevOps CI/CD pipelines inside of ML frameworks GitLab Grafana Atlassian Software (Jira Confluence)
PostFinance AG
Bern (Switzerland)
11 Monate
2020-05 - 2021-03

several data migration projects

SAP Data Migration Architect / Data Migration Developer Informatica PowerCenter 10.2 (with idocs interface TDM and QM) SAP Migration Cockpit ...
SAP Data Migration Architect / Data Migration Developer
  • 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
Informatica PowerCenter 10.2 (with idocs interface TDM and QM) SAP Migration Cockpit SAP FI/CO SAP Embedded Analytics LSMW/LTMC Qlik Sence SAP MDM/MDG Redshift/ Oracle for data staging
Volkswagen Financial Services
Brunswick (Germany)
6 Monate
2019-12 - 2020-05

Design and implementation of the methods

Data Analyst Informatica 10.2 (PowerCenter Developer Enterprise Data Catalog ...
Data Analyst
  • 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
Informatica 10.2 (PowerCenter Developer Enterprise Data Catalog Data Quality TDM MX Views) Enterprise Architect/ERWin TOGAF 9.x Oracle 19c Multitenant Microsoft PowerBi Desktop DAX PowerOneBi (according to IBCS rules) GitLab
KKH Hannover
11 Monate
2019-01 - 2019-11

?Decision Service Room ? DSR?

Full Stack Architect Wherescape (3D RED) and SAP Data Services GitLab ...
Full Stack Architect

  • 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

Wherescape (3D RED) and SAP Data Services GitLab PostgresSql IBM AS400/DB2 Data Vault 2.0 TMT OpenShift SAP Analytics Cloud (SAC) Apache Messaging (Kafka) IntelliJ Postman API Keycloak RESTful API Set up of the continuous integration / delivery (CI/CD) methods Atlassian Software (Jira/Confluence)
DB Systel / Z.O.D
Frankfurt/Main, Germany
2 Jahre 11 Monate
2016-02 - 2018-12

various Projects

DWH Architect Informatica 10.2 (Developer Data Quality Transformations and Product Integration) AWS (managed stack) ...
DWH Architect
  • 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

Informatica 10.2 (Developer Data Quality Transformations and Product Integration) AWS (managed stack) Redshift Snowflake (multi cluster) IBM DOORS IBM AS400 UML SAP Hana Studio Talend Open Studio (TOS 7.x) Apache Kafka Streams IntelliJ with Spring Boot Jenkins Swagger SAP Hana Informatica PowerCenter 10.x and MDM Module BMC Remedy Oracle 11c/12 Snowflake DB Scaled Agile Framework 4.x (SAFe)
DB Systel GmbH, Frankfurt/Main, Germany / SwissPost AG, Bern Wankdorf, Switzerland
2 Jahre 10 Monate
2013-03 - 2015-12

Design and development of the data extraction process

Data Architect Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Oracle ODI 12c ...
Data Architect
  • 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.)
Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Oracle ODI 12c Sybase PowerBuilder HP Service Manager 9.34 Scrum Technics Analysis for Office (AfO) Design Studio Data Vault 2.0 Jira (Atlassian)
MunichRe AG
Munich,Germany
5 Monate
2012-10 - 2013-02

"Car Leasing" Project

DWH/ETL Architect SAP Business Objects 4.1 (DeskI Dashboard WebI) ...
DWH/ETL Architect
  • Design of the data download from SAP BW (BODS Extractors, PL/SQL), MAN AG, Munich, Germany
  • Orchestration, tuning and reengineering of existing ETL pipelines (OWB and ODI 12c)
  • Implementation of the business semantic layer (Business Objects Universum) for German Commercial Code (?HGB?)
  • Design, implementation and tests of the standard reports (WebIntelligence, mainly accounting and billing reports)
SAP Business Objects 4.1 (DeskI Dashboard WebI) Business Objects Data Services (BODS) Oracle OWB ODI 12c SAP Bank Analyzer SAP FI Extractors Oracle 12c PL/SQL Data Architect R.Kimball's Star Schema (Data Marts) and Data Vault (Staging Area) shell scripting HP (ALM Quality Center)
MAN AG
Munich
2 Jahre 5 Monate
2010-04 - 2012-08

"SMART" Project SEB /Santander Bank

Consultant ITIL R.Kimball's dimensional modelling UML ...
Consultant
  • 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
ITIL R.Kimball's dimensional modelling UML ErWin PL/SQL Informatica 9.34 Powershell Atlassian (Jira Confluance) Oracle Application Express (APEX) Oracle 10/11c
SEB AG
Frankfurt/Main, Germany
1 Jahr 4 Monate
2009-01 - 2010-04

ETL development

Consultant, ETL Team Leader (5 persons) SAP Business Objects Product Suite BO Data Services SAP RMCA ...
Consultant, ETL Team Leader (5 persons)
  • 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 (cross over the stage and output area), co-working on annual/ quarterly/monthly balance sheets
  • Release management
SAP Business Objects Product Suite BO Data Services SAP RMCA FI ErWin Quest Toad Data Vault MS Project UML Subversion (Apache)
Kabel Deutschland
Munich, Bavaria
9 Monate
2008-04 - 2008-12

DWH Design & Development

Consultant
Consultant
  • 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
Deutsche Buchhandel (Paragondata GmbH)
Frankfurt
2 Jahre
2006-05 - 2008-04

DWH and ETL concept and design

Consultant Business Intelligence XCelsius 2008 Dashboarding BOXI R2 and R3 ...
Consultant Business Intelligence
  • 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)
XCelsius 2008 Dashboarding BOXI R2 and R3 BODI (Data Services) PowerCenter 8.x Erwin ...)
Deutsche Ärzte und Apothekenbank, Düsseldorf, Volkswagen AG
1 Jahr 1 Monat
2005-05 - 2006-05

Prepaid System migration

Senior Consultant OOA /OOD PL/SQL ITIL/Cobit framework implementation ...
Senior Consultant
  • 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
OOA /OOD PL/SQL ITIL/Cobit framework implementation Quality Assurance Sicap PPC5.1 Prepaid System Distributed Software Development Outsourcing Coordination
CapGemini Germany
2 Jahre 5 Monate
2003-01 - 2005-05

Kenan/BP migration strategy

Team Leader Online Development SQL PL/SQL C++
Team Leader Online Development
  • 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.
SQL PL/SQL C++
EDS Deutschland GmbH
1 Jahr 4 Monate
2001-09 - 2002-12

Customising & optimize of the PowerMart entities

Health Care Austrian: Sr. Software Architect PowerMart J2EE BEA Software ...
Health Care Austrian: Sr. Software Architect
  • 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
PowerMart J2EE BEA Software SSL & Distributed Systems XML
EDS Deutschland GmbH
11 Monate
2000-11 - 2001-09

Migration from BSCS5.21 to MCBS

Migration Team Leader, Mobile Communication Service Provider Oracle 8x Unix SQL ...
Migration Team Leader, Mobile Communication Service Provider
  • 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
Oracle 8x Unix SQL PL/SQL PowerMart ERWIN MS Project
EDS Deutschland GmbH
6 Monate
2000-06 - 2000-11

Co-operation & coaching

Project Leader, Migration of a International Service Provider Oracle 7.34 SunSolaris C++ ...
Project Leader, Migration of a International Service Provider
  • 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
Oracle 7.34 SunSolaris C++ Embeded C COCOMO II
EDS Deutschland GmbH
6 Monate
1999-08 - 2000-01

Responsible for the Change Request Management

MS Project Vantive PVCS ...
  • 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
MS Project Vantive PVCS Workflow Management System
EDS Deutschland GmbH
2 Jahre 8 Monate
1997-01 - 1999-08

Designed the System Upgrade Strategy

Software Engineer Sybase & Oracle 7.34 SQL PL/SQL ...
Software Engineer
  • 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.
Sybase & Oracle 7.34 SQL PL/SQL C/C++ Centura
LHS Group
Hessen, Frankfurt am Main
1 Jahr 1 Monat
1996-01 - 1997-01

Developed & integrated Dynamic Linking Librarys

Freelance Computer Consultant Centura C/C++ native interfaces ...
Freelance Computer Consultant
  • 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
Centura C/C++ native interfaces Java JavaScript HTML 3.0 Netscape  Centura Access and Visual Basic
GodeSYS GmbH, Mainz, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 1 Monat
2002-09 - 2004-09

McComb School of Business (Austin,Texas, USA)

Master of Business Administration, Johannes Gutenberg Universität Mainz (Germany)
Master of Business Administration
Johannes Gutenberg Universität Mainz (Germany)

  • Strategic Management

4 Jahre
1992-10 - 1996-09

Study of Computer Science

BS in Computer Science, Technical University Darmstadt, Darmstadt, Hessen, Germany
BS in Computer Science
Technical University Darmstadt, Darmstadt, Hessen, Germany
  • Business Intelligence
  • Data Modelling
  • Distributed Systems
  • Project Management

Position

Position


Kompetenzen

Kompetenzen

Top-Skills

Data Vault 2.0 DWH mit ETL (Wherescape-dbt-Talend-BODS) Umsetzung der Regulatorik (DSGVO-DORA-NIS2) backend-frontend) Anforderungsmanagement/Analyse Wherescape (3D, RED) Informatica PowerCenter - Developer - MDM SAP BO 4.x (IDT - DesignStudio - WebI, Crystal, Universe) ETL/ELT (SAP BODI, BODS, Informatica, Talend TOS) DWH (3NF, Dimensional, Snowflake, DataVault 2.0) Billing- und Ratingsysteme (Ericson BSCS-iX, Kenan FX) Architekturmanagement (SPARX Enterprise Architect, ERWin) Businessintelligence, Reporting und Dashboards (PowerBi, QlickSence, Lumira, SAP WebI) Java 2 EE (RESTfull API, SpringBoot, Swagger/Postman clients, Keyclock, GitLab, SVN) Amazon Webservices (RDS, S3, EC3, Lambda, DevOps, CloudWatch, CloudFormation) PostgreSQL - Oracle - Multitenant - MariaDB - MS SQL Server - AWS Redshift Snowflake (incl.snowpipes) dbt (dbtvault) SAP MDM MM PM PI FI CO Hana Regulatorik -DSGVO MiFID II MIFIR AWS MS Azure (Fabric...) Atlassian Software und agile Methoden (SCRUM SAFe Jira Confluence Kanban ...) SAP Analytics for Cloud (SAC) und Datasphere SAP Migration (conversion analyse - simplification objects - mappings)

Schwerpunkte

Business Intelligence
Experte
DWH Architektur
Experte
ETL/ELT
Experte
Finanzwesen
Fortgeschritten
(SAP) Migrationen
Experte
Frondend (PowerBI, Qlik*, Grafana...)
Experte
SQL/NonSQL Database
Experte
Complience Management - Regulatorik - ITIL (4)
Experte

Produkte / Standards / Erfahrungen / Methoden

BSCS/Kenan FX
Sehr gut
Crystal Reports
Experte
ErWin
Experte
HP Quality Center
Experte
Informatica PowerCenter
Experte
Jira (Atlassian)
Kenan Arbor FX
LiveOffice
PowerBi (PowerOn BI)
Experte in "Customer Visuals"
SAP BO Xcelsius
SAP BusinessObjects
BOXI 3.x BOXI 4.x,
SAP BusinessObjects Data Services
SAP BusinessObjects Design Studio
SAP LCM
SAP MM
Universe Designer
Universum Designer
WebIntelligence
SAP Powerdesigner
Experte
System Life Cycle SLC 3
Practice
DevOps
Practice
OpenAPI
Practice
Netbeans, IntelliJ IDEA
Experte
Visual Studio Code
JBuilder
ETL/ELT: Informatica PowerCenter/Developer/DQ/TDM
Experte
Oracle OWB /ODI 12c
Practice
SAP BODI/BODS
Experte
Theobald
Basics
Matilion
Basics
Apache Airflow 2.1x
Practice
Talend TOS
Experte
Master Data Management (Informatica MDM)
TestDataManagement(TDM), Data Quality(DQ)
Product360
Product Integration
Data Steward
frameworks: SAP Operational Data Provisioning, ODP
Practice
SAP FI/CO PI, PO
Practice
SAP ERP Central Component (ECC)
Practice
Ariba
Basics
SAP Analytics for Cloud - SAC
Experte
SAP Analytics for Office AfO
Experte
SAP Integration/Orchestration (PI PO)
Practice
Fiori, SAP Fieldglass
Practice
LSMW (Legacy System Migration Workbench)
Experte
SAP SuccessFactors
Basics
SAP MM/IM
Experte
SAP FI/CO
Practice
LE/WM
Practice
MDG
Experte
PowerBi/DAX
Practice
SAP Embedded Analytics - SAC
Practice
SAP Datasphere
Practice
LSMW
Practice
Tableau
Basics
Grafana
Practice
Qlik View / Sence
Basics
Enterprise Architect (EA)
(Sybase) PowerDesigner
TOGAF
IBCS (International Business Communication Standard)
RationalRose
Practice
IBM Process Mining
Practice
IBM DOORS
Experte
Regulatory requirements/frameworks:DSG
Experte
BAIT
Practice
MA Risk
Practice
DORA
Practice
TOAD
Experte
dbt /dbtvault
Experte
BPMN
Practice
PowerDesigner
Experte
ArchiMate
Practice
BPMN 2.0 tools
Experte
Enterprise Architect
Experte
REST /RESTful interface
Practice
SOAP (soapi)
Practice
Insomnia
Experte
UML
Practice
Innovator
Experte
Security and compliance standards (RBAC, GDPR, HIPAA..)
Basics
Citrix app (Workspace?)
Practice
Atlassian Software (Jira, Confluence)
Experte
SharePoint
Experte
MS Azure (Databricks)
Practice
Platform Services
Practice
RedHad OpenShift
Practice
GitHub, GitLab, DevOps
Experte
AWS Stack (Lambda, S3, IAM...)
Practice
VMware, Docker
Experte
AladdinConnectors
Practice

Betriebssysteme

HPUX
Gut
IBM 4680
Lynx
MS-DOS
OSF/Motif
SUN OS, Solaris
Sehr gut
Unix
Experte
Windows
NT/2000/XP/CE
Windows Server
MS Azure Cloud Services (Databrics, Analytics, Fabric, OpenShift, Data Factory, DevOps,..)
Experte
Linux (div. Derivates)
Docker
VM
Experte
IBM AS400
Practice
SAP Cloud Integration /Suite, IpaaS
Practice
SAP Public Cloud Plattform
Practice

Programmiersprachen

C
C++
Experte
Centura
Emacs
Gupta, Centura
Experte
J2EE & Java
JavaScript
PL/SQL
Experte
Python/PySpark
Practice
R Shiny
Practice
Shell
Guru
UML
ABAP OO
Experte
TSQL
Experte
Lua
Practice
PowerShell
Experte

Datenbanken

Access
OK
amazon-Redshift
Experte
DB/400
Fortgeschritten
DB2
Practice
Informix
Practice
Lotus Notes
OK
MariaDB
Practice
MS SQL Server
Sehr gut
ODBC /JDBC
Experte
Oracle
7.34 bis 19c in AWS, Expert
PostgreSql/EDB
Experte
Quest
Sehr gut
Regulatorik
Guru
Sybase
Practice
Snowflake
Experte
AWS Redshift
Practice
Exasol V7
Basics
MSSQL
Experte
Oracle Multitenant 19c
Experte
MaxDB
Practice
SAP S/4 HANA & CDS Views
Experte
InfluxDB
Practice
Snowflake und Co
Experte

Datenkommunikation

CORBA
Ethernet
Internet, Intranet
ISDN
Kafka
LAN, LAN Manager
Novell
REST
Router
TCP/IP
TIP
Winsock

Hardware

AS/400
Echtzeitsysteme
embedded Systeme
Emulatoren
HP
IBM Großrechner
IBM RS6000
Macintosh
Nixdorf
Rational
Siemens Großrechner
Silicon-Graphics
SPARC
SUN
Teradata

Berechnung / Simulation / Versuch / Validierung

TestDirector
WinRunner

Design / Entwicklung / Konstruktion

Big Data
Sehr gut
Data Vault 2.0
Experte
DWH Design
Sehr gut
Hub&Spoke
Experte
Informatica 9.34, MDM, DQ, PIM
Experte
ITIL
"Service Management"
Kimball
Experte
TOGAF
Gut

Branchen

Branchen

  • FinTech -Finanzen und (Rück) Versicherungen
  • Logistik (DB Bahn, Lufthansa)
  • Telco
  • Billing-Rating branchenübergreifend
  • SAP -nonSAP Migrationen (übergreifend)
  • (Technisches) Project Management

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz

Schweiz: Zürich

nicht möglich

Projekte

Projekte

1 Jahr 7 Monate
2023-11 - heute

Design and refactoring of logical and physical data model

Data Engineer / DWH Designer / Data Architect Innovator 15.2 SAP Hana Studio SAP Datasphere ...
Data Engineer / DWH Designer / Data Architect
  • 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
Innovator 15.2 SAP Hana Studio SAP Datasphere SAP Hana (incl. CDS/CS Views) HDBSQL NIS2UmsuCG Salesforce Jira/SCRAM CICD methods GitHub Apache Airflow Python 3.x SAP Fieldglass SQL/PLSQL
BG Phoenics
Hannover, Germany
8 Monate
2023-03 - 2023-10

New data objects integration

DEVOps/ ETL/ELT Developer Wherescape (RED BLUE) ParTcl ...
DEVOps/ ETL/ELT Developer
  • 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
Wherescape (RED BLUE) ParTcl Computer System Validation (CSV) guidelines MS SQL OpenShift MS Azure DevOps ?Digital Operational Resilience Act? ? DORA SAP FI/CO Fiori SAP S/4Hana SAP Powerdesigner / ArchiMate SQL/TSQL SAP LSMW SAP DS 4.3 MLOps Pipes GitHub
Zurich Insurance Group AG
Zürich (Switzerland)
2 Jahre
2021-04 - 2023-03

Active DataWarehouse

DWH Migration Developer AS400 DB2 and Oracle 19c Enterprise Edition SAP FI/CO (IDocs) SAP Data Services 4.x ...
DWH Migration Developer
  • 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
AS400 DB2 and Oracle 19c Enterprise Edition SAP FI/CO (IDocs) SAP Data Services 4.x SQL/PLSQL Quest's Toad Toad for DB2 Snowflake and Snowpipe dbt (data-base-tool) with dbtvault plugin Docker Desktop IntelliJ IDEA DevOps CI/CD pipelines inside of ML frameworks GitLab Grafana Atlassian Software (Jira Confluence)
PostFinance AG
Bern (Switzerland)
11 Monate
2020-05 - 2021-03

several data migration projects

SAP Data Migration Architect / Data Migration Developer Informatica PowerCenter 10.2 (with idocs interface TDM and QM) SAP Migration Cockpit ...
SAP Data Migration Architect / Data Migration Developer
  • 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
Informatica PowerCenter 10.2 (with idocs interface TDM and QM) SAP Migration Cockpit SAP FI/CO SAP Embedded Analytics LSMW/LTMC Qlik Sence SAP MDM/MDG Redshift/ Oracle for data staging
Volkswagen Financial Services
Brunswick (Germany)
6 Monate
2019-12 - 2020-05

Design and implementation of the methods

Data Analyst Informatica 10.2 (PowerCenter Developer Enterprise Data Catalog ...
Data Analyst
  • 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
Informatica 10.2 (PowerCenter Developer Enterprise Data Catalog Data Quality TDM MX Views) Enterprise Architect/ERWin TOGAF 9.x Oracle 19c Multitenant Microsoft PowerBi Desktop DAX PowerOneBi (according to IBCS rules) GitLab
KKH Hannover
11 Monate
2019-01 - 2019-11

?Decision Service Room ? DSR?

Full Stack Architect Wherescape (3D RED) and SAP Data Services GitLab ...
Full Stack Architect

  • 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

Wherescape (3D RED) and SAP Data Services GitLab PostgresSql IBM AS400/DB2 Data Vault 2.0 TMT OpenShift SAP Analytics Cloud (SAC) Apache Messaging (Kafka) IntelliJ Postman API Keycloak RESTful API Set up of the continuous integration / delivery (CI/CD) methods Atlassian Software (Jira/Confluence)
DB Systel / Z.O.D
Frankfurt/Main, Germany
2 Jahre 11 Monate
2016-02 - 2018-12

various Projects

DWH Architect Informatica 10.2 (Developer Data Quality Transformations and Product Integration) AWS (managed stack) ...
DWH Architect
  • 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

Informatica 10.2 (Developer Data Quality Transformations and Product Integration) AWS (managed stack) Redshift Snowflake (multi cluster) IBM DOORS IBM AS400 UML SAP Hana Studio Talend Open Studio (TOS 7.x) Apache Kafka Streams IntelliJ with Spring Boot Jenkins Swagger SAP Hana Informatica PowerCenter 10.x and MDM Module BMC Remedy Oracle 11c/12 Snowflake DB Scaled Agile Framework 4.x (SAFe)
DB Systel GmbH, Frankfurt/Main, Germany / SwissPost AG, Bern Wankdorf, Switzerland
2 Jahre 10 Monate
2013-03 - 2015-12

Design and development of the data extraction process

Data Architect Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Oracle ODI 12c ...
Data Architect
  • 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.)
Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Oracle ODI 12c Sybase PowerBuilder HP Service Manager 9.34 Scrum Technics Analysis for Office (AfO) Design Studio Data Vault 2.0 Jira (Atlassian)
MunichRe AG
Munich,Germany
5 Monate
2012-10 - 2013-02

"Car Leasing" Project

DWH/ETL Architect SAP Business Objects 4.1 (DeskI Dashboard WebI) ...
DWH/ETL Architect
  • Design of the data download from SAP BW (BODS Extractors, PL/SQL), MAN AG, Munich, Germany
  • Orchestration, tuning and reengineering of existing ETL pipelines (OWB and ODI 12c)
  • Implementation of the business semantic layer (Business Objects Universum) for German Commercial Code (?HGB?)
  • Design, implementation and tests of the standard reports (WebIntelligence, mainly accounting and billing reports)
SAP Business Objects 4.1 (DeskI Dashboard WebI) Business Objects Data Services (BODS) Oracle OWB ODI 12c SAP Bank Analyzer SAP FI Extractors Oracle 12c PL/SQL Data Architect R.Kimball's Star Schema (Data Marts) and Data Vault (Staging Area) shell scripting HP (ALM Quality Center)
MAN AG
Munich
2 Jahre 5 Monate
2010-04 - 2012-08

"SMART" Project SEB /Santander Bank

Consultant ITIL R.Kimball's dimensional modelling UML ...
Consultant
  • 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
ITIL R.Kimball's dimensional modelling UML ErWin PL/SQL Informatica 9.34 Powershell Atlassian (Jira Confluance) Oracle Application Express (APEX) Oracle 10/11c
SEB AG
Frankfurt/Main, Germany
1 Jahr 4 Monate
2009-01 - 2010-04

ETL development

Consultant, ETL Team Leader (5 persons) SAP Business Objects Product Suite BO Data Services SAP RMCA ...
Consultant, ETL Team Leader (5 persons)
  • 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 (cross over the stage and output area), co-working on annual/ quarterly/monthly balance sheets
  • Release management
SAP Business Objects Product Suite BO Data Services SAP RMCA FI ErWin Quest Toad Data Vault MS Project UML Subversion (Apache)
Kabel Deutschland
Munich, Bavaria
9 Monate
2008-04 - 2008-12

DWH Design & Development

Consultant
Consultant
  • 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
Deutsche Buchhandel (Paragondata GmbH)
Frankfurt
2 Jahre
2006-05 - 2008-04

DWH and ETL concept and design

Consultant Business Intelligence XCelsius 2008 Dashboarding BOXI R2 and R3 ...
Consultant Business Intelligence
  • 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)
XCelsius 2008 Dashboarding BOXI R2 and R3 BODI (Data Services) PowerCenter 8.x Erwin ...)
Deutsche Ärzte und Apothekenbank, Düsseldorf, Volkswagen AG
1 Jahr 1 Monat
2005-05 - 2006-05

Prepaid System migration

Senior Consultant OOA /OOD PL/SQL ITIL/Cobit framework implementation ...
Senior Consultant
  • 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
OOA /OOD PL/SQL ITIL/Cobit framework implementation Quality Assurance Sicap PPC5.1 Prepaid System Distributed Software Development Outsourcing Coordination
CapGemini Germany
2 Jahre 5 Monate
2003-01 - 2005-05

Kenan/BP migration strategy

Team Leader Online Development SQL PL/SQL C++
Team Leader Online Development
  • 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.
SQL PL/SQL C++
EDS Deutschland GmbH
1 Jahr 4 Monate
2001-09 - 2002-12

Customising & optimize of the PowerMart entities

Health Care Austrian: Sr. Software Architect PowerMart J2EE BEA Software ...
Health Care Austrian: Sr. Software Architect
  • 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
PowerMart J2EE BEA Software SSL & Distributed Systems XML
EDS Deutschland GmbH
11 Monate
2000-11 - 2001-09

Migration from BSCS5.21 to MCBS

Migration Team Leader, Mobile Communication Service Provider Oracle 8x Unix SQL ...
Migration Team Leader, Mobile Communication Service Provider
  • 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
Oracle 8x Unix SQL PL/SQL PowerMart ERWIN MS Project
EDS Deutschland GmbH
6 Monate
2000-06 - 2000-11

Co-operation & coaching

Project Leader, Migration of a International Service Provider Oracle 7.34 SunSolaris C++ ...
Project Leader, Migration of a International Service Provider
  • 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
Oracle 7.34 SunSolaris C++ Embeded C COCOMO II
EDS Deutschland GmbH
6 Monate
1999-08 - 2000-01

Responsible for the Change Request Management

MS Project Vantive PVCS ...
  • 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
MS Project Vantive PVCS Workflow Management System
EDS Deutschland GmbH
2 Jahre 8 Monate
1997-01 - 1999-08

Designed the System Upgrade Strategy

Software Engineer Sybase & Oracle 7.34 SQL PL/SQL ...
Software Engineer
  • 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.
Sybase & Oracle 7.34 SQL PL/SQL C/C++ Centura
LHS Group
Hessen, Frankfurt am Main
1 Jahr 1 Monat
1996-01 - 1997-01

Developed & integrated Dynamic Linking Librarys

Freelance Computer Consultant Centura C/C++ native interfaces ...
Freelance Computer Consultant
  • 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
Centura C/C++ native interfaces Java JavaScript HTML 3.0 Netscape  Centura Access and Visual Basic
GodeSYS GmbH, Mainz, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2 Jahre 1 Monat
2002-09 - 2004-09

McComb School of Business (Austin,Texas, USA)

Master of Business Administration, Johannes Gutenberg Universität Mainz (Germany)
Master of Business Administration
Johannes Gutenberg Universität Mainz (Germany)

  • Strategic Management

4 Jahre
1992-10 - 1996-09

Study of Computer Science

BS in Computer Science, Technical University Darmstadt, Darmstadt, Hessen, Germany
BS in Computer Science
Technical University Darmstadt, Darmstadt, Hessen, Germany
  • Business Intelligence
  • Data Modelling
  • Distributed Systems
  • Project Management

Position

Position


Kompetenzen

Kompetenzen

Top-Skills

Data Vault 2.0 DWH mit ETL (Wherescape-dbt-Talend-BODS) Umsetzung der Regulatorik (DSGVO-DORA-NIS2) backend-frontend) Anforderungsmanagement/Analyse Wherescape (3D, RED) Informatica PowerCenter - Developer - MDM SAP BO 4.x (IDT - DesignStudio - WebI, Crystal, Universe) ETL/ELT (SAP BODI, BODS, Informatica, Talend TOS) DWH (3NF, Dimensional, Snowflake, DataVault 2.0) Billing- und Ratingsysteme (Ericson BSCS-iX, Kenan FX) Architekturmanagement (SPARX Enterprise Architect, ERWin) Businessintelligence, Reporting und Dashboards (PowerBi, QlickSence, Lumira, SAP WebI) Java 2 EE (RESTfull API, SpringBoot, Swagger/Postman clients, Keyclock, GitLab, SVN) Amazon Webservices (RDS, S3, EC3, Lambda, DevOps, CloudWatch, CloudFormation) PostgreSQL - Oracle - Multitenant - MariaDB - MS SQL Server - AWS Redshift Snowflake (incl.snowpipes) dbt (dbtvault) SAP MDM MM PM PI FI CO Hana Regulatorik -DSGVO MiFID II MIFIR AWS MS Azure (Fabric...) Atlassian Software und agile Methoden (SCRUM SAFe Jira Confluence Kanban ...) SAP Analytics for Cloud (SAC) und Datasphere SAP Migration (conversion analyse - simplification objects - mappings)

Schwerpunkte

Business Intelligence
Experte
DWH Architektur
Experte
ETL/ELT
Experte
Finanzwesen
Fortgeschritten
(SAP) Migrationen
Experte
Frondend (PowerBI, Qlik*, Grafana...)
Experte
SQL/NonSQL Database
Experte
Complience Management - Regulatorik - ITIL (4)
Experte

Produkte / Standards / Erfahrungen / Methoden

BSCS/Kenan FX
Sehr gut
Crystal Reports
Experte
ErWin
Experte
HP Quality Center
Experte
Informatica PowerCenter
Experte
Jira (Atlassian)
Kenan Arbor FX
LiveOffice
PowerBi (PowerOn BI)
Experte in "Customer Visuals"
SAP BO Xcelsius
SAP BusinessObjects
BOXI 3.x BOXI 4.x,
SAP BusinessObjects Data Services
SAP BusinessObjects Design Studio
SAP LCM
SAP MM
Universe Designer
Universum Designer
WebIntelligence
SAP Powerdesigner
Experte
System Life Cycle SLC 3
Practice
DevOps
Practice
OpenAPI
Practice
Netbeans, IntelliJ IDEA
Experte
Visual Studio Code
JBuilder
ETL/ELT: Informatica PowerCenter/Developer/DQ/TDM
Experte
Oracle OWB /ODI 12c
Practice
SAP BODI/BODS
Experte
Theobald
Basics
Matilion
Basics
Apache Airflow 2.1x
Practice
Talend TOS
Experte
Master Data Management (Informatica MDM)
TestDataManagement(TDM), Data Quality(DQ)
Product360
Product Integration
Data Steward
frameworks: SAP Operational Data Provisioning, ODP
Practice
SAP FI/CO PI, PO
Practice
SAP ERP Central Component (ECC)
Practice
Ariba
Basics
SAP Analytics for Cloud - SAC
Experte
SAP Analytics for Office AfO
Experte
SAP Integration/Orchestration (PI PO)
Practice
Fiori, SAP Fieldglass
Practice
LSMW (Legacy System Migration Workbench)
Experte
SAP SuccessFactors
Basics
SAP MM/IM
Experte
SAP FI/CO
Practice
LE/WM
Practice
MDG
Experte
PowerBi/DAX
Practice
SAP Embedded Analytics - SAC
Practice
SAP Datasphere
Practice
LSMW
Practice
Tableau
Basics
Grafana
Practice
Qlik View / Sence
Basics
Enterprise Architect (EA)
(Sybase) PowerDesigner
TOGAF
IBCS (International Business Communication Standard)
RationalRose
Practice
IBM Process Mining
Practice
IBM DOORS
Experte
Regulatory requirements/frameworks:DSG
Experte
BAIT
Practice
MA Risk
Practice
DORA
Practice
TOAD
Experte
dbt /dbtvault
Experte
BPMN
Practice
PowerDesigner
Experte
ArchiMate
Practice
BPMN 2.0 tools
Experte
Enterprise Architect
Experte
REST /RESTful interface
Practice
SOAP (soapi)
Practice
Insomnia
Experte
UML
Practice
Innovator
Experte
Security and compliance standards (RBAC, GDPR, HIPAA..)
Basics
Citrix app (Workspace?)
Practice
Atlassian Software (Jira, Confluence)
Experte
SharePoint
Experte
MS Azure (Databricks)
Practice
Platform Services
Practice
RedHad OpenShift
Practice
GitHub, GitLab, DevOps
Experte
AWS Stack (Lambda, S3, IAM...)
Practice
VMware, Docker
Experte
AladdinConnectors
Practice

Betriebssysteme

HPUX
Gut
IBM 4680
Lynx
MS-DOS
OSF/Motif
SUN OS, Solaris
Sehr gut
Unix
Experte
Windows
NT/2000/XP/CE
Windows Server
MS Azure Cloud Services (Databrics, Analytics, Fabric, OpenShift, Data Factory, DevOps,..)
Experte
Linux (div. Derivates)
Docker
VM
Experte
IBM AS400
Practice
SAP Cloud Integration /Suite, IpaaS
Practice
SAP Public Cloud Plattform
Practice

Programmiersprachen

C
C++
Experte
Centura
Emacs
Gupta, Centura
Experte
J2EE & Java
JavaScript
PL/SQL
Experte
Python/PySpark
Practice
R Shiny
Practice
Shell
Guru
UML
ABAP OO
Experte
TSQL
Experte
Lua
Practice
PowerShell
Experte

Datenbanken

Access
OK
amazon-Redshift
Experte
DB/400
Fortgeschritten
DB2
Practice
Informix
Practice
Lotus Notes
OK
MariaDB
Practice
MS SQL Server
Sehr gut
ODBC /JDBC
Experte
Oracle
7.34 bis 19c in AWS, Expert
PostgreSql/EDB
Experte
Quest
Sehr gut
Regulatorik
Guru
Sybase
Practice
Snowflake
Experte
AWS Redshift
Practice
Exasol V7
Basics
MSSQL
Experte
Oracle Multitenant 19c
Experte
MaxDB
Practice
SAP S/4 HANA & CDS Views
Experte
InfluxDB
Practice
Snowflake und Co
Experte

Datenkommunikation

CORBA
Ethernet
Internet, Intranet
ISDN
Kafka
LAN, LAN Manager
Novell
REST
Router
TCP/IP
TIP
Winsock

Hardware

AS/400
Echtzeitsysteme
embedded Systeme
Emulatoren
HP
IBM Großrechner
IBM RS6000
Macintosh
Nixdorf
Rational
Siemens Großrechner
Silicon-Graphics
SPARC
SUN
Teradata

Berechnung / Simulation / Versuch / Validierung

TestDirector
WinRunner

Design / Entwicklung / Konstruktion

Big Data
Sehr gut
Data Vault 2.0
Experte
DWH Design
Sehr gut
Hub&Spoke
Experte
Informatica 9.34, MDM, DQ, PIM
Experte
ITIL
"Service Management"
Kimball
Experte
TOGAF
Gut

Branchen

Branchen

  • FinTech -Finanzen und (Rück) Versicherungen
  • Logistik (DB Bahn, Lufthansa)
  • Telco
  • Billing-Rating branchenübergreifend
  • SAP -nonSAP Migrationen (übergreifend)
  • (Technisches) Project Management

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.