Eternis Fine Chemicals: Procurement & Logistics Analytics Intern Prep

A specialty chemicals plant spends heavily on spares, contractors, capital equipment and freight, and procurement and logistics control all of that spend. At Eternis Fine Chemicals Ltd., the Procurement & Logistics Analytics Intern works on two business improvement projects. Both turn scattered purchase and shipment records into clear savings opportunities and a roadmap that management can act on.

This guide is for Engineering, Supply Chain and MBA students preparing for this summer internship. It covers what the two projects involve in plain terms, the skills interviewers test and how campus rounds usually run. It also includes 28 role-specific questions with answer approaches, the topics to master and a four-week preparation plan.

1. About the Procurement & Logistics Analytics Intern Role

This internship is built around projects, not support tasks. You own two pieces of analysis. The first cleans and standardises how the company buys materials and services. The second examines what it pays to move goods into and out of India and between its sites. Your output is a set of recommendations that decides where procurement and logistics effort goes next.

Day to day, you work with the people who raise purchase requests, the buyers who turn them into orders, and the teams that book freight and arrange local and waste transport. You also deal with suppliers and logistics partners when you benchmark quotes. Finally, you present your dashboards to management, who use them to approve or reject the changes you propose.


2. Required Skills and Qualifications

Educational Qualifications

Skills Overview


3. Day-to-Day Responsibilities

A typical week mixes desk-based data work with conversations across the plant and head office. Early weeks lean on extracting and cleaning records, and later weeks shift towards analysis, benchmarking and presenting recommendations.

1

Consolidate purchase records

Bring PR and PO data, material records and supplier records into one structured dataset. Spend splits into three buckets: Maintenance, Repair and Operations (MRO) items such as bearings and gaskets, Services such as calibration or housekeeping contracts, and Capital Expenditure (CAPEX) such as a new reactor or storage tank. Harmonising means one naming format, one unit and one category tree across all three.

2

Spot duplicates and overlaps

Look for the same item stored under several codes, such as "Bearing 6205 ZZ" and "BRG 6205-2Z" created by two different buyers. Do the same for suppliers registered twice under slightly different names, and for materials with specifications close enough to merge into one standard code. Each find cuts inventory clutter and gives buyers more combined volume to negotiate with.

3

Analyse spend and cycle time

Study where the money goes and how long buying takes. This means comparing prices paid for the same item across plants and quarters, spotting categories split across too many vendors and measuring the time from PR creation to PO release. If urgent spares requests take three weeks to become orders, that delay is a finding in its own right.

4

Build procurement dashboards

Turn the cleaned data into Power BI views that buyers and managers will actually open. Typical pages show spend by category and supplier, duplicate codes found, price variance across sites and PR-to-PO cycle time. A good dashboard lets a procurement head answer a specific question, such as which ten suppliers drive most MRO spend, in under a minute.

5

Draft the transformation roadmap

Rank every procurement opportunity by savings potential, effort and risk, then sequence it into a roadmap. Quick wins, such as merging duplicate supplier codes, come first. Bigger moves, such as rate contracts for high-volume spares or a simpler approval workflow, follow with owners and timelines. Every roadmap item should trace back to a number from your analysis.

6

Clean logistics spend data

Assemble 2-3 years of import and export shipment records together with local transport and waste transport bills. Expect invoices in different currencies, freight quoted per container in one file and per kilogram in another, and missing route details. Waste movements from a chemical plant often need their own category, because hazardous waste goes only to authorised disposal sites.

7

Benchmark freight and quotations

Compare supplier quotations, freight rates, routes and shipment modes against each other. For example, check whether imports through Nhava Sheva cost more than an alternative such as Mundra once inland haulage is added. Another check: whether a low-volume lane would be cheaper as Less than Container Load (LCL) than as a half-empty Full Container Load (FCL). Each gap becomes a negotiation point.

8

Map end-to-end flows

Draw how material physically moves: from a supplier abroad or in India, through a port or by road, into the plant, and out again as finished goods or waste. The map shows the handoffs where shipments wait, such as customs clearance or missing documents. It also shows where two separate transporters serve the same route. This map forms the backbone of integrated flow design.

9

Set logistics KPIs and dashboards

Choose a small set of KPIs that balance cost against service, and write down exactly how each one is calculated so every team gets the same answer. Then build management dashboards that track these KPIs over time and let leaders filter by mode, route and logistics partner. The aim is for a manager to see in one glance which lanes are drifting off target.

10

Build the improvement framework

Pull the logistics analysis into a framework that tells management where to act on cost, service and partnerships. That could mean consolidating local transporters, moving certain lanes to annual rate contracts or setting regular performance reviews with freight forwarders. Each recommendation should state the expected saving or service gain alongside the trade-off it involves.


4. Key Competencies for Success

Most shortlisted candidates know Excel and can name supply chain terms. Interns who stand out pair that with patience for imperfect data, a habit of expressing findings in rupees, and real curiosity about how a chemical plant runs.


5. Interview Process at Eternis Fine Chemicals Ltd.

Summer placement processes for manufacturing and specialty chemicals firms on IIM and IIT campuses are managed by the placement cell and run within a short window. Prepare for the rounds below, and confirm the exact sequence with your placement committee once the company shares its schedule.

1

CV Shortlisting

