Experience

AKRIKHIN

• Pharmaceutical Manufacturing
• 100 - 200 Employee

• Sales Planning and Marketing Manager

  • Oct 2021 - Present

  Leading the project for the implementation of the budget model in Optimacros (analogue Anaplan);Development of tools for the analysis of commercial and market indicators of the company and the pharmaceutical market (Excel, Power BI, SQL);Created 5 PBI dashboards for business units that allow to analyze their financial and market KPI's by channels, SKUs;Responsible for uploading financial data to external systems for consolidation at the group level (SQL);Financial analyst under direct supervision. Show less

• Financial Analyst

  • Oct 2020 - Oct 2021

  Preparation of commercial Brand P&L with granularity up to SKU (budget/actual/forecast);Developed the SQL script to automate the collection of the data from more than 5 sources (internal systems, Oracle, other SQL servers).Development of ad-hoc models (including econometric) for making managerial decisions;



GSK

• United Kingdom
• Pharmaceutical Manufacturing
• 700 & Above Employee

• BI Intern

  • Nov 2019 - Oct 2020

  Developed team site for the Commercial Excellence department on the platform MS SharePoint; Developed a SQL database for processing sales data from distributors; Created 5 dashboards for business units that allow to analyze sales by channels, SKUs and regions. Developed team site for the Commercial Excellence department on the platform MS SharePoint; Developed a SQL database for processing sales data from distributors; Created 5 dashboards for business units that allow to analyze sales by channels, SKUs and regions.



Plekhanov Russian University of Economics

• Russian Federation
• Higher Education
• 100 - 200 Employee

• Junior Technician

  • Jun 2018 - Oct 2019