Працював в 5 компаніях 13 років 11 місяців
IT, Нерухомість та Девелопмент, Торгівля оптова / Дистрибуція / Імпорт-експорт
Senior data analyst. team lead
International iGaming & Sports Betting multi-brand Operator
IT
5 років 11 місяців
05.2020 - до теперішнього часу
• Participated as a key stakeholder in creation of the company's end-to-end analytics infrastructure from the ground up, including close cooperation with backend/data-engineering team on data-related issues;
• Developed a comprehensive BI infrastructure using Tableau, automating reporting/ dashboards and serving multiple teams;
• Created and maintained reporting/dashboards for the core KPIs - revenue, actives, GGR, Bonuses, Deposits, Withdrawals etc.;
• Conducted analysis and visualization of product and marketing metrics - conversions, affiliate/channel performance, customer LTV, ARPPU, ARPU, retention etc.;
• Customer segmentation based on value, tenure and last activity; created and maintained the system of regular supply of customer data to AM/support teams by segment;
• Analysis of overall bonus performance and promo campaigns’ results;
• Designed and analyzed A/B tests for product features and marketing campaigns, a number of which led to significant improvement of business performance;
• Developed statistical and machine learning models for fraud prediction, VIP detection, deposit amount recommendation, leading to a proven positive monetary effect;
• Collaborated with cross-functional teams to fill their requests and achieve business goals;
• Provided in-depth ad-hoc analysis on different issues, including payment method performance, game profitability, and post-platform migration etc.
• Led the Analytics team of 3.
Lead of business analysis and reporting
Betinvest LTD (favbet.com, favoritsport.com.ua)
IT
4 роки 8 місяців
10.2016 - 05.2021
- Led the Business Analysis and Reporting function for an international sports betting and gambling operator;
- Conducted financial and performance analysis, including the calculation of revenue, profit and loss, and other key business performance indicators across countries, sales channel, service types.
- Prepared managerial PL reporting for all Business regions, including data collection from different data sources, data validation, transformation for reporting;
- Developed and maintained reports and dashboards to visualize key business performance metrics;
- Controlled online business metrics - active users, average stakes, ARPU, CAC, CRC, LTV, Churn;
- Analyzed efficiency of marketing affiliate programs and control of affiliate’s charges;
- Performed different kind of ad-hock analyses and internal audits;
- Designed and documented the methodological framework for a new internal accounting model aimed to automate accounting of customer’s balances and turnovers;
- Collaborated with other departments in order to develop algorithms, business logics.
Financial Analyst
"TRI O" LLC, BC and shopping mall "Gulliver"
Нерухомість та Девелопмент
1 рік 9 місяців
02.2015 - 10.2016
• Budgeting – led preparation of annual and 3 years revenue plan and rolling forecasts, scenarios analysis, participated in development of appropriate reporting tools;
• Development and implementation Factor analysis of actual revenue variance to plan; regularly reported to the management on the results of analyses;
• Prepared regular analytical overviews on business activity, including key metrics like average lease rates, discount structure; analyses of dynamics;
• Modeled different revenue scenarios by ‘playing’ with parameters such as occupation rate, lease rates and exchange rates;
• Prepared managerial data and comments on the overdue receivables for regular meetings of the commercial department, regular reconciliation of managerial and financial data;
• Performed calculation of overdue payments, terms of overdue, fines and penalties due to agreements;
• Conducted the report on overall areas vacancy and structure of leased compartments by commercial types of leases;
• Assigned technical tasks for processes and reports development and automation, collaborating with the IT department.
Financial Controller
“Trost Auto Service Technik Tov” LLC
Торгівля оптова / Дистрибуція / Імпорт-експорт
1 рік 9 місяців
02.2013 - 10.2014
Financial accounting and reporting:
- Prepared transformation of IFRS reporting for the Mother company - P&L, Balance Sheet, Cash Flow;
- Controlled full compliance of book keeping and reporting with Corporate standards;
- Booking of accounting entries on IFRS level for some accounting objects;
- Performed booking of accounting entries on IFRS level for some accounting objects - allowance on receivables, provision for vocation payments, provision for dead stock, warranty provision.
Managerial reporting and control:
- Controlled the correctness of revenue/cost allocation between Centers due to Corporate standards;
- Conducted financial reporting in context of revenue/cost centers for the Mother Company;
- Conducted reporting on financial result by branches;
- Prepared analytical reporting on accounts receivable – analyzed receivables turnover and average payback period; analyses of receivable’s overdue periods, etc.;
Budgeting:
- Participated in preparation of annual budget and budget forecast;
- Analyzed actual-budget variance;
• Composed technical requests to 1C developers aimed to meet corporate rules, maintain reporting transformation to IFRS, implement corporate reporting forms etc.;
• Supported annual external financial audit – explained internal accounting policies and standards, differences in local and IFRS reporting, assisted in auditors’ requests;
• Other – performed different ad-hoc requests, conducted presentation, participated 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.
Ключова інформація
Skills - Data analytics, Product analytics, performance metrics, KPI, reporting, data vizualisation, Business intelligence, data insights, discover trends, hypotesis testing, A/B tests, Data Science, Machine Learning;
Tools - SQL (Postgress, GoogleBQ), Tableau, Python, NumPy, Pandas, Scikit-learn, Excell.
Навчався в 1 закладі
Kyiv National Economic University named after V. Hetman
Information Systems and Technologies, Applied Statistics
Kiev, 2009
Володіє мовами
Англійська
вільно
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Російська
рідна
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Українська
рідна
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Курси, тренінги, сертифікати
Tableau Certified Data Analyst
Google Advanced Data Analytics Specialization (Coursera)
Data analytics, Statistical analysis, Machine learning,
Machine Learning and Data Analysis Specialization (Coursera)
Data science, Machine Learning, Python programming
Statistics and data analysis with R
SQL (2 levels)
Ms.Excel (2 levels)
CAP level of CAP/CIPA
Додаткова інформація
Kaggle site
https://www.kaggle.com/lakshtanov18031987
Serhii
Serhii
Senior data analyst, Data Scientist

Київ
Працює, але відкритий для пропозицій
повна зайнятість, неповна зайнятість, проектна робота
Характер роботи: віддалена робота, гібридна, в офісі/на місці
Остання активність 1 тиждень тому