Andrea Von der grün
Interim Manager, Senior Expert in Controlling & Business Intelligence
Experience
Interim Manager, Senior Expert in Controlling & Business Intelligence
Freelance
Senior Consultant and Team Lead Data Analytics and Controlling
Bruhn Consulting
- Independent project work in HR controlling as vacancy cover with process optimization
- Designing KPIs for an HR controlling dashboard in Power BI
- Supporting data analytics and developing concept proposals for marketable and fair employee compensation in several large companies
Head of Controlling
Lamilux Heinrich Strunz Holding GmbH & Co. KG
- Led and built the Controlling department for over 20 years, developing employees personally and professionally
- Granted power of attorney (Prokura) since 2020
- Established and sustainably expanded the Controlling area and budgeting for the entire corporate group
- Provided meaningful, focused reporting for stakeholders 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
- Preliminary and post-calculation of project margins
- Planning and budgeting
- Absorption costing
- Operating account sheet (BAB)
- Investment controlling
- Profitability calculations
- Inventory
- System-driven costing
- Managed 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 management tools with early warning indicators to support target achievement
- Conducted system-driven post-calculation of construction projects and live post-calculation of ongoing projects with result forecasting by creating the necessary data structure in the ERP system and setting up reporting
- Integrated acquisitions into the existing system landscape and set up controlling in subsidiaries
- Continuously designed and developed tools for business units to improve operational control
- Responsible for process changes and customizing in the ERP system in Controlling, Costing, Accounting, and Procurement/Materials Management areas
- Reviewed and approved change requests, as well as testing and implementation
- Supported process migration between different Microsoft Dynamics Navision ERP system versions
- Implemented QlikView and Qlik Sense as BI tools, including designing and programming data models and visualizations for Sales, Procurement/Materials Management, Production, Cost Controlling, Personnel capacities and employee development
- Trained business units in the use of and data analysis with BI tools
- Introduced and rolled out JET Reports to automate manual Excel reporting with live data
- Initiated and led the 'strong purchasing' project to improve procurement/materials management performance, including ABC and XYZ classifications, supplier evaluation, and negotiation preparation
- Built an early warning system for material availability in production
- Optimized inventory management in terms of capital tied up and delivery capability
- Designed and built a QlikView dashboard for materials management and procurement
- Collaborated closely with production management on material availability, capacity utilization, capacity issues, supplier management, investment projects, profitability calculations, and performance measurement
- Designed and implemented a QlikView production dashboard for production and capacity control, as well as operational and strategic planning
Summary
Experienced senior controlling expert with over 20 years in operational and strategic controlling, with a strong affinity for digitalization and company-wide performance and process optimization.
Skills
Personal Strengths**
Passionate Business Economist With Strong Self-motivation
Doer With Foresight And Strong Analytical Skills
Many Years Of Leadership, Motivation, And Professional And Personal Development Of Employees 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 Experience In Company-wide Efficiency Improvements And Process Acceleration Using Modern Digital Tools (Strong It And Bi Affinity) With Sustainable And Consistent Implementation
Focused Work, Quick Comprehension, And Fast Understanding Of Complex Contexts
Lean Mindset
Networked Working
Assertiveness
Hands-on Mentality
Management**
C-level
Power Of Attorney (Prokura)
Head Of Controlling Department For Over 20 Years With A Team Of Up To 10 Employees
Leadership Qualities**
High Motivation And Development Of Employees
Engaging Presence Through Solution-oriented Behavior, Appreciation, And Empathy
Reliable And Trustworthy Work Style
Situational Leadership
Strong Networking
Communication**
Open And Honest
Factual And Appreciative
Skills And Expertise**
Comprehensive, In-depth Business Administration Knowledge
Significant Professional Experience In Operational And Strategic Controlling In An Industrial Environment
Analysis Of Company Results And Development Of Action Areas Based On Business Strategy Using Meaningful Key Figures And Reporting Systems
Analysis And Presentation Of Company Results To Management Team
Implementation Of Reporting, Analytics, And Planning Solutions
Continuous Improvement Of Controlling Processes
Efficiency Analysis, Driving Change Processes, And Performance Optimization Through New Technologies Or Support In Strategic Shifts
Goal Setting And Cascading Aligned With Company Objectives
Professional Interface Competence And Interdisciplinary Thinking
Strong It And Business Intelligence Affinity
Accounting Knowledge According To Hgb
It Skills**
Microsoft Office (Very Good)
Excel Expert Knowledge, Pivot Tables (Very Good)
Vba (Basic Knowledge)
Microsoft Dynamics Navision 2009 To Microsoft Dynamics 365, Key User Knowledge For Interface And Data Structure In Almost All Modules (Very Good)
Creating Sql Queries (Good)
Etl Competence (Very Good)
Business Intelligence Tools (Data Modeling And Visualization): Qlikview (Very Good), Qlik Sense (Very Good), Jet Reports (Excel Add-on For Report Automation With Erp Database Queries) (Very Good), Power Bi (Basic Knowledge)
Edi Interface Competence (Very Good)
Lucanet User Knowledge (Very Good)
Other Training**
Modern Supplier Management
Basics Of Project Management
Leadership Training**
Leading Remotely
Efficient Leadership (Mehrwissen)
Employee Conversation Training
Languages
Education
University of Applied Sciences Hof
Diploma in Business Administration (FH), Accounting/Controlling · General Business Administration · Hof, Germany · 1.8
Similar Freelancers
Discover other experts with similar qualifications and experience