Дмитрий Кошелев

Dmitriy Koshelev

Бизнес - администратор

The Systems Business Analyst

Я присоединился к British American Tobacco в 2020 году

I have been with British American Tobacco since 2020

2022.06 - current time

Account Planning Tool support

User support for system operation and reporting

· All requests are resolved on time (SLA)

· Attracted additional resources, organized meetings to solve the problem with the support team, set priorities, established communication with users

Testing and launching the new APT system

· Created a BRD for the Administration module

· Creating a manual for the new APT system

· Setting tasks for developers
· Control and verification of execution

2021.09 - 2022.06
Power BI reports creat and BO reports support

Trade KPI dashboard (TMR, CM, RM, TMD)
Contract Dashboard
Bonus KPI Dashboard

· Meetings were held to discuss the terms of reference and the logic of the bonus KPI
· Implemented guides on tasks and a report for TMR, CM, TMD
· Made instructions and mini-training for the Distribution Department to support the report

Join and Check tours check list

2020.11 - 2021.09

Intern at NWBU Activation Department

Working with agencies 1-2-1
Pop Up's sales analytics, preparation of monthly reports
Data collection and implementation of the Glo Tracker report

The Education

University degree

St. Petersburg State University of Commerce and Economics 2013

Professional development

Netology: BI Analyst 2021

Professional development

Stepik: SQL for Data Analysis 2022

Professional skills

Hard skills
I have experience in Power BI, Power Query, Excel, SQL, SAP BO

Soft skills
I like working in a team, responsibility, the desire to learn new things