Amazon Redshift Experts in Germany

Led the end-to-end integration and migration architecture for decommissioning SAP IS-U market communication and transitioning to Salesforce Marketing Cloud (SFMC) with E.ON IT Services — covering regulated EDIFACT market messaging, a three-phase data migration (transfer of market message inventory after cutover), redesign of market communication processes, and full GDPR and German energy-market compliance.

• Designed the three-tier target architecture (SAP IS-U → NScale B2B gateway → SFMC) processing 50,000–100,000 EDIFACT messages daily within sub-5-minute SLAs.
• Architected the three-phase data migration: 36 months of historical data, zero-loss cutover of in-flight market messages, and near-real-time CDC synchronization.
• Delivered secure, BDEW/GDPR-compliant integration (AS2/OFTP2, RFC/IDoc, REST APIs, OAuth 2.0, Azure AD, AWS S3) achieving >99.5% uptime, <0.1% migration discrepancy, and RTO <4 hours.
• Applied BPMN to model and optimize the market communication processes.

Technologies: SAP IS-U, NScale, Salesforce Marketing Cloud, EDIFACT, OAuth 2.0, Azure AD, AWS S3, BPMN, Jira, Confluence, Draw.io

Development of AI and traditional models to analyze medical and patient data, including medication analyses, diagnosis analyses, forecasts, procedure analyses, dosage analyses, comorbidity analyses, prescription analyses, patient potential analyses, referral profile analyses, and prescription analyses. Analyses in the field of Real World Evidence.

Healthcare IT, pharmaceutical industry

Tasks, responsibilities:

• Gathering customer requirements
• Planning the subproject
• Designing and defining KPIs
• Designing and developing models and visualizations of results using customer dashboards
• Developing and implementing data warehouse adaptations
• Deriving recommendations for action

Methods, technologies:

• Simulation
• Artificial intelligence
• Python
• R
• SQL
• Microsoft Power BI
• Amazon Web Services
• Elasticsearch
• PostgreSQL
• Databricks
• Multivariate statistics

Further Development of the Integrated Capacity Management Platform InKa

Rail Infrastructure

• Power BI shared datasets and reports via DirectQuery on Amazon Redshift (timetable, construction and capacity data)
• Automated report testing with Playwright in Docker containers, version control with GitLab
• Concept and implementation of user communication (information page, changelog, known bugs)

Initial Situation:

The integrated capacity management platform (InKa) is a monitoring and analysis platform for data from timetable and capacity management: customer orders, infrastructure, timetable operations, construction, as well as route capacity and width. The data is stored and linked in a structured data warehouse. This makes it possible to create complex KPIs across different source systems and display current and future route utilization as well as construction activity across the network. The goal is to improve strategic, medium-term and intra-year planning and provide users with easy access to capacity management analyses.

Measures:

• Enablement: Introduction of Power BI with training and workshops for development teams.
• Consulting & Design: Problem analysis, concepts and solution consulting for reporting requirements; implementation of reporting solution plans.
• Data Model: Development of shared datasets with DirectQuery on Amazon Redshift and import tables; DAX measures for utilization and capacity KPIs.
• Development: Data analysis, data transformation and visualization in Power BI; extension and migration of business applications to Power BI; AI-supported development in VS Code with GitHub Copilot.
• Test Automation: Automated testing of Power BI reports with Playwright; setup of the test environment in Docker containers.
• User Communication: Concept and implementation of a central information page with hot news, changelog and known bugs, access from reports with report filters, updates via Power Automate.
• Deployment: Management of Power BI Deployment Pipelines across the DEV, TEST and PROD environments.
• Agile Working: Work in an agile team according to SAFe (Scaled Agile Framework); refinement of user stories and features including effort estimates in Jira; version control with Git and GitLab.
• Quality & Documentation: Reviews for quality assurance, error analysis and resolution, technical documentation in AsciiDoc and Confluence.

