Business Analyst | Marketing & Operations | Management Trainee

Abhijeet Siddappa Kapse

Turning market signals into business growth.

MBA from IIM Bodh Gaya with hands-on work in business development, client coordination, and data analytics. Google Digital Marketing certified, Lean Six Sigma Green Belt (KPMG). I connect market research, outreach execution, and dashboards so business decisions rest on evidence, not instinct.

Market research Campaign coordination CRM management Tableau + PostgreSQL
0+ pharma & biotech client segments researched
0+ industry prospects maintained in CRM
0 active client accounts coordinated
0+ client interaction sessions managed
Market research & segmentation 3 BD presentations delivered 5 service marketing documents Outreach performance dashboards Weekly reports to 3 business leads Google Digital Marketing certified Lean Six Sigma Green Belt — KPMG 50+ prospect CRM database

Profile

Built for business decisions, not vanity metrics.

My work sits between marketing and analytics. I research client segments, coordinate outreach and engagement, and turn the results into dashboards and reports — so growth conversations are grounded in what the data shows, not what a slide claims.

Portrait of Abhijeet Siddappa Kapse
Pune, India Business Analyst
Research Segment mapping

Researched 20+ pharmaceutical and biotech client segments and mapped company service capabilities to what each segment actually needs.

Engagement Client coordination

Managed communication across 8 active accounts — 20+ interaction sessions, follow-up tracking, and meeting summaries to senior leadership.

Analytics Performance reporting

Built Excel dashboards tracking outreach performance and engagement metrics, with weekly summaries delivered to 3 business leads.

Why Me

What stands out in a marketing-analyst role.

Marketing + analytics blend

Comfortable moving from market research and content development to Tableau, PostgreSQL, and Excel dashboard reporting.

Client-facing discipline

Real experience coordinating live client accounts — scheduling, follow-ups, summaries, and stakeholder communication that keeps deals moving.

Immediate readiness

Pune-based, immediate joiner. Google Digital Marketing certified with Lean Six Sigma Green Belt (KPMG) process rigour built in.

Internship · Apr–Jul 2024

Program Coordinator
Business Development & Client Coordination

Seveillar Clinical Supplies Services Pvt Ltd · Ranjangaon, Maharashtra

20+ Client segments researched
8 Active accounts coordinated
5 Marketing documents developed
50+ CRM prospect contacts
01

Market research & prospecting

Researched 20+ pharmaceutical and biotech client segments, mapped service capabilities to client requirements, prepared 3 business development presentations used in external outreach, and maintained a 50+ contact prospect database in CRM.

50+ prospects in CRM
02

Client account coordination

Coordinated communication across 8 active client accounts — scheduled and managed 20+ client interaction sessions, tracked follow-up action items, and circulated meeting summaries to senior leadership after each engagement.

20+ sessions managed
03

Marketing content & dashboards

Developed 5 service marketing documents and internal communication templates; designed Excel dashboards tracking outreach performance and engagement metrics; delivered weekly summary reports to 3 business leads.

Weekly reporting cadence
04

Records, compliance & process

Administered records and compliance documentation for 10 vendor and partner accounts; drafted 2 internal policy documents adopted by the team; organised scheduling, agendas, and follow-up tracking across coordination activities.

2 policy documents adopted

Campus Leadership

Envision — Entrepreneurship & Industrial Relations Cell, IIM Bodh Gaya.

Event marketing & logistics

YES Summit & TEDx IIM Bodh Gaya

Coordinated event logistics for the Youth Entrepreneurship Summit and TEDx IIM Bodh Gaya — vendor bookings, venue setup, and materials for 100+ participant summits with sponsors including NABARD and Startup Bihar.

Outreach & communications

Entrepreneur's Talk Series & World Entrepreneurship Day

Led external outreach — contacted industry speakers, coordinated schedules, and managed pre-event communications across organising teams.

Featured Project

Business Analytics Dashboard

Analysed 9,999 global orders across 5 markets in Tableau, PostgreSQL, and Excel — surfacing delivery risk, discount-profit trade-offs, and segment-level performance for commercial decision-making.

01 Delivery risk exposed Identified a 53.7% late delivery rate overall, peaking at 60.1% in Europe — a direct threat to customer experience and retention.
02 Discount-profit trade-offs Mapped how discounting behaviour affects profit across 3 customer segments to show where margin is being given away.
03 Decision-ready visuals Built an 8-visualisation Tableau dashboard — geographic map, monthly trend, treemap, scatter plots — backed by 10 PostgreSQL queries, published on GitHub.
0%
Late delivery 53.7% Europe: 60.1%
Analysis depth 8 + 10 visualisations + SQL queries
Business story

Delivery performance, discount behaviour, and segment profitability stitched into one commercial decision view.

Operating Style

How I typically work through a business problem.

01 Research the market

Start with segments, client requirements, and what the company can credibly offer each one.

02 Quantify what's working

Track outreach performance, engagement metrics, and delivery signals in dashboards instead of gut feel.

03 Communicate to action

Turn findings into presentations, marketing documents, and weekly reports that stakeholders act on.

Capabilities

Marketing, business analysis, and data skills.

Marketing & Business

Market Research, Digital Marketing, Campaign Coordination, Content Development, Client Relationship Management, Business Analysis, Stakeholder Management, Project Coordination

Analytics & BI

Tableau (maps, trend charts, treemap, scatter plots), SQL (PostgreSQL), Power BI (basic), Excel Dashboards, MIS Reporting, Data Visualisation, Data Reporting

Tools & Methods

CRM Systems, Asana, Google Workspace, Microsoft Office Suite, SAP S/4HANA MM, Lean Six Sigma, Report Writing, Presentation Design, Process Documentation

PivotTables VLOOKUP INDEX-MATCH COUNTIFS Dynamic slicers Conditional formatting Treemaps Scatter plots

Education & Certifications

MBA foundation with marketing-focused upskilling.

IIM Bodh Gaya logo
MBA Institution Indian Institute of Management Bodh Gaya

Core management training supporting business analysis, marketing decision-making, and structured problem solving.

MBA

IIM Bodh Gaya

CGPA 6.3/10 | 2023–2025

B.E.

Jaywant College of Engineering, Sangli

Civil Engineering | 78.50% | Rank 2/50

Certifications

Google Digital Marketing, Lean Six Sigma Green Belt (KPMG)

Also: Google Project Management, SAP S/4HANA MM (Udemy), McKinsey Forward Program.

Contact

Open to business analyst, marketing, and management trainee roles.