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