Dryсleaning Bianca (TOP-1 drycleaning in Russia, Moscow). Revenue $17+ mln / year

INVELLECT (Drycleaning Bianca, Hohoro, Lifehacker, OmniTrade, Ibis Coffee and more). Revenue $50+ mln/year* analytics for the group of companies (for 4 companies)* automation, improvement and migration reports to Power BI for all companies (for example, sales funnel, finance: debt, retention, revenue, reports to the claims support team and more)* administration and configuration of Power BI Report Server, web gateway, access setup* notifications for business with key data in Telegram bot* optimisation and decomposition of reports in Power BI* setting up and maintaining Jira for the analytics team* working with 3-layer data warehouse (ODS, DDS, DataMart), 35 data sources and ~100 DAGs, with ~200 tables in DataMart

Integrated service for working with app stores. It includes tools for App Store Optimization, customer support automation, organic install increase, competitor research, app performance monitoring and analysisI started working at this company as a freelancer, gathering data for machine learning models. I undertook a major project automating presentations for the Customer Success team, integrating various product metrics and visualizations, and generating reports. Following that, I transitioned to full-time Data AnalyticsHere's a summary of my responsibilities and skills:* automation of reporting, dashboards, presentations, and alerts* analytical research and ad-hoc analysis for various teams* development and maintenance of the Data Vault 2.0 analytical warehouse (creating new entities, ETL processes)* leading large projects from requirements discussions to production* writing ETL processes and pipelines* financial reporting for company top management (CEO, Team Leads) and investors* independently setting task priorities* working with product metrics, analyzing app reviews, ratings, and semantics* supporting product reports, dashboards, and alerts* collaborating with teams ranging from HR to product, growth, and billing* SaaS revenue analyticsTech stack: Python, SQL, MySQL, PostgreSQL, BigQuery, Data Vault 2.0, MongoDB, Airflow, Git, ETL, Google API, Google Services, Salesforce, Tableau, English

Odoo ERP Solutions Implementation, integration, development, support* designing and developing applications for Odoo* developing new modules and conducting module testingTech stack: Python, SQL, PostgreSQL, Odoo, Unit-testing, Git

One of the top mobile gaming companies in the world. Our titles are played by 100 million people every month* practical experience within an analytics automation team* preparing data sources and developing data delivery pipelines* tasks involving Python for data transformation, validation, and quality assurance* continuous Integration/Continuous Delivery (CI/CD) practices* diploma project focused on deploying a cloud-based warehouse using AWS RedshiftTech stack: AWS, Python, SQL, CI/CD, Git, Hadoop, Impala, Hive