Technologies: Power BI, DAX, Power Query, DirectQuery, Amazon Redshift, Git / GitLab, Deployment Pipelines, Playwright, Docker, AsciiDoc, Power Automate, Jira, Confluence, VS Code with GitHub Copilot, SAFe

Results:

• Capacity management KPIs from multiple source systems combined on one platform
• Transparency regarding current and future route utilization and construction activity across the network
• Easy access to analyses for users
• Automated regression testing of Power BI reports
• User communication implemented: central information page with hot news, changelog and known bugs, directly accessible from the reports

I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.

I delivered following projects and engagements as a freelancer.

• Data Migration of CRM System for AL-FA Objekt Service Gmbh
• Microsoft Software Resales Partnership

I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer

Technical Focus Areas

• Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
• DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
• Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
• MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
• Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.

• Architected an enterprise Fabric-based data-product governance framework, authoring data contracts and schema-validation KPIs to enforce completeness, freshness and SLA standards across reporting data products.
• Operationalized pipeline observability by integrating Dagster orchestration data into automated data-health reporting, proactively validating data integrity and pipeline reliability before production reporting layers refresh.
• Established BI-as-Code and end-to-end governance through Git-based version control, CI/CD and Alpha→GA release management, strengthening lineage, schema-drift detection and production change traceability.

• Product Analytics, Mobile App Tracking & Tracking Governance (B2C Mobility App) – agile project management (Scrum/Kanban)
• Product Ownership for Product Analytics and Mobile App Tracking of the EnBW mobility+ app; gathering, prioritizing, and translating business requirements into actionable concepts and Azure DevOps user stories with acceptance criteria.
• Derivation of tracking requirements when introducing new app features (including Resilient Map), definition of tracking parameters (screens, events, custom definitions), and ensuring privacy-compliant tracking (Firebase, GA4, Adjust) based on the tracking concept.
• Design and adaptation of dashboards and funnel reporting for campaigns (GA4 validation, onboarding and order flow analyses, conversion funnels, charging start flow) to identify drop-off points and optimization potential.
• Management of the technical raw data export (Adjust to BigQuery) and connection to the data warehouse/data lakehouse, including data mapping; collaboration with international development teams, Data Engineering, Marketing/Sales, and Product Management.
• Establishment of standardized tracking architecture, naming conventions, and governance; analysis and expansion of tracking (new features and “blind spots”), test design, handover to testers, and quality assurance and approval before releases; documentation in Conceptboard.

• Architected and deployed private cloud data platform on VMware vSphere, integrating Greenplum MPP, Apache Kafka, Kubernetes, and Apache Solr, and developed real-time ingestion pipelines with Kafka Connect and Schema Registry.
• Led Oracle Exadata to Greenplum migration, rearchitected data models, optimized storage, implemented RabbitMQ with Debezium for CDC, and deployed VectorDB for Generative AI.
• Designed and executed multi-cloud migration PoC across AWS, Azure, and GCP, defined KPIs for throughput, latency, and cost efficiency, executed bulk data transfers, validated analytics and streaming workloads, and delivered full-scale architecture recommendations.
• Assessed legacy on-premises infrastructure and designed modern cloud-native data platforms using Greenplum and containerized microservices, advising on scalability, disaster recovery, and high-availability.

Led FP&A tech transformation for a 9-figure business – from resolving legacy technical debt to leading AI-native EPM implementation

• Driving end-to-end FP&A transformation, from architecture redesign through EPM tool selection to rollout
• Ran evaluation of 12+ EPM platforms, from vendor negotiation to selection framework tied to long-term planning
• Diagnosed constraints in financial planning architecture, presented findings to the CFO, and secured executive mandate to redesign FP&A infrastructure from the ground up

• This project involved extraction of intelligence data to support report writing for a company that provides geopolitical, global, commercial intelligence. The data have been gathered from a number of resources (interview transcripts, online data, internal documents), and then a knowledge base has been build from it. This was the basis of a complex RAG system, that was evaluated against a golden dataset. Agents have been used to find out the contradicting intelligence, the statements supporting each other, and to store back the generated knowledge.

