Alekhya Buddhavarapu

• 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.