Consultant · Analyst · Strategist
BLR, IN — 2026
JISHNU
MONDAL
Data Accuracy ↑
~25%
150+ lead records/week
Outlets Analysed
300+
Market data, ITC internship
Manual Effort ↓
~30%
Lead tracking streamlined
MBA.
Data-first.
Results-led.
I'm a business analyst and strategist who translates data into decisions. MBA in Marketing with a minor in Business Analytics — working at the intersection of structured thinking, clean data, and strategic action.
From validating 150+ leads weekly to reducing manual effort by 30%, I build frameworks that make organisations faster and smarter.
~30%
Reduction in manual effort — lead tracking at Erayaa Builders
~20%
Faster decisions via daily KPI reports and performance dashboards
~15%
Improved targeting efficiency — trend analysis at Berger Paints
500+
Customer records analysed for segmentation and conversion insights
Data Validation & Cleansing88
KPI Tracking & Reporting85
Tools & Competencies
ExcelTableauSQLPythonFigma
PowerPointKPI DashboardsSegmentation
BenchmarkingGap AnalysisProcess Mapping
Req. GatheringStructured Thinking
Problem SolvingData Structuring
Risk AnalyticsDigital Marketing
ERAYAA BUILDERS
Mar 2026 — Present
Bengaluru, India
Business Development Associate
Structured and validated 150+ lead records weekly, improving data accuracy by ~25% through systematic cleansing protocols
Designed and maintained daily KPI dashboards, compressing decision-making cycle by ~20% across the BD team
Redesigned lead tracking workflow end-to-end, cutting manual effort by ~30% and eliminating recurring data entry errors
Coordinated with sales, ops, and senior stakeholders to ensure consistent data flow and unified reporting standards
Scoped and proposed API-based customer analytics and segmentation solution for pipeline intelligence
BERGER PAINTS
May — Jul 2025
Kolkata, India
Management Intern — Sales & Operations
Validated and standardised 100+ distributor and dealer records per month, reducing downstream reporting errors by ~20%
Built Excel-based KPI dashboard consolidating sell-out data, territory coverage, and scheme performance into a single view
Conducted trend analysis across SKUs and geographies, improving sales team targeting efficiency by ~15%
Designed a QR-code-driven Figma prototype for regional product catalogues, improving accessibility for non-digital users
Performed process gap analysis on order-to-delivery workflows; identified three high-impact inefficiencies and recommended fixes
ITC LIMITED
May — Jul 2024
Kolkata, India
Management Intern — Market Strategy & Analytics
Audited and analysed trade data across 300+ retail outlets — mapped coverage gaps, shelf-share trends, and competitor activity
Performed channel segmentation and benchmarking; surfaced high-potential clusters that informed territory reallocation decisions
Built Excel/SQL reporting dashboards that reduced weekly report preparation time by ~25% for the field sales team
Packaged raw market data into structured executive briefs and visual presentations for regional strategy reviews
P — 001
CLOUD DELIVERY & RISK DASHBOARD
Built a delivery analytics system using Python (pandas) to compute KPIs including issue severity, project health scores, and a calculated risk_score. Surfaced at-risk engagements, blockers, and delivery trends via a Tableau dashboard — mirroring consulting PM reporting and risk governance frameworks.
PythonPandasTableauRisk AnalyticsPM
GitHub — CloudDeliveryDashboard
P — 002
PM PLAYBOOK & DELIVERY TOOLKIT
Created a consulting-ready project management toolkit — WBS templates, RAID logs, stakeholder maps, communication frameworks, and a complete sample delivery scenario. Demonstrates structured project leadership aligned to real consulting delivery standards.
Project MgmtStakeholder MgmtFrameworksConsulting
GitHub — PM Playbook
P — 003
CUSTOMER ANALYTICS & SALES OPTIMISATION
Analysed 500+ customer records using Excel and SQL to identify high-value segments and conversion drop-off points. Built a KPI dashboard and recommended targeted process improvements that reduced lead drop-offs and improved funnel efficiency.
ExcelSQLSegmentationKPI
P — 004
MARKET RESEARCH & BENCHMARKING
Structured competitive benchmarking across market segments at ITC Limited to surface performance gaps and white-space opportunities. Delivered executive-ready reports and decision frameworks for quarterly strategy reviews.
BenchmarkingGap AnalysisStrategyReporting
P — 005
QR-BASED PRODUCT ACCESSIBILITY PROTOTYPE
Designed a QR-code-driven Figma prototype for Berger Paints — enabling regional distributor staff to browse product catalogues without a sales rep. Reduced in-store friction and improved product accessibility for non-digital-native audiences.
FigmaUX ResearchPrototypeCX
P — 006
MORE COMING SOON
Currently working on new projects at the intersection of data analytics, consulting, and digital strategy. Check back soon — or connect on LinkedIn to follow along as they ship.
In Progress2026
Beyond the data — I shoot street, architecture, and travel. A disciplined eye for composition and light; the same attention to detail I bring to analysis.
MBA
CGPA 7.19 · First Class · Vidyasagar University
Eastern Institute for Integrated Learning in Management, Kolkata
Major: Marketing · Minor: Business Analytics & Data Science
Final Semester: 72.88% · Business Analytics A · Strategic Management A
Marketing · Analytics
View Mark Sheet
BCA
DGPA 9.07 · UEM Kolkata
University of Engineering & Management, Kolkata
Bachelor of Computer Applications
Final Year SGPA: 9.03 (Even) · 9.66 (Odd) · YGPA: 9.32
Computer Applications
View Grade Card
Certifications & Credentials
McKinsey Forward Program
Problem Solving & Communication · Dec 10, 2025
McKinsey.org
Data Analytics Job Simulation
Data Analysis · Forensic Technology · Oct 17, 2025
Deloitte × Forage
Google Digital Marketing & E-commerce
8-Course Professional Certificate · Aug 22, 2025
Google × Coursera
