Portfolio - Rajeev Kumar

Rajeev Kumar

Data Analyst

Resume

2

Excel Projects

2

PowerBI Projects

About Me

Welcome to my portfolio! I am an aspiring data analyst with a strong foundation in economics and a natural talent for data analysis. My expertise lies in using tools like Excel, Power BI, SQL, and Python to extract valuable insights from data.

While I haven't yet worked within a traditional organization, I've completed several business projects that highlight my skills and ability to turn complex data into meaningful solutions. These projects are showcased in my portfolio below.

Explore my work to see how I bring data to life and make informed decisions that drive success. I'm excited to connect with opportunities where I can contribute my analytical skills and passion for data to achieve impactful results.

My Projects

Sales analytics

Domain/Function: Sales

Virinda store sales analysis

Domain/Function: Sales

BUSINESS 360 - Bricks & motor e commerce

Domain/Function: Sales

HR Analytics - Human Resources

Domain/Function: Human Resources

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/rajeev-kumar91555/

Call Me

+91 9155588303

Excel Project

Sales analytics

Domain/Function: Sales

I created detailed reports for the sales team to evaluate customer performance and understand market trends, providing insights to refine strategies and drive business growth.

Customer net sales by year and comparing their net sales to the target.

customer net sales in the APEC region by the year.

Project Details

In this project, I created a sales report using Excel pivot tables. This report helps businesses determine effective customer discounts, negotiate better with consumers, and find opportunities for expansion in promising countries. The reports provide actionable insights and recommendations for optimizing sales strategies, enhancing customer satisfaction, and maximizing revenue growth.

From this project, I learned:

Pivot Tables
Power Query
DAX
Conditional Formatting
Interactive Dashboard
Sales Domain
Overall, this project aims to empower businesses with the tools and insights needed to monitor, evaluate, and improve their activities.

Excel Project

Virinda store sales analysis

Domain/Function: Sales

"Analyzed sales trends and profit data for Virinda Store to identify key patterns and growth opportunities. Provided data-driven insights and recommendations to boost sales and improve profitability."

pie chart showing the market share of the channels from top ranking to the bottom.

picture showing the order count of different age group by their age category .

Project Details

"Virinda Store brought in a data analyst to help them increase sales and boost profits. The analyst started by closely examining the store’s sales data to see which products were popular and which ones weren’t selling as well. They looked at how different factors like time of year, pricing, and promotions affected sales. By spotting important trends and patterns, the analyst was able to uncover opportunities to improve the store’s performance. They then shared clear, actionable advice with the store’s management on how to better stock products, adjust prices, and plan promotions to attract more customers and increase profits. Thanks to these insights, Virinda Store was able to make smarter decisions that led to higher sales and better financial results."

PowerBI Project

BUSINESS 360 - Bricks & motor e commerce

Domain/Function: Sales

Developed a BI 360 solution for a brick-and-mortar e-commerce platform, featuring finance, marketing, sales, executive, and supply chain views. Enhanced decision-making efficiency by 30% and reduced report generation time by 40% through automation, analyzing 100K+ data points for optimized insights.

The finance view provides real-time insights into revenue, expenses, and profitability, enabling informed budgeting and financial planning decisions.

The sales view displays key metrics such as sales trends, top-performing products, and customer insights, driving effective sales strategies.

Project Details

Here’s an expanded project description that fits within the 1000-character limit:

In September 2024, I developed a comprehensive BI 360 solution for a brick-and-mortar e-commerce platform, integrating key business views: finance, marketing, sales, executive, and supply chain. This project aimed to enhance decision-making efficiency and streamline reporting processes. By automating report generation and creating KPI-driven dashboards, I reduced report generation time by 40%.

Additionally, I explored over 100,000 data points, which provided valuable insights that improved business alignment by 25%. The interactive dashboards enabled stakeholders to easily access critical data, fostering a data-driven culture within the organization. This initiative not only facilitated better strategic planning but also empowered teams to make informed decisions swiftly, ultimately enhancing overall operational efficiency and effectiveness.

Live Interactive Dashboard

PowerBI Project

HR Analytics - Human Resources

Domain/Function: Human Resources

conducted an HR analytics project using Power BI, analyzing a dataset of 500+ employees. I identified a 15% overall attrition rate, with a 30% higher rate among high school-educated employees. Additionally, a 20% attrition spike in the technical department prompted targeted retention strategies.

It illustrates attrition rates by department, highlighting HR, Sales, and R&D, enabling quick visual comparisons for informed decision-making.

The bar chart displays the number of employees across different age groups, providing a clear visual representation of workforce demographics.

Project Details

I undertook an HR analytics project using Power BI to analyze a dataset of over 500 employees. The goal was to assess attrition rates and identify factors influencing turnover.
Through thorough analysis, I discovered an overall attrition rate of 15%, with notable differences based on gender, age group, and education level. One significant finding was a 30% higher attrition rate among employees with only a high school education, prompting targeted development plans. Additionally, the analysis revealed a 20% attrition spike in the technical department, enabling leadership to implement focused retention strategies.

By visualizing these insights in an interactive dashboard, I facilitated data-driven decision-making, contributing to improved employee retention and organizational stability.