Yash Patil
Data Analyst
About
Analytical professional with experience in SQL, Oracle applications, reporting, and data management. Skilled in data extraction, report creation, data validation, and business analysis to drive operational insights. Experienced in working with complex datasets, troubleshooting data issues, and translating business requirements into data-backed solutions. Passionate about analytics, business intelligence, and leveraging data for informed decision-making.
Skills & Expertise (36)
Work Experience
Data Analyst
Tech Mahindra
Jun 2024 - Present
Spearheaded end-to-end data analysis and reporting for Fanatics, a global sports licensed merchandise platform, supporting HR and workforce intelligence for 10,000+ employees across multiple regions. Engineered and maintained 15+ automated SQL/Python data pipelines to extract, clean, and transform HCM data, reducing manual data processing time by 40%. Designed and published 12+ interactive Power BI dashboards tracking key HR KPIs — headcount trends, attrition rates, payroll summaries, and workforce demographics — enabling real-time executive decision-making. Developed BI Publisher reports for payroll compliance, employee demographics, and HR audit use cases with scheduled automated delivery to 20+ business stakeholders. Wrote advanced SQL and PL/SQL queries including CTEs, window functions, and stored procedures to support complex data extraction and transformation from Oracle HCM Cloud and Oracle Database. Performed exploratory data analysis (EDA) using Python (Pandas, NumPy, Matplotlib, Seaborn) to identify workforce trends, outliers, and data quality gaps, directly informing HR strategy. Conducted data quality audits and root-cause analysis across 10+ weekly data feeds, achieving a data accuracy rate exceeding 98% for client-facing reports. Collaborated with functional HR, payroll, and finance teams at Fanatics to gather requirements, define KPIs, and deliver self-service analytics solutions reducing ad-hoc reporting requests by 30%. Maintained and documented data dictionaries, ETL logic, and process flows to ensure data lineage transparency and support team knowledge transfer.
Engineer Trainee
Cognizant Technology Solutions
Mar 2024 - Jun 2024
Completed intensive training in Cloud Infrastructure Services, covering deployment models, cloud storage, and enterprise IT architecture. Gained foundational exposure to data management on cloud platforms and enterprise application workflows.
Education
Bachelor of Technology in Computer Engineering - Government College of Engineering, Jalgaon
2019 - 2023 · Afghanistan
Certifications
Oracle AI Cloud Database Services 2025 Certified Professional
Oracle · 2025
AI White Belt
TechM · 2025
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
Skills (36)
Click a skill to find developers with the same skill
