Fachlicher Schwerpunkt dieses Freiberuflers

Business Intelligence- und Data Warehouse Architekt, Integration- und Backend/Frontend Experte (SAP BO / BI, ELT/ETL, Informatica 10.x, BODS...),

verfügbar ab
14.10.2019
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

D0

D1

D2

D3

D4

D5

D6

D7

D8

D9

Österreich

Schweiz

Einsatzort unbestimmt

Kommentar

Deutschland: Gerne Frankfurt oder Rhein-Main

Position

Kommentar

Cloud (AWS) Architekt

ETL Architekt / Developer

AWS Migrationsexperte

Projekte

03/2017 - Heute

2 Jahre 7 Monate

Several migration projects

Rolle
Self-employed DWH Architect
Kunde
DB Systel GmbH
Einsatzort
Frankfurt/Main, Germany
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

01/2016 - 02/2017

1 Jahr 2 Monate

Online shop interface

Rolle
Self-employed Business Intelligence Architect
Kunde
Die Schweizerische Post
Einsatzort
Kanton Bern, Switzerland
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

03/2013 - 12/2015

2 Jahre 10 Monate

Design & development

Rolle
Self-emeployed Data Architect
Kunde
MunichRe AG
Einsatzort
Munich,Germany
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
  • 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.

10/2012 - 02/2013

5 Monate

"Car Leasing" Project

Rolle
DWH/ETL Architect
Kunde
MAN AG
Einsatzort
Munich
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

04/2010 - 08/2012

2 Jahre 5 Monate

"SMART" Project SEB /Santander Bank

Rolle
Self-employed Consultant
Kunde
SEB AG
Einsatzort
Frankfurt/Main, Germany
Projektinhalte
  • Design and development a large size data warehouse (>1 TB), SEB AG, Frankfurt/Main, Germany
  • Several reporting tasks according to BaFin (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

01/2009 - 04/2010

1 Jahr 4 Monate

ETL development

Rolle
Self-employed Consultant, ETL Team Leader (5 persons)
Kunde
Kabel Deutschland
Einsatzort
Munich, Bavaria
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)

04/2008 - 12/2008

9 Monate

DWH Design & Development

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

05/2006 - 04/2008

2 Jahre

DWH and ETL concept and design

Rolle
Consultant Business Intelligence
Kunde
Deutsche Ärzte und Apothekenbank, Düsseldorf, Germany
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 ...)

05/2005 - 05/2006

1 Jahr 1 Monat

Prepaid System migration

Rolle
Senior Consultant
Kunde
CapGemini Germany
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

01/2003 - 05/2005

2 Jahre 5 Monate

Kenan/BP migration strategy

Rolle
TP S.A. Poland - Team Leader Online Development
Kunde
EDS Deutschland GmbH
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++

09/2001 - 12/2002

1 Jahr 4 Monate

Customising & optimize of the PowerMart entities

Rolle
Health Care Austrian: Sr. Software Architect
Kunde
EDS Deutschland GmbH
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

11/2000 - 09/2001

11 Monate

Migration from BSCS5.21 to MCBS

Rolle
Migration Team Leader, Mobile Communication Service Provider
Kunde
EDS Deutschland GmbH
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

06/2000 - 11/2000

6 Monate

Co-operation & coaching

Rolle
Project Leader, Migration of a International Service Provider
Kunde
EDS Deutschland GmbH
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

08/1999 - 01/2000

6 Monate

Responsible for the Change Request Management

Kunde
EDS Deutschland GmbH
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

01/1997 - 08/1999

2 Jahre 8 Monate

Designed the System Upgrade Strategy

Rolle
Software Engineer
Kunde
LHS Group
Einsatzort
Hessen, Frankfurt am Main
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

01/1996 - 01/1997

1 Jahr 1 Monat

Developed & integrated Dynamic Linking Librarys

Rolle
Freelance Computer Consultant
Kunde
GodeSYS GmbH, Mainz, Germany
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

Branchen

  • Business Intelligence
  • ETL
  • DWH 
  • Billing Rating 
  • Migration 
  • Reporting 
  • SAP BI/BO, SAP BO IX3x, 4x
  • Project Management
  • telecommunication

Kompetenzen

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

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

Datenbanken
Access
OK
amazon-Redshift
OK
DB/400
OK
DB2
OK
Informix
OK
Lotus Notes
MariaDB
Experte
MS SQL Server
ODBC
Experte
Oracle
7.34 bis 12c in AWS
PostgreSQL
Guru
Quest
Sybase

Sprachkenntnisse
english
Practice
german
fluent
polish
mother tongue
russian
Basics

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

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

Produkte / Standards / Erfahrungen
BSCS
Crystal Reports
HP Quality Center
Informatica PowerCenter
Kenan Arbor FX
LiveOffice
SAP BO Xcelsius
SAP BusinessObjects
BOXI 3.x BOXI 4.x,
SAP BusinessObjects Data Services
SAP BusinessObjects Design Studio
SAP LCM
SAP MM
Universum Designer
WebIntelligence

Design / Entwicklung / Konstruktion
Big Data
Cubes
Hub&Spoke
ITIL
"Service Management"
Kimball
TOGAF

Berechnung / Simulation / Versuch / Validierung
TestDirector
WinRunner

Aus- und Weiterbildung

09/2002 - 09/2004

2 Jahre 1 Monat

McComb School of Business (Austin,Texas, USA)

Abschluss
Master of Business Administration
Institution, Ort
Johannes Gutenberg Universität Mainz (Germany)
Schwerpunkt

Strategic Management

10/1992 - 09/1996

4 Jahre

Study of Computer Science

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