PRASHANT GORADE's Resume

PRASHANT GORADE
Pune MH | +91 7719992361 |prashant24gorade@gmail.com |LinkedIn

CAREER OBJECTIVE
To be associated with a dynamic and progressive organization that will allow me to utilize my abilities and qualifications in the field to
add value to the organization while providing me with opportunities for growth.
PROFESSIONAL SUMMARY
 REPORTING DATA ANALYST with 13+ months of experience in designing analytical reports.
 Extensive knowledge in Data analysis, Designing Interactive Dashboards/Reportsand Data Modelling of Star.
 Enhancing the load time for Power BI reports by 40% through performance tuning of the data model and the DAX queries using
DAX STUDIO.
 Performing complex SQL queries in extracting data & Worked on various types of transformations that are available in power query.
 Worked with Power BI services. Worked on creating dashboards, dataset refreshthrough gateways.
 Analyse current ETL process, define and design new systems.
PROFESSIONAL EXPERIENCE
SYNGENTA INDIA PVT. LTD, Pune | REPORTING ANALYST | Mar 2023 – Sept 2023
Project 1: Group People Insights and Analytics | Domain: Human Resource
Description:
 In this project we were supposed to analyse the availabity and need of workforce in company worldwide.
 Create and manage Global dashboard for senior leadership to get insights of overall performance of variousplants worldwide.
Responsibilities:
● Creating bar charts for month wise Employees analysis.
● Calculating wastage % with actual waste per total Production.
● Scheduling daily refresh over power bi service where the data is loading from SQL / EXCEL.
● Creating and Maintaining KPI dashboard reports in Power BI based on assessment data and other manufacturing datagenerated 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.
AI Variant, Bangalore | Intern Data Analyst | July 2022- Dec 2022

Project 1: Flight delay Analysis
Description:
 This project involved a comprehensive analysis of flight delays, aiming to identify patterns and factors contributing to delays in a major
airline's operations. This project involved the utilization of advanced data analytics techniques and tools to derive meaningful insights.
Responsibilities:
 Gathered extensive flight data from various sources, including airline databases and public datasets.
 Conducted thorough data cleaning and preprocessing to ensure accuracy and consistency in the dataset.
 Conducted EDA to uncover initial trends and patterns in flight delay data.
 Utilized visualization techniques to present key findings effectively.
 Conducted in-depth root cause analysis to pinpoint underlying reasons for delays, including factors within the airline's control and
external variables.
 Generated actionable insights and recommendations based on the analysis to mitigate delays.
 Presented findings and recommendations to the team and stakeholders through visual reports and presentations.
Project 2: Patient Diagnosis Analysis

Description:
 This project involved a comprehensive analysis of healthcare patient diagnoses, with the aim of identifying patterns and factors
contributing to various medical conditions. The analysis utilized advanced data analytics techniques and tools to derive meaningful
insights.
Responsibilities:
 Gathered extensive patient diagnosis data from various sources, like health records, medical databases, public health datasets
 Conducted thorough data cleaning and preprocessing to ensure accuracy and consistency in the dataset. This included handling missing
values, removing duplicates, and standardizing data formats.
 Utilized visualization techniques to present key findings effectively. This included creating various types of charts (e.g., bar charts,
scatter plots) to visually represent the prevalence of different medical conditions.
 Generated actionable insights and recommendations based on the analysis to improve patient diagnosis accuracy and treatment
planning. This may include suggestions for diagnostic protocols, patient monitoring, and treatment strategies.
 Implemented a system for continuous monitoring of patient diagnoses, allowing for ongoing analysis and improvement of diagnostic
processes based on emerging trends and patterns.
TECHNICAL SKILLS
 Microsoft Power BI  Python
 MS SQL Server  Pandas, NumPy
 SQL, T-SQL  MS Excel (VLOOKUP, XLOOKUP, PIVOT TABLE
EDUCATION
University: Pune University, Pune |July 2017- Dec 2020 |
Degree: Bachelor of Business Administration in Human Resource Management
Declaration
I hereby declare that the information given above is true to the best of my knowledge.
Date: 20-11-2023
Place: Pune Name: Prashant Gorade

PRASHANT GORADE's Resume

Uploaded by

Copyright:

Available Formats

PRASHANT GORADE's Resume

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

PRASHANT GORADE's Resume

Uploaded by

Copyright:

Available Formats

PRASHANT GORADE

Pune MH | +91 7719992361 |prashant24gorade@gmail.com |LinkedIn

AI Variant, Bangalore | Intern Data Analyst | July 2022- Dec 2022

Project 2: Patient Diagnosis Analysis

You might also like