Powered by
Codebasics DA Bootcamp

Sudip Ruidas

Data Aspirant

+91 8170981792 [email protected]

Resume

Hello, I am

Sudip Ruidas.

1

Excel Project

3

PowerBI Projects

1

SQL Project

1

Python Project

About Me

👋🏻 Hey there!

I’m a data enthusiast with a passion for turning raw data into actionable insights. I hold a BCA and an MCA, but I truly discovered my strengths in data analysis. With tools like Excel, Power BI, and SQL, I enjoy uncovering patterns in data that help businesses make smarter, more informed decisions.

While I haven’t worked in an organization yet, my portfolio showcases several business projects where I’ve applied my skills to drive meaningful insights. I’m always eager to learn, grow, and contribute, and I’m excited about the opportunity to bring fresh ideas and a supportive, collaborative spirit to your team!

Key Skills

SQL

PYTHON

PROBLEM SOLVING

effective communication

stakeholder management

My Projects

My Experience

Amazon - Automation Analyst Feb 2025 - Present

● Automated reporting workflows and partnered with cross-functional teams to streamline processes, enhance data accuracy, and improve efficiency in delivering business insights.

AtliQ Technologies - Data Analyst Intern Dec 2024 - Jan 2025

● Leveraged Power BI and Power Query for data cleaning, validation, and reporting, improving accuracy by 15%. Analyzed sales channels for Shield Insurance, driving strategic adjustments that boosted client engagement across five cities.

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

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

PwC Switzerland - Power BI Job Simulation

PwC Switzerland - Power BI Job Simulation

SQL (Intermediate)

SQL (Intermediate)

MeriSKILL - Certificate of Internship Completion

MeriSKILL - Certificate of Internship Completion

Coding Samurai - Internship Experience Certificate

Coding Samurai - Internship Experience Certificate

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

+ 91 8170981792

https://github.com/SudipRuidas

Excel Project

Sales & Finance Analytics Report for AtliQ Hardwares

Domain/Function: Sales & Finance

Analyzed over half a million sales records for AtliQ Hardware using advanced Excel. Created key reports like 'Customer Net Sales Performance' and 'Market Performance vs. Target,' delivering crucial insights to drive data-driven decisions and improve business performance.

View Project
Engagement

View Project
on GitHUB

Sales & Finance Analytics Report for AtliQ Hardwares

Displays net sales performance for each customer over the years.

Sales & Finance Analytics Report for AtliQ Hardwares

Compares the company’s market performance with set targets across different years.

Project Details

In this project, I created detailed sales and finance reports using Excel tools like pivot tables, Power Query, and conditional formatting. These reports help businesses make better decisions about customer discounts, improve negotiations, and find new growth opportunities in different markets.

During this project, I gained experience in:

- Using pivot tables for detailed analysis
- Cleaning and organizing data with Power Query
- Learning basic DAX formulas for data work
- Improving report visuals with conditional formatting
- Understanding important sales and finance metrics

These reports give businesses useful insights to improve their sales strategies, increase customer satisfaction, and boost revenue. Analyzing the sales data allows businesses to identify trends and make informed decisions for growth.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar and E-commerce

AtliQ Hardware struggled to manage data in Excel, limiting their ability to compete. I implemented an advanced analytics solution using Power BI, enabling insights into finance, sales, and supply chain. The project involved handling 1.8M data entries using SQL, Power BI, and Excel.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

MySQL

Business Insights 360

A user-friendly landing page designed for seamless navigation, connecting users to various dashboard sections for an enhanced experience.

Business Insights 360

A "Snowflake" schema data model involving 10+ tables, designed to optimize data relationships and streamline dashboard performance.

Project Details

AtliQ Hardware, a global leader in computers and accessories, faced unexpected losses due to reliance on Excel for data analysis. To address this, a data analytics project using Power BI, SQL, and Excel was initiated to enhance performance. The project analyzed 1.8 million records and provided actionable insights for stakeholders in finance, sales, marketing, supply chain, and the executive team.

Key Focus Areas:

Robust Data Modeling
User-friendly Report Design
Drillable Insights
Key Learnings:

Power Query (Basic & Advanced)
Complex DAX Formulas
Data Modeling (10+ Tables)
Visual Selection & Formatting
Dashboard Design Principles
Bookmarks & Drill-Through
Power BI Deployment
Stakeholder Feedback
Metrics Across Sales, Marketing, Finance & Supply Chain

Project video

Live Interactive Dashboard

PowerBI Project

Electric Vehicle Market Analysis

Domain/Function: Automotive Industry

Analyzed the Indian EV market for AtliQ Motors, which has <2% market share in India and aims to expand. Provided key insights to guide strategic decisions for launching bestselling EV models and support their growth plans in the region.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Canva

Electric Vehicle Market Analysis

This is the home page of the dashboard, providing a quick overview and navigation to key insights.

Electric Vehicle Market Analysis

