Prabhat Ranjan

Conducted exploratory data analysis on service booking records using Python and SQL, identifying seasonal demand patterns, peak booking hours (10 AM–1 PM), and service-wise booking trends. Built ARIMA and Prophet forecasting models to predict service demand, capturing trend and seasonality patterns for 4-week workforce planning.

Built

Power BI dashboard tracking revenue, conversion rate (∼78%), and cancellation rate (∼14%) across 3 service categories, used by management for weekly operational reviews.

Data Analytics Intern - Swiftly Seva Multi Utility Pvt. Ltd.

(2025-05 - 2025-07)

• Conducted exploratory data analysis on service booking records using Python and SQL, identifying seasonal demand patterns, peak booking hours (10 AM–1 PM), and service-wise booking trends.
• Built ARIMA and Prophet forecasting models to predict service demand, capturing trend and seasonality patterns for 4-week workforce planning.
• Built Power BI dashboard tracking revenue, conversion rate (∼78%), and cancellation rate (∼14%) across 3 service categories, used by management for weekly operational reviews.
• Analyzed booking completion, cancellation, and demand patterns across cities and service categories, generating actionable insights for workforce planning and operational efficiency.

Coverage Head | Spardha'24 - IIT (BHU), Varanasi

(2024-09 - 2024-10)

• Led end-to-end sports fest media coverage for 500+ participants, overseeing content planning, videography, editing, and media releases across platforms.

Event Coordinator — Frame by Frame | FMC Weekend - IIT (BHU), Varanasi

(2023-08 - 2023-11)

• Coordinated logistics and 100+ participants for Frame by Frame photography event; contributed to successful execution of college fest.

B.Tech - Chemical Engineering - Indian Institute of Technology (BHU), Varanasi (2022 - 2026)

CBSE Class XII - P C High School, Patsa, Samastipur (2021 - 2021)

CBSE Class X - P C High School, Patsa, Samastipur (2019 - 2019)