Business Intelligence & Data Analytics, Excel (Guru-Level, SQL, Projektmanagement & Methoden, Cloud & Tools, Erfahrung als Scrum Master
Aktualisiert am 07.11.2025
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 06.11.2025
Verfügbar zu: 100%
davon vor Ort: 0%
Business Intelligence & Data Analytics
Excel (Guru-Level)
SQL
Power BI (Desktop & Services
Azure DevOps Reporting
Python (Datenanonymisierung
OpenAI API-Integration).
SCRUM
KANBAN
Stakegholder Management
Azure Analysis Services (AAS)
Azure DevOps.
Git
Visual Studio
Visual Studio Code
Datenanonymisierung
OpenAI API-Integration
Datenmodellierung
DAX-Entwicklun
Prozessoptimierung
Dashboard-Frameworks
Datenintegration
Data Warehouse
German
Professional Working
English
Professional Working
Italian
native
Spanish
Professional Working

Einsatzorte

Einsatzorte

Deutschland
möglich

Projekte

Projekte

5 Monate
2025-06 - 2025-10

various

Power BI Consultant Power BI Desktop Power Query Azure DevOps
Power BI Consultant
Usage and Cost Monitoring Dashboard
  • Developed a Power BI dashboard integrating usage metrics and cost data to identify  underutilized reports, datasets, and workspaces, enabling optimization and proactive cleanup.
  • Implemented filtering by business unit/region and automated alerts based on usage-to-cost thresholds.
Workspace Lifecycle Management
  • Built detection logic for abandoned or inactive workspaces using activity metrics and owner status, supporting governance decisions for archival or deletion.
Documentation and Best Practices
  • Authored key chapters of the internal PBI-Toolkit, including Enterprise Gateway setup, incremental refresh, OLS implementation, SAP BW/4HANA connectivity and productivity tips.
Power BI Desktop Power Query Azure DevOps
Healthcare Technology
3 Monate
2025-04 - 2025-06

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop Jira
Power BI Report Designer (Frontend)
  • Dashboard Development
    • Designed and implemented internal back-office dashboards for test status tracking using Power BI and Excel-based solutions.
  • Visualization and DAX Implementation
    • Created interactive visualizations and advanced DAX calculations, including scatter plots and percentile analyses.
  • Stakeholder Collaboration
    • Worked with specialist departments to gather requirements and translate them into user stories for development.
Power BI Services Power BI Desktop Jira
Energy Sector
4 Monate
2024-12 - 2025-03

various

Enhancement Developer for Calculation Tool/ Web Application VB.Net SQL Server Excel ...
Enhancement Developer for Calculation Tool/ Web Application
Legacy Tool Enhancement
  • Participating in the enhancement of a legacy calculation tool/web application originally developed 10-20 years ago in Excel and VB.Net Windows Forms.
  • Optimizing the tool?s on-prem SQL database for improved performance and scalability.
Feature Updates and Modernization
  • Adding new functionalities to the web application, improving usability and adapting it to modern user requirements.
  • Supporting the transition of key workflows, such as data entry and reporting, from Excel to a centralized web-based interface.
Collaboration and Documentation
  • Working closely with stakeholders to refine technical requirements, ensuring updates align with business needs.
  • Documenting enhancements to facilitate knowledge transfer and future maintenance
VB.Net SQL Server Excel VBA Windows Forms
Energy Sector
2 Monate
2024-10 - 2024-11

various

Power BI Consultant Power BI Desktop Power Query Azure DevOps ...
Power BI Consultant
Power BI Template Development
  • Designed and implemented Power BI templates to streamline reporting processes and standardize visualizations.
Power BI Guidance and Governance
  • Restructured the Power BI guidance and data governance website, contributing additional pages to enhance usability and documentation.
  • Identified new content topics for the website by analyzing approximately 300 support tickets and emails from the global IT Power BI support team using OpenAI API.
    • Developed a proof of concept in Power Query to connect with the OpenAI API.
    • Transitioned to Python for better scalability and efficient data anonymization.
Azure DevOps Reporting
  • Created a Power BI analytics report to visualize metrics such as Azure DevOps user story cycle time, enabling better tracking and process optimization.
Power BI Desktop Power Query Azure DevOps Python OpenAI API
Healthcare Technology
1 Jahr
2023-11 - 2024-10

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop Oracle SQL ...
Power BI Report Designer (Frontend)
Customized Dashboard Design
  • Designed advanced Power BI dashboards tailored to the specific reporting needs of finance and operations teams, focusing on user-friendly and insightful visualizations.
Data Integration & Optimization
  • Integrated data from SQL Server and Excel into Power BI, optimizing data models for scalability and performance.
Advanced DAX Implementation
  • Created complex DAX calculations, including time series analysis, trend detection, and predictive metrics to support strategic decisions.
Stakeholder Collaboration
  • Worked closely with stakeholders to translate business requirements into technical specifications, ensuring dashboards align with organizational goals.
Power BI Services Power BI Desktop Oracle SQL Excel
Industry: Production
10 Monate
2023-01 - 2023-10

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop SSAS Cube
Power BI Report Designer (Frontend)
Dashboard Design
  • Developed four advanced Power BI dashboards, including scatter plots, parameter-based source connections, and dashboards with complex DAX calculations.
Visualization and Implementation
  • Designed interactive visualizations in Power BI to meet business requirements and provide actionable insights.
  • Implemented advanced DAX calculations, such as percentiles and scatter plots, to enhance data analysis capabilities.
Stakeholder Collaboration
  • Engaged with specialist departments to gather requirements, translating them into detailed user stories for development.
Power BI Services Power BI Desktop SSAS Cube
Energy Sector
5 Jahre 10 Monate
2017-10 - 2023-07

various

Power BI, Excel & Visual Basic Developer (ETL & Frontend) Power BI Desktop Excel VBA ...
Power BI, Excel & Visual Basic Developer (ETL & Frontend)
Excel Dashboard Framework (EDBFW) Improvements
  • Enhanced existing Excel dashboards by adding new features (e.g., Workpaper, Snap Shot, Translation, Speed Test Tool, and Pre-Populating Utility).
  • Increased stability, reduced maintenance efforts, and introduced automation in dashboard build and testing processes.
Issue Resolution and Support
  • Analyzed and resolved issues in the Excel dashboards and framework, creating flexible solutions for specific requirements.
  • Provided training and support to colleagues on VBA and Power BI functionalities.
Strategic Analysis
  • Explored the feasibility of transitioning reporting solutions to Power BI and Excel Online
Scrum Master
  • Co-led Scrum processes for project management and development.
Power BI Desktop Excel VBA SQL Server
BIG 4 Audit Company
6 Monate
2022-07 - 2022-12

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop SQL Server ...
Power BI Report Designer (Frontend)
Dashboard and KPI Development
  • Designed and developed Power BI dashboard pages for internal controlling purposes.
  • Created KPIs based on controlling definitions to support business decision-making.
Visualization and Data Model Optimization
  • Designed intuitive Power BI visualizations tailored to user needs.
  • Optimized the existing data model for better performance and flexibility.
Stakeholder Collaboration and DAX Implementation
  • Collaborated with departments to gather requirements and derive user stories.
  • Developed complex DAX calculations, including percentiles and scatter plots, to enable detailed analysis.
Power BI Services Power BI Desktop SQL Server SSAS Cube Excel
Energy Sector
2 Jahre 3 Monate
2015-07 - 2017-09

various

Reporting Specialist SAP R/3 SAP Analysis Office VBA (Excel ...
Reporting Specialist
European Reporting Activities
  • Took over and standardized European reporting processes across multiple locations (Germany, Switzerland, Denmark)
  • Generated and processed data using SAP and business warehouse systems for cost and consolidated income reporting.
Process Improvement and Automation
  • Streamlined reporting processes, from data retrieval to report delivery, through automation with VBA.
  • Standardized European reports using data from various BW systems.
On-Site Analysis and Solutions
  • Conducted on-site analysis to address technical and organizational challenges during process acquisitions.
SAP R/3 SAP Analysis Office VBA (Excel Access PPT Outlook) BW Systems
Chemical Industry Sector

Aus- und Weiterbildung

Aus- und Weiterbildung

1999 - 2004
Bachelor/Master in Economics and Business
Universitá Ca Foscari Venezia
  • Statistics and Analysis of complex systems.

Kompetenzen

Kompetenzen

Top-Skills

Business Intelligence & Data Analytics Excel (Guru-Level) SQL Power BI (Desktop & Services Azure DevOps Reporting Python (Datenanonymisierung OpenAI API-Integration). SCRUM KANBAN Stakegholder Management Azure Analysis Services (AAS) Azure DevOps. Git Visual Studio Visual Studio Code Datenanonymisierung OpenAI API-Integration Datenmodellierung DAX-Entwicklun Prozessoptimierung Dashboard-Frameworks Datenintegration Data Warehouse

Produkte / Standards / Erfahrungen / Methoden

Miscellaneous
I am a very collaborative person, solution oriented, focused on improvement and development, with proactive attitude. Due to my expert knowledge of Microsoft Excel (guru level), Power BI, Microsoft Access and VBA I work with a high level of automation
  • Vision and Mindset
    • Data Driven, Technology Enthusiast

Qualifications
  • Programming, Database and Cloud
    • >10 years of experience: Excel, Visual Basic
    • 5-10 years of experience: PowerBI, Power Query, DAX, MS Access
    • 2-5 years of experience: SQL Server Management Studio (SSMS); MS Reporting Services (SSRS); Data Warehouse; Transact-SQL; Visual Studio, Azure Analysis Services (AAS), Git, Visual Studio Code, AzureDevOps
  • Project Management
    • Agile Programming (Defining Requirements/ User Stories, implement solution, present results to stakeholders), SCRUM, KANBAN, Classical Project Management (V-Model)

Experience

08/2023 ? today
Power BI Developer (Full Time) 
HexaBase GmbH

07/2022 ? 07/2023
Power BI Developer (Part Time)
HexaBase GmbH

10/2017 - 07/2023
Automatisation expert, Data visualization specialist
KPMG AG

12/2010 - 09/2017
Senior Reporting Specialist, Controlling Services
BASF AG

06/2005 - 01/2009
Store Manager
AGILE ITALIA/ MarcusEvans

Einsatzorte

Einsatzorte

Deutschland
möglich

Projekte

Projekte

5 Monate
2025-06 - 2025-10

various

Power BI Consultant Power BI Desktop Power Query Azure DevOps
Power BI Consultant
Usage and Cost Monitoring Dashboard
  • Developed a Power BI dashboard integrating usage metrics and cost data to identify  underutilized reports, datasets, and workspaces, enabling optimization and proactive cleanup.
  • Implemented filtering by business unit/region and automated alerts based on usage-to-cost thresholds.
Workspace Lifecycle Management
  • Built detection logic for abandoned or inactive workspaces using activity metrics and owner status, supporting governance decisions for archival or deletion.
Documentation and Best Practices
  • Authored key chapters of the internal PBI-Toolkit, including Enterprise Gateway setup, incremental refresh, OLS implementation, SAP BW/4HANA connectivity and productivity tips.
Power BI Desktop Power Query Azure DevOps
Healthcare Technology
3 Monate
2025-04 - 2025-06

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop Jira
Power BI Report Designer (Frontend)
  • Dashboard Development
    • Designed and implemented internal back-office dashboards for test status tracking using Power BI and Excel-based solutions.
  • Visualization and DAX Implementation
    • Created interactive visualizations and advanced DAX calculations, including scatter plots and percentile analyses.
  • Stakeholder Collaboration
    • Worked with specialist departments to gather requirements and translate them into user stories for development.
Power BI Services Power BI Desktop Jira
Energy Sector
4 Monate
2024-12 - 2025-03

various

Enhancement Developer for Calculation Tool/ Web Application VB.Net SQL Server Excel ...
Enhancement Developer for Calculation Tool/ Web Application
Legacy Tool Enhancement
  • Participating in the enhancement of a legacy calculation tool/web application originally developed 10-20 years ago in Excel and VB.Net Windows Forms.
  • Optimizing the tool?s on-prem SQL database for improved performance and scalability.
Feature Updates and Modernization
  • Adding new functionalities to the web application, improving usability and adapting it to modern user requirements.
  • Supporting the transition of key workflows, such as data entry and reporting, from Excel to a centralized web-based interface.
Collaboration and Documentation
  • Working closely with stakeholders to refine technical requirements, ensuring updates align with business needs.
  • Documenting enhancements to facilitate knowledge transfer and future maintenance
VB.Net SQL Server Excel VBA Windows Forms
Energy Sector
2 Monate
2024-10 - 2024-11

various

Power BI Consultant Power BI Desktop Power Query Azure DevOps ...
Power BI Consultant
Power BI Template Development
  • Designed and implemented Power BI templates to streamline reporting processes and standardize visualizations.
Power BI Guidance and Governance
  • Restructured the Power BI guidance and data governance website, contributing additional pages to enhance usability and documentation.
  • Identified new content topics for the website by analyzing approximately 300 support tickets and emails from the global IT Power BI support team using OpenAI API.
    • Developed a proof of concept in Power Query to connect with the OpenAI API.
    • Transitioned to Python for better scalability and efficient data anonymization.
Azure DevOps Reporting
  • Created a Power BI analytics report to visualize metrics such as Azure DevOps user story cycle time, enabling better tracking and process optimization.
Power BI Desktop Power Query Azure DevOps Python OpenAI API
Healthcare Technology
1 Jahr
2023-11 - 2024-10

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop Oracle SQL ...
Power BI Report Designer (Frontend)
Customized Dashboard Design
  • Designed advanced Power BI dashboards tailored to the specific reporting needs of finance and operations teams, focusing on user-friendly and insightful visualizations.
Data Integration & Optimization
  • Integrated data from SQL Server and Excel into Power BI, optimizing data models for scalability and performance.
Advanced DAX Implementation
  • Created complex DAX calculations, including time series analysis, trend detection, and predictive metrics to support strategic decisions.
Stakeholder Collaboration
  • Worked closely with stakeholders to translate business requirements into technical specifications, ensuring dashboards align with organizational goals.
Power BI Services Power BI Desktop Oracle SQL Excel
Industry: Production
10 Monate
2023-01 - 2023-10

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop SSAS Cube
Power BI Report Designer (Frontend)
Dashboard Design
  • Developed four advanced Power BI dashboards, including scatter plots, parameter-based source connections, and dashboards with complex DAX calculations.
Visualization and Implementation
  • Designed interactive visualizations in Power BI to meet business requirements and provide actionable insights.
  • Implemented advanced DAX calculations, such as percentiles and scatter plots, to enhance data analysis capabilities.
Stakeholder Collaboration
  • Engaged with specialist departments to gather requirements, translating them into detailed user stories for development.
Power BI Services Power BI Desktop SSAS Cube
Energy Sector
5 Jahre 10 Monate
2017-10 - 2023-07

various

Power BI, Excel & Visual Basic Developer (ETL & Frontend) Power BI Desktop Excel VBA ...
Power BI, Excel & Visual Basic Developer (ETL & Frontend)
Excel Dashboard Framework (EDBFW) Improvements
  • Enhanced existing Excel dashboards by adding new features (e.g., Workpaper, Snap Shot, Translation, Speed Test Tool, and Pre-Populating Utility).
  • Increased stability, reduced maintenance efforts, and introduced automation in dashboard build and testing processes.
Issue Resolution and Support
  • Analyzed and resolved issues in the Excel dashboards and framework, creating flexible solutions for specific requirements.
  • Provided training and support to colleagues on VBA and Power BI functionalities.
Strategic Analysis
  • Explored the feasibility of transitioning reporting solutions to Power BI and Excel Online
Scrum Master
  • Co-led Scrum processes for project management and development.
Power BI Desktop Excel VBA SQL Server
BIG 4 Audit Company
6 Monate
2022-07 - 2022-12

various

Power BI Report Designer (Frontend) Power BI Services Power BI Desktop SQL Server ...
Power BI Report Designer (Frontend)
Dashboard and KPI Development
  • Designed and developed Power BI dashboard pages for internal controlling purposes.
  • Created KPIs based on controlling definitions to support business decision-making.
Visualization and Data Model Optimization
  • Designed intuitive Power BI visualizations tailored to user needs.
  • Optimized the existing data model for better performance and flexibility.
Stakeholder Collaboration and DAX Implementation
  • Collaborated with departments to gather requirements and derive user stories.
  • Developed complex DAX calculations, including percentiles and scatter plots, to enable detailed analysis.
Power BI Services Power BI Desktop SQL Server SSAS Cube Excel
Energy Sector
2 Jahre 3 Monate
2015-07 - 2017-09

various

Reporting Specialist SAP R/3 SAP Analysis Office VBA (Excel ...
Reporting Specialist
European Reporting Activities
  • Took over and standardized European reporting processes across multiple locations (Germany, Switzerland, Denmark)
  • Generated and processed data using SAP and business warehouse systems for cost and consolidated income reporting.
Process Improvement and Automation
  • Streamlined reporting processes, from data retrieval to report delivery, through automation with VBA.
  • Standardized European reports using data from various BW systems.
On-Site Analysis and Solutions
  • Conducted on-site analysis to address technical and organizational challenges during process acquisitions.
SAP R/3 SAP Analysis Office VBA (Excel Access PPT Outlook) BW Systems
Chemical Industry Sector

Aus- und Weiterbildung

Aus- und Weiterbildung

1999 - 2004
Bachelor/Master in Economics and Business
Universitá Ca Foscari Venezia
  • Statistics and Analysis of complex systems.

Kompetenzen

Kompetenzen

Top-Skills

Business Intelligence & Data Analytics Excel (Guru-Level) SQL Power BI (Desktop & Services Azure DevOps Reporting Python (Datenanonymisierung OpenAI API-Integration). SCRUM KANBAN Stakegholder Management Azure Analysis Services (AAS) Azure DevOps. Git Visual Studio Visual Studio Code Datenanonymisierung OpenAI API-Integration Datenmodellierung DAX-Entwicklun Prozessoptimierung Dashboard-Frameworks Datenintegration Data Warehouse

Produkte / Standards / Erfahrungen / Methoden

Miscellaneous
I am a very collaborative person, solution oriented, focused on improvement and development, with proactive attitude. Due to my expert knowledge of Microsoft Excel (guru level), Power BI, Microsoft Access and VBA I work with a high level of automation
  • Vision and Mindset
    • Data Driven, Technology Enthusiast

Qualifications
  • Programming, Database and Cloud
    • >10 years of experience: Excel, Visual Basic
    • 5-10 years of experience: PowerBI, Power Query, DAX, MS Access
    • 2-5 years of experience: SQL Server Management Studio (SSMS); MS Reporting Services (SSRS); Data Warehouse; Transact-SQL; Visual Studio, Azure Analysis Services (AAS), Git, Visual Studio Code, AzureDevOps
  • Project Management
    • Agile Programming (Defining Requirements/ User Stories, implement solution, present results to stakeholders), SCRUM, KANBAN, Classical Project Management (V-Model)

Experience

08/2023 ? today
Power BI Developer (Full Time) 
HexaBase GmbH

07/2022 ? 07/2023
Power BI Developer (Part Time)
HexaBase GmbH

10/2017 - 07/2023
Automatisation expert, Data visualization specialist
KPMG AG

12/2010 - 09/2017
Senior Reporting Specialist, Controlling Services
BASF AG

06/2005 - 01/2009
Store Manager
AGILE ITALIA/ MarcusEvans

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.