Entry-Level Data Analyst | Business Analyst

Hi, I'm P. V. Dharani

I transform raw data into actionable business insights using Excel, SQL, Python and Power BI. I build clean dashboards, perform EDA, and deliver KPI-driven reports.

Download Resume View Projects GitHub Profile Notion Case Studies

About Me

I’m an MCA student and aspiring Data Analyst with practical experience in Excel, SQL, Power BI, Tableau, and Python. I build dashboards, perform EDA, and deliver KPI-driven reports.

Skills Experience Education

Data Analysis

Excel, SQL, Python

Visualization

Power BI, Tableau

Spreadsheets

Pivot Tables, Power Query

Databases

MySQL

Data Analyst Intern — ExcelR Solutions

EDA, KPI dashboards, Excel, SQL, Power BI, Tableau

Python & MySQL Intern — ThopsTech

Python (Pandas, NumPy) and SQL for analytics

Project Experience

CRM Analytics, Insurance Analytics

Master Of Computer Applications - MCA

Sri Venkateshwara College Of Engineering, Tirupati – CGPA 9.35

Bachelor Of Computer Science - B.Sc

Medha Degree College, Mydukur – CGPA 8.21

Projects

Insurance Analytics Dashboard

Interactive analytics dashboards built in Power BI, Tableau, and Excel to analyze premiums, renewals and cross-sell KPIs.

Tools: Excel, Power BI, Tableau, SQL

View Case Study GitHub Repo

YouTube Spam Comment Detection

Machine learning model to classify spam/ham comments using NLP techniques, integrated with a Flask-based prediction UI.

Tools: Python, ML, NLP, Flask, SVM

View Case Study GitHub Repo

Python Mini Projects

A collection of beginner-to-intermediate Python mini projects focusing on logic building, problem-solving, and core Python concepts.

Tools: Python, Control Flow, Functions, OOP, File Handling

View Case Study GitHub Repo

Excel Data Analysis Project

Data analysis project using Microsoft Excel with data cleaning, pivot tables, charts, and KPI analysis to generate business insights.

Tools: Excel, Pivot Tables, Charts, Power Query

View Case Study GitHub Repo

CRM Analytics

CRM analytics project focused on analyzing customer lifecycle, lead conversion, sales performance, and revenue trends to enable data-driven business decisions.

Tools: Excel, SQL, Power BI, CRM KPIs, Tableau

View Case Study GitHub Repo

Portfolio Website

Personal portfolio website built with HTML, CSS, and JavaScript and deployed using GitHub Pages.

Tools: HTML, CSS, JavaScript, GitHub Pages

View Case Study GitHub Repo

Certifications

Verified certifications that strengthen my Data Analyst profile.

🎓

NASSCOM FutureSkills — Data Analytics Certification

Issued by: NASSCOM

Completed: December 2

View Certificate

📊

ExcelR — Data Analyst Course Completion

Issued by: ExcelR Solutions

Modules Covered: Excel • SQL • Power BI • Tableau

View Certificate

CONTACT

If you’d like to connect, feel free to reach out.

• Email: pillidharani27@gmail.com

• LinkedIn: linkedin.com/in/pillidharani

• GitHub: github.com/pillidharani27-alt

• Notion Portfolio: P. V. Dharani Portfolio

• Location: Bangalore, India

Download Resume