Pentaho Experts in Germany

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Creation of automated tests.
• Extension of the functionality of the enterprise BI data warehouse.
• Design and development in SQL and PL/SQL.
• Data modeling as well as performance measurement and tuning.
• Creation of and contribution to user stories and concepts.
• Technical environment: Windows, Linux.
• Database: Oracle 19c incl. DWH, CDB, PDB.
• Tools: Confluence, CVS, Eclipse, Git, GitLab, Jira, N4, PL/SQL, SQL Developer, utPLSQL.

• Implementation of specified DevOps solutions to automate infrastructure (Terraform, Bicep, CloudFormation, Ansible) on-premises datacenter (Ovirt, Proxmox, Ceph Cluster, MinIO) and private cloud.
• Administration, configuration and implementation of CI/CD DevOps pipelines (GitLab, GitFlow) to support development process (Artifactory, Prometheus, Istio, service mesh, Helm Chart, OpenShift (Red Hat Enterprise) / Kubernetes cluster), Red Hat Satellite.
• Administration, setup, monitoring and patching of Linux infrastructure based on Red Hat Enterprise for Dev, Test and QA.
• Use of Scrum and Kanban methods.
• Administration, configuration and implementation of security standards for deploying on Dev, Test, QA and Prod stages of the new ePA applications.
• Development of new plugins and add-ons needed on current infrastructure.
• Database support.
• Data analytics support (Python, Spark, Pandas, Power BI, Splunk Enterprise).
• Implementation of best practices for DevSecOps and BizDevOps using GitOps (ArgoCD), Streamlit framework, Semaphore Ansible UI.
• Configuration and testing of iperf, uperf, sysbench using benchmark-operator for external source data and IoT/MDM devices, creating reports via ELK / OpenSearch.
• Building a new Databricks platform to collect and analyze big data from different sources and IoT devices into Hadoop framework (Python, Pandas, PySpark, Power BI, Apache Airflow).
• Building backend data aggregation and processing to automate configuration deployment between different OpenShift clusters and big data framework (Python, Pandas, PySpark, Apache Spark, PostgreSQL, Django 2, Ansible Automation, Jira JSM).
• Building a new ML pipeline platform using Kubeflow, TensorFlow, KServe.
• Data extraction, transformation and loading from different data sources including structured and unstructured data to analytic DWH / big data cluster using Python, Pandas, Polars, Power BI, Django backend and PostgreSQL.
• Setup of new DevOps Test and QA HashiCorp Vault cluster for PKI and IAM.
• Configuration and testing of automated patching based on CVSS score, SIEM-integrated CVEs.
• Use of Nexpose and InsightVM to scan vulnerability events in network, host, container and application.
• Design and implementation of secure and scalable AWS architectures including VPC, EC2, S3, RDS and Route53 and similar setups on Azure and GCP.
• Automated system provisioning and deployment using CloudFormation templates.
• Configuration of IAM roles, policies and permissions to ensure secure access control.
• Patch management, backup automation and disaster recovery setup on AWS infrastructure.
• Monitoring and optimization of system performance using AWS CloudWatch and AWS Trusted Advisor.
• Support of VMware services (vSphere, Aria, Horizon) and the virtual desktop environment.
• Development and maintenance of CI/CD pipelines using Jenkins, GitLab CI/CD and AWS CodePipeline with interface to Nutanix.
• Configuration of AWS CloudWatch to monitor application performance and system events.
• Planning and execution of migration of on-premises applications to AWS cloud platforms.
• Deployment of containerized applications using Docker and Kubernetes in AWS environments.
• Deployment of internal software packages between availability zones using AWS CodeDeploy.
• Building and deploying ML models using Scikit-learn, XGBoost and Spark MLlib including hyperparameter tuning, model evaluation and production deployment.

• Energy Management (2023-08-01 – present):

• Designing a planning solution to improve energy efficiency

• Creating a concept for an energy management system

• Planning a measures planning component to gradually reduce energy consumption

• Evaluating planned measures by assessing opportunities, risks, and effectiveness for integration into planning

• Defining requirements for a data model to compare planned vs actual data in the dashboard

• Consulting (2023-05-01 – present):

• Expanding accantec PerCon permission management to IBM Planning Analytics

• Analyzing permission requirements and aligning with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

• Printing (2023-04-01 – present):

• Supporting the rollout of a data warehouse solution with IBM Cognos Analytics 11

• Assisting in the introduction of a reporting system based on a standard data warehouse

• Supporting report developers and creating custom controls to optimize the user interface

• Healthcare (2020-08-01 – 2023-03-31):

• Optimizing, extending, and operating a long-standing BI planning landscape

• Upgrading the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL

• Connecting various accounting and management systems

• Writing back completed plans to source systems and implementing complex allocation logic

• Building and maintaining dimensions and hierarchies (company structure, P&L)

• Developing planning scenarios for FP&A and creating budget monitoring reports

• Designing and implementing new OLAP cubes and reporting

• Conducting user trainings based on customer requirements

• Industrial sector (2020-04-01 – 2020-12-31):

• Migrating and optimizing an existing Jedox solution

• Merging reporting and planning systems in Jedox

• Building a central group reporting with plan vs actual comparison for FP&A

• Optimizing metric calculations, existing reports, and creating new reports

• Producing forecast reports, managing permissions, and training users in an international setting

• Finance (2020-05-01 – 2023-03-31):

• Enhancing and operating an existing Jedox solution

• Designing and developing new OLAP cubes for controlling

