Andrea Von der grün - Interim Manager Senior Expert in Controlling & Business Intelligence

Go to Website

Rehau, Germany

Experience

Jan 2023 - Present

2 years 7 months

Interim Manager Senior Expert in Controlling & Business Intelligence

Freelance

Sep 2022 - Dec 2022

4 months

Senior Consultant and Team Lead Data Analytics and Controlling

Bruhn Consulting

Independent project handling in HR controlling as vacancy covering, with process optimization.
Designed KPIs for an HR controlling dashboard in Power BI.
Supported data analytics and developed concept proposals for marketable and fair employee compensation in several large companies.

Nov 1999 - Sep 2022

22 years 11 months

Rehau, Germany

Head of Controlling

Lamilux Heinrich Strunz Holding GmbH & Co. KG

Led and built the controlling department for over 20 years, developing employees both personally and professionally.
Granted power of attorney since 2020.
Sustainable expansion of the controlling department and costing for the entire corporate group, including:
Meaningful and focused reporting for stakeholders (over 20 years with future-ready reporting structures), with monthly presentations and strategy reviews.
Sales controlling.
Production controlling.
Procurement controlling.
Fixed cost controlling.
Cost center accounting.
Cost unit accounting.
Multi-level contribution margin accounting.
Preliminary and final project margin calculation.
Planning/budgeting.
Overhead calculation.
Cost allocation sheet (BAB).
Investment controlling.
Profitability analysis.
Inventory.
System-driven costing.
Managed the costing and master data area for production control in the ERP system, ensuring data availability for all subsequent production and controlling processes.
Developed various control tools with early warning indicators to support goal achievement.
System-driven final costing of construction projects and live costing of ongoing projects with result forecasts (initially in Excel, later in Qlik Sense) by creating the necessary data structure in the ERP system and building reporting.
Integration of company acquisitions into the existing system landscape and establishment of controlling in the subsidiaries.
Continuous design and development of tools for departments to improve operational management (facilitating work, speeding up processes, gaining information).
Digital process expert (>3 years experience), previously key user in controlling, responsible for:
Process changes and customization in the ERP system in controlling, costing, accounting, and procurement/material management.
Reviewing and approving change requests, responsible for testing and implementation.
Process support for migrating different Microsoft Dynamics Navision ERP system versions.
Implemented QlikView and later Qlik Sense as the standard BI tool in the company (>10 years experience), including:
Designed and programmed the data model and visualization for the following areas:
Sales.
Procurement/material management.
Production.
Cost controlling for construction projects.
Personnel capacities and employee development.
Trained departments in usage and data analysis.
Introduced JET Reports in controlling and later rolled out company-wide for live data processing in Excel (>20 years experience), which included:
Automating manual reporting via JET Reports into Excel reporting and continuously expanding it.
Supporting departments with reports and ad-hoc analyses.
Guiding key users after rollout in the departments on reporting.
Initiated and led “strong procurement” project to improve procurement/material management performance, including:
Developing operational and strategic measures.
ABC and XYZ classification of suppliers and items.
Designing reports and implementation for negotiation preparation with suppliers.
Designing and implementing supplier evaluation in the ERP system and supplier information for supplier management.
Building material attribute search system.
Training employees in new tools and methods.
Building early warning system for material availability in production to avoid production outages.
Optimizing inventory in terms of capital tie-up and delivery capability.
Developing content and building a material management and procurement/purchasing dashboard in QlikView.
Worked closely with production management daily to support operational and strategic questions about:
Material availability.
Utilization.
Capacity issues.
Supplier management.
Investment projects.
Profitability calculations.
Performance measurement.
Designed and built production dashboard in QlikView to:
Control production in line with economic objectives.
Capacity control.
Support operational and strategic planning.

Summary

Experienced senior controlling expert with over 20 years of professional experience in operational and strategic controlling, with a strong affinity for digitization and company-wide performance and process optimization.
Passionate business economist with strong self-motivation
Doer with foresight and strong analytical skills
Many years of leading, motivating, and developing employees personally and professionally through responsibility, constructive and solution-oriented behavior combined with empathy and personality
Valued business partner for financial aspects of corporate management at all levels
Relevant experience in company-wide efficiency improvement and process acceleration using modern digital tools (high IT and BI affinity) with sustainable and consistent implementation
Focused work, quick comprehension, and rapid understanding of complex contexts
Lean mindset
Networked working
Assertiveness
Hands-on mentality