Powered by
Codebasics DA Bootcamp

Saumya Jha

Data Analyst

+91 9334091372 [email protected]

Resume

Hello, I am

Saumya Jha.

2

Excel Projects

2

PowerBI Projects

2

SQL Projects

2

Python Projects

About Me

An aspiring data analyst , passionate about uncovering insights through dynamic dashboards and data storytelling. I excel in creating dynamic dashboards and crafting compelling data stories using tools like Power BI and Tableau. With expertise in SQL and Excel, I am proficient in data cleaning, transformation, and visualization to aid in strategic decision-making. I have worked on diverse projects, from HR analytics to sales and marketing dashboards, showcasing my ability to analyze complex datasets and deliver valuable insights. My goal is to drive impactful business outcomes through data-driven strategies and innovative solutions.

Key Skills

Python

Excel

SQL

Power BI

Data Visualization

Business Communication

Tableau

My Projects

My Experience

Data Analyst Intern, Atliq Technology – Bengaluru, India

Performed 15+ data variance analyses, identifying discrepancies with 98% accuracy, and debugged 100+ SQL queries, ensuring 100% correct data extraction from MySQL Workbench.
Applied 10+ advanced data cleaning and normalization techniques, reducing data redundancy by 35% and improving query performance by 40%.
Designed and delivered 5+ Power BI dashboards, enabling 30% faster stakeholder decision-making by visualizing key performance metrics

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

SQL Basic(Hackerrank)

SQL Basic(Hackerrank)

Complete Pyhton Bootcamp From Zero to Hero in Python

Complete Pyhton Bootcamp From Zero to Hero in Python

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/saumya-jha-3a11a7270/

+ 91 9334091372

https://github.com/JhaSaumya/JhaSaumya

PowerBI Project

Business 360 Power BI Project

Domain/Function: Manufacturing Domain

It is a project made for company ATLIQ hardware to gain valuable insights and help various teams, such as finance, marketing, supply chain, and sales , make data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Business 360 Power BI Project

Home page which has different linked attached to different reports to help stakeholders navigate better as per their needs !!

Business 360 Power BI Project

This report shows the finance view of the dashboard which has important KPI related to gross margin , net profit etc .

Project Details

Designed and developed a comprehensive Power BI 360 Dashboard encompassing Finance, Executive, Sales, Supply Chain, and Marketing views, with KPIs such as Net Sales, GM%, Net Profit% etc.
Optimized it with DAX Studio resulting in a 5% performance boost and projected 10% revenue growth and 20% data-related expense reduction.

Live Interactive Dashboard

SQL Project

Bank Loan Analysis

Domain/Function: Finance Domain

This project showcases an advanced Power BI solution with SQL queries to extract all the useful information about the bank loan data . Project is made to showcase my SQL and Power BI skills concerning answering all the queries and business problems given by stakeholders .

View Project
Engagement

View Project
on GitHUB

View Project
on PowerBI Service

Other Tools

PowerBI

Bank Loan Analysis

This dashboard highlights 38.6K loan applications, $435.8M funded, $473.1M received, 86.2% good loans ($370.2M), and 13.8% bad loans ($65.5M).

Bank Loan Analysis

This dashboard shows the information about total loan applications by month, state, and term.

Project Details

The Bank Loan Analysis Dashboard provides a comprehensive overview of loan performance and borrower behavior, enabling stakeholders to make data-driven decisions. Key insights from the analysis highlight steady growth in loan applications and funding, a strong repayment trend, and customer preferences for longer-term loans and specific loan purposes such as debt consolidation.
The geographic and demographic breakdowns further support targeted strategies for marketing, risk management, and customer acquisition. Metrics like loan grades and the debt-to-income ratio help identify creditworthy borrowers while managing risk associated with bad loans.
This dashboard empowers the bank to optimize loan offerings, improve financial health, and enhance customer satisfaction through actionable insights. Continued monitoring and refinement of KPIs will ensure sustained growth and operational excellence.

Project video

PowerBI Project

AtliQ. Grands Hospitality Analysis

Domain/Function: Hospitality Domain

AtliQ Grand is a renowned imaginary company with a chain of five-star hotels in major cities across India, including Mumbai, Hyderabad, Delhi, and Bangalore. Despite its esteemed reputation, AtliQ Grand has experienced a decline in revenue and market share.

View Project
on GitHUB

AtliQ. Grands Hospitality Analysis

Provides detailed revenue, occupancy, and ADR insights by property & platform.

AtliQ. Grands Hospitality Analysis

Focuses on revenue, occupancy, and ratings, segmented by city and booking type.

Project Details

AtliQ Grand is a renowned imaginary company with a chain of five-star hotels in major cities across India, including Mumbai, Hyderabad, Delhi, and Bangalore. Despite its esteemed reputation, AtliQ Grand has experienced a decline in revenue and market share. To address this, the company sought assistance to analyze their data and provide actionable insights and recommendations.

Project video

Live Interactive Dashboard

Excel Project

Sales-and-Finance-analytics

Domain/Function: Sales & Finance Analytica

