Jyoti Kumar

Data Analyst

[email protected] +1 2243108300

Resume

Hello, I am

Jyoti Kumar.

2

Excel
Projects

3

PowerBI
Projects

About Me

Hi, I am Jyoti Kumar -- a Data Analyst with a passion for uncovering stories through data.

After taking a career break, I reskilled through a structured bootcamp that helped me rebuild confidence and sharpen my skills. Along the way, I challenged myself by competing in two online dashboard creation contests -- and that's just the beginning.

Here I am now -- continuing to grow, create, and explore the endless possibilities data has to offer!!

Key Skills

Microsoft Power BI

Advanced Excel

SQL

Story Telling

My Projects

Call Center Report

Domain/Function: Call Center

Sales Analytics

Domain/Function: Sales and Marketing

Business Insights 360

Domain/Function: Business Intelligence/ Finance

Financial Reporting and Analysis

Domain/Function: Finance

Banking Customer and Transaction Analysis

Domain/Function: Finance/Banking

My Experience

Virtual Internship (Job Simulation)

Accenture, Data Analyst

Forage | February 2024 – March 2024

· Automated the cleaning and transformation of a 36-million-row dataset using Power Query in Excel, saving 4 hours of repetitive manual work per update.

· Presented a PowerPoint report highlighting the top 5 content categories by popularity, with recommendations projected to boost user engagement by 25% if implemented.

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

Associate Data Analyst in SQL

Power BI Fundamentals

Data Manipulation in SQL

Data Visualization in Power BI

SQL Basic Certificate Hacker Rank

PostgreSQL Summary Stats and Window Functions

Joining Data SQL

Introduction to Statistics

Accenture North America project completion certificate

Intermediate SQL

HR Analytics in Power BI--Case Study

Exploratory Data Analysis in SQL

Beginners DAX Functions Workshop

Data Modeling in Power BI

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/jyoti-sharma7/

Call Me

+1 2243108300

GitHub

https://github.com/jyotikumar07

Excel Project

Call Center Report

Domain/Function: Call Center

An Interactive dashboard designed in Excel to provide a visual performance summary of call center representatives. Analyzed over 1,000 calls totaling 1,497 hours and 30 minutes of talk time.

View Project
on GitHUB

Other Tools

Pivot Table

Pivot Chart

Conditional Formatting

Call Center Representatives Summary

Call Center Report

Project Details

This dashboard provides a clear performance summary of call center employees, identifying top performers and areas for improvement. It enables data-driven decisions on targeted training and workforce optimization, ultimately improving efficiency and reducing operational costs.

Excel Project

Sales Analytics

Domain/Function: Sales and Marketing

This report was designed in Excel to provide insights into the Sales and Financial operations of the organization, determine effective customer discounts, and identify potential expansion opportunities, thereby instilling confidence in the financial outlook.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Pivot

Power Query

DAX

Calculated Columns

Conditional Formatting

Shows countries' actual performances vs. planned.

Shows gross margin by countries.

Project Details

• Created a customer performance report to show Customer Net Sales Performance over the years 2020 and 2021.
• Conducted a comprehensive comparison between Countries' performances and Net sales targets
• Created a Profit and Loss Statement for fiscal years 2019 to 2021.
• Performed an ETL methodology (Extract, Transform, Load).
• Generated a date table using Power Query.
• Ability to derive fiscal months and quarters.
• Established data model relationships with Power Pivot.

PowerBI Project

Business Insights 360

Domain/Function: Business Intelligence/ Finance

Business Insights 360" is a comprehensive Power BI solution designed to provide a holistic view of key business performance across various departments. It integrates financial, operational, and sales data to deliver actionable insights, enabling stakeholders to make data-driven decisions.

View Project
on GitHUB

Other Tools

Power Query

Excel

Power BI Desktop

Power BI Service

Provides visuals related to various products and customers' performances from the sales perspective.

It's all about the market share and yearly sales trends.

Project Details

• Extensive data cleaning, transformation, and shaping were performed using Power Query Editor to ensure data quality, consistency, and proper formatting for analysis.
• A robust set of Data Analysis Expressions (DAX) measures has been developed to calculate key metrics, create complex calculations (e.g., YoY growth, running totals, forecast errors), and enable dynamic analysis.
• DAX Studio was utilized during the development phase for performance tuning of DAX measures and queries, ensuring optimal report responsiveness and efficiency.

Live Interactive Dashboard

PowerBI Project

Financial Reporting and Analysis

Domain/Function: Finance

The project has two essential perspectives: the actual financial outcome and the original budgetary expectations. Provided a well-designed financial Statement report with trends, variance, and patterns to reveal the business’s economic health and operational effectiveness.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Point

Power BI

Actual vs. Planned Revenue

Actual vs. Planned Expenses

Project Details

• Visualized 3 years of actual vs. planned revenue and expenses in Power BI, uncovering trends and variances to support more accurate budgeting for a SaaS company.
• Challenged myself by choosing the advanced ZoomCharts version of the Power BI challenge, mastering 15+ visuals formatting options and drill-down features to improve analytical depth and usability.

Live Interactive Dashboard

PowerBI Project

Banking Customer and Transaction Analysis

Domain/Function: Finance/Banking

Financial institutions can use this report to gain a deeper understanding of customer behavior and preferences, as well as to identify early indicators of financial distress.

View Project
Engagement

View Project
on GitHUB

Other Tools

Figma

Power BI

Data Modeling

Know the preferred and transactional behavior of your customers.

Trends and Patterns of revenue and expenses.

Project Details

• Designed a comprehensive dashboard, integrating over 10 key customer metrics.
• Identified the Middle-Income segment as the most transaction-active (~9,000 transactions); Loans as the largest revenue generator and 100% driver of overdue payment.