Timeline
🏅 Achievement 🥑 part-time
mar 2026 - jun 2026
nov 2025 - jan 2026
Financial Data Analyst — Fintech / Payments - Freelance Project
Payment Gateway / PSP (company under NDA), Remote
- Built Python / MSSQL pipelines for PSP reconciliation: provider file loading, transaction matching, and financial exception reporting.
- Designed rule-driven reconciliation — provider matching rules stored in the database, not hardcoded; a new provider is onboarded via configuration, without code changes.
- Worked with order_id / external_id matching, approved flows, chargebacks, refunds, fee logic, amount mismatches and unmatched transactions.
- Rebuilt the special transaction-chain logic for cascaded provider flows; restored correct parent–child matching across multiple providers.
- Improved reconciliation coverage from ~70–80% to near-complete matching by fixing chain logic, matching rules, fee calculation and PSP amount logic.
- Designed and automated the Rolling Reserve calculation pipeline in Python: daily transaction ingest, MID mapping, tariff matching by date/channel/traffic, FX conversion to EUR, reserve accruals, cap enforcement, release scheduling, and BI-ready outputs.
- Re-engineered legacy hardcoded reserve logic into a configurable, rule-driven model, making cap and release rules adjustable without code changes.
- Automated data-quality checks & alerts: missing MID mappings, tariff gaps, invalid rules, missing FX rates, cap violations, release issues and reconciliation inconsistencies.
- Processed high-volume data (100k+ rows per daily run; larger monthly reconciliation scopes) with prod-safe, read-only access to production tables.
- Investigated legacy 2024–2025 transaction and data issues that had not been detected before.
Tech: Python (Pandas, NumPy), MSSQL, SQL, Google Drive/Sheets API, Git
Data / Operations Analyst (Logistics & Geo Analytics) , iPOST -Courier Logistics Platform
Built end-to-end analytics infrastructure for a courier logistics platform, transforming raw operational exports into a structured analytical system for operational and financial decision-making.
Responsibilities & Impact:
Data / Operations Analyst (Logistics & Geo Analytics) , iPOST - Courier Logistics Platform
Built end-to-end analytics infrastructure for a courier logistics platform, transforming raw operational exports into a structured analytical system for operational and financial decision-making.
Responsibilities & Impact:
- Designed data pipeline: raw exports → JSON normalization → PostgreSQL analytical data model
- Structured and linked core entities: orders, couriers, surcharges, transactions, tariffs, routes, recipients
- Built analytical data warehouse logic for BI usage (order, courier, city, day granularity)
- Developed BI dashboards (Power BI / Tableau) for:
- SLA performance & delivery delays
- courier productivity & workload distribution
- order profitability & surcharge impact
- system vs courier income analysis
- Performed geo-analytics:
- address geocoding (HERE, Google fallback, Nominatim)
- route distance analysis (OSRM)
- comparison of tariff vs real delivery distance
- Conducted operational modeling:
- courier supply vs delivery performance
- city complexity coefficients & density modeling
- estimation of required courier capacity per area
- Linked operations with finance:
- system revenue vs courier payouts
- surcharge impact on margins
- identification of loss-making delivery scenarios
Tech stack: Python, SQL (PostgreSQL), Tableau, Power BI, Jupyter, Geo APIs, OSRM
feb 2025 - nov 2025
Data / Financial Analyst - Freelance Project , Zurich @gotou.me
Worked as a data/financial analyst in GoTo, an AI-powered booking aggregator that consolidates service requests from platforms like WhatsApp, Instagram, Telegram, ClassPass, Treatwell, and others. The project aimed to simplify and automate service bookings through a smart unified interface.
- Built a detailed 5-year revenue projection model in Google Sheets, accounting for seasonal growth, churn, subscription mix (monthly, annual, feature-based), retention and cohort behavior.
- Designed and implemented Python-based forecasting logic (pandas), including client segmentation and cashflow breakdowns.
- Developed activation and retention funnel analysis, helping identify user drop-off points.
- Extracted behavioral data using advanced SQL (window functions, CTEs) for product and finance teams.
- Built real-time dashboards in Metabase for stakeholder visibility on KPIs and forecasts.
- Conducted manual QA, tested backend APIs via Postman, load-tested workflows using JMeter, and filed bugs in Jira.
Results:
The model became the financial core of the product, used for strategic decision-making and investor reporting. Helped validate pricing hypotheses, improve revenue planning, and guide team priorities based on actual user behavior.
Education
Master of Accounting and Auditing (2004-2009)
Majors: Accounting and Auditing
National University of Economics, Kharkiv
Certificate: Data Analyst (Dec. 2023 - Oct 2024)
Data Analysis
IT Career Hub GmbH, Berlin @ itcareerhub
Languages
- Ukrainian (native)
- Russian (C2)