Працював в 4 компаніях   13 років 11 місяців

IT, Нерухомість та Девелопмент, Торгівля оптова / Дистрибуція / Імпорт-експорт

Lead of business analysis and reporting

Betinvest LTD (favbet.com, favoritsport.com.ua)

IT

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

10.2016 - до теперішнього часу

  • Analysis of business results of a period - calculation and analysis of structure of revenues, profits and losses, absolute and relative business performance indexes, comparison of revenues/expenses efficiency indexes by countries, types of sales, kinds of services;
  • Analysis of dynamics of revenues, expenses, profits/losses, general profitability by countries;
  • Analysis of dynamics of sales, profitability by types of sales, kinds of services;
  • Build reports/dashboards on the above issues;
  • Preparation of managerial PL reporting for all Business regions, including collection of data from different databases, validation, transformation for reporting;
  • Control of online business metrics - active users, average stakes, ARPU, CAC, CRC, LTV, Churn;
  • Methodological description of accounting model for accounting customer's balances and turnovers;
  • Collaboration with other departments on creation and/or improvement of motivation systems;
  • Preparation of different kind of ad-hock analyses and internal audits;
  • Collaboration with other departments in order to develop algorithms, OLAP cubes, business logics; assigning technical tasks (user cases, stories) for IT developers, testing of results.

Financial Analyst

"TRI O" LLC, BC and shopping mall "Gulliver"

Нерухомість та Девелопмент

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

02.2015 - 10.2016

  • Budgeting - preparation of annual and 3 years plan and rolling forecasts of revenue of the Company, development of different scenarios, development of appropriate reporting tools;
  • Factor analysis of actual revenue variance to plan - development and implementation of the method from the very beginning, regular reporting to the management on the results of analyses;
  • Preparation of periodical analytical overviews on the results of business activity - calculation of average lease rates in different splits (business units, revenue items, currency attachments etc.); calculations of total sum of discount and their structure; analyses of dynamics;
  • Selection of parameters (lease rates, fixed exchange rates) for simulation of different variants of revenue;
  • Preparation of managerial data and comments on the overdue receivables for regular meetings of the commercial department, regular reconciliation of managerial and financial data;
  • Calculation of overdue payments, terms of overdue, fines and penalties due to agreements;
  • Preparation of the report on overall areas vacancy and structure of leased compartments by commercial types of lease;
  • Implementation of the internal turnover sign and possibility of consolidated management reporting without internal traffic between sister companies;
  • Technical assignments for development and automation of reports; collaboration with IT department on improving of managerial calculation registers, algorithms of calculation; testing and debugging of developed reports and processings.

Financial Controller

“Trost Auto Service Technik Tov” LLC

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

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

02.2013 - 10.2014

Financial accounting and reporting:

  • Preparation of IFRS reporting for the Mother company - P&L, Balance Sheet, Cash Flow;
  • Provision and control of full compliance of book keeping and reporting with Corporate standards;
  • Booking of accounting entries on IFRS level for some accounting objects;
  • Calculation, accrual of valuation provisions - allowance on receivables, provision for vocation payments, provision for dead stock, warranty provision.

Managerial reporting and control:

  • Control of the correctness of revenue/cost allocation between Centers due to Corporate standards;
  • Preparation of financial reporting in context of revenue/cost centers for the Mother Company;
  • Preparation of reporting on financial result of the branches;
  • Preparation of analytical reporting on accounts receivable - analyses of receivables turnover and average payback period; analyses of receivable's overdue periods, etc.;
  • Oversee accounts payable and payment timelines control;

Budgeting:

  • Participation in preparation of annual budget and budget forecast;
  • Analyze of actual-budget variance;

Writing technical requests to 1C developers;

Support annual external financial audit;.

Other - performance of different ad-hoc requests, preparation of materials in form of presentation, active participation in Companies' meetings and disputes, participation in annual stock inventory.

Leading economist

Asset Management Company “Globus Asset Management” LLC

Нерухомість та Девелопмент

1 рік 1 місяць

02.2012 - 02.2013

preparation (follow up) and analysis of periodical consolidated cash flow (budget and actual), Balance sheet, P&L Balance, accounts payable, accounts receivable statements of the "Globus" Group;

  • account of current cost of investment projects of the "Globus" Group, analyze of investment expenses;
  • Participation in preparation of business plans (calculation of NPV, payback period etc).

July 2009 - February 2012 - Economist, "Globus Asset Management" LLC

Main duties:

  • involved in preparation (follow up) and analysis of periodical consolidated financial reporting;
  • control of the correctness of filling budget forms by members of the budgeting process;
  • control of the correctness of actual budget (revenue/expense allocation);
  • controlling of investment expenses;
  • account of revenue from investment certificates placement and from other sources of financing;
  • updating loan transactions and interest expenses database;
  • administration of securities trade operations and updating securities database.

November 2008 - June 2009 - Economist's assistant, "Globus Asset Management" LLC

Main duties:

  • opening and closing of bank accounts for companies of the "Globus" Group;
  • selection of optimal bank tariffs and tariff packages;
  • control over bank charges, interest paid on deposits;
  • administration of other questions related to cooperation with banks (agreements with banks, etc.);
  • preparation of consolidated daily cash flow report of the Group.

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

Collection and analysis of business data, discover trends, making reporting tools for visualization, preparing conclusions on results of analysis. Developing system of analytics for decision making.

Навчався в 1 закладі

Kyiv National Economic University named after V. Hetman

Information Systems and Technologies, Applied Statistics

Kiev, 2009

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

Англійська

вище середнього

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

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

Російська

рідна

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

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

Українська

рідна

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

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

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

Statistics and data analysis with R

Kiev, 2018

SQL (2 levels)

Kiev, 2017

Ms.Excel (2 levels)

Kiev, 2015

CAP level of CAP/CIPA

Kiev, 2014

Додаткова інформація

Computer skills

Experience with BI tools (Pentaho, ClickView), accounting software 1C-8, SQL, Google BQ, R (basics), Ms. Excel

Sergey

Data analyst

Київ

39 років

повна зайнятість

Остання активність 6 років тому