MCA graduate (CGPA 8.70) with hands-on internship experience building Power BI and Tableau dashboards on 65K+ real-world loan records at AiVariant. Proficient in SQL, DAX, Power Query and Python — translating complex datasets into actionable business insights.
Built a Power BI Manufacturing Dashboard tracking 86.7M+ units across 4 KPIs including rejection rate, wastage percentage and processed quantity. Identified machine C007 as the top rejection source with 33,660 rejected units, enabling targeted quality control and reducing overall wastage to 0.61%. Performed data cleaning and transformation using SQL and Python, standardizing records across machine-wise, employee-wise and department-wise dimensions.
Developed 10+ DAX measures in Power BI to analyze 18 seasons of IPL data, tracking team standings, player performance and match KPIs across 74 matches and 10 teams with interactive season-wise filters. Built interactive visualizations for Points Table, Orange Cap, Purple Cap and player-wise batting and bowling KPIs using slicers and dynamic filters, enabling season-wise drill-down analysis across 18 IPL seasons.
End-to-end analytics solution processing 65K+ loan records. Built 3 interactive dashboards in Power BI and Tableau tracking 8 KPIs including delinquency rate and default metrics. Developed 15+ DAX measures and an ETL pipeline that cut data preparation time by 30%.
Continuously explores real-world datasets and case studies using SQL and Python to develop BI solutions and deepen understanding of data patterns across industries.
MCA graduate and Data Analyst Intern at AiVariant, actively seeking full-time Data Analyst roles. I bring hands-on experience in Power BI, Tableau, SQL and Python — ready to deliver real impact from day one. Let's connect!