About
Computer Engineering graduate (CGPA 9.15/10) and aspiring Data Analyst with hands-on experience turning large, messy datasets into clear business decisions. Skilled in SQL and MySQL (JOINs, subqueries, window functions), Python (pandas, NumPy) for data cleaning, and building interactive dashboards in Power BI, Tableau and Advanced Excel. Project work has delivered measurable business impact, including isolating approximately $9.6M in recoverable transaction value and diagnosing a mis-set SLA affecting $5.4M in premium revenue. Certified in SQL Mastery, Advanced Excel, Power BI and Tableau. Currently enrolled in the Data Science and Analytics with AI programme at I.T. Vedant Institute.
Skills & Expertise (49)
Work Experience
Data Analyst
Navi Mumbai Real Estate Analytics
Present - Present
Built a complete data pipeline: scraped 722 live property listings with Python (requests, BeautifulSoup) after checking robots.txt, then cleaned in pandas and NumPy (parsing Crore/Lakh prices, extracting BHK and locality from titles, handling missing values). Stored the data in a MySQL relational schema and built interactive Power BI dashboards with a map, key influencers, and a decomposition tree. Surfaced actionable value insights, for example Seawoods at about Rs 32,000/sqft versus Panvel and Taloja at roughly Rs 8,000 to 10,000, with 82% of listings being new construction.
Data Analyst
Merchant Portfolio Performance Analysis
Present - Present
Analysed a 50,000-transaction merchant portfolio to diagnose an 11% decline rate; cleaned and verified the data (removed duplicates, standardised category labels, handled missing values) before trusting any number. Broke declines down by category and channel, then examined their interaction to isolate Online Travel at a 59% decline rate, about 6.6x the roughly 9% portfolio baseline. Traced the cause to a mis-set risk/decline rule rather than fraud or customer behaviour, quantifying approximately $9.6M in recoverable transaction value and recommending a targeted rule review.
Data Analyst
Supply Chain Delivery Performance Analysis
Present - Present
Analysed 62,897 e-commerce orders ($35.2M revenue) to diagnose a 57.3% late-delivery rate, building a two-page interactive dashboard with global filters and cross-chart actions. Rebuilt the late-delivery flag from raw shipping dates to validate it (97.6% match), exposing 7,754 mislabelled cancelled shipments and correcting the reported late rate from 54.8% to 57.3%. Isolated the driver as a mis-set SLA, with First Class shipping in 2 days against a 1-day promise (100% failure on $5.4M premium revenue), and recommended resetting the SLA at zero operational cost.
Data Analyst
Credit Card Risk and Customer Analysis
Present - Present
Analysed 10,127 credit-card customers to assess spending behaviour, credit utilisation and churn risk, addressing a 16.1% annual attrition problem. Engineered a weighted risk score using nested IF/OR logic and built 9 PivotTables with GETPIVOTDATA KPI cards and 8 PivotCharts across two interactive dashboards; identified the segments driving attrition.
Data Analyst
Formula 1 Data Analysis
Present - Present
Loaded and cleaned a 600K+ row, 8-table relational dataset, converting raw CSVs and standardising nulls and data types for accurate aggregation. Built 15 analytical queries (JOINs, GROUP BY / HAVING, subqueries, window functions) to analyse win patterns and historical trends, documenting each with methods and business-style insights.
Education
Data Science & Analytics with AI - I.T. Vedant Institute
2026 - · India
B.E. Computer Engineering - Ramrao Adik Institute of Technology
2020 - 2023 · India
Diploma in Computer Engineering - Dr. D. Y. Patil Polytechnic
2017 - 2020 · India
Xth Standard - D. A. V. Public School
2016 - 2017 · India
Certifications
Power BI Essentials
I.T. Vedant Institute · 2026
Tableau Essentials
I.T. Vedant Institute · 2026
SQL Mastery
I.T. Vedant Institute · 2026
Advanced Excel
I.T. Vedant Institute · 2026
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
Skills (49)
Click a skill to find developers with the same skill
