Data Analyst

Job description

PROSENJEET DEY
+91 9381822626 | prosenjeetdey1@gmail.com| LinkedIn
Skills
• Microsoft Power BI
• SQL (SQL Server, MySQL)
• Python (Pandas)
• Excel
Projects
Payment Data Analysis
July 2024
• Conducted comprehensive analysis of payment behaviors using Python and Power BI, focusing on debit cards, PayPal, and
credit cards.
• Cleaned and processed data from Kaggle, ensuring accuracy for detailed insights into transaction patterns and consumer
spending habits.
• Provided regional preferences and peak usage periods through Power BI visualizations, highlighting significant trends.
• Recommended offering discounts on credit card purchases and focusing on electronics to boost sales and customer
satisfaction.
Amazon Sales Analysis
June 2024
• Analyzed Amazon sales data using Python and Power BI to identify key trends and consumer purchasing behaviors.
• Cleaned and processed the dataset from Kaggle, ensuring data accuracy and reliability for robust analysis.
• Utilized descriptive visualizations to uncover peak sales segments, popular product categories, and regional preferences.
• Identified five top profit-generating products and provided actionable recommendations to optimize marketing strategies
and inventory management, leading to improved business performance.
PM Country Visits Analysis
May 2024
• Analyzed PM Modi’s international visits using MySQL for table joins and data analysis, focusing on visit frequency, duration,
and budget allocation.
• Employed Python to clean the data by renaming columns and performing calculations, identifying the United States as the
most visited country with the highest number of days.
• Used Power BI for advanced visualizations to analyze the distribution of days spent and published the findings on the
Power BI website.
• Revealed total spending of 4 billion rupees on these visits, highlighting significant budget allocations for the most visited
destinations.
Internships
Forage Accenture - Data Analytics and Visualizations
June 2024
• Created an up-to-date big data best practices presentation with audio elements, focusing on optimizing data management
and processing techniques.
• Extracted sample data sets using SQL queries, capturing diverse post interactions and reaction types for detailed analysis.
• Merged sample data sets and identified key insights: 16 categories analyzed, with "Animals" having the highest
engagement score of 149,000; May recorded the highest volume of posts.
Education B.Sc in Biotechnology Bangalore University – Bangalore, Karnataka August 2019 - August 202