Prashant Gorade Email & Phone Number

Experienced Power BI Developer and Business Analyst with over 2 years of expertise in data analysis, interactive dashboard design, and business intelligence. I specialize in transforming complex datasets into actionable insights using Power BI, DAX, SQL, and T-SQL, helping organizations optimize decision-making processes. I have a proven track record of enhancing report performance by up to 40% through model optimization and performance tuning.I am skilled in end-to-end BI project execution, from requirement gathering to data extraction, modeling, and visualization. My experience spans across industries, including financial services and sales analysis, with a focus on delivering strategic insights that drive business growth. Additionally, I have implemented Row-Level Security (RLS) and optimized ETL processes to ensure data integrity and security.Passionate about data-driven decision-making, I’m committed to leveraging business intelligence tools to solve complex challenges and improve operational efficiency. Let's connect to discuss how data can empower your business!

• Power Bi Developer

  Bny Mellon Pvt. Ltd

  2022 - Present

  Project: Insurance Claims Analysis Domain: Sales Analysis.Description: This report is designed to analyse and visualize overall information related to sales for sales leaders and management to improve strategic planning. A variety of KPI's tracked on the four majors: Sales values, Product categories, Sales executives, and new customers as it is having a major focus to grow these accounts.Responsibilities:● Creating bar charts for month wise production as well as wastage analysis.● Using matrix table creating machine wise production, day wise production.● Calculation wastage % with actual waste per total Production.● Scheduling daily refresh over power bi service where the data is loading from SQL.● Creating and Maintaining Power BI reports based on assessment data and other manufacturing data generated globally across the plants.● Resolution of bugs and defects identified, Root cause analysis and providing optimized solution● Implementation of Row Level Security by defining various constraints for each defined role● Redefine and make technical/strategic changes to enhance existing Business Intelligence systems.

• 

  Modern Education Society'S Ness Wadia College Of Commerce, Pune

  Data Analytics And Visualization