Microsoft Power Automate Experts in Germany

• Designed and developed a production-ready data platform based on Microsoft Fabric for an e-commerce company
• Built a scalable Medallion Architecture (Bronze, Silver, Gold) with Lakehouse and Delta Lake as the foundation for analytics and AI applications
• Developed a metadata-driven ETL platform with PySpark and a generic Incremental Loading Framework (SQL Server → Bronze → Silver → Gold)
• Developed reusable components for Microsoft Fabric Notebooks to standardize data integration, transformation, and validation
• Implemented automated data pipelines including monitoring, logging, error handling, and Delta MERGE strategies for stable production operations
• Built a business layer architecture for reporting, data warehousing, and reusable data products
• Integrated heterogeneous data sources via SQL Server, REST APIs, Amazon SP API, and Google Analytics 4
• Worked closely with business departments to analyze business requirements and translate them into scalable data architectures

Technologies: Microsoft Fabric, PySpark, Python, SQL Server, Delta Lake, Lakehouse, OneLake, Data Factory, Data Warehouse, REST APIs, Amazon SP-API, Google Analytics 4

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

The client operates a SaaS platform for managing rail and intermodal transport (Rail-Flow Transport Management Platform).

For two of its customers, it was looking for a 3-month project management replacement. Both customers offer rail and intermodal transport services. Implementation progress differs: one customer is already live and wanted its Phase 2 enhancements implemented; the other customer is implementing its MVP and entering an intensive testing phase.

As part of the assignment, project management was taken over, including management of the internal development team (offshore Turkey).

• Took over complete project management for 2 customer projects, including the roles of Product Owner and Co-Scrum Master
• Managed agile implementation teams consisting of business analysts, implementation consultants, developers (offshore) and QA staff
• Ensured compliance with and further development of project governance
• Planning and rollout management: creation and maintenance of project and rollout plans as well as coordination of role assignments with the client’s management
• Requirements and change management: management of contractual requirements, bugs and changes
• Customer and project communication: organization and moderation of status meetings and steering committees
• Identification of project risks, initiation of countermeasures and escalation
• Ensured correct and timely invoicing for project services together with Finance

Methods: Scheduling (forward- and backward-based), including milestone planning, structured interviews, multi-project management (in English)

Tools / Technologies: Jira, Confluence / Atlas, Claude (Skills, Artifacts), MS Outlook

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

• Built a scalable nearshore IT developer hub (Croatia, Czech Republic, Poland) as an independent company through a BOT model (Build – Operate – Transfer)
• Identified, selected, and managed full-service agencies; introduced management and control mechanisms, including KPIs, SLAs, and regular service reviews
• Prepared and reviewed data processing agreements and framework contracts in coordination with Legal & Compliance; integrated regulatory requirements (including KRITIS) into process design
• Advised on cloud vs. on-premise strategies, data storage, and authorization concepts; supported Procurement with tendering and service provider evaluations
• Managed change and process harmonization between internal teams and nearshore partners; reported to executive management, CFO, and CIO

Result: Scalable IT developer hub with an audit-ready governance model, reduced operating costs, and accelerated product development.

Objective: Consulting in IT project management for interface management, with the aim of driving the structural transformation toward global systems in the cloud

Activities:

• Process design in the source system: Analyzing and developing processes for the efficient provision of data from source systems
• Data definition: Precisely defining the data records to be transferred and ensuring data quality
• Process design in the target system: Designing and developing processing processes within the target systems
• Technical consulting for the IT implementation team within an iPaaS system
• Quality assurance: Planning, leading and documenting User Acceptance Tests (UAT) to ensure the functional requirements
• Project completion & handover: Formal handover of the implemented interfaces, including complete technical documentation, to IT operations

Tools: Jira, Confluence, Office 365

• Conclusion of partner agreements with OnePlan (portfolio management) and ForProject/EVMS (project controlling); ongoing qualification and implementation of both tools.
• Project management for the relaunch of [link] with a new focus on integrated PM/PPM toolchains.
• Development and implementation of approx. 60 PM standard methods (PMSP, CMSP, QMSP) according to ICB4 & PMBoK8 as a database application on MS Power Automate / M365 / MS Project, with a planned cloud launch in 2025.
• Deployment and cut-over standard process defined as Quality Gate QG07: go-live plan, cut-over plan, communication package, production launch, smoke test in production, hypercare team, incident and SLA management, confirmation of production stability and operational handover.
• Development of a classification and retrieval system (TOC) for ChatGPT projects to enable immediate cross-application object activation.

Tools: LinkedIn, Claude, ChatGPT, Gemini, Infinity, MS Copilot, OnePlan, EVMS/ForProject, Power Automate, SQL DB, O365, MS Project, MS Cloud, ICB4, PMBoK7, M365, Teams