• Building hierarchies in dimensions (e.g., P&L) and updating the Jedox system in a Linux environment

• Conducting user trainings for report creation

• Trade fair (2020-06-01 – 2023-03-31):

• Designing and developing a BI planning solution in Jedox with a data warehouse setup

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports, planning input forms, and implementing business logic (P&L, allocation logic)

• Implementing planning and analysis reports, as well as a security concept in Jedox

• Industrial sector (2021-03-01 – 2023-03-31):

• Migrating and optimizing an existing Jedox solution

• Upgrading the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator

• Optimizing SQL queries, analyzing the system, removing redundancies, and developing new ETL processes

• Reviewing and adjusting existing reports

• Staffing services (2022-07-01 – 2022-10-31):

• Migrating a Jedox solution from version 5 to 2022.2

• Performing a system update with configuration adjustments and performance issue analysis

• Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data

• Finance (2021-10-01 – 2022-02-28):

• Creating OLAP cubes in Microsoft SSAS

• Building dimensions and hierarchies, and calculating metrics with MDX

• Supporting users with Power BI requests

(Technology)

• Design and implementation of an SAP BTP CAP microservice to consolidate cross-system transactional checks between SAP Sales Cloud (C4C) and On-Premise SAP CRM (05/2024– 06/2025)
• Bi-directional Cloud-to-On-Premise integration enabling real-time validation of Contact lifecycle and open document dependencies prior to record updates (05/2024– 06/2025)

Responsibilities / Deliverables

• development of custom CAP (Cloud Application Programming) services on SAP BTP
• API design, data mapping, and end-to-end integration across C4C (Cloud Runway) and legacy CRM (Traditional Runway)

• Configuration and expansion of monitoring
• Setup of a monitoring test instance and inclusion of Windows and Linux servers
• Creation of documentation for the checkmk environment
• Handover to operations
• Administration, installation, documentation
• IT environment: Windows Server 2019, Ubuntu Server, Checkmk

• Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
• Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
• Storage of the silver layer on Hadoop and the gold layer in Oracle.
• Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
• Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
• Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
• Versioning changes in GitHub and deployment via the CI/CD portal.
• Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
• Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
• Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
• Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
• Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.

• Optimized the data architecture (medallion) to better decouple processing stages and improve transparency and reproducibility
• Ensured technical quality of data processing in Databricks by introducing schema enforcement, data quality checks and a structured data architecture
• Orchestrated pipelines with Azure Data Factory
• Professionalized and automated the development and deployment process by integrating Git and GitHub Actions
• Led the Data Engineering team (3 members) in a functional role
• Conducted workshops to optimize and stabilize the data platform and the development process
• Collected and prioritized new requests, maintained the product backlog
• Technologies: Microsoft Azure (Data Lake, Data Factory), Databricks, Apache Spark (PySpark), Python, SQL, Git, Confluence, Power BI, Power Apps, Dataverse, MS SharePoint, Mural

• Analyzed the required scope of processes, infrastructure, and SAP for integrating the MacDermid subsidiaries
• Validated proposals from the new service providers
• Managed the collaboration and tracked the tasks of business and IT experts
• Coordinated communication and the PMO
• Created cutover plans in three waves for SAP conversion, Salesforce, and Ariba

• Developed a comprehensive business concept for a medical fall detection device based on a patented process registered in Germany
• Identified and collected use cases for medical device deployment in residential buildings and healthcare provider facilities
• Expanded the product scope to industry standards such as HL7/FHIR and designed a product based on modern communication protocols for IIoT
• Supported offshoring activities, defined SLA and scope-of-work documents for development teams after selecting various vendors
• Identified and selected hardware components (Terrabee, E-Con Systems) for LIDAR/TDOA functions
• Defined integrated AI features and LLM models for patient fall detection as well as AI-based audio triggers
• Oversaw the implementation of algorithms for object detection, fall detection, and false alarm identification

• Designing and implementing an interactive evaluation system for top executives to rate core competencies such as goal orientation, team culture, and strategic alignment.
• Integrating control mechanisms to enforce feedback limits and store evaluations in a central system to ensure data integrity.
• Optimizing data processing for personnel development by automating the merging of various information sources for form letters.
• Implementing technical data preparation and analysis for the annual compensation comparison in the financial sector.
• Developing automated processes for data preparation in Excel using Power Query, ensuring data integrity and anonymization according to data protection requirements.
• Automating personnel cost analysis by developing a solution to process data from the Paisy system into an SAP-compatible Excel file.
• Creating test cases, user documentation, and test plans for all developed systems.
• Technologies: Power Query, MS Office 2016 (Word, Excel, PowerPoint), Paisy, SAP, VBA.

• Architected and operated cloud-based data and ML platforms for autonomous driving and parking systems, supporting large-scale (multi PB scale) simulation and vehicle data ingestion.
• Implemented security, compliance, and governance standards across Azure subscriptions and cloud resources.
• Managed GitHub organizations and CI/CD pipelines to improve deployment reliability and developer productivity.
• Contributed to hiring and technical interviews as part of the recruitment panel.

• Developed and enhanced ETL loading jobs with IBM DataStage and optimized SQL in an IBM DB2 environment as part of the Agree21 data migration
• Analyzed data quality and developed test procedures
• Created PowerShell scripts and documented GIT deployment processes
• Technologies: RedHat Linux, IBM DB2 with DBVisualizer, IBM InfoSphere DataStage 11.7, JIRA, TortoiseGIT, TortoiseSVN, PowerShell scripts

• 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