Microsoft Power BI Experts in Nuremberg

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide context-based business information.

Development of an AI agent with Function/Tool Calling for the secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Building automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and Service Principal, and integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

• IT consulting
• Power Platform & Databricks
• AI software development (custom software)
• Commercial responsibility for the company

• Analysis of the role of marriage as an informal insurance in Germany using econometric methods (supervisor: Prof. Dr. Harald Tauchmann).
• Prepared and cleaned multiple panel datasets and extracted relevant variables to create a final panel dataset with over 36,000 observations (2006–2020, SOEP).
• Designed an IV model in Stata to examine the causal link between couple separation and health shocks (mental/physical).
• Conducted robustness checks to ensure stability and validity of the results.

• Collected, analysed, and interpreted HR data from multiple systems
• Conducted ad-hoc people data analyses for stakeholders
• Supported Employee Listening and ensured actionable survey insights
• Built intuitive dashboards and visualizations in SuccessFactors, PowerBI, and Qualtrics
• Produced regular reports and dashboards on key HR metrics
• Contributed to people analytics projects as a junior team member
• Collaborated with HR Tech and Data teams to improve data quality
• Ensured ethical and governed data use with Legal, Data Privacy, Labour Relations and Works Council

• Development of strategies, processes and system requirements to further develop the lead and campaign streams of a Salesforce system for the subsystems Sales Cloud, Marketing Cloud and Analytics Cloud
• Gathering and creation of marketing strategy concepts for direct sales, focusing on lead generation for new and existing customers
• Analysis and optimization of existing and new contact points
• Derivation of system requirements and user tests for new developments
• Establishment of a requirements and implementation process for business needs at the interface between CRM strategy and marketing system operations
• Facilitation of ideation workshops with the project's stakeholders
• Mediation between business and technical project stakeholders
• Analysis and post-documentation of existing marketing strategies and the system functions already created for them
• Analysis of target groups and pre-system data quality as a foundation for new CRM strategies
• Consultation on content and asset strategy for marketing campaigns
• Definition of KPIs and other performance criteria for the system and CRM strategy

• Integrated complex AI-based energy system models into the frontend framework, enabling the visualization of insights for 6+ key clients and maximizing energy utilization.
• Maximized energy efficiency and utilization by architecting the seamless data flow between AI models and the user interface for rapid, actionable reporting.

• Developed KPI dashboards using Power BI and DAX for 4+ business units, improving reporting transparency and strategic decision support.
• Migrated enterprise finance data views into dbt models, implementing modular SQL transformations, version-controlled data pipelines, and automated documentation to create a scalable analytics layer.
• Built dimensional data models in Snowflake for enterprise finance data, enabling scalable forecasting and supporting executive decision-making.
• Designed end-to-end ETL/ELT pipelines using Snowflake and SAP HANA, integrating data from 3+ enterprise systems.
• Automated monthly reporting workflows using SQL and Power BI, delivering strong business impact by reducing manual effort by 80%.
• Collaborated with finance stakeholders to translate business requirements into analytical data models, supporting strategic decision-making cycles.
• Delivered ad-hoc financial reports using Power BI, reducing turnaround time by 60%.
• Implemented data validation logic in SQL, resolving 95% of recurring data quality issues.

• Designed a target operating model (including strategic mid-term planning and operational staffing) for the restructuring and capacity management process of the product workstreams to increase development efficiency, boost employee retention and improve profitability
• Integrated targeted incentives such as budget targets, contribution margin accounting and incentive schemes into the operating model

