Portfolio - Dinesh Kumar Yadav

About Me

About Me
👋 Hello! I'm Dinesh Kumar Yadav
A passionate data enthusiast with a strong foundation in mathematics, actively developing expertise in Excel, Power BI, MySQL, and Python to transform data into actionable insights.

Why Choose Me?
📊 Analytical Mindset: Mathematics background enables precise problem-solving and clear analysis.
🛠️ Skilled in Data Tools: Proficient in the latest analytics tools and committed to staying ahead of industry trends.
🧮 Problem-Solver: Tackles real-world challenges with innovative, data-driven solutions.
🔍 Detail-Oriented: Ensures accurate interpretation and reporting for confident decision-making.
🌟 Passion for Growth: Driven by continuous learning and professional development.

Key Skills

SQL

Python

Power BI

Excel

Effective Communication

Problem Solving

Stakeholder Management

Team Work

My Projects

𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝟯𝟲𝟬

Domain/Function: 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝟯𝟲𝟬

AtliQ-Hospitality-Analysis

Domain/Function: AtliQ-Hospitality-Analysis

My Experience

MKS Construction Equipments – Tata Hitachi, Varanasi, Uttar Pradesh

Service Assistant Manager
Jan 2024 – Jan 2025

Automated 10+ dashboards using Power BI and Excel, reducing manual reporting time by 40% and improving KPI tracking.
Analyzed over 150 warranty and MSI claims via SQL-based reports, ensuring 100% compliance and reducing claim resolution time by 25%.
Conducted root cause analysis on service failure data, supporting maintenance strategies that cut repeat issues by 30%.
Delivered monthly executive reports with actionable recommendations, optimizing workforce planning and training outcomes.

Emeasurebox Pvt. Ltd., Patna, Bihar
Software Engineer
Aug 2022 – Nov 2022

Developed 5+ internal business modules using PHP and MySQL, improving process efficiency by 30%.
Identified backend bottlenecks and optimized SQL queries, resulting in a 40% decrease in latency and a 20% reduction in system downtime.

Saint Sita Ram Innovation Lab Pvt. Ltd., Bathinda, Punjab
IT Engineer
Apr 2022 – Aug 2022

Automated 3+ workflows using Excel macros and Python, reducing manual effort by 50%.
Streamlined onboarding systems, cutting average training time by 2 days per new hire.