Soumesh Bhaumik

I'm an Electrical Engineering graduate with experience in data analysis using MS Excel, SQL, and Python. During my internship at a
multinational corporation, I worked with databases like MySQL and Teradata. My passion is using my skills to provide valuable insights
and optimize business operations.

• Microsoft Excel from Beginner to Advanced, 09/2022
• The Ultimate MySQL Bootcamp, 09/2021

Excel: Insights on Uber's operation in Cities, 

This project uses VLOOKUP, pivot tables, charts, and data analysis to examine key factors affecting Uber's operations. This involves analyzing crucial metrics like 

• the peak completed trips, car requests, and
• the weighted average trip-to-driver ratio within a 24-hour timeframe.
• The project examines weekend car availability, peak shift identification, and hourly demand vs. supply trends, while also exploring end-of-business-day patterns.

SQL: Netflix movies data analysis

In this project I used SQL for data cleaning and data analysis like

• Top 10 movies by IMDB scores
• Average IMDB and TMDB scores calculated
• Content categorized by decades
• Top five age certifications for movies
• Analysis of long-running series
• Popular genres identified and frequently appearing actors in highly rated content recognized.

Python: Pizza data analysis

This project uses Python (pandas, matplotlib, seaborn).  Data cleaning and validation are performed using Pandas. Pizza sales data analysis yields insights into:

• customer preferences, peak hours, and revenue trends.
• Key metrics include Monthly Pizza Orders, Average Daily Customers, and Peak hours for pizza orders.
• Most Sold Pizza Size
• Top 10 Bestseller Pizzas are identified and Total Revenue for the year.