Akshay Pratap Srivastava

Data Analyst

[email protected] +91 8303068757

Resume

Hello, I am

Akshay Pratap Srivastava.

2

Excel
Projects

3

PowerBI
Projects

1

SQL
Project

About Me

I’m Akshay Pratap Srivastava, a data-driven professional specializing in IT and data analysis. Currently a Senior Officer at Cashpor Micro Credit, I focus on data reconciliation and reporting. My experience as an Equity Research Analyst and Data Analyst intern, along with certifications in SQL and Power BI, enhances my ability to drive efficiency and insights. I am always ready to learn new skills and embrace challenges that contribute to my professional growth.

Key Skills

Sql

Power BI

Excel

Dashboarding

Reporting

Power Query

Dax

Analysis

Power Pivot

Pivot Table

Microsoft fabric

My Projects

Wavecon Telecom Analysis

Domain/Function: TELECOM

E-COMMERCE SALES ANALYSIS

Domain/Function: Sales

SWIGGY CASE STUDY

Domain/Function: FOOD DELIVERY

HR PERFORMANCE ANALYSIS

Domain/Function: HR

HEALTH COST ANALYSIS

Domain/Function: Health

CALL CENTER ANALYSIS

Domain/Function: BPO

My Experience

Haraya IT Services Pvt Ltd
Role: Data Analyst Intern
July 1 – August 31, 2023
Gained hands-on experience in data analysis and visualization during this paid internship.
Cashpor Micro Credit
Role: Senior Officer [ICT Department]
December 2023 – Present
Currently working in the ICT department, applying and expanding my technical skills.

Awards & Certificate

SQL: Basic of Database

HITS : INTERN AS-Analyst

EXCEL : Mother of Business Intelligence

POWER BI : Data Analyst

SQL : Beginner to Advanced For Data Professionals

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.

Mail Me

[email protected]

https://www.linkedin.com/in/akshay-pratap-srivastava-97b62223b

Call Me

+91 8303068757

PowerBI Project

Wavecon Telecom Analysis

Domain/Function: TELECOM

Wavecon is a leading telecom provider offering high-speed 4G and next-gen 5G services across 13 major cities. With 13 affordable plans designed for every type of user, Wavecon ensures reliable connectivity, wide coverage, and customer satisfaction. It empowers individuals and businesses through sea

View Project
Engagement

Following the 5G launch, there was a significant 23.5% increase in user unsubscriptions compared to the pre-5G period. A city-wise breakdown reveals t

Following the launch of 5G, our market share has declined—not drastically, but noticeably when compared to other telecom companies. While the industry

Project Details

This project focuses on analyzing the impact of the 5G launch on company revenue and key performance indicators (KPIs). It aims to identify which KPIs are underperforming post-launch and evaluate plan-wise revenue performance. The objective is to determine which plans are contributing positively and which are not after the rollout of 5G services

Live Interactive Dashboard

Excel Project

E-COMMERCE SALES ANALYSIS

Domain/Function: Sales

This is E-commerce Sales data i have done Some analysis with help of some Chart To show My KPI like Year over Year Growth of the company profit of the company Top products With Bottom Products also and Many More This only Possible With Help Of Excel

View Project
Engagement

View Project
on GitHUB

In This Image I showed the actual Dashboard from which we can help to client understand His Business and get Insights Easily

In this Image I applied a filter to show case the sales ,Profit and many thing By Regions

Project Details

● Collect e-commerce sales data, including orders and product details.
● Analyze profit margins and categorize products for insights.
● Cleanse Excel data, removing errors for accurate analysis.
● Validate findings using MySQL Workbench through SQL queries

SQL Project

SWIGGY CASE STUDY

Domain/Function: FOOD DELIVERY

I recently completed an SQL project analyzing Swiggy’s data. By applying SQL queries, I was able to uncover valuable insights and address key business requirements. This project demonstrated the impact

View Project
Engagement

This is the schema of SQL tables and there relationship between tables are define and from doing we will get some meaning-full and correct data

This is the queries are Build to full-fill the need of business Requirement and by getting the data management can take some Business Action

Project Details

Swiggy, a leading food delivery platform, operates in a highly competitive market where efficient delivery operations are crucial to maintaining customer satisfaction and profitability. With millions of orders processed daily, Swiggy needs to manage and analyze vast amounts of data to optimize delivery times, understand customer preferences, But in this Project we have taken a small data set to understand the domain and business Requirement

PowerBI Project

HR PERFORMANCE ANALYSIS

Domain/Function: HR

There we are using power query editor and also transform data in data type format and loaded on power bi desktop then does the data visualization uses various chart like Bar chart, Line chart, stacked column chart , Donut chart , Pie chart , Filter and cards.

View Project
Engagement

View Project
on GitHUB

There is image of Dashboard where you can go by clicking Action button what are the action is needed we have to take to improve in HR Perfromamce

This image Shows The Details of the Employee What they Think About The company and the His Job and Many More.

Project Details

HR data analysis project is divided in three section are –
In Its first page represent all basic data about company and also called home page of that project. In this
. The second page is represent the Action page were we have to take some type of action like To terminate some employee and give the promotion to the some employee also
. Third last page represent the detail page of a employees about his job satisfaction and overtiming and how much employee are working in each department and how many I have to fire them and how many employees I have to give the promotion letter to them.

Live Interactive Dashboard

PowerBI Project

HEALTH COST ANALYSIS

Domain/Function: Health

Excited to unveil my new Power BI health cost dashboard! It features treatment costs, per-day room charges, geographic billing insights, disease revenue analysis, and service types—all enhanced with dynamic cards and filters. Check it out for a comprehensive view of health cost data

View Project
Engagement

This Dashboard Includes a Analysis in Treatment Cost by Using a City and State and also includes a by services Provided by a Hospital and % wise also

Delved into billing analysis with a focus on geographic variations. My Power BI dashboard uses interactive maps to display billing amounts by city

Project Details

A short Info of a Health cost dashboard in Power BI
Treatment Costs: Detailed analysis of patient treatment expenses.
Per-Day Room Charges: Breakdown by patient.
Geographic Insights: Treatment costs visualized by city and state using interactive maps.
Disease Revenue Analysis: Insights into which diseases are generating the highest revenue.
Service Types: Overview of the types of services provided.
Dynamic Cards & Filters: Enhanced data visualization and exploration with the latest Power BI features.

Live Interactive Dashboard

Excel Project

CALL CENTER ANALYSIS

Domain/Function: BPO

Project Name: Call Center Analysis Report (FY 2023-2024) Tool Used: Microsoft Excel Objective: To provide real-time insights into call center performance, improve agent efficiency, and enhance customer experience through interactive dashboards.

View Project
Engagement

Identifying peak call days helps optimize staffing, reduce idle time, and improve efficiency.

Track gender and city-based engagement help tailor support strategies enhance service quality improve response times and optimize customer interaction

Project Details

Project Name: Call Center Analysis Report (FY 2023-2024)
Tool Used: Microsoft Excel
Objective: To provide real-time insights into call center performance, improve agent efficiency, and enhance customer experience through interactive dashboard