Alex Balgalv Email & Phone Number

Limassol, Cyprus

Cyprus

Kazakhstan

InDrive is 2nd most downloaded ride-hailing application and 4nd most downloaded travel application in 20231) Tableau - 5 dashboards created from scratch - 10 Dashboards refactored: performance tuning and business logic implementation - Fixed schedule errors, allowing business users to see fully refreshed dashboards 4 hours earlier than before2) Big Query - Managed cost reduction of our project. I was able to save 35% of query and storage monthly costs year over year - Introduced fundamental change to the large data storage process. As a result, reduced queried data volume by 400GB per day3) Event analytics, web - Conceptualized, validated, and implemented over 50 unique new events and parameters - Managed GTM container with more than 100 events and parameters - Optimized Google ads campaigns, reducing the cost per click by 11% through strategic metric adjustments4) Push notification data - Developed an ETL tool to ingest WhatsApp logs from our bot via the Twilio API. Using raw data from it, found a behavior pattern that later led to the optimization of a notification strategy, increasing contact rate by 1.5% in total - Conducted a comprehensive series of tests on Swrve push notifications, culminating in a 5.8% increase in push conversion rate5) Created end-to-end data mart with joined user data across backend, app and web - It allowed every analyst in our department to see the realistic customer flow of our users While using it, we saw an increase of 1% in contact rate due to fixes to missing data in web and app trackers6) Teamwork & education - Created an onboarding process for newcomers to our department. By keeping it simple and in one place, I was able to save around 20% of time needed for a full onboarding - Authored a comprehensive "Knowledge Base" within Confluence, comprising six articles in which colleagues are able to easily find all the technical details regarding our project

Moscow, Moscow City, Russia

Ozon.ru is top-5 CIS e-commerce project1) Losses prevention - Created dashboard that: a) assisted with tracking and identifying potential losses as well as making loss prevention task easier by highlighting potential problems and bottleneck cases b) provided KPI analysis for every member of loss prevention team c) using insights provided by dashboard, my was able to reduce total lost items stock by 12% - Created and maintained ETL process for storing loss-related data in secure and comprehensive format which allows to track every single lost item for entire company2) Courier analytics - Performance tuning for SQL and Python scripts - Created and wrapped Python reusable functions as Nexus/Artifactory modules - Created ETL pipeline using Airflow - Managed alert bots for Teams for pipeline/dashboards health status3) Teamwork & education - Wrote technical and business documentation - Interviewed potential candidates for Data Analyst position

Санкт-Петербург, Россия

One of the most well-known food delivery services in Saint-Petersburg1) Power BI - Gathered requirements for business from every business unit. Added 5 new dashboards to the reporting service and modified all of the existing ones based on collected requirements - Implemented new design for entire Power BI report base to standardize their output and help users better understand information they convey - Created main quality-of-life Power BI dashboard, which helped to evaluate current state of critical business functions across entire company - Implemented new design for entire Power BI report base to standardize their output and help users better understand information they convey2) Data analysis - Launched several Telegram bots which presented daily tracked progress of new brands and provided specific metrics for each of them - Integrated data from Yandex.Metrica into our pipeline - Created end-to-end data mart, connecting user data from google analytics with data from backend - Supported ad-goc analytics for all business functions from HR to Sales

Moscow, Moscow City, Russia

Online FMCG store startup by X5 Retail Group https://www.vprok.ru/1) Analyzed forecast quality for sales and supply, resulting in creation of a main quality-of-life dashboard2) Developed tool for B2B demand planning, allowing my colleagues to start B2B sales with +3% margin increase from original expectation3) Gathered business requirements, completed data analysis and prepared final reports in Power BI/Excel

Москва, Россия

Online FMCG store startup by X5 Retail Group https://www.vprok.ru/1) Supply planning for dark stores - Created demand planning model from scratch with high accuracy (~95% accuracy, goods availability), which has been used for 7 years and is a main tool for supply planning - Implemented supply chain operations specific to on-line business - Supplied operations team with Excel dashboards, which helped them maintain high inventory turnover (3 days across all items) and damaged goods reduction (below 0,5 %)2) Provided learning for supply chain team

Москва, Россия

X5 Group is Russia's largest food retailer1) Supply planning for logistic centers - Using Excel, SAP BW and JDA demand planner, maintained order accuracy rate at 97% for food (dry stock) category and 93% for Fresh (short shelf-life stock) category - Minimized inventory turnover: not moved in 30 days items lower than 1% - Supplied commercial department with accurate volume prediction for tender goods. Managed to increase prediction accuracy from 65% to 80% for tender goods2) Cultivating suppliers relationship - Communicated with 45 active suppliers - Participated in daily support of our suppliers, reducing incident rate from 5 per month to 1 per month (warehouse time slot management, fraudulent activity, delay management, unusual issues)