BI Architect | Marketplace & CFO Analytics
I design version-controlled marketplace analytics systems
from raw data (TDP layer) to CFO-ready consolidated reporting (T+3 → T+7 freeze).
Specialization: Power BI semantic modeling, unit economics, advertising efficiency, multi-cabinet consolidation.
TDP → Executive (T+3) → Snapshot Freeze (T+7) → CFO consolidation
Includes: PnL MASTER, Unit Economics MASTER, Ads Efficiency, Risk Matrix
https://github.com/AvseHorosho/Marketplace-MultiCab-BI-Case
Star-schema semantic model, time intelligence (MoM), drillthrough, financial validation, data reconstruction under connectivity loss
financial validation and data reconstruction under connectivity loss
https://github.com/AvseHorosho/PowerBI-WB-Analytics
- Power BI (Power Query, DAX, semantic modeling)
- Version-controlled reporting architecture (TDP → CFO layer)
- Multi-marketplace consolidation (WB / OZON / YM)
- Unit economics & profitability modeling
- Advertising efficiency analysis (ROMI / DRR / break-even)
- Time intelligence (MoM / deltas / leader ranking)
- Data validation & reconciliation (checkpoint-based control)
- Governance & freeze logic (T+3 / T+7)
All cases follow strict snapshot governance, CSV evidence layer and version control principles.
Results:
• Consolidated 3 marketplaces into CFO-ready PnL
• Identified capital reallocation priorities
• Designed reproducible snapshot governance model
Author: AvseHorosho
GitHub: https://github.com/AvseHorosho