PRIYANKA CHAVHAN
Manora
Summary
Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.
Overview
1
1
year of professional experience
1
1
Certification
Work History
DATA ANALYST INTERN
EXCELR
Pune
12.2023 - 06.2024
- During my internship at ExcelR, I had the privilege of immersing myself in a fascinating realm of data analysis.
- Here are the key highlights of my experience:
- Hospitality Management: I worked extensively with hospitality-related datasets, exploring factors contributing to hotels' attrition.
- Healthcare management: Understanding age, gender, location, and other factors influencing healthcare usage. Evaluating efficiency, patient outcomes, and operational effectiveness.
- Stock Market Analysis: Analyze stock market trends, historical prices. Build predictive models for stock price forecasting and risk assessment.
- By analyzing data, I identified patterns and correlations related to attrition triggers.
- Interactive Dashboard Creation with Power BI: Using Power BI, I designed an interactive dashboard that encapsulated my analyses.
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities, such as normalization and transformation.
- Completed data cleaning and data validation of existing spreadsheets to promote a robust data management platform, resulting in accurate data analysis and entry.
- Visualizations included dynamic charts, KPIs, and drill-through capabilities.
Education
MBA - Business Analytics
Dyansagar Institute of Management
PuneB. Tech Agricultural Engineering - Agricultural Engineering
K.K. Wagh College of Engineering
Nashik, India06-2019
12 Th - Science Education
R.L.T College of Science Akola
Akola01-2015
10th - Maharashtra State Board
V.N.V. Manora
Manora01-2013
Skills
- Data Analysis & Visualization – Excel, Power BI, Tableau
- Programming & Scripting – Python (Pandas, NumPy, Matplotlib)
- Database Management – SQL (MySQL, PostgreSQL)
- Data Cleaning and Preprocessing – Python (Pandas)
- Dashboard creation
- Statistical analysis
Projects
Hospitality Management
Objective: Create an interactive Dashboard to analyze global hotels data, including ratings, revenue, capacity. AtliQ Group of Hotels, a prominent player in the hospitality industry, initiated a data analysis project focused on enhancing their hotel management strategies. Leveraging data analytics techniques, the project aimed to optimize various aspects of hotel operations including revenue management, and resource allocation. The analysis involved examining customer feedback, booking patterns, occupancy rates, and other relevant metrics to identify trends and patterns. By implementing data-driven insights, the AtliQ Group aimed to streamline operations, improve service quality, and ultimately enhance the overall guest experience.
Healthcare Management
In the realm of healthcare management, particularly in the context of dialysis services, this project aimed to improve patient outcomes and operational efficiency Leveraging data analytics, the project team conducted an in-depth analysis of patient demographics, treatment protocols, clinical outcomes, resource utilization, and cost management within dialysis centers By analyzing these key metrics, the project sought to identify opportunities for enhancing service delivery, optimizing resource allocation, and reducing healthcare costs The ultimate goal was to improve the quality of care provided to dialysis patients while ensuring the sustainability and effectiveness of healthcare operations.
Certification
- Data Analyst Certificate by ExcelR
- Data Analyst Internship Certificate( AI variant )12/2023- 06/2024
Languages
Marathi
First Language
English
Upper Intermediate (B2)
B2
Hindi
Advanced (C1)
C1
Stock Market Analysis
Analyzed historical stock market data to identify trends and patterns.
Performed data cleaning, visualization, and statistical analysis.
Applied time series forecasting and predictive modeling to assess stock performance.
Used SQL to query financial data and create insights from large datasets.
Presented findings through interactive dashboards in Excel,Tableau,Power BI.
Timeline
DATA ANALYST INTERN
EXCELR
12.2023 - 06.2024
MBA - Business Analytics
Dyansagar Institute of Management
B. Tech Agricultural Engineering - Agricultural Engineering
K.K. Wagh College of Engineering
12 Th - Science Education
R.L.T College of Science Akola
10th - Maharashtra State Board
V.N.V. Manora
Similar Profiles
ATHARVRAJ CHAVANATHARVRAJ CHAVAN
Hospitality Analysis - Intern at ExcelrHospitality Analysis - Intern at Excelr
Shana Sherin M KShana Sherin M K
Data Analyst at ExcelrData Analyst at Excelr
Amutha NAmutha N
LMS Administrator at ExcelRLMS Administrator at ExcelR