Chetan J
Back to Work
[ CASE STUDY ]

Gangothri Nutrients

Organic fertilizer and agri-inputs manufacturer. Built the monthly sales reporting model regional leadership uses for reviews, and co-authored an internal FAQ from clustered farmer queries.

Role

Product Operations Intern

Duration

3 mo

Type

internship

Location

Hyderabad, India

30+

SKUs Modeled

3–5 districts, 12–18 months of data

50+

Duplicate SKUs Resolved

ERP + distributor reconciliation

2–3h → 45m

Monthly Review Prep

via reusable pivots + SOP

30–40

Farmer Queries Clustered

internal FAQ adopted by sales

Highlights

01

Built an Excel monthly sales reporting model across 30+ SKUs and 3–5 districts, consolidating 12–18 months of ERP and distributor data and resolving 50+ duplicate SKU codes

02

Cut regional leadership’s monthly review prep from 2–3 hours to under 45 minutes via reusable pivots and a data-refresh SOP covering SKU, territory, and channel slicing

03

Logged 30–40 farmer and dealer queries over 6 weeks on tank-mixing and dosage for flagship products, clustered patterns with the agronomy lead, and co-authored an internal FAQ adopted by sales reps

Skills

Data AnalysisExcel ModelingOperationsUser ResearchDocumentation