Yashvardhan Patil

Experience

• 

  Square Yards

  Apr 2022 - Jan 2023

  Management Information System Executive

  Regulatory Reporting and Data Management: Utilized Excel to support senior management in preparing and managing regulatory filings and inquiries, ensuring accuracy and timeliness. Implemented data management practices that enhanced compliance and streamlined reporting processes.MIS Enhancement and Support: Improved the efficiency and effectiveness of Management Information Systems by developing custom reports and dashboards, providing actionable insights to support strategic decision-making.

• 

  ExcelR

  Jul 2023 - Dec 2023

  Data/Business Analyst Intern

  Developed and implemented comprehensive financial analysis KPIs utilizing Excel, MySQL, Power BI, andTableau for a bank loan customer dataset comprising 1000000+ records, focusing on loan amounts, payment verification, geographic trends. Designed and deployed a Supply Chain Dashboard, featuring vital KPIs such as total sales tracking (MTD, QTD,YTD), product-wise sales analysis, and sales trends across regions and stores, showcasing expertise in supply chain analytics and visualization.Developed reports or created dashboards, providing financial-related information to make informed business decisions. Created Dashboard in Microsoft Power BI & Tableau to drive accuracy of insightfully reporting solutions. Developed reports using SQL queries to track progress against key performance indicators. Show less

• 

  Omni-Bridge Solutions

  Mar 2024 - Jul 2024

  #Engaged in an end-to-end project involving Pune Municipal Corporation (PMC) finance data and Occupancy Report data. Utilizing various techniques such as data cleaning, data transformation, and data visualization to enhance data quality and usability using tools such as Microsoft Power BI, Advance MS-Excel, SQL, and Python.# Focused on creating dynamic dashboards tailored for finance data and Occupancy Report data, enabling comprehensive analysis and insights. #Actively involved in all stages of the project, from data preprocessing to dashboard development, ensuring seamless execution and delivery, leveraging tools like Microsoft Power BI, Advance MS-Excel, SQL, and Python. Show less

  • Data Analyst

    Feb 2024 - Jul 2024

  • Data Analyst Intern

    Mar 2024 - Jun 2024