Data Modeling Experts in Frankfurt

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.

• ITSM consulting, analysis and optimization of IT capacity with BMC TSCO / BMC Helix
• Drafting "Governance guidelines for operational capacity management"

• Analysis of the existing reporting platform including processes and governance topics with stakeholders from sales and marketing.

• Detailed analysis and evaluation of client-defined requirements for existing reporting and new dashboards.

• Supporting stakeholders in managing sales processes and early detection of KPI trends.

• Use of Microsoft Power BI as central analysis and reporting platform.

• Developing a proposal for the necessary evolution of processes and the Power BI platform.

• Gathering current business processes and defining company-wide KPIs in coordination with stakeholders.

• Analysis and inventory of the client's Power BI platform.

• Analysis of processes and data governance.

• Recording and documenting current business processes.

• Developing recommendations for process and reporting platform improvements.

• Designing and implementing dashboards in Power BI.

• Defining company-wide KPIs and aligning them with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

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

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

• Manage and oversee various software development projects between product management and agile dev teams of external service providers
• Communicate with all stakeholders
• Promote transparency and focus on project topics
• Facilitate alignments between business units and external partners
• Support product managers and product owners in preparing and managing requirements in workshops and tools
• Use short feedback loops to optimize agile collaboration
• Support hybrid and agile collaboration

• 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

• Supported the International Web Presence project of the Federal Employment Agency (IntWeb) in quality management, taking on responsibility for the quality of processes and project deliverables while adhering to BA standards. The project's main goals are to give professionals abroad a quick overview of their chances to move to Germany and to enable them to take the necessary steps in a consistently digital way.

• Set the fundamental guidelines using the QA handbook

• Summarized test results in QA reports for PLA

• Analyzed project outcomes for improvement opportunities

• Quality management of requirements analysis (especially processes, methods and tools)

• Ensured compliance with SERA guidelines

• Created a cross-project test concept

• Agreed on sprint completion reports

• Conducted formal reviews of deliverables according to guidelines and/or project plan

• Acted as contact person for internal audit and external audits by auditors or the Federal Audit Office (BRH)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Configured and automated data extracts from Oracle databases, achieving 100% data accuracy in a critical migration project, significantly reducing manual errors and accelerating the migration timeline.

• Designed and implemented interfaces with Order Management Systems (OMS), enabling seamless and automated data exchange and improving operational efficiency through faster, error-free order processing across business units.

• Developed and deployed data extraction workflows to support regulatory compliance and customer reporting, ensuring timely delivery of key reports, reducing manual effort, and increasing customer satisfaction.

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

• Advising on the use of analytics and BI tools and services in the Microsoft Azure stack (e.g. MS Fabric, Synapse Workspaces and dedicated SQL pools, SQL Database, PostgreSQL, Snowflake, Databricks, Data Factory, SSIS, Analysis Services, Function Apps, Power BI, ML)
• Independently designing analytics solutions with Python, SQL, etc.
• Designing and implementing ETLs and data pipelines
• Creating and maintaining APIs
• Independently applying CI/CD, testing, and version control
• Data modeling
• Model development and optimization
• Anomaly detection with AI
• Predictive analytics

Used technologies:

• Snowflake
• Fabric
• Azure Synapse Analytics
• Azure DataFactory
• Azure Data Lake
• Azure DevOps
• Databricks
• Spark
• CI/CD
• SQL Database
• Python
• Power Platform

• 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

• Microsoft Azure: design, sizing, and capacity analysis including PoC
• Microsoft Azure: final implementation for migration from on-prem RAC to single instance Data Guard
• Performance tuning and troubleshooting for crew management systems (pilots and briefings)
• Design and implementation of a disaster recovery-aware system based on RAC Extended Cluster and Data Guard
• OEM: Oracle Cloud Control maintenance, installation and upgrades (12.1.0.5 > 13.3 > 13.5)
• OEM: creating an agent golden image with new RU and security fixes for a full-scale environment
• OEM agent upgrade
• OEM: developing custom metric extensions and reports
• OEM: full monitoring setup with template collection and monitoring templates and incident rule configuration
• Upgrades: GI from 11.2.0.4 to 12.1.0.2, to 18.4, to 19.6+
• Upgrades: databases from 11.2.0.2 to 12.1.0.2, to 19.18+
• Redesign and license optimization based on Oracle SE on ODA and DBVisit
• Design of a virtualized platform based on OLVM and license optimization using hard partitioning
• Migration of databases from bare metal to OLVM

• The project aimed to reduce the scope of the annual PCI DSS audit and increase security in credit card payments.
• Credit card payments were tokenized and data and business processes adjusted so that no personal data was used in the internal IT infrastructure.
• Tools: MS Office, Jira, Confluence, draw.io, Miro, Scrum.
• Designed the tokenization of credit card payments.
• Clarified necessary changes to the architecture and data model.
• Designed and implemented process changes in the call center.
• Prepared management documentation on project status, decisions required, risks and escalations.