# Pandurang Rayfalwar

Pandurang Rayfalwar is a remote worker on Himalayas, Operations Analyst at Allstate India, based in India.

Source: https://himalayas.app/@pandurangrayfalwar

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

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 1005k+ INR |
| Job categories | Data Analyst |
| Skills | demand planning, Capacity Planning, Work Allocation, Operational Reporting, KPI Reporting, MIS Reporting, Performance Analysis, Data Analysis, Data Cleaning, Data Visualization, Exploratory Data Analysis, Trend Analysis, Excel, Pivot Tables, XLOOKUP |

## About

```text
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

### Operations Analyst (current)

Allstate India. Jan 2025 - Present

```text
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.
```

Skills: Excel, VBA-Macros, XLOOKUP, Sumifs, Pivot-Tables, Data-Analysis, Capacity-Planning, Work-Allocation, SLA-Adherence, Operational-Reporting

## Education

### IIIT Bangalore

Advanced Certificate Program, Data Science. 2023 - 2024

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

### upGrad

Advanced Certificate Program, Data Science. 2023 - 2024

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

### Swami Ramanand Teerth Marathwada University

Bachelor of Business Administration, Business Administration. 2018 - 2021

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

## Tech stack

- Tableau
- NumPy
- Pandas
- MySQL
- Python
- scikit-learn
- Google Sheets
- SQL
- Seaborn
- Matplotlib
- Power BI

To contact Pandurang, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [PRAKASH SINGH](https://himalayas.app/@prakashsingh1): Operations Analyst – Team Lead, Flipkart
- [Devesh Dhyani](https://himalayas.app/@deveshdhyani): Data Operation Analytics, Neuter India Pvt Ltd
- [Samiul Hoda](https://himalayas.app/@samiulhoda): Data Analytics, Hands on Projects
- [Jayant Wadhwa](https://himalayas.app/@jayantwadhwa): H&W Benefits Administrator (Workforce Management), Milliman India
- [Prasad walke](https://himalayas.app/@prasadwalke): Machine Supervisor, AtomX
- [Shivayya Mathapati](https://himalayas.app/@shivayyamathapati): Data Analyst, Myntra Designs Pvt Ltd
- [Maroof Hasan](https://himalayas.app/@maroofhasan): Consultant, Genpact
- [Vaishnavi Pandey](https://himalayas.app/@vaishnavipandey1): Senior Analyst, Aon
- [Aksa Mathew](https://himalayas.app/@aksamathew): Senior Representative – Operations, Concentrix
- [Raj Pachauri](https://himalayas.app/@rajpachauri): Lead Analyst, Advanced Analytics, Airbnb
