+91-989*******

East Delhi-******, India

adynnp@r.postjobfree.com

AMIT

SINGH

KANDARI

Data Enthusiast

EDUCATION

Bachelors of Arts in Political

Science honors.

Bachelors of Computer

Application (1st year).

2023

2023

Delhi University

Indira Gandhi National Open

University

SKILLS

SQL Server

Python

Power BI

VBA

Adv. Excel

Highly skilled data enthusiast with expertise in

Data Analytics, Programming, Visualization,

and Database management. Passionate

about transforming complex data into

actionable insights.

CERTIFICATE

Adv. Computer Course in Microsoft

Office.

Master Certification in Business Data

Analyst.

WORK EXPERIENCE

Designed a Dynamic Excel sales Dashboard

using Pivot tables, Validations, and functions

like OFFSET, VLOOKUP, etc.

Analysis of AdventureWorks and MusicStore

dataset using SQL Server with views, joins,

Aggregate, and other SQL techniques.

Built HR analytics dashboard and Sales

Dashboard on Power BI with data cleaning,

transformation, and visualizing KPIs using

cards, donuts, bars, line charts, etc.

Performed exploratory data analysis on the

Adventurework database, utilizing Python

libraries such as NumPy, Pandas, Matplotlib,

Seaborn, etc.

10/2022-01/2023

Data Analyst intern

F1 Macro Technologies

MS Office

Responsible for the Maintenance of Systems

and Management of Networks, Software, and

Data.

11/2022-04/2023

IT Executive

The Delhi Golf Club

04/2022-Till Now

Created Dynamic Excel Revenue Dashboards

using VLOOKUP, Pivot tables, validations, and

functions like OFFSET and INDEX.

Responsible for managing and analyzing

data, generating reports, and providing

insights to support decision-making

processes.

Utilize advanced Excel functions and VBA

Skills to create Automated Excel Reports.

Conducted comprehensive in-house training

sessions for all employees, fostering

professional development and optimizing

team performance.

MIS Executive

VTS Infosoft Pvt. Ltd.

Contact this candidate