Jedox Experts in Germany

Advising various companies in the areas of controlling, finance and planning, transformation, business partnering, management reporting and AI-driven forecasting systems

• Tendering, IT architecture and implementation
• Project and budget planning, resource management
• Stakeholder management and risk management
• The project was delivered “on time and within budget”
• Implementation of SAP IBP Cloud S&OP Demand & Supply
• Building materials group with revenue of €1.3 billion and 30 plants

• Energy Management (2023-08-01 – today):

• Designing a planning solution to increase energy efficiency

• Creating a concept for an energy management system

• Planning a component for action planning to gradually reduce energy consumption

• Evaluating planned measures based on opportunities, risks, and effectiveness for inclusion in the planning process

• Designing requirements for a data model to compare planned and actual data in the dashboard

• Consulting (2023-05-01 – today):

• Extending the accantec PerCon authorization management system to IBM Planning Analytics

• Analyzing authorization requirements and comparing them with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

• Printing (2023-04-01 – today):

• Supporting the introduction of a data warehouse solution with IBM Cognos Analytics 11

• Supporting the introduction of a reporting system based on a standard data warehouse

• Supporting report developers and developing custom controls to optimize the user interface

• Healthcare (2020-08-01 – 2023-03-31):

• Optimizing, extending, and operating a historically grown BI planning environment

• Updating the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL processes

• Connecting different accounting and administration systems

• Writing completed plans back to source systems and implementing complex allocation logic

• Building and maintaining dimensions and hierarchies (corporate structure, P&L)

• Developing planning scenarios for FP&A and creating reports to monitor the budget

• Designing and implementing new OLAP cubes and reporting

• Providing user training according to customer requirements

• Industrial Sector (2020-04-01 – 2020-12-31):

• Migrating and optimizing an existing Jedox solution

• Combining the reporting system and planning system in Jedox

• Building a central group reporting system with plan-versus-actual comparisons for FP&A

• Optimizing KPI calculations and existing reports, and creating new reports

• Creating forecast reports, managing authorizations, and providing user training in an international environment

• Finance (2020-05-01 – 2023-03-31):

• Further developing and operating an existing Jedox solution

• Designing and developing new OLAP cubes for controlling

• Building hierarchies in dimensions (e.g. P&L) and updating the Jedox system in a Linux environment

• Providing user training on report creation

• Trade Fair (2020-06-01 – 2023-03-31):

• Designing and developing a BI planning solution in Jedox with a data warehouse structure

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports and plan-entry forms, and implementing business logic (P&L, allocation logic)

• Implementing planning and analysis reports as well as a security concept in Jedox

• Industrial Sector (2021-03-01 – 2023-03-31):

• Migrating and optimizing an existing Jedox solution

• Updating the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator

• Optimizing SQL queries, analyzing the system, eliminating redundancies, and developing new ETL processes

• Analyzing and adapting existing reports

• Staffing Services (2022-07-01 – 2022-10-31):

• Migrating a Jedox solution from version 5 to 2022.2

• Updating the system, adjusting configurations, and analyzing performance issues

• Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data

• Finance (2021-10-01 – 2022-02-28):

• Creating OLAP cubes in Microsoft SSAS

• Building dimensions and hierarchies and calculating KPIs with MDX

• Supporting users with Power BI requests

• Planning, management and monitoring of the Corporate Responsibility Tech Enablement project for IT
• Design and implementation of the EUDR (EU Deforestation Regulation)
• Design and implementation of the Eco-Design Regulation
• Continuation of projects as part of the Corporate Responsibility strategy
• Definition and review of requirements (e.g. governance, success metrics) and, where necessary, analysis and resolution of problems
• Overall management, marketing, communication and quality assurance of the projects
• Creation of the project plan including timeline/roadmap, budget and resources
• Ensuring compliance with budget and deadlines
• Defining project management guidelines, methods and priorities
• Planning and tracking resources & efforts, also in cooperation with other IT departments
• Evaluation of projects and preparation of results (reporting to management)
• Identification and reduction of risks
• Regular communication with stakeholders
• Management of internal and external stakeholders and service providers (Jira, Confluence, backlog management, task tracking, Sharepoint, MS 365 Platform etc.)
• Development of standards and automation of processes
• Technical design and documentation of the Digital Product Passport
• Selection and evaluation of potential software providers
• Training and workshops on Osapiens

Label: Azure Cloud, Jira, Confluence, Power BI, SAP BW, AWS, Miro, Bee360, Draw.io, Sharepoint, MS 365 Platform, Trello, Osapiens, Naravero etc.

• Finance: Managed and led multiple cash flow-related projects.
• Implemented a standardized project management organization, including a resource plan.
• Led the VAT change project in Slovakia.
• Built a management dashboard for all internal projects.
• Systems used: MS Office; Jira, Confluence.
• Reference: Alexander Knoll, CFO – SAP FICO.

