Back to Developers
Aditya yadav

Aditya yadav

Data Analyst

New Delhi, India 4+ yrs exp 90 · Outstanding

About

Data Analyst with 4+ years building ETL pipelines, Power BI / Tableau dashboards, and MIS reporting systems that drive operational decisions — cutting manual reporting by 50%, lifting data accuracy to 99%, and surfacing ₹8L+ in annual cost savings. Skilled in SQL, Python, data warehousing (star schema, fact/dimension tables), and cross-functional stakeholder analytics across aviation maintenance operations.

Skills & Expertise (19)

Power BI Advanced
8.1/10
4
Years Exp
SQL Advanced
8.1/10
4
Years Exp
Python Advanced
8.0/10
4
Years Exp
Pandas Advanced
8.0/10
4
Years Exp
ETL Pipeline Design Advanced
8.0/10
4
Years Exp
Root Cause Analysis Advanced
8.0/10
4
Years Exp
NumPy Advanced
7.8/10
4
Years Exp
Data Warehousing Advanced
7.8/10
4
Years Exp
Data Validation Intermediate
7.5/10
4
Years Exp
Azure Intermediate
7.5/10
4
Years Exp
Predictive Analysis Intermediate
7.5/10
4
Years Exp
trend forecasting Intermediate
7.5/10
4
Years Exp
Hypothesis Testing Intermediate
7.5/10
4
Years Exp
A/B testing Intermediate
7.5/10
4
Years Exp
KPI Design Intermediate
7.5/10
4
Years Exp
API Integration Intermediate
7.5/10
4
Years Exp
Tableau Intermediate
7.5/10
4
Years Exp
ERP Systems Intermediate
7.0/10
4
Years Exp
Excel

Work Experience

Data Analyst

Veyron — Aviation Maintenance Software

Nov 2021 - Present

Saved 30+ hours/month for a 6-person ops team by automating 12+ daily, weekly, and monthly MIS reports — replacing manual SQL pulls with scheduled ETL pipelines and self-service Power BI dashboards. Lifted ERP master data accuracy from 92% to 99% across ~150K component records by implementing field-level validation rules, data dictionaries, and reconciliation logic aligned to data governance standards. Surfaced ₹8L+ in avoidable annual part-replacement costs by performing root cause analysis on MTBF degradation trends — correlating unscheduled removal data with vendor and component-level reliability signals. Cut data transformation time by 35% and server load by 20% by redesigning SQL ETL pipelines — migrating flat-file extraction to API-driven data integration across 4 operational source systems. Accelerated executive reporting delivery by 40% by building a standardised MIS performance pack pipeline pulling from validated data warehouse sources — enabling SLA, productivity, and fleet efficiency decisions within hours of period close. Built 5 real-time Power BI dashboards tracking operational KPIs across maintenance, procurement, and pricing — cutting leadership decision-response time from days to hours for 3 cross-functional teams. Designed star schema structures (fact and dimension tables) for component reliability and maintenance events within the operational data warehouse — enabling consistent, reusable KPI reporting across fleet engineering. Increased analytics self-service adoption by ~60% by translating stakeholder requirements into Tableau views — reducing routine analyst dependency for 4 non-technical business users. Validated data integrity and documented current-state ETL data flows for Azure pipeline migration planning — mapping star schema and field transformations in a staging environment prior to cut-over. Delivered statistically significant findings for 2 process-change initiatives using A/B testing and hypothesis testing — one recommendation adopted fleet-wide by operations leadership.

Data Analyst — Contract Project

The Sparks Foundation

Aug 2021 - Sep 2021

Identified 3 revenue-impacting patterns — including a 22% seasonal dip in a single product segment — through exploratory data analysis in Python (Pandas, NumPy), directly informing post-project business recommendations. Delivered a forecasting and trend analysis report with interactive visualisations — enabling non-technical stakeholders to make data-driven decisions independently without analyst support.

Education

Bachelor of Technology — Computer Science - J.C. Bose University (YMCA)

2017 - 2021 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceAug 2026