Vaibhav Solanke

Shirdi

Overview

years of professional experience

WSP Consultants India

Noida

12.2022 - Current

ARCADIS (GEC INDIA)

Hyderabad

08.2021 - 12.2022

Scaler Academy

03.2025

National Institute of Technology

Nagpur

07.2020

Pune University (AVCOE)

06.2018

Netflix Business Case: Analyzed Netflix's TV show and movie data using Python libraries. The dataset included information on the cast, genre, duration, release year, year added to Netflix, director, and country of release. Key findings from the analysis revealed that "Dramas" and "International Movies" are the predominant genres for most titles, with the USA leading in the number of movies and shows added.
Target Case Study: Conducted an analysis of a large dataset using SQL and BigQuery to extract valuable insights into Target's operations in Brazil. This analysis covered approximately 100,000 orders placed between 2016 and 2018, providing a detailed overview of various dimensions such as order status, pricing, payment methods, and freight performance.
Loyaltics case study: Created interactive dashboards using Tableau to analyze the number of registered customers for the loyalty program. Conducted year-wise analysis of total sales amount and total refund amount.
CCD-(Coffee Chain Business Case Study: Analysis of market which had least contribution to total percentage sales. Identification of stores which have highest sales and profit.

Financial and economic analysis of Ahmedabad BRTS, Oct 2019.
Methods of estimation of socio-economic cost of road accidents, Oct 2019.
Recent advances in methods and approaches for sustainable urban transportation, Aug 2019.
Road Safety Audit, Dec 2018.
Applications of RS and GIS in Transportation Engineering and planning, Nov 2018.

Contributed and Participated in five days STTP program on 'Design And Evaluation Of Flexible Pavement', Dec 2018
Participated and contributed in one week workshop on 'Road Safety Audit And Construction Material', Dec 2018
Contributed in the organization & the management of 'Indian Road Congress Young (IRC-Y) Conference', 2018
Organizer of street play event during 'Indian Road Congress Young (IRC-Y) Conference', 2018