# Rishitha Karangula

Rishitha Karangula is a remote worker on Himalayas, Supply Chain Analyst at PepsiCo, based in United States.

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

```text
Supply Chain Analyst at PepsiCo who cut forecast MAPE from 22% to 14% with Python and SQL.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 75k+ USD |
| Job categories | Supply Chain Analyst |
| Skills | Demand Forecasting, demand planning, Replenishment Planning, Inventory Optimization, Procurement Analytics, Purchase Order Management, Supplier scorecards, Transportation Management, Freight Cost Analysis, Inventory Control, Inventory Reconciliation, Warehouse Management Systems, Forecasting Accuracy, KPI Dashboards, ABC |

## About

```text
At PepsiCo, I rebuilt the weekly demand forecasting model using Python, SQL, and historical SAP sales data, reducing forecast MAPE from 22% to 14% within two quarters.

I review daily demand exceptions and replenishment needs for a SKU portfolio tied to more than $25M in annual inventory value. I also developed Power BI dashboards that replaced manual weekly reporting with same-day visibility.

At Mphasis, I built Excel procurement trackers that reduced purchase-order status lookup time from a full working day to under an hour. I also analyzed carrier costs and identified a lane consolidation opportunity that reduced annual freight expenditure by approximately 9%.

I led user acceptance testing for a warehouse management system upgrade at Mphasis, coordinating test scenarios and tracking defects in Jira. My projects have also focused on demand forecasting, inventory optimization, and procurement and warehouse analytics.
```

## Experience

### Supply Chain Analyst (current)

[PepsiCo](https://himalayas.app/companies/pepsico). Feb 2026 - Present

```text
Review daily demand exceptions and replenishment requirements for a SKU portfolio tied to more than $25M in annual inventory value. Rebuilt the weekly demand forecasting model using Python, SQL, and historical SAP sales data, reducing forecast MAPE from 22% to 14% within two quarters.
```

Skills: Python, SQL, SAP, Power-BI, DAX, Power-Query, Excel, Demand-Forecasting, Replenishment-Planning, Inventory-Management, ABC, Safety-Stock, OTIF, Fill-Rate, Backorder-Analysis, Data-Validation

### Supply Chain Analyst

Mphasis. Jul 2021 - Dec 2023

```text
Built Excel procurement trackers using XLOOKUP and PivotTables to consolidate open purchase orders, cutting order-status lookup time from a full working day to under one hour. Analyzed transportation costs across regional carriers and identified a lane consolidation opportunity that reduced annual freight expenditure by approximately 9%.
```

Skills: Excel, XLOOKUP, Pivot-Tables, Procurement, Transportation, MRP, Inventory-Reconciliation, User-Acceptance-Testing, Jira, Confluence, Supplier-scorecards

## Education

### Hood College

Master of Science, Computer Science. 2024 - 2025

```text
Pursued a Master of Science in Computer Science at Hood College, Maryland, USA, from January 2024 to December 2025.
```

## Tech stack

- Jira
- Python
- Confluence
- Microsoft Excel
- SQL
- Microsoft Visio
- ServiceNow
- Power BI
- Microsoft Office
- Power Query

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

## People also viewed

- [ARUN SAI RAMADUGU](https://himalayas.app/@arunsairamadugu): Supply Chain Analyst, Penske Logistics
- [Hrishikesh Jadhav](https://himalayas.app/@hrishikeshjadhav): Supply Chain Analyst, Johnson & Johnson
- [Manusha D](https://himalayas.app/@manushad): Supply Chain Analyst, Mindtree
- [Nagabhushan Patil](https://himalayas.app/@nagabhushanpatil): Supply Chain Analyst, ResMed
- [DIVYA SOWJANYA GUDAPATI](https://himalayas.app/@divyasowjanyagudapat): Supply Chain Analyst, Kroger
- [Vishvesh Patel](https://himalayas.app/@vishveshpatel): Supply Chain Analyst, Johnson & Johnson
- [Alabi Emmanuel](https://himalayas.app/@alabiemmanuel1): Supply Chain Analyst & Demand Planner, Guardian Drug Company
- [Mallikarjuna Reddy Bandi](https://himalayas.app/@mallikarjunareddyban): Supply Chain Analyst, Kimberly Clark
- [Karthikeya Chiranjeevi](https://himalayas.app/@karthikeyachiranjeev): Supply Chain Analyst, PepsiCo
- [Vidhiben Patel](https://himalayas.app/@vidhibenpatel): Supply Chain Analyst, PepsiCo
