Summary
Overview
Work History
Education
Skills
Certification
Tools
Personal Projects
Timeline
Generic

Piyush Khadatkar

Nagpur

Summary

Experienced Microsoft support professional with 2.5 years of expertise in resolving complex technical issues, enhancing data processes, and supporting business-critical applications. Skilled in data analysis, problem-solving, and client communication, with a strong commitment to quality and compliance. Proficient in collaborating across teams to drive efficiency and deliver data-driven insights for informed decision-making.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Systems Engineer

Infosys Limited
04.2022 - Current
  • Collaborated with cross-functional teams to provide actionable insights, leveraging data analytics tools like SQL, Power BI, Dynamics CRM, and Python to drive strategic business decisions.
  • Cleansed and prepared 50+ datasets using Alteryx and Python, ensuring data accuracy and reducing data processing time by 25%.
  • Developed and delivered 25+ dashboards and reports in Power BI, enhancing data visibility and empowering stakeholders to make data-driven decisions with increased confidence and speed.
  • Provided regular status updates and insights to internal and global stakeholders across 5+ countries, effectively addressing key project requirements and resolving issues, resulting in a 20% improvement in stakeholder satisfaction.
  • Actively contributed to process improvements, identifying and implementing 5+ optimization opportunities in data handling, which led to a 20% increase in efficiency across reporting processes.

Education

B.E. - Mechanical Engineering

G.D. Rungta College of Science & Technology
Bhilai
06-2019

Skills

  • Data visualization with Power BI
  • Power Query
  • Power Pivot
  • DAX
  • Embedded Power BI
  • Extract Transform and Load (ETL)
  • Reports and Dashboards
  • Row level security (RLS)
  • SQL
  • DDL
  • DML
  • Joins
  • CTEs
  • Sub-queries
  • Window functions
  • MySQL
  • Stored Procedures
  • Views
  • Pivot tables
  • Pivot charts
  • Lookups
  • Major Excel functions
  • Excel Dashboards
  • Python
  • MS Dynamics CRM

Certification

  • Microsoft Certified: Power Platform Fundamentals (PL 900).
  • KPMG Data Analytics Virtual Internship with Forage.
  • Accenture Data Analysis and Visualization internship with Forage.
  • SQL(Intermediate) from Hacker rank.

Tools

  • Power BI
  • MySQL
  • Advanced Excel
  • Jupyter Notebook
  • VS Code
  • Tableau

Personal Projects

Mitron Bank Customers Data Analysis | Live Dashboard

  • Successfully managed data import, validation, and modeling for a 4,000-customer dataset spanning 5 cities, ensuring data quality and readiness for insightful analysis.
  • Conducted detailed analyses to identify key market trends, including Mumbai’s leading customer base (over 25%) and an average income utilization of approximately 43%.
  • Uncovered insights on customer behavior, showing a 40.74% overall credit card usage rate, with a primary focus on the 25-35 age demographic to support strategic business decisions.

Atliq Exclusive Business Insights | Live Dashboard

  • Analyzed market trends and competitive landscape in the APAC region, identifying growth opportunities projected to achieve a 30% revenue increase.
  • Utilized advanced SQL techniques, including CTEs, Window functions, and subqueries, to perform complex data analysis and extract actionable insights.
  • Quantified a significant year-over-year increase in unique product offerings for 2021, highlighting a robust expansion compared to 2020.

Timeline

Systems Engineer

Infosys Limited
04.2022 - Current

B.E. - Mechanical Engineering

G.D. Rungta College of Science & Technology
Piyush Khadatkar