ETL Experts in Hamburg

traigo is VTG's digital rail logistics and fleet management platform. It processes large volumes of telemetry, mileage, geofence, sensor and wagon-movement events in near real time and provides operational services for rail logistics customers across Europe.

As part of Team Customer Selfcare, I worked on the design, implementation, optimisation and operation of large-scale backend services and event-driven processing pipelines — covering both feature development and operational ownership of business-critical production systems. I also regularly acted as first responder for production incidents, data inconsistencies and performance investigations across multiple distributed services.

• Design and implementation of event-driven backend services.
• Migration and replacement of legacy processing pipelines.
• Development of replay / rebuild mechanisms for large event datasets.
• High-throughput asynchronous event processing on SNS / SQS.
• Database and query optimisation for PostgreSQL and DynamoDB.
• Design of scalable read / write models and aggregation pipelines.
• Production troubleshooting and operational support.
• Performance tuning and infrastructure scaling.
• Design and stabilisation of integration and system tests.
• Technical concepts, architecture documentation, and cross-team collaboration.
• Support the further development of existing GitLab CI/CD pipelines

Geofence & Wagon Stay Processing

• Algorithm to detect vehicles within geofences (entry, exit, dwell time).
• Event sourcing with guaranteed chronological order within the affected time window.
• Refactored geofence event and wagon-stay processing logic for performance.
• Resolved race conditions and event-ordering problems in distributed services; server-side filtering, aggregation and optimised query pipelines.
• Repair and replay tooling for corrupted or inconsistent movement data.

Fleet Metadata & Mileage

• Modernised the service; migrated storage from DynamoDB to PostgreSQL to improve traceability and accelerate new features.
• Scalable mileage aggregation and replay mechanisms.
• Read / write models and optimised queries for high-volume mileage calculations.

Sensor & Telematics Integration

• Integrated telemetry and sensor processing pipelines.
• Snapshot and state-calculation logic for sensor systems.
• APIs and persistence models for wagon sensor data; data-quality improvements.
• Further development of a service using gRPC for intra-service communication.

Movement Segment Processing & Routing

• Migrated services to new movement-segment event streams.
• Built replay and rebuild tooling for segment correction.
• Optimised throughput and reliability for high-volume event processing.

Condition Monitoring & Wagon Analytics

• APIs and backend services for wagon condition monitoring.
• Brake-wear prediction processing and wagon analytics functionality.
• PostgreSQL views and optimised query models for operational dashboards.

Operational Reliability - First Responder

• Investigated production incidents and distributed-system failures; DLQ analysis, replay and operational recovery.
• Tuned database performance and AWS infrastructure under production load.
• Improved observability, monitoring and operational tooling.
• Supported rollout strategies, monitoring and post-deployment stabilisation.

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Data-analysis, Preparation, gathering and coordination of business requirements for retrieval of monthly- and long term (CLV – relevant) cost- and revenue-components per contract for a customer–base–grouping project (HUB–Project) for B2C-Postpaid-Controlling
• Concept and Implementation of cost- and revenue-KPIs calculation and corresponding CLV–reports (Oracle, Perl, SVN, MS SQL Server, MS Power BI, Serviceware Performance Analytics)
• Operational support of the HUB-Project – various ad-hoc reports, deployments, job-scheduling etc. (Oracle, SVN, BICSuite–Scheduler, DWSODA etc.)
• Analysis, implementation, retrieval and reporting of various physical and financial KPIs for B2P-Prepaid Business on an existing data-mart (Oracle, Perl)

• Restructuring for product-led growth in the field of digital user-centric tech product development language learning experiences
• Scaling empowered tech product teams
• Anti-fragile software engineering

• Planning, steering, and monitoring the Corporate Responsibility Tech Enablement project for IT
• Concept and implementation of the EUDR (EU Deforestation Regulation)
• Concept and implementation of the Eco-Design Regulation
• Continued support of projects within the Corporate Responsibility strategy
• Definition and review of guidelines (e.g. governance, success metrics) and, if needed, analysis of issues and their solutions
• Overall project management, marketing, communication, and quality assurance for the projects
• Creation of the project plan including timeline/roadmap, budget, and resources
• Ensuring compliance with budget and deadlines
• Defining guidelines for project control, methods, and priorities
• Planning and tracking resources and effort, also together with other IT teams
• Evaluation of projects and preparation of results (reporting to management)
• Identification and reduction of risks
• Regular communication with stakeholders
• Steering internal and external stakeholders and service providers (Jira, Confluence, backlog management, task tracking, SharePoint, MS 365 platform etc.)
• Development of standards and process automation

Label: Azure Cloud, Jira, Confluence, Power BI, SAP BW, AWS, Miro, Bee360, Draw.io, SharePoint, MS 365 platform, Trello etc.

