Data Warehouse Experts

• Development of a production-ready Enterprise AI solution for the automated processing of invoices and business documents
• Integration of Azure AI Document Intelligence and LLM technologies into existing business processes
• Development of robust REST APIs for automated document processing and system integration
• Extraction, validation, and storage of structured invoice data in Azure SQL as a base for analytics and machine learning models
• Development of an AI-based recommendation engine with machine learning and deep learning to generate personalized product recommendations based on historical purchase data
• Implementation of logging, monitoring, error handling, and validation mechanisms for stable production use
• Collaboration with business teams to define business rules and integrate the solution into existing enterprise processes

Technologies: Python, Azure AI Document Intelligence, Azure OpenAI, Azure SQL Database, REST APIs, Machine Learning, Deep Learning, OCR, Pandas, JSON, Workflow Automation

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

• IT systems: Azure DevOps, SharePoint, Opal/Repost, JustinMind, Monday, SAP

• Analysis of requirements for branch software

• Coordination of intercultural teams

• Partly agile project organization

• Master data management / DMS

• UI/UX design and mockup creation

• Requirements documentation

• Digitalization of signatures

• Stakeholder management and workshop facilitation

• Billing/bank transfer

• Business analysis / requirements engineering

Concept and implementation of a unified-commerce platform for SMEs for selling and building multi-product bundles

Successes: On-time concept, delivery, and customer acceptance of a 100% functional, CPQ-based buy flow process for configuring and selling multi-product bundles within the given 90-day time frame. Successfully tested integration of various interface services for the following areas: customer search, customer data enrichment, address validation, service qualification, phone number validation, credit check, appointment selection, and quote-to-order transition.

Responsibilities:

• Strategic target delivery: deriving and implementing strategic customer goals (e.g. release content, business value).
• Backlog management: creating and refining backlog items (initiatives, epics, user stories, defects) in close coordination with the project team and customer.
• Prioritization & releases: responsibility for prioritizing the product backlog and delivering defined release goals.
• Deliverable tracking: tracking work results on both the supplier and customer side.
• Roadmap & release planning: developing and implementing roadmaps and release plans together with the customer.
• Scope responsibility: responsibility for the contractually agreed scope of services.
• Claim management: active claim and change management toward the customer.
• Team coordination: steering and coordinating the development team.
• Using synergies: making use of synergies between customer projects and product development.
• Offer preparation: preparing offers (with supervision) and presenting them on site to customers and partners.

Skills: development, communication, and implementation of product visions; product backlog management; stakeholder management; regular reporting to management and steering committees; requirements analysis & engineering; planning and documenting workshops; functional leadership and coordination of (distributed) project teams and external service providers; epic management; user story specifications; creating use cases, support with software tests and user acceptance testing (UAT); release management and sprint planning; design of target processes; process optimization; planning, concept, and specification of interfaces to existing and new systems; identification, assessment, and steering of project risks; active claim and change management; facilitation of sprint planning and reviews; data migration; Scrum; Kanban; REST API; JSON; XML; BPMN; UML; Jira; Confluence

• New connection of the product interfaces of the Financial Data Warehouse (FDW) directly to the Abacus 360 native interfaces
• IT environment: PC, client-server, Citrix remote client, Oracle DB
• Mapping of FDW outbound to Abacus 360 Native
• Analysis of requirements documents, business concepts, and existing interface rules
• Definition of new FDW rules for outbound to Abacus 360
• Adjustment of test scripts for the new interfaces
• Execution of tests to ensure correct data delivery and processing

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.

• Definition and setup of the subject areas
• Building a governance model for the department with the areas of responsibility
• IT strategy, project management, process management, and quality and sustainability management
• Developing a communication strategy for the group
• Creating an IT strategy
• Designing templates, guidelines, and processes for standardized work
• Capturing strategic guardrails and grouping ongoing projects – deriving a roadmap for strategic planning
• Reviewing ongoing projects
• Creating staffing and capacity calculations
• Defining job profiles

• Technical leadership and further development of a team of 28 IT staff (internal & external) in the areas HelpDesk/HelpLine, RHEL (Red Hat), MUREX (trading system & applications), SAP basis operations
• Managing external service providers (including FI-TS for SAP basis operations)
• Personnel, resource and budget planning for the IT department and projects
• Introducing and establishing regular communication formats (weekly status meetings, team and cross-department meetings)
• Ensuring application operations in a hybrid environment (Windows/Linux with database and web/application servers)
• Supporting transformation projects to modernize the application landscape (e.g. DevOps approaches)
• Setting up and implementing a digital IT procurement for hardware & software (e.g. with DELL)
• Developing and managing the "IT Operations DOS" department based on corporate strategy
• Preparing management reports & decision papers on IT projects, optimization potential and automation opportunities
• Representing the department in the advisory boards of the Rentenbank and ensuring regulatory compliance (BaFin §44, GDPR, BSI, MaRisk)

