Oracle Hyperion Expert

• Prepared and reviewed quarterly royalty settlements for licensors across music, publishing and media brands, including minimum guarantees, recoupment, returns reconciliation and process optimisation.
• Reconstructed historical licensing data for an external audit by a major US studio, covering music publishing and recorded music across ROW and AUS, and coordinated the resulting statements with the licensor.
• Supported the reconciliation of music royalties with the German collecting society and its international hub for 2018 to 2024.
• Assessed licensing data for accruals and provisions, and structured metadata for contract negotiations.
• Designed target processes and SOPs for a royalty automation tool and accompanied testing during rollout.

Responsibilities: Management of the Group’s Finance and central functions in Europe, including Controlling, FP&A, Accounting, Treasury, Tax, Legal and IT. Responsibility for value creation, exit readiness, M&A integration and business transformation with P&L responsibility of EUR 200 Mio. Reporting to the PE shareholder and the Advisory Board; management of 45 FTE, including 7 direct reports.

Key achievements:

• Earnings improvement: Increased EBITDA by around 10%. Improved liquidity through working capital measures and reduced HQ costs.
• Exit readiness & financing: Expanded investor reporting, governance and controls; managed investor and banking relationships and led refinancing and capital structure measures.
• Buy-and-build readiness: Prepared the Group for international acquisitions and the integration of new dermatological platforms.
• Reporting & IT transformation: Implemented, optimized and launched a new LucaNet solution for 80 companies for Group reporting and consolidation, with a savings target of 1–2 FTE and a closing process that was 2–3 days faster, as well as modernized scalable IT systems for greater transparency and performance management.
• AI & digitalization: Defined and rolled out an AI strategy for the Group and introduced AI tools (Microsoft Copilot and ChatGPT) for around 100 users at headquarters, achieving productivity and efficiency gains in Finance.
• Establishment of the Dutch platform: Established and restructured the platform and took over its commercial and operational management, including the implementation of a new ERP system (AFAS).

• Interim management as freelancer for finance accounting, HR, controlling, accounting and leadership, process optimization
• Clients: Esprit (DE/CH), MSD (CH), Sedus Stoll AG (CH), Brooks AG (CH), Yves Rocher (DE), Lilium (DE) and others

• Interim Head of Controlling at a medium-sized industrial group in mechanical engineering: setup of group controlling, preparation for the planned IPO, realignment of monthly reporting
• Project at a medium-sized company in the steel and mechanical engineering industry: further development of cost and performance accounting; setup of a structured overhead cost sheet to determine hourly and overhead allocation rates for pre- and post-calculation; setup of a profit center accounting system to show the P&L by business unit
• Interim CFO at a startup in optics / photonics: preparation of financial and liquidity plans to prepare for financing rounds and funding projects; contact person for investors in due diligence processes; setup of monthly reporting for internal and external stakeholders; preparation of annual financial statements together with an external tax advisory firm (inventory valuation, provisions, etc.); contact person for project sponsors in funded development projects; optimization and digitalization of business processes in finance
• Interim Head of Finance at a startup in robotics: introduction of business processes; support during financing rounds
• Project at a medium-sized mechanical engineering company: introduction of cost and performance accounting

TenneT is the largest transmission system operator and largest private bond issuer in Germany. With more than 5,000 employees and a transmission network of more than 15,000 km, TenneT connects more than one third of the European Union's total offshore wind capacity. With an annual investment volume of more than 12 billion euros, TenneT is a key player in Germany's energy transition.

• Consulting and operational support for the Controlling department
• Management of the new planning process following the entry of new international investors
• Implementation of new reporting requirements after closing

I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.

I delivered following projects and engagements as a freelancer.

• Data Migration of CRM System for AL-FA Objekt Service Gmbh
• Microsoft Software Resales Partnership

I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer

Technical Focus Areas

• Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
• DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
• Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
• MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
• Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.

• Controlling project work: introduction of customer quotation costing and development of a trading/forward costing model for sales
• Development of a manufacturing cost calculator
• Theoretical design and practical implementation: interim Excel version introduced at short notice; migration to INFOR LN and preparation of the requirements specification
• Most of the project management using modern tools (Loop, Jira, Excel, PowerPoint)
• Regular reporting on submitted quotations (db1 and full-cost coverage) and comparison with post-calculation

• Process optimization, process design
• Business partnering, target vision
• Teambuilding
• Workflow design
• Budget, MEC
• SAP S4/Hana, Board

Focus areas: Knowledge transfer, reporting, cost analysis Responsibilities

• Ensuring knowledge transfer from the departing controller
• Documentation of key controlling processes
• Operational controlling (liquidity planning, reporting)
• Simplification of the cost center structure to improve cost analysis Results
• Transparent knowledge transfer and sustainable documentation of controlling processes
• Improved cost analysis and more efficient reporting

• Responsible for Finance, Insurance, and Legal, including 3 department heads
• Leading and managing day-to-day accounting
• Preparing and reporting monthly financial statements according to HGB and IFRS
• Corporate controlling including budgeting, forecasting, and variance analysis
• Point of contact for external authorities, banks, tax advisors, and auditors
• Implementing group-wide processes at the corporate level
• Preparing annual financial statements according to HGB
• Supporting the annual audit
• Supporting special audits and due diligence projects at the group level
• Insourcing of accounting, including ERP implementation and department development

• Special topics such as IFRS 9 / posting of complex syndicated loans
• Accounting for 2 subsidiaries

• Performance optimization and centralization of reporting by creating data models using SSMS (SQL) & SSAS (DAX) and integrating data via SSIS
• Optimizing and extending the current PowerBI dataset (in parallel until the SSAS data model is ready)
• Expanding current reports (migrating reporting to SSAS source after building the SSAS data model)
• Conducting regression analyses, cohort analyses, price/quantity analyses, and strategy project success analyses
• Training internal team members

• Assessment of the existing processes and structures in accounting
• Development of recommendations for the future department structure
• Implementation of the new processes and structures, especially the introduction of a Fast Close
• Completion of the annual financial statement audit incl. audit opinion by the end of May 2023 for 2 companies as well as one company as a first-time audit