Работал в 4 компаниях   8 лет 7 месяцев

Торговля розничная / Retail, Торговля оптовая / Дистрибуция / Импорт-экспорт

Head of Analytics

Monopoly, Kheraon, Ukraine

Торговля розничная / Retail

5 лет 8 месяцев

11.2020 - по настоящее время

  • analysis of OverStocks and Out of Stocks, ABC and XYZ analyzes;
  • identification of trends and patterns;
  • financial modeling and planning, compilation of P&L, Balance Sheet, Cash Flow (indirect method);

- department management.

  • development of key analytical (regular or as needed) reports and calculations based on large amounts of data from various sources (SQL-Server, file data, SSAS): ETL, modeling, analysis, creation of PivotTables and Dashboards;

Head of the Financial and Economic Department

LDK Ltd, Kherson, Ukraine

Торговля оптовая / Дистрибуция / Импорт-экспорт

11 месяцев

01.2020 - 11.2020

  • analysis of economic indicators of subdivisions;
  • optimization and adjustment of management accounting;
  • development and improvement of the financial model, forecasting the effectiveness of new projects;
  • department management.
  • automation of reporting (P&L, Balance Sheet, Cash Flow, etc.) based on data from various sources (SQL-Server, data from files) using MS Excel software (Power Query, Power Pivot), Power BI;

Financial Analyst

Monopoly, Kherson, Ukraine

Торговля розничная / Retail

1 год 2 месяца

11.2018 - 12.2019

  • financial modeling and planning, P&L, Balance Sheet, Cash Flow (indirect method);
  • analysis and sales planning, ABC and XYZ analysis, preparation of financial calculations;
  • participation in the automation of the process of calculation and approval of plans.
  • development of key automated reports on the performance of the network and departments (Excel, Power Query, Power Pivot);

Financial Analyst

Orexim Holding, Mykolaiv, Ukraine

Торговля оптовая / Дистрибуция / Импорт-экспорт

11 месяцев

09.2017 - 07.2018

  • development and improvement of the financial model of the Holding;
  • forecasting the consolidated financial statements of the Holding (P&L, Balance Sheet, Cash Flow) and key financial indicators (covenants) in the short, medium and long terms.
  • participation in consolidation of the Holding's reporting under IFRS;

Ключевая информация

More than 5 years of experience in financial planning, data analysis and analysis.

Experience with MS Power BI, MS Power Pivot, MS Power Query, and VBA for MS Excel, Basic SQL and Python, beginner QlickView / QlickSense.

DAX (Power Pivot for MS Excel, Power BI): ETL from various sources, including large amounts of data (SQL-Server, SSAS, file data sources), modeling, data analysis and trend detection, forecasting financial reports and covenants, sales planning, respectively trends and Financial Planning, Budgeting, Dashboards.

Учился в 1 заведении

Interregional Institute of Business, Kherson

Economist of finance

Kherson, 2000

Владеет языками

Английский

средний

Русский

свободно

Может проходить собеседование на этом языке

Может проходить собеседование на этом языке

Украинский

родной

Может проходить собеседование на этом языке

Может проходить собеседование на этом языке

Курсы, тренинги, сертификаты

Introduction to Data Modeling for Power BI Video Course

Інші країни, 2020

Introductory video course on data modeling in Power BI, Power Pivot for Excel and Analysis Services from https://www.sqlbi.com

Introducing DAX Video Course

Інші країни, 2020

Introductory video course on the DAX data analysis language from https://www.sqlbi.com, used in Power Pivot for MS Excel and Power BI

Introducing DAX Video Course

2020

Ознайомлювальний відеокурс про мову аналізу даних DAX від https://www.sqlbi.com, що використовується в Power Pivot для MS Excel та в Power BI

Maxim

Financial Analyst

Ровно, Ровненская область

Готов переехать: Одесса, Винница, Ивано-Франковск

48 лет

полная занятость

Последняя активность 4 года назад