Ігор

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

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 visualize key performance indicators, supported by practical experience at
"Big 4" and international audit firms.

HARD SKILLS: SQL, Python, R, product metrics (CAC, LTV, ROMI), unit economics modeling, financial forecasting & budgeting, cost-benefit
analysis, P&L analysis, market & competitive intelligence, trend analysis, A/B testing, conversion funnel, cohort retention analysis, marketing
ROI/ROAS optimization, marketing attribution modeling, customer segmentation (RFM, behavioral), customer funnel analysis, statistical hypothesis
testing, data cleaning & validation, data visualization, Scrum methodology, prompt engineering, generative AI tools (ChatGPT, Claude, Gemini).
TOOLS: Tableau, Microsoft Power BI, Looker Studio, Metabase, Google BigQuery, PostgreSQL, Amplitude, Google Analytics 4 (GA4), Google
Ads, WordPress, Figma, Canva, Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook, Google Colab, Excel (Power Query, Pivot Tables),
Google Sheets, Notion, Nextcloud, Orange, EViews, GeNie.
SOFT SKILLS: Analytical thinking, problem solving, cross-functional communication, team collaboration, proactive mindset, time management,
active listening, critical thinking, stress tolerance, adaptability.

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

Languages English - Intermediate Ukrainian - Native Russian - Advanced Czech - Beginner

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

KPMG Ukraine Assistant Auditor February 2025 - November 2025
Conducted training sessions for colleagues on preparing and sending requests to clients (confirmation letters).
Participated in 3 inventories of agricultural companies.
Successfully passed the test after the probationary period with a score of 89%.

BitCapital Risk Analyst March 2026 - October 2026
Automated SQL data extraction and Google Sheets workflows via Python scripts, accelerating report generation by 3x
and saving 15+ manual hours weekly.
Conducted root-cause analysis on credit metric deviations, delivering actionable insights that improved monitoring and
reduced risk identification time by 30%.
Refactored legacy SQL workflows for large-scale financial datasets, cutting query execution time by 50% and
improving overall analytical performance.
Consolidated diverse data sources into automated Metabase dashboards, expanding tracked KPIs to 25 and
improving load speed for 7+ key stakeholders.
Partnered with the Marketing department to design customized, automated reporting frameworks, standardizing
metrics evaluation and improving tracking efficiency for 10+ monthly campaigns.

EDUCATION
Scrum and Agile practices, Skillsetter July 2025 - September 2025
IT School GoIT, Data Analyst [Link] June 2025 - January 2026
Virtual International Program, Justus Liebig October 2025 - February 2026
[Link]
University Giessen, Germany
National University of Kyiv-Mohyla Academy [Link] 2022 - 2026
Bachelor's degree; Finance, banking and insurance