Працювала в 6 компаніях   15 років 9 місяців

АПК (Агропромисловий комплекс), Консалтинг / Аудит

Senior Demand Planner

Сингента/Syngenta

АПК (Агропромисловий комплекс)

2 роки 1 місяць

12.2023 - до теперішнього часу

- Maintain planning and forecasting process in-line with existing S&OP cycle, preparing and conducting meetings following the corporate planning cycle.

- Ensuring the balance between market demand, sales plan, and supply plan to improve sales forecast accuracy rate.

- Connecting interdepartmental information and data to drive informed business decisions (sales effectiveness analysis, risk for demand & supply imbalances, etc.), support data-driven approaches by providing clear data exchange between departments (Sales, Marketing, Finance). Development of automated reporting in Power BI

- Improving planning processes to enhance forecast accuracy and implementing forecast accuracy evaluation in the S&OP process.

-Deputy Planning Group Leader Responsibilities

Demand Planning Manager

Сингента/Syngenta

АПК (Агропромисловий комплекс)

4 роки

01.2020 - 12.2023

- Preparing and leading monthly Demand Review Meetings - compile and analyze essential data for sales forecasting, including demand analysis, availability assessments, and risk evaluations. Coordinate cross-functional inputs to create an accurate and actionable consolidated sales forecast.

- Development and preparation of analytical reports, ensuring transparent and data-driven business decisions throughout the S&OP process.

- Performing IBP process on a monthly basis: forecast submissions, master data maintenance, forecasting and price update

- Tracking the Allocation process, communicating changes, and aligning substitutions with the Commercial Team.

- Seed availability tracking, communicating changes in availability, and coordinating seed distribution process to customers. Monitoring batch quality characteristics on stock and in delivery, informing Commercial Team & Customer Service to ensure proper distribution between CustomersParticipated in the improvement of seed availability calculation by implementing automated data processing using Power Query, resulting in an over 50% reduction in report generation time for deliveries and increased time for delivery schedule verification. As a result, we obtained more accurate data on seed availability, which positively impacted the precision of sales forecasts and provided opportunities to inform about the status of deliveries and seed quality indicators in advance.

- Preparing seasonal/monthly sales plans and Specifications for Customers (Distributors, AGHs, direct Customers) based on Demand level and Supply plan data and performing checks of its execution. As part of the planning team participated in the development of the Distributor's Portal (requirements gathering, logic development, and testing), resulting in improved responsiveness to demand changes, reduced communication with customer service, and real-time visibility of all changes in the plan for online clients.

Deputy Head of Business-Projects Division

APK-Inform

Консалтинг / Аудит

1 рік 6 місяців

01.2018 - 06.2019

  • coordination and management of the department, distribution of tasks and monitoring their implementation
  • training and adaptation of new employees
  • gathering of requirements for researches, coordination of the timing and format of the report
  • processing of large data set, creating reports and data visualization

Coordinator of the project "Survey of the market of plant protection products"

APK-Inform

Консалтинг / Аудит

3 роки 11 місяців

02.2015 - 12.2018

  • preparation of all necessary documentation for the conduct of the survey (questionnaire, sampling, the timing of data collection)
  • coordination and management of the team - distribution of tasks and monitoring their implementation
  • quality control of collected information
  • analysis of research results, interpretation and preparation of reports

Participation in the development of software products (for input/output of survey results, and a database for storing and processing statistical data):

  • compilation of documentation (description of requirements, specifications, and features of the software product)
  • software testing
  • training for employees on the use of software products

Editor of the statistical publication "APK-Stat"

APK-Inform

Консалтинг / Аудит

3 роки

02.2010 - 01.2013

  • preparation of reports and statistics for publication (developing formats and publication release dates)
  • writing statistical news to advertise the publication

Assistant of analyst (2007-2010)

APK-Inform

Консалтинг / Аудит

2 роки 4 місяці

10.2007 - 01.2010

  • monitoring, consolidation and analysis of the information from different sources
  • maintenance of databases
  • preparation of statistical reports

Ключова інформація

Confident user of MS Office - Power Point, MS Word, MS Excel (formulas, pivot tables, data visualization - dynamic tables and charts, VBA - basic level).

Data visualization: infographics design, creating dashboards, charts, and tables for company products (website, magazine, conferences)

Knowledge of the basics of statistical data analysis - data collection and processing, sampling (sampling, questionnaire design, report preparation), creating reports/surveys for customer request (from requirements collection to presentation of results). Preparation of forecasts/estimation for the main grain market indexes. Organization and conducting of marketing researches for Ukrainian companies and international organizations (IFC, EBRD, FAO)

Understanding the principlesof software development and testing, compilation of checklists, using Mantis, TestLink, Trello. Experience in testing of the program for processing/aggregation of statistical data created for APK-inform and preparation of requirements for the program for input data of survey results (compiling a list of checks to reduce the level of input errors by operators), product testing (error reporting)

Basic knowledge: - SPSS, Power BI, Google data studio, SQL, VBA, Google Analytics, HTML, CSS, BABOOK.

Навчалась в 1 закладі

Dnipropetrovsk National University

Economics faculty, specialization – applied statistics

Днепр, 2007

Володіє мовами

Англійська

вище середнього

Російська

рідна

Українська

рідна

Курси, тренінги, сертифікати

- Udemy – Series of courses on working with MS Excel by Leila Gharani

on-line, 2018

Advanced Excel, Excel Charts and Visually Effective Excel Dashboards

- OWOX Analytics School – Google Analytics Basic Course

Днепр, 2018

Lviv IT School - Basics of Web UI development

(on-line course from Prometheus), 2017

QATestLab - Basics of Software Testing

on-line, 2017

Oratory courses (basic and advanced course).

Днепр, 2016

Seminars on the preparation and interpretation of data from the State Statistics Service of Ukraine

Киев, 2008

Додаткова інформація

Личные качества

I have a great experience as an analyst - preparing reports, conducting research (for both Ukrainian and international companies and organizations), preparing presentations and giving a presentation at events. Also, I have experience in the development of software products for internal purposes of the company (writing requirements and testing). I interesting in data visualization - prepare infographics and develop new ways to display trends in data. I am a good team player but it doesn't mean that I can not work independently.

Julia

Analyst, Demand & Supply Planner, Project Manager (market research)

Київ

40 років

Працює, але відкритий для пропозицій

повна зайнятість

Характер роботи: гібридна

Оновлено 3 дні тому