Працював в 7 компаніях   16 років 8 місяців

Енергетика та Енергоносії, Телекомунікації / Зв'язок, Фінансові послуги, FMCG

Analyst

Energy Suppliers Association

Енергетика та Енергоносії

2 роки 4 місяці

02.2022 - 06.2024

Preparation of strategic plans and reports, regular, presentational, analytical materials, reviews,... regarding markets:

  • gas, gas supply, gas distribution;
  • water supply;
  • heat supply;
  • electricity supply;
  • cogeneration, energy saving and alternative energy;
  • investment projects, restoration and reconstruction programs of energy facilities

Senior analyst of the strategic development department

Ukrtransgaz, JSC

Енергетика та Енергоносії

2 роки 5 місяців

09.2019 - 02.2022

  • Prepared plans, explanatory notes, presentation materials, regarding the development of gas storage facilities for 20-31
  • SWOT analysis, ranking, modeling of costs and prospects
  • Monitoring and support the implementation of investment projects
  • Modeling of underground gas storages activities
  • Preparation of a road map and long-term business plans for the development of gas storage facilities
  • Preparation of portfolios of investment projects

Head of Commercial Analytics. Strategic Analyst

Volia

Телекомунікації / Зв'язок

1 рік 9 місяців

12.2017 - 09.2019

  • Leading and building a high performing Commercial Analytics team
  • Drawing up the annual, monthly, revenue, sales, churn and migrations plans
  • Сreation of new reporting forms and models
  • Coordinating the complete sales reporting and forecasting for all sales channels
  • PI preparation, analysis of their revenue and churn effect
  • Preparation of presentations and materials for company management meetings

Demand Planning Specialist

Ukrtelecom

Телекомунікації / Зв'язок

2 роки 2 місяці

06.2015 - 08.2017

  • drawing up the annual, monthly plans;
  • analyzing sales and performance records, interpreting results of overall sales;
  • creating new forms of reports, improvement of the existing report system;

  • coordinating the complete sales reporting and forecasting for different channels...

Analyst

Post Finance

Фінансові послуги

2 місяці

01.2015 - 03.2015

  • designing analytical system of the company;
  • marketing analysis: tariffs, market dynamics, trends, government regulation...
  • creating new forms of reports,coordinating the complete sales reporting and forecasting for all sales channels;
  • drawing up special reports and forecasting models on request...

Head of Analytics Department, Leading analyst

Milkiland-Ukraine

FMCG

1 рік 10 місяців

02.2013 - 12.2014

- creating the analytical system of the company, organizing the activity of sales analysis department;

- drawing up the annual, monthly, weekly and daily sales plans;

- analyzing sales and performance records, interpreting results of overall sales, profitability in different sales channels (supermarkets, distributors, retail), TOP-sales analysis

- marketing analysis: prices, market dynamics, trends, government regulation..;

- creating new forms of reports, existing report system improvement;

- conducting SKU Input-Output Analysis, ABC analysis of the assortment;

- coordinating the complete sales reporting and forecasting for all sales channels...

Chief Analyst

SoloMia

FMCG

5 років 6 місяців

06.2007 - 12.2012

- forming the comprehensive system for the collection and processing information in the company;

- drawing up the annual sales plans, marketing plans and business plans of the company;

- researching of the various segments of "Food&Beverages" market, preparing special reports and briefs about the other markets (upon request);

- conducting regular analyses of import and export, production volumes and prices, demand and supply;

- drawing up proposals on raw materials supply improvement;

- monitoring seasonal demand and sales trends, planning marketing promotions;

- analyzing previous year sales and expenses to estimate future sales and expenses;

- conducting SKU Input-Output Analysis, ABC analysis of the assortment; - conducting SWOT analysis of the company and competitors;

- conducting analysis of indicators media activity, of the main companies in the Ukrainian tea market;

- working with the 1S8, databases Access, Cronos, Nielsen, SPOT and others

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

  • big experience creating the analytical system of the company, organizing the activity of sales analysis department;
  • drawing up the annual, monthly, weekly and daily sales plans;
  • sales and marketing analysis: prices, market dynamics, trends, government regulation..;
  • Data modeling: Revenue, Sales, Churn models. Financial models, EBITDA, P&L, Margin in Excel: Power BI, Power Pivot, Power Query...
  • coordinating the complete sales reporting and forecasting for all sales channels;
  • preparing reports for UNDP and GEF programs ...

Навчався в 2 закладах

Ukrainian State University of Water Resources and Environmental Management

Faculty of Economics

2003

Institute of Statistics

Accounting and Auditing

2002

Володіє мовами

Англійська

поглиблений

Може проходити співбесіду на цій мові

Може проходити співбесіду на цій мові

Російська

вільно

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

Basics of legislative linguistics

Kyiv, 2023

norm design skills using current linguistic rules and tools

Data visualization

Kyiv, 2020

SQL Advaned

Kyiv, 2018

SQL data modeling

Emotional intelligence (EI)

Kiev, 2017

DAT206x Analyzing and Visualizing Data with Excel

Kiev, 2017

Analyzing and Visualizing Data with Excel 

SQL: Analyzing Business Metrics

2016

Codecademy, SQL

SQL: Table Transformation

2016

Codecademy, SQL

Business English

Kiev, 2016

Prometheus

Learn SQL

2015

Codecademy, SQL

Python

2015

Codecademy, Python

PR - Course «Master of Political Management»

Київ, 2012

PR-курс «Master of Political Management»

Business course "Market analysis in the operational marketing"

Kyiv, 2008

Business course "Market analysis in the operational marketing"

Denys

Head of Analytics Department, Strategic analyst

Київ

1 грн.

43 роки

Працює, але відкритий для пропозицій

повна зайнятість, неповна зайнятість, проектна робота

Характер роботи: віддалена робота, гібридна, в офісі/на місці

Оновлено 1 день тому