Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Nikhil Prasannan

Summary

Data analyst with one year of experience in data collection, processing, and analysis. Proficient in Excel, SQL, Power Bi and Tableau for generating reports and visualizations. Skilled in identifying trends and providing actionable insights to stakeholders

Overview

1
1
year of professional experience
1
1
Certification

Work History

Data Analyst

Sant Parmanand Hospital
2023.09 - 2024.08

- Collected, cleaned, and organized healthcare data from various sources, improving data accuracy by 15%.

- Utilized statistical techniques and data visualization tools to identify trends, resulting in a 20% improvement in decision-making efficiency.

- Key Project: Emergency Room Dashboard – Enabled stakeholders to make informed decisions regarding resource allocation, reducing patient wait times by 25%.

Education

Bachelor of Arts - (Hons.)Economics

Dyal Singh College
06.2018

Skills

    ●Microsoft Power Bi

    ●Microsoft Excel

    ●Data Scripting Tools : SQL, PostgreSQL

    ●Tableau

    ●Python

    ●Strong Analytical skills.

    ●Excellent communication skills, written and spoken.

    ●Organizational and presentational skills.

    ●Interpersonal and managerial skills.

Certification

● Google Data Analytics Professional Certificate

● Udemy Microsoft Power BI desktop for business intelligence

● Udemy Microsoft SQL server Database Management course.

Projects

Microsoft Excel

Sales Snapshot

Provided insights into the store's sales performance, leading to a 10% increase in sales strategy effectiveness.

Microsoft Power Bi

● HR Dashboard

I created a Power BI dashboard to track key HR metrics, including employee headcount by qualification and attrition rate trends, identifying areas for improvement.

● Electric Vehicle Analysis

Compiled and visualized data on electric vehicles in the USA, detailing total counts and average ranges for BEVs and PHEVs.

Tableau

● McDonald Food Nutrition Analysis

Provided insights into dietary impacts, contributing to a 5% improvement in menu healthfulness.

● UPI Adoption Dashboard

Developed a dynamic Tableau dashboard to identify and visualize countries discussing or implementing Unified Payments Interface (UPI), offering a clear overview of global UPI adoption trends.

● Amazon sales data

Led a Tableau project for Amazon, creating custom dashboards with in-depth insights into product categories and sales performance by state.

SQL

Pizza Sales Analysis

Designed and implemented a SQL-based analysis of pizza sales data to uncover insights and optimize business strategies


Timeline

Data Analyst

Sant Parmanand Hospital
2023.09 - 2024.08

● Google Data Analytics Professional Certificate

● Udemy Microsoft Power BI desktop for business intelligence

● Udemy Microsoft SQL server Database Management course.

Bachelor of Arts - (Hons.)Economics

Dyal Singh College
Nikhil Prasannan