Kushagra Bhatnagar

Certified Microsoft Power BI Data Analyst Associate® and accomplished Analyst with over 2 years of experience in data validation, analysis, and visualization. Proficient in transforming complex datasets into actionable insights through dynamic dashboards and interactive visualizations. Skilled in collaborating with cross-functional teams and clients to identify requirements, risks, optimize workflows, and drive data-driven decision-making.

Experienced in conducting detailed audits to ensure data accuracy, integrity, and compliance with organizational and regulatory standards. Demonstrated expertise in freelancing projects, delivering tailored solutions to global clients, and resolving advanced data visualization challenges. Adept at leveraging AI-driven tools to enhance data processing and analytics efficiency.

Analyst - 3 at Ernst and Young

• Collaborated with clients to gather requirements and evaluate operational workflows, proactively identifying risks and recommending process improvements.
• Conducted systematic audits of data, processes, methodologies, and systems to ensure accuracy, integrity, consistency, and compliance, resulting in a 30-hour monthly reduction in processing time.
• Created and validated SQL scripts and parameters to ensure accurate client data, eliminate inappropriate parameter usage, and rectify irrelevant data issues, resulting in enhanced efficiency and precise output delivery.
• Worked extensively with SQL joins, window functions, CTEs, and subqueries to perform complex data transformations and analytical computations.
• Conducted Power BI training workshops, empowering business users with self-service analytics by educating them on dashboard navigation, troubleshooting, and incorporating new business requirements.
• Proposed improved visualizations by critically thinking for existing tabular reports, achieving a 30% increase in clarity.
• Utilized advanced Excel functions, along with conditional formatting and data validation, to perform in-depth variance analysis, verify process adherence, and identify deviations from standards reducing manual work by 2 hours.
• Designed and developed interactive Power BI dashboards using DAX, Power Query, and data modeling, enabling real-time KPI tracking and business performance analysis for stakeholders.
• Optimized Power BI reports by implementing query optimization, aggregations, and row-level security (RLS), reducing data load time by 30% and ensuring secure access to insights.
• Integrated multiple data sources (SQL, Excel, API) with ETL process and Power Automate, automating dataflows and report updates, improving reporting efficiency by 40%.
• Transformed static tabular reports into interactive Power BI dashboards, improving clarity and user engagement by 20% through data storytelling, custom visuals, drill-throughs, and bookmarks.

Freelance consultant

• Delivered end-to-end data solutions using Power BI, Excel, and Tableau, reducing project turnaround time by 20%, while designing user-friendly dashboards for global clients, improving user satisfaction by 15%.  Optimized dashboard performance by addressing query, data display, and visualization issues, improving loading speed and user experience. Mentored peers and led part-time projects, boosting team productivity by 30%.

B.tech in Computer Science The Northcap University , Gurgaon