Business-Intelligence-Entwickler

• Collaborates as a member of a scrum team to deliver BI products that support medical professionals in enhancing the quality of their services;

• Converts functional requirements into SQL scripts within the Data Warehouse (DWH);

• Maintains over 25 SSAS tabular models to ensure data integrity and performance;

• Optimizes Power BI reports for usability and efficiency. Acts as a DevOps release manager, overseeing daily build, release, and refresh processes.

• Identifies and addresses technical debt within the organization’s golden analysis services cube;

• Develop new BI products, including A Financial Report that integrates Excel-based master data with general ledger numbers from the ERP;

• A Market Tracker to benchmark the organization's sales performance against key competitors;

• Supports the BI team in adopting best practices for agile and DevOps, including Utilizing backlogs and conducting sprints;

• Implementing a robust release process with pull requests and formalized user acceptance testing.

• Develops and maintains a Covid-19-related data platform for Dutch regional health services;

• Fulfills reporting needs for clients and external stakeholders, including labs and the Ministry;

• Creates and manages over 50 Power BI reports with live connections to on-premises SSAS cubes;

• Ensures data consistency and accuracy by feeding SSAS cubes with data from SQL databases using stored procedures;

• Implements and manages business logic primarily written in SQL to support data-driven insights and reporting.

• Worked on standardizing reports within the department by establishing Power BI as the default visualization tool;

• Built a golden Power BI dataset to serve as a central resource for creating dashboards and paginated reports for both internal and external stakeholders;

• Developed a proof of concept dashboard based on the golden dataset to demonstrate its effectiveness to external stakeholders.

• Developed a central Power BI report for IT analytics and KPIs, tailored to the needs of IT developer teams;

• Extracted data from five key sources: ServiceNow, Mendix, GRC Control, Jira, and Azure DevOps, using Power BI Data Flows (Power Query) and REST API calls for complex queries;

• Combined source data with mapping files in a tabular model and implemented DAX calculations for KPIs;

• Designed and visualized a 20-page Power BI report, ensuring clarity and ease of navigation;

• Built a proof-of-concept Azure solution for granular data ingestion, leveraging: Azure Data Factory Pipelines: For incremental data ingestion. Stored Procedures: For data transformation. Azure SQL: For storing and querying the processed data.

Global Media Hub

• Developed a centralized, enterprise-level platform for decentralized data and analytics from Facebook, Google, and finance departments;

• Extracted and validated raw data from SAP HANA views using Power BI dataflow;

• Collected business requirements from stakeholders to design and implement the necessary mapping and DAX logic for a harmonized tabular Power BI model;

• Enforced data security by implementing row-level security in the Power BI model;

• Created 9 Power BI reports for both internal and external stakeholders, serving 840 users across 65 countries.

Customer Data Platform Italy

• Collaborated with Heineken Italy’s marketing team to gain insights into digital customers and identify reporting needs;

• Partnered with a data engineer to convert raw JSON data into structured tables using Azure Data Factory and Databricks;

• Designed Power BI reports that utilized structured data stored in Azure SQL databases.

Covid-19 Supply Chain & Procurement

• Collaborated with an agile team to provide senior management with real-time insights into operational risks during the COVID-19 pandemic;

• Built a Microsoft Power App to standardize risk reporting and updating by international HQ and local officers;

• Combined risk data from the Power App with historical supply chain data in Azure SQL, creating a comprehensive dataset for analysis in Power BI;

• Delivered the first report within one month, followed by iterative expansions that incorporated financial risk, inventory, and logistics data;

• Supported over 300 users in mitigating COVID-19-related bottlenecks within their operations.

Treasury Dashboards

• Eliminated manual effort and inefficiencies in Excel reporting for the Treasury team;

• Translated business logic and calculations into four fully automated Power BI reports;

• Used Power Query to ingest flat files and applied DAX for calculations and data modeling.

• Delivered a set of pre-defined Profit & Loss (P&L), Sales, and Inventory reports in Power BI as requested by the customer;

• Connected to an on-prem SQL server using a Power BI gateway to extract ERP data required for the reports;

• Ensured timely delivery by bringing the reports to production within two months;

• Designed reports to meet the needs of both senior management and staff across commerce, purchasing, and finance departments.