Dmitry Gerashchenko Email and Phone Number

Development of a dashboard system for daily use by employees of all levels• Development of a reporting system in Tableau• Transferring dashboards from Tableau to Visiology• Writing ad-hoc queries to Postgres database• Writing SQL scripts to create data tables• Writing Python scripts to extract and transform data and load (ETL) into a database• Expanding the basic capabilities (visual and computational) of the BI system using Javascript, HTML and CSS

Managed the implementation, expansion and automation of end-to-end analytics for 18online stores. As a result, more than 60 people from different departments (marketing / sales /customer support / management, etc.) began to use dashboards daily.• implemented the Clickhouse + Yandex Datalens bundle, which made it possible to abandon K50:BI and Google Data Studio, as well as most of the manual reports• created dashboards with end-to-end analytics of marketing / sales / calls / e-mails, etc. As a result, managers and department leaders tracked key indicators daily• trained employees to use ready-made dashboards and create individual(by instructions, webinars), which significantly accelerated using of BI into the company as daily tool• developed Python + SQL scripts for uploading, processing and loading data in Clickhousefrom various sources (using api, webscraping, csv, google sheets, etc.).• filled DWH with data, as well as directories, increasing the speed of creating new onesdashboards.• built pipelines in Airflow to automate work with data, reducing the intervalupdate results up to 10-15 minutes.• created ad-hoc reports in the absence of ready-made dashboards, which speeded up decision makingby managers.• set up tags, events and goals through Google Analytics, Google Tag Manager (EnhancedEcommerce), Yandex Metrika for uploading new services, tracking and improving effectiveness of the site and advertising sources.• made recommendations for optimizing advertising campaigns for the marketing department. As a result, the cost of order has significantly decreased and the number of orders has increased.• led a group of 3 junior marketers.

Helped the marketing department (> 15 people) get rid of manual reports and daily data uploads (it took up to 30 hours per month) and switch first to Excel + VBA, and then to BI tools with end-to-end analytics for 13 online stores.• implemented end-to-end analytics through K50:BI• created dashboards in Google Data Studio and K50:BI on sales and efficiency of traffic sources• analyzed data in Google Analytics and Yandex.Metrica• set up tags, triggers, etc. in Google Tag Manager• prepared recommendations for optimizing advertising campaigns and sales• automated reporting using macros in VBA for the entire marketing department• wrote macros in VBA for ad analysis, ABC analysis, popular product combinations, query lemmatization, etc.• made media plans for sales, distribution of the budget for the performance by channels• launched and optimized contextual advertising for 5 stores, conducted A/B tests• trained junior marketers