SteppeChange

Responsibilities:
- EDA, spatial EDA, data modeling, metrics dev, data QA, spatial data visualisation, statistical analysis, ML, geospatial experiments.

Spatial Data Analyst, Data Engineer

CoffeeHouse

Consulting and assisting in setting up app Analytics, A/B testing and Recommendation system.

Technological stack: Mixpanel, Amazon AWS, PostgreSQL, dbt, AVO, Python.

Product Analyst

Delve into A/B testing, Statistics, Amazon AWS, dbt, recommendation systems.

Courses:
- Mobile Games AB Testing with Cookie Cats (DataCamp)
- Level Difficulty in Candy Crush Saga (DataCamp)
- Introduction to Hypothesis Testing (DataCamp)
- Customer Analytics and A/B Testing in Python (DataCamp)
- Analyzing Marketing Campaigns with pandas (DataCamp)
- AB Testing in R (DataCamp)
- Fundamentals of Bayesian Data Analysis in R (DataCamp)
- Hypothesis Testing in R (DataCamp)
- Introduction to Statistics in R (DataCamp)
- Sampling in R (DataCamp)
- dbt Fundamentals (dbt)

Books:
- "Trustworthy Online Experiments". Ron Kohavi
- "Statistical Methodes in Online A/B Testing". Georgi Georgiev
- "Игра в цифры. Как аналитика позволяет видеоиграм жить лучше", Василий Сабиров

Professional Development

JatApp

Product - multi platform VPN server (web, chrome/edge/firefox extension, iOS, android, windows, linux, apple TV, amazon TV, Playstation, Xbox). 
The main request from the company: find out the cause of the chaos in analytic processes and setup cross platform analytics.
Finished cooperation due to the impossibility of productive communication with the product owner.

What has been done for the company:
- analyzed interior analytical processes and found the cause of chaos - the product owner;
- composed technical task for cross platform analytic system; 
- explicitly demonstrated pros/cons of the custom analytic system to managerial stuff;
- planned DB architecture of custom analytic system on the base of Clickhouse;
- setup analytics for chrome/edge extensions (Google Measurement Protocol);
- setup analytics for the web, including acquisition and remarketing campaigns monitoring (GA4, UA);
- calculated business metrics in Tableau and built reports (MySQL, ClickHouse);
- setup A/B test environment for the web, setup validation (Google Optimize);
- planned cross-platform analytic system for the product on China market (Amplitude, Appsflyer).

Technological stack: GA4, MySQL, ClickHouse, GTM, Tableau, Amplitude, AppsFlyer, Google Optimize.

Senior Product Analyst

Maxine-betting company

Product - web and app (iOS, android) for sports betting.
The main request from the head of the marketing department - figure out the reason for the incorrect collection of conversions, as well as provide tools for evaluating effectiveness of the users acquisition and remarketing activities.

What has been done for the company:
- built an end-to-end analytic system from scratch on the stack GA4 (Firebase), BigQuery, Owox, PowerBI for marketing channels effectiveness analysis;
- planned BigQuery architecture, automation setup, request cost optimization;
- built events map for the web (desktop, mobile), applications (iOS, Android): conversion events, events for funnels analysis (registration, verification, deposites), UX events;
- setup event tracking (web, applications);
- setup tools for funnels analysis: registration, verification, deposites (DataStudio);
- calculated product metrics (Power BI + DAX);
- dashboards for cohort analysis by day/traffic source (Power BI);
- dashboards for users segmentation (multiple criterias) + interactive tools for user ids export (Power BI);
- created business performance reports, reports on the effectiveness of traffic channels, other on-demand reports (bonuses effectiveness, etc.) (Power BI).

Technological stack: GA4, Firebase, Google BigQuery, MySQL, Power BI (DAX), Google Data Studio, GTM, Owox, Appsflyer, R.

Product Analyst, Marketing Analyst

IM Action

IM Action (now - Ramp IQ) - internet marketing agency, operating on the international market (US, Europe, CIS countries).

