DAX Experts in Frankfurt

• KPI dashboards for inventory and goods received quality control & testing ETL, dataset, dataflows and report development, complex DAX solutions

Data sources: Dataverse, RDB, Excel

Tools: ETL, data modeling, data flows, Power Query, M, Power BI, complex DAX

• Capacity: 25%

• Analysis of web and campaign performance to derive actionable insights for marketing and growth optimization
• Implementation and maintenance of tag management solutions to ensure reliable and consistent data collection
• Continuous development and optimization of reporting structures with a focus on scalability and data quality
• Conducting regular deep-dive analyses and leading monthly stakeholder sessions to present findings and align on optimization measures
• Designing and managing end-to-end data flows from data collection to visualization
• Tools: GA4, Google Tag Manager, Looker Studio, Airbyte, BigQuery

• 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 patient journey through big data analysis and cross-functional collaboration
• Regionalized NICU centers with 86% coverage using mathematical models
• Developed patient flow and geoprocessing models with Python and ArcGIS, resulting in an 18% increase in efficiency
• Built simulation models to optimize bed utilization and reduce waiting times with Rockwell Arena
• Developed analytical dashboards in collaboration with clinical experts
• Implemented machine learning algorithms for birth predictions and cross-functional prescription analyses

• Design an interactive Tableau dashboard to analyze historical aviation accidents using data from the Federal Bureau of Aircraft Accident Investigation
• Develop visualizations to provide actionable insights to improve aviation safety measures employing data modeling and transformation techniques
• Develop a Power BI dashboard to monitor sales KPIs and product performance integrating data from multiple sources
• Design a star schema data model and implement advanced DAX measures for high-performance and dynamic reporting
• Design a comprehensive BI architecture solution focusing on ETL pipelines, data integration, and data governance
• Recommend Power BI as the central tool and create a security-compliant implementation roadmap

• Design, architecture & development/programming of ETL/ELT data pipelines, DWH, BI solution
• Technical project lead, POC – proof-of-concept creation
• Liaison between business units and technical teams
• Azure DevOps Boards & Jira
• Data modeling & data engineering – data warehouse & data mart
• Azure (Data Factory, Azure SQL, Azure DevOps CI/CD, Azure Data Lake V2, Business Central REST API, OData API, OAuth2 tokens)
• SharePoint lists & API for ADF, Firebird DB, Postgres DB, DB2
• Power BI (Power Query), DAX, Excel PBI add-on, GIS data
• Automated ETL process monitoring/logging, performance monitoring, error monitoring – capturing & resolution
• Index performance tuning & statistics monitoring, Transact-SQL
• Data security – MFA (multi-factor authentication) & OAuth2, MS Graph, Azure networks & firewalls, gateways, roles, user groups – with read/write permissions
• Sources – Vario Bill, Camunda, Radius, Geo Database, OTRS, PAST, MS Dynamics Business Central, Azure Blob Data Lake, SharePoint lists

• IT security audits and reviews of IT security architectures with a focus on IAM
• Creating security concepts and risk analyses for DAX companies and medium-sized businesses
• Developing cloud security strategies and reviewing core security solutions
• Designing IT security architectures including IDP integration (OAuth2/OIDC)
• Multi-project management and central program office for DAX companies
• Developing project management strategies for medium-sized businesses
• Process-oriented GDPR data analyses and action catalogs for foundations

• Jul 2024 – Feb 2025 Transformation (NDA – Clients)

• Implementation of the value creation plan in a private equity-backed industrial company

• Served as Interim Transformation Officer; responsibilities: central project management including timeline, budget, resources, reporting, risks

• Oct 2023 – Apr 2024 Sourcing, Regulation (Retail Bank DE)

• Change Lead for the implementation of a regulation (CESOP), responsible for project governance, project controlling (budget, resources) and project reporting, stakeholder management, timeline and project risks

• Drafted SLAs and aligned with relevant 2nd lines (Legal, Compliance, Tax, Third Party Risk – MaRisk BAIT, ORM) for sourced services; aligned on the Statement of Work

• Apr 2023 – Aug 2023 IT Program Management (Retail Bank DE)

• Local coordinator for the rollout of a project management software combining program and agile backlog management views

• Responsible for migration preparation, communication of changes and new logic in Germany, stakeholder management

• Oct 2022 – Aug 2023 Regulation (Retail Bank DE)

• Local lead of the global program; combined 4 local projects (retail/wholesale banking) to implement the next generation messaging standard (ISO 20022)

• Implemented local project governance, communicated progress, aligned and managed stakeholders with global HQ

• Jul 2022 – Mar 2023 Digitalization, Data Management (Retail Bank DE)

• Change Lead aligning the local retail data model to the global standard and its implications for internal data providers and consumers

• Designed and aligned a detailed implementation plan with global and local stakeholders

• Project management: set up new project governance and routines, reviewed progress in weekly meetings with product owners, chaired SteerCo meetings, documentation

• May 2022 – Apr 2023 KYC Regulation, Process Management (Retail Bank DE)

• Built a highly automated customer offboarding process for retail clients due to non-compliance

• Change Lead in development, testing and implementation in an agile environment with a 40-FTE project team

• Project management: held SteerCo meetings, accountable for the business case, project risk management, stakeholder management

