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 a vacancy cover with process optimization
- Design of KPIs for an HR controlling dashboard in Power BI
- Support in data analytics and development of 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 with employee development on personal and professional levels
- Power of attorney since 2020
- Set up and sustainably expanded the controlling department and cost calculations for the entire group
- Clear and 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
- Project margin pre- and post-calculation
- Planning and budgeting
- Overhead rate calculation
- Operating cost sheet (BAB)
- Investment controlling
- Profitability calculations
- Inventory management
- System-driven costing
- Managed calculation and master data departments 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 forecasting by creating necessary data structures in the ERP system and building reporting
- Integrated company acquisitions into the existing system landscape and established controlling in subsidiaries
- Continuously designed and developed tools for departments to improve operational control
- Responsible for process changes and customizing in the ERP system in controlling, costing, accounting, and procurement/material management areas
- Reviewed and approved change requests as well as testing and implementation
- Supported the migration of different Microsoft Dynamics Navision ERP system versions
- Introduced QlikView and Qlik Sense as BI tools, including design and programming of data models and visualizations for sales, procurement/material management, production, cost controlling, staffing, and employee development
- Trained departments in using and analyzing data in BI tools
- Implemented and rolled out JET Reports to automate manual Excel reporting with live data
- Initiated and led the 'strong purchasing' project to improve procurement/material management performance with ABC and XYZ classifications, supplier evaluation, and negotiation preparation
- Built an early warning system for material availability in production
- Optimized inventory management regarding capital tie-up and delivery capability
- Designed and built a dashboard for materials management and procurement in QlikView
- Collaborated closely and supported production management on material availability, capacity utilization, supplier management, investment projects, profitability calculations, and performance measurement
- Designed and built a production dashboard in QlikView for production and capacity control as well as operational and strategic planning
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Manufacturing and Professional Services.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Accounting, Finance, and Human Resources.
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.
Skills
Personal Strengths**
Passionate Business Economist With Strong Self-motivation
Doer With Foresight And Strong Analytical Skills
Many Years Of Leadership, Motivation, Personal And Professional Development Of Employees Through Responsibility, Constructive And Solution-oriented Behavior Combined With Empathy And Personality
Valued Business Partner For Business Aspects Of Corporate Management At All Levels
Relevant 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 Grasp Of Complex Relationships
Lean Mindset
Collaborative Working
Assertiveness
Hands-on Mentality
Management**
C-level
Power Of Attorney
Leading The 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 Working Style
Situational Leadership
Strong Networking
Communication**
Open And Honest
Factual And Appreciative
Skills And Expertise**
Comprehensive, In-depth Business Administration Knowledge
Relevant Professional Experience In Operational And Strategic Controlling In An Industrial Environment
Analysis Of Company Results And Development Of Action Areas In Line With Business Strategy Using Meaningful Kpis And Reporting Systems
Analysis And Presentation Of Company Results To The Management Team
Implementation Of Reporting, Analytics, And Planning Solutions
Continuous Improvement Of Controlling Processes
Efficiency Analysis, Driving Change Processes, And Performance Optimization Through Use Of New Technologies Or Support In Strategic Change
Goal Setting And Cascading Aligned With Corporate Objectives
Technical 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 In Interface And Data Structure In Almost All Modules (Very Good)
Writing 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 Database Queries From Erp System) (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
Statistics
Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Andrea based?
What languages does Andrea speak?
How many years of experience does Andrea have?
What roles would Andrea be best suited for?
What is Andrea's latest experience?
What companies has Andrea worked for in recent years?
Which industries is Andrea most experienced in?
Which business areas is Andrea most experienced in?
Which industries has Andrea worked in recently?
Which business areas has Andrea worked in recently?
What is Andrea's education?
What is the availability of Andrea?
What is the rate of Andrea?
How to hire Andrea?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Interim Manager, Senior Expert in Controlling & Business Intelligence
Nearby freelancers
Professionals working in or nearby Rehau, Germany