Ajay Yadav
Gurgaon
Summary
Results-driven Data Analyst with 7+ years of IT experience, including 4 years in data analysis and prior experience in QA and .NET application support. Skilled in SQL, Python, Excel, and Power BI for data extraction, transformation, visualization, and reporting. Strong expertise in data validation, troubleshooting, and business insights generation.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data analyst
Tata Consultancy Services(Client - Unilever)
Gurgaon
09.2022 - Current
- Analyzed large datasets using SQL and Python to extract insights, optimize queries, and support data-driven decision-making.
- Developed interactive dashboards and reports in Power BI to visualize KPIs and business performance trends.
- Performed data cleaning, transformation, and validation using Excel and Python to ensure high data accuracy and consistency.
- Collaborated with stakeholders to gather requirements and deliver actionable insights, improving reporting efficiency and business outcomes
.NET Application Support
Tata Consultancy Services(Azure Governance portal)
Gurgaon
06.2020 - 08.2022
- Wrote and optimized SQL queries to investigate incidents, generate reports, and support business/user requests.
- Performed data validation and root cause analysis to identify discrepancies in application data and improve data accuracy.
- Maintained and monitored Azure DevOps pipelines, ensuring smooth CI/CD workflows, timely deployments, and quick resolution of build/release issues.
Manual QA Tester
Tata Consultancy Services(Client - Lloyds Bank)
Gurgaon
09.2018 - 05.2020
- Performed Manual testing of forms in Microsoft Dynamics 365, ensuring functionality, usability, and data accuracy for banking applications ensuring functionality and usability.
- Documented test results and reported issues to project management teams effectively.
- Conducted regression and UAT testing to ensure system stability after enhancements and deployments.
Education
B.Tech - Information Technology (7.94 CGPA)
YMCA University Of Science & Technology
Faridabad, Haryana08-2014
Skills
- Strong SQL query writing
- Python (Pandas, NumPy, Matplotlib, Seaborn, Data Analysis)
- Power BI (Dashboarding, DAX, data modeling)
- Advanced Excel: Pivot Tables, XLOOKUP, Power Query, Data Cleaning, Dashboarding
- Statistics (Mean, median, correlation)
- Data Cleaning & Transformation
- ETL processes(Azure data factory)
- Azure DevOps CI/CD pipelines
- Azure / Cloud Basics(Az-900 certified)
Certification
Az-900 Microsoft Certified: Azure Fundamentals
Timeline
Data analyst
Tata Consultancy Services(Client - Unilever)
09.2022 - Current
.NET Application Support
Tata Consultancy Services(Azure Governance portal)
06.2020 - 08.2022
Manual QA Tester
Tata Consultancy Services(Client - Lloyds Bank)
09.2018 - 05.2020
B.Tech - Information Technology (7.94 CGPA)
YMCA University Of Science & Technology