Experience

• 

  Gfk praha, s.r.o.

  Feb 2001 - Nov 2007

  Senior financial analyst

  Responsibilities:• Cost centre controlling, cost allocation, profitability analysis• Sales budgeting, detailed liquidity planning, intercompany reconciliation and netting• Reporting of Monthly Order Intake, Invoicing and Profit By Customers• IFRS • Navision Financials super user and administrator• Czech Statistical Office reporting • Maintenance of an electronic archive system• Management accounting supervisor for GfK Praha, s.r.o. and INCOMA Research, s.r.o.Achievements:• Author of original management information system based on Navision Financials, MS SQL Server, MS Excel and OLAP technologies.• Author of an Excel Application for Human Resource Accounting• Developed a detailed liquidity planning tool Show less

• 

  Shell czech republic a.s

  Dec 2007 - Jul 2011

  Responsibilities:• Implementation of SAP in CEE (Central and East Europe) – Go-Live January 2011• Asset + Project data conversion from SUN to GSAP• LFRD (Legal and Fiscal Requirement Documents) + GSAP Master data preparation – KDS (Key Data Structure) collection• B2B stock data cleansing• SQL Server Management Studio query design to facilitate teams with data• Leading Service Centre GSAP data cleansing activities – daily management and support of the offshore SSSC (Shell Shared Service Centre) team of 5 people.Achievements:• Design of effective checks on Asset + Project data quality ensured that Asset and Project data for CEE countries passed successfully TC (trial conversion) testing and further TC+ testing was not needed.• Crucial help with B2B Stocks Data Cleansing for GSAP – CEE countries achieved 100% Readiness Status for TC3+ in time.• Well prepared LFRDs for assets enabled smooth GSAP systems settings Show less Responsibilities:• Month end business closure – Aviation fuels stock reconciliation, Retail sales booking • Faster Monthly Reporting – monthly management reporting• OPTIMIS - Commercial fuels, Aviation + Bitumen sales management reporting• Czech Statistical Office reporting• Krakow + Chennai Service centre staff training• Ad Hoc AnalysisAchievements:• In a one month period successfully maintained reporting of Aviation, Bulk Fuels, CRT (Commercial Road Transport) and Bitumen CZ/SK business results from SUN - previously done by 3 persons• Successful two month training of Chennai Service Centre People• Development of semi automated tools for Commercial and Bitumen Supplementary sheet reporting and accrual calculation• Mastered Aviation stock reconciliation process that involved close cooperation among MSD department (Manufacturing and Supply) in Prague office, Sales invoicing department in SSSC Krakow and Sales Support at Prague Airport and reports to Aviation Finance Manager CEE. The process was described in procedure instructions and successfully handed over to Stock Accounting department in SSSC Krakow Show less

  • SAP Implementation Finance Analyst

    Jan 2009 - Jul 2011

  • MI Financial Analyst CZ&SK

    Dec 2007 - Dec 2008
• 

  Magna exteriors & interiors (nymburk) s.r.o.

  Aug 2011 - Jun 2015

  Plant controlling manager

  Responsibilities:• Top management financial representative of the Nymburk plant• Month end closing and full finance controlling reporting from SAP (P&L, BS, sales analysis, product line profitability, variance analysis, reconciliation, business result presentation at general meetings)• Yearly SAP budgeting (turnover 94 MEUR, 530 people, 5 main product lines, 3 production phases)• Accounting supervision, audit cooperation, statistical reporting • Monthly internal SOX controlling• Team leadingAchievements:• Building a completely new successful team • Fast and accurate forecasting and reporting• Excellent interpersonal relations Show less

• 

  Intelligent studios s.r.o.

  Jul 2015 - Jun 2017

  Consultant erp & mi systems

  • A consultant for implementation and design of ERP systems (focusing on Microsoft Dynamics AX), MI reporting systems and Master Data Management.• Implementation of ERP system solution for Central European Media Enterprises Ltd. • Fully responsible for bTV Media Group ERP data migration to Microsoft Dynamics AX• Working for Intelligent Studios s.r.o.

• 

  Solitea business solutions s.r.o.

  Jun 2017 - Mar 2018

  Consultant erp

  Focus on Budget Management and Purchasing Process in the J & T Group

• 

  Bohemia energy entity s.r.o.

  Mar 2018 - Feb 2022

  Senior controller and data analyst

  • Highly advanced controlling data analysis using MS SQL Server Management Studio and DWH• End to end design of a detailed SQL model for revenue and cash flow planning down to the item level of 1.3 mil. individual customers

• 

  E.on energie, a.s.

  Feb 2022 - Nov 2022

  Senior controller

  • Helped to automate Business Lines Profitability report sourced by SAP and Analysis for Office• Cost Allocation model, completion and automation of the Group profitability statement

• 

  Photon energy corporate services cz s.r.o.

  Dec 2022 - now

  Business analyst

  • Author and implementer of the idea of a MS SQL data warehouse for reporting purposes. A three-layer data warehouse architecture connecting data from NetSuite, the Ticketing system and the HR system has become the main tool for reporting in the back office The data warehouse is fully automated, historized and easy to handle. Its clear architecture provides a robust base for almost any report. • Author of many reports in Power BI sourced by SQL queries running at SQL server • Ad Hoc SQL reports for Controlling, Treasury and Finance teams Show less