Business Intelligence Experts in Cologne

• Advising primarily mid-sized companies on growth and transformation topics
• Developing business models, positioning, and strategies, including implementation plans and KPI roadmaps

Architected and maintained data products for renewable energy operations, covering wind turbine, grid-meter, and weather data. Built scalable ETL/ELT pipelines in Azure Databricks using Delta Lake (bronze/silver/gold layers) and processed data in various formats, including structured and semi-structured data. Contributed to a data quality framework supporting table and column documentation, outlier detection, and completeness metrics across all datasets within a data product. In addition, implemented a DORA KPI Databricks dashboard used across all data products. Optimized CI/CD processes in Azure DevOps to streamline deployment across development, test, and production environments.

Technology stack: Azure Databricks, PySpark, SQL, Delta Lake, Unity Catalog, Azure Data Lake, APIs, Dremio, Azure DevOps, YAML, Git, Databricks Workflows, Application Insights, Terraform, OpenAI API, Codex, LLM-assisted workflows

• Integration of medical modalities (including ultrasound) into the existing IT infrastructure (DICOM, HL7) – put into operation within the planned timeframe.
• Administration and optimization of PACS systems for efficient archiving and distribution of radiology image data across multiple locations.
• Ensuring consistent data quality and seamless interoperability in data exchange between HIS, RIS, and PACS.
• Close collaboration with medical staff to analyze and digitally optimize clinical workflows.
• Requirements management and test coordination when implementing clinical requirements in complex IT structures.

• Responsible for the architecture and development of an AI-native SaaS platform for industrial product portfolio management.
• Designed the modern data platform architecture on Azure for scalable analytics and enterprise data integration.
• Built enterprise data ingestion and transformation pipelines across complex industrial system landscapes.
• Developed graph-based representations of product structures and dependencies for analytical reasoning.
• Designed and implemented an agentic AI framework for AI-supported decision workflows.
• Built scalable analytical microservices and integrated reporting through modern BI technologies.
• Coordinated backend, AI, and frontend development across the MYNR platform stack.

• Developed data-driven performance strategies and managed cross-functional agency teams.
• Led KPI forecasting, budgeting, and implemented scalable creative solutions.
• Linked creative insights with analytics to increase marketing efficiency.
• Developed inspiring campaigns based on brand strategy and data-driven insights.
• Performed budget planning, forecasting, and full KPI accountability.
• Led and executed an agency pitch for performance marketing.

Project: Digitalization of Warehouse Processes | Building a Data Analytics Platform.

• Built a web-based workforce allocation system that digitized daily shift planning by matching worker expertise to operational zones, replacing manual coordination with a structured workflow adopted across the site, saving supervisors time on daily planning.
• Developed a real-time operational visibility dashboard giving supervisors a live view of task throughput and outstanding workload across warehouse zones throughout the day, helping reduce overtime and idle labour costs.
• Developed a slotting optimization solution to improve warehouse picking efficiency and reduce picking time per order, working directly with operations teams from concept through production deployment.

Technologies used: Python, Django, PostgreSQL, Pandas, NumPy, HTML, Java, JavaScript, Docker, Kubernetes, AWS, Power BI, GitHub Actions CI/CD, GitOps, Claude, OpenAI

• Structured analysis and evaluation of business processes

• Gathering, documenting, and prioritizing requirements

• Creating business-friendly and technically executable process models

• Use of Camunda tools

• Deriving requirements and interfaces from BPMN diagrams

• Coordination with stakeholders and business units

• Translating business requirements into technical solution designs

• Implementing efficient and tailored applications

• Systematic collection, analysis, and documentation of requirements

• Prioritizing and validating requirements in close collaboration with stakeholders

• Alignment between business and development to ensure shared objectives

• Creating use cases, user stories, and acceptance criteria

• Continuous requirements and change management throughout the project lifecycle

• Define project goals and create project plans

• Delegate tasks and monitor project progress

• Monitor budgets and inform stakeholders

• Mendix: Architecture, development, and maintenance of custom applications (Microflows, Domain Model, Security, XPath)

• Modeling Mendix workflows for process optimization

