Bodapati Udayasri

Operations Executive

1+ yrs exp 76 · Very Good

About

Results-driven Operations Executive with experience in sales analysis, inventory management, and business reporting within a fast-paced e-commerce environment. Proficient in SQL and Advanced Excel, with expertise in extracting and analyzing large datasets to generate actionable business insights. Skilled in monitoring sell-out performance, conducting root cause analysis, managing inventory through Daily Run Rate (DRR) analysis, and raising purchase orders to ensure optimal stock availability. Adept at developing dashboards, performing year-over-year trend analysis, and leveraging data-driven strategies to improve operational efficiency and business performance.

Skills & Expertise (8)

Advanced Excel Advanced

9.0/10

Years Exp

SQL Advanced

9.0/10

Years Exp

VLOOKUP Advanced

8.5/10

Years Exp

XLOOKUP Advanced

8.0/10

Years Exp

Index-match Advanced

8.0/10

Years Exp

SUMIFS Advanced

8.0/10

Years Exp

Countifs Advanced

8.0/10

Years Exp

Macros Advanced

8.0/10

Years Exp

Work Experience

Operations Executive

Flipkart

Mar 2025 - Present

Proficient in writing complex SQL queries, including advanced JOINs, nested queries (subqueries), data retrieval across multiple tables. Developed and executed SQL queries to extract IMEI-level data, Offer ID-wise sell-out data, order details, and customer reviews and ratings. Performed data cleaning, validation, and transformation to ensure accuracy, consistency, and reliability of datasets using Advanced Excel functions such as VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS and MACROS. Analyzed sell-out performance across multiple product models to identify sales trends and determine the root causes behind increases or decreases in demand. Monitored inventory levels by evaluating Daily Run Rate (DRR) and ensured optimal stock availability across different regions. Conducted year-over-year (YoY) analysis by comparing current and previous year data to identify trends, evaluate business performance, and generate strategic insights.