Hellođź‘‹, I'm

Bhanu Khandelwal

Data Analyst

Typing Animation

bhanu khandelwal

About Me

Introduction
coder gif

A skilled data analyst proficient in Python, SQL, Power BI, EDA, Excel, and Machine Learning. Completed a comprehensive 1000+ hour Data Analytics and Generative AI/Prompt Engineering course at Masai School with hands-on experience in individual and collaborative projects. Seeking an opportunity to apply the skills and knowledge while continuing to learn and grow in this dynamic field.

Bhanu Khandelwal

+91-8233141633 | +91-9413734941
bhanukhandelwal75@gmail.com
bhanu-khandelwal
bhanukhandelwal75

Work Experience

Professional Journey

Hecta Proptech Pvt. Ltd (Property Investment Company) 2024 – 2025

Role: Data Analyst & Automation Engineer

Tech: Python | SQL | Power BI | Ms-Excel | Apache-Solr | Gen AI | Web-Scraping

  • Automated Cataloguing & Auto-update: Built AI-driven cataloguing pipeline using Python, Regex, GenAI prompts & Google Maps API. Improved data accuracy & saved 100+ hours/month through Solr-based indexing & auto-sync of auction property data.
  • Auction Property Data Scrape: Developed real-time scraping system from multiple auction platforms using BeautifulSoup, API analysis & AWS S3 integration—boosting property supply by 70%.
  • Availability Index Algorithm: Designed and deployed a scoring model using SQL, Solr & Python ML to prioritize high-potential properties—enhancing lead conversion by 15%.
  • Sales & Leads Dashboards: Built interactive dashboards in Power BI to visualize city-wise monthly sales revenue, lead generation sources, engagement metrics, and conversion rates—enabling data-driven decision-making for sales & marketing teams.

Bharat Petroleum Corporation Ltd (Oil & Gas Company) 2021 – 2022

Role: Technical Engineer

  • Analyzed fuel & lubricant sales, consumption & footfall across petrol pumps to generate performance reports for operations team.
  • Monitored transformer voltage readings, identified peak hours & visualized insights via dashboards for senior management.
  • Installed and configured Siemens smoke detection systems in buildings, built dashboards to monitor alerts, device health, and usage trends for safety reporting.

Certifications

My Certificates Double Click on Certificate To View Certificates

Technical Skills

Skills & Tools

Languages

Python
EDA

Dashboard

PowerBI
MS Excel

Databases

MySQL
MongoDB

General Tools

Git, GitHub
VS Code
Apache Solr
Genrative AI

Projects

Few Projects I've Build

Cars24 Insights

This project utilizes Python for web scraping and exploratory data analysis (EDA), SQL for data management, and Power BI for visualization. It provides insights into used car prices, popular models, and market trends in Delhi and Mumbai. The goal is to deliver a comprehensive overview of the used car market, highlighting regional differences and pricing patterns.

Solo Project: Completed in 5 days

Tech Stack: Python | PowerBI| SQL | Excel | EDA |

E-Commerce Analytics : Insights and Vizualization

This project aims to analyze the sales data of a Brazilian e-commerce store from 2016 to 2018. The main objectives are to understand sales trends across different states, identify states with declining or increasing trends, perform a root cause analysis for their performance, and provide recommendations for improvement.

Collaborative project:: Accomplished with a team of 4 developers, completed in 6 days

Contribution: Team lead | Dashboard Making | Frontend Workflow & Design | GitHub Management

Tech Stack: Python | PowerBI| SQL | Excel | EDA | package

Credit Card Transaction

The primary goal of this project is to gain comprehensive insights into credit card transactions and customer behaviors using advanced data analytics techniques. By leveraging Power BI, Python, SQL, Excel, and exploratory data analysis (EDA), this project aims to identify spending patterns, detect anomalies, segment customers, and provide actionable recommendations to enhance decision-making and business strategies.

Solo Project: Completed in 5 days

Tech Stack: Python | PowerBI| SQL | Excel | EDA |

GitHub Statistics

& Calender

react-activity-calendar

Contact Me

bhanukhandelwal75
Bhanu khandelwal
bhanukhandelwal75@gmail.com
+91-8233141633

Thank You for visiting my PortFolio.