Data Modeling Experts in Dusseldorf

• Training AI models, evaluating images and text UI/UX, turning the provided data into insights through OpenAI Feather as part of the machine learning workflow

Technologies: OpenAI Feather

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

Technologies: Informatica IDMC, Databricks

• Building a central data model to consolidate data from CRM (ATS), online marketing, HR, and finance
• Integration of various data sources (including Sistrix, eTracker, HR Works, finance systems)
• Creation of a unified data basis for reporting and management
• Design and setup of the data structure
• Business analysis and definition of KPIs
• Coordination of data integration and alignment with business departments
• Consolidation and normalization of heterogeneous data sources
• Building an initial prototype in Excel
• Further development and implementation in Microsoft Power BI
• Central, consolidated data basis across multiple business areas
• Transparent management of CRM/ATS, marketing, HR, and finance KPIs
• Establishment of scalable BI reporting based on Power BI

• 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

• Built & maintained 10+ Power BI dashboards tracking booking, revenue & yield KPIs, reducing manual reporting effort
• Developed a centralized data model (SQL & Azure Analysis Services), integrating multiple data sources to improve reporting consistency & scalability
• Delivered ad-hoc analyses for leadership, supporting data-driven decision-making across multiple business units

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

• Supporting several agile teams in the new product development of an enterprise CRM and ERP application
• Web frontend development with Angular 17–21 (microfrontends, Domain-Driven Design, MDB-Bootstrap)
• Backend development with C# and .NET 7–10, MongoDB, MassTransit, RabbitMQ, Entity Framework Core, ElasticSearch (microservices, DDD)
• Technical feature design for assigned tasks
• Technical architecture design including forward-looking planning of AI-supported extension options
• Proof-of-concept implementation of AI-supported workflows with n8n and a locally hosted LLM (Ollama)
• Coordination with stakeholders and Product Owners, support with sprint planning

Result: Delivery of production-ready microservices and frontend modules in agile sprint cycles.

Environment: .NET 7–10 · Angular 17–21 · C# · TypeScript · OpenAPI · Microfrontends · DDD · Kubernetes · Docker · Helm · MS SQL Server · PostgreSQL · MongoDB · MassTransit · RabbitMQ · EF Core · ElasticSearch · Kibana · Azure DevOps · KeyCloak · n8n · Ollama

The Helaba ATLAS project aims to modernize core systems and make them future-proof. As part of the subproject, the existing legacy system for international payments is being replaced by a modern web-based application.

• Analysis of functional and technical requirements
• Analysis and optimization of business processes
• Process modeling
• Preparation and facilitation of workshops
• Defining project scope and prioritizing requirements
• Business process management (analysis, modeling, and optimization)
• Specification of user stories
• Designing business and authorization concepts
• Testing and acceptance
• Designing mockups in Figma
• Creating the UI/UX style guide for web applications Approach: Scrum (agile) Technologies: Jira, Confluence, MS Teams, Conceptboard, Java, Vaadin, Figma

• Further development and optimization of the PIM system (e.g. data modeling, interfaces, user experience)
• Analysis, structuring, and professional evaluation of business requirements in close coordination with business units and stakeholders
• Translating business requirements into functional and technical concepts (business & solution design)
• Designing and further developing the target PIM architecture including data models, object structures, versioning, and lifecycle concepts
• Defining interfaces, integration concepts, and data flows between PIM, eCommerce, ERP, and other systems
• Quality assurance in close collaboration with business units and the development team
• Effort estimations for analysis, design, and testing activities
• Agile, Scrum, 4APortal, SAP ERP, SAP eCommerce (Hybris)

• Mobile: Kotlin Multiplatform (KMP), Kotlin, Swift, SwiftUI, Jetpack Compose, Ktor, Room, Koin
• Backend: Spring Boot, GCP Cloud Run, GCP Load Balancer, GCP Eventarc
• Planned and developed a cloud backend architecture with Google Cloud Platform
• Developed a cross-platform architecture with Kotlin Multiplatform (KMP)
• Tech lead for comprehensive large project including webshop, two apps and omnichannel backend

• 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

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

• Developed an in-depth understanding of the business processes and data in the corporation
• Assisted in maintaining the corporate data

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