Senior Data & Reporting Specialist | Power BI Expert | Turning complex data into business solutions Automation Expert | Excel...
- Verfügbarkeit einsehen
- 0 Referenzen
- auf Anfrage
- 10247 Friedrichshain-Kreuzberg
- Umkreis (bis 200 km)
- it | en | es | de
- 27.04.2026
Kurzvorstellung
Automation Expert | Excel Guru | Out-of-the-box Thinker
Qualifikationen
Projekt‐ & Berufserfahrung
7/2022 – offen
Tätigkeitsbeschreibung
Power BI Report-Designer (Frontend) 07/22 – now Energy Sector
● Source Data: Excel Files and SSAS cube
● Advanced Power BI Dashboard (Scatter Plot, Parameter based for source connection, complex DAX calculation.)
● Develop various Dashboard pages for internal Controlling
● Develop various KPIs based on definition of Controlling
● Tools: Power BI Services, Power BI Desktop, SQL Server
● My Role
○ Design Visualization in Power BI
○ Discuss the needs with the specialist departments and derive user stories from them
○ Optimize existing data model
○ Implement complex calculations in DAX (percentiles, scatter plots, etc.)
Power Bi
10/2017 – 4/2023
Tätigkeitsbeschreibung
Improvement of the existing Excel-Dashboards process. Development of new features and tools as part of the Excel Dashboard Framework (like Workpaper, Snap Shot, Translation, Speed Test Tool and Pre-Populating Utility).
● Improved stability and reduced maintenance efforts for the EDBFW. Increased maturity of automation in build production of the dashboards and in the Testing tool.
● Assessment and fixing of issues with the Excel Dashboards or the framework. Create smart solutions to flexible dashboard functions. More focused on General Ledger Analysis and
Financial Services, I helped in other projects. Lately, I also work as a Scrum Master (together with a colleague). ● Analysis of the possibility to add (or move to) Power BI and the possibility to move to Excel online.
● Always available to help colleagues (for example with problems concernin VBA) and to explain new features / possibilities (for example regarding Power BI).
Power Bi, Agile Methodologie, Scrum, VBA (Visual Basic for Applications), Microsoft Excel
9/2015 – 9/2017
Tätigkeitsbeschreibung
● Analysis of the challenges related to the acquisition of new processes, from the technical to the organizational point of view, finding solutions adapted to the available resources and in time with the deadline.
● Acquisition of European reporting activities, including on-site presence (Germany, Switzerland, Denmark). Data generation and processing using SAP Analysis Office and various business warehouse systems for cost and consolidated income (including SAP R / 3). Improvement of the creation process of the reports, from the data retrieve to the delivery of the report, including high level of automatization using VBA (excel, access, PPT, outlook, pdf…). Introduction and standardization of European reports with components from different BW systems
Power Bi, Microsoft Excel, SAP HANA, VBA (Visual Basic for Applications)
Ausbildung
Universitá Ca Foscari Venezia
Venedig
Über mich
Started building complex reporting solutions using Excel and VBA, later evolving into Power BI, Power Query, and DAX from their earliest stages. Deep understanding of data modeling, ETL processes, and scalable reporting architectures beyond standard “out-of-the-box” usage.
Strong problem-solving mindset with the ability to design and implement solutions where standard approaches or AI-generated outputs are not sufficient.
Experienced in working with international stakeholders, translating complex business requirements into high-quality, scalable, and user-friendly reporting solutions.
Weitere Kenntnisse
Data & BI
• Power BI (Advanced), DAX, Data Modeling (Star Schema, performance optimization)
• Power Query (M), ETL design, Dataflows
• Dashboard Design (UX-focused, business-driven)
• Dataset optimization and performance tuning
• Row-Level Security (RLS)
• Experience with large-scale reporting environments
Data & Backend
• SQL (T-SQL), Data Warehousing concepts
• Azure / Fabric (working knowledge)
• SSAS / AAS
Automation & Legacy Systems (Key Differentiator)
• Excel (Expert), VBA, MS Access
• Development of enterprise-level reporting frameworks and automation solutions
Working Style
• Solution-oriented mindset
• Strong analytical thinking
• Independent & remote-first working approach
• Stakeholder communication
WHAT I BRING BEYOND STANDARD BI DEVELOPMENT
• 15+ years of hands-on experience in complex reporting and data analysis environments
• Deep understanding of data modeling — not just tool usage
• Ability to solve complex problems beyond standard solutions
• Experience transforming legacy systems into modern BI architectures
• Strong focus on scalability, quality, and maintainability
• AI (ChatGPT) used as a support tool — not as a replacement for expertise
PROFESSIONAL EXPERIENCE
Power BI Developer
HexaBase GmbH | 08/2023 – Present
• Strong experience in migration and redesign of reporting systems into scalable Power BI environments
• Design and implementation of advanced Power BI solutions in international environments
• Development of complex data models and high-performance DAX logic
• Creation of scalable ETL pipelines using Power Query
• Close collaboration with stakeholders (e.g. Deepak, Rahna)
• Delivery of custom solutions beyond standard approaches
• Continuous improvement of reporting processes and automation
• Delivered multiple client projects across energy, healthcare, and production sectors, focusing on scalable and business-critical solutions, such as:
o As Power BI Consultant for Healthcare Technology | 06/2025 – 10/2025
Developed governance-focused dashboards (usage, cost monitoring)
Implemented logic to identify unused datasets and optimize platform usage
Designed solutions for workspace lifecycle management
Contributed to enterprise Power BI documentation (gateway, incremental refresh, OLS, SAP BW integration)
o As Power BI Report Designer (Frontend) for Energy Sector | 2025
Designed dashboards for operational and testing processes
Developed advanced DAX logic (percentiles, scatter analysis)
Translated business requirements into technical solutions
o As Enhancement Developer (Legacy System) for Energy Sector | 12/2024 – 03/2025
Modernization of legacy Excel/VB.NET application
SQL database optimization
Migration of workflows from Excel to web-based systems
o As Power BI Consultant for Healthcare Technology | 10/2024 – 11/2024
Developed Power BI templates for global usage
Built reporting based on Azure DevOps metrics
Created AI-supported analysis workflows (OpenAI API integration)
Power BI Developer / Excel Automation Expert
KPMG AG | 10/2017 – 07/2023
• Developed and enhanced enterprise Excel reporting frameworks
• Introduced automation and reduced manual workload significantly
• Provided training in VBA and Power BI
• Co-led Scrum processes
Senior Reporting Specialist (Controlling)
BASF AG | 12/2010 – 09/2017
• Managed European reporting processes across multiple countries
• Automated reporting workflows using VBA
• Worked with SAP R/3 and BW systems
• Delivered consolidated financial and cost reports
CERTIFICATIONS
• Microsoft Power BI Data Analyst (PL-300)
EDUCATION
• M.Sc. Economics & Business, Ca’ Foscari University, Venice (Statistics & Complex Systems)
LANGUAGES
• German (Professional, improving) , English (Professional), Spanish (Professional), Italian (Native)
Persönliche Daten
- Italienisch (Muttersprache)
- Englisch (Fließend)
- Spanisch (Fließend)
- Deutsch (Gut)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden