Himanshu Chavhan

Analyst

Nagpur, India 0+ yrs exp 66 · Good

About

Analyst skilled in collecting, analyzing, and interpreting data to support business decision-making — supported business planning, forecasting, and performance tracking across 5 end-to-end projects including a Rs. 1.71B revenue dashboard and a 26.5% churn rate discovery. Certified by IBM and Deloitte; proficient in Excel, SQL, Power BI, and Tableau with strong ability to translate complex data into clear insights, business cases, and strategy recommendations.

Skills & Expertise

No skills listed yet

Work Experience

Analyst

Telecom

Feb 2026 - Mar 2026

Analyzed 7,032 telecom customer records using Python — identified a 26.5% overall churn rate and pinpointed month-to-month contract customers as the highest-risk segment at 42% churn, directly quantifying revenue loss risk for the business. Built 6 statistical visualizations (histogram, box plot, pie chart, bar chart) revealing Fiber Optic users and electronic check payers as priority churn segments — delivered a business intelligence report with retention recommendations including annual contract promotion and auto-pay incentives.

Analyst

Hospitality Domain

Sep 2025 - Nov 2025

Designed and built a full-scale Power BI dashboard tracking Rs. 1.71B revenue across 7 hotel properties — developed DAX measures for Occupancy % (57.87%), ADR (Rs. 12,696), and RevPAR (Rs. 7,336) with automated weekly trend reporting for management. Built the complete ETL pipeline using Power Query — extracted data from multiple raw Excel and SQL sources, performed data cleaning and transformation, and implemented Row Level Security to ensure data accuracy and stakeholder-level access control. Supported business planning and forecasting by identifying underperforming properties through RevPAR variation analysis — prepared strategy decks and business cases with pricing recommendations that directly enabled a data-driven revenue strategy across all 7 properties, improving performance and efficiency.

Analyst

HR Analytics

May 2025 - Jul 2025

Designed and executed 12 optimized SQL queries on a 303-record HR dataset — analyzed workforce attrition (41.29% in Production), recruitment source performance, and salary equity to answer critical business questions for HR leadership. Exposed a gender pay gap through statistical analysis — Male avg $70,879 vs Female $68,067 — and identified Google Search as highest-attrition recruitment source (65.2%) vs Website (7.7%); findings delivered as structured reports directly actionable for HR policy. Identified opportunities for process improvements and efficiency gains through department-level segmentation and absenteeism analysis — monitored key performance indicators and provided regular updates to management, supporting data-driven workforce planning recommendations.