Open to opportunities

Ivan Ostapenko

@ivanostapenko

Message

Junior Business & Data Analyst focused on funnel operations, revenue analytics, and automated reporting.

Ukraine

Message

What I'm looking for

I’m looking for a role where I can own funnel operations and revenue analytics—building GA4/Meta CAPI tracking, automating SQL reporting, and using dashboards to stop budget leaks while aligning cross-functional teams through clear executive insights.

I’m a Junior Business & Data Analyst / Revenue Operations professional with 2+ years of direct experience in data analytics, funnel optimization, and automated reporting pipelines. I enjoy turning messy commercial data into clear, decision-ready insights.

In Funnel Operations, I extracted, transformed, and analyzed structured datasets across multiple performance pipelines to support data-driven decisions for user acquisition channels. I wrote and maintained optimized SQL queries (including multi-stage joins and CTEs) to pinpoint root causes of commercial funnel drops.

I built and maintained end-to-end tracking pipelines using Google Analytics 4, Meta CAPI, and Cloudflare, then designed granular data visualization reports that isolated exact drop-off points and prevented budget leaks. I also integrate AI tools (Claude, ChatGPT, Cursor) into daily SQL and analytics workflows to automate repetitive work and improve documentation quality.

Before focusing on analytics, I led B2B and multi-unit operations—serving as a key data and communication interface for executive stakeholders, developing data-backed proposals and scenario models, and managing P&L, forecasting, and cash flow analysis. I bring that operational mindset to analytics to ensure insights translate into measurable business outcomes.

Experience

Work history, roles, and key accomplishments

Data Business & Data Analyst

Self-Employed

Jan 2025 - Jan 2026 (1 year)

Extracted, transformed, and analyzed funnel performance datasets across user acquisition channels, supporting data-driven commercial optimization and automated reporting. Wrote optimized SQL queries (joins/CTEs) for funnel drop-off root-cause analysis and built tracking pipelines across GA4, Meta CAPI, and Cloudflare.

Data Analytics Commercial Analytics Funnel Leak Identification SQL Root Cause Analysis Data Cleaning GA4 Meta CAPI Cloudflare Data Visualization Executive Reporting Claude ChatGpt Cursor

B2B Project Manager

SignWork

Jan 2024 - Jan 2025 (1 year)

Served as the key data and communication interface for commercial B2B accounts, gathering and documenting business requirements for executive stakeholders. Developed commercial proposals and data-backed project budget and scenario models while managing delivery hypotheses and SLA compliance.

Business Requirements Gathering Business Intelligence (BI)SQL Query Optimization Commercial Analytics Data Visualization Scenario Modeling Proposal Development SLA Stakeholder Management

Operations Director, Multi-Unit Manager

Zeus Track

Jan 2021 - Jan 2024 (3 years)

Held full operational accountability for multi-unit business performance, managing P&L statements, financial forecasting, and cash flow analysis. Translated operational data into executive summaries, tracked core operational KPIs across teams of 45+, and integrated AI tools into analytics workflows.

Multi Unit Operations P&L management Financial Forecasting Cash Flow Analysis Executive Reporting KPI Tracking Resource Planning Excel Modeling Claude ChatGpt Gemini)Cursor

Project Manager

Synergy Fitness

Jan 2022 - Jan 2023 (1 year)

Supervised infrastructure construction and facility deployment projects from tender through final sign-off. Managed project budget compliance and controlled tender selection procedures for technical contractors.

Project Management Deployment Tender Management Budget Compliance Contractor Management