Powered by
Codebasics DA Bootcamp

Sooraj A D

Data Analyst

+91 7012680703 [email protected]

Resume

Hello, I am

Sooraj A D.

1

Excel Project

2

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Hi there!

I'm a professional with over 5 years of experience in core travel business operations. In my role, I've helped businesses make data-informed decisions, driving over 40% growth in sales through my initiatives. I've successfully led a team of travel professionals and acted as a bridge between stakeholders and the team.

I hold an Advanced Certification in Data Analytics from IIT Roorkee, along with Advanced Power BI Training, SQL Training, and Python certification from Codebasics and Intellipaat. I firmly believe that for a Data Analyst to provide deep business insights, they need both business acumen and experience. With my 5+ years of business experience and proficiency in various tech tools, I can help your business make informed decisions based on data.

Key Skills

SQL

Python

Stakeholder Management

My Projects

Awards & Certificate

Advanced Certification In Data Analytics, IIT Roorkee

Advanced Certification In Data Analytics, IIT Roorkee

Excel : Mother of Business Intelligence

Excel : Mother of Business Intelligence

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

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

MS SQL Developer Course

MS SQL Developer Course

Google Professional Data Analytics Certificate

Google Professional Data Analytics Certificate

Advanced Power BI Training

Advanced Power BI Training

Python Training

Python Training

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/soorajad

+ 91 7012680703

https://github.com/adsooraj

PowerBI Project

Business Analysis 360

The primary goal of this project was to use Power BI to create a holistic report that offers an insightful overview of Atliq Hardware's performance. Crafted a Power BI dashboard gathering data from two different sources (Excel/CSV files and a SQL database).

View Project
Engagement

Business Analysis 360

Sales Performance View to gain insights about the sales across different regions and clients.

Business Analysis 360

Supply Chain View to gain insights about forecast and supply

Project Details

AtliQ Hardware, faced significant loss in Latin America due to Excel-based analytics. To address this issue, the company's senior executives decided to invest in a data analytics expert, utilizing data from the previous year to enhance performance and decision-making.

● The Stakeholders require actionable insights to analyze trends, revenues, profit margins, and more, with the ultimate goal of boosting the business.

● Created the required views which have their importance.

● The generated insights will help stakeholders in the data-driven decisions in their businesses with accuracy & precision

Live Interactive Dashboard

Excel Project

ATLIQ Hardware Profit & Loss Report - Excel Analytics

Designed a concise sales report for the team to assess customer and market performance. This report provides quick insights into individual customer interactions and broader market trends. It's user-friendly, visually engaging, and aims to enhance strategic decision-making.

View Project
Engagement

View Project
on GitHUB

ATLIQ Hardware Profit & Loss Report - Excel Analytics

Sales Profit & Loss Report

ATLIQ Hardware Profit & Loss Report - Excel Analytics

Quarter wise Report

Project Details

In this project, I compiled a sales analysis utilizing Excel pivot tables, enabling businesses to identify effective customer discounts, streamline negotiations, and uncover potential expansion opportunities in promising markets. The resultant report offers practical insights and strategic suggestions, empowering businesses to refine sales strategies, enhance customer satisfaction, and optimize revenue generation.

Skills honed:

Pivot Table Manipulation
Power Query Utilization
Fundamental DAX Knowledge
Application of Conditional Formatting
Report Aesthetic Enhancement
Understanding of Sales Metrics
This project acts as a resource kit, equipping businesses with essential techniques and insights to monitor, evaluate, and improve their sales operations. By analyzing sales data comprehensively, businesses can unearth new avenues, foster growth, and sustain competitiveness in a dynamic market environment.

PowerBI Project

Atliq Grand Revenue Insights - Power BI Dashboard

AtliQ Grands, a chain of luxury five-star hotels, is facing a decline in market share and revenue due to uncompetitive strategies and poor management decisions. Designed an interactive dashboard for the Atliq Grand Hotel chain to help them gain insights over the revenue loss they are facing.

View Project
Engagement

Atliq Grand Revenue Insights - Power BI Dashboard

Revenue Insights Dashboard for Atliq Grands

Atliq Grand Revenue Insights - Power BI Dashboard

Revenue Insights Dashboard for Atliq Grands

Project Details

AtliQ Grands, a chain of luxury five-star hotels, is facing a decline in market share and revenue due to uncompetitive strategies and poor management decisions. To counteract this, the managing director has decided to implement “Business and Data Intelligence” to reclaim their market position and revenue.

Workflow Steps:

Collect and explore data, and create a Date table in Power Query (M language).
Load data into Power BI and perform initial validation.
Transform data in Power Query.
Model data and create calculated columns.
Develop measures using the DAX language.
Build views for Executives, Finance, Revenue, Occupancy and Booking, and Key Metrics.
Design an effective Dashboard incorporating page navigation with buttons, tooltips, KPIs, and conditional formatting.
Deploy the solution using Power BI.

Live Interactive Dashboard

SQL Project

Sales Analytics - SQL

As a database administrator. I was asked to use the data to answer a few questions about customers, especially about the sales and profit coming from different states, money spent in marketing and various other factors such as COGS (Cost of Goods Sold), budget profit etc.

View Project
Engagement

View Project
on GitHUB

Sales Analytics - SQL

SQL Queries

Sales Analytics - SQL

SQL Queries

Project Details

Problem Statement: As a database administrator. I was asked to use the data to answer a few questions about customers, especially about the sales and profit coming from different states, money spent in marketing and various other factors such as COGS (Cost of Goods Sold), budget profit etc. I am planning on using these insights to help find out which items are being sold the most. I have been provided with the sample of the overall customer data due to privacy issues. But I hope that these samples are enough for you to write fully functioning SQL queries to help answer the questions.

Python Project

HR Analytics with Python for People's Charm

People Charm’, a growing company is facing a high attrition rate among their employees which in turn affects their business due to lack of expertise and experience. HR department is assigned the task to reduce the attrition rate by retaining employees who are about to churn out.

View Project
Engagement

View Project
on GitHUB

HR Analytics with Python for People's Charm

Percentage of Employees Leaving and Staying

HR Analytics with Python for People's Charm

Employee Projects Count Graph

Project Details

People Charm’, a growing company is facing a high attrition rate among their employees which in turn affects their business due to lack of expertise and experience.

• Our HR department is assigned the task to reduce the attrition rate by retaining employees who are about to churn out.

• We need to recommend special plans or strategies which will help them to retain their employees which in turn will help them to grow bigger as a company