• Jan 2022 – Mar 2022 Strategy, Product Development (NDA - Exchange)

• Coordinator in the concept phase for developing a cryptocurrency certificate with an external investment bank

• Orchestrated 5 workstreams, provided overarching PMO and stakeholder management

• Created the business case and aligned strategic options

• Oct 2020 – Oct 2021 Business Transformation, Sourcing (Largest German Bank)

• Implemented the organizational target operating model for KYC Germany as project manager

• Managed staffing and location setup (hired 250 FTE, logistics for new site)

• Built the KYC competence center for German large caps (department, team, roles) process-wise and organizationally

• Advised on contract negotiations with procurement for sourcing an external KYC provider

• Jan 2020 – Sep 2020 Digitalization, KYC Regulation (Largest German Bank)

• Germany coordinator (project manager) in an agile project to introduce an AMLD-5 compliant KYC software (MVP)

• Stakeholder management as nexus between local staff and management (back & front office), global project management, product owners, IT

• Incident management (capture, prioritization, tracking) with JIRA

• Jan 2018 – Jun 2019 Business Transformation, Tax Evasion Prevention Act Regulation (Largest German Bank)

• Led the implementation of the Tax Evasion Prevention Act in the global Corporate & Investment Banking division

• Analyzed legal requirements and developed a control concept in alignment with business and infrastructure units

• Successfully implemented IT and process solutions within budget and timeline; prepared initial regulatory reporting to the Federal Central Tax Office

• Project management: initiation, chaired SteerCo meetings, communication

• Dec 2016 – Dec 2017 Business Transformation, Banking Separation Act Regulation (Largest German Bank)

• Led the implementation of the Banking Separation Act in the global Global Transaction Banking (GTB) division

• Developed target operating model and process design (control concept) in coordination with IT and 2nd lines (Legal, Compliance)

• Successfully implemented changes in business units and IT per regulatory requirements

• PMO and represented the internal GTB project management in committees

• Jul 2015 Project Management (Largest German Bank – Asset Management)

• Implemented an asset management front-office system

• Interim head of the global PMO (Frankfurt, New York) with 4 staff

• Planned milestones, budget, regular reporting

• Prepared, attended and followed up on senior governance meetings

• Apr 2015 – Jun 2015 M&A Consulting – Due Diligence (NDA – Asset Management)

• Led a European operational due diligence (buy side) for a European asset manager back-office provider

• Produced red flag reports: screened data rooms, assessed organizational structure, identified risks in acquisitions

• Designed operating model scenarios for operations including business case

• Jan 2015 – Feb 2015 Target Operating Model (Largest German Bank)

• Conducted market and competitor analysis to realign multiple securities processing units (private & corporate clients)

• Ran a strategy workshop to develop a new target operating model for securities processing

• Jan 2014 – Dec 2014 M&A Consulting – Post Merger Integration (Largest German Bank)

• Organizational restructuring and group integration during the post-merger integration phase

• Deputy project manager leading 4 staff in the Integration Management Office (status reporting, attended sponsor meetings with senior management)

• Advised workstreams on cost reduction, synergy realization and business case controlling across 11 subprojects

• Feb 2013 – Dec 2013 Sourcing (State-owned Resolution Agency)

• Coordinated sourcing activities for the bankwide service-level agreement (SLA) creation with an external service provider

• Checked SLAs for completeness and consistency, facilitated cross-functional alignment within the bank

• Advised on preparing negotiation positions and participated in discussions with service providers and senior management

• Jun 2012 – Jan 2013 Sourcing (State-owned Resolution Agency)

• Developed site strategy: scenario analysis for European locations and created business case

• Advised and prepared tender and contract documents per EU procurement rules for outsourcing portfolio management services

• Led a team in drafting portfolio management service-level agreements

• Mar 2012 – Jun 2012 M&A Consulting – Carve-Out (Largest German Bank – Asset Management)

• Global carve-out of the institutional asset management business to a US investor

• Led the global operations workstream focusing on 3rd-party contract review, portfolio analysis, drafting and negotiating transitional service agreements

• Oct 2011 – Feb 2012 Regulation (various banks)

• Central support for FATCA project teams with technical work and Deloitte position papers

• Conducted client workshops for a cooperative bank on FATCA strategy for foreign financial institutions

• Process redesign and advisory support during implementation

• Jul 2011 – Oct 2011 M&A Consulting – Carve-Out (Life Insurance)

• Planned and prepared an M&A carve-out transaction

• Analyzed existing processes and defined target processes; facilitated cross-functional workshops and created day-1 checklists

• Operationally led the PMO with 3 staff for the carve-out (prepared and participated in steering committee, developed project plan)

• Feb 2011 – Jul 2011 Project Management (Life Insurance)

• Operational leadership of the PMO, project risk management

• Prepared post-merger integration steering committee at C-level

• Project reporting, stakeholder management, project and budget controlling

• Nov 2010 – Jan 2011 Securities Processing (Landesbank)

• Created data processing and business concepts for securities trading

• Designed test cases for IT interfaces

• Independently coordinated test execution with business requirements

• Sep 2010 – Oct 2010 Project Management (Asset Manager)

• PMO for introducing an independent P&L

• Budget tracking, prepared and documented steering committee