To develop an interactive business intelligence dashboard, Sales and Finance Analytics Report, aimed at extracting decision-making insights for well-articulated strategies at Atliq Hardware.

View Project
on GitHUB

View Project
on Github

Sales-and-Finance-analytics

Atliq Exclusive and Amazon showed strong sales growth in 2021, with Amazon leading at 82.1M, reflecting a 118.9% increase from 2020.

Sales-and-Finance-analytics

India had the highest 2021 sales (161.3M) but missed its target by 9.6M (-5.6%), while Poland had the largest negative deviation (-15.3%).

Project Details

To develop an interactive business intelligence dashboard, Sales and Finance Analytics Report, aimed at extracting decision-making insights for well-articulated strategies at Atliq Hardware.To reach our customers, we utilize intermediaries such as retail giants like Croma and Best Buy, as well as popular online marketplaces like Flipkart and Amazon. These intermediaries play a crucial role in connecting Atliq's products with end consumers, ensuring our offerings are accessible to the general public.

Python Project

Paisabazar_banking_fraud_analysis

Domain/Function: Finance Domain

The Paisabazaar Banking Fraud Analysis project is designed to analyze a large dataset of banking customers to identify potential fraudulent activities. The dataset includes detailed information about customers' financial behaviors, credit histories, and transaction details. The goal of this project

View Project
on GitHUB

View Project
on Github

Paisabazar_banking_fraud_analysis

This Dataset contains customer details such as Customer ID, Name, Age, SSN, Occupation, Annual Income, and Monthly Inhand Salary.

Paisabazar_banking_fraud_analysis

This image contains a snippet of just one visualization which I have used in this project to show salary variations across different occupations .

Project Details

For this project, the goal was to analyze customer data from Paisabazaar to uncover patterns and potential red flags that might indicate banking fraud. The dataset included 100,000 records with 28 different attributes, covering key details about customers' financial habits, credit history, and loan information. Some of the important features examined were Age, SSN, Occupation, Annual Income, Credit Utilization Ratio, Payment Behavior, and Credit Score. By studying these factors, we aimed to gain deeper insights into customer behavior and identify any irregularities that could suggest fraudulent activity.

Project video

SQL Project

Walmart Sales Data Analysis

Domain/Function: Retail Domain

Extracted 10,000 rows of required data by utilizing Python libraries for data processing and analysis Performed ETL on the data and used various SQL queries to gain powerful insights.

View Project
on GitHUB

View Project
on

Walmart Sales Data Analysis

The picture describes the business problems that I tried to solve through SQL and python libraries .

Walmart Sales Data Analysis

It shows the sinepts of the SQL code that I have utilized to gain some valuable insights from the dataset provided !!

Project Details

In this project i have used the walmart dataset to gain some valuable insights such as the highest rated category of projects , the busiest day etc .

Python Project

Telco-Customer-Churn-Analysis-

Domain/Function: Telecom Domain

In this project, I analyzed customer churn patterns by exploring how demographics, subscription plans, and service usage impact their decision to stay or leave. I focused on key features like Phone Service, Internet Service, and add-on services such as Online Security and StreamingTV.

View Project
on GitHUB

Telco-Customer-Churn-Analysis-

Some snippet of the project which shows the various reasons for why the customer has churned out from the company services

Telco-Customer-Churn-Analysis-

It shows all the key findings of the project @@

Project Details

In this project, I analyzed customer churn patterns by exploring how demographics, subscription plans, and service usage impact their decision to stay or leave. I focused on key features like Phone Service, Internet Service, and add-on services such as Online Security and StreamingTV. Through this analysis, I identified the main drivers of churn and developed actionable strategies to improve customer retention.

Excel Project

Espresso Insights: Coffee Shop Sales Performance

Domain/Function: Food Domain

This analysis explores key sales trends, customer preferences, and revenue drivers in a coffee shop. By leveraging data analytics, we uncover peak sales hours, best-selling products, and seasonal demand shifts, helping optimize pricing, inventory, and marketing strategies for improved profitability.

View Project
on GitHUB

Espresso Insights: Coffee Shop Sales Performance

This Excel dashboard, designed to showcase my data analysis skills, reveals key insights such as peak sales hours between 8 AM and 10 AM.

Espresso Insights: Coffee Shop Sales Performance

The dataset captures transaction-level data for a coffee shop, showcasing detailed information about each sale.

Project Details

This Excel dashboard, designed to showcase my data analysis skills, reveals key insights such as peak sales hours between 8 AM and 10 AM, with coffee contributing 39% to total sales of $69,881.33. The dashboard also highlights a total footfall of 149,116 across locations and top-performing products like Barista Espresso generating over $90,000 in revenue. It demonstrates my ability to extract, analyze, and visualize data effectively for actionable business decisions.

# Top Metrics:
Total Sales: $69,881.33, showcasing the revenue generated.
Total Footfall: 149,116, representing the number of visitors.
Average Bill/Person: $4.69, highlighting the spending per customer.
Average Order/Person: 1.44, indicating the average number of items purchased per customer.
Quantity Ordered Based on Hours
% Size Distribution Based on Orders
Footfall and Sales Over Various Store Locations
Top 5 Products Based on Sales: