Oracle Hyperion Experts in Germany

• 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.

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.

Focus areas: knowledge transfer, reporting, cost analysis Tasks

• Ensure knowledge transfer from the outgoing controller
• Document key controlling processes
• Operational controlling (cash flow planning, reporting)
• Simplify 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

• Controlling project work: implementation of customer quotation calculation and development of a trading and forward calculation for sales
• Development of a cost of goods manufactured calculator
• Theoretical design and practical implementation: temporary Excel-based solution introduced quickly; embedding into INFOR LN and creation of the requirements specification
• Majority of project management using modern tools (Loop, Jira, Excel, PowerPoint)
• Regular reporting on quotes submitted (contribution margin 1 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

• 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

• 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

• Climate solutions, approx. 14,800 employees, approx. €3.9 billion revenue
• Led and managed the carve-out of Viessmann Climate Solutions from the Viessmann Group into the publicly traded US group Carrier Global Corporation
• Responsible for adapting and converting monthly, quarterly, and annual financial statements to US GAAP, including group reporting to Carrier Group
• Further developed, restructured, and optimized group reporting, commercial processes & structures; implemented Fast Close & Power BI; and developed and coached finance departments

• 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

• Responsibility for group-wide financial management with a focus on management, PE, and lender reporting.
• Focus on an integrated financial model (P&L, balance sheet, cash flow), robust liquidity and covenant management, and preparation of decision-ready materials for financiers, auditors, and rating stakeholders.
• Establishment of reporting standards, data logic, and closing routines for high-frequency scalability.
• Further development of an integrated financial model (P&L/BS/CF), including scenario capabilities, sensitivities, and driver-based forecasting logic.
• Design and management of a rolling liquidity plan (short-/mid-term), including working capital mechanisms and financing instruments.
• Preparation and quality assurance of lender reporting, including covenant calculations, bridge analyses, and variance explanations.
• Support for the CFO agenda in financier and stakeholder communication (Q&A, documentation logic, key messages, data consistency).
• Coordination and content input for rating- and financing-related deliverables (e.g., presentations, data rooms, management commentary).
• Management of IFRS/accounting topics (e.g., IFRS 16 lease logic, accrual and reconciliation concepts) to ensure reporting and audit readiness.
• Standardization of reporting structures, templates, and KPI definitions across entities to increase transparency, comparability, and speed.

• Redesigning cablewise infrastructure with CAT 8.1 keystones, measuring the speed and quality of the new installation with Pockethernet, documentation at a local saddlery
• CAT 8.1 installation and building a data center, site linking, VPN and VLAN configuration for a local car dealership, implementation of IT-Security standards like virus protection (G Data) and firewalling (OPNSense)
• Relocation of a tax office with redesign of the IT infrastructure, virus protection (G Data) and backup solutions (QNAP)
• Planning, conception and implementation of an inhouse data center, BSI-compliant for commercial laundry (including Proxmox-based virtualization of existing infrastructures, QNAP, G Data, OPNSense, APC)
• Implementation and conception of security solutions in the SME sector
• Collaboration on the IT-security concept for the Bremen network of authorities (in the dLAN network)
• Creation of IT-security concept VOIS (modules MESO, KFZ/iKFZ) including audit preparation for KBA
• Expansion of the IT-security concept for the online service for electronic residence registration (eWA) to include use as an eFA (one-for-all) service (nationwide)
• Expansion of the IT-security concept to include modules wos & wvp
• Concept development for the implementation of DIN SPEC 27076 at MSEs and SMEs
• Creation and evaluation of emergency concepts
• Creation and evaluation of response actions and BCM plans
• Assessment of existing business continuity management (ISO 22301)
• Development of BCM strategy options
• Conducting awareness training

• full-service marketing agency for global technology companies

• Inhousing and responsibility for financial accounting for 15 companies within the group (HGB)
• Selection of auditors
• Central point of contact for tax advisors, auditors and the tax office
• Execution of the first full consolidation in the group and support of auditors
• Execution and support of the planning process across all companies
• Strategic guidance and development of the group, direct CEO reporting and exchange
• Recruiting and building a completely new finance team & onboarding new employees
• Team leadership
• Design and delivery of staff workshops and training
• Establishment of controlling & reporting
• Finalization of the consolidated financial statements including drafting the management report
• Ensuring the preparation of complete & accurate monthly financial statements for all companies within the holding
• Reduction of the monthly closing process by 10 days
• Processing of payment transactions and cash management for the holding
• Preparation of intercompany billing as a service company within the group
• Revision of authorization concepts
• Implementation of DATEV Kanzlei Rechnungswesen
• Introduction of HR tool Personio
• Introduction of the Moss system as an expense tool, budget control and preliminary accounting across all entities
• Introduction of LucaNet for consolidation, reporting & planning
• Project initiation and execution of an automation solution for revenue postings (development of an in-house application)
• Ongoing review of existing contracts
• Contract negotiations
• Preparation and support of a full M&A process
• Selection of advisory firms for preparing FDD & CDD
• Co-supervision of the preparation of the Financial Factbook with external consultants
• Direct exchange with external consultants, investment banks, lawyers and house banks as part of due diligence
• Management of external service providers (data protection officers, consultants, lawyers)
• Complete review of the payroll and salary payment process
• Handling various HR topics
• Design and conduct of finance meetings within the holding with all managing directors
• Management of the group's rental properties
• Procurement
• Setup of IT functionalities and admin tasks, interface to external IT service providers

• Development of a planning workbook for P&L and balance sheet items

• Introduction of planning workshops with management, procurement, and plant construction managers

• Mapping the original plan into an SKR04 structure

• Analysis and optimization of the payment run process, implementation of CANDIS.IO and Datev

• Determination of capital requirements for all entities until 2025

• Implementation of planning structures

• Setup of a basic actual vs. target reporting, resulting in higher cost transparency