Dec 2024 – Present · 1 yr 5 mos · California, United States · On-site

• Partner closely with Finance (FP&A), Supply Chain, and Operations leaders to define, standardize, and track enterprise KPIs related to margin, inventory health, service levels, and operational efficiency across multi-site healthcare distribution networks.
• Translate ambiguous business questions into well-defined analytical frameworks, enabling leadership to assess performance drivers, cost leakage, and improvement opportunities at both regional and national levels.
• Designed and maintained analytics-ready data models in Amazon Redshift using dbt, enabling consistent reporting across finance and operations while reducing downstream metric discrepancies.
• Developed and optimized SQL-based analytical views to support daily, weekly, and monthly reporting, improving query performance by up to 40% for high-usage dashboards.
• Built near real-time inventory, fulfillment, and logistics monitoring solutions, allowing operations teams to proactively identify stock risks and delivery bottlenecks, improving on-time delivery by 9%.
• Created demand forecasting and seasonality-adjusted models in Python for high-volume SKUs, improving forecast accuracy and reducing excess inventory while maintaining service levels.
• Performed cost-to-serve and labor productivity analysis by distribution center and fulfillment lane, identifying process inefficiencies that resulted in $3.1M in annualized cost savings.
• Led automation of Power BI dashboards and reports, implementing DAX-based variance logic, drill-down analysis, and row-level security, reducing manual reporting effort by over 50%.
• Established data quality checks and reconciliation rules using dbt tests and Airflow scheduling, significantly reducing reporting defects and increasing trust in executive dashboards.
• Collaborated with IT and security teams to enforce HIPAA and PII compliance, implementing access controls, data masking, and audit logging for sensitive healthcare data.