About Me
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.
Skills & Technologies
Work Experience
Data Science Intern
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.
Projects
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.
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.
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.
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.
Education
B.Tech
Computer Science Engineering
Class 12th
Science