Ayush Prajapat

Data Analyst with hands-on experience analyzing 100K+ records using SQL, Excel, Python, and Power BI. Skilled in building interactive Power BI dashboards, automating MIS reports, performing data cleaning, validation, ETL processes, trend analysis, KPI monitoring, and delivering actionable business insights. Strong foundation in Advanced Excel, SQL, stakeholder collaboration, and reporting automation, seeking to contribute to data-driven decision-making.

Data Analyst Intern at Hero MotoCorp (2024-06 – 2024-08)

• Analyzed 100K+ operational and sales records using SQL, Excel, and Power BI to identify KPI trends, reporting gaps, and performance drivers, enabling faster management decision-making.
• Developed 5+ interactive Power BI dashboards and automated recurring Excel reports, reducing manual reporting effort by approximately 30% while improving reporting accuracy.
• Performed data cleaning, validation, and transformation to improve data quality, collaborated with stakeholders to understand reporting requirements, and delivered reliable KPI dashboards.

B.Tech in Artificial Intelligence – Gurugram University (2023 – 2026)

Diploma in Computer Science Engineering – Guru Brahmanand Polytechnic (2020 – 2023)

Senior Secondary (12th)

Secondary (10th)