• Develop scalable apps with Mendix including REST/SOAP integration with SAP, SQL, Azure & SharePoint

• UI design for Mendix using Atlas UI, Fluent UI, HTML, CSS, JavaScript

• Develop web & mobile apps with Mendix using agile methods (Scrum, Kanban)

• Implement business logic with Mendix Microflows and Nanoflows

• Performance optimization and architecture improvements for Mendix applications

• Conduct Mendix training

• Create technical documentation and best practices for Mendix

• Coaching and mentoring for low-code development with Mendix

• Analysis of business requirements
• Integration of different data sources such as ERP systems, production systems, and external data sources
• Implementation of load processes and processing logic with MSSQL
• Data modeling and optimization of data models
• Setting up data quality management incl. data profiling with dynamic programming
• Support in designing and establishing data governance, especially in the areas of data quality management and data protection
• Support in developing BI solutions with Tableau to help decision-making processes

• Network elements, network, operational and operator-related systems
• Supporting around 20 different products (managed agile)
• Requirements analysis and management (functional and non-functional)
• Test concept and planning (scope, test phases, effort, schedule, resources, organization, etc.)
• Aligning approach with clients and service providers
• Managing and assisting in creation of test cases for system, integration and end-to-end tests
• Guiding and supporting test execution
• Defect management and planning bug fixes with external providers
• Preparing and facilitating workshops
• Regular reporting and creating automated test reports
• Further development of agile testing methodology and configuration of supporting tools
• Conceptual support in developing a quality seal for rating product and service quality of internal and external providers
• Requirements engineering based on ISO/IEC 25010, Scrum, SaFE
• BMC Remedy, Atlassian Confluence, Atlassian Jira (including plugins Xray, Structure), Microsoft Office (incl. Visio), Obsidian, doxis document management system, Gitlab, Obsidian

Industry: digital sovereignty, public sector

Content:

• Project steering (teams: consulting, development, testing, deployment/operations)

Products and standards:

• Jira, Confluence, Asana, Miro, Mural
• Open Source, Keycloak, Open Xchange, ownCloud

• Overall responsibility for platform transformation across ERP, CRM, PIM, and AI-driven process automation
• ERP transformation: Implementing and migrating to Microsoft Dynamics 365 Business Central
• CRM & growth stack: Implementing HubSpot as the central CRM and a platform for lead and marketing automation
• Product data & commerce enablement: Introducing an ePIM to scale category management and digital commerce processes
• AI-driven process automation: Designing and implementing agent-based AI workflows to automate processes in business services, accounting, tender management, and marketing
• Building a scalable platform organization including product development, DevOps, UX, cloud engineering, and corporate IT
• Implementing modern product and portfolio governance (e.g., OKRs, portfolio boards, value-based roadmaps) to manage technology-driven initiatives
• Harmonizing heterogeneous system landscapes and transforming them into a modular, scalable platform architecture (ERP, CRM, PIM, integrated customer journeys)
• Coaching and developing product owners, tech leads, delivery managers, and UX teams to build a scalable product organization

• Transition of processes from garage-style to series production
• Establishment of financial processes including monthly reporting to the Chinese parent company
• Development of long-term planning (5/10 years) and budgets for 2024 and 2025
• Ensuring sufficient financing
• Creation and implementation of a restructuring plan with over 60% reduction in staff and costs

• Built a reporting structure with group brands, taking development platforms and global requirements into account; stakeholder management
• Identified needed KPIs, data sources and user requirements
• Developed, aligned and operationally implemented KPIs, aligned milestone plans
• Collected requirements for a heterogeneous tool landscape, interviewed stakeholders
• Managed implementation of Power BI dashboards, ensured technical operation
• Presented results at board level, moderated workshops, mitigated project risks

• Further training to become a certified AI expert in the company
• Fundamentals of AI
• AI tools
• Prompt engineering (creation of professional prompts)
• (Advanced) Process automation with AI and make.com
• AI in marketing and sales
• Legally compliant use of AI in companies
• Intelligent knowledge management
• AI in customer management
• Developing AI guidelines for the company
• AI integration into the company