Christian P.-BI Architect & Power BI Project Manager
Check rate
Experience
Power BI Developer & Consultant in an Agile Team (SAFe)
DB InfraGO AG
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
BI Consultant & Developer in a Scrum Team
Association of German Banks
Further Development of a Risk Reporting Application
Banks
- Implemented a new risk controlling concept in the DWH (SQL Server) and Power BI
- Designed KPI logic so that the business department can control weights and parameters independently
- Professionalized the way of working in a five-person team with Git, VS Code and Azure DevOps
Initial Situation:
A new concept from risk controlling required comprehensive further development of the existing risk reporting application—both in the SQL Server data warehouse and in Power BI reporting—to represent new assessment and classification criteria. The five-person development team worked agile according to Scrum with version control in Git and Azure DevOps.
Measures:
- Development Environment: Integrated environment with Visual Studio Code and Git for multiple developers, including source code management.
- Data Integration: ETL processes for automated loading from internal and external rating systems using SQL views and stored procedures.
- Business Logic: Standard models for KPI calculations, which the business department can adjust independently using weights and parameters.
- Reporting: Standard reports in Power BI with a commenting function for deviations and actions.
- Team Processes: Planning of features, user stories and tasks in Azure DevOps for sprint execution.
Technologies: SQL Server 2019, Power BI, Power Query, Git, Azure DevOps
Results:
- Better basis for decision-making in risk controlling
- Calculations and results documented directly in Power BI
- Standardized enterprise DWH with historization and business logic
Project Manager & Developer
GAPLAST GmbH
Optimization of a Tabular Model for Management Reporting
Industry / Production
- Took over an existing Power BI Report Server environment and optimized the data model for performance
- Integrated new reporting requirements and additional data sources, improved ETL processes
Initial Situation:
The existing Power BI Report Server environment was slow and required optimization of performance, data integration and modeling to meet growing reporting requirements.
Measures:
- Analysis & Strategy: Gathering new requirements and deriving suitable BI solutions.
- Optimization: Revising data models, improving performance and adapting ETL processes.
- Expansion & Operations: Creating new reports, integrating additional data sources and supporting the production environment.
Technologies: Power BI Report Server, Tabular Editor, DAX
Results:
- Noticeably faster reports through optimized data models
- Reporting opened up for additional business areas
- Improved data quality through revised ETL processes
Managing Director & BI Architect
Proofnity GmbH
With Proofinity GmbH, I support companies and associations in building and further developing their Power BI environments. I take on project management and architecture and also work hands-on in implementation: from the data warehouse and data model to reports, governance and user training.
Product Development
From the projects, we developed our own framework with eight Power BI modules. This means that not every project has to start from scratch. Each module consists of a demo file (PBIX/PBIP), HTML documentation, C# scripts for Tabular Editor and a configuration. Examples:
- Security: all five levels (RLS, OLS, CLS, MLS, PLS) in one model, connected to Azure AD groups
- Time Intelligence: 29 patterns with Calculation Groups, 57 DAX measures and a calendar configurator as a C# script
- Requirements & Wireframing: questionnaires and mockups so that the business department and development have the same understanding before implementation
- Design Playbook and Documentation: consistent themes according to IBCS and automatically generated model documentation for handover
Training and Coaching I train development teams and key users and support customer teams through sparring on data models, DAX and report design. The modules and a resource line form the basis.
Business Development and Sales I developed Proofinity's positioning and service offering: diagnosis of existing reports, training, coaching and fixed-price projects. I conduct requirements workshops, prepare proposals and support customers beyond the project. I am also building a network of freelancers and partners with whom we develop ready-made solution templates for each ERP system and business area.
AI in Development and Operations I use Claude Code, Codex and GitHub Copilot for development, documentation and testing. I also automate internal processes, for example collecting and evaluating project tenders and creating drafts for applications. Technologies: Power BI (Desktop, Service, Report Server), DAX, Power Query, DirectQuery, Calculation Groups, RLS/OLS, Deployment Pipelines, Power Automate, SQL Seer, Amazon Redshift, Tabular Editor(C# scripts), DAX Studio, InfoRiver, Azure DevOps, Git/GitLab, Jira, Confluence, Playwright, Docker, Python, Claude Code, Codex, GitHub Copilot
Methods: Scrum, SAFe, IBCS, Requirements Engineering
Project Manager & BI Architect
Securitas AG
Building a Power BI Environment from Scratch for Management Reporting
Security Services
- Planned the Power BI environment from the ground up: requirements analysis, governance framework and roadmap with profitability calculation
- Built a data warehouse with Data Vault, introduced Report Server and migrated to the cloud
- Introduced managed self-service BI—business departments create reports independently, reducing dependence on IT
Initial Situation:
The existing BI environment was based on outdated reporting solutions that no longer met growing requirements. The goal was a scalable self-service BI solution for finance and controlling reports, enabling other departments to build reports independently.
Measures:
- Analysis & Strategy: Requirements analysis, governance framework, roadmap with profitability calculation and project proposal.
- Architecture & Implementation: Built a Power BI Report Server environment, migrated to the cloud and implemented a managed self-service BI architecture.
- Data Management: Data warehouse with Data Vault (Data Vault Builder), including multilayer architecture; extraction from Firebird and SAP R/3.
- Model & Reports: Semantic model with Tabular Editor including Calculation Groups, performance analysis with DAX Studio, IBCS standard reports with InfoRiver.
- Standardization: Report templates, corporate identity templates and dashboards for employee satisfaction.
- Training & Support: Introduction of self-service BI, user training and documentation.
Technologies: Power BI, DAX, Tabular Editor, Calculation Groups, InfoRiver (IBCS), SQL Server 2016, Data Vault Builder
Results:
- Faster report creation through standardized templates
- Higher self-service adoption and less dependence on IT
- Cloud migration in compliance with governance guidelines
Technical Project Manager
SCHAEFER KALK
Microsoft–BI–Application for Sales and Finance Based on Navision
Industry / Production
- Technical project management of a team developing the BI solution for Sales and Finance
- OLAP model and SQL logic for profit and loss and balance sheet reports based on Navision account schemas
Initial situation:
The company needed a BI solution to analyze financial and sales data from Navision in order to create profit and loss and balance sheet reports more efficiently.
Measures:
- Analysis & Strategy: Requirements gathering in Sales and Finance, definition of the BI architecture.
- Data Modeling: OLAP data model with Visual Studio Data Tools 2017 to represent the business logic.
- Data Integration: SQL procedures for extracting and transforming Navision data for profit and loss and balance sheet reporting.
Technologies: SQL Server, SSAS, Visual Studio Data Tools
Results:
- Greater transparency in financial and sales reporting
- Automated data processing through SQL processes
- More precise reports as a basis for decision-making
Developer on the Team
Political Foundation
Redesign of a Near-Time DWH with SQL Server and Cubeware
Initial situation:
A Near-Time Data Warehouse was needed for reporting requirements in Finance and Controlling, consolidating data from several accounting systems. The existing DWH had become very complex due to changing consultants and had to be rebuilt.
Measures:
- Development Environment: Visual Studio Data Tools with Git version control for multiple developers.
- Data Integration: ETL process for automated loading from the MACH and FAV2 accounting systems using views and stored procedures.
- Data Modeling: OLAP model with Cubeware Importer, measures in MDX.
- Reporting & Budgeting: Standard reports in Cubeware Cockpit with write-back functionality for budget values.
Technologies: SQL Server 2016, MDX, Cubeware, Git
Results:
- More up-to-date data through Near-Time updates
- Efficient report creation through standardized reports
- Maintainable enterprise DWH with historization and business logic
Senior Consultant
QUNIS GmbH
At QUNIS, I led and implemented BI projects for customers in industry and the non-profit sector, focusing on Microsoft SQL Server, SSAS and Cubeware. I gathered requirements with the business departments, prepared proposals and supported the projects through to go-live.
- Project management and proposals: I led projects from requirements gathering through architecture to handover and prepared the corresponding proposals, including effort estimates and project plans.
- SCHAEFER KALK, Industry (from 05/2020): As technical project manager, I led the team that built the BI solution for Sales and Finance. The solution was based on data from Navision. I aligned the OLAP model and the SQL logic for profit and loss and balance sheet reporting with the Navision account schemas. Since then, financial and sales reports have been generated automatically and provide a more reliable basis for decision-making.
- Political Foundation, Non-Profit (11/2018 – 12/2021): The Data Warehouse had become difficult to manage over the years due to changing consultants. As part of the team, I restructured it and changed it to Near-Time loading from the MACH and FAV2 accounting systems. Standard reports for Finance and Controlling were created in Cubeware, with budget values that can be written back directly. The data has been more up to date since then, and the DWH is maintainable again.
Technologies: SQL Server 2016, T-SQL, Stored Procedures, SSAS (OLAP), MDX, Visual Studio Data Tools, Cubeware Importer and Cockpit, Git
Senior Consultant & Head of Competence Center
Braincourt GmbH
At Braincourt, I built and managed the Competence Center for Tagetik. Tagetik is software for corporate planning, budgeting and consolidation. I was responsible for the service offering related to Tagetik, won new customers and also worked on planning projects myself.
- Building the Competence Center: I developed the Tagetik service offering and was responsible for the subject area at Braincourt.
- Presales and Acquisition: I presented Braincourt and its planning offering to potential customers, conducted presentations and demos, and prepared proposals.
- Telecommunications Group, Bonn: In the corporate planning project with Infor BI, I built ETL processes on SQL Server to load planning data from files. This made the data centrally available in the database for planning.
Technologies: Tagetik, Infor BI, SQL Server, T-SQL, ETL
BI Consultant
Cubeware GmbH
At Cubeware, I developed complete BI solutions with Cubeware based on Microsoft SQL Server for medium-sized customers. I supported projects from the initial workshop through to the completed solution, sometimes as project manager and sometimes as sub-project manager.
- Requirements workshops: Together with the business departments, I gathered key figures, analyses and data sources and derived the solution concept from them.
- Implementation of the BI solution: I built the Data Warehouse on SQL Server, loaded the data with Cubeware Importer, created OLAP models and developed the reports in Cubeware Cockpit. This gave customers an end-to-end solution from the data source to the report.
- Proofs of Concept and Presales: In Proofs of Concept, I used prospects' own data to show them what a solution could look like for them. I also provided technical support to Sales in customer meetings.
Technologies: Cubeware Importer, Cubeware Cockpit, SQL Server, T-SQL, OLAP, MDX
Certificate: Cubeware Certified Professional (2014)
IT–Consultant
Infomotion GmbH
After completing my studies, I started working in consulting at Infomotion. For clients, I built BI solutions based on Microsoft SQL Server, using SAP BusinessObjects for reporting. This gave me the foundation I still need in every project today: clean data models, reliable loading processes, and reports that business departments can work with.
- Data Warehouse: I developed data warehouse systems on SQL Server 2005 to 2012, from the data model to the ETL processes used to load data from the source systems.
- Reporting: Based on the data warehouse, I created reports and analyses with BusinessObjects so that business departments could obtain their key figures from a consistent data foundation.
- Further training: During this time, I completed the Microsoft Certified Technology Specialist certification for SQL Server BI and the PRINCE2-Foundation certification.
Technologies: Microsoft SQL Server 2005–2012, T-SQL, SAP BusinessObjects
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Professional Services, Manufacturing, Telecommunication, and Banking and Finance.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Project Management, Sales, Product Development, and Marketing.
Summary
BI Architect and Project Manager specializing in Power BI and Microsoft SQL Server. I build BI environments from scratch or bring existing ones back into shape: from requirements gathering with the business through architecture, data warehouse and semantic model to governance, reporting standards and user training. The goal is a solution that the customer can operate and extend independently. I use AI tools such as Claude Code and Codex for development, documentation and testing.
Skills
Power Bi
- Power Bi Desktop
- Power Bi Service
- Report Server
- Microsoft Fabric
- Dax
- Power Query
- Calculation Groups
- Rls
Database & Dwh
- Sql Server 2008–2019
- T-Sql
- Ssis
- Ssas
- Ssrs
- Data Vault
- Star Schema
- Mdx
- Amazon Redshift
Tools
- Tabular Editor
- Dax Studio
- Inforiver
- Azure Devops
- Git / Gitlab
- Vs Code
- Playwright
- Docker
- Jira
- Confluence
Methods
- Scrum
- Safe
- Prince2
- Ibcs
- Requirements Engineering
Ai Tools
- Claude Code
- Codex
- Vs Code With Github Copilot
Project Management & Bi Consulting Planning And Managing Bi Projects With A Focus On Profitability, Roadmaps, Project Proposals And Stakeholder Management. Agile Delivery In Sprints With Azure Devops.
Power Bi & Microsoft Bi Stack Managed Self-Service Bi With Power Bi Service, Report Server And Fabric. Data Modeling, Dax, Calculation Groups, Power Query.
Data Warehouse & Etl Building And Redesigning Dwhs On Sql Server With Data Vault And Star Schema, Etl With Stored Procedures, Views And Ssis.
Governance, Standards & Training Governance Frameworks, Report Templates, Corporate Identity Templates, Ibcs Reports. Workshops, Training Concepts And Key-User Enablement.
Languages
Education
Cologne University of Applied Sciences
Diplom Business Information Systems · Business Information Systems · Cologne, Germany
Siegburg Municipal Administration
IT Specialist for Systems Integration · Systems Integration · Siegburg, Germany
I completed my training in the IT department of Siegburg Municipal Administration. There I learned how networks, servers and workstations work together and how to quickly help users in their day-to-day work. I still use this foundation today when integrating BI solutions into existing IT environments and coordinating with IT departments.
- Network and servers: Setting up and supporting the network and Windows servers, managing users and permissions
- Workstations and support: Setting up PCs and software for administrative staff, user support for issues and questions
- Final project “Central Data Backup Concept for the Branch Offices of the Municipal Administration”: I recorded the current state of data backup and developed a target concept from it. I then set up a central backup server with a tape drive using Veritas Backup Exec. The Oracle database is backed up online via an agent without interrupting ongoing operations, and the file server is also connected. Full and differential backups run automatically according to a schedule. Retention periods and overwrite protection are managed through media sets. In the event of errors, the administrator receives an email. After the first backup runs, I checked the logs, explained the concept to employees and then took over responsibility for data backup.
Technologies: Windows NT, Exchange, Veritas Backup Exec, Oracle, tape backup
Certifications & licenses
Boris Gloger
Cubeware Certified Professional
Statistics
Experience
Global experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Christian is based in Hünfelden, Germany and can operate in on-site, hybrid, and remote work models.
Christian speaks the following languages: German (Native), English (Advanced).
Christian has at least 19 years of experience. During this time, Christian has worked in at least 11 different roles and for 11 different companies. The average length of individual experience is 2 years and 9 months. Note that Christian may not have shared all experience and actually has more experience.
Based on recent experience, Christian would be well-suited for roles such as: Power BI Developer & Consultant in an Agile Team (SAFe), BI Consultant & Developer in a Scrum Team, Project Manager & Developer.
Christian's most recent position is Power BI Developer & Consultant in an Agile Team (SAFe) at DB InfraGO AG.
In recent years, Christian has worked for DB InfraGO AG, Association of German Banks, GAPLAST GmbH, Proofnity GmbH, and Securitas AG.
Christian is most experienced in industries like Information Technology, Professional Services, and Manufacturing. Christian also has some experience in Telecommunication and Banking and Finance.
Christian is most experienced in business areas like Business Intelligence, Information Technology, and Project Management. Christian also has some experience in Sales, Product Development, and Marketing.
Christian has recently worked in industries like Information Technology, Professional Services, and Manufacturing.
Christian has recently worked in business areas like Business Intelligence, Information Technology, and Project Management.
Christian holds a Master in Business Information Systems from Cologne University of Applied Sciences.
Christian has 4 certificates. Among them, these include: Scrum Master, Cubeware Certified Professional, and Microsoft Certified Technology Specialist.
Christian is immediately available full-time for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 20 Oct 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Marco S.
Henok A.
Ronny H.
William N.
Germo G.
Torsten F.
German P.
Vitali H.
Christian D.
Guido K.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Power BI Developer & Consultant in an Agile Team (SAFe)
Eric B.
Thomas R.
Mario T.
Carsten F.
Benedikt R.
Bernd S.
Susanne M.
Daryoosh D.
Tim S.
Claus E.
Nearby freelancers
Professionals working in or nearby Hünfelden, Germany
Sahra H.
Qamar H.
Robert K.
Benedikt G.
Olaf S.
Julia K.
Gregor P.
Bernhard B.
Henok M.
Jakob H.
