Mumbai, India ยท UK experience ยท Open to analytics opportunities across India

Turning data into
better business decisions.

I help businesses solve customer, commercial and operational problems through analytics.

3+ YearsAnalytics Experience
220+Locations Analysed
100%Reconciliation Accuracy
75%Ad-Hoc Requests Reduced
Scroll
Vishal Patil
๐Ÿ†

Ann Tonner, Head of Data & BI โ€ข Manager Feedback

"Strong analytical rigour, curiosity and collaboration, with the ability to turn complex data into information the business can act on."

Building analytics that drive
commercial decisions.

I enjoy solving ambiguous business problems by combining data analysis with business context to explain what is happening, why it is happening, and what should happen next. Whether analysing customer behaviour, improving reporting accuracy or identifying commercial opportunities, my goal is to help teams make better decisions with confidence.

Based in Mumbai, India, with UK enterprise experience at JD Sports Fashion and A2Dominion Group, I help businesses answer difficult commercial questions using data.

Financial Analytics Product Analytics Customer Insights SQL & Power BI Python Data Quality

Selected Business Questions

Demonstrating how analytics directly addresses core commercial challenges.

๐Ÿ›’

How do we reduce checkout abandonment?

Analysed e-commerce clickstream data to isolate friction points and support checkout journey optimization.

JD Sports
๐ŸŽฏ

Which customer segments should marketing prioritise?

Applied RFM segmentation and cohort analysis to identify high-value customer retention & growth pools.

JD Sports
๐Ÿ“Š

Why are finance reports inconsistent?

Reconciled SQL joins and migrated legacy SSRS reports into verified Power BI semantic models.

A2Dominion
โš ๏ธ

How can we identify complaints likely to escalate?

Engineered NLP text classification and risk scoring to flag high-friction interaction cases early.

Complaint Risk Case Study
๐Ÿ’ณ

Can alternative financial data improve credit decisions?

Evaluated recurring utility payment patterns in Python/XGBoost to assess creditworthiness for thin-file applicants.

Thin-File Borrower Case Study

How I Work

A structured problem-solving framework connecting business questions to measurable impact.

01 Business Question
02 Data Exploration
03 Analysis
04 Insights
05 Recommendation
06 Business Impact

Selected Projects

Selected analytics projects solving customer, commercial and operational problems.

Product & Commercial Analytics 01

Sales Pipeline Analytics

Challenge: Sales leaders lacked visibility into funnel performance and pipeline velocity across deal stages.

Approach: Built SQL pipeline analysis and interactive Streamlit dashboards tracking deal progression.

Key Insight: Analysis identified late-stage negotiation as the largest source of pipeline leakage.

Business Value: Improved visibility into pipeline health and revenue forecasting reliability.

Customer Insights & Retention 02

Complaint Risk & Operational Insights

Challenge: Escalating customer complaints were driving operational support costs and account churn.

Approach: Applied NLP text classification and XGBoost predictive risk scoring on customer logs.

Key Insight: Analysis highlighted recurring operational friction points associated with complaint escalation.

Business Value: Enabled early intervention triggers to reduce operational escalation costs and improve retention.

Credit Risk & Financial Analytics 03

Thin-File Borrower Risk Assessment

Challenge: Traditional credit scoring excluded 31.4% of creditworthy thin-file applicants with sparse history.

Approach: Built alternative credit scoring models using utility & payment history in Python/XGBoost with SHAP.

Key Insight: Recurring digital utility payment consistency strongly correlated with low default risk.

Business Value: Scenario analysis shows credit criteria can expand safely without increasing credit default risk.

Regulatory Compliance & Data Integrity 04

Mortgage Regulatory Data Quality

Challenge: Regulatory reporting required 100% data integrity before loan register submission.

Approach: Developed automated SQL reconciliation scripts and pre-submission audit rules.

Key Insight: Formatting discrepancies between loan origination systems and reporting tables caused errors.

Business Value: Designed an automated reconciliation framework capable of validating reporting datasets before submission.

Postgraduate NLP Research 05

Multilingual NLP Dissertation Benchmark

Question: Does translating multilingual customer feedback reduce ML classification accuracy?

Methods: Compared Logistic Regression, Random Forest, Naive Bayes and multilingual BERT.

Finding: Native-language fine-tuning consistently outperformed machine translation pipelines.

Professional Experience

Commercial analytics experience across retail, housing, and operations.

Insight Analyst

A2Dominion Group London, UK
Nov 2024 โ€“ Jan 2026

Business Focus: BI & Finance Analytics (Housing association managing 38,000+ homes)

  • Achieved 100% reconciliation accuracy for finance reporting by validating KPIs and reporting logic during SSRS to Power BI migration using SQL.
  • Reduced ad-hoc reporting requests by 75% by building self-service executive dashboards and standardising definitions.
  • Saved 15+ hours per week by automating data preparation and validation workflows in SQL, Power Query, and Power BI.
  • Validated SQL joins and reporting logic alongside data engineering teams to ensure consistent financial outputs.
SQLPower BIDAXPower QuerySSRS MigrationData Quality

Insight Analyst

JD Sports Fashion London, UK
Sep 2023 โ€“ Nov 2024

Business Focus: Retail & Commercial Analytics (UK's largest sports fashion retailer across 220+ locations)

  • Analysed e-commerce clickstream data using SQL to identify customer drop-off points targeting a 5% checkout conversion uplift.
  • Delivered commercial performance reporting across 220+ retail and digital locations in Power BI and Tableau.
  • Conducted customer segmentation and cohort retention analysis using SQL and Python to guide marketing decision making.
  • Supported ETL/ELT data validation and aggregation of transactional datasets within Databricks.
Product AnalyticsSQLPythonDatabricksPower BITableauCohort Analysis

Junior Data Scientist

GEAR - Gemini Equipment And Rentals Mumbai, India
Jun 2020 โ€“ Jun 2021

Business Focus: Operational Analytics (Industrial equipment rentals and fleet operations)

  • Reduced reporting turnaround time by 90% by replacing manual spreadsheet processes with automated Python and Power BI workflows.
  • Standardised core operational metrics and built validation checks across reporting datasets.
  • Supported fleet operational reporting and predictive maintenance analytics.
PythonSQLPower BIAutomationData Validation

Technical Expertise

๐Ÿ“ˆ

Core Analytics

  • SQL
  • Python
  • Statistics
  • Experimentation
๐ŸŽฏ

Product Analytics

  • Funnel Analysis
  • Cohorts
  • Customer Segmentation
  • A/B Testing
๐Ÿ“Š

Business Intelligence

  • Power BI
  • Tableau
  • Executive Reporting
  • Data Storytelling
โ˜๏ธ

Data Engineering

  • BigQuery
  • Databricks
  • ETL
  • Data Quality

Education

Distinction Sep 2022 โ€“ Sep 2023

MSc in Big Data Science

Queen Mary University of London ยท London, UK

BE Degree Jun 2018 โ€“ Jun 2022

BE in Electronics & Telecommunication Engineering

University of Mumbai ยท Mumbai, India

Let's build better decisions with data.

Based in Mumbai, India with UK experience ยท Open to analytics opportunities across India.

โœ‰๏ธ
Email vishalrpatil2010@gmail.com Copied to Clipboard!
๐Ÿ’ผ
LinkedIn linkedin.com/in/vishalrpatill
๐Ÿ’ป
GitHub github.com/VishalP44