• Ongoing support for a Lucanet project in Hamburg (logistics/financial market)
• Consulting on budgeting topics
• Consulting on fixed asset accounting issues
• Support with analyses
• Implementation of Lucanet at a customer near Munich (retail/building materials)
• Support with the initial setup
• Preparation of Excel data imports
• Development of an SQL interface to Navision data
• Ongoing support for a Lucanet project in Munich (pharmaceuticals/medical)
• Data output to SQL Server
• Support and consulting in setting up legal consolidation
• Ongoing support for a Lucanet project in Cologne (publishing)
• Preparation of Excel imports
• Support with the initial setup (project restart)
• Ongoing support for a Lucanet project in Ludwigsburg (chemicals, printing inks, hobby paints)
• Connecting Lucanet to an existing data warehouse solution (SQL)
• Ongoing support for a Lucanet project in Bad Staffelstein (solar industry)
• Connecting Lucanet to an existing data warehouse solution (SQL)
• Connecting the Lucanet Reporting Package
• Support and consulting in setting up legal and management consolidation
• Ongoing support for a Lucanet project in Zeven (transport and logistics)
• Administration of the existing Lucanet solution
• Connecting the Lucanet Reporting Package
• Support and consulting in setting up legal and management consolidation
• Support with planning and forecasting
• Implementation of Lucanet at a customer in Luxembourg (retail)
• Installation and setup
• Support with the initial setup
• Preparation of Excel/DWH interface data imports
• Implementation of Lucanet at a customer in Nuremberg (manufacturing)
• Support with the project restart
• Design of reporting and planning
• Setup of import packages
• Lucanet in-house consultant at an international software group with a focus on M&A
• Consulting and support for the group holding company and business units regarding the implementation, rollout and operation of the Lucanet Disclosure Management solution
• Implementation of Lucanet at a customer in Wassertrüdingen
• Database setup and configuration
• Connecting source systems using Lucanet interfaces
• Preparation of consolidated financial statements
• Support with the consolidation process
• Support with the reporting process
• Support for Lucanet at a customer in Stuttgart
• Support with the consolidation process
• Support with the reporting process
• Support with the planning process
• Sparring partner for the specialist department
• Support for Lucanet at a customer in Landau
• Implementation of cost center allocation in Lucanet
• Support with the consolidation process
• Support for a Lucanet carve-out for a customer in Waldstetten
• Database setup and configuration
• Design and implementation of BI software at a staffing services provider in Nuremberg
• Connecting various source systems
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Ongoing support and further development
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of BI software at an elevator company in Nuremberg
• Connection to Navision BC
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Based on: Cubeware Importer, SQL Server
• Design and implementation of BI software at a logistics company in Leipzig
• Connection of various source data
• Development of data warehouse and ETL processes
• Creation of several cubes and data marts
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of BI software at a corporate group in Freilassing
• Connection of various source data
• Development of data warehouse and ETL processes
• Based on: Cubeware Importer, SQL Server, TM1
• Design and implementation of a new reporting environment based on SQL Server and Power BI
• Best practice consulting for the creation of a data warehouse
• Support with report creation in Power BI
• Support with transforming an existing DWH solution to SAP BW
• Analysis and documentation
• Ongoing consulting on processes
• Support with designing BW/SAC models
• Reporting in SAC
• Rebuilding the BI environment at an international company from Berlin (manufacturing/retail)
• Connecting SAP BO to the new DWH (SSIS)
• Creation of tabular model cubes (SSAS)
• Creation of reports and KPIs
• User training

• Acting as the program lead for digitally enabled services, overseeing projects like Transformation, remote scanning (WeScan), e-commerce, and OneGate (budget: ~€5M p.a.).
• Developed the transformation strategy and roadmap for a supply and demand platform on ServiceNow, driving harmonization and integration of legacy systems.
• Led cross-functional teams in designing and rolling out these digital business models on the ServiceNow backend platform.
• Enabled strategic decision-making by building Azure DevOps transparency structures and using Agile methods like PI Planning and WSJF prioritization.
• Served as the business demand manager and digital counterpart for CS CRM.
• Managed internal project organization, external partners, and organizational interfaces and dependencies with other departments.
• Executed RFPs and managed vendors according to contracts and internal requirements.
• Contributed to Project sucCeSs, Northstar, and was part of the RaaS Tiger Team and Spryker Customer Advisory Board.

• Built a CRNN model with VGG16 and BiLSTM backbone for text-based CAPTCHA recognition
• Achieved 9.37% character error rate and 68.36% sequence accuracy on validation data
• Expanded data augmentation pipeline with distortions, noise injection, and clutter to improve robustness
• Conducted detailed error analysis on confusable characters (O, Q, D) and proposed error-specific augmentation
• Tech Stack: Python, TensorFlow/Keras, OpenCV, NumPy, Matplotlib

• Created database schemas and liaised with geographically distributed teams using waterfall methodology
• Participated in business workshops and authored technical specification documents aligned with architectural requirements
• Developed high-quality code deliverables and reports using repository tools

• Focused on exploring the intersection of Music and AI.

• Consulted on project management office (PMO) topics, including the optimization of processes, methods and governance structures to increase the efficiency and effectiveness of projects
• Provided comprehensive executive support, including preparing presentations and reports, managing confidential communications, and organizing and streamlining administrative processes
• Developed and implemented strategic marketing plans to increase brand awareness, including the conception and implementation of campaigns via various channels, and the measurement and analysis of campaign results for continuous optimization of marketing measures