The placement cell forwards applications and the company screens them. Expect reviewers to look for an Engineering, Supply Chain or MBA background, evidence of Excel and Power BI work, and operations or analytics projects with measurable outcomes.

2

Group Discussion or Short Case Exercise

Some firms add a group discussion or a short written case to narrow a large shortlist. It tests structured thinking, clarity and how you build on other views. Treat it as possible rather than certain, and prepare an operations case structure just in case.

3

Functional and Technical Interview

Usually taken by procurement, logistics or supply chain managers. Expect questions on the purchasing cycle, spend analysis, freight basics, Excel and Power BI, plus a mini case close to the two projects. This round carries the most weight.

4

HR and Fit Interview

An HR representative or senior leader checks motivation, communication and readiness for a Pan India posting. Expect "Why this company?" and "Why procurement?" questions, and be ready to discuss working from a plant location.

5

Final Shortlist and Offer

Results and offers are communicated through the placement cell, often on the same day as the interviews. Keep your phone reachable and respond promptly to any follow-up call from the panel.

Many candidates list Excel and Power BI on their CV but cannot explain what decision a dashboard would support, or walk through how a purchase request becomes an order. In a role built entirely around procurement and logistics improvement projects, tool names without process understanding read as weak preparation. Be ready to explain both the data and the business behind it.

6. Interview Questions

Answer behavioural questions with the STAR method. For case questions, use a MECE (mutually exclusive, collectively exhaustive) structure that you state aloud before solving.

For technical questions, show calculations step by step and end with the business consequence. Panels for procurement and logistics analytics roles reward clear numbers and practical judgement over jargon.

Behavioral & Company-Fit Questions

Technical Questions: Procurement, Logistics and Tools

Case-Based & Analytical Questions


7. Topics and Areas of Focus

Each area below maps directly to one of the two projects and to what panels test in procurement and logistics analytics interviews.

For trade terms, study the Incoterms rules from the International Chamber of Commerce. For tools, use Microsoft Learn for official Excel and Power BI training.


8. Preparation Plan

Freshers: focus on conceptual depth and structured answer frameworks such as STAR and MECE, and build one small dashboard project to discuss. Candidates with work experience: prepare 3-5 impact stories with measurable outcomes, ideally from plant, sourcing or logistics work, because analytics panels probe for ownership and results rather than a list of responsibilities.
Week 1

Foundations

Company research and the purchasing cycle.

Week 2

Procurement Analytics

Hands-on cleaning, deduplication and spend cubes.

Week 3

Logistics and Stories

Freight maths plus STAR story writing.

Week 4

Mocks and Polish

Daily mocks and a dashboard you can present.

Pre-Interview Checklist


9. Career Growth & Next Roles

Interns who deliver a credible roadmap and dashboards that teams keep using make the strongest case for a pre-placement offer conversation. In specialty chemicals manufacturing, supply chain careers usually move from analysis into owning categories or logistics networks, and then into leading the function across plants.

Progress depends on savings that show up in the books, strong supplier relationships and reliability during disruptions, more than on tenure alone.

1

Procurement & Logistics Analytics Intern (Summer Internship)

You own two projects end to end: a cleaned procurement dataset with dashboards and a roadmap, and a logistics spend analysis with KPIs and an improvement framework. To move up, prove your numbers can be trusted, that plant and procurement teams found the work useful, and that your final presentation contains recommendations management can act on. A strong finish is the usual basis for any conversion discussion.

2

Category Manager or Logistics Manager (around 2-3 years after joining full time)

You own a spend category, such as MRO spares or engineering services, or a set of logistics lanes and partners. You run sourcing events, negotiate rate contracts and answer for savings and service levels. To move up, show savings that hold up in the accounts, supplier relationships that survive tough negotiations and the ability to keep plants supplied during disruptions such as port congestion or a supplier failure.

3

Senior Manager, Procurement or Supply Chain (around 4-6 years)

You lead a team of buyers or logistics coordinators across several sites and own a significant budget. The work shifts from individual negotiations to policy: sourcing strategy, approval workflows, partner portfolios and the metrics leadership reviews. To move up, demonstrate impact across plants, sound judgement on capital purchases and the ability to develop people who can run categories without you.

4

Head of Function or Deep Specialist (beyond 6 years)

The path forks here. The people-management route leads to roles such as Head of Procurement or Head of Supply Chain, owning the full strategy for buying and moving goods along with its risks. The specialist route leads to roles such as Supply Chain Analytics Lead or Strategic Sourcing Expert, owning advanced modelling, network design or complex global negotiations. Either way, you are judged on business outcomes and resilience, not activity.


10. Conclusion

The biggest differentiator in this interview is showing you understand both the data and the business behind it. Be ready to walk through a PR-to-PO cycle, size a saving with correct arithmetic and explain what a logistics dashboard should help a manager decide. Candidates who tie their Excel and Power BI skills to real procurement and freight decisions stand out.

Two more actions make a visible difference. Build one small spend or freight dashboard of your own and practise presenting it in two minutes. Then rehearse the core logistics calculations, Incoterms normalisation and FCL versus LCL breakeven, until you can do them aloud without notes.

Today, download a public dataset with messy supplier or transaction records, clean it in Power Query and build a one-page Power BI spend view. Then bring the story of what you fixed and what it revealed into your technical answers for the Eternis Fine Chemicals Ltd. Procurement & Logistics Analytics Intern interview.

Top Tips for Interview Success

Mark as Read