Microsoft Power BI Experts in Munich

Subproject management in an agile IT environment

Leading a software development team (10 employees)

• Leading a software development team with 10 employees
• Budget responsibility approx. 3 million Euros per year
• Conducting employee and job interviews
• Responsibility for resource planning (budget and employees)
• Digitalization of a web interface
• Regular reporting to clients and stakeholders (C-level)
• Product management: developing and implementing product strategies; defining requirements to steer product development
• Designing product development & continuous testing efficiently to quickly incorporate feedback & compliance points
• Close collaboration with stakeholders & various teams to understand requirements, define priorities, ensure rollout, and increase user-friendliness
• Project experience in an energy industry company, including the functioning of energy markets, the basics of energy generation and distribution, as well as current challenges and developments in the industry
• Project experience in the railway sector - including the structure and operation of railway systems.
• Project experience within the 16.7 Hz traction power sector including knowledge of regulatory processes
• Formulating the subproject charter and the project profile according to the project standard together with the project management
• Steering performance delivery according to the project charter
• Planning and steering human resources including budget planning for the subproject
• Ensuring the working capacity of subproject participants, e.g., by requesting access rights and documents for the subproject team
• Planning and steering for the respective subproject (Time, Scope, Budget) including the creation of necessary documents
• Coordinating with the department and Product Owners to plan the subproject scope and the corresponding implications
• Conducting milestone planning according to the agreed process model
• Effort estimation and support of subproject controlling as well as overall project controlling in forecasting and planning
• Reporting subproject status (according to status slide template) including progress (according to progress measurement)
• Analyzing, preparing, and addressing needs for action and decisions
• Escalating subproject issues to project management
• Creating and managing Change Requests (CR)
• Quality assessment of completed task packages from a project management perspective (Time, Scope, and Budget)
• Steering the implementation of cross-cutting specifications and requirements in the subproject, supported by cross-functional roles on the business and technical side.
• Identifying, steering, documenting, and communicating opportunities, risks, and dependencies within and across subprojects
• Supporting project management in creating the overall project plan and overall status reports
• Preparing and steering commissioning including required documents and protection requirements assessment

Scrum Master in an agile IT environment supporting a software development team in the fullstack area (7 people)

• Close collaboration with stakeholders & various teams to understand requirements, define priorities, ensure rollout, and increase user-friendliness
• Introducing the selected Scrum method, including the required events, meetings, artifacts (Product Backlog, Sprint Backlog, Burndown Charts), metrics, and conducting required training in an agile IT environment
• Preparing Scrum events such as Daily, Retrospectives, Review, Sprint Planning, Estimation, and Refinement (agile way of working)
• Facilitating retrospectives and removing impediments to drive the team and product forward
• Preparing action points and retros via Whiteboard and Figma
• Applying and improving agile methods such as Kanban, Scrum, SAFe, or Scrum of Scrums
• Tracking the "Definition of Done" and "Definition of Ready" for all work results of the development team
• Advising on information flow and communication improvements between Product Owner and project team
• Experience with automation, validation such as mandatory field checks, notification functions, creating filters, boards, and reports via JQL, and setting up Cycle Time
• Using Jira & Confluence
• Setting up progress measurement for project management to transparently map planned vs. actual team capacities and actual effort for user stories
• Measuring team progress: creating team KPIs: "Velocity", "Burn-Down Chart", "Throughput", "Costs", "Quality", "Scope"
• Evaluating agile metrics, process management, and process modeling methods (BPMN, EPC, UML)
• Communication and moderation know-how
• Proven methodological competence in conflict resolution discussions

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

• Deployment and scaling of existing ML initiatives, including demand and cash flow forecasts.
• Building robust monitoring with mlflow for data stability, model performance, and drift detection, as well as implementing additional ML use cases.
• Further development of an Agentic AI chatbot for transparent and easy-to-understand model explanations.

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

• Building, implementing and selling automated Data Science solutions such as Scorecard Factory and Forecast Factory
• Implementation of automated end-to-end cloud processes
• Development of LLM and NLP models
• Creation of interactive reports
• Support for national and international large corporations as well as medium-sized companies in implementing ML projects

• Focus areas: restructuring, operations management, commercial management, purchasing, production
• Industries: automotive, metal processing, shipbuilding, electrical, elevators / escalators

