Anastasiia Ogurtsova
Product Management
Netanya, Israel
Skills
Data Analysis
About
Anastasiia Ogurtsova's skills align with Sellers (Sales and Trading). Anastasiia also has skills associated with Insurance & Finance Managers (Insurance and Finance). Anastasiia Ogurtsova has 8 years of work experience, with 5 years of management experience, including a mid-level position.
View more
Work Experience
Data analyst
DOONA (Herzliya, Israel)
January 2023 - Present
- Responsibilities: 1) Make dashboards with BI analysis for the CEO and stakeholders 2) Keep updating huge databases (sell-in, sell-out, shipments, invoices) 3) Prepare monthly and yearly sales reports with the key points for the CEO 4) Request and collect sales and stock data of more than 40 distributors 5) Work with ERP system 6) Cross-functional collaboration with all departments (financial, marketing, logistics, production) for sharing useful data and finding business needs 7) Analyze data sales and stocks of distributors by giving them helpful feedback Achievement: Transfer the whole data that the company has from separate Google Sheets to one smart Looker dashboard that shows the whole Business picture on one page. The most useful tools: Looker Studio, ERP, Excel, Google Sheets, PowerPoint
Key account manager
Heineken
November 2017 - November 2022
- (Retailers: Okey, Billa, Auchan) Responsibilities: 1) Forecast of sales volumes 2) Monthly KPI: turnover, assortment matrix, forecast accuracy 3) Planning and tracking the annual budget 4) Quarterly analysis of sales results (Like-for-like, sell-in, sell-out) 5) Prepare an annual promo plan together with the marketing and trade marketing department 6) Cross-functional cooperation with all departments of the company (finance, trade marketing, field team, logistics, and planning department) 7) Leading in negotiations with buyers: contract conditions, rotation, listings, promo
Sales Specialist
L'Oreal
June 2014 - August 2016
- (Retailers: Lenta, Okey) Responsibilities: 1) Planning KPI for the field team and monitoring their implementation 2) Forecast of sales volumes 3) Monthly analysis of sales results (LFL, sell-in, sell-out) 4) Achieving monthly sales KPI: turnover, assortment 5) Planning of the annual promo plan and budget 6) Interaction with all departments of the company 7) Making orders for testers, displays (SAP) 8) Managing of make-up assortment as manager (make-up L'Oreal Paris, Maybelline) - rotation, listings
