BI analitycs:

• business process analysis
• master data management
• collection and preparation of data from ERP/CRM
• support, maintain, design ETL process
• data modelling
• vizualization and presentation of data
• developing and maintaining of reports/dashboards
• consolidation of data from different sources
• provide trainings, supporting of data-driven decisions
• collaboration with stakeholders to identify and prioritize business needs and BI initiatives
• identification of opportunities to improve metrics/KPIs etc

Commercial controlling:

• design and coordination of sales budgeting model (by SKU/channel, sales manager) (power query)
• complex monthly variance analysis
• gross margin management
• price management
• scenario modelling WISA (what-if scenario analysis)

Supply chain controlling:

• SC budgeting and forecasting
• SC reporting and support

• Review, analysis and consolidation of weekly/monthly contraction/production/sales plan data
• Analysis and financial control over price deviations by products/markets
• Participation in mid-term and long-term planning processes
• Periodical analysis of price, volumes and costs trends
• Factor analysis against target volumes and revenues
• Performing ad hoc analysis as required, preparation of different management accounts
• Design and support various models and dashboards using Power BI / Power Query
• Sales data management

• Design and coordination of budgeting process
• Budgeting control over expenditures
• Preparing and coordinating monthly performance review
• researching and reporting on factors influencing business performance, deep variance analysis, EBIT bridge
• Preparation of long-term plan (PS5)
• Mid-year forecasting
• Preparation of monthly reporting package (IAS/IFRS based)
• Management reports compilation (PLs by SKU, by customers, by channels), customer profitability reports
• Appraisal of marketing initiatives, support new SKUs launches
• Support yearly IAS/IFRS audit process
• Support of internal management decisions - GM/MC management
• Conduct trainings for non-financial colleagues
• Ad-hoc reports and calculations
• Development of financial models

management accounting, methodology of budgeting, financial and economical analysis, forecasting, preparation of management reports, consolidation of budget, breakeven analysis, variable and fixed costs analysis, variance analysis, IFRS reporting