Summary
Overview
Work History
Education
Skills
Leadership And Activities
Communication And Soft Skills
Timeline
Generic

Alekhya Buddhavarapu

Kakinada

Summary

Results-driven Business Analyst with Amazon Development Center India, skilled in data analysis and KPI creation. Successfully developed interactive dashboards that enhanced operational insights and improved decision-making. Expert in SQL and stakeholder communication, I excel at translating complex data into actionable strategies, driving process improvements and optimizing performance metrics.

Overview

2
2
years of professional experience

Work History

Business Analyst / Transportation Specialist

Amazon Development Center India
09.2023 - Current
  • Analyzed transportation and operations datasets to identify inefficiencies, delay patterns, and opportunities for process optimization.
  • Designed and built Amazon Quicksight dashboards to automate metric visibility, improve decision-making, and provide leadership with real-time operational insights.
  • Collaborated with program managers, yard managers, and carrier partners to resolve bottlenecks, improve SLAs, and enhance customer experience.
  • Extracted, cleaned, and transformed large datasets using SQL and Excel to support weekly/monthly reviews.
  • Developed KPIs such as on-time departures, trailer dwell time, and transit delay trends to monitor performance.
  • Conducted root cause analysis for transportation defects and presented findings to stakeholders with actionable recommendations.
  • Translated business problems into detailed analytical requirements, enabling scalable and accurate reporting solutions.

Business Analyst Projects

  • AWD Hardcoded Sites Replacement: Replaced AWD hardcoded sites with a new scalable source table. Improved data accuracy for multiple downstream datasets by ensuring correct and dynamic site mapping.
  • Inbound Defects & Rejected Trailers Dashboard (Quicksight): Developed a dashboard for FC leaders to monitor inbound defect trailers and rejected trailers. Enabled faster insights and improved operational defect management.
  • IBPS Dashboard Data Quality Fixes: Resolved critical data quality SIMs on the IBPS dashboard, which receives 100k+ monthly views. Identified logic issues causing inconsistencies and updated calculations to restore data accuracy.
  • WIMS Launch Dashboard: Built an end-to-end dashboard within 2 weeks for the WIMS pilot launch. Provided visibility into Avg AHT, SLA performance, associate-level metrics, and WoW trends.
  • Rail Yard Churn & Cost Reduction Dashboard: Created a dashboard that identified incorrect carrier scheduling by comparing planned vs actual transit times. Helped eliminate unnecessary churn and additional costs at rail yards by highlighting scheduling gaps.
  • Supervisor Mapping & Data Integrity Corrections: Enhanced an existing dashboard by fixing associate-to-supervisor mapping issues. Ensured accurate metric distribution and reporting after resolving logic and data alignment problems.

Education

B.Tech - Civil Engineering

V.R. Siddhartha Engineering College
Vijayawada
05-2023

Skills

  • Requirement gathering & stakeholder communication
  • Data analysis & KPI creation
  • Process improvement & RCA (Root Cause Analysis)
  • Dashboard development (Quicksight)
  • Workflow documentation & reporting
  • SQL (Joins, CTEs, Subqueries, Window Functions)
  • Python (basics)
  • Java (basics)
  • Microsoft Excel (Pivot tables, Lookups, Dashboards)
  • Amazon Quicksight – interactive dashboards, calculated fields, parameters, visuals

Leadership And Activities

  • Student Body President, American Society of Civil Engineers (ASCE), 2022–23
  • Social Media Coordinator, Institute Innovation Council (IIC), 2021–23
  • Main Organizer, State-level Techno-Cultural Symposium (Civicture’22)

Communication And Soft Skills

  • Strong leadership, teamwork, and decision-making skills
  • Effective communication with technical and non-technical teams
  • Ability to handle multiple projects simultaneously
  • Fast learner, adaptable, and committed to continuous improvement

Timeline

Business Analyst / Transportation Specialist

Amazon Development Center India
09.2023 - Current

B.Tech - Civil Engineering

V.R. Siddhartha Engineering College
Alekhya Buddhavarapu