Skip to main content
PR
Open to opportunities

Pandurang Rayfalwar

@pandurangrayfalwar

Operations Analyst at Allstate India who developed capacity planning that cut processing time by 12%.

India
Message

At Allstate India, I developed an Excel-based demand and capacity planning model to improve workload allocation. It accounts for employee availability, working hours, process demand, and workload requirements.

I designed data-driven allocation logic to balance work against available capacity and process-level needs while supporting SLA adherence. I also tracked availability, service times, and service-level requirements using VBA Macros.

By automating capacity calculations with XLOOKUP, SUMIFS, and Pivot Tables, I helped identify workload gaps and imbalances. This work contributed to a 12% reduction in processing time and a 10% improvement in efficiency.

I bring experience in operational reporting and performance monitoring, along with data analysis training through the Advanced Certificate Program in Data Science at IIIT Bangalore & upGrad.

Experience

Work history, roles, and key accomplishments

AI
Current

Operations Analyst

Allstate India

Jan 2025 - Present (1 year 10 months)

Developed an Excel-based Demand & Capacity Planning model to optimize workload allocation, leading to a 12% reduction in processing time and 10% improvement in efficiency. Analyzed productivity and capacity metrics to support operational reporting and data-driven decision-making.

Education

Degrees, certifications, and relevant coursework

IIIT Bangalore logoIB

IIIT Bangalore

Advanced Certificate Program, Data Science

2023 - 2024

Advanced Certificate Program in Data Science covering SQL, Python, Exploratory Data Analysis, Machine Learning, Tableau, and Advanced Excel.

upGrad logoUP

upGrad

Advanced Certificate Program, Data Science

2023 - 2024

Advanced Certificate Program in Data Science covering SQL, Python, Exploratory Data Analysis, Machine Learning, Tableau, and Advanced Excel.

Swami Ramanand Teerth Marathwada University logoSU

Swami Ramanand Teerth Marathwada University

Bachelor of Business Administration, Business Administration

2018 - 2021

Bachelor of Business Administration degree from Swami Ramanand Teerth Marathwada University from 2018 to 2021.

Availability

Open to opportunities

Location

India

Authorized to work in

Salary expectations

1005k+ INR

Job categories

Interested in hiring Pandurang ?

You can contact Pandurang and 600K+ other talented remote workers on Himalayas.

Message Pandurang

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan