JM
Initialising portfolio
Consultant · Analyst · Strategist
BLR, IN — 2026

JISHNU MONDAL

Data Noise ↓
40%
100+ leads audited daily
Outlets Audited
300+
Field audit, ITC internship
Records Tracked
30K+
Excel dashboard built from scratch

MBA.
Risk-aware.
Data-led.

I'm a business consultant and analyst who works at the intersection of risk, data, and strategy. MBA in Marketing with a minor in Business Analytics — I've audited 300+ outlets, cleaned 30,000+ records, and built compliance frameworks from the ground up.

From identifying control gaps to delivering structured insights to stakeholders, I turn messy data into clean decisions.

40%
Reduction in data noise — audited & cleaned 100+ daily lead records at Erayaa
1K+
Secondary stakeholders verified in 3-day compliance exercise at Berger Paints
~150
Outlets disqualified for compliance reasons during ITC field audit across 2 districts
90+
New customer onboardings secured post-ITC internship through competitor negotiation pipeline
02

SKILLS

Advanced Excel90
Data Validation & Reconciliation88
KPI Tracking & Reporting85
Risk & Controls Review82
Gap & Trend Analysis80
Tableau / Power BI75
SQL65
Compliance Verification80
Project Management
WBS RAID Logs Stakeholder Mapping Delivery Frameworks Jira Communication Plans
Risk & Controls
Risk IdentificationProcess Review Gap AnalysisControl Weakness Internal Audit SupportCompliance Verification COSO AwarenessRCM
Analytics & Tools
ExcelSQLTableau Power BIPythonFigma KPI DashboardsSWOT Analysis Stakeholder ReportingJira
03

EXPERIENCE

ERAYAA BUILDERS
Mar 2026 — Present
Bengaluru, India
Business Development Associate
Audited and cleaned 100+ daily leads, removing ~40 duplicate and incomplete records — reducing data noise by 40% and contributing to the team's first closed sale after a 3-month dry run
Replaced a manual paper-based lead distribution system with an Excel tracking dashboard capturing 30,000+ customer records including location preferences and feedback
Performed process risk assessments to detect workflow inefficiencies and recommend corrective controls, enhancing operational compliance and reporting reliability
Proposed an API-based data standardisation solution to reduce reporting inconsistencies and strengthen control over customer data management
BERGER PAINTS
May — Jul 2025
Kolkata, India
Management Intern — Sales & Operations
Conducted a compliance verification exercise across 1,000+ secondary stakeholders (painters) in 3 days, confirming quarter-end points collection using AI-assisted calling
Identified a process control gap in product information delivery caused by language barriers; proposed and demonstrated a QR-based solution to standardise access
Collected, maintained, and reconciled financial records including cheque submissions — ensuring data accuracy and accountability across the reporting cycle
Participated in weekly, monthly, and quarterly business review meetings, gaining structured exposure to performance monitoring cycles and stakeholder reporting
ITC LIMITED
May — Jul 2024
Kolkata, India
Management Intern — Market Strategy & Analytics
Conducted a field audit across 300+ outlets in two districts, classifying and disqualifying ~150 for compliance reasons — non-smoking zones, government restrictions, no building permission, or active competitor agreements
Negotiated with competitor-tied outlets lacking formal agreements, building a pipeline that resulted in 90+ new customer onboardings after the internship concluded
Executed 10–20 Legal Term Agreements (LTAs) with new HORECA sector customers, ensuring contractual compliance and formalising business relationships
Tracked and reconciled product movement records at distributor level, maintaining data accuracy across inventory and sales reporting cycles
04

PROJECTS

P — 001
CLOUD DELIVERY & RISK DASHBOARD
Python (pandas) system computing KPIs — issue severity, project health, risk_score. Tableau dashboard surfacing at-risk engagements and blockers, mirroring consulting PM reporting and risk governance.
PythonPandasTableauRisk
GitHub
P — 002
PM PLAYBOOK & DELIVERY TOOLKIT
Consulting-ready PM toolkit: WBS templates, RAID logs, stakeholder maps, communication frameworks, and a complete sample delivery scenario demonstrating structured project leadership.
PMStakeholderFrameworks
GitHub
P — 003
PROCESS RISK & KPI ANALYSIS
Analysed 500+ records to identify process gaps, inconsistencies, and performance risks. Developed KPI dashboard and recommended process improvements to strengthen controls and reduce errors.
KPIRiskControlsExcel
P — 004
DATA VALIDATION & CONTROL IMPROVEMENT
End-to-end data validation and reconciliation — identifying inconsistencies, duplicates, and control gaps. Structured reporting frameworks to improve data accuracy, reliability, and process transparency.
ValidationReconciliationReporting
P — 005
CUSTOMER ANALYTICS & SALES OPTIMISATION
Analysed 500+ customer records using Excel and SQL to identify high-value segments and conversion drop-off points. KPI dashboard with targeted process improvement recommendations.
ExcelSQLSegmentation
P — 006
MARKET RESEARCH & BENCHMARKING
Structured competitive benchmarking across market segments at ITC Limited. Surfaced performance gaps and white-space opportunities. Delivered executive reports for quarterly strategy reviews.
BenchmarkingStrategyReporting
P — 007
QR-BASED PRODUCT PROTOTYPE
QR-code-driven Figma prototype for Berger Paints — enabling regional distributor staff to access product catalogues without a sales rep. Reduced friction for non-digital-native audiences.
FigmaUXCX
P — 008
MORE COMING SOON
Building new projects at the intersection of risk analytics, consulting, and digital strategy. Connect on LinkedIn to follow along.
In Progress2026
05

PHOTOGRAPHY

Beyond the data. I shoot street, architecture, and travel across India — the same compositional discipline I apply to analytics. All shots taken by me.

Victoria Memorial Kolkata
Colonial · Shimla
Victoria Memorial Interior
The Dome · Victoria Memorial
Child with bubbles street photography
Bubbles · Street
Hat seller Kolkata street
Hat Seller · Kolkata Streets
Night architecture Shimla
Night · Shimla
Mall Road Shimla
Mall Road · Shimla
Colonial architecture Shimla
Victoria Memorial · Kolkata
View on Instagram ↗
06

EDUCATION

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
View Certificate ↗
McKinsey Forward Program
Problem Solving & Communication · Dec 10, 2025
McKinsey.org
Deloitte
View Certificate ↗
Data Analytics Job Simulation
Data Analysis · Forensic Tech · Oct 17, 2025
Deloitte × Forage
Google Digital Marketing
View Details ↗
Google Digital Marketing & E-commerce
8-Course Professional Certificate · Aug 22, 2025
Google × Coursera
07

THE LAB

Think like a consultant. Five rapid-fire business analytics questions — can you crack them all? Best score gets bragging rights.

Analyst Challenge · 5 Questions
0
Score
1/5
Question
Loading question...
0 / 5
That's your analyst score
08

CONTACT

LET'S
WORK
TOGETHER.

Open to consulting, risk & controls, and analytics roles. If you're building something data-driven and need someone who translates numbers into decisions — let's talk.