RESUME
Sourav Bhattacharya

SKILLS

  • Excel-Used for data cleaning, analysis, and reporting. Skilled in Pivot Tables, XLOOKUP, IFs, Power Query, charts, and dashboards to quickly summarize data and generate business insights.
  • SQL– Used for data extraction, cleaning, and analysis. Skilled in SELECT queries, JOINs, GROUP BY, subqueries, CASE statements, and aggregations to transform raw data into actionable business insights.
  • POWER BI – Used for data visualization and business reporting. Skilled in dashboard development, data modeling, DAX (CALCULATE, SUM, etc.), and Power Query for data cleaning and transformation to deliver actionable insights.

certificates

LANGUAGES

  • English (Intermediate)
  • Bengali (Native)
  • Hindi (Proficient)

Interest

  • Interested in learning data analytics by watching domain-related videos from various YouTube channels and reading blogs from different sources.

Personal Info

  • DOB : 30/12/1993
  • Marital Status : Unmarried

Sourav Bhattacharya

Data Analyst

98,bapuji colony ichapur 24 PGS (N) near bhartri sanga club, po- nawabganj, police station- naopara pin-7431444

PROFILE

Data-driven analyst turning raw datasets into actionable insights and interactive dashboards using SQL, Power BI, Excel

Personal Project/s

Project Name :

SWIGGY-SALES-ANALYSIS USING -SQL

Description :

This project analyzes sales data from Swiggy, one of India’s largest online food delivery platforms. The goal of this project is to transform raw food delivery transaction data into meaningful business insights using SQL.

Project Name :

Apple-Retail-Sales-SQL-Project

Description :

This project is designed to showcase advanced SQL querying techniques through the analysis of over 1 million rows of Apple retail sales data. The dataset includes information about products, stores, sales transactions, and warranty claims across various Apple retail locations globally. By tackling a variety of questions, from basic to complex, you'll demonstrate your ability to write sophisticated SQL queries the extract valuable insights from large datasets.

Project Name :

Netflix-Data-Analysis-Using-SQL

Description :

This project involves a comprehensive analysis of Netflix's movies and TV shows data using SQL. The goal is to extract valuable insights and answer various business questions based on the dataset. The following README provides a detailed account of the project's objectives, business problems, solutions, findings, and conclusions.

Project Name :

Blinkit Sales Dashboard using Power BI

Description :

This project presents an interactive Power BI dashboard built to analyze Blinkit's retail sales data. The dashboard provides insights into sales performance, customer preferences, and outlet distribution to support data-driven decision-making.

Experience/s

17/07/2017 - 22/08/2019

Company :

MT Infrastructures

Designation :

SITE Engineer

Description :

Supervised construction activities ensuring work was completed as per drawings, quality, and safety standards while managing manpower and materials.
04/09/2024 - 02/01/2025

Company :

Vibrant Impetus

Designation :

IT Executive

Description :

Provided end-user technical support including desktop troubleshooting, LAN cabling, and operating system installation. Assisted users with hardware, software, and network-related issues to ensure smooth daily operations.

EDUCATION

Bachelor of Technology in civil Engineering (80%)

2017

West Bengal of HIgher Secondary Education (50%)

2011

West Bengal BOARD OF SECONDARY EDUCATION (60%)

2009
Logo