Oleksandr

Oleksandr Zamay​
BI Consultant | Power BI Developer | Analytics Engineer​
Kyiv, Ukraine - [открыть контакты](см. выше в блоке «контактная информация») - LinkedIn

Summary​
BI consultant focused on building decision-ready analytics systems for SMB companies.

Design data models and Power BI dashboards that unify Sales, Marketing, Finance, and
Operations into a single source of truth. Combine 10+ years of business leadership with
hands-on BI implementation (Power BI, DAX, SQL, ETL, APIs).

Connect data sources → build a structured data warehouse → create dashboards in
Microsoft Power BI → define KPIs and translate metrics into insights for management
decision-making.

BI Impact​
• Built unified reporting systems consolidating CRM, marketing, and operational data into
executive dashboards.​
• Implemented end-to-end Marketing → Sales analytics to track conversions, funnel
performance, and ROI.​
• Developed KPI dashboards enabling data-driven marketing budget allocation and sales
performance monitoring.​
• Introduced structured KPI frameworks improving business transparency and
decision-making.

Key Projects​
• Executive BI Dashboard - Power BI model combining sales, marketing, and finance metrics
(Revenue, Margin, CAC/LTV, Budget vs Actual).​
• Sales & Marketing Analytics - Funnel analytics (MQL→SQL→Closed), CAC/CPA,
ROAS/MER, sales cycle & rep performance.​
• Operations & Profitability Dashboard - Profitability by service/SKU, inventory turnover,
DOH, productivity and bottleneck analytics.

Tech Stack​
Power BI (Advanced DAX) - Power Query / ETL - SQL - API integrations - CRM analytics -
Google Sheets

Professional Experience
TurboWeb - BI Analyst / Head of Sales (Marketing agency) | 2023-2026​
• Built Power BI reporting system for Sales & Marketing​
• Consolidated CRM, Google Sheets, SQL and GA4 data into unified analytics model​
• Developed executive dashboards for KPI tracking and marketing budget decisions

Vema Kids - Head of Sales (Manufacturing) | 2020-2022​
• Built sales department (10 managers)​
• Implemented sales performance dashboards (B2B / B2C / B2G)

Mamamia Pizza - Business Development Director | 2018-2020​
• Operational analytics and delivery optimization​
• Reduced delivery time 1.5h → 45 min