Data Analyst · Pali, Rajasthan

Hello, I'm
Dhruv Kanther

I transform data into actionable insights and build solutions that solve real business problems. Currently developing Power Platform solutions at Smart Technologies; previously worked as an Analyst at Deloitte, leveraging SQL, Power BI, Excel, Python, and automation to improve business processes.

SQL · Power BI · Python · Power Apps · Salesforce

Say hello ↗ See my work
20%
efficiency gain at Deloitte
30%
fewer data errors, same workflows
119k
records in hotel booking EDA
4+
end-to-end projects shipped
Career

Where I've worked

From uncovering insights through data analysis at Deloitte to developing scalable Power Platform solutions at Smart Technologies—each role has strengthened my ability to solve real business problems with data and technology.

Smart Technologies Outsourcing Services Pvt Ltd · Pali
Software Developer
  • Built low-code business applications using Power Apps to capture, validate, and manage structured business data across the data lifecycle, from intake through downstream reporting.
  • Automated end-to-end business processes using Power Automate, orchestrating multi-step approval flows, notifications, and data movement between SharePoint and Dataverse to reduce manual effort.
  • Partnered with business stakeholders to gather requirements and translate them into scalable Power Platform solutions, improving process efficiency for downstream teams.
Mar 2025 – Present
Current
Deloitte India Consulting Pvt Ltd · Mumbai
Analyst
  • Worked across 5+ teams optimising Salesforce CRM — automated workflows that cut manual effort by about 20%.
  • Wrote complex SQL queries that shaved 25% off report generation time and made the data more trustworthy.
  • Ran UAT cycles with the client, catching errors before they reached production — brought data error rates down by 30%.
  • Picked up Salesforce Admin and PD-1 certifications along the way.
Jan 2023 – Aug 2023
Deloitte
Portfolio

Things I've built

A mix of personal projects and client work — usually starting with messy data and ending with something that makes sense of it.

01 / Hotel Booking EDA
What makes guests cancel?
Dug into ~119k hotel booking records to understand cancellation patterns, guest behaviour, and where revenue was quietly leaking away.
94.7% cancellation rate on non-refundable bookings
50%+ drop in cancellations with special requests
Repeat guests cancel at 7.6% vs 28.3% for new ones
Python Pandas Seaborn EDA
GitHub ↗
02 / Chinook Music Store
Who's buying what, and why
SQL analysis of 10,000+ sales records to surface top genres, artist trends, and customer segments — the kind of insight a marketing team can actually act on.
Top-selling tracks & artists surfaced
5+ demographic segments identified
20% lift in LTV prediction accuracy
SQL Excel Pivot Tables Dashboard
GitHub ↗
03 / AstroSage Investment Plan
How to spend ₹1 crore wisely
Designed a structured ₹1 crore investment plan targeting customer satisfaction, operational efficiency, and long-term competitive positioning.
25% projected market reach increase
Tech upgrades + workforce upskilling roadmap
Excel Pivot Tables Business Analysis
GitHub ↗
04 / Louisiana Child Abuse App
Faster case tracking, better outcomes
Client project at Deloitte — restructured SQL and redesigned Salesforce workflows to speed up case closure and make reporting actually fast.
30% improvement in case closure time
25% reduction in report generation time
CTEs and indexing replaced slow legacy queries
Salesforce MySQL UAT Workflow Design
Toolkit

What I work with

The tools I reach for most — picked up through projects, certifications, and a lot of trial and error.

Programming & Databases
SQL MySQL Python Pandas NumPy EDA
BI & Visualisation
Power BI Excel Google Sheets Matplotlib Seaborn Pivot Tables
CRM & Low-Code
Salesforce Admin Salesforce PD-1 Power Apps Power Automate SharePoint Dataverse
The soft stuff
Critical Thinking Problem Solving Teamwork Communication Time Management
Credentials

Certifications & courses

Formal certifications that backed up what I was already learning on the job.

📊
Professional Certificate in Data Science
Newton School
Apr 2025
Data analysis, statistical modelling, visualisation, and predictive modelling across 3 real-world projects.
☁️
Salesforce Administrator
Salesforce
Aug 2023
Platform administration, configuration, and CRM management on the Salesforce ecosystem.
⚙️
Platform Developer I (PD-1)
Salesforce
Mar 2023
Apex development, Visualforce, and Lightning components — the developer side of Salesforce.
Academic

Where I studied

2018 – 2022
B.Tech — Electronics & Telecommunication Engineering
MIT Academy of Engineering
GPA 7.1 / 10
2016 – 2017
Intermediate (Class XII)
Central Academy
70.4%
2014 – 2015
Matriculation (Class X)
Central Academy
GPA 8.0 / 10
Let's connect

Say hello

I'm open to data analyst roles, freelance projects, and interesting data problems. If you've got a messy dataset, a dashboard that no one looks at, or just want to talk shop — reach out. I don't bite.

✉ dhrvkanther1@gmail.com 📞 +91 9649921415 in LinkedIn ⌥ GitHub ◈ LeetCode