Pantaloons Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail, or D2C ensures products move efficiently from suppliers to customers by analysing demand, inventory, and logistics data. Day to day, they track stock levels, forecast demand, coordinate with warehouse and transport teams, and use tools like Excel or SQL to solve problems such as stockouts or excess inventory. At a company like Pantaloons, this role supports omnichannel retail by balancing store and online fulfilment.

Role and Technical Knowledge

1. 1

   What is the difference between demand forecasting and demand planning in a retail context?

   Explain that forecasting predicts future demand using historical data, while planning decides how to meet that demand through inventory, sourcing, and logistics. Mention that planning includes adjustments for promotions or seasonality.

2. 2

   How would you calculate and improve inventory turnover for a fast-moving fashion category?

   Define inventory turnover as COGS divided by average inventory. Suggest improving it by reducing lead times, optimising reorder points, and clearing slow movers through markdowns or transfers.

3. 3

   What are OTIF and fill rate, and why do they matter in e-commerce?

   OTIF means On Time In Full, measuring delivery reliability. Fill rate is the percentage of customer orders shipped complete. Both directly affect customer satisfaction and repeat purchases.

4. 4

   Explain the bullwhip effect and how a D2C brand can reduce it.

   Describe how small demand changes amplify up the supply chain. Suggest sharing POS data with suppliers, using smaller batch sizes, and improving forecast accuracy through collaboration.

Practical Scenarios

1. 5

   A top-selling apparel item is out of stock online but available in some stores. How would you resolve this?

   Propose enabling ship-from-store or click-and-collect, updating inventory visibility in real time, and analysing why online stock ran out to adjust safety stock.

2. 6

   During a festive sale, you expect a 300 percent spike in orders. How do you prepare the supply chain?

   Cover demand forecasting with historical sale data, pre-positioning inventory in fulfilment centres, arranging temporary staff, and setting up contingency transport plans.

3. 7

   You notice that a particular warehouse has high shipping costs but low order volume. What steps would you take?

   Analyse cost per order, check if the warehouse is in the wrong location, consider consolidating with a nearby hub, and negotiate better carrier rates or use zone skipping.

4. 8

   A supplier consistently delivers late, causing stockouts. How would you handle this?

   Discuss setting up a vendor scorecard, imposing penalties or incentives, finding alternate suppliers, and increasing safety stock temporarily while improving the supplier's performance.

Behavioural and Situational

1. 9

   Tell me about a time you used data to solve a problem. What was the outcome?

   Use the STAR method. Focus on how you identified the issue, analysed data (even from a college project), and achieved a measurable result like reduced cost or improved efficiency.

2. 10

   Describe a situation where you had to work under a tight deadline. How did you manage?

   Highlight prioritisation, communication with teammates, and staying calm. Mention any tools or methods you used to track tasks and meet the deadline.

3. 11

   Give an example of a time you disagreed with a team member. How did you resolve it?

   Show that you listen, present data or logic, and aim for a win-win solution. Avoid blaming others and emphasise the final positive outcome.

4. 12

   How do you handle repetitive tasks while maintaining accuracy?

   Talk about creating checklists, using automation in Excel, taking short breaks, and double-checking critical numbers. Relate it to supply chain work like daily stock reports.

HR and Company Fit

1. 13

   Why do you want to work as a Supply Chain Analyst in retail or e-commerce?

   Connect your interest in problem-solving and data to the fast-paced, customer-focused nature of retail. Mention how supply chain decisions directly impact product availability and customer experience.

2. 14

   What do you know about Pantaloons' supply chain or retail operations?

   Research Pantaloons' parent company, store network, and online presence. Talk about how they manage inventory across stores and online, and how a supply chain analyst could contribute.

3. 15

   Where do you see yourself in three years in this role?

   Show ambition to grow into a senior analyst or supply chain manager role, and mention gaining expertise in forecasting, analytics, and end-to-end planning.

4. 16

   Are you comfortable working with large datasets and learning new software?

   Say yes and give an example of a tool you learned quickly, such as Excel, SQL, or a college project tool. Emphasise your willingness to undergo training.