Andrei Gusev

← В ленту

Регистрация: 11.05.2023

Специализация: Data Analyst

AWS google analytics Python SQL VBA

Портфолио

ALMUS

• Formed an analytics department. • UA KPI Planning. • SKAD Analysis. • Resource planning. • Team development.

EPAM

• Extensive data manipulation and analysis (MS Excel, SQL, Power BI). • Processing large amounts of data including facts, figures, and number crunching. • Data entry and auditing. • Compiling and organizing data from different Data Sources. • Ensuring data accuracy and data integrity. • Identifying trends and patterns of information. • Data reporting, data visualization creation. • Applying statistical techniques and translating the results into information required by stakeholders. • Communication with stakeholders on defining requirements to report and change managment.

ALMUS

• Built a BI system from scratch. • Implemented an LTV models. • A/B Testing. • Implemented the model of SKAD traffic.

Скиллы

Adapty

Adjust

Amplitude

Apache Superset

Apphud MS Windows

Appsflyer

AWS

BigQuery

Databricks

DataStudio

Excel

Funnel

GCP

GIT

Google Analytics

Looker

Microsoft SQL Server

Power BI

Python

RevenueCat

SQL

Tableau

VBA

VSC

Yandex

Опыт работы

Team Lead Data Analyst

с 01.2021 - По настоящий момент |NDA

Python, BigQuery, SQL, Amplitude analytics

• Built a BI system from scratch. • Implemented an LTV models. • A/B Testing. • Implemented the model of SKAD traffic. • Formed an analytics department. • UA KPI Planning. • SKAD Analysis. • Resource planning. • Team development.

Lead Data Analyst

12.2019 - 12.2020 |EPAM

Microsoft SQL Server, SQL, Power BI, Google Analytics, BigQuery

Lead Data Analyst of Workforce and People Management department. • Extensive data manipulation and analysis (MS Excel, SQL, Power BI). • Processing large amounts of data including facts, figures, and number crunching. • Data entry and auditing. • Compiling and organizing data from different Data Sources. • Ensuring data accuracy and data integrity. • Identifying trends and patterns of information. • Data reporting, data visualization creation. • Applying statistical techniques and translating the results into information required by stakeholders. • Communication with stakeholders on defining requirements to report and change managment.

Data Analyst

07.2019 - 12.2019 |PAX (I-Develop Technologies.)

HTML, Python

• HTML parsing with Python (regex, BeautifulSoup, request,API). • Working on ML model for text translation. • Elasticsearch.

Data Analyst

01.2018 - 07.2019 |GameStram, Wargaming

Data analytics, Marketing analytics, Product analysis

• Analysis of monetization events. • Data Visualization. • Calculation of the effects of marketing activities. • A/B Testing.

Lead Sales Analyst

12.2015 - 12.2017 |Group of Companies “Armtek” (Auto Components)

Data Visualization, CRM

• General analytics of sales and marketing. • Analysis and problem identification. • Data Visualization. • Calculation of market capacity. • KPI Planning • Clients segmentation • Customer relationship programs • Preparation of commercial proposals • ETP optimization (electronic trading platform) • Communication with all departments • Participation in the implementation of SAP CRM. • coordination and motivation of sales team.

Образование

Economical Informatics, Business analyst (Бакалавр)

2009 - 2014

Belarusian State Economical University

Дополнительное образование

Data Camp – Data Science Track

Special Trainings / Courses

Python Programming

Special Trainings / Courses

Business Statistics Course

Special Trainings / Courses

Courses of MS Excel and Data Mining

Special Trainings / Courses

Языки

АнглийскийВыше среднегоБелорусскийРоднойРусскийРодной