Freelancer profile translated to English.
Back to original languageAbout Sven
Enterprise Reporting & Analytics Architect
I support companies in transforming fragmented reporting landscapes into scalable, trustworthy reporting and analytics platforms.
With over 20 years of experience in Business Intelligence, Data Warehousing, Analytics, and Enterprise Reporting, I guide clients from requirements analysis, data modeling, and KPI architecture to the implementation of modern reporting solutions based on Microsoft Power BI, SQL Server, Python, and Dynamics 365.
My focus is not on creating individual dashboards, but on the conception and implementation of holistic reporting ecosystems that provide management, business units, and operational teams with consistent and reliable key figures.
I have realized projects across industries for international companies in banking, pharmaceuticals, manufacturing, telecommunications, insurance, media, and logistics.
Typical services:
• Reporting & Analytics Architecture
• Power BI & Microsoft Fabric
• KPI and Key Figure Systems
• Data Modeling & Data Warehousing
• SQL Server & Performance Optimization
• Dynamics 365 Reporting Modernization
• Finance & Controlling Reporting
• ETL/ELT & Data Integration
• Governance & Standardization
• BI Transformation and Reporting Roadmaps
My particular focus is on bridging business requirements and technical implementation to create sustainable reporting solutions with high acceptance and measurable added value.
German
Native or bilingual
English
Fluent
French
Conversational
Can work on-site
Konstanz (up to 50km)
Experience
- Reise / Tourismus / DigitalplattformConsulting / Requirements Engineering / Solution DesignTRAVEL AND TOURISMJune 2025 - November 2025 (5 months)München, Germany• Requirements Engineering for HR Controlling and Personnel Planning• Evaluation of existing reporting structures and data flows• Logical data model design• ETL design: Extraction, normalization, and mapping of planning-relevant process and master data from LucaNet, Personio, and SAP exports using Power Query/M• Power BI star schema design and implementation• Power BI role concept and row-level security design for planning and HR controlling views• Integrated Excel/Power BI solution for personnel planning and HR controlling• Power Automate support for workflow automationStakeholder / Delivery Context• Interaction with Head of HR Controlling, CFO, Head of IT, and BI Team Lead• Modernization of personnel planning and reporting in the HR controlling environment• Translation of business planning requirements into an integrated Excel/Power BI target solutionTechnology ContextPower BI, DAX, Power Query/M, Excel, VBA, SAP, LucaNet, Personio, Power Automate
- Maschinenbau / FertigungConsulting / Requirements Engineering / Solution Design / Reporting ArchitectureMECHANICAL ENGINEERINGJanuary 2025 - April 2025 (3 months)Architecture and Requirements Engineering ERP Reporting KPI Definition, KPI Catalog Design Accounting, Customer• Design and implementation of SQL Server-based generic and report-specific views / data marts• ETL pipeline implementation with Power BI / Power Query/M• Report-specific DAX measures based on the KPI catalog• Microsoft Fabric setup for the ERP data pipeline and Python-based transformation of Parquet files• Power BI role concept and RLS design for report-specific access logic• Design and implementation of Power BI reports as a replacement for legacy Navision reports• Connection of Excel Power Pivot to SQL Server reporting structures via SSAS• Data architecture and deployment consulting Stakeholder / Delivery Context• Interaction with senior technology stakeholders, including CTO level• Reporting modernization in the ERP migration context• Business-to-technology translation across ERP reporting, KPI logic, and BI delivery
- PharmaConsulting / Project Coordination / Solution DesignPHARMACEUTICALS INDUSTRYOctober 2023 - December 2024 (1 year and 2 months)München, GermanyProcess, system, and implementation consulting for Salesforce-based target achievement, payout calculation, and BI integration. Architecture and Scope• Business, data, and system analysis for incentive reporting• Executive-level consulting for automating Salesforce incentive processes• Target setting, target scaling, and payout calculation logic under works council-sensitive business rule requirements• Implementation of a target optimization algorithm based on Simplex Linear Programming• Data model and ETL process design and implementation• Design and implementation of an operational prototype / POC based on Excel, VBA, and Power Query/M• REST API interface definitions for Veeva Align integration into the incentive reporting landscape• Axtria Sales IQ implementation consulting within the Salesforce / Power BI incentive reporting landscape• Evaluation of Tableau reports and migration assessment to Power BI Stakeholder / Delivery Context• Interaction with senior stakeholders from Commercial and IT• Service provider management and coordination in the Axtria-related implementation environment• Coordination of the vendor / development team• Business rule-intensive reporting environment with target achievement and payout logic Technology Context BI
Recommendations
Be the first to recommend Sven
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Industrial ClerkIHK2002