Senior Executive

Role & responsibilities:

• Prepare and maintain the

  Order Allocation Summary

  to support optimal allocation decisions.
• Create and update

  Inventory Aging reports

  to track stock ageing and identify slow-moving items.
• Develop

  Free Inventory Files

  for visibility of unallocated stocks for business teams.
• Generate

  Distributor Order Visibility Reports

  to enhance order planning and fulfilment efficiency.
• Prepare and share

  inputs for Stock Summary reports

  to relevant stakeholders.
• Create

  input files

  required for running tools that optimize order allocation.
• Consolidate and prepare

  Stocks and Sales Performance Reports

  at SKU, category, and distributor levels.
• Develop

  Forecast Accuracy Reports

  , comparing actuals vs forecast to improve demand planning.
• Prepare and maintain

  Cross Sourcing Matrices

  to support sourcing flexibility and allocation decisions.

Required Skills & Qualifications:

• Graduate/Postgraduate in Commerce, Science, Statistics, Engineering, or related disciplines.

• 2-4 years of experience

  in reporting, MIS, or data analysis roles, preferably in supply chain, sales operations, or commercial functions.

• Advanced Excel skills

  including pivot tables, complex formulas, lookups, data validation, conditional formatting, and dashboarding.
• Experience in

  creating structured reports

  with accuracy and timeliness.
• Strong understanding of inventory management concepts is preferred.
• Ability to handle large datasets efficiently and perform data consolidation from multiple sources.
• Excellent attention to detail, problem-solving attitude, and logical thinking.
• Good communication skills to coordinate inputs and explain reports to stakeholders.

• Preferred Skills:

• Exposure to

  Power Query, Power Pivot, VBA Macros, or Power BI

  for automation and visual reporting.
• Experience in supply chain analytics, inventory optimization, or order allocation processes.

Office Location - Yelahanka, Bangalore