About
Results-driven Data Analyst with hands-on expertise in MS SQL Server, Power BI, and Python. Skilled in building end-to-end analytical pipelines — from raw data extraction to interactive dashboards that power business decisions. Currently a final-year B.Tech student in Computer Science Engineering with a specialisation in Data Science at ABESIT, Ghaziabad. Experienced in applying AI tools and automation to accelerate analytics workflows, surface insights, and support strategic decision-making across HR, finance, and operational domains.
Experience1
Data Science Intern
May 2026 — Jun 2026SYNTECXHUB
Completed a 1-month virtual internship delivering 4 end-to-end analytical projects. Built Power BI dashboards for HR analytics and banking loan performance. Utilized MS SQL Server for data extraction, query optimisation, and complex financial data modelling. Applied Python for student performance and website traffic analysis, leveraging AI tools and prompt engineering to accelerate data workflows and insight generation.
Projects4
Bank Loan Report
Analysed 38,600+ loan applications with funded amount, repayments, interest rates, and DTI metrics. Classified loans into 'Good' (86.18%) and 'Bad' (13.82%) categories with KPI dashboards, performed trend analysis across loan status, customer segments, states, time periods, and built interactive dashboards to support lending decisions.
- MS SQL Server
- Power BI
HR Analytics Dashboard – Attrition
Analysed 1,480 employee records including salary, department, job level, age, tenure. Identified attrition patterns (16.08% attrition rate) across departments and roles, created KPIs like attrition rate, retention rate, average salary, average tenure, and correlation analysis highlighting business travel, salary slab, education field as key factors.
- Power BI
Student Performance Analysis
Processed academic dataset with marks, attendance, study behaviour; identified performance patterns across subjects and student groups using statistical exploration, visualized findings with bar, pie, and line charts delivering actionable academic insights.
- Python
- Pandas
- Matplotlib
- Seaborn
Website Traffic Analysis
Analysed traffic data including sessions, users, bounce rates, conversion funnels; evaluated top sources (organic, paid, referral), assessed engagement metrics, and created interactive dashboard presenting channel performance and content strategy insights.
- Python
- Power BI
Education2
B.Tech
2023 — 2027ABESIT, Ghaziabad
Computer Science Engineering
Class 12th
2022 — 2023United Public School, Civil Lines, Kanpur
Science