Sparsh Verma
Sparsh Verma
Chandigarh, India
Business & Finance Analytics

Turning operational data
into financial clarity.

I'm a business and finance professional who finds revenue leaks before they become problems — using SQL, Power BI, and Excel to turn institutional data into decisions.

1
Year of Experience in Finance Ops
2
End-to-End Analytics Projects
100K+
Data Points Analysed
View my work → ✉ Email me directly
Profile

Finance fundamentals.
Analyst's instincts.

I work as a Finance & Business Operations Professional at Fortis Hospital, one of India's leading hospital networks — where I sit at the intersection of financial operations, billing reconciliation, and revenue cycle management. Every day, I work with real financial data: validating tariffs, reconciling discrepancies, and producing the reports that keep a 5+ department operation financially accurate.

Outside my core role, I've taught myself SQL and Power BI to go beyond Excel — building two independent analytics projects that mirror real consulting engagements, from problem scoping to stakeholder-ready recommendations.

I'm now looking to bring this blend of financial domain knowledge and analytical capability into a full-time Business Analyst, Finance Analyst, or Healthcare Analyst role.

01
Financial accuracy under pressure
Reconciling 25–30+ transactions daily with zero tolerance for error
02
Self-taught technical depth
SQL and Power BI learned independently, applied to real datasets
03
Stakeholder-first communication
Translating data into recommendations decision-makers actually use

Quick facts

Based inChandigarh, India
Current roleFinance & Ops, Fortis Hospital
EducationB.Com, First Division
Core toolsSQL · Power BI · Excel
Open toBA · Finance · Healthcare Analyst
Emailvermasparsh024@gmail.com
Experience

Where the work happens

Hands-on financial and operational experience inside a real, high-stakes institution — not a simulation.

Jul 2025 — Present
Fortis Hospital, Mohali
Finance & Business Operations Professional
  • Own end-to-end financial processing for 30–40+ patient transactions daily — validating tariffs, package classifications, and category-specific billing rules to protect revenue accuracy.
  • Detect and resolve 7–9 financial discrepancies daily through root cause analysis, coordinating with TPAs, clinical teams, and management for same-day resolution.
  • Build Excel-based MIS and reconciliation reports used for management review, audit trails, and operational continuity across 5+ departments.
  • Run gap analysis on billing patterns to catch systemic errors before they compound — directly informing process control improvements.
Selected work

Two projects. One question:
where is the value leaking?

Independent, end-to-end analytics engagements — from raw data to stakeholder recommendation.

SQL · Power BI

E-Commerce Order & Delivery Performance Analysis

Analysed 99,441 orders across 8 relational tables to uncover revenue patterns, fulfilment bottlenecks, and regional delivery risk — using SQL for data extraction and Power BI for stakeholder-ready visualisation.

SQL (SQLite) Multi-table JOINs CASE WHEN logic Power BI Dashboard
  • Beauty & Health is the highest-revenue category at $1.23M — driven by order value, not volume
  • Average delivery time is 22.2 days; RR state averages 29 days vs. 22 in São Paulo
  • Only 31% of orders qualify as fast delivery (under 7 days) — 41% take 15+ days
  • Credit card dominates at 73.9% of transactions, reflecting Brazilian payment behaviour
See full project on LinkedIn →
$1.23M
Top category revenue
32%
Regional delivery gap
10.09M
Total revenue analysed
E-Commerce Order & Delivery Performance Dashboard built in Power BI
Live Power BI dashboard — built end-to-end from raw SQL extraction to stakeholder visualisation
Key findings slide from the e-commerce analytics presentation
Key findings slide from the full business presentation
Excel · Pivot Tables

Hospital Billing Analysis — Revenue Patterns & Discrepancies

Analysed 1,001 patient billing records (2019–2024) to identify revenue leakage patterns by diagnosis, insurer, and length of stay — delivering a structured business case to hospital stakeholders.

Pivot Tables Nested IF DAYS Formula Data Validation
  • Asthma drives the highest avg. billing at $27,329 — a 9% premium above the $25,117 average
  • Arthritis (178 cases) shows the lowest avg. billing — a potential under-billing signal
  • Blue Cross patients generate the highest avg. bill per patient at $26,241
  • High-bill patients stay 15% longer (15.8 vs. 13.7 days) — a revenue leakage risk window
See full project on LinkedIn →
1,001
Patient records analysed
3–5%
Est. revenue lost industry-wide to billing errors
20–30%
Potential reduction in post-discharge corrections
Key findings slide from the hospital billing analysis presentation
Key findings slide from the full business presentation
Toolkit

What I work with

Analytics & Reporting

SQL (JOINs, CASE WHEN, subqueries) Power BI Advanced Excel Pivot Tables Google Sheets

Finance & Operations

Revenue Cycle Management Financial Reconciliation MIS Reporting Tariff Validation TPA Coordination

Business Analysis

Gap Analysis Root Cause Analysis KPI Definition Process Improvement SOP Development

Communication

Stakeholder Management Business Case Presentations PowerPoint Cross-functional Coordination
Education

Foundation

Bachelor of Commerce (B.Com)
Shri Guru Gobind Singh College, Chandigarh · First Division
2025
62%
Class XII — Commerce
Shivalik Public School, Chandigarh
2022
87%

Let's talk about how I can bring this thinking to your team.

Open to Business Analyst, Finance Analyst, and Healthcare Analyst roles — open to relocation across India.

Email me LinkedIn +91 82648 75168