Scope: Embedded as FP&A Data & AI Architect within the Finance function of a major European refrigeration manufacturer, leading the transformation of manual, fragmented financial reporting into an automated, governance-driven intelligence platform. Driving the shift from Excel-based controlling to structured data architecture, Power BI analytics, and AI-assisted financial operations.

Financial Data Integrity & ERP Governance

• Initiated and led GL vs. subledger reconciliation investigations, identifying and resolving structural mismatches between General Ledger and subledger data that had gone undetected prior to engagement
• Conducted asset analysis to identify items missing from General Ledger postings, surfacing gaps in fixed asset tracking and period-end completeness
• Validated SAP reports, establishing baseline data quality standards for Finance team consumption
• Established systematic SAP data validation framework ensuring ongoing integrity between ERP postings and downstream reporting outputs

Finance Reporting Transformation

• Designed and implemented a structured Transformation Project approach for converting manual Finance reports into fully automated processes
• Created and owns the Data Reporting Audit Log; a centralized tracking system capturing report owners, stakeholders, data sources, manual effort estimates, and automation opportunity scores across the Finance function
• Mapped the full reporting landscape identifying quick-win automation targets and strategic Power BI migration candidates
• Actively reducing manual Excel and PowerPoint dependency across FP&A workflows; replacing point-in-time snapshots with live, governed data models

Power BI & Analytics Enablement

• Introduced and presented Power BI as the strategic reporting platform to Finance leadership, building internal buy-in for the BI transformation roadmap
• Designed initial Power BI architecture aligned with SAP, Salesforce and Oracle data structures and FP&A reporting requirements
• Established report ownership, governance documentation, and data lineage standards enabling sustainable self-service analytics across the Finance team

Transformation Infrastructure & Collaboration

• Configured and deployed Jira as the transformation project management hub, establishing structured sprint workflows, backlog management, and progress visibility for Finance IT initiatives
• Proposed and initiated a dedicated FP&A Communication & Transformation Hub, a structured cross-functional forum aligning Finance, IT, and business stakeholders around the reporting transformation roadmap
• Positioned the Finance function as an active driver of data governance and digital transformation within the broader organization

Outcomes

• GL/subledger reconciliation gaps identified and investigation framework established within first two weeks of engagement
• Data Reporting Audit Log deployed; first structured inventory of Finance reporting landscape in company history
• Power BI transformation roadmap presented and approved by Finance leadership
• Jira-based project governance live; Finance transformation now tracked with full sprint visibility

Technologies: SAP FI/CO · Power BI · DAX · SQL · Excel (advanced) · Power Query (M) · Power Automate · VBA · Jira · Microsoft 365 · SharePoint · Salesforce (Sales Data) · Oracle HCM · Python

• Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
• Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
• Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
• Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
• Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
• Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
• Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
• Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
• Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

Tasks & results:

• Developed measures to improve management control during a restructuring program (approx. 80 people involved)
• Set up the PMO to enforce transparency, reporting, and data-driven decisions
• Developed an integration template to move team silos (software, field installation, supply chain) into a cross-functional project structure with lean tracking systems for timeline, progress, and KPIs
• Technologies / methods: PMO setup, KPI tracking, project organization, Jira, Confluence

• Responsible for introducing agile methods within the Interface & Integration Team (2 Scrum Teams)
• Planning and delivering trainings in agile methods
• Facilitating workshops and Scrum events
• Removing impediments
• Increasing sprint performance

Tools: Fabric, AWS, dbt, Power BI, SQL, DWH, R, Python

• Supported customers in implementing an architecture design for extracting and preparing data
• Planned the design and implementation of the BI and DWH platform
• Ensured the scalability and performance of the data platform

• -- ENGLISH Version (Deutsche Version unten) ---

Experience

• Ex-BCG Platinion: 14 years as Manager & Chief IT Architect, leading large-scale IT transformations in complex group structures
• 20+ years of C-level consulting across AI/IT strategy, enterprise architecture, IT organization, transformation, M&A due diligence, project recovery, and interim management
• IT leadership experience with cross-functional, intercultural teams of up to 100+ people
• Hands-on background in software engineering, IT architecture, and project management
• Fortune Europe 500 focus; numerous international projects; SME and start-up experience

Core services:

• IT strategy, enterprise architecture (EAM), target architectures and roadmaps
• PE/M&A/carve-out IT/tech due diligence, asset valuation, cost estimation
• GenAI transformation, process automation, and AI governance
• IT reorganization, target operating model (TOM), agile transformation
• IT governance, development and ITSM process optimization (BizDevOps, SAFe)
• Review and recovery of critical large-scale IT programs
• Planning and steering of transformation programs and IT project portfolios
• IT vendor and platform selection (RfI / RfP)
• Coaching & Interim management

Industries (selection): Insurance, financial services & banking, energy & utilities, telecommunications, retail & consumer goods, logistics, media, industry & engineering, healthcare, professional services

