ETL Experts in Dusseldorf

• Evaluate, design, and implement Power BI solutions for Cat4 reporting, significantly improving reporting efficiency, accuracy, and stakeholder visibility.
• Develop and maintain robust data integration interfaces between Cat4 and Power BI, eliminating manual processing bottlenecks.
• Configure and continuously optimise Power BI reports to deliver sharper management insights and support data-driven decision-making.
• Ensure full GDPR data protection compliance across Power BI reports, proactively identifying and mitigating risks.
• Acquired in-depth product knowledge of CAT4, a globally deployed enterprise platform, enabling effective requirements analysis, solution design, and seamless Power BI integration across client environments.
• Developed and integrated scalable reporting templates within the CAT4 product interface, delivering new product features and enhancing data visualisation, reporting efficiency, and stakeholder visibility across global users.
• Trained and mentored staff on Power BI configuration and best practices, accelerating adoption and embedding a data-driven culture.
• Prepared clear technical documentation and delivered hands-on demonstrations to end users and clients, ensuring smooth adoption and confident use of Power BI solutions integrated with CAT4.
• Researched and recommended licensing strategies for cost-effective and scalable Power BI deployment.

SKILLS - BI & Visualisation: Power BI (Desktop, Service, Report Builder), DAX, Power Query

Project and Product Management Tool: CAT4

• Implemented the BI solution and replaced the old BI landscape
• Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
• Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
• Expanded the relational DWH database
• Developed ETL processes using SSIS
• Developed the multidimensional database (OLAP Cubes/SSAS)

• Responsibility for group-wide financial management with a focus on management, PE, and lender reporting.
• Focus on an integrated financial model (P&L, balance sheet, cash flow), robust liquidity and covenant management, and preparation of decision-ready materials for financiers, auditors, and rating stakeholders.
• Establishment of reporting standards, data logic, and closing routines for high-frequency scalability.
• Further development of an integrated financial model (P&L/BS/CF), including scenario capabilities, sensitivities, and driver-based forecasting logic.
• Design and management of a rolling liquidity plan (short-/mid-term), including working capital mechanisms and financing instruments.
• Preparation and quality assurance of lender reporting, including covenant calculations, bridge analyses, and variance explanations.
• Support for the CFO agenda in financier and stakeholder communication (Q&A, documentation logic, key messages, data consistency).
• Coordination and content input for rating- and financing-related deliverables (e.g., presentations, data rooms, management commentary).
• Management of IFRS/accounting topics (e.g., IFRS 16 lease logic, accrual and reconciliation concepts) to ensure reporting and audit readiness.
• Standardization of reporting structures, templates, and KPI definitions across entities to increase transparency, comparability, and speed.

I continuously expand my expertise in AI and automation, working with ChatGPT, OpenAI, Manus, Gemini, MS CoPilot, API, LangChain, Hugging Face, Manus, TensorFlow and Auto-GPT as well as Python-based ML frameworks and MLOps tools to intelligently transform classic software development, analysis, and testing processes.

• Analysis, software development/customization, and testing of various transaction and batch objects
• Conducting functional integration and regression tests on TEST and QA platforms under z/OS for later production implementation
• Hardware / Software / Tools: IBM MVS, z/OS, JES2/3, TSO-ISPF, JCL, DB2, SQL, SQL/PL, QMF, QMF for Workstations, SPUFI, FileAid, IMS-DB/DC, MFS, XPEDITER, COBOL, REXX, Windows 10, MS Office 365, MS Teams, batch job management via OPC, BETA92, RVS, BVB, ABL, DIALOGplus, PROBA, PRODPR (VW internal systems), JIRA, CONFLUENCE

• Development and maintenance of database-driven applications for managing supplier and food contracts, using Oracle PL/SQL extensively for complex business logic and data processing
• Optimization of PL/SQL procedures, functions, and triggers to ensure the performance and scalability of Oracle database solutions
• Ensuring adherence to best practices in PL/SQL development and implementing standards for code quality and data integrity
• Close collaboration with backend and frontend teams to ensure seamless integration between the Oracle database, C#-based APIs, and Azure cloud services

