Mykola

MYKOLA KROTOV
Data Analyst / Financial Analyst
Kyiv, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація») | LinkedIn: Mykola Krotov | Telegram

PROFESSIONAL SUMMARY 01

I'm a Financial and Data Analyst with hands-on experience in financial reporting, budget
reconciliation, and BI dashboard development in media buying and ad-tech. I bring a background in
sales team leadership and KPI tracking, paired with skills in SQL, Power BI, and Google Sheets/Excel.
I'm known for turning messy, multi-source data into clean, reliable reports – and for catching the
discrepancies others miss.

CORE SKILLS 02

Data & Reporting: SQL, Power BI (DAX, data modeling), Google Sheets / Excel (advanced formulas, automation),
Tableau / Looker Studio
Financial Analysis: Budget reconciliation, financial tracking systems, plan-vs-actual analysis, KPI and payroll
calculation.
Data Sources & Systems: CRM systems, Google Analytics, Keitaro, ad platforms, SQL databases
Analytical Methods: Statistics, A/B testing, product metrics, sales-funnel analysis
Other Tools: GitHub

Languages: Ukrainian (Native), English B1, Polish (Fluent)

PROFESSIONAL EXPERIENCE 03

Financial Analyst – Media Buying company (NDA) (04/2025 – Present)
Engineered automated daily and monthly financial tracking systems for traffic arbitrage, building highly
complex spreadsheets to process multi-level calculations and large datasets
Conducted deep-dive analysis of ad performance across multiple accounts, CRMs, and GEOs, delivering
structured statistical reports to the media buying team for further campaign optimization.
Audited and reconciled media-buyer budgets and deposits, evaluating performance metrics to assess team
profitability and ag discrepancies.
fl

Data Analyst – ОТК Сервіс (02/2024–03/2025)
B uilt and maintained interactive dashboards in o er
P w BI and Google heets for management reporting.
S

Consolidated and cleaned data from CRM, Google nalytics, ad platforms, and
A SQL databases using SQL .
A utomated recurring data-collection and reporting ork o s, reducing manual processing steps.
w fl w

Head of Sales Department – private entrepreneur (01/2023–01/2024)
Led a sales team of 10 people, tracking KPIs and performance coefficients used for monthly payroll and
coaching.
Analyzed the sales funnel to identify bottlenecks and improve conversion rates.
Onboarded and trained new hires, standardizing performance-tracking processes.

Personal Investment Consultant – FREELANCE (05/2022 – 01/2023)
Built crypto portfolios and investment strategies for private clients.
Analyzed crypto markets to advise on risk management and asset allocation.

Sales Manager – ФОП (02/2019 – 05/2022)
Managed the full sales pipeline and client relationships via CRM systems.
Consistently met and exceeded sales targets over multiple years.

education 04

(2022–2026)
DNIPRO UNIVERSITY OF TECHNOLOGY
Bachelor's Degree in Accounting and Taxation (Expected 2026)
(2024)
DONEIT – "DATA ANALYTICS" COURSE
Completed comprehensive projects on data collection, analysis, and working with large datasets. (SQL, Power BI, data
collection and analysis projects)
(2016–2020)
STEP COMPUTER ACADEMY
Diploma in Computer Technologies and Software Engineering