Portfolio - Santhosh kumar | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

Santhosh kumar

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

Welcome to my data-driven world!
I'm Santhosh Kumar, a passionate aspiring Data Analyst with a talent for transforming raw data into actionable insights. Proficient in Excel, PowerBI, SQL, and Python basics, I revel in uncovering the stories within data sets. Although my journey began with a Bachelor's degree in Engineering, it was in the dynamic realm of data analysis that I discovered my true calling and natural abilities.Specializing in the Supply Chain domain, I've honed my analytical skills through hands-on projects in Demand Planning and Forecasting. What sets me apart is the blend of technical expertise and industry insight I bring to the table, ensuring a holistic approach to data analysis.Beyond technical proficiency, I am committed to extracting meaningful insights that fuel informed decision-making. Eager to make significant contributions in data analytics, I am excited about the prospect of joining your team. Let's embark on a journey of data-driven excellence.

Key

Skills

SAP

SQL

Stakeholder Management

Leadership

My

Projects

Sales Analytics(FMCG)

Sales Analytics(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.

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

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

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 to get insights and make informed decisions.

Contact Me

Email

[email protected]

Linkedin

https://www.linkedin.com/in/santhoshkumar-ramesh/

Call

+91 9095011247

Santhosh kumar

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics(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
Engagement

Sales Analytics(FMCG)

The Customer Performance Report is a comprehensive analysis that delves into the net sales performance of individual customers over multiple 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

I crafted an Excel sales report to assist businesses in determining optimal customer discounts, negotiating deals, and identifying new opportunities in promising countries. The reports offer practical guidance for businesses to enhance their sales strategies, boost customer satisfaction, and increase revenue.
In essence, the project aims to empower businesses with the tools and guidance necessary to monitor, comprehend, and enhance their sales performance.
Excel Skills:Pivot tables,Conditional formatting,Data visualization techniques.
Power Query:Extracting, transforming, and loading (ETL) data.
DAX (Data Analysis Expressions):Basic understanding for creating custom formulas and calculations in Excel Power Pivot.
SQL:Querying databases to extract relevant sales data.
Data Analysis:Skills in analyzing and interpreting sales data.
Report Beautification:Design and presentation skills for creating visually appealing reports.

PowerBI Project

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

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 to get insights and make informed decisions.

View Project
Engagement

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

User-empathetic Home page as a part of dashboard design

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

Data modelling involving multiple tables and its relation.

Project Details

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 :Robust Data Modeling, User-empathetic Report design, Drillable Insights.

Following things i have learned 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