Viraj Bhosale

Junior Data Analyst

Pune, India 85 · Excellent

About

Detail-oriented Data Analyst with hands-on experience collecting, cleaning, and analyzing large datasets using SQL, Python, and Power BI to uncover trends and drive business decisions. Skilled in building reports and interactive dashboards that turn raw data into actionable insights for HR, finance, and sales functions. Strong analytical mindset, attention to detail, and proven ability to communicate findings clearly to stakeholders. Eager to bring strong data wrangling and visualization skills to a fast-paced internship environment and contribute impactful, data-driven insights from day one.

Skills & Expertise (35)

SQL Advanced

8.0/10

Years Exp

Python Advanced

7.5/10

Years Exp

Power BI Advanced

7.5/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

Data Storytelling Intermediate

6.5/10

Years Exp

Presentation Intermediate

6.0/10

Years Exp

Cross-Functional Communication Intermediate

6.0/10

Years Exp

Data Validation Intermediate

6.0/10

Years Exp

Data collection Intermediate

6.0/10

Years Exp

ETL Processes Intermediate

5.5/10

Years Exp

Git Intermediate

5.0/10

Years Exp

Jupyter Notebook Intermediate

5.0/10

Years Exp

Tableau DAX Dashboard Development Trend Identification Pattern Identification VS Code GitHub Power Query Data Modelling Charts Formulas XLOOKUP VLOOKUP Pivot Tables Advanced Excel Matplotlib NumPy Pandas Subqueries Window Functions CTEs Joins MySql

Work Experience

Data Analyst

Sales Operations Dashboard

Present - Present

Collected and analyzed 64,000+ sales records using SQL and Python to build a Power BI dashboard, uncovering $1.24B in total revenue, $461.77M in profit, and a 37.4% profit margin across regions and channels. Identified key regional trends and patterns, finding California generated $228.8M in revenue (18.5% of total) while the West region delivered the highest profit margin at 37.4%, informing regional strategy insights. Developed clean, stakeholder-ready visualizations and reports to communicate revenue and profitability trends across channels.

Data Analyst

HR Attrition Analysis Dashboard

Present - Present

Cleaned and analyzed employee data to build a Power BI dashboard revealing a 16.1% overall attrition rate, identifying Sales Reps (39.8%) and under-25 employees (39.2%) as highest-risk groups. Identified critical attrition patterns: employees working overtime showed 30.5% attrition vs. 10.4% for non-overtime staff, and low earners (under $4k/month) attrited at 25.3% vs. 4% for top earners. Uncovered that 25% of attritions (59 of 237) occurred within the first year, translating data findings into an actionable retention-risk insight for stakeholders.

Data Analyst

Bank Loan Analytics

Present - Present

Queried and cleaned 38,576 loan records using SQL to track MTD/MoM KPIs, identifying a 6.9% increase in loan applications and 13% growth in funding month-over-month. Analyzed risk patterns across the dataset, finding 13.82% of loans were charged off with a notably higher average interest rate (13.88%) versus fully paid loans (11.64%), flagging an early risk indicator. Built an Excel dashboard structured around key findings, including that debt consolidation accounted for 47.2% of all loan applications.