• Advise organizations on integrating AI into project and program management practices, delivering measurable productivity improvements
• Designed and implemented an AI agent to improve project communication, transparency, and reporting quality

Large Insurance Company – Consultant Wiesbaden: Consulting support for the introduction of an integrated planning and performance management framework (operational, financial, customer) to enhance customer-centric transparency, decision-making quality, and steering capabilities across all lines of business within an insurance organization:

• Analysis of existing processes, reports, KPIs, and KPI calculation methodologies
• Design and introduction of new, standardized customer KPIs (gross/net), as well as key steering metrics with consistent linkage across all lines of business
• Recalculation, validation, and plausibility checks of KPIs based on existing and newly integrated data sources
• Conceptual support for the development of an integrated reporting and performance management setup
• Execution of customer insights analyses to identify patterns and anomalies within customer data clusters

Large retail company – Consultant in Karlsruhe: Advisory services for the setup and step-by-step implementation of an internationally deployable RELEX solution in the supply chain management environment:

• Advising overall and sub-project management on methodology, project setup and steering (e.g. agile approach, Jira configuration, RELEX phases, Jira Structure PPM)
• Strategic-operational consulting for the introduction of RELEX including best practices
• Support in defining overarching goals and requirements (2-year target picture)
• Guidance in scoping a relevant supply chain network segment for the project
• Development of a roadmap for iterative, incremental RELEX setup and rollout
• Assessment of project dependencies (interfaces, configurations, etc.)
• Advice on prioritized implementation of business requirements and data interfaces
• Support in test planning (data validation, system testing, UAT)
• Consulting on internationalization, change management, training, and knowledge transfer
• Stakeholder advisory and alignment activities between the client, implementation partner, and RELEX

Insurance company – Management Consultant in Munich: Analysis, consulting and support for the optimization of a large-scale business and IT transformation. Focus on strategically important programs and modernization projects in the area of Managed Services Operations and processes:

• Review of project plans and deliverables; analysis of programs and projects (e.g. cloud approach, process standardization, system integration, roadmaps)
• Identification of technical, functional and personnel risks and challenges; development of content-related measures and alternative solutions
• Proposal of quality improvements for program and modernization efforts
• Sparring partner and professional, technical, structural and organizational consulting for project and program management

Large retail group – Management Consultant & Stream Lead in Cologne: Consulting, process, project and product management for the introduction and implementation of a large strategic program in the field of advanced analytics, assortment and space management:

• Setup, test and rollout of a new space planning, automation and optimization product based on the existing cluster-based merchandising approach
• Definition and setup of new processes and transformation and change management measures for the new store-specific merchandising approach
• Collaboration with Advanced Analytics and IT (internal and external) for software implementations, automations, extensions and interfaces
• MVP approach and piloting in phases with gradual rollout (pilot with 80 stores, region with 500 stores, national level with 4000 stores)

Large retail company – Agile Coach & Change Agent in Cologne: Agile coach, OKR master and facilitator for the introduction of the OKR approach in a large strategic digitization program for retail stores:

• Coaching of the core team with topic managers and team leads
• Introduction to the OKR topic and setup of the OKR cycle
• Establishment of the OKR approach in teams and on a cross-team level

Delivery and logistics company – Management Consultant in United Kingdom: Consulting and coaching in the restructuring of the Data Analytics department:

• Analysis of current challenges
• Definition of overarching goals
• Development of a proposal for a new team structure
• Identification of required competencies, skills and responsibilities
• Advisory and alignment on communication and change management strategy

• PMO setup and governance for complex development and transformation programs
• Program and project management in highly complex technical environments (hardware, software, and system integration)
• Agile coaching and scaling (SAFe, Scrum) – from framework introduction to operational rollout
• Scrum Master and Product Owner roles within cross-functional, international teams
• Risk, stakeholder, and backlog management using JIRA, Confluence, and MS Project Available for: PMO Lead, Program Manager, Project Manager, Agile Coach, Scrum Master, Product Owner, Technical Program Manager

