Data Visualization Expert in Cologne

PLANT-MY-TREE®-per-order

The application enables Shopify merchants to automatically place tree-planting orders for every incoming order. By integrating ecological contributions directly into the purchase process, the manual effort for tracking and billing reforestation initiatives is eliminated. The system increases transparency for end customers through real-time visualizations of the ecological impact directly in the storefront. The architecture is based on a modular monolith with Spring Boot in the backend and an integrated React app inside the Shopify admin area. The solution uses webhooks to capture order data in an event-driven way and integrates the weclapp ERP system for automated monthly invoicing. An app proxy mechanism provides dynamic statistics such as CO2 compensation and planted trees without any performance loss for the merchant shop.

Tasks:

• Design of the modular software architecture based on Spring Modulith to ensure high maintainability
• Development of the event-driven business logic for evaluating Shopify orders via webhooks
• Implementation of automated invoicing by connecting the weclapp REST API
• Building the frontend using React Router and Shopify App Bridge for native integration
• Design of the database model and implementation of the persistence layer with JPA/Hibernate and Prisma
• Integration of internationalization processes for global use in the frontend and email communication
• Automation of deployment processes using Docker and GitLab CI/CD

Project skills: Java 25, Spring Boot, Spring Security, Spring Modulith, Hibernate, JPA, REST API, PostgreSQL, Maven, Liquibase, React, TypeScript, React Router, Vite, Node.js, Prisma, Zod, Docker, Docker Compose, GitLab CI/CD, Shopify CLI, Shopify App Bridge, Polaris, weclapp, i18next, Lombok, Vitest

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

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

• 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

• Coordinated feedback and milestones with international co-authors to streamline publication
• Directed data curation and final analysis using Python and Matlab
• Accelerated the final publication timeline by efficiently managing figure preparation and data traceability

trategic Requirements Management: Steered user-centric product development for highly complex analytical platforms in close coordination with Product Owners.

Team Enablement: Provided technical supervision and UX alignment across multiple development teams to ensure consistent implementation.

Translation of Requirements: Translated complex business logic into intuitive, user-centric concepts and workflows along the entire customer journey.

End-to-End Design: Led ideation, conceptualization, and UI design for UX projects, accounting for cross-functional requirements.

Quality Assurance: Ensured strict adherence to and verification of usability standards and web accessibility (WCAG) within a B2B context.

Stakeholder Management: Confidently presented and defended design solutions to senior management and specialized departments.

Cross-functional Collaboration: Acted as the primary interface between Product, Engineering, and Business to resolve conflicting objectives within the design process.

• Conducted GCP/GLP audits, compiled quality metrics, supported inspection and documentation for regulatory submissions
• Collaborated with clinical, technical, regulatory, study execution, and management teams
• Reviewed systems and processes in preparation for EU and global regulatory filings
• Edited quality and regulatory documents for internal and external review

• Implementation of custom reporting solutions for financial KPIs aligned with specific business requirements

• Development of a machine learning application that achieved a 250% performance improvement

• Data Architect "Production-Oriented Quality Assurance" (03/2024–09/2024):

• Design and implementation of an analytics platform to detect quality deviations in manufacturing

• Build of a scalable data lakehouse architecture on Databricks in combination with SAP ERP data via SAP Datasphere

• Close collaboration with the SAP team to harmonize bill of materials and order data

• Visualization of KPIs to support shopfloor management

• Lead Data Engineer "Sales Performance Monitoring" (08/2023–12/2023):

• Design and implementation of a Databricks-based platform for analyzing sales figures and promotion effects

• Integration of SAP SD data via SAP BW/4HANA

• Use of Azure DevOps to orchestrate ETL jobs and deploy workflows

• Technical Project Lead "Cloud Migration & Data Strategy" (02/2023–05/2023):

• Migration of a heterogeneous data warehouse stack to a modern cloud architecture on Azure with Databricks as the central processing platform

• Development of a governance-compliant data architecture to integrate SAP financial data and non-SAP sources

Technologies: Databricks, Delta Lake, Python, SAP Datasphere, Azure DevOps, PowerBI, SQL

• Acted as the primary bridge between Legal, Engineering, and Business units to ensure zero compliance violations while maintaining product velocity.

• Led the development of a GDPR-compliant AI aggregator platform, managing a roadmap that balances legal constraints with aggressive feature delivery.

• Scaled the engineering team from 4 to 9 developers, establishing hiring protocols and technical onboarding processes to support rapid product iteration.

• Boosted the development process by introducing structured sprint cycles and backlog refinement, resulting in a 20% reduction in feature delivery time.

• Architected and prototyped agentic AI workflows with n8n and RAG pipelines on Langchain.

• Technical project management, requirements management, and design to guide the data team in developing a predictive maintenance model for DB InfraGO's maintenance planning.
• Statistical modeling and analysis programming with R Studio for fault analysis in preventive maintenance: multivariate modeling using quasi-Poisson, negative binomial, lasso, offset, splines, RandomForest.
• Implementation of various R Shiny dashboards.
• Sparring partner and requirements management for data engineering, data modeling, and ETL pipeline in Tableau Prep.

• Generated and analysed large-scale RNA-seq data (>800 samples) using R, Python, and high-performance computing (HPC/Linux) systems.
• Integrated multi-omics data (genomic, transcriptomic, and phenotypic); applied Bayesian approaches and machine learning to study gene expression variation and inheritance of complex traits.
• Mentored B.Sc. and M.Sc. students in experimental design, programming in R/Python/Bash, biostatistics, data visualisation and scientific presentations.

• Extraction and transformation of relevant data from the SAP system developed for the bank and consolidation into the existing reporting environment
• Integration of the data into the existing BI model (extending the star schema to a galaxy schema) for generating the funding committee report and the business development report
• Ensuring data quality
• Knowledge transfer to department staff (SAP, SQL database, Power Pivot, DAX)