PRATIK SHINDE
Data Analyst
+91-818******* ****************@*****.*** linkedin.com
SUMMARY
Entry-level Data Analyst with strong analytical and problem-solving skills.Proficient in Excel,Power BI, SQL, and Python for data cleaning, analysis, and visualization.Quick learner with a keen interest in data analysis and visualization.
EDUCATION
Master of Computer Applications, Sandip University. Present Bachelor of Computer Science, Savitribai Phule Pune University.
(K.K.Wagh ACSCS College, Nashik) Sep 2021 - Jun 2024 SKILLS
Languages: Python, SQL, PostgreSQL, R, PHP, HTML/CSS Concepts: Pivot Tables, Data Analysis, Data Visualization, Dashboard Design,Power Query, KPI Design. Tools: Power BI, Tableau, MS Excel, Jupyter Noytebook, Pycharm, VS code. PROJECTS
Amazon Sales Analysis Dashboard:
• Designed and developed an interactive Power BI dashboard to analyze Amazon product sales and reviews.
• Integrated and transformed raw sales data to generate YTD and QTD performance metrics.
• Built dynamic visualizations including sales by month, sales by category, top products by sales reviews, and weekly price trends.
Blinkit Sales Analysis Dashbaord:
• Developed an interactive Power BI dashboard to analyze Blinkit’s sales, product performance, outlet distribu- tion, and customer ratings.
• Used DAX calculations to create KPIs for total sales, average sales, total items, and average ratings.
• Implemented slicers and filters for location type, outlet size, and item type to enable flexible analysis. Hotel Booking Cancellations:
• Built an interactive dashboard to analyze hotel booking data, differentiating City Hotels vs. Resort Hotels.
• Used Pivot Tables, slicers, and charts to track total vs. cancelled bookings.
• Segmented guest types (family, couple, single) to identify occupancy patterns. CERTIFICATIONS
• GenAI Powered Data Analytics Job Simulation. Python for Data Science:Visualization using Seaborn.
• Deloitte Australia Data Analytics Job Simulation. Udemy’s Machine Learning Online Course.
• Quantium Data Analytics Job Simulation.
CURRICULAR ACTIVITIES
• Attended the CyberSakshar’s Cybersecurity Awareness Workshop in which it enhanced awareness of cyber laws,digital ethics,cybercrime and many others which is Conducted on (DEC 2021)