Used: Python, RAG, LangGraph, LangChain, deepeval, MCP

• Leading enterprise BI transformation across Power BI & Microsoft Fabric, delivering scalable data models, automated reporting, and high-performance analytics solutions for commercial and operational leadership.
• Building and optimizing Power BI Dataflows, Fabric Lakehouse datasets, semantic models, and automated reporting pipelines to improve data scalability, governance, and reporting performance.
• Driving dashboard modernization and KPI governance by translating complex business requirements into executive-level insights, interactive visualizations, and decision-ready analytics.
• Designing end-to-end Microsoft Fabric architectures integrating data ingestion, transformation, virtualization, and enterprise reporting across cross-functional business domains with SAP BW to Qlik to Power BI migration.
• Delivering AI-enabled reporting capabilities, threshold-based alerting, and automation frameworks within the Power BI ecosystem to accelerate business decision-making.
• Partnering with commercial leadership, analytics teams, and IT stakeholders to standardize KPIs, optimize BI strategy, and deliver scalable, business-critical reporting solutions.
• Recognized for combining strong stakeholder leadership, technical architecture expertise, and business-driven analytics to deliver impactful enterprise BI transformation initiatives.

• Task Engineering: Evaluating Coding Agents.
• Asset Creation: Building realistic task environments using datasets and files in German. Crucially, these assets must remain in the target language to genuinely measure multilingual handling.
• Prompting & Translation: finding failure points where AI does not work, in German.
• Implementation & Verification: Supporting the development of robust solutions (reference implementations) and write highly reliable, deterministic verifier scripts (using rubric-based judging only when strictly necessary).
• Calibration & Execution: Analyze execution logs and calibrate task difficulty (Easy to Very Hard) using standard Terminal-Bench run configurations against various model tiers (Haiku, Opus).
• Quality Assurance: Participation in a rigorous, 4-layer human quality control process (creation, human review, calibration review, and audit) alongside automated LLM-based checks to ensure fairness, grammatical accuracy, and benchmark integrity.
• Linguistic Review: Reviewing AI benchmark tasks across Hindi, Arabic, Japanese, Chinese, Czech and Turkish.

CRM and revenue platform managing billing and subscription workflows.

• Scaled payments infrastructure across data products, direct debit expansion and automated abuse prevention, generating $416K in annualized operational savings ($8K/week) by eliminating redundant gateway calls.
• Owned backlog and sprint execution for autonomous checkout abuse detection pipelines, designing real-time risk guardrails and velocity heuristics that blocked card testing attacks.
• Architected enterprise billing migrator user stories and data reconciliation mechanisms, achieving zero-downtime subscription state transitions and cutting $60K in infrastructure overhead.
• Expanded European direct debit (SEPA) payment capabilities, managing cross-squad API dependencies and automated webhook error-handling to eliminate checkout friction.

Specialize in turning complex data from diverse environments into actionable business value through compelling visual storytelling. I am an expert in generating actionable insights and presenting recommendations to business stakeholders. My technical proficiency in SQL, Python, and leading data visualization tools like Tableau and Power BI allows me to deliver a new generation of self-service tools and analytics services.

• Data Visualization & Storytelling: Created impactful data visualizations and dashboards in Tableau and Power BI, effectively communicating findings and presenting actionable recommendations to C-suite stakeholders and business leaders.
• Stakeholder Management: Built effective working relationships with key business stakeholders, data engineers, and other partners to achieve common data-driven goals and targets.
• Insights & Recommendations: Generated actionable insights from complex data analysis for funnel conversion, marketing performance, and ROI, directly influencing business performance and strategy.
• Data Collaboration & Empowerment: Worked closely with cross-functional teams to support the ongoing data needs of internal partners, helping to optimize internal data processes and workflows.
• BI & Data Expertise: Applied extensive experience in data modeling, data collection, data mining, and analysis to deliver end-to-end analytical solutions from stakeholder discovery to production.

• Teaching Introduction to Data Science Course in MBA Programme