• Designed and implemented comprehensive business processes, leading cross-functional teams to increase customer satisfaction and reduce costs
• Provided training and ensured benefits realization through end-to-end workflow development
• Contributed to the “Generate Insights from Hidden Knowledge” initiative by developing and deploying AI-driven workflow automation solutions using Large Language Models (LLMs) and low-code/no-code platforms
• Designed multi-agentic workflows integrating OpenAI, LangChain, Haystack, and n8n to automate document review, data extraction, and knowledge summarization processes
• Led the orchestration of AI and automation frameworks to enhance medical and business review processes, ensuring compliance, explainability, and transparency
• Collaborated cross-functionally to translate complex business requirements into AI-enabled automation prototypes aligned with enterprise compliance and data privacy standards
• Applied Power Automate, UiPath, Nintex, and ServiceNow to deliver rapid, scalable, and secure automation solutions within validated operational environments
• Leveraged Lean Six Sigma, Agile/SAFe, and ITIL principles to structure AI development pipelines ensuring measurable impact, auditability, and sustainable governance
• Managed cross-departmental collaboration to standardize workflows, reducing errors and enhancing task management. Established governance frameworks to ensure the sustainability of automation solutions

• Administration and further development of the M365 environment, including Teams, Exchange Online, Intune, and SharePoint Online
• Development of dashboards for performance monitoring with Microsoft Power BI
• Implementation of user requirements and processes with low-code/no-code technologies (Power Apps, Power Automate)
• Use of Jira and Azure DevOps to plan and implement user stories in an agile project context
• Participation in daily stand-ups, sprint planning, sprint reviews, and retrospectives as the technical point of contact
• Planning and implementation of security policies using Azure Conditional Access and multi-factor authentication
• Configuration and deployment of clients and applications via MECM (SCCM) and Baramundi

• Integration of highly regulated countries such as China and South Korea into a company-wide M365 tenant.

• Technical contact for integrating special requirements for the executive board and German subsidiaries that are subject to BaFin compliance requirements.

• Subproject management.

• Coordination of requirements within the overall architecture.

• Design of the use of DLP features from Microsoft Purview.

• Design of special access restrictions via Entra ID Conditional Access.

• Support in designing the provisioning of Teams teams and SharePoint sites with higher compliance requirements.

• Technical support for implementing information classification with sensitivity labels for SharePoint Online and Teams.

• Technical support for the subproject introducing CoPilot for M365.

• Skills: M365, Purview, DLP, Entra ID, Sensitivity Labels, CoPilot, Teams, SharePoint Online.

Independently built a data platform with cross-system process monitoring.

• Designed the Bronze/Silver/Gold architecture and Python-based pipelines for diverse operational sources.
• Cleaned, harmonized, and validated data; processed and stored it in Parquet format.
• Tracked data history and built business-focused fact and dimension models for traceable reporting.
• Automated data delivery with Python and Power Automate (desktop and cloud); used SharePoint for archiving and data access.
• Developed the Power BI solution from data preparation through to visualizing process statuses, work progress, and deviations.

Technologies: Python, SQL, Parquet, Power BI, Power Query, Power Automate, SharePoint, Copilot

• Advising companies on building, migrating and optimising BI and reporting landscapes (Power BI, SQL, Python, ETL)

• 5 client engagements in real estate and finance since 05/2025: taking over and stabilising existing reporting, automating recurring standard and management reports, building cash-flow models

• Proposal and feasibility assessments for BI and reporting projects

• Using AI-assisted development (Claude Code) to accelerate automation, tooling and web/app development

• Custom ERP system

• Problem: A client's core processes ran on scattered, siloed Excel files with no central data storage – error-prone, hard to scale and impossible to analyse end-to-end.

• Approach: Captured the business processes and requirements, modelled the data and developed iteratively together with the business team.

• Implementation: Built a tailored, web-based ERP system with a central database, role-based modules and automated reporting – delivered using AI-assisted development in Claude Code.

• Timesheet app

• Starting point: Time tracking based on an overgrown, macro-heavy Excel template – maintenance-intensive, single-user and error-prone.

• Implementation: Migrated all functionality and VBA macros into a standalone web app with central data storage, multi-user support and automated reporting.

• Cash-flow modelling

• Starting point: The existing cash-flow model covered standing investments only; project developments were missing from steering.

• Implementation: Built and extended the CF model to include project-development cash flows.

• Optimisation: Reviewed and optimised existing CF models and expanded the KPI outputs for reporting and steering.

• Analysis of the existing reporting platform, including processes and governance topics, with stakeholders from Sales and Marketing.

• Detailed analysis and evaluation of customer-defined requirements for existing reporting and new dashboards to be established.

• Support for stakeholders in managing sales processes and identifying KPI trends at an early stage.

• Use of Microsoft Power BI as the central analysis and reporting platform.

• Development of a proposal for the required further development of processes and the Power BI platform.

• Documentation of AS-IS business processes and derivation of company-wide KPIs, including coordination with stakeholders.

• Analysis and assessment of the customer's Power BI platform.

• Analysis of processes and data governance.

• Documentation of AS-IS business processes.

• Development of recommendations for further developing processes and the reporting platform.

• Design and implementation of dashboards in Power BI.

• Development of company-wide KPIs and coordination with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

• Consulting across two integrated areas: Commercial Strategy (pricing, sales steering, marketing strategy, market expansion, margin management) and Operational Efficiency (process automation, AI integration, workflow design, last-mile automation).
• Development of custom SaaS solutions, explicitly tailored to the specific requirements and processes of each company.
• Delivery of AI training and change management workshops for managing directors and specialist departments, including AI competence training with a certificate of attendance under Art. 4 of the EU AI Act.