SK Siddharth Karandikar
Brief

Case study · Sparkonix (India), EDM division

₹1,700 crore of import records contained ₹30 crore of demand nobody had called.

Role
Competitive Strategy Intern
When
May – Jul 2025
Full read
2 min
Situation
Sparkonix has made electrical discharge machines since 1966, and its sales team knew its own customers well.
Complication
It could not see which factories were buying from competitors, so a large part of the market was invisible to it.
Question
Where is the demand nobody is calling?
Answer
In customs records. Seven years of import and sales data, more than ₹1,700 crore of it, surfaced over ₹30 crore of untapped demand and an 800-account lead base that sales could work.

What I did

Read the market from customs data. Import records show who bought a competing machine, when, and roughly what they paid. I analysed more than ₹1,700 crore of seven-year import and sales data against internal records. That surfaced over ₹30 crore of demand the firm was not serving, and an 800-plus account lead base verified enough for outreach to work.

Exhibit 1

₹1,700 crore of records narrowed to 800 accounts worth calling

Not to scale
  1. ₹1,700 Cr+
    Import and sales data analysed, seven years
  2. ₹30 Cr+
    Demand the firm was not serving
  3. 800+
    Verified accounts handed to sales

Source: Sparkonix (India), 2025 — seven years of customs import records read against internal sales

Benchmarked the competition. I profiled 8 competitors across the EDM industry and delivered a 30-slide strategy deck, a 25-page market report and 6 live dashboards. The Sales and Marketing Directors adopted them as the input for the firm’s competitive strategy.

Automated the grunt work. Classifying more than 4,000 product codes across 12 verticals (CNC, ZNC, manual, drills and accessories) by hand was not viable. I built an AI workflow on the Gemini API with Excel automation that cut the manual effort by 85%.

Exhibit 2

An AI workflow removed 85% of the manual classification effort

Manual classification
100
With the AI workflow
15

Effort indexed to the manual process = 100.

Hover, tap or tab to a bar for its value.

Source: Sparkonix (India), 2025 — 4,000+ product codes across 12 verticals

Used the engineering degree. With the Head of R&D, I evaluated 15-plus microchip communication protocols and recommended a revised standard, contributing to a 20% reduction in failure rates. It was an engineering judgement made to fix a commercial problem.

The result

A sales team with a list of accounts it had never called, and directors with a competitive picture they took into use.

You are reading a shorter version of this case study.