Business Intelligence- und Data Warehouse Architekt, Integration- und Datenqualitätsexperte, Technicher Projektleiter und Anforderungsmanager.
Aktualisiert am 14.02.2024
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 04.03.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Data Vault 2.0
ETL (Informatica, Talend, BODS...)
Data Warehouse (DWH)
SAP HANA
DSGVO
Anforderungsmanagement/Analyse
SAP Anylytics for Cloud (SAC)
Wherescape (3D, RED)
Atlassian Software (Jira, Confluence)
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)
SCRUM und agile Entwicklungsmethoden
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
AWS OpsWorks
Snowflake (incl.snowpipes)
dbt (dbtvault)
english
Practice
german
fluent
polish
mother tongue
russian
Basics

Einsatzorte

Deutschland, Österreich, Schweiz

Schweiz: Zürich

nicht möglich

Projekte

6 Jahre 11 Monate
2017-03 - heute

Several migration projects

Self-employed DWH Architect
Self-employed DWH Architect
  • 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
Informatica 10.2 (Developer Tool) AWS (DevOps; GitLab) Redshift MariaDB PostgresSql Talend Open Studio (TOS) IntelliJ with Spring Boot Jenkins Swagger
DB Systel GmbH
Frankfurt/Main, Germany
1 Jahr 2 Monate
2016-01 - 2017-02

Online shop interface

Self-employed Business Intelligence Architect Informatica PowerCenter 9.2 Oracle 11c/12 SAP MM
Self-employed Business Intelligence Architect
  • 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
Informatica PowerCenter 9.2 Oracle 11c/12 SAP MM
Die Schweizerische Post
Kanton Bern, Switzerland
2 Jahre 10 Monate
2013-03 - 2015-12

Design & development

Self-emeployed Data Architect Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Sybase PowerBuilder ...
Self-emeployed 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 (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)
Business Objects Data Services (BODS) Informatica's PowerCenter 9.5 Sybase PowerBuilder HP Service Manager 9.34 Scrum Technics SAP BO 4.2 SP1: Analysis for Office Design Studio Data Vault 2.0 Jira (Atlassian) SAP Business Objects 4.2 WebIntelligence Lumira Universe Designer IDT etc.
MunichRe AG
Munich,Germany
5 Monate
2012-10 - 2013-02

"Car Leasing" Project

DWH/ETL Architect Business Objects Data Services (BODS) WebIntelligence Oracle 11g ...
DWH/ETL Architect
  • 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)
Business Objects Data Services (BODS) WebIntelligence Oracle 11g PL/SQL Data Architect R.Kimball's Star Schema (Data Marts) and Data Vault (Staging Area) SAP Business Objects 4.1 DeskI Dashboard WebI
MAN AG
Munich
2 Jahre 5 Monate
2010-04 - 2012-08

"SMART" Project SEB /Santander Bank

Self-employed Consultant R.Kimball's dimensional modelling UML ErWin ...
Self-employed 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
R.Kimball's dimensional modelling UML ErWin PL/SQL Informatica 9.34 Oracler Row Level Security ITIL Regulatorik
SEB AG
Frankfurt/Main, Germany
1 Jahr 4 Monate
2009-01 - 2010-04

ETL development

Self-employed Consultant, ETL Team Leader (5 persons) SAP Business Objects Product Suite BO Data Services SAP RMCA ...
Self-employed 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 ( stage and output area), population of Hub / Satelite entities
  • 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

Self-employed Consultant
Self-employed 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, Germany
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

TP S.A. Poland - Team Leader Online Development SQL PL/SQL C++
TP S.A. Poland - 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

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
  • Telecommunication
  • Client/Server Systems
  • Project Management

Position

Regulatorik (fachlich und funktional): DSGVO, CSRD

Cloud (AWS) Architekt

Rechtlinien der Computer System Validation (CSV)

ELT/ETL Architekt / Developer

AWS Migrationsexperte

DWH Architekt und Modellierer

Anforderungsmanager

Data Scientist (frontend/backend)

Migrationsstrategie und Umsetzung (R/3 nach SAP4Hana)

Kompetenzen

Top-Skills

Data Vault 2.0 ETL (Informatica, Talend, BODS...) Data Warehouse (DWH) SAP HANA DSGVO Anforderungsmanagement/Analyse SAP Anylytics for Cloud (SAC) Wherescape (3D, RED) Atlassian Software (Jira, Confluence) 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) SCRUM und agile Entwicklungsmethoden 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 AWS OpsWorks Snowflake (incl.snowpipes) dbt (dbtvault)

Schwerpunkte

Business Intelligence
Experte
DWH Architektur
Experte
ETL/ELT
Experte
Finanzwesen
Fortgeschritten
(SAP) Migrationen
Experte
Frondend (PowerBI, Qlik*, Grafana...)
Experte
SQL/NonSQL Database
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

Betriebssysteme

HPUX
Gut
IBM 4680
Lynx
MS-DOS
OSF/Motif
SUN OS, Solaris
Sehr gut
Unix
Sehr gut
Windows
NT/2000/XP/CE

Programmiersprachen

C
C++
Experte
Centura
Emacs
Gupta, Centura
Experte
J2EE & Java
JavaScript
PL/SQL
Guru
Python
Experte
R
Experte
Shell
Guru
UML

Datenbanken

Access
OK
amazon-Redshift
Experte
DB/400
OK
DB2
Fortgeschritten
Informix
OK
Lotus Notes
OK
MariaDB
Experte
MS SQL Server
Sehr gut
ODBC /JDBC
Experte
Oracle
7.34 bis 19c in AWS, Multitenant
PostgreSQL
Guru
Quest
Sehr gut
Regulatorik
Guru
Sybase
Guru
Snowflake
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

  • Business Intelligence
  • Finanzen und (Rück) Versicherungen
  • ETL
  • DWH 
  • Billing Rating 
  • Migration 
  • Reporting 
  • SAP BI/BO, SAP BO IX3x, 4x
  • Project Management
  • telecommunication

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

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

Das GULP Freelancer-Portal

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