IIM Bodh GayaMBA — IIM Bodh Gaya

Operations Analyst · Business Analyst · Process Improvement

Abhijeet
Siddappa Kapse

Operations & Business Analyst

Turning workflows into insights,
processes into performance.

MBA from IIM Bodh Gaya with hands-on experience in workflow analysis, process improvement, and Excel MIS reporting. Mapped 3 order-to-dispatch processes identifying 5+ bottlenecks, analyzed 150+ data points revealing 15-20% delivery delays, and delivered weekly dashboards to 5-6 stakeholders with zero missed deadlines.

Let's Connect → ⬇ Download CV
Abhijeet Kapse
150+Data Points Analyzed
95%+PO Accuracy
25%Process Time Reduced
● What I Bring

Expertise That Drives Results

Analytical rigor and process excellence honed through real-world operations challenges.

🎯

Business Analysis

Mapped 3 order-to-dispatch workflows interviewing 4-6 staff. Identified 5+ process gaps and analyzed 150+ operational data points revealing 15-20% delays in specific stages.

Process MappingWorkflow AnalysisGap AnalysisRequirements Gathering
📊

MIS & Excel Analytics

Built Excel MIS dashboards using PivotTables and VLOOKUP tracking on-time dispatch and PO aging. Supported weekly reviews with 5-6 stakeholders with zero missed deadlines.

MIS ReportingPivotTablesVLOOKUPDynamic Slicers
⚙️

Process Improvement

Analyzed 120+ survey responses identifying 5 critical gaps, contributing to 3 implemented changes reducing order processing time by 25%. Drafted 2 SOP updates reducing processing errors.

Root Cause AnalysisSOP DevelopmentLean Six SigmaCost-Benefit Analysis
📦

Operations & Procurement

Processed 120-200 purchase orders in ERP/CRM with 95%+ accuracy. Reconciled 80-100 GRNs resolving invoice discrepancies within 2 working days.

PO ProcessingGRN ReconciliationVendor ManagementInventory Mgmt
🏆
Lean Six Sigma Green Belt
KPMG Certified
📈
Tableau & PostgreSQL
Analytics Proficiency
🎓
McKinsey Forward
Google PM Certified
📱
Google Digital Marketing
Certified
● Career Journey

Where I've Made Impact

Real-world experience driving operational and analytical excellence.

2024

Operations Program Coordinator

Seveillar Clinical Supplies Services Pvt Ltd

  • Mapped 3 order-to-dispatch workflows interviewing 4-6 staff; identified 5+ process gaps; analyzed 150+ operational data points calculating on-time delivery metrics and revealing 15-20% delays
  • Built Excel MIS dashboards using PivotTables and VLOOKUP tracking on-time dispatch and PO aging; supported weekly reviews with 5-6 stakeholders with zero missed deadlines
  • Processed 120-200 purchase orders in ERP/CRM with 95%+ accuracy; reconciled 80-100 GRNs resolving invoice discrepancies within 2 working days
  • Drafted 2 SOP updates reducing processing errors; organized documentation repository with 10+ templates cutting team search time 75%
  • Facilitated 24+ stakeholder meetings with 100% advance agendas
  • Analyzed 120+ survey responses identifying 5 critical gaps, contributing to 3 implemented changes reducing order processing time 25%
Workflow AnalysisERP/CRMProcess ImprovementMIS DashboardsSOP Development
2023 — 2025

Entrepreneurship Cell (E-Cell) Member

Indian Institute of Management Bodh Gaya

  • Directed 20+ campus events (40-100 attendees each) achieving 90% on-time start rate; secured 5-7 external partnerships (TEDx, YES Club, startup incubators) with 25-30% response rate from 100+ targeted outreach emails
  • Managed event logistics including venue, vendor, and materials coordination across 3 major events with 100% financial reconciliation and zero budget overruns
LeadershipEvent ManagementPartnershipsBudget Management
● My Toolkit

Technical Skills

Tools and technologies I work with across my roles.

📊
Excel (Advanced)
  • PivotTables & Dynamic Slicers
  • VLOOKUP / INDEX-MATCH
  • COUNTIFS & Conditional Formatting
  • Data Validation & Dashboards
📈
Tableau
  • Geographic Mapping
  • Trend Charts & Treemaps
  • Scatter with Trend Lines
  • Interactive Dashboards
🗄️
SQL (PostgreSQL)
  • JOINs & Subqueries
  • CTEs & Window Functions
  • Aggregations & Data Modeling
  • OTD% & Performance Analytics
📉
Power BI & Analytics
  • Power BI Dashboards
  • IBM SPSS
  • Process Mapping Tools
🔧
ERP & Tools
  • ERP Systems (User)
  • Microsoft Office Suite
  • Google Workspace
  • Asana
🏅 Lean Six Sigma Green Belt — KPMG
🎓 Google Project Management
📱 Google Digital Marketing
🚀 McKinsey Forward Program
● Featured Work

Technical Project

End-to-end analytics solution demonstrating data-driven capabilities.

📊

Supply Chain Performance Dashboard

Analyzed 9,999 global orders across 5 markets using Excel PivotTables, COUNTIFS, and dynamic slicers — identified 53.7% late delivery rate, Europe worst at 60.1%; confirmed discount-profit trade-off via scatter trend lines across 3 segments. Built Tableau Public dashboard with 8 visualizations including geographic delivery map, monthly trend, department treemap, and scatter with segment-level trend lines. Wrote 10 SQL queries in PostgreSQL (pgAdmin) analyzing OTD%, market performance, shipping mode delays, and discount-profit correlation across 9,999 orders.

View Live Dashboard → GitHub Code →
ExcelTableauPostgreSQLpgAdminSQLSupply Chain 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 Analyst, Business Analyst & Process Improvement roles. Immediate joiner, Pune-based.

Reach Out

Immediate joiner, Pune-based. Open to relocation.

✉️
Email
ak@abhijitkapse.com
📱
Phone
+91 7507055055
📍
Location
Pune, Maharashtra, India

Ready to Drive Process Excellence?

Let's connect and explore how I can add value through data-driven analysis and process improvement.

Connect on LinkedIn View GitHub Download Resume