Anirudh Yadav

Data Analyst

Hyderabad 2+ yrs exp 85 · Excellent

About

Detail-oriented Operations and Reporting Professional with 2+ years of experience in Aerospace manufacturing and workflow coordination. Skilled in managing operational activities, monitoring KPIs, and preparing reports using SAP, MS Excel, and Google Sheets. Proficient in Excel, Power Query, Power Pivot, SQL, and Power BI for data analysis, reporting, and process improvement. Strong analytical, problem-solving, and communication skills with experience collaborating with cross-functional teams to ensure operational efficiency, data accuracy, and timely execution of tasks.

Skills & Expertise (35)

SQL Intermediate

7.6/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

DAX Intermediate

6.8/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Data Extraction Intermediate

6.5/10

Years Exp

KPI Tracking Intermediate

6.0/10

Years Exp

Data Modeling Intermediate

6.0/10

Years Exp

Reporting Intermediate

6.0/10

Years Exp

Operational Reporting workflow optimization VLOOKUP Data Consolidation Exploratory data analysis Cross-functional coordination KPI Monitoring Performance Monitoring PowerPoint SAP MS Office Dashboard Development Aggregation Subqueries Joins MySql Power Pivot Power Query Data Validation Conditional Formatting Pivot Tables Countifs SUMIFS Index-match XLOOKUP

Work Experience

Data Analytics

Adventure Works

Feb 2026 - Mar 2026

Built a sales analytics dashboard to analyse $43.5M revenue and customer behaviour trends to support data-driven business decisions. Analysed 18,000+ customer transactions, 177 products, and multi-region sales data to develop KPI dashboards tracking revenue, profit margin (42.4%), and regional performance. Used SQL for data cleaning, transformation, and aggregation, and created interactive Power BI dashboards with 25+ DAX measures to monitor key performance metrics. Discovered that 80% of customers were one-time buyers, highlighting a retention opportunity, and improved report performance by reducing query execution time by ~40%.

Assistant Executive – Team Lead

Tata Advanced Systems Limited

Jan 2024 - Mar 2026

Managed day-to-day production operations and coordinated with Production Planning (PPC) and Quality teams to ensure timely execution of manufacturing activities. Tracked production status and maintained operational reports using SAP, Excel, and Google Sheets for 800+ production records, reducing reporting turnaround time from 24 hours to 2 hours. Developed KPI dashboards and standardized reporting processes, improving team efficiency and enabling data-driven decision-making. Performed data validation and quality checks to ensure reporting accuracy and process consistency. Identified operational bottlenecks and supported process improvement initiatives to enhance productivity and reduce delays. Collaborated with cross-functional stakeholders to gather requirements and optimize reporting workflows for critical aerospace production activities.