a Randstad company

Business Intelligence- und Data Warehouse Architekt, Integration- und Datenqualitätsexperte, Technicher Projektleiter und Anforderungsmanager.

Profil
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)
Verfügbar ab
04.12.2022
Aktuell verfügbar - Der Experte steht für neue Projektangebote zur Verfügung.
Verfügbar zu
100%
davon vor Ort
100%
Einsatzorte

PLZ-Gebiete
Länder
Ganz Deutschland, Österreich, Schweiz

Deutschland: Gerne Frankfurt oder Rhein-Main

Remote-Arbeit
Nicht möglich
Art des Profiles
Freiberufler / Selbstständiger
Der Experte ist als Einzelperson freiberuflich oder selbstständig tätig.

5 Jahre 9 Monate

2017-03

heute

Several migration projects

Self-employed DWH Architect
Rolle
Self-employed DWH Architect
Projektinhalte
  • 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
Produkte
Informatica 10.2 (Developer Tool) AWS (DevOps; GitLab) Redshift MariaDB PostgresSql Talend Open Studio (TOS) IntelliJ with Spring Boot Jenkins Swagger
Kunde
DB Systel GmbH
Einsatzort
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
Rolle
Self-employed Business Intelligence Architect
Projektinhalte
  • 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
Kenntnisse
Informatica PowerCenter 9.2 Oracle 11c/12 SAP MM
Kunde
Die Schweizerische Post
Einsatzort
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 ...
Rolle
Self-emeployed Data Architect
Projektinhalte
  • 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)
Kenntnisse
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.
Kunde
MunichRe AG
Einsatzort
Munich,Germany
5 Monate

2012-10

2013-02

"Car Leasing" Project

DWH/ETL Architect Business Objects Data Services (BODS) WebIntelligence Oracle 11g ...
Rolle
DWH/ETL Architect
Projektinhalte
  • 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)
Kenntnisse
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
Kunde
MAN AG
Einsatzort
Munich
2 Jahre 5 Monate

2010-04

2012-08

"SMART" Project SEB /Santander Bank

Self-employed Consultant R.Kimball's dimensional modelling UML ErWin ...
Rolle
Self-employed Consultant
Projektinhalte
  • 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
Kenntnisse
R.Kimball's dimensional modelling UML ErWin PL/SQL Informatica 9.34 Oracler Row Level Security ITIL Regulatorik
Kunde
SEB AG
Einsatzort
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 ...
Rolle
Self-employed Consultant, ETL Team Leader (5 persons)
Projektinhalte
  • 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
Kenntnisse
SAP Business Objects Product Suite BO Data Services SAP RMCA FI ErWin Quest Toad Data Vault MS Project UML Subversion (Apache)
Kunde
Kabel Deutschland
Einsatzort
Munich, Bavaria
9 Monate

2008-04

2008-12

DWH Design & Development

Self-employed Consultant
Rolle
Self-employed Consultant
Projektinhalte
  • 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
Kunde
Deutsche Buchhandel (Paragondata GmbH)
Einsatzort
Frankfurt
2 Jahre

2006-05

2008-04

DWH and ETL concept and design

Consultant Business Intelligence XCelsius 2008 Dashboarding BOXI R2 and R3 ...
Rolle
Consultant Business Intelligence
Projektinhalte
  • 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)
Kenntnisse
XCelsius 2008 Dashboarding BOXI R2 and R3 BODI (Data Services) PowerCenter 8.x Erwin ...)
Kunde
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 ...
Rolle
Senior Consultant
Projektinhalte
  • 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
Kenntnisse
OOA /OOD PL/SQL ITIL/Cobit framework implementation Quality Assurance Sicap PPC5.1 Prepaid System Distributed Software Development Outsourcing Coordination
Kunde
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++
Rolle
TP S.A. Poland - Team Leader Online Development
Projektinhalte
  • 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.
Kenntnisse
SQL PL/SQL C++
Kunde
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 ...
Rolle
Health Care Austrian: Sr. Software Architect
Projektinhalte
  • 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
Kenntnisse
PowerMart J2EE BEA Software SSL & Distributed Systems XML
Kunde
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 ...
Rolle
Migration Team Leader, Mobile Communication Service Provider
Projektinhalte
  • 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
Kenntnisse
Oracle 8x Unix SQL PL/SQL PowerMart ERWIN MS Project
Kunde
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++ ...
Rolle
Project Leader, Migration of a International Service Provider
Projektinhalte
  • 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
Kenntnisse
Oracle 7.34 SunSolaris C++ Embeded C COCOMO II
Kunde
EDS Deutschland GmbH
6 Monate

1999-08

2000-01

Responsible for the Change Request Management

MS Project Vantive PVCS ...
Projektinhalte
  • 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
Kenntnisse
MS Project Vantive PVCS Workflow Management System
Kunde
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 ...
Rolle
Software Engineer
Projektinhalte
  • 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.
Kenntnisse
Sybase & Oracle 7.34 SQL PL/SQL C/C++ Centura
Kunde
LHS Group
Einsatzort
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 ...
Rolle
Freelance Computer Consultant
Projektinhalte
  • 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
Kenntnisse
Centura C/C++ native interfaces Java JavaScript HTML 3.0 Netscape  Centura Access and Visual Basic
Kunde
GodeSYS GmbH, Mainz, Germany

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)
Abschluss
Master of Business Administration
Institution, Ort
Johannes Gutenberg Universität Mainz (Germany)
Schwerpunkt

Strategic Management

4 Jahre

1992-10

1996-09

Study of Computer Science

BS in Computer Science, Technical University Darmstadt, Darmstadt, Hessen, Germany
Abschluss
BS in Computer Science
Institution, Ort
Technical University Darmstadt, Darmstadt, Hessen, Germany
Schwerpunkt
  • Telecommunication
  • Client/Server Systems
  • Project Management

!! Virusresistent !!

Cloud (AWS) Architekt

ELT/ETL Architekt / Developer

AWS Migrationsexperte

DWH Architekt und Modellierer

Anforderungsmanager

Data Scientist (frontend/backend)

english Practice
german fluent
polish mother tongue
R.Kimball's dimensional modelling
russian Basics

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
SAP SAC
DWH Architektur
Data Science
ETL/ELT Finanzwesen
Produkte / Standards / Erfahrungen / Methoden
BSCS/Kenan FX
Sehr gut
Crystal Reports
Experte
ErWin HP Quality Center
Experte
Informatica PowerCenter
Alle RElease
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
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
OK
DB/400
OK
DB2
OK
Informix
OK
Lotus Notes
OK
MariaDB
Experte
MariaDB
Experte
MS SQL Server
Sehr gut
ODBC
Experte
Oracle
7.34 bis 19c in AWS, Multitenant
PostgreSQL
Guru
Quest
Sehr gut
Regulatorik
Guru
Sybase
Guru
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

*** Virusresister und Coronaimmuner BI / DWH Profi ***

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

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

Jetzt bei GULP Direkt registrieren und Freelancer kontaktieren