Особисті дані приховані

Oleksandr ZIkratov
junior data analyst

ABOUT ME

I finished university in 2022. Currently, I have been working as a Junior Data Analyst at
PricewaterhouseCoopers (PwC) since December 2022. In my job, I use various tools such as
Excel (including pivot tables, formulas, and power query), MySQL, Python, and automation
CONTACTS tool Alteryx. I am proficient in handling big data in various formats and can parse, transform
and process any type of data
 Kyiv, Dragomanova 12

 [відкрити контакти](див. вище в блоці «контактна інформація») WORK EXPERIENCE
 [відкрити контакти](див. вище в блоці «контактна інформація»)

 18.08.2000 01.12.2022- Junior data analyst
now PricewaterhouseCoopers (PwC)  Lviv/Ukraine

TECHNICAL SKILLS In my position, I analyze accounting journal entries and prepare special reports and
dashboards using the QlikView system. I have proficiency in using various tools, including
SQL Middle Excel (including pivot tables, formulas, and power query), MySQL, Python, and the
Excel Advanced automation tool Alteryx. Additionally, I am experienced in handling big data in various
Python Basic formats, and I am able to parse, transform, and process any type of data

1C Middle
June 2022- Economist assistant
Math skills Advanced November Limited Liability Company "Landcom"  Kyiv/Ukraine
Power BI middle 2022

During my previous role, I was responsible for managing accounting invoices, calculating
LANGUAGES
expenses and income, and assisting with financial control and salary payments.
I possess extensive experience in working with Microsoft Excel, with proficiency in utilizing
Ukrainian Native
formulas, pivot tables, and other advanced features. Additionally, I had experience working
Russian Native with Bitrix24, where I was responsible for charging working hours and managing task
English B2 assignment
Germany A2
January Internship financial analyst
2022 - May ROSHEN Confectionery Corporation  Kyiv/Ukraine
2022

In my position, I was responsible for conducting balance sheet analysis, cash flow analysis,
market research, product pricing, and costing. Additionally, I handled accounting invoices
and prepared profit and loss statements.
I had extensive experience working with Microsoft Excel, including proficiency in using
formulas, pivot tables, and other advanced features. I also had experience using Microsoft
Teams for collaboration and communication. In addition, I have worked with an ERP system
called 'IT-Enterprise' and have a strong understanding of its functionalities and capabilities

August Mathematics Teacher
2019-June Private school "Grand Expo"  Kyiv/Ukraine
2020

On this position I taught school and advanced school mathematics to pupils.
Also I had experience working with business processes using Bitrix24
EDUCATION

2019-2022 Bachelor degree in Business Administration
Taras Shevchenko National University of Kyiv  Kyiv/Ukraine

I have studied:
Finance
Management
Micro and macroeconomics
Econometrics
Business and project analysis
Logistics
Economic analysis and business planning

2017-2019 Applied Mathematics
National University of "Kyiv-Mohyla Academy"  Kyiv/Ukraine

I studied for two years and then transferred to another university. During my studies, I
covered various disciplines including:
Calculus
Statistics and Probability
Set Theory
Discrete Mathematics
Linear Algebra
Combinatorics
Differential Equations

ADDITIONAL COURSES AND TRAININGS

2023-now DATA SCIENTIST
online school for programming and data science robot_dreams
 Kyiv/Ukraine

Learn python, oop princeples, machine learning

2022 Professional course MSExcel
Computer education center "Basic"  Kyiv/Ukraine

professional using excel

2021 The qualification upgrade course "Finance&Audit”
STUD POINT  Kyiv/Ukraine