This is the Data Model I built, designed to optimize data flow and support efficient, in-depth analysis for generating actionable insights.

Project Details

AtliQ Motors, a leading EV manufacturer with 25% market share in North America, aimed to expand into India’s EV/Hybrid sector, where they currently hold <2% market share. As a Data Analyst, I conducted an in-depth market analysis to support this expansion.

I developed a Power BI report using a STAR schema Data Model, analyzing EV sales data by state and maker. The dashboard included:

Home Page: Landing page
Makers Page: Detailed view of EV makers
State Page: Overview of states and state comparisons

I analyzed key metrics such as EV penetration rates and CAGR, identified top-performing states and makers, and provided actionable recommendations to guide AtliQ Motors' expansion strategy.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods

Analyzed AtliQ Hardware's sales data using SQL to address 10 key business queries. Delivered actionable insights on sales trends, customer discounts, and market presence, helping management make data-driven decisions to optimize channels and explore product expansion opportunities.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Excel

Canva

Consumer Goods Ad-Hoc Insights

This is a snapshot of the data model used in this project, which I created in MySQL Workbench.

Consumer Goods Ad-Hoc Insights

Graphical representation of AtliQ's business model showing how they sell their products to consumers (end users).

Project Details

SQL project analyzed *AtliQ Hardware’s* sales data to support management’s ad-hoc queries. AtliQ, a leading hardware provider (imaginary), distributes products through direct, retail, and partner channels across diverse markets. The goal was to uncover growth opportunities by examining sales trends and customer insights.

Dataset:
Utilized six tables from FY 2020–2021 covering sales, customer details, and financials.

Task:
Addressed 10 business questions around sales trends, discounts, market reach, and product performance, all to aid data-driven decisions.

Approach:
Crafted efficient SQL queries (joins, CTEs, subqueries, window functions) to provide clear insights, including sales peaks, product growth, and regional trends.

Outcome:
Key findings:
- 36.3% growth in unique products
- 8 APAC countries reached
- Retailer channel led with 73% of sales

This project highlights my SQL skills and ability to derive actionable business insights.

PowerBI Project

Shield Insurance Analysis Dashboard

Domain/Function: Insurance

Developed a 3-page interactive Power BI dashboard for Shield Insurance, analyzing revenue trends, customer demographics, sales performance, and policy preferences. Delivered actionable insights to enhance decision-making and proposed strategies for revenue growth and market expansion.

View Project
Engagement

View Project
on GitHUB

Shield Insurance Analysis Dashboard

Navigate through an interactive dashboard with insights on customers, revenue, and performance.

Shield Insurance Analysis Dashboard

Explore key metrics, revenue trends, and city-wise performance with dynamic filters and visuals.

Project Details

This project focuses on building a 3-page interactive Power BI dashboard for Shield Insurance, providing actionable insights into revenue trends, customer demographics, sales performance, and policy preferences.

The dashboard includes:
1. General View: Highlights total revenue, customer growth, and city-wise performance.
2. Sales Mode View: Analyzes revenue and customer trends across sales channels.
3. Age Group View: Explores age-wise revenue contribution and settlement percentages.

Key findings include:
• Delhi NCR contributed 35% of total revenue, while Indore accounted for less than 5%.
• The 31–40 age group drove 40% of revenue and 50% of customers, with offline agents generating 55.67% of revenue.
• POL2005HEL emerged as the top-performing policy, generating the highest revenue with only 7.3% ownership.

This project highlights opportunities for improved regional strategies, younger demographic engagement, and targeted policy promotion.

Project video

Live Interactive Dashboard

Python Project

Diabetes Prediction System

Domain/Function: Healthcare

Developed a Diabetes Prediction System using the National Institute of Diabetes dataset. Built a logistic regression model with 8 medical variables and integrated it into a Django web app for user-friendly data input and result visualization.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Django

Jupyter Notebook

Diabetes Prediction System

Overview of the Diabetes Prediction System web app's main page, where users can input their medical data and check their diabetes status.

Diabetes Prediction System

Correlation matrix visualization between variables, created using Matplotlib and Seaborn libraries in Python.

Project Details

Diabetes Prediction System
This project predicts the likelihood of diabetes using a dataset from the National Institute of Diabetes and Digestive and Kidney Diseases. The dataset includes 8 medical predictor variables (e.g., glucose levels, BMI, age) and an 'Outcome' variable indicating diabetes presence (1: Yes, 0: No).

A logistic regression model was developed, achieving an 75% accuracy rate. A Django-based web application was also created, allowing users to input medical data and view predictions. The app features intuitive result visualization for easy interpretation.

Tools & Technologies:

Programming: Python (Pandas, NumPy, Seaborn, Scikit-learn, Matplotlib)
Development Environment: Jupyter Notebook, VS Code
Framework: Django

This user-friendly system bridges machine learning and web development for accessible diabetes risk assessment.