Ranjit Ghadge | Data Analyst

Ranjit Ghadge

Data Analyst

Based in Pune

About

Experienced Data Analyst with expertise in Data Analysis, Machine Learning, and Visualization. I excel at uncovering insights from complex datasets using advanced techniques and presenting them in an actionable manner. My creative and logical approach to problem-solving has led to successful projects that benefit businesses. Committed to continuous learning, I stay at the forefront of data science to deliver innovative solutions. I am eager to collaborate on projects that leverage data for strategic decision-making.

Skills

Projects

Netflix Movies & TV Shows Clustering

The goal of this project is to find similarities within groups of people in order to build a movie recommendation system for users. This project aims to address this issue by providing tailored recommendations to enhance the user experience.

Bike Sharing Demand Prediction

In urban areas, rental bikes enhance mobility comfort by reducing waiting times. Predicting hourly bike demand is crucial for ensuring a stable supply, optimizing availability, and improving citywide accessibility.

Credit Card Default Prediction

This project focuses on predicting credit card payment defaults among customers in Taiwan. Emphasizing predictive accuracy in estimating default probabilities is more valuable for risk management than a binary classification of credible or non-credible clients.

Hotel Booking Analysis

This hotel booking dataset offers insights into optimal booking times, ideal lengths of stay, and the likelihood of receiving many special requests. Explore and analyze the data to uncover key factors influencing hotel bookings.

Adventure Works Cycles Analysis

Analyzed Adventure Works data using Power BI, revealing sales trends, customer behavior, and product performance. Crafted interactive dashboards for informed decision-making and enhanced business strategies

Cost Analysis - Budget vs Actual

Managed budget vs. actual analysis project at JPMC using Tableau and Excel, fostering data-driven financial decisions. Created insightful visualizations, pinpointing variances and enabling precise financial control.

A/B Testing for Marketing Campaigns

Conducted an A/B test comparing Facebook Ads and Google Adwords for an online retailer. Google Adwords showed better conversion rates and engagement. Recommended scaling Google Adwords and optimizing Facebook Ads, using data cleaning, exploratory analysis, and hypothesis testing in Python.

Improving Upfront Pricing Precision for Ride-Hailing Service

Analyzed discrepancies between predicted and actual ride prices. Identified issues with distance, duration, device compatibility, and GPS. Recommended refining algorithms and enhancing device and GPS handling to reduce inconsistencies and improve satisfaction.

Guestimate: Blinkit Store Launch Staffing Requirements

Estimated the staffing needs for Blinkit's new Pune store, determining that 176 delivery partners and 29 store workers are required for smooth operations. The analysis factored in peak times, operational buffers, and industry standards.

Experience

2022-2023

Data Science Trainee

As a Data Science Trainee at Almabetter, I embarked on an immersive journey into the world of data science, honing my skills and knowledge in this dynamic field. I delved into a rigorous curriculum encompassing a wide spectrum of data science concepts and tools during my tenure. I actively participated in hands-on projects, including data cleaning and preprocessing, exploratory data analysis (EDA), predictive modeling, and data visualization, all while working collaboratively with peers and mentors. This experience expanded my technical expertise, shaped my problem-solving abilities, and instilled a strong commitment to continuous learning, preparing me to excel in the field of data science.

2021-2023

Junior Engineer

In my role as a QS & Billing Engineer, I gained valuable experience that seamlessly aligns with the demands of Data Analysis and Data Science. I excelled in data visualization and reporting, crafting impactful dashboards using tools like Excel and PowerBI, with a focus on financial metrics like Profit Margin. My proficiency in quantitative analysis extended to tasks such as Rate Analysis, Cost Analysis, tracking project costs, and optimizing cash flow management all of which are highly transferable skills. I also demonstrated the ability to proactively track project costs, negotiate contracts, and conduct reconciliations, significantly reducing payment cycle times. This diverse skill set equips me to excel in roles where analytical prowess and data-driven decision-making are paramount.

2023-2024

Data Analyst - Zoplar

-Achieved a 30% average monthly sales increase by orchestrating the development of a comprehensive sales dashboard, providing actionable insights that facilitated informed decision-making. – Elevated task adherence of the sales team by 35% by delivering daily, on-time, and accurate reports with important insights, providing critical metric visibility that significantly improved team efficiency. – Reduced daily manual import time by 80% and enhanced data accuracy and reliability by implementing an automated data extraction process, creating a streamlined data pipeline from the database. – Improved target achievement by 25% through the formulation and execution of rewarding incentive policies, fostering consistent month-on-month sales improvement and delivering measurable results.

Education

2016-2020

Bachelore of Civil Engineering