• With the CPQ process change from "ETO" to "CTO", the previous tools "Selling" and "Camos CPQ" are replaced by "MS Dynamics 365" and "Configure One CPQ".
• Assessment of the current vs. target state and recommendations for action.
• Assessing the project from an external perspective (both technically and in terms of content).
• Evaluating the Configure One system in the context of LMT.
• Jointly develop a concept for further CPQ implementation and create an MVP.
• Change and stakeholder management.
• Product Owner for setting up follow-up projects.
• Handover to business units.
• Final consulting on open issues (e.g. future controlling).

As a bridge between Legal, IT, and Marketing, my responsibilities include conducting technical due diligence, documentation, and designing privacy-compliant IT functions across multiple B2P Telefónica Germany brands as part of the RAITT digitalization program. Focused on aligning web and app services with GDPR, TDDDG, and Privacy by Design & Default principles.

Core responsibilities included analysing and visualising data flows across customer journeys, validating tracking and martech integrations, and supporting IT teams in designing privacy-compliant digital architectures. Delivered documentation for internal legal assessments and maintained OneTrust governance and cookie-banner accuracy.

Services and technologies involved:

• Identity & Authentication: CIAM (OAuth2, OIDC), login and session handling, customer account services
• Analytics & Measurement: Google Analytics (GA4), Google Tag Manager (Server-side Tagging & Data Stream Design), event tracking and tagging
• Advertising & Attribution: Google Ads, Google DoubleClick / Campaign Manager, Meta Pixel, affiliate partner integrations
• Experience & Personalisation: Adobe Experience Manager (AEM), Adobe Target, Adobe Experience Platform (AEP), Adobe Edge Network
• Security & Delivery: Cloudflare (CDN), PayPal FraudNet
• Compliance & Governance: OneTrust CMP, consent categories, cookie governance, TDDDG-compliant banner logic
• General web/app services: partner APIs, data transfers, tracking schemas, consent-dependent data activation

• Architected and deployed LLM based AI agents, RAG pipelines, and vector search solutions for decision support across retail banking department.
• Developed and shipped robust AI pipelines with guardrails, error handling, monitoring, and fallback logic ensuring high reliability outcomes and compliance with data privacy.
• Developed and deployed ML models to identify transactional anomalies, improving fraud detection and risk assessment in high-volume datasets for credit risk modelling.
• Built, evaluated and fine-tuned ML models to generate propensity scores for customers used to drive personalized targeting campaigns for credit cards and personal finance/loan products.
• Developed an NLP pipeline using BERT embeddings and spaCy NER for SMS/email analysis and customer query logs.
• Trained machine learning models using Isolation Forest to classify user behaviour and detect anomalies.
• Extracted, cleaned, enriched and feature engineered datasets from different sources to build feature stores that powered ML model training.
• Led development of dashboards using Power BI, Grafana, and Prometheus to monitor model performances, KPI trends, and marketing metrics.
• Built multi-touch attribution models using logistic regression and time-decay weights to evaluate lead quality.
• Developed scalable ETL pipelines from CRM, T24, SAP, and ERP, supporting millions of monthly transactions.
• Integrated testing and CI/CD workflows for robust data pipeline deployment.

• Optimized and introduced Salesforce processes (Sales Cloud + Marketing Cloud) to support sales.
• Implemented processes for collecting requirements from various departments.
• Expanded reporting for transparency of project progress and backlog priorities.
• Managed the backlog, created user stories and acceptance criteria.

• Migration of 3 DE/AT payment iOS/Android apps and web portal to global solution
• Performed a fit gap analysis for 6 consumer apps vs. global solution
• Managed the migration project to global CWC solution, developed end-to-end tests for backend systems, Pi Planning, release planning

• Design and implementation of a big data energy reporting infrastructure for operational data from data centers in EMEA for aggregated client reporting and the energy efficiency register (EnEfG)

• Integration of data from over 50 systems, including GridVis, Robotron, Niagara, ShowIT, and Salesforce

• Developed and extended Fiori UI5/WebApps for areas such as general ledger, asset accounting, and others.
• Implemented backend logic and OData services for a new S/4 HANA system
• Analyzed the current state of SAP GUI transactions and derived suitable standard and custom developments
• Designed technical concepts and implemented custom UI5 apps in the Fiori Launchpad
• Automated OPA tests, extended and adapted standard Fiori apps
• Documented and created developer manuals in the wiki
• Conducted code reviews, approved and delivered software units via GitLab and SAP transports

• Attained AWS Certified Cloud Practitioner certification.

• Mastered Rust through self-study, including books, online courses, and open-source contributions.

• Developed a serverless web application using AWS (RDS, Lambda, Polly, Amplify) and TypeScript/React/D3, managed infrastructure with CDK.

• Continuously stayed updated with industry trends through self-education, webinars, and workshops, exploring Data Mesh and FastAPI.