Informatica Experts in Germany

• Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
• Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
• Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
• Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
• Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
• Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
• Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
• Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
• Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

• Architected and deployed private cloud data platform on VMware vSphere, integrating Greenplum MPP, Apache Kafka, Kubernetes, and Apache Solr, and developed real-time ingestion pipelines with Kafka Connect and Schema Registry.
• Led Oracle Exadata to Greenplum migration, rearchitected data models, optimized storage, implemented RabbitMQ with Debezium for CDC, and deployed VectorDB for Generative AI.
• Designed and executed multi-cloud migration PoC across AWS, Azure, and GCP, defined KPIs for throughput, latency, and cost efficiency, executed bulk data transfers, validated analytics and streaming workloads, and delivered full-scale architecture recommendations.
• Assessed legacy on-premises infrastructure and designed modern cloud-native data platforms using Greenplum and containerized microservices, advising on scalability, disaster recovery, and high-availability.

Project, Strategic Consulting – building the Data Strategy and Data Governance Policy for the German branch, client (private bank Julius Bär, headquarters Zurich), March 2026 – present

• Design and negotiation of the data strategy with key stakeholders, including obtaining board sign-off (strategic consulting) – in this context, regulatory advice on data regulations in the EU and specifically for Germany. The data strategy includes: Data Lifecycle Management: data capture, data storage, data usage, data retention policy, data quality incident management
• Definition of milestones and technical feasibility for implementing TOM for the data strategy, data quality checks, metrics, and a metadata inventory to ensure the bank’s compliance with DORA, BCBS239, and MaRisk requirements.

Core project data change, client: (ING Bank, Frankfurt am Main), March – December 2025

• Concept development and solution design for new end-to-end processes including technical interfaces
• Definition of synchronization logic and data flows between legacy and target systems (decommissioning of legacy systems)
• Analysis and validation of data models
• Stakeholder communication with product owners, feature engineers, UX designers, and operational teams for decision-making
• Analytics and impact assessments, e.g. to assess downstream effects and regulatory requirements
• Documentation and comments on technical and business requirements to support implementation in agile squads

Project digitalization of a user group, client: (ING Bank, Frankfurt am Main), as Interim Product Owner, Jan 2025 – present

• Co-shaping key decisions on data architecture and process logic in the context of historized data and user login functionality
• Development of business solution concepts for migration to the target system, including system integration and data flows
• Support with analytics and impact analyses, especially regarding the ability to provide information to law enforcement authorities
• Active coordination with stakeholders from different squads to support decision-making and ensure regulatory requirements are met
• Creation of test scenarios for operational teams and backend systems in the area of API management using Postman and Bruno.

• Designed and implemented scalable ETL/ELT pipelines using Python, SQL, dbt, AWS and Informatica to ingest data from sources such as APIs, relational databases, and flat files into Snowflake, reducing pipeline runtime by ~30%.
• Migrated high-volume datasets from on-premises Teradata to Snowflake using AWS services (S3, Glue, Step Functions, IAM), ensuring data consistency and integrity.
• Applied Kimball methodology to design star and snowflake schemas, improving query performance and reducing Snowflake compute costs.
• Implemented automated data quality checks using SQL-based dbt tests and the Great Expectations framework to detect anomalies and enforce data correctness before production loads.
• Orchestrated ETL workflows in Airflow using Python and managed code deployments via Git with CI/CD best practices to increase deployment reliability and maintain pipeline uptime.
• Built interactive Power BI dashboards and curated datasets to enable data-driven decision-making for stakeholders.
• Maintained technical documentation in Confluence for ETL workflows, and led knowledge-sharing sessions for new joiners.

• Management and optimization of a portfolio of about 100 projects (launches, in-field solutions, data & analytics, digital solutions, digital products)
• Optimization of the existing project standard (playbook) and alignment with the European and global organization (USA)
• Coaching project managers on setup, planning, cooperation with business, GDPR, GxP, data security and launches
• Preparing projects for works council information and project closeout communication
• Optimization of resource management (tracking, allocation, prioritization)
• Taking over individual project leads (off-/transboarding, event management, checking whether WhatsApp is allowed on a business smartphone)
• Supporting the hiring of external project managers
• Optimization of meeting structure, project controlling (KPIs), change and demand management
• Optimization of risk, issue, dependency and quality management and support during internal audits (GxP)
• Optimization of the portfolio steering tool (Smartsheet) on national, European and global level
• Design and implementation of a Business Value Complexity Scoring
• Building a strategic PMO with a sister department and optimizing cross-functional teams
• Reporting, communication and escalation at management level
• Leadership coaching for several future leaders (short-time assignment)
• Development of the concepts "PPM as a Service" and "Internal Customer Approach"
• Development and review of a concept "AI Data Governance" including roles and processes
• Selection and onboarding of the successor

• DWH modernization
• Migration from Informatica PowerCenter to IDMC/CDI
• Migration from IBM DB2 to Databricks

Technologies: Informatica IDMC, Databricks

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

• 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.

• 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

• Design, development, and maintenance of end-to-end ETL pipelines for scalable and reliable data integration
• Support in data quality checks, testing, and migrations
• Development and maintenance of dbt models for structured, modular, and reusable data transformations
• Use of AI-driven development to improve ETL job creation and code quality.
• Development of CI/CD for automated deployment.

Implementation of anti-money laundering requirements in accordance with AMLA/KYC for an international large bank in Munich

Services provided:

• Clarification of the assignment, definition of the work package structure for the AMLA/KYC implementation project
• AI-supported project planning using my own AI workflow for project management
• Creation of the project management plan
• Resource and capacity planning
• Development of collaboration structures between IT service provider and bank client
• Alignment of responsibilities (RACI matrix)
• Management of 5 project members (core team)
• Project control, project monitoring, project reporting
• Communication management
• Escalation management
• Stakeholder management (11 stakeholders)
• Permanent member of the steering committee
• Project representation internally and externally
• Project reporting, management of decision-making bodies
• Project volume: 506 person-days (development effort)
• Risk management
• Quality management
• Organization and running of workshops

Methods: PMI PMBOK, EVM, GWG, DORA, BAIT, KANBAN, AML, AMLR, AMLA, GWG, KYC

IT environment: JIRA, Confluence, Sharepoint, Kantata Kimble, AI LLM Copilot, ChatGPT, anti-money laundering systems (in-house developments and SMARAGD)

(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)

• Analyzing, aligning and modeling business processes (BPMN 2.0) for the 'The New Retail' program in the areas of invoicing, tax, customs and accounting
• Tracking user stories and their impact on processes
• Point of contact for preparing the tool migration from Symbio to Signavio for the mentioned areas
• Power user after the introduction of Signavio, point of contact and coach for other process modelers

• The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.

• Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.

• Analyzing the company's current situation and developing the best possible solution together with the client.

• Using both agile and classical IT project management methods to deliver projects on time and within budget.

• Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.

• Considering the dependencies between IT and business to achieve sustainable positive effects.

• Employing modern strategies and tools specifically tailored to the company's needs.

• Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.

• Objective: streamlining management and enabling well-founded, data-driven decision-making.