Responsibilities:
- analytic tools installation and configuration: Google Tag Manager, Google Analytics, Google Search Console, Yandex Metrika, Hotjar, Call Tracking, pixels of advertising systems;
- Google Analytics setting up: events, goals, filters, segments, custom metrics, importing data from third-party systems manually and by means of Owox, custom reports, cross-domain tracking, multi-domain projects;
- web analytics: research for the reasons in the abnormal metrics behavior, answers to the questions of the client's managerial staff, SEO and PPC departments, ;
- setting up event tracking in Google Tag Manager;
- building reports (SEO, Ads, Pacing) in Data Studio, Power BI, Google Sheets (including uploading via API): automated monthly and weekly performance reports, pacing predictive reports;
- building dashboards for SEO and PPC departments for analysis of backlinks, keywords, advertising campaigns, comparative competitors analysis (Power BI + Ahrefs / Semrush + Google Sheets);
- data synchronization with CRM, search for the reasons of data discrepancies between systems;
- advertising campaigns performance analysis;
- experiments on uploading data from advertising systems (Facebook Ads, Google Ads) via API, visualization, analysis, building simple predictive models (R, Power BI + R).

Technological stack: GA4, GA3, Google Sheets, Google Data Studio, GTM, Google Ads, Facebook Ads, Power BI, Ahrefs, Semrush, Owox, R.

Web Analyst, Business Analyst

Digging into Data Analytics / Science.

Courses:
- Business Intelligence (Epam)
- Практика создания аналитических панелей в среде Power BI (Coursera)
- Data Science Specialization (Coursera)
- In-depth Introduction to Machine Learning (Stanford University)
- Tableau 9 For Data Science (Udemy, Tableau eLearning)
- Mathematics for Data Science (Coursera)
- Neural Networks and Deep Learning (Coursera)
- Version Control with Git (Coursera)
- Погружение в Python (Coursera, МФТИ)
- SQL for Data Science (Coursera)
- Inferential Statistical Analysis with Python (Coursera)

Books:
- "R programing for Data Science", Roger Peng
- "R for Data Science", H.Wickham G.Grolemund
- "An Introduction to Statistical Learning", by Gareth James, Daniela Witten, Trevor Hastie and Rob Tibshirani

Technological Stack: R, Python, SQL, Power BI, Tableau, Google Data Studio, Google Sheets, Git, Google Analytics, Google Tag Manager.

PROmusculus.ru

PROmusculus.ru is a personal web-project about nutrition in sport, fat-loss and health from the point of view of science. I started it on my own in order to practice principles of web-development, internet marketing and SEO i learned and at the same time get expertise in sport nutrition.

Web: https://promusculus.ru.

Responsible for:
- general resource structure
- usability
- SEO strategy (keywords analysis, content planning, technical optimization, link building)
- SEO-copywriting
- freelancers management
- html/css, wordpress plugins and templates customization
- monetizing 
- web analytics
- e-mail marketing

Founder

Self employed

Starting from 2014 i studied web development (html/css, Wordpress, a bit PHP, javascript) and SEO and took part in developing several projects.

1) promusculus.ru (Dec 2016 - now)
(See description above.)

2) city1850.com (Nov 2016 - Feb 2017)
My role - Web developer. 
city1850.com - creative travel project of my friend - professional street photographer.
Web: http://city1850.com. Instagram: @city1850.

Responsible for:
- general structure of the project, usability
- front-end
- deep software cutomization of template and plugins
- SEO optimization

3) meshtrip.com (Nov 2015 - May 2016)
MeshTrip.com is a vacation rental start-up. I was responsible mainly for SEO and simple mobile application development. 

Responsible for:
- Web analytics
- SEO optimization and strategy development 
- Blog launching and support
- iOS application development

Web-developer, SEO specialist

Entrydell

As Automation engineer i was responsible for:
- HVAC software development and launching on sites (Siemens HVAC control systems, Desigo Insight, Desigo Xworks Plus).

As a Medical Integration Engineer and Field service engineer i was responsible for: 
- Leading projects of medical engineering systems planning/design/installation/maintenance.
In the scope of my responsibility where integrated systems for operational rooms Karl Storz OR1 (archiving, telemedicine, control systems), access control systems for aseptic modules, nurse-patient communication systems, etc. 
Almost all projects were country wide level importance (President clinic, Regional children hospital, etc. See Projects section below).

Also i developed for my company web-site www.vi-rent.by. That was my first experience in web dev.

HVAC Software Developer (Siemens), Medical Integration Engineer

Hire me if you need to:
- plan analytics system architecture on your project (web, app);
- setup tracking and necessary analytics stack;
- understand how effective your marketing efforts are in users acquisition;
- setup environment for A/B testing and culture of A/B testing;
- improve your product with CRO activities;
- need a handy data-person able to solve any challenges and find answers to any questions.

Taplio

Andrei Kristov's Linkedin Analytics

Andrei Kristov

Want to drive more opportunities from LinkedIn?