About
Results-driven Data Analyst with a Bachelor’s degree in Statistics (CGPA: 8.47) and hands-on experience in Python, SQL, Power BI, Excel, Tableau, and Business Intelligence. Skilled in data cleaning, preprocessing, transformation, ETL, exploratory data analysis (EDA), statistical analysis, data modeling, DAX, KPI reporting, dashboard development, data visualization, Web Scraping, PDF Data Extraction, API Integration, Data Wrangling, Data Validation, and Data Pipelines. Experienced in transforming complex datasets into actionable business insights through SQL analysis, interactive dashboards, and data-driven reporting. Familiar with AWS, Snowflake, Artificial Intelligence (AI), and Prompt Engineering. Fundamental understanding of Machine Learning concepts including Regression, Classification, and Clustering.
Skills & Expertise (71)
Work Experience
Data Analyst
Airbnb
Present - Present
Developed an end-to-end interactive Power BI dashboard to analyze listing performance, pricing trends, host activity, customer reviews, property types, room types, and city-wise market insights. Performed data cleaning, transformation, ETL, and data modeling using Power Query and structured the dataset using a Star Schema for efficient reporting. Developed dynamic DAX measures and KPI calculations and implemented slicers, drill-through, cross-filtering, bookmarks, and interactive visualizations. Analyzed customer review patterns, host verification, property distribution, pricing trends, and geographical performance to derive actionable business and customer insights.
Data Analyst
Loan Risk Analytics
Present - Present
Developed an end-to-end loan portfolio and risk analytics dashboard by integrating SQL Server with Power BI to analyze loan applications, funded amounts, repayments, defaults, and customer risk segments. Used SQL for data extraction, filtering, aggregation, and analysis and Power Query for ETL and data transformation. Designed a Star Schema data model and developed advanced DAX measures using CALCULATE, FILTER, SUMX, AVERAGEX, DIVIDE, and SWITCH for KPI and risk calculations. Built interactive dashboards to monitor loan amount, default rate, credit score, income, employment type, mortgage status, and YOY/YTD performance using slicers, drill-through, bookmarks, and interactive visuals.
Data Analyst
Hospital Emergency Room
Present - Present
Developed an interactive Excel dashboard to analyze patient flow, operational efficiency, department performance, and patient experience. Used Power Query for data cleaning and transformation and Power Pivot for data modeling and analytical reporting. Built Pivot Tables, Pivot Charts, and Slicers to analyze patient admissions, waiting time, satisfaction scores, referrals, department performance, and age/gender distribution. Developed operational KPIs including total patient volume, average waiting time, patient satisfaction, and patients attended within 30 minutes.
Education
Master of Science in Statistics - Savitribai Phule Pune University, Pune
2026 - 2028 · India
Bachelor of Science in Statistics - Sir Parashurambhau College (Autonomous), Pune
2022 - 2025 · India
Certifications
Data Analyst Bootcamp From Basic To Advanced
Krishnaik Academy · 2026
Completed the Data Analyst Bootcamp by Krish Naik, gaining practical knowledge of the complete data analytics workflow. Covered Python for data analysis, NumPy, Pandas, data cleaning, exploratory data analysis (EDA), data visualization, SQL, Excel, Power BI, statistics, and real-world data analytics projects. Developed hands-on experience in cleaning and transforming datasets, identifying patterns and trends, performing statistical analysis, creating interactive dashboards, and generating actionable business insights from data.
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
Skills (71)
Click a skill to find developers with the same skill
