MIS Specialist- Yelahanka Bangalore

3SC, an 12-year-old technology scale-up specializing in Supply Chain Analytics, is driven by innovation and a commitment to sustainability. With the backing of GEF Capital (Global Environment Fund), a global private equity leader in impact investment, 3SC operates across the globe, serving 75+ clients with a team of over 500 employees. Over the next five years, we're on an ambitious trajectory to digitally transform our operations using cutting-edge technologies such as IoT, virtual reality, RPA, blockchain, and neural networks. As we grow, we remain steadfast in our dedication to sustainability, seamlessly integrating eco conscious practices into our solutions to help shape a more environmentally responsible future for the industry.

http://www.3scsolution.com

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