Demand Planner
Procter & Gamble
مجموع سنوات الخبرة :10 years, 2 أشهر
Manage the short, mid and long term forecasts of the brands.
Receive and consolidate market level forecast on cluster level and provide data to BOP Planners.
Forecast management with sales and marketing team to agree on 12 months SKU wise shipment forecast
Track orders received vs. forecast from distributors (SIS) so to ensure the right mix is received.
Review and update the monthly forecast as per the current sales trend and inputs from Sales, Marketing and Product Managers
Coordinating with Product Managers regarding phase in, phase out of products and planning smooth transition of the SKU life cycle.
Developing GDM templates/models for comparison of sales/forecast at brand, segment, initiative, and Cluster FPC level.
Act as a primary point of contact for business questions related to European region
Work alongside merchandising, Finance, credit, Accounts Payables, Invoicing and other relevant teams to ensure accuracy and timely execution of all requests received for the creation and maintenance of master data through a formal process.
Understand and Communicate master data updates(e.g. maintenance, introduction of new fields, modification in attribute definition) that impact downstream systems/teams
Material Code Creation, Extension, Updating, Deletion, Reactivation.
Recipe/Bill of Material (BOM) Creation & Changes, Purchase Info Record(PIR)
Conduct root cause analysis of data quality issues and develop new processes to prevent future data quality issues; including taking necessary corrective action
Triggering assortment in SAP and mapping assortment to Site’s.
Creation/Modification of On-Trade -Direct/Indirect & Off-Trade -Direct/Indirect customers
Processing and reviewing Sales force tickets on daily basis like BOR’s, ACR’s assigning the same to the respective Territories management. (M1’s)
Hierarchy Creations/Modifications on SAP.
Preparing and sharing the ADOPT/MDQT/KPI Reports per country to clients on monthly basis
Preparing MIS reports on daily, weekly and monthly basis of created and modified item codes.
Special projects(e.g. listing of new item codes/ vendors/customers and unblocking the suspended)
Working as part of Automation team by providing the required parameters to automate the current process.
Involved in handling individual projects which are critical to business and help in achieving yearly targets.
Ad-hoc data cleansing as required ensuring data quality is upheld on an ongoing basis.
Maintaining the Metrics Tracker to track the daily workflow & management reporting on metrics.
Working as a part of team, ensuring SLA’s (Service level Agreement) all relevant regulations are met.
Material master creation and maintenance if generic and structured articles.
Vendor Master Creation and Maintenance.
Assigning of Storage Locations, Profit centers and Valuation Classes for the materials.
Creation of Merchandise Categories and assigning to Hierarchies
Creation of Assortment Modules and assigning them to Assortments.
Assortment and Merchandise Planning.
Vendor Mapping
Resolving customer issues in the areas of Master Data, Pricing and Sales Processes.
Carried out unit testing (UAT) Integration Testing for the rollout Projects and various business scenarios of purchasing and sales processes.
New Store Configuration (Site Master).
Material Extensions to customers.
Bar code report generation
Purchasing Info Record Creation and Maintenance.
Material Extensions to various plants as per the requirements.
Resolving customer issues in the areas of Master Data, Pricing and Sales Processes.
Mapping Business requirements in SAP for customers.
Producing Internal and External Sales reports
Producing Global/Polaris master data reports
Purchase order Creation and processing
Blocking and unblocking of materials.
Extensively worked on data migration tools such as LSMW.
Periodical checking of data quality and generation of reports from SAP and reporting.
Configuration of Promotions and various schemes for different business scenarios.
Free Goods Determination for the Articles.
Working with departments such as Merchandising, Sales, Operations, Finance for daily business needs.
Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulation
Gathering of business requirement for the planning process and study the scope of implementation.
Responsible for Master data maintenance, scheduling, planning, trouble-shooting
for end to end MDM process. Complete Master data creation and maintenance which I Involves Article Master, Vendor Master, Purchase Info Records and Source List.
Promotion Management involving Creation, change and Store Co-ordination
Well conversant in the field of purchasing and inventory management.
MDM system Integration end to end
Identification of opportunities to improve data quality & reduce cycle time.
Responsible for training/mentoring new hires.
Supporting sales department from Inquiry/receipt of the order till the delivery.
Analyzing the customer demands, order fulfillment, enhancing the quality of the orders.
Coordinate, conduct, document and process orders using GII, ORL tools.
Process accurate orders maintaining all contractual and compliance requirements.
Creating Purchase orders (PO) as per the Customer requirements i.e. quantity, configuration, billing, shipping confirmations, shipping Instructions etc.
Quote processing, Preparing Pro-forma invoice (PI) and tax invoice.
Sending Proposals, order processing and Payment follow ups.
Prepare GRN according to the Supplier’s Invoice
Ensure a timely feedback to the customer/affiliate, acknowledging receipt of order and any data that may be missing to ensure successful order completion, processing and shipment.
Interacting with sales, finance customer care and production team for stakeholder’s approvals and ensure the order released to production at minimum customer interaction and keeping Customer Experience at high standards.
Coordinating with Inside Sales and Technical Sales for right Configuration.
Achieve the revenue targets for assigned accounts
Collect, enter and validate orders into Order Management System.
Statutory checks with regards to Taxation, Duties, Octroi, and Road Permits/Declaration letters, Procurement certificate document for exemption of duties
Ensure that all orders are processed and delivered to customer site within lead times as per customer specification
Prepare Shipping Instructions like CIF(Cost Insurance Freight) and Ex-works
Review of process orders for quality
Preparing Delivery Note and Invoice
Maintaining the queue within the SLA.
|Distinction