• Developed & maintained customer analytical reporting solutions to identify revenue trends, performance drivers, risks & optimization opportunities to ensure data driven decision making across Sales, Finance, Product, Data Engineering & Controlling.
• Defined & analyzed customer trends & performance metrics to identify root causes behind variances, anomalies & emerging risks across business domains to deliver actionable recommendations.
• Developed & owned analytical data models & reporting layers to ensure scalability, performance & analytical robustness to support executive & operational reporting across business domains.
• Planned, tracked & executed projects by ensuring adherence to timelines, data accuracy, consistency, deliverables, reliability & data quality standards through rigorous validation & reconciliation processes.
• Raised the analytical maturity by formalizing analytical workflows, documenting data processes & standard operating procedures (SOPs) & conducting training sessions to drive adoption of self-service analytics & embed a data driven culture across operational and business teams.
• Took ownership of the end-to-end lifecycle roadmap from requirement gathering, collection, transformation, developing robust business logics to data storytelling & stakeholder delivery.
• Converted complexity into structured clarity by translating requirements & business processes into analytical recommendations to ensure alignment between non-technical & technical stakeholders.
• Conducted advanced SQL based analysis of complex business datasets to uncover trends, correlations & performance improvement opportunities.
• Drove process automation & efficiency improvements by leveraging Python, SQL optimization & AI assisted tools to reduce processing time & increase reliability across analytical & operational workflows.
• Standardized KPI definitions & reporting logic to ensure consistency & trust across reporting solutions.
• Developed process monitoring dashboards & analyses to identify inefficiencies, bottlenecks & compliance deviations across end-to-end business processes to derive actionable recommendations for process improvement & automation.

• Built a Python pipeline that converts lectionary web content into structured daily JSON, applying liturgical-calendar rules for accurate weekday and Sunday coverage.
• Shipped a read-only FastAPI REST API with shared Pydantic models and delivered a Kirundi-first web client for browser and mobile use.
• Owned the data layer and backend architecture, collaborating closely on system architecture and interfaces while automating refreshes with GitHub Actions and validating the ETL with pytest.
• Impact: Created a reliable, API-driven source of truth for daily Bible readings in Kirundi, enabling consistent access to previously unstructured content.

Outcome: Implementation of an APS solution (Eyelit) across multiple international production sites, including definition of target planning processes, integration architecture (SAP – APS via middleware), and alignment of complex manufacturing requirements (e.g. autoclave planning, alternative routings). Establishment of governance structures, steering formats and decision frameworks to manage scope, cost and timeline across multiple stakeholders. Successful handover of project leadership to internal successor, ensuring continuity and sustained project delivery.

Role in Project: Project Lead / Program Manager

Main Tasks in Project:

• Led APS implementation across multiple plants (Germany, Canada, France, US) with focus on end-to-end planning & scheduling processes and system integration
• Acted as central interface between business stakeholders (plants, operations), IT (SAP/middleware) and vendor (Eyelit)
• Drove requirements engineering, including consolidation of plant-specific requirements and steering of sign-off process
• Managed vendor (Eyelit) performance, including scope clarification, effort discussions and commercial alignment
• Identified and challenged gaps between standard APS functionality and complex manufacturing requirements (e.g. autoclave planning, batch optimization, alternative routings)
• Defined and implemented project governance structures, including Steering Committees, risk reporting and decision frameworks
• Led escalation management on cost overruns, scope deviations and delivery transparency
• Coordinated integration strategy (decision for custom middleware vs. standard connector) and alignment with SAP landscape
• Improved project transparency and way of working, including definition of reporting structures, tracking logic and communication cadence
• Facilitated alignment between global and local stakeholders to ensure feasible timelines, resource planning and plant readiness
• Prepared and delivered SteerCo updates and executive decision documents
• Managed structured project handover to internal project lead, including knowledge transfer, documentation alignment and stakeholder transition.

• Built and maintained Power BI dashboards (DAX, Power Query, data modeling) tracking KPIs across 15+ global manufacturing sites — primary reporting tool for EU leadership decision-making.
• Developed a multi-screen Power Apps application (configurator-style tool) with SharePoint-based workflow integration for the sales team — designed jointly with business stakeholders and IT.
• Built and maintained automated Power Automate workflows connecting to SQL databases; independently identified and deployed an LLM-driven automation use case that eliminated 90% of manual reporting effort — self-pitched to leadership and taken end-to-end into production.
• Built a Python-based data pipeline (SQL) extracting, modeling, and validating data across 10+ EU plants — establishing reliable data models and KPIs for cross-site reporting.

• Implemented optimized management control and PowerBI solutions for the Power and Gas departments
• Performed a value chain analysis and created a business case with three scenarios and a value creation roadmap