Srikar Raju Bhattu

Data Analyst @Cardinal Health

US

Designed real-time dashboards in Power BI, Tableau, and Looker to track drug distribution and clinical supply KPIs, reducing reporting lag from 2 days to under 1 hour and improving executive decision speed by 65%. • Developed Azure Data Factory + Synapse pipelines to integrate ERP, logistics, and pharmacy datasets into Snowflake, cutting ETL runtimes by 35% and enabling near-real-time supply chain visibility. • Automated recurring compliance and regulatory reports (FDA/DEA controlled substances) using Python (Pandas, NumPy)+ Airflow, saving 15 analyst-hours per week while reducing compliance reporting errors by 20%. • Built forecasting pipelines in Databricks (Prophet, ARIMA) to predict drug demand and vaccine utilization, reducing stockouts by 12% and lowering excess inventory costs by $1.2M annually. • Conducted variance and root-cause analysis in Excel (Power Query, Power Pivot, macros), identifying $3M in misallocated spend across 5 business units. • Performed customer segmentation with K-means clustering (scikit-learn) on hospital accounts, increasing contract renewal rates by 8% through targeted retention strategies. • Implemented data governance frameworks (Collibra, Informatica Data Quality), reducing data discrepancies by 25% and ensuring compliance with HIPAA standards. • Delivered predictive analytics for value-based care, helping clinical teams anticipate patient demand patterns and avoid $500K in annual supply costs. • Partnered cross-functionally with finance, supply chain, and clinical ops, translating analytics into process improvements that cut delivery delays by 10%. • Mentored 2 junior analysts in SQL optimization, BI best practices, and GitHub version control, improving team delivery capacity by 20%.

BV Raju Institute of Technology (BVRIT)

Bachelor of Technology - BTech

University of Colorado Denver

Master's degree