• Led full-cycle EPM implementations with Jedox for clients in various industries – from requirements gathering to go-live and post-support
• Editor of Research Notes at BARC-Institute

• Financial controlling, IT controlling, support of a change process, implementation of new cost center and cost unit structures, adjustment of finance workflow, IT budget planning and budget tracking, CAPEX, OPEX (HGB, SAP, XFlow; trading group) (since 2024-09-01)
• Project controlling, contract controlling, project contribution margins, project accruals for monthly and quarterly closing, reporting, accounting (HGB, Datev; advertising agency group) (2024-06-01 to 2024-06-30)
• Financial controlling support in a group environment; vacancy cover, operational controlling, revenue accrual in the year-end closing, process optimization, support for new ERP implementation, introduction of new reporting (KPIs, cost center accounting, service charge allocations), support of a change process/restructuring/reorientation (IT services) (2022-01-01 to 2024-09-30)
• Financial controlling with focus on working capital, cash flow projection, SOX testing (US advertising agency group, shared service) (2023-11-01 to 2024-05-31)
• FP&A, financial modelling, balance sheet planning (Lucanet) in an international corporate environment (solar industry) (2023-09-01 to 2023-11-30)
• Vacancy cover, overall commercial responsibility; operational accounting (Datev), collaboration with external tax advisor/auditor, coordination with British parent company (advertising agency) (2023-04-01 to 2023-08-31)
• Support for the general ledger team in a service group (US GAAP, SAP, Lucanet); preparation of HGB financial statements, reconciliation and submission of VAT returns, accounts reconciliations, support during tax audit (US media group) (2023-01-01 to 2023-06-30)
• Operational commercial oversight; financial controlling, operational accounting (Datev, Datev Unternehmen Online), collaboration with external tax advisor/auditor (film production) (2021-04-01 to 2023-02-28)
• Planning and budgeting, introduction of KPIs; structuring of monthly profit and loss statements and advising the management (digital agency) (2021-03-01 to 2023-01-31)
• Inventory and concept development for product and project controlling as well as implementation (gaming agency) (2022-10-01 to 2022-12-31)
• Financial controlling and improvement of accounting processes, redefinition of KPIs/controlling (event agency) (2021-08-01 to 2022-12-31)
• Reporting, financial controlling, ERP system change (easyJob), process optimization, realignment of KPIs, operational accounting, ensuring a smooth document flow (advertising agency group) (2022-04-01 to 2022-10-31)
• Vacancy cover of operational controlling/project controlling; revenue accrual in monthly closing (IT service provider/digital agency in a group environment) (2021-06-01 to 2021-12-31)
• Software selection and implementation of ERP system with a focus on digital workflow/remote work, interface to Datev, Datev Unternehmen Online (design agency) (2021-03-01 to 2021-12-31)

• PMO & Scrum Master in a banking transformation project (ETT Market initiative)

• Coordinated deliverables, milestones, and reporting across project streams

• Prepared management reports and supported steering committee meetings

• Facilitated Scrum ceremonies, coached the team in agile practices, and tracked sprint progress and impediments in Jira

• Supported backlog refinement and sprint planning activities

• Contributed to AI-driven process optimization concepts and client workshops

• PMO in a tool evaluation and implementation initiative (Landgard eG)

• Supported evaluation and selection of a suitable Digital Asset Management (DAM) solution

• Conducted market and product research to compare tool functionalities and vendor fit

• Assisted in preparing the final client presentation, including structure, storyline, and slides

Project description: Design and step-by-step implementation of a central, multidimensional controlling platform based on IBM Planning Analytics to optimize and automate internal company planning and reporting.

Business & technical consulting: Analyzed the provided operational base data and proactively advised the controlling team on cube design best practices and optimal dimension structures.

Data integration & ETL: Designed and developed robust TurboIntegrator processes for automated data loading, transformation, and dimension maintenance.

Logic & business implementation: Implemented complex business logic and calculations with high performance using TM1 business rules (including efficient skipping/feeding).

Development of a Python HTTPS server to integrate an input widget in IBM PAW, enabling direct data write-back to TM1 cubes via the TM1 REST API.

Reporting & analytics: Created dynamic, user-friendly reports and dashboards for management and specialist departments.

• Interim management in commercial positions
• Project management in the commercial area
• Restructuring consulting for FTI Andersch AG
• Project in Vienna for Cash Remediation, establishment of a Group Treasury, cash reporting and segment restructuring (VAMED AG)
• Support in the handling and liquidation of the Kiel Group for insolvency administrator Dr. Jörg Gollnick (HWD, Cologne), preparation of financial statements for the tax office and provision of data and analyses for the winding-up and court proceedings