Ігор

Makartsov Ihor
[Link to Portfolio]

[відкрити контакти](див. вище в блоці «контактна інформація») · [відкрити контакти](див. вище в блоці «контактна інформація») · [відкрити контакти](див. вище в блоці «контактна інформація») · Ostrava, Czech Republic

DATA ANALYST
Results-oriented Data Analyst with a strong background in Finance and Audit. Experienced in data collection,
cleaning, and interpretation using Python, SQL, and BI tools to drive business decisions. Proven ability to analyze
financial statements and visualize key performance indicators, supported by practical experience at "Big 4" and
international audit firms. Skilled in transforming complex datasets into actionable insights.

HARD SKILLS: SQL, Python, Product & Business metrics (CAC, LTV, ROMI, Churn), A/B Testing, Conversion
funnel, Cohort retention analysis, Marketing campaign evaluation, Statistical hypothesis testing, Data Cleaning &
Validation, Data Visualization & Storytelling, Financial & Market Analysis.
TOOLS: Tableau, Power BI, Looker Studio, BigQuery, PostgreSQL, Amplitude, Google Analytics, Pandas, NumPy,
Matplotlib, Seaborn, Jupyter Notebook, Excel (Power Query, Pivot Tables), Google Sheets, Orange, EViews,
GeNle
SOFT SKILLS: Meticulous, Proactive, Analytical, Committed, Communicative

PROJECT EXPERIENCE
User Conversion & Retention Insights
[Link to Code] [Link to Tableau Dashboard]
Tools: SQL (BigQuery), Tableau, Google Analytics 4
Description: Engineered an end-to-end product analytics dashboard using raw GA4 event-level data to diagnose
user drop-offs, platform disparities, and customer retention dynamics.
My tasks: Extracted and aggregated raw database events using SQL, implemented cohort retention analysis
(weekly churn tracking), designed multi-stage conversion funnels, segmented acquisition channels, and
established market benchmarks for ARPU/ARPPU.
Result: Pinpointed a critical 81% drop-off between product views and cart additions, identified a massive Week 2
cohort retention cliff where the majority of new users churn

US Tech Sector ESG Investment Strategy & Market Valuation
[Link to Code] [Link to Tableau Dashboard]
Tools: SQL, Tableau, Excel, Python (Pandas, NumPy, SciPy, Statsmodels, Seaborn, Matplotlib).
Description: Built an investment decision-making framework analyzing the impact of ESG (Environmental, Social,
Governance) performance on the market valuation and financial risk of 22 major US tech companies.
My tasks: Performed non-linear regression analysis (OLS, VIF, Hypothesis Testing), calculated financial metrics
(ROA, Tobin's Q, Leverage, Price-to-Book), segmented industry sub-sectors using SASB and IFRS S2 standards,
and built correlation matrixes.
Result: Proven an inverted U-shaped relationship between ESG and corporate value with a strict financial
optimum at 58.42 points (beyond which ESG spending destroys FCF), identified a 27.54% "social penalty" driven
by non-core philanthropy, and mapped out an optimal compliance matrix with a decision-making algorithm to
relocate corporate capital into R&D and cybersecurity

Marketing Campaign Analysis & Conversion Funnel (E-commerce)
[Link to Code 1] [Link to Code 2]
Tools: SQL (PostgreSQL, BigQuery), Google Analytics 4, DBeaver
Description: Analyzed cross-platform advertising performance (Google & Facebook) and user behavior to
evaluate campaign efficiency and conversion dynamics.
My tasks: Data extraction and cleaning using SQL, KPI calculation (ROMI, Conversion Rate, Churn), funnel
analysis, traffic segmentation, and ad performance evaluation.
Result: Identified critical funnel drop-off points and determined high-performing channels to optimize marketing
budget allocation.
LANGUAGES
English - Intermediate
Ukrainian - Native
Czech - Beginner
Russian - Advanced

WORK EXPERIENCE
BakerTilly July 2024 - January 2025
Junior Accountant-Auditor
Audited financial statements for two large projects, companies in the defence and technology sectors.
Was involved in three inventories in the following areas: logistics, agriculture, banking, and retail.
Successfully passed two internal tests in the following sections: cash and cash equivalents, inventories.

KPMG Ukraine February 2025 - November 2025
Assistant Auditor
Completed two training courses on LinkedIn Learning: Advanced Excel Functions and Power BI.
Conducted training sessions for colleagues on preparing and sending requests to clients (confirmation letters).
Performed initial audit procedures for 30+ companies in various industries.
Participated in 3 inventories of agricultural companies.
Successfully passed the test after the probationary period with a score of 89%.

EDUCATION

Finance & Audit School, STUD-POINT August 2024

ETHICS CHALLENGE, organised by CFA SOCIETY UKRAINE March 2024
Captain of the team in the student competition on solving
professional ethical problems, took 2nd place

Scrum and Agile practices, Skillsetter platform, 2 July 2025 - September 2025
months of training

IT School GoIT, Data Analyst June 2025 - January 2026

Virtual International Program, Justus Liebig October 2025 - February 2026
University Giessen, Germany

National University of Kyiv-Mohyla Academy 2022 - 2026
Bachelor's degree; Finance, banking and insurance

SOCIAL ACTIVITIES
Copywriter
East West Business business environment
Participant
Balakun