AVISHEK KUMAR MODI
New Delhi
Summary
Data Scientist with 3.5 years of experience progressing from Business Analyst to Data Analyst roles. Skilled in Python, SQL, AWS (EC2, Glue, Redshift), feature engineering, and machine learning algorithms (Decision Trees, KNN, Bagging Regressor, Linear Regression) for predictive modeling, time series forecasting, pricing analytics, and revenue management.
Overview
4
4
years of professional experience
Work History
Data Scientist
Lemon Tree Hotels
New Delhi
03.2025 - Current
- Dynamic Demand Forecasting for Pricing Engine (Revenue Management System): Developed snapshot-based machine learning forecasting system for hotel occupancy prediction across 7-time horizons (DBA 100 to same-day), achieving 5-20% MAPE and enabling accurate demand forecasting and planning.
- Engineered lag features (booking velocity) and entity-level features to capture non-linear demand patterns; built unified Bagging Regressor model for 40+ properties.
- Implemented model drift monitoring using pickup and booking curve metrics to detect behavioral shifts and trigger retraining; deployed system on AWS EC2 using Python.
- Overbooking Module for Pricing Engine (Cancellations): Developed cancellation prediction model for overbooking module in pricing engine, processing 500K+ records to forecast cancellations 7-30 days ahead across 40 hotels, increasing occupancy rates by 2-3%.
- Built KNN-based machine learning model with feature engineering (booking age, price quartiles, cyclical encodings); designed automated back-testing framework for continuous model validation and monitoring.
- Engineered end-to-end ETL pipeline using Python, pandas, NumPy to ingest data from SQL Server and AWS S3 Parquet files with schema validation and data quality checks.
Data Analyst
Lemon Tree Hotels
New Delhi
05.2024 - 03.2025
- Managing day-to-day functioning of the pricing engine: Contributed to converting a monolith pricing engine from Alteryx and SQL to modular Python code for improved efficiency and faster price optimization and push.
- Played a key role in managing and stabilizing the pricing engine of Lemon Tree Hotels.
- Conducted in-depth competitive pricing analysis for the engine, pinpointing and resolving pricing inaccuracies to enhance precision and effectiveness.
- Consistently resolved Revenue Managers' pricing queries raised on GitHub, to optimize hotel pricing strategies and improve outcomes.
- Automation using python and selenium:
- Cross price Elasticity: Automated CPE modeling in Python (using log-log regression), replacing Alteryx workflows to support quarterly pricing & competitor analysis.
- Automated STR data exchange and reporting using Selenium in python, uploading the reports on S3 parquets, enabling daily revenue submissions and report retrieval for 95 Lemon Tree Hotels, eventually saving ~80L per annum cost.
Business Analyst
dhurin
Noida
07.2022 - 04.2024
- Developed acquisition strategy scorecard for a leading NBFC using decision tree algorithm; performed feature selection with Information Value (IV) on customer demographics, financial behavior, and credit history variables; evaluated model performance using KS-Gini statistics.
- Built linear regression predictive model to estimate used car residual values (resale/on-road price ratio) using model-specific (engine capacity, color, model) and vehicle-specific (year of manufacture, ex-showroom price) features; performed data cleaning, feature engineering, and time series analysis (no significant trends observed), achieving 71% R-squared.
Education
Masters in Operational Research -
University of Delhi
New Dehi05-2022
B.Sc (Hons) - Statistics
Ramjas College, University of Delhi
New Delhi07-2020
Skills
- Python
- SQL
- DuckDB
- AWS
- Glue
- EC2
- Tableau
- Alteryx
- Git
- GitHub
- Pricing Analytics
- Revenue Management Analytics
- Tree Based Models
- Decision Trees
- Random Forest
- Bagging Regressors
- Isolation Forest
- Clustering Algos
- KNN
- DBSCAN
- Time Series Forecasting
- Statistical Modeling
- ARIMA
- SARIMA
- Prophet
Hobbies and Interests
- Watch movies/series
- Reading books
Timeline
Data Scientist
Lemon Tree Hotels
03.2025 - Current
Data Analyst
Lemon Tree Hotels
05.2024 - 03.2025
Business Analyst
dhurin
07.2022 - 04.2024
Masters in Operational Research -
University of Delhi
B.Sc (Hons) - Statistics
Ramjas College, University of Delhi