Julia Averyanova Email & Phone Number

Moscow City, Russia

Responsibilities:• Creation and optimization of reporting systems;• Development of a regular reporting system for the sales department;• Implementation of best practices for working with BI reports;• Analysis of customer requirements;• Setting up algorithms for upload, data transformation, data quality checks.Achievements:• Optimized reporting in Power BI to increase the level of self-service, which reduced the number of incoming requests by 90%;• Automated data ETL with further development of price monitoring in Power BI to monitor the fulfillment of commitment by partners;• Updated the process of calculating bonuses for partners, which increased the accuracy of bonus calculations for sales department employees up to 100%.• Automated the process of loading assortment matrices using Python, which reduced the task execution time by 90%

Moscow, Moscow City, Russia

Responsibilities:• Reporting update;• Creation of presentations;• Control of assortment matrices;• Price monitoring.Achievements:• Created category management performance evaluation reports in Power BI, which accelerated the decision-making process to change the promotional strategy and assortment matrices;• Automated ad-hoc reporting in Excel using Power Query to ensure up-to-date Sell-In and Sell-Out information;• Automated price monitoring process using BeautifulSoup and Selenium Python libraries and created a single tool to meet the needs of finance, marketing and sales departments.

Moscow, Moscow City, Russia

• Automated the distribution report for the Sales director• Updated product cards on online storefronts through communication with national and regional customers

Master'S Degree, Management Consulting

Bachelor'S Degree, Marketing