Projects (selection):

• M&A Buy-side IT/Tech Due Diligence of an Acquisition in the Energy Sector (Utility, Smart Home) — AI-augmented with Anthropic Claude

• AI Initiative for LLM-Based Optimisation and Automation of Sales and Billing Processes

• Interim management Enterprise Architecture & group target architecture/roadmap development (METRO)

• Reorganization: Design and introduction of agile IT target operating model at international wholesale group (METRO)

• Design and implementation of agile BizDevOps target operating model (E.ON Grid Solutions)

• Platform/vendor selection for renewal of core insurance solution of start-up (ELEMENT Insurance)

• Establishment of project assurance capability and review/recovery of critical transformation projects (ERGO)

• Enterprise architecture management and development of divisional/solution architectures (Deutsche Post DHL)

• Strategic pricing architecture decisions in digital sales application landscape (E.ON Energie)

• IT due diligence: Architecture evaluation and monetary valuation of IT assets (ProSiebenSAT.1 Media)

• Interim management of group-wide security/compliance programme (ERGO)

• Enabling an application landscape for different sales organizations and product structures (E.ON Energie)

• Realignment of business/IT strategy and InsurTech platform selection (RfI, RfP) (nexible, ERGO Digital Ventures)

• Stabilization/optimization of an agile/SAFe business/IT DevOps landscape transformation (Lufthansa AirPlus)

• Process optimization and design/management of digitization and robotics introduction in power plants (RWE Nuclear)

• BSS target architecture development for fixed/mobile networks convergence (Deutsche Telekom)

• Optimization of IT organization model and methodology in application development and testing (Deutsche Telekom)

• Evaluation of fulfillment of a general contractor agreement for run-off/migration of contract portfolios (ERGO)

• -- DEUTSCHE Version (English version above) ---

Experience

• Ex-BCG Platinion: 14 years of strategy and implementation of large-scale IT transformations in complex corporate structures (Manager & Chief IT Architect)
• 20+ years of C-level-adjacent IT consulting: IT strategy, enterprise architecture, IT organization, transformation, due diligence, project recovery, and interim management
• IT leadership responsibility for cross-functional, intercultural teams of up to 100+ people
• Solid hands-on experience in software development, IT architecture, and project management
• Focus on Fortune Europe 500, numerous international projects; SME and start-up experience

Industries: insurance · financial services & banking · energy · telecommunications · retail & consumer goods · industry & engineering · logistics · media · healthcare

Services (focus areas):

• IT strategy, enterprise architecture (EAM), IT landscape target visions and roadmaps
• M&A/carve-out IT/tech due diligence, asset valuation, and cost estimation
• GenAI transformation, process automation, and AI governance
• IT reorganization, target operating model (TOM), agile transformation
• IT governance, development and ITSM processes (BizDevOps, SAFe)
• Review and recovery of critical large-scale IT projects
• Planning/steering of transformation programs and IT project portfolios
• IT service provider/platform selection (RfI, RfP)
• IT project management (agile, classic, hybrid)
• Coaching & interim management

Projects (selection):

• M&A buyer-side IT/tech due diligence of an acquisition in the energy sector (utility, smart home) — AI-augmented with Anthropic Claude
• AI initiative for LLM-supported optimization and automation of sales and billing processes
• Interim management of Enterprise Architecture and development of group target architecture in wholesale (METRO)
• Reorganization: design and introduction of an agile IT target operating model (TOM) at an international wholesale group (METRO)
• IT reorganization: introduction of an agile BizDevOps target operating model (TOM) at an energy group (E.ON Grid Solutions)
• Platform selection / vendor selection for renewal of the core insurance solution of a B2B2C start-up (ELEMENT Insurance)
• Process optimization, digitalization, and introduction of robotics in power plants (RWE Nuclear)
• Assessment of fulfillment of a general contractor agreement for run-off/migration of life insurance portfolios (ERGO)
• Business/IT strategy and InsurTech platform selection for a digital insurer/start-up (nexible, ERGO Digital Ventures)
• Enabling an energy application landscape for multiple sales units (E.ON Energie)
• Strategic architecture decisions in price management of a digital sales application landscape at an energy group (E.ON Energie)
• Stabilization/optimization of an agile DevOps IT transformation in business travel and payment management (Lufthansa AirPlus)
• Interim management in a group-wide security and compliance program of a global insurer (ERGO)
• Building project assurance capability as well as review and optimization/recovery of critical IT projects in an insurance group (ERGO)
• Building enterprise architecture management and development of domain and solution architectures for a logistics group (Deutsche Post DHL)
• M&A IT due diligence – evaluation and valuation of IT assets in the media sector (ProSiebenSAT.1 Media)
• Development of BSS target architecture and roadmap for fixed/mobile convergence (Deutsche Telekom)
• Optimization of IT governance/organization and methodology in application development and testing at a telecommunications group (Deutsche Telekom)