← Back to list
Senior
Registration: 11.05.2023

Andrei Gusev

Portfolio

ALMUS

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

ALMUS

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

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.

Skills

Python
SQL
VBA
Google Analytics
Yandex
Adjust
Appsflyer
AWS
GCP
Databricks
DataStudio
Apache Superset
Tableau
Power BI
Excel
Looker
DataStudio
Apphud MS Windows
Microsoft SQL Server
VSC
GIT
Amplitude
RevenueCat
Funnel
Adapty
BigQuery
Google Analytics

Work experience

Team Lead Data Analyst
since 01.2021 - Till the present day |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.

Educational background

Economical Informatics, Business analyst (Bachelor’s Degree)
2009 - 2014
Belarusian State Economical University

Languages

EnglishUpper IntermediateBelarusianNativeRussianNative