Data Analysis
Project
Tableau
Projects
PowerBI
Projects
ME
Welcome to My Professional Portfolio!
I'm Bhavana Pansare, a passionate Data Analyst currently pursuing my MSc in Data Analytics at Queen's University Belfast. My journey in data science has been driven by a deep-seated curiosity and a desire to uncover actionable insights that drive business innovation and growth.
🚀 Professional Journey:
In my role as a Data Analyst Intern at Incisiv Ltd, I've had the opportunity to make significant contributions by designing Power BI dashboards that increased visualization clarity and usability by 40%. I also optimized SQL procedures and automated data refreshes using Python, reducing data processing time by 50%. My work involved conducting advanced analyses on product performance, customer segmentation, and LTV modeling, which supported key strategic initiatives.
Previously, as a Software Developer at Bridgenext , I led efforts in gathering requirements and exploring data to enhance decision-making processes. By optimizing SQL queries, I improved data retrieval speed by 40% and developed real-time monitoring dashboards that reduced issue resolution time by 50%. My focus on backend application performance resulted in a 20% improvement, showcasing my ability to blend technical proficiency with strategic insight.
📈 Data-Driven Excellence:
Throughout my career, I have consistently delivered data-driven solutions that have had a meaningful impact. At Energia Group, I spearheaded the analysis of renewable energy data, using advanced clustering techniques to improve trading decision accuracy. My work on satellite data-driven greenspace classification at Deloitte involved employing deep learning architectures like DeepLabV3 and U-Net, achieving an impressive 99.82% classification accuracy.
In another project at KDC Insurance Company, I assessed the economic impact of Hurricane Ian, using advanced preprocessing and visualization tools to quantify financial risks. These projects highlight my ability to leverage data science techniques to solve real-world problems and drive business growth.
📚 Academic Pursuit:
My academic journey at Queen's University Belfast has allowed me to deepen my expertise in areas such as machine learning, big data, and database management. With top marks in modules like Data Mining and Machine Learning, I am committed to staying at the forefront of industry trends and continuously enhancing my skills to make a meaningful impact in the field of data analytics.
🌟 Let's Collaborate and Connect
I believe in the power of data to transform businesses and am always excited to collaborate with like-minded professionals and organizations. Whether you're interested in discussing innovative data strategies, exploring collaboration opportunities, or simply exchanging insights, I'd love to connect with you.
SKILLS
Python
Excel
PowerBI & Tableau
SQL (MySQL, PandaSql, PostgreSQL)
Machine Learning & Deep Learning
Web Development
Big Data
AWS
Data Storytelling
MS Office Suite
Data Analyst.
Queen's University Belfast, Northern Ireland
MGM College of Engineering and Technology, Mumbai, India
Grade: First Class Honours
Core Modules: Computer Organization & Architecture, Operating Systems, Statistics, Computer Networks, Big Data, Machine Learning, Database Management System, Data Mining, Business Analytics, Python Programming
Incisiv, Belfast, Northern Ireland
Bridgenext, Pune, India
PROJECTS
The Energia Group has provided us with the dataset of Electricity Industry in the All Island (AI), Northern Ireland (NI), and the Republic of Ireland (IE) for each type of renewable sources of energy including Wind Energy, Solar Energy, and Hydro Energy. The given dataset was analysed by plotting different graphs to understand the data and gain insights. Later, the data was pre-processed and cleaned using the Python programming language in Jupyter Notebook.
Deloitte has provided a challenge for Analytathon 2 for classifying greenspaces within the Belfast area utilizing the dataset of Sentinel Images. The data is generated from the Sentinel-2 L2A Satellite with high-resolution images from the satellite covering an area of 10 meters. Greenspaces include various areas of green vegetation, such as parks, forests, and street trees. The goal of this challenge is to use machine learning algorithms such as supervised classification or deep learning techniques, to accurately label the greenspaces areas in the provided image dataset. So, to address the problem, we divided the solution into different parts. The first part involves exploring the data by printing the images and labels to gain more insights into the dataset. Following this, we prepared a scene classification mask. Later, we split the dataset into train, test, and validation datasets. Consequently, we applied different machine learning models and selected the best model by analysing the results, of the model which accurately classifies the greenspaces.
The Analytathon Challenge aims to evaluate the financial impact of Hurricane Ian on properties insured by KDC Property Insurance. In this we need to find two things first, calculating the maximum inherent cost of destruction for properties at high risk of hurricane damage, and second, identifying the most affected geographic areas. By utilizing the shapefile for the hurricane path and property data, we need to determine the cost implications of building, contents, and outbuildings coverage for properties located in the most endangered ZIP codes. The results of this analysis will play a vital role in planning and risk management within KDC Property Insurance.
& CERTIFICATIONS
Emtec Excellence Award
Data Visualization with power BI Great Learning
KPMG Internship
Exploratory Data Analysis in R
Machine Learning for Time Series Data in Python
Intermediate R
Introduction to Data Analytics for Business
Google Cloud Fundamentals
Project Management
Advance Python
