Freelancer profile translated to English.

Back to original language

Description

Skills:

Oracle 19c Exadata

Senior Expert PL/SQL

Data Warehouse Architect

ETL Developer

Data Modeling

Data Vault 2.0

SQL Performance Tuning

SAP ERP Data Extraction

Quality Assurance

Jira, Git

Over 20 years of experience in Oracle Data Warehouse:

- Conception, construction, further development, operation

- ETL development in PL/SQL + BI structures, reporting layer

- Data modeling – including approx. 6 years of Data Vault 2.0

- Data extraction from SAP ERP via Theobald

- Performance tuning SQL

- Setup and expansion of the central information platform of thyssenkrupp Steel Europe

- Close collaboration with business departments/stakeholders

Languages

German
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Dinslaken (up to 50km)

Aachener Grundvermögen GmbH
SAP ERP Data Extraction (FI) for Cost Report to Snowflake DB
REAL ESTATE
May 2024 - Today (2 years and 1 month)
Köln, Germany
▪ Data extraction from SAP/ERP on HANA via Theobald Xtract Universal to Snowflake DB (SAP master data and SAP FI)
▪ Support in setting up a test environment
▪ Quality assurance, testing, documentation
▪ Work in a cloud environment (AWS)
thyssenkrupp Steel Europe AG
Setup and Expansion of the Central Information/Reporting/Analytics Platform of thyssenkrupp Steel Europe
RAW MATERIALS INDUSTRY
June 2023 - March 2024 (10 months)
Duisburg, Germany
Position: Senior Expert
▪ Setup and expansion of the central information/reporting/analytics platform of thyssenkrupp Steel Europe
▪ Design of the central information platform/Lakehouse architecture as a basis for Business Intelligence and Data Science
▪ Management of external companies, specifications for design and development
of Data Warehouse data modeling
▪ Consulting and support for business departments, project team,
designers and developers in developing analytics solutions
▪ Quality assurance of data models and data access functions.
▪ Conception, operation and further development of ETL pipelines for
reporting, data provision and automated data clearing.
▪ Design and implementation of an authorization concept in reporting
with the "Sales" department to control the visibility
of defined data (technical Oracle VPD with Policy Functions)
▪ Testing, operation, SQL performance tuning
▪ Incident/Change Management for Business Intelligence /
Reporting / Analytics Platform via Jira ticketing system
▪ Migration of an existing data model into a new Oracle
Data Warehouse - close coordination with application developers/-
designers and product owners
thyssenkrupp Steel Europe AG
Conception and Setup of a New Oracle 12c Data Warehouse Based on Data from SAP ERP/HANA
RAW MATERIALS INDUSTRY
September 2016 - June 2023 (6 years and 9 months)
Duisburg, Germany
Position: Senior Expert / Sub-Project Manager / Technical Architect
▪ Conception and setup of a new Oracle 12c Data Warehouse
based on data from SAP ERP/HANA, extraction of
transactional data and master data as a supplement to the
existing central information/reporting/analytics DWH
▪ Data extraction (SAP tables, extractors, BAPIs) from SAP/ERP
HANA via Theobald xtract IS to Oracle - modules SAP MM, SD, PM, FI
- Design and implementation of all ETL processes in PL/SQL
▪ Core data modeling with Data Vault 2.0 - self-developed
Job Scheduling, self-developed dynamic loading in
PL/SQL. Data volume approx. 100 million records per day.
▪ Joint specification and close coordination with all
involved business departments (Purchasing, Accounting, Maintenance Controlling, Investment Controlling, Sales)
▪ Processing of all functional designs + creation of technical designs
▪ Setup of a Data Mart Layer for reporting via MicroStrategy
(Dimensions / LookUps, Facts / Marts) - close coordination with
MicroStrategy developers/designers
▪ Performance Tuning Data Warehouse and SQL query tuning
▪ Development of PL/SQL TestCase routines that automatically
perform data consistency checks and structure checks
▪ Introduction of a new deployment process with Git to control
all development teams and involved external companies
▪ Creation of automation scripts (Shell, SQL, PL/SQL) for
deployment processes via BitBucket
▪ On-call duty for the entire system
▪ Participation in DOAG in 11/2017 in Nuremberg
▪ Conception / Setup of interface from SAP PO/PI to Oracle DWH
for purchasing data of all subsidiaries
▪ in 09/2020 Migration Oracle 12c to 19c: Participation in the migration
of the Oracle Data Warehouse from version 12c to Oracle 19c
→Exadata X8M-2 Quarter Rack and an Exadata X8M-2 Eighth Rack