Pramod Negi

Results-driven professional with an MBA in Marketing & Analytics, skilled in SQL, Python, Power BI, and Machine Learning. Experienced in data analysis, business intelligence, and market research, driving insights for strategic decision-making. Proven ability to optimize processes and enhance efficiency, making data-driven recommendations for business growth.

• Python by IIT Madras
• Machine Learning by Great Learning
• SQL by Code Basics
• Statistics for Data Science by CloudyML
• Marketing Analytics by Great Learning

• Represent DSM(DTU) volleyball team at university level and achieved second rank | 2023

Railway Database Analysis Using SQL

 Analyzed train cancellation data to determine the total number of cancellations and identified the top 5 stations with the highest and lowest cancellation rates.

 Calculated total revenue and booking counts for each station, revealing revenue generation patterns and booking preferences between online and station-based transactions., Identified peak booking months and revenue trends, showing which months had the highest booking volumes and revenue.

EDA on Swiggy Dataset

 Conducted exploratory data analysis on the Swiggy Restaurants dataset for the Top 50 Cities.

 Identified and handled missing values in the dataset and removed irrelevant columns to streamline the analysis., Utilized Python libraries such as NumPy, Pandas, Matplotlib, Seaborn, and Warnings for data visualization.

 Plotted and visualized the distribution of restaurant ratings and the availability of food delivery facilities for insights and understanding. 

House Price Prediction, 

Developed a high-accuracy machine learning model to predict house prices in Delhi, optimizing performance with industry-leading metrics such as RMSE, MAE, and R² Score., Executed advanced data preprocessing and feature engineering, including handling missing data and encoding categorical variables.