Powered by
Codebasics DA Bootcamp

SRIDHAR R

Data Analyst

+91 6374666532 [email protected]

Resume

Hello, I am

SRIDHAR R.

1

PowerBI Project

1

Excel Project

1

Python Project

1

SQL Project

About Me

Experienced Data Analyst skilled in advanced Excel, VBA macros, Power BI, and SQL. Proficient in creating dynamic dashboards, automating tasks, and conducting regression analysis.
Passionate about leveraging data to drive business decisions and uncover new opportunities.

Key Skills

VBA Macros

Power BI

SQL

Python

Excel

Alteryx

ETL

My Projects

My Experience

Advanced Analyst, EY GDS, Bangalore.

Nov 2024 – Present

Conducted financial analysis for Base Erosion and Profit Shifting (BEPS) compliance using Excel.
Supported Country-by-Country (CbCr) reporting with Power BI, enabling tax transparency and data-driven decision-making.
Developed ETL workflows in Alteryx to automate data extraction, transformation, and loading processes, improving reporting

PG Intern, Ashok Leyland, Hosur.

Sep 2023 - Nov 2024

Utilized Excel VBA macros to automate repetitive data cleaning and analysis, cutting manual work by 15%.
Performed ETL processes and creating dashboards that supported strategic initiatives and executive-level decision-making.
Conducted regression analysis on Frame Distortion Issue, identifying bottlenecks and enabling process improvements.
Led supply chain analytics projects, improving demand forecasting, reducing lead times, and optimizing stock levels.

Graduate Trainee, Ashok Leyland, Hosur.

Apr 2022 - Apr 2023

Utilized pivot analysis to monitor vehicle age trends and supported project teams with data collection, delivering actionable insights that improved operational decisions.

Awards & Certificate

Excel Beginner to Advanced

Excel Beginner to Advanced

Python Basics

Master Data Science Program

Master Data Science Program

Data Analytics Virtual Internship Program

Data Analytics Virtual Internship Program

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/sridhar-rajavel-7400551b3/

+ 91 6374666532

https://github.com/SRIDHAR3131

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: FMCG

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

Domain/Function: FMCG

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sales Analytics(FMCG)

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics(FMCG)

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Python Project

E-Commerce Customer segmentation

Domain/Function: E-Commerce

This project aims to perform customer segmentation analysis on an E-commerce dataset using the K-means clustering algorithm. The goal is to identify the optimal number of clusters (k) based on the maximum silhouette score and uncover purchasing patterns among customers.

View Project
on GitHUB

E-Commerce Customer segmentation

Visualize the overall order distribution as a bar chart to easily identify the frequency of orders across different categories.

E-Commerce Customer segmentation

I used the silhouette visualizer to determine the optimal number of clusters (k) by identifying the k value that maximizes the silhouette score.

Project Details

The project will begin by exploring and preprocessing the dataset, ensuring that the data is clean, consistent, and suitable for clustering. Following this, the K-means algorithm will be applied to the dataset, and various values of k (the number of clusters) will be tested. The goal is to identify the optimal number of clusters that best represents the underlying customer segments. This will be achieved by evaluating the clustering performance using the silhouette score, a metric that measures how similar each point is to its own cluster compared to other clusters.

Tools Used:

Python: For data processing and implementing the K-means algorithm.
Pandas: For data manipulation and cleaning.
Scikit-learn: For applying K-means clustering and calculating silhouette scores.
Matplotlib/Seaborn: For visualizing clusters and patterns in the data.

SQL Project

YouTube Data Harvesting and Warehousing

Domain/Function: Video sharing service and Social media platform

This project aims to harvest data from YouTube using Python scripting and store it in a NoSQL (MongoDB) database as a data lake. The harvested data can then be fetched from the NoSQL database and migrated to a SQL (MySQL) database for further analysis.

View Project
Engagement

View Project
on GitHUB

YouTube Data Harvesting and Warehousing

Harvest YouTube data, store it in MongoDB, and analyze it in MySQL. Simply enter the channel ID and access detailed insights instantly.

YouTube Data Harvesting and Warehousing

Run the script and enter the required details, like the channel ID. The script will then retrieve the channel information from the database.

Project Details

This project focuses on harvesting data from YouTube using Python scripts and storing it in a NoSQL (MongoDB) database, serving as a data lake. The collected data can later be retrieved from MongoDB and migrated to a SQL (MySQL) database for structured storage and further analysis. By utilizing SQL queries on the MySQL database, users can extract specific insights related to uploaded channel information.

Tools Used:

Python 3.9
MongoDB
MySQL

Project video