Павел

Pavlo Brodskyi
Data Analyst
 [відкрити контакти](див. вище в блоці «контактна інформація»)  [відкрити контакти](див. вище в блоці «контактна інформація»)  Facebook  LinkedIn

Summary
I am good at working with data and making presentations, using different data and BI tools and also Power Point. I
am ambivert, so I can do both of mix with people for team work and completely isolated from outside if needed. My goal
is to reach new level of working with data by mastering Python and become a Data Scientist

Professional Skills
Advanced work with MS Of ice: Work with Google Sheets, Looker Social skills. English level
Excel formulas, Power Query, Studio, Tableau, SQL Advanced, Russian/Ukrainian
Power Pivot, Macros, level Native
PowerPoint, Power BI

Work experience
NDA Analizing inancial data for crypto-exchanger. Creating periodical and ad hoc
Analyst reports in Excel, Word and Google Sheets.
Built an infrastructure for tracking and analyzing payment systems' invoices and
09/2023 - present
banks' statements and also made a model for prognosing future receivings.
Optimized and improved managements accounting both functionally and visually.
Salvaged some longtime debts through negotiations with partners and made
recomendations which led to cut of unnecessary expenditures.
NDA Analysis in traf ic arbitrage: calculation of inancial balances with partners,
Analyst creating daily reports in Tableau about amount of leads and FTDs, calculating leads
to FTDs conversion, ad hoc reports in Excel.
03/2023 - 08/2023
Created Tableau dashboard consisting and visualizing all the data every team
needed. Also automotized some routine tasks in Google Sheets.
NDA Analysis in traf ic arbitrage: calculation of inancial balances with partners,
Analyst making ad-hoc reports about clients' last comments, amount of leads and FTDs,
calculating leads to FTDs conversion, player value, etc.
08/2022 - 01/2023
Creating cumulative daily reports using Lookers Studio and later moved it to
Power BI and and made it more comprehensive.
Writing and adapting SQL queries of different scale to the metabase.
Dentsu Media (part of Making the most part of media market overview (Economics, Audience, TV, Radio,
dentsu,Inc.) Out-of-home segments and part of Digital segment). Thoroughly remade this
Researcher report, made it more exhaustive and more visially appealing.
Taking part in tenders for new clients: making data bases and competitive analysis
09/2020 - 08/2022
for presentations.
Making regular and ad hoc reports about advertising activity of clients’
competitors and consumers’ behaviour using Excel and Power BI (dashboards
were often developed by myself using Power Query and Power Pivot).
Developed Power BI dashboards for two clients for their weekly reports from
scratch.
Pioneered in using some of the software and in calculating cumulative TRPs for all
media.
Clients’ markets: alcohol, pharma, inance, telecommunications, mobile
connection, confectionery, couriering, retail.
 Work experience
Carat Ukraine (part of Making regular and ad-hoc reports about advertising activity of clients’
dentsu, competitors and consumers’ behaviour, taking part in making media market
Inc.) overview (Out-of-home segment).
Researcher Regular reports included:
Weekly Excel or Power BI reports about advertising activity on clients’ markets;
12/2017 - 04/2020
Quarterly Power Point reports about consumers’ behaviour, quarter Power Point
media market overview reports (included trends, top categories and brands, etc.);
Half-year Power Point competitive analysis reports (included advertising activity
in different types of media and advertising budget estimations).
Profoundly re-made competitive analysis report for one of the biggest clients by
including previously ignored co-branding and not-monitored activity.
Clients’ markets: home appliances, home appliances retail, payment systems,
jewellery, hygienic paper production, banking.

Education
European University Marketing (Faculty of Economics and Management), master
2024 - present

Taras Shevchenko Marketing (Faculty of Economics), bachelor
National University of Kyiv
2016 - 2019

Certi icates
2026 Data Analyst by Mate Academy
2020 Internal dentsu Ukraine courses (MS Office, Marketing, Project Managment, etc.)

2018 Kantar MMI courses