Contact information

The job seeker has entered a phone number , email and LinkedIn.

You can get this candidate's contact information from https://www.work.ua/resumes/8788374/

Work experience

Business analyst

from 07.2024 to 01.2026 (1 year 7 months)
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

from 12.2022 to 03.2026 (3 years 4 months)
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)

from 07.2022 to 12.2022 (6 months)
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

from 07.2021 to 05.2022 (11 months)
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

from 04.2021 to 07.2021 (4 months)
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

from 11.2020 to 03.2021 (5 months)
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

from 11.2012 to 04.2020 (7 years 6 months)
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.

Education

National Aviation University

Department of Management Technologies, Project Management, Kyiv
Higher, from 2011 to 2012 (1 year)

Received a specialist's degree.

Industrial Economic College of National Aviation University

Business Economics, Kyiv
Unfinished higher, from 2007 to 2011 (4 years)

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

Additional education and certificates

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

2022, 6 month
Certificate

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

2019, 2 month

Knowledge and skills

• 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

Language proficiencies

• English — above average
• Ukrainian — fluent

Additional information

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.

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