Reliance Trends Supply Chain Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Supply Chain Analyst in e-commerce, retail and D2C supports demand forecasting, inventory planning, replenishment and logistics coordination across warehouses and stores. On a typical day you pull sales and stock data, update forecast models, track fill rates and stockouts, and work with buying, operations and last-mile teams to keep fast-moving fashion and essentials available. The role is data-heavy and requires comfort with Excel, SQL and ERP tools.

Role and Retail Supply Chain Knowledge

1. 1

   Walk me through how a fashion SKU moves from a supplier to a Reliance Trends store or an e-commerce customer.

   Cover purchase order, inbound QC, DC or warehouse putaway, allocation to store or pick-pack-ship for online, and returns. Show awareness of lead times and inventory visibility.

2. 2

   What is the difference between push and pull replenishment in retail, and when would you use each?

   Explain push as forecast-driven allocation to stores and pull as demand-driven reorder. Give an example like seasonal festive stock versus fast-moving basics.

3. 3

   Which inventory KPIs matter most for a D2C apparel brand, and why?

   Mention sell-through, days of supply, fill rate, stockout percentage and markdown. Link each to cash flow and customer experience.

4. 4

   How does omnichannel retail change supply chain planning compared to pure store retail?

   Discuss ship-from-store, buy online pick up in store, unified inventory, and the need for real-time stock accuracy across channels.

Technical and Analytical Skills

1. 5

   How would you calculate a 4-week moving average forecast and use it for replenishment?

   Show the formula, explain smoothing, and mention adjusting for seasonality, promotions and new store openings.

2. 6

   Write a SQL query to find the top 5 SKUs with the highest stockout days in the last quarter.

   Use GROUP BY, SUM or COUNT on stockout flags, ORDER BY DESC, LIMIT 5. Explain joins to a product master if needed.

3. 7

   In Excel, how would you identify stores with inventory above 60 days of supply and sales below target?

   Mention pivot tables, conditional formatting, VLOOKUP or XLOOKUP, and creating a simple exception report for action.

4. 8

   How do you decide the safety stock level for a fast-moving vs slow-moving SKU?

   Link safety stock to demand variability, lead time variability and service level target. Slow movers need tighter control to avoid markdowns.

Practical Scenarios and Case Questions

1. 9

   A top-selling kurta set is out of stock online but available in 20 stores. What do you do?

   Propose checking store-level inventory accuracy, enabling ship-from-store or click-and-collect, and reallocating stock from low-selling stores. Mention customer communication.

2. 10

   During festive season, your DC is running at 95 percent capacity and dispatch delays are rising. How do you prioritise?

   Prioritise high-margin and high-velocity SKUs, use temporary space or 3PL, stagger inbound, and communicate revised timelines to stores and online customers.

3. 11

   You notice a 15 percent gap between system stock and physical stock in a warehouse. How do you investigate?

   Check cycle count process, returns handling, damage and theft, and receiving errors. Recommend root cause analysis and tighter scan discipline.

4. 12

   A new D2C brand wants to reduce last-mile cost without hurting delivery speed. What levers would you suggest?

   Discuss order batching, zone skipping, dark stores, courier mix, and incentivising customers for slightly longer delivery windows.

Behavioural and HR Questions

1. 13

   Tell me about a time you used data to solve a problem in a college project or internship.

   Use STAR format, quantify the impact, and highlight the tool used such as Excel, SQL or Python.

2. 14

   Retail supply chain often involves peak hours and weekend shifts. How do you handle that?

   Show flexibility, time management and willingness to learn. Give an example of handling pressure during exams or events.

3. 15

   Why do you want to work in supply chain for a large retail or e-commerce company rather than a manufacturing firm?

   Link to fast fashion cycles, omnichannel complexity, customer impact and data-driven decision making. Show you understand the sector.

4. 16

   Describe a time you disagreed with a teammate on a plan. How did you resolve it?

   Focus on listening, using data to evaluate options, and agreeing on a common goal. Avoid blaming the teammate.