Name: Arun Jakhmola

Job Role: Data Analyst

Location: Delhi, India

Skills

POWER BI 75%
SQL 75%
Data Visualization 75%
PYTHON 60%
Statistical Analysis 70%

About Me

About Me

With over 3 years of comprehensive experience in the field of research analytics, particularly in the Insurance sector, I hold a Master of Commerce in Management and a Bachelor of Commerce in Finance. Proficient in data analysis, statistical analysis, customer behavior analysis, and financial data examination. Skilled in Microsoft Excel, Power BI, SQL, and Python, with a track record of providing insightful data-driven solutions.

  • Profile: Data Analytics
  • Education: Master of Commerce
  • Language: English, Hindi
  • Tools: Jupyter Notebook, Microsoft Excel, MySql, Dbeaver & Power BI
  • Other Skills: SQL, MS Excel & Python
  • Interest: Photography, Cricket & Food Walks

0 +   Projects completed

LinkedIn

Tech Stack

Tech Stack

power bi

Power Bi

power bi

Ms Excel

mysql

MySql

python

Python

jupyter

Jupyter

NumPy

NumPy

Pandas

Pandas

Matplotlib

Seaborn

Matplotlib

Matplotlib

Resume

Resume

Seasoned Analyst with the experience of driving business strategies through data-driven insights. Proven expertise in data analytics, statistical analysis and project management.

Education

Education


Aug 2023 - Present

Data Analyst Certification Course

Coding Invaders
2021-2023

Master of Commerce

IGNOU
2016-2019

Bachelor of Commerce

University Of Delhi
2015-2016

Sr. Secondary School

Preet Public Sr. Sec. School
2013-2014

Secondary School

Preet Public Sr. Sec. School

Projects

Projects

Below are the sample Data Analytics projects on SQL, Power BI & Python.

AtliQ Hotels Revenue Analysis

The AtliQ Hotels Data Analysis project leverages SQL for data extraction and transformation, and Power BI for dashboard creation. Key insights include total revenue, occupancy rates, and customer ratings, aiding in strategic decision-making for optimizing market share and revenue.

Tools Used: Excel Power BI

HR Absentees Data Analysis

This project aims to analyze absenteeism data using Power BI to uncover insights and trends. The analysis includes data visualization and extracting key metrics to provide a comprehensive overview of absenteeism patterns.

Tools Used: SQL Power BI

Toman Bike Share Analysis

The Toman Bike Share Project involves the analysis of bike share data for the years 2021 and 2022. This project utilizes SQL for data extraction and transformation, and Power BI for data visualization. The data is stored in three CSV files and is analyzed to gain insights into usage patterns, financial performance, and other key metrics.

Tools Used: SQL Power BI

Bank Loan Dashboard

In order to monitor and assess our bank's lending activities and performance, we need to create a comprehensive Bank Loan Report. This report aims to provide insights into key loan-related metrics and their changes over time. The report will help us make data-driven decisions, track our loan portfolio's health, and identify trends that can inform our lending strategies.

Tools Used: Excel

Coffee Sales Dashboard

This dashboard provides an insightful analysis of coffee sales data, created using Microsoft Excel. The dataset includes information on orders, customers, and products, allowing for a comprehensive view of sales performance over time, by region, and by customer.

Tools Used: Excel

Retail Order Analysis

This project involves analyzing retail order data. The analysis includes data cleaning, processing, and deriving insights using Python and SQL. The raw data was obtained from Kaggle, and the detailed steps of the analysis are documented in the following sections.

Tools Used: SQL Python

Walmart Sales SQL Analysis

This project aims to explore the Walmart Sales data to understand top performing branches and products, sales trend of of different products, customer behaviour. The aims is to study how sales strategies can be improved and optimized. The dataset was obtained from the Kaggle Walmart Sales Forecasting Competition.

Tools Used: SQL

Amazon Sales Analysis

The Amazon Sales Analysis project involves analyzing sales data to identify trends and patterns that can help in making informed business decisions. The project covers various aspects of data analysis including data preprocessing, exploratory data analysis, and visualization.

Tools Used: Python

Restaurant Order Analysis

The Restaurant Order Analysis project aims to analyze order data to identify the most and least popular menu items and types of cuisine. The analysis objectives and their corresponding queries are outlined below.

Tools Used: SQL


0 Total Projects
0 Years of Experience

More projects on Github

Certificates

Certificates

Here are some of the certificates I've earned from various courses.

Data Analytics Program

Issued by: Coding Invaders

Date: 2024-June

Coding For Data Analysis

Issued by: Sololearn

Date: 2024-April

SQL Intermediate Cert

Issued by: Sololearn

Date: 2024-February

SQL Basics Certificate

Issued by: HackerRank

Date: 2024-March

From Excel to MYSQL

Issued by: Linkedin

Date: 2023-August

Python Intermediate

Issued by: Sololearn

Date: 2024-February

Contact

Contact Me

Below are the details to reach out to me!

Address

Delhi, India

Contact Number

+91 93546 33132

Email Address

rnjakhmola@gmail.com

Download Resume

Updated_CV





Copyright © All rights reserved | This template is made with by Colorlib