Andrea V. - Interim Manager Senior Expert Controlling & Business Intelligence

Go to Website

Rehau, Germany

Experience

Jan 2023 - Present

2 years 8 months

Interim Manager Senior Expert Controlling & Business Intelligence

Self-employed

Sep 2022 - Dec 2022

4 months

Senior Consultant and Team Lead Data Analytics and Controlling

Bruhn Consulting

Independently handled HR controlling projects to fill vacancies and optimize processes.
Designed KPIs for an HR controlling dashboard in Power BI.
Supported data analytics and developed concept proposals for competitive 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

Managed and developed the controlling department for over 20 years, including personal and professional staff development.
Granted power of attorney since 2020.
Established and sustainably expanded the controlling function and costing for the entire corporate group, including:
Meaningful and focused reporting for stakeholders (>20 years with future-proof reporting structures) with monthly presentations and strategy meetings.
Sales controlling.
Production controlling.
Procurement controlling.
Fixed cost controlling.
Cost center accounting.
Cost unit accounting.
Multi-level contribution margin accounting.
Project margin pre- and post-calculation.
Planning/Budgeting.
Overhead calculation.
Operating statement (BAB).
Investment controlling.
Profitability calculations.
Inventory management.
System-driven costing.
Led the costing and master data department 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 post-calculation of construction projects and live post-calculation of ongoing projects with result forecasts (initially in Excel, later in Qlik Sense) by creating the required data structure in the ERP system and building reporting.
Integrated company acquisitions into the existing system landscape and set up controlling in the subsidiaries.
Continuously designed and developed tools for departments to improve operational control (facilitating work, speeding up processes, gaining information).
Digital Process Expert (>3 years experience), previously Key User for controlling, responsible for:
Process changes and customizing in the ERP system in controlling, costing, accounting, and procurement/material management.
Reviewing and approving change requests, responsible for testing and implementation.
Supporting the migration of different ERP system versions of Microsoft Dynamics Navision.
Introduced QlikView and later Qlik Sense as standard BI tools in the company (>10 years experience), including:
Designing and programming the data model and visualizations for:
Sales.
Procurement/Material Management.
Production.
Cost controlling for construction projects.
Personnel capacities and employee development.
Training 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:
Transforming manual reporting via JET Reports into automated Excel reporting and continuously expanding it.
Supporting departments with reports and ad-hoc analyses.
Guiding key users in departments after rollout regarding reporting.
Initiated and led the 'Strong Purchasing' project to improve procurement/material management performance, including:
Designing necessary operational and strategic measures.
Performing ABC and XYZ classifications of suppliers and items.
Designing and implementing reports for negotiation preparation with suppliers.
Designing and implementing supplier evaluation in the ERP system and supplier information for supplier management.
Developing a characteristic search system.
Training employees on new tools and methods.
Developing an early warning system for material availability in production to avoid production downtime.
Optimizing inventory regarding capital tie-up and delivery capability.
Designing and building a material management and procurement/purchasing dashboard in QlikView.
Closely collaborating daily and supporting the production management on operational and strategic issues related to:
Material availability.
Capacity utilization.
Capacity planning.
Supplier management.
Investment projects.
Profitability calculations.
Performance measurement.
Designing and building the production dashboard in QlikView for:
Production control regarding economic targets.
Capacity control.
Supporting operational and strategic planning.

Summary

Seasoned Senior Controlling Expert with over 20 years of operational and strategic controlling experience and a strong affinity for digitalization and company-wide performance and process optimization.
Passionate business economist with high self-motivation
Doer with foresight and strong analytical skills
Many years of leading, motivating, and developing employees both personally and professionally through responsibility, constructive and solution-oriented behavior combined with empathy and personality
Trusted business partner for financial aspects of corporate management at all levels
Proven track record in company-wide efficiency improvements and process acceleration using modern digital tools (strong IT and BI affinity) with sustainable and consistent execution
Focused work style, quick comprehension, and rapid grasp of complex issues
Lean mindset
Collaborative working
Assertiveness
Hands-on mentality