Analytics und Automatisierung in Accounting, Controlling & Finance / Controller

3/2024 – 10/2024

Finance counterpart in an AnaPlan implementation project
Creation of a FP&A model to be implemented in AnaPlan. From construction to cash inn.
Main responsibilities:
Balance Sheet, Cashflow, Profit and Loss statement
Department Planning
Financing
Master Data and Uploads

Bilanzen, Budgetierung, Cash-Flow-Analyse, Controlling, Finanzielle Planung, Finanzierung, Liquidität, Planbilanz

7/2023 – 3/2024

Created a weekly rolling cash forecast using direct cashflow method
Including regular income and expenditure and a short term forecast using OPOS and approval workflow to carry out analysis of working capital improvements and cash management.

Cash-Flow-Analyse, Cash Management, Controlling, Liquidität, Microsoft Excel, SAP HANA

6/2022 – 6/2023

Created a standardised automated monthly project reporting for nine national and international subsidiaries using PowerQuery / Power Pivot and VBA. The reporting template was provided to the subsidiaries to be executed on site and provided to the management
− Created an Excel based project dashboard for monthly review meeting using PowerQuery / PowerPivot and VBA. The dashboard was used for monthly meetings with project leaders

International Financial Reporting Standards, Microsoft Excel, Power Bi, Reporting, VBA (Visual Basic for Applications)