• Design and implementation of an OCI-based data warehouse and ETL system to replace legacy mainframe applications
• Developed a database optimization strategy and planned the rapid conversion of JCL and COBOL routines to PL/SQL using AI
• Developed an Oracle Apex-based app for internal administrative processes in the public sector (office equipment, staff training)
• Implemented PL/SQL workflows for approval processes and created a responsive mobile version with JavaScript and CSS
• Used Azure DevOps for backlog management and documentation, and Git for version control
• Developed REST interfaces to CRM systems
• Replaced and reprogrammed Oracle Forms screens with Oracle Apex and updated to the latest Apex versions
• Designed a Git branching strategy and conducted code reviews
• Maintained and further developed an EDI-based data exchange system based on Oracle Advanced Queuing for the public sector in Austria
• Performed data analysis and created charts in the Oracle Apex frontend; installed standalone ORDS and Apex 23.1
• Worked agile using the Spotify model; developed complex Apex pages with support from Oracle JET
• Rebuilt and customized existing PL/SQL packages, created workarounds for database version differences, and optimized queries
• Developed Apex applications for broker pools to manage and optimize Oracle databases in the banking environment, including SSO-based authorization systems with OAuth2 and Keycloak
• Built extensive Oracle Apex applications for BI and data mining modernization projects and developed manual and automated projection methods in the frontend
• Carried out data warehousing projects in the banking sector and used Scrum and Kanban in team projects

• Instructor / Trainer
• SAP applications in SAP S/4 HANA - Sales, Sourcing Procurement, Logistic Execution, SAP Foundation
• SAP S/4 HANA - Fiori UX and Fiori Launchpad
• Cross-module MM application - Sourcing & Procurement
• Business processes SAP S/4 HANA Procurement
• Purchasing processes SAP S/4 HANA MM
• Incoming processes SAP S/4 HANA MM
• Supplier invoicing SAP S/4 HANA MM
• Pricing & plant determination SAP S/4 HANA MM
• Automation in SAP S/4 HANA MM
• Business processes SAP S/4 HANA Pre & After Sales
• Sales processes SAP S/4 HANA Sales
• Delivery processes SAP S/4 HANA Sales
• Billing SAP S/4 HANA Sales
• Pricing SAP S/4 HANA Sales and Storage Rooms and Lean-EWM
• Automation in SAP S/4 HANA Sales
• SAP S/4 HANA – SAP Private Cloud – Release 2023

• Led the design, implementation, and optimisation of SAP Analytics Cloud (SAC) dashboards, stories, and reports for business users.
• Worked closely with business stakeholders to gather and analyse reporting requirements, translating them into technical designs.
• Integrated SAC with SAP BW/4HANA, SAP S/4HANA, SAP HANA Views, and external data sources.
• Developed SAC Planning models and supported planning processes, including input forms, allocations, forecasts, and simulations.
• Configured live and import connections to SAP and non-SAP data sources.
• Conducted performance tuning, security setup, and ensured data accuracy in SAC environments.
• Provided training, documentation, and best practices for SAC adoption across the organization.
• Led incident management, change requests, and enhancements in SAC landscapes.

• Gather and analyze requirements in close collaboration with business units to develop data-driven solutions and scalable PowerBI reporting infrastructures.
• Perform detailed debugging and optimize existing semantic and data models to ensure a robust data architecture, high data quality, and improved PowerBI reporting.
• Design and implement scalable ETL processes for data preparation and integration.
• Create a wiki for table and view descriptions as well as PowerBI PowerQuery and KPI documentation to ensure a consistent understanding of data structures and metrics.

Implemented Power BI reporting for various departments at an energy provider. Agile project: responsible for organizing and coordinating with departments and IT, and regularly presented interim steps and results to project management.

• Project: Migration of large data sets
• Result: ETL route development with AWS Glue and Talend Open Studio

• Extraction and transformation of relevant data from the SAP system developed for the bank and consolidation into the existing reporting environment
• Integration of the data into the existing BI model (extending the star schema to a galaxy schema) for generating the funding committee report and the business development report
• Ensuring data quality
• Knowledge transfer to department staff (SAP, SQL database, Power Pivot, DAX)

• Improvement of Tagetik
• Other tasks