Giya Mekh - Резюме Business Analytics

Acharuli Indauri LLC / MIT Product LLC, Tbilisi CEO / FP&A & Operational Analytics | 2021–2025 | • Led full-cycle industrial project for heavy-breed turkey production; defined product line, operations, and market strategy • Developed management analytics systems for finance, sales, production, and logistics; created KPI dashboards for executive decision-making • Built financial models, budgets, and scenario planning tools; reduced production shortfalls and improved capacity planning • Optimized processes and automated feeding, watering, and climate-control systems, reducing labor and downtime • Managed product certification: ISO 9001:2015, HACCP; coordinated cross-functional teams including production, QC, and supply chain 🔗 Website | 🔗 GitHub Aztransles / West Nord Export CEO / Financial & Operational Analytics | 2014–2019 • Analyzed financial and logistics metrics; optimized routes and reduced costs by 20–30% • Developed KPI and management reporting systems for export operations • Controlled P&L and improved operational efficiency through data-driven decision-making Specialized Transport Company / Interbaltic CEO / Lead Logistics Analyst | 2010–2015 • Modeled transportation flows, monitored receivables/payables, optimized supply chains • Built KPI and analytics systems to improve performance and reporting Russian Railways Deputy Station Manager, Commercial Operations | 2002–2008 • Analyzed cargo flows, tariffs, and train compositions • Monitored team performance and operational reporting

• St. Petersburg State Transport University — Economics & Management, 2002 • Yandex Practicum — Data Analyst, 2025 | Final Project: Sales Analysis and KPI Dashboards (Power BI / Yandex DataLens)

Core Skills Technical: PostgreSQL, SQL, Excel (Advanced), Power BI, Yandex DataLens FP&A / Finance: Forecasting, Budgeting, Scenario Modeling, Variance Analysis, Unit Economics, Financial Modeling Analytics & Data: Dashboard Creation, Cohort & Funnel Analysis, ETL Basics, KPI Development Soft Skills: Stakeholder Management, Team Leadership, Operational Management, Project Management

-

Selected Projects / Portfolio
Acharuli Indauri Startup — Full launch of industrial turkey project; created KPI dashboards and analytics → improved operational efficiency by 25%
🔗 Website | 🔗 GitHub
Sales Analysis and KPIs for Yandex Afisha — DataLens dashboard to track ticket sales and promo campaigns → improved budget planning and ad targeting
🔗 [Dashboard]
Key Business Metrics in Saransk (May–June 2021) — Dashboard monitoring real estate market; data collection, cleaning, visualization → supported strategic decisions
🔗 [Dashboard]
Dashboard for a Real Estate Agency — Performance analysis of sales & marketing → optimized departmental KPIs
🔗 [Dashboard]