Pavan Mahankali

Financial Analyst @Cardinal Health

US

Improved forecast accuracy by 15% by building a dynamic monthly expense forecast model in Excel for 300+ pharmacies, incorporating key cost drivers such as labor, drug procurement, and logistics.• Analyzed SKU-level cost trends using SQL across five regional warehouses, delivering insights that contributed to a 6.8% reduction in procurement cost per unit through a targeted vendor renegotiation.• Automated gross margin reporting across pharmacy categories through Tableau–Snowflake integration, helping finance leadership identify underperforming segments and reallocate $2.1M in annual spend.• Partnered with operations to simulate demand-based staffing models in Excel, identifying excess overtime patterns and contributing to a 9% reduction in labor costs.• Conducted variance analysis between forecasted and actual fulfillment costs, uncovering insights that led to changes in the distribution strategy and resulted in a $320K annual reduction in last-mile delivery expenses.• Developed a SQL-based audit report to track expired and returned drug inventory along with their financial impact, leading to a revised write-off policy that reduced unrecoverable cost exposure by 11%.• Consolidated historical OPEX, logistics, and return data from multiple systems into a centralized Snowflake model, enabling more accurate quarterly board reporting and insightful cost trend analysis.

University of North Texas

Master's degree