Jiří Šnajdr Email & Phone Number

Hlavní Město Praha, Česko

Hlavní Město Praha, Česko

Hlavní Město Praha, Česká Republika

- Implementation of Jedox system for group FP&A purposes (budgeting, forecasting and reporting platform). - - Communication with consultants from the implementation company to translate business needs into an IT solution. - - Coordination with local Dr. Max entities to align with group requirements. - - Preparation of group level budget/forecast based on Jedox outputs.- Co-implementation of Oracle Hyperion Financial Management (HFM) system for FP&A purposes. - - Adjustment of the system to fit FP&A requirements and desired data structure (cost center hierarchies, etc.). - - Data quality checks and troubleshooting. - - Preparation of regular automated reporting packages based on HFM outputs as the primary goal of the implementation.- Regular FP&A activities: - - Involved in preparation of group level budgets, forecasts and their presentations. - - Automation of regular reporting using Power Query. - - CAPEX reporting, identification of savings,... - - Dr. Max Private label group sales&margin reporting and related ad hoc tasks - identification of revenue risks and trends. - - Preparation of monthly reporting for shareholder.

Prague

- Preparation of the annual budget/operational plan - revenues and costs.- Finance partner to the head of sales and KAMs - providing analyses, simulations, recommendations regarding investments, profitability, category mix, pricing... - Consolidation, checks and adjustments of sales forecasts - revenue and trade investment (costs), analyses of variances, YoY, forecasts. - Creation of new tools and reports to cope with the fast changing environment (new KPIs, better transparency, higher data quality, etc).- Setting up new processes to ensure continual improvements, efficiency and performance.- Genuine interest in new BI tools - Power Query, Power BI, SQL, etc... - Providing guidance/steering the KAMs towards targets.

Prague

- Consolidation of KAM sales forecasts and preparation of related reports, identifying revenue, trade spend and pricing risks so the management gets the true picture. - Invention of new reports, providing better transparency and insights into the planned trade promotions and mainly providing forecasts, not only reports of historical data. - Cooperation on the implementation of a new planning system - Logio Planning Wizard and the introduction of several new useful reports for the Key Account Managers and the management based on this system.- Regular reporting to the corporate headquarters in Switzerland, improving the process and simplification of the reports.- Daily usage of SAP Business Warehouse, occasional use of regular SAP transactions. Usage of Analysis for Office, training other users and preparation of basic manuals, usage of Power BI Desktop – for clear dashboards, live graphs, etc.- Evaluation of promotions, ROI calculation, underperforming activity identification.- Ad-hoc analyses, monthly business reviews, identification of variances compared to the operational plans, last year data, etc.

Zlín

- Support of corporate bankers regarding client acquisition and retention, financial analysis and the loan process in general.- Came up with the topic for my Diploma thesis.- Weekly meetings with the director, I was assigned a topic to research which we then discussed and evaluated.

Master'S Degree, Economics And Management - Finance

- Further extracurricular work on projects and competitions. - Erasmus study stay in the Netherlands. - Diploma thesis based on my.

Erasmus Study Stay, International Finance

- Great opportunity to meet people from all around the world, practice my Spanish and study abroad. - Own project related to reporting.

Bachelor'S Degree, Economics And Management, Enterprise Management

- Participation in many extracurricular projects, competitions and activities both local and abroad. - First Class Honors graduate..

English With Applied Economics

I decided to quit this program after a year because I didn't consder it good enough for my future. It was a tough decision but gave me.

Maturita, Economics, Accounting

- Graduated with honors.