Saurabh Yadav

Data & BI Analyst currently interning at Jindal Steel Limited, delivering Power BI dashboards and cross-department KPI reporting for plant-level operations. Skilled in Power BI, SQL, Python and Advanced Excel, with hands-on ETL (Power Query) and a track record of turning operational data into trends, variances and improvement opportunities for leadership. Comfortable collaborating with cross-functional plant teams to map processes and surface actionable insight.

Actively upskilling in Qlik Sense. B.Tech Computer Science, 2026.

Data Analyst Intern, IT Department at Jindal Steel Limited (2026-03 – Present)

Enterprise steel manufacturer; delivered BI dashboards and cross-department KPI reporting for plant-level IT and workshop operations.

• Built and shipped a 10-page executive Power BI dashboard over 77 live IT projects (6 modules, 2 plants, 4 IT owners), delivering interactive, focused reporting that replaced scattered manual trackers as the single source of truth for weekly leadership reviews.
• Built a live Google Sheets-to-Power BI ETL pipeline in Power Query (M) with scheduled refresh to collect, organize and integrate data from multiple sources, eliminating the entire weekly manual data-prep cycle.
• Analyzed 25+ KPIs to surface trends and variances — a 51.9% SLA breach (48.1% vs. 80% target) and 40 overdue projects (37 in the >90-day bucket) — driving leadership escalation and owner-wise improvement actions.
• Engineered a composite Delivery Excellence Score (0–100) from weighted DAX measures (Timeliness, Completion Rate, Delay Control), compressing 25+ KPIs into one board-level metric benchmarked at 70/100 vs. an 80 target.
• Delivered the analytics and reporting layer of an enterprise platform serving 10+ cross-functional plant departments, interpreting KPIs across departments to identify trends, variances and improvement areas for management review.
• Collaborated with departmental stakeholders to map monthly workshop processes and structure the data behind best practices, repetitive problems and improvement actions, sourced from a PostgreSQL schema of 21 relational tables.
• Defined 3 core plant KPIs (submission completion, problem resolution, on-time action) rolled up into composite Plant Health Score and Workshop Readiness indices via a database-configurable KPI engine.
• Automated recurring reporting into PowerPoint, PDF and Excel from a single unified data model, guaranteeing identical figures across formats and eliminating manual monthly deck collation.

B.Tech in Computer Science & Engineering – Rajkiya Engineering College, Sonbhadra (2022-11 – 2026-06)