IIM Bodh GayaMBA โ€” IIM Bodh Gaya

Operations ยท Strategy ยท Analytics

Abhijit
Kapse

Operations & Strategy Professional

Transforming operational complexity
into data-driven clarity.

MBA from IIM Bodh Gaya with 3+ years of hands-on operations experience across agribusiness and clinical supplies. Delivered 95% on-time performance across 200+ orders and built MIS dashboards for weekly stakeholder insights.

Abhijit Kapse
3+Years Experience
200+Orders Managed
95%On-Time Delivery
โ— What I Bring

Expertise That Drives Results

Analytical rigor and operational excellence honed through real-world challenges.

๐Ÿ“Š

Operations & MIS

Built Excel MIS dashboards providing weekly insights to 5โ€“6 stakeholders with zero missed deadlines. Delivered 32+ weekly reports enabling early identification of 15+ operational issues.

MIS ReportingProcess ImprovementSOP DevelopmentKPI Monitoring
๐ŸŽฏ

Business Analysis

Mapped 3 order-to-dispatch workflows identifying 5+ process gaps. Analyzed 150+ data points revealing bottleneck patterns and 15โ€“20% delays in specific stages.

Process MappingGap AnalysisRoot Cause AnalysisRequirements Gathering
๐Ÿ“ฆ

Supply Chain & Procurement

Processed 60โ€“100 POs on TallyPrime ERP with 95%+ accuracy. Managed 200+ orders at 90โ€“95% on-time dispatch. Reconciled 40โ€“50 GRNs resolving discrepancies within 2 days.

PO ProcessingVendor OnboardingGRN ReconciliationInventory Mgmt
๐Ÿ‘ฅ

Stakeholder & Vendor Mgmt

Facilitated 12+ stakeholder meetings distributing action items within 24 hours. Coordinated 8โ€“10 vendor relationships achieving 10โ€“15% cost optimization through competitive analysis.

Stakeholder MeetingsVendor NegotiationCost AnalysisCross-functional
๐Ÿ†
Lean Six Sigma Green Belt
KPMG Certified
๐Ÿ“ˆ
PostgreSQL & Tableau
Analytics Proficiency
๐Ÿ‘ฅ
E-Cell Lead
IIM Bodh Gaya
๐Ÿ“š
McKinsey Forward
Google PM Certified
โ— Career Journey

Where I've Made Impact

Each role shaped my ability to drive operational excellence.

2024

Operations Program Coordinator (Intern)

Seveillar Clinical Supplies Services Pvt Ltd

  • Processed 60โ€“100 purchase requisitions using TallyPrime ERP for invoicing, inventory tracking, and procurement workflow management
  • Validated item codes, cost centers, and tax calculations using standardized checklists, maintaining 95%+ accuracy across all PO transactions
  • Analyzed 120+ survey responses identifying 5 critical gaps, recommending 3 process changes that reduced order processing time by ~25%
  • Organized centralized SOP repository with 10+ documents and version control, cutting retrieval time from 15 min to under 2 min
  • Monitored delivery schedules sustaining 90โ€“95% on-time dispatch performance across all orders
Supply ChainERP (TallyPrime)Process ImprovementSOP Development
2020 โ€” 2022

Operations Coordinator

Kapse Greenhouse & Agribusiness

  • Managed end-to-end operations for 6-acre operation with 3โ€“4 logistics providers, delivering 200+ orders at 95% on-time dispatch
  • Processed 80โ€“120 goods receipt notes using standardized validation checklists, maintaining 98% accuracy across vendor payment cycles
  • Delivered 32+ weekly MIS reports using Excel PivotTables and VLOOKUP with zero missed deadlines
  • Negotiated with 10โ€“12 vendors through cost comparison analysis, achieving 10โ€“15% cost optimization across procurement
  • Monitored inventory for 40โ€“60 SKUs with monthly physical counts and buffer stock alerts, preventing stockout incidents
OperationsMIS ReportingLogisticsVendor Mgmt
2024

E-Cell Lead

Indian Institute of Management Bodh Gaya

  • Directed 20+ events achieving 90% on-time start rate with 40โ€“100 attendees, managing venue booking, vendor coordination, and materials procurement
  • Secured 5โ€“7 external partnerships (TEDx, YES Club, startup incubators) through targeted outreach
LeadershipEvent ManagementPartnerships
โ— My Toolkit

Technical Skills

Tools and technologies I work with across my roles.

๐Ÿ“Š
Excel (Advanced)
  • PivotTables
  • VLOOKUP / INDEX-MATCH
  • Conditional Formatting
  • Data Validation
๐Ÿ“ˆ
Tableau
  • KPI Scorecards
  • Interactive Dashboards
  • Geographic Mapping
  • Vendor Rankings & Trend Charts
๐Ÿ—„๏ธ
PostgreSQL
  • JOINs & Subqueries
  • CTEs (Common Table Expressions)
  • Window Functions
  • Aggregations & Data Modeling
๐Ÿ“‰
Power BI & Analytics
  • Power BI Dashboards
  • DAX Basics & Data Modeling
  • IBM SPSS
๐Ÿ”ง
ERP & Tools
  • TallyPrime ERP
  • Microsoft Office Suite
  • Google Workspace
  • Asana
๐Ÿ… Lean Six Sigma Green Belt โ€” KPMG
๐ŸŽ“ Google Project Management
๐Ÿ“Š PwC Data-Driven Decision Making
๐Ÿš€ McKinsey Forward Program
โ— Featured Work

Technical Projects

Hands-on projects demonstrating analytical capabilities.

๐Ÿ“Š

Operations Analytics Dashboard

Built PostgreSQL database + interactive Tableau dashboard with 8 visualizations (KPI scorecards, vendor rankings, trend charts, inventory alerts) analyzing 51 orders and 10 vendors. Queried โ‚น886,500 procurement data using SQL JOINs, CTEs, and aggregations, uncovering 88.24% on-time delivery rate.

PostgreSQLTableauSQL
๐Ÿ“‹

S&OP Planning Workbook

12-month demand vs capacity planning model in Excel with safety-stock calculations, constrained plan modeling, projected inventory levels with visual indicators, and stockout flags for proactive decision-making.

Excel ModelingForecastingSupply Chain Planning
๐Ÿ“ฆ

Operations KPI Dashboard

Excel analytics platform tracking OTD/OTIF metrics, pick/pack TAT analysis, fill rate calculation, and monthly OTD% by distribution center for supply chain performance visibility.

ExcelKPI TrackingLogistics Analytics
โ— Academic Foundation

Education

From engineering fundamentals to management excellence.

๐ŸŽ“

MBA

Indian Institute of Management Bodh Gaya

2023 โ€” 2025

CGPA: 6.3 / 10

Operations Management, Supply Chain Strategy, Business Analytics

๐Ÿ—๏ธ

B.E. Civil Engineering

Jaywant College of Engineering

2016 โ€” 2020

78.50% ยท Rank 2nd / 50

Analytical thinking, project planning, and systematic problem-solving

โ— Get In Touch

Let's Build Something Together

Open to Operations, Supply Chain, Business Analyst & Product Management roles.

Reach Out

Open to US shift overlap, immediate joining, and relocation.

Ready to Transform Operations?

Let's connect and explore how I can add value through data-driven operations management.