Контактна інформація

Шукач вказав телефон , ел. пошту та LinkedIn.

Отримати контакти цього кандидата можна на сторінці https://www.work.ua/resumes/8788374/

Досвід роботи

Business analyst

з 07.2024 по 01.2026 (1 рік 7 місяців)
newage., Remote (Marketing, advertising, and PR)

Organization and control of cross-linked Google Sheets architecture for media advertising agency management accounting, including:
- media campaign realization database, control of data entry, period-end closings, automated calculations for project teams profitability, specific KPI's for key clients, forecast vs. actual analysis;
- project teams KPI tracking files, individual employee performance metrics;
- organizational structure & financial modeling, headcount data, employment types, tax liabilities, integration with financial forecasts to model agency profitability and unit economics;
- monthly payroll processing, base salaries, performance bonuses, % workload, business trips, benefits (corporate language training);
- monthly Profit & Loss reporting, automation;
- Power BI dashboards, other presentations;
- ad hoc analytical support.

Improved the management accounting system.
Carried reporting system to a quality new level.

Data Analyst

з 12.2022 по 03.2026 (3 роки 4 місяці)
Proxima Research International, Remote (IT)

- weekly sales calculation, control and modeling dynamics to achieve indicative values, automation processes, report on certain product group balances;
- participation in daily sales calculation, detection and analysis of abnormal trend deviations, forecasting;
- responding ad hoc requests from team or clients to calculate, analyze and visualize data;
- creating complex data models, interconnected tables and directories;
- calculating specific indicators of market activity.

Data Analyst (professional development)

з 07.2022 по 12.2022 (6 місяців)
250 hours BI course (dan-it.com.ua/uk/program/kiev/business-intelligence/#program), Remote (IT)

- database design and advanced SQL programming
(github.com/vsevolod-zelenkov/MySQL);
- back-end: data integration, Python
(github.com/vsevolod-zelenkov/Python);
- introduction to Big Data, machine learning, and predictive analytics;
- front-end: reporting tools and concepts, Tableau
(public.tableau.com/app/profile/vsevolod4198);
- Power Pivot and Power BI
(https://github.com/vsevolod-zelenkov/PowerBI).

(dan-it.com.ua/certificates/business-intelligence/zelenkov-vsevolod/)

Planning Economist, Data Analyst

з 07.2021 по 05.2022 (11 місяців)
TEDIS Ukraine, Remote (Wholesale, distribution, imports, and exports)

- calculating current balances with key suppliers, modeling forecast values;
- control on consistency between SAP / BAS databases;
- gross profit report, plan-fact, factor analysis;
- calculation for provided discounts, dynamics in terms of regions, sales channels;
- data consolidation, report on key performance indicators (KPI's);
- report on profitability of business units, factual cost budget execution;
- building reports and dashboards in Power BI.

Implemented Power BI data visualization in department, set up automation of basic reports.

Financial Economist

з 04.2021 по 07.2021 (4 місяці)
Basepack, Kyiv (Chemical industry, pharmaceuticals)

- daily report on sales, direct costs and direct expenses, monthly gross profit report;
- preparation, agreement and control for payment plans;
- sales analysis, combined ABC / XYZ analysis;
- data consolidation for employee salaries;
- organization and control of motivation payments to customers;
- working on financial development models;
- Google Sheets management reports.

Financial Economist

з 11.2020 по 03.2021 (5 місяців)
Energy 365, Kyiv (Power industry)

- cash flow report, budget planning;
- actual VAT tracking (cash method);
- payment register, coordination and control of execution;
- consumer indebtedness, indicators for legal department, control on payments under restructuring agreements;
- monthly, quarterly and annual reporting forms;
- calculation of payments for electricity distribution system operators;
- control over turnover of bank accounts.

Financial Analyst

з 11.2012 по 04.2020 (7 років 6 місяців)
New Resource, Auto Resource Service, Kyiv (Auto business and auto service)

- P&L, BS, CF, financial reports;
- business activity analysis (profitability of sales, combined ABC / XYZ analysis, fixed and indirect costs);
- management accounting of business processes using double-entry method;
- profitability analysis on import deliveries;
- budget planning, plan-fact analysis, optimization;
- control of payroll and partner funds payments;
- organization of financial processes for advertising campaigns.

Carried reporting system to a quality new level.
Improved the management accounting system.

Освіта

National Aviation University

Department of Management Technologies, Project Management, Kyiv
Вища, з 2011 по 2012 (1 рік)

Received a specialist's degree.

Industrial Economic College of National Aviation University

Business Economics, Kyiv
Незакінчена вища, з 2007 по 2011 (4 роки)

Received a bachelor's degree. Completed an associate's degree.

Додаткова освіта та сертифікати

Business Intelligence, Data Analyst: SQL, Python, Tableau, Power Pivot and Power BI.

2022, 6 month
Сертифікат

CFO school of practice: management accounting, performance indicators, budgets, company analysis, management, motivation.

2019, 2 month

Знання і навички

• DAX
• Power Query
• Power Pivot
• SQL
• MySQL
• Qlik Sense
• Data Models
• Data analysis
• Data visualization
• Communicability
• Data Reporting
• Formation of pivot tables
• MS Excel
• SAP BW
• MS Power BI
• KPI Reporting
• Gross Profit Analysis
• Data consolidation
• Preparation of financial statements
• Google Sheets
• Cash flow control
• Turnover
• PnL calculation
• Financial planning
• Budget planning
• Financial analysis
• Compilation of the balance sheet
• Maintenance of management accounting
• Tableau
• Python
• Punctuality
• Client-Bank
• User 1C
• Economic analysis of production
• Economic analysis of sales
• Plan factor analysis
• 1C:Enterprise
• BAS user
• MS Outlook

Знання мов

• Англійська — вище середнього
• Українська — вільно

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

Hard skills:
- Data Models, Data Analysis, Data Reporting, Data Visualization;
- Microsoft Excel, Power Query, Power Pivot, Google Sheets;
- Microsoft Power BI, Tableau;
- SQL, DAX, Phyton.

Soft skills:
- responsibility, honesty;
- consistency and attention to detail;
- initiativity;
- open and positive attitude.

З приводу заробітної плати - зараз більш важливе бронювання, тому якщо ця цифра для вас не комфортна, я готовий домовлятись.