At Eternis Fine Chemicals Ltd., the Data Science and Business Analytics intern plant on two problems that hit a specialty chemicals endeavor directly. The archetypal is how exposed the business is whenever a crucial raw matter has too few suppliers. The second is how much period teams endure whenever customer, matter and merchandise records differ throughout systems.
This guide is for Master of Business Administration (MBA) students in operations, provision sequence and analytics preparing for this summer internship. It explains the two projects in plain English and covers the skills interviewers test and a apt discussion sequence. It additionally includes 28 custom questions alongside answer frameworks and a four-week preparedness plan.
1. About the Data Science & Business Analytics Intern Role
This internship is two endeavor betterment projects, and all one ends in a tool the business keeps using. In the first, you decide which raw materials deserve substitute suppliers and rear that call alongside disbursal and hazard evidence. In the second, you build one trusted type of customer, matter and merchandise data so reports halt contradicting all other.
Your activity sits near to the procurement team, which sends out Requests for Quotation (RFQs) and approves new suppliers. You additionally activity alongside the group who keep records in SAP, the company's endeavor asset preparedness (ERP) system, alongside alongside on-time in-full (OTIF) shipment trackers and customs data. You volition additionally agreement immediately alongside chemic manufacturers whenever chasing quotations.
2. Required Skills and Qualifications
Educational Qualifications
Skills Overview
Strong Excel is the center requirement. A chemistry backdrop and Power BI visibility are business preferences: they fortify a overview but are not mandatory.
3. Day-to-Day Responsibilities
Most weeks divided between array inspection in Excel or Power BI and follow-ups alongside suppliers and inner data owners. The cards below shield all deliverable throughout the two projects, so you can conversation to all one alongside confidence in the interview.
Supplier Development Project
Rank Raw Materials by Risk
You obtain acquisition data for approximately 26 raw materials and position them on two things: how much the business spends on each, and how difficult all would be to replace. A high-spend solvent alongside three family sources is small worrying than a low-spend catalyst bought from one abroad plant. You afterward narrow the catalog to 10 crucial items and defend all choice.
Find the Actual Manufacturers
For all of the 10 crucial items, you build a catalog of who really produces the chemical, not fair who sells it. Traders and distributors frequently appear in searches alongside genuine producers. You cross-check shipment records, industry directories and provider websites, afterward verify factory locations and capability before anyone is approached.
Compare Landed Costs
A quoted cost is lone the starting point. Landed disbursal adds freight, insurance, customs duty, harbor clearing and inland transport up to the factory gate. An imported citation that looks cheaper can end up costlier than a manufacturer in Gujarat or Maharashtra formerly duty and transit are added. You build a like-for-like panel in rupees per kilogram for all supplier.
Score Supplier Risk
Alongside cost, you charge all applicant provider on risk. Factors contain dependence on a sole plant, extend and guide time, financial health, compliance document and former norm issues. A provider whose lone factory sits in a area alongside common shutdowns scores worse than a slightly pricier one alongside two plants. The output is a transparent mark that procurement can challenge.
Track RFQs and Qualification
Once suppliers are shortlisted, RFQs go out and you keep the tracker. It records who received an RFQ, who replied, the quoted cost and its validity. It additionally shows anywhere all provider stands in qualification, specified as example received, lab test passed or factory test pending. Chasing overdue replies by email and phone is part of the job.
Build the Supplier Intelligence Hub
Everything complete comes together in one Excel or Power BI document covering crucial materials, suppliers, landed costs, hazard scores and RFQ status. A director have to be capable to choice a matter and see its sourcing options in seconds. You near alongside written recommendations, for example qualifying a second family origin for one item and renegotiating alongside the current provider on another.
Master Data Harmonisation Project
Audit Records Across Systems
You drag customer, matter and merchandise records from SAP, the OTIF tracker, customs data and squad spreadsheets, afterward figure anywhere they disagree. The identical client power be 'Shree Ganesh Polymers Pvt Ltd' in SAP and 'SHREE GANESH POLYMERS PRIVATE LIMITED' in customs filings, or one matter may transport two codes. The audit puts numbers on duplicates, gaps and conflicts.
Create Golden Records and Mappings
For all customer, matter and product, you create one expert version, called the aureate record. You additionally build a mapping array that links all old code or orthography rear to it. If a matter appears under three codes throughout systems, the mapping shows all three pointing to one expert ID, so reports can be joined without manual cleanup.
Define Matching Rules
Matching rules decide whenever two records are the identical entity. Strong identifiers arrive first. Examples are the Goods and Services Tax Identification Number (GSTIN) for an Indian customer, or the Chemical Abstracts Service (CAS) figure for a material. Where identifiers are missing, you autumn rear to cleaned names and addresses, and you document which origin wins whenever values conflict.
Build the Data-Quality Dashboard
The dashboard shows the health of expert data complete time. It tracks the portion of complete records, duplicates established and resolved, and mismatches by origin system. A squad guide have to be capable to see, for instance, what portion of matter records deficiency a CAS figure and which scheme they sit in. This turns a one-time cleanup into item the business can monitor.
Write the Data Dictionary
A data dictionary defines all site in the expert tables, including its meaning, format, allowed values, origin scheme and owner. It settles questions akin whether 'customer' method the billing being or the shipment plant. It additionally records whether a importance site is stored in kilograms or tonnes. Without it, the next expert recreates the identical disturbance you fair removed.
Write the User Guide
The person guide explains how colleagues use and keep what you built. It covers how to refresh the dashboard, how to add a new client without creating a duplicate, and what to do whenever a matching regulation flags a imaginable conflict. Write it for a occupied colleague, alongside screenshots and abbreviated steps, since it keeps your activity living following the internship ends.
4. Key Competencies for Success
Excel and the correct MBA specialisation get you shortlisted. What sets powerful interns distinct on projects akin these is how they behave whenever data is incomplete, suppliers go quiescent and two teams differ concerning which figure is right.
5. Interview Process at Eternis Fine Chemicals Ltd.
Summer placement interviews for operations and analytics roles at manufacturing companies normally run inside a sole placement day, on evidence or online. The sequence below reflects that representative pattern. Your placement commission volition verify the exact rounds nearer to the date.
Curriculum Vitae (CV) Shortlisting
The business reviews CVs for MBA specialisation, Excel degree and any chemistry or Power BI exposure, and shares a shortlist through the placement committee. A row specified as 'built a Power Query example reconciling 5,000 vendor records' carries far additional importance than 'proficient in Excel'.
Group Exercise or Short Case (if conducted)
Some manufacturing firms use a collection conversation or a abbreviated written case to narrow a lengthy shortlist. Expect a endeavor topic specified as import dependence for raw materials or provision sequence resilience. Evaluators observe whether you construction the issue and build on others fairly than conversation complete them.
Functional Interview
Usually conducted by a director from procurement, provision sequence or analytics. Expect questions on Excel logic, landed cost, provider hazard and data cleaning, affirmative a profound dive into any CV project. Be prepared to explain formulas stage by stage or portion your display if the circular is online.
HR and Fit Interview
Covers motivation for a specialty chemicals company, comfort alongside a Pan India location, and how you activity alongside factory and procurement teams. Short, particular answers concerning why this internship fits your goals matter additional current than polished speeches.
Offer Through the Placement Committee
Results are typically communicated through the placement commission on the identical day. Once you accept, keep your commission updated on any joining instructions and the location confirmed for your project.
6. Interview Questions
Use STAR (Situation, Task, Action, Result) for behavioural questions and keep all narrative under two minutes. For specialized questions, conversation through your logic as if you were construction the document in forefront of the interviewer. For cases, province assumptions, calculate, afterward recommend.
Expect follow-up questions that shove former your archetypal answer. Interviewers desire to see that you can inspect your own numbers and defend a recommendation.
