Neeraj Gupta

Revenue Analyst

Treebo Hotels•  November 2023 - Present

• Conducted thorough analysis of historical revenue data to identify trends and patterns. • Automated reporting processes, reducing time spent on routine tasks by 30% • Collaborated with cross-functional teams to develop pricing strategies based on market demand and competitor analysis. • Presented analytical findings to senior management, providing actionable insights for decision-making.

Data Analyst

Shri Mahavir Ferro alloys Pvt Ltd•  February 2023 - November 2023

 Achieved reduction in unplanned plant halt time by 25% by introducing insightful KPIs and created a Power BI dashboard to understand the performance of various plant equipment.  Used SQL to extract desired information, and performed data cleaning using Excel and Python upon which analysis was to be performed.  Perform sampling, Descriptive statistical analysis, and ANOVA test to compare monthly plant performance as per norms.  Build a cold compressive strength determination model using Lasso and Ridge regression, Decision tree, and Random Forest by selecting 8 important input parameters and performing cloud deployment for industry decision-making purposes.  Studying and analyzing equipment’s parametric trends during the breakdown.  Managed a team of 5, comprising of cross-functional members across regions to understand the hurdles in plant productivity and provided timely data-driven solutions for the same

Data Analyst

Tutort Academy•  June 2022 - December 2022

Generate and maintain regular HR Excel reports and BI dashboards to track employee KPIs.  Leveraging data-driven insights to identify and target prospective candidates with the highest potential for course enrollment increased CTA’s to 32%.  Collecting and analyzing on-boarding feedback and suggesting satisfactory actions.

Assistant Professor

ARMIET Engineering college•  December 2021 - May 2022

Trained students on Python, SQL, and Web Scraping using Python. Worked in collaboration with the data analytics department to tackle drop-outs without fee payment by analyzing student performance and considering various inputs using Excel dashboard.