Kearney
Client — CARE Pharmacies
Industry Practicum — Strategy & Analytics Consultant
Sizing and standardizing the economics of a 93-pharmacy member network so leadership can prioritize a product roadmap against real numbers rather than anecdotes.
Quantified $33.9M in total annual member value (on-invoice + off-invoice) across 93 member pharmacies by synthesizing fragmented wholesaler sales data from 4 quarterly datasets, translating findings into executive-ready reports for Kearney and CARE Pharmacies leadership to support product strategy and roadmap prioritization.
Designed a rule-based financial savings framework standardizing WAC, COGS, and aggregation logic across 3 agreement types and 2 account categories, enabling consistent savings calculation across $870M in annual purchasing spend.
Built data visualizations and user-facing insights identifying a ~$8.8M off-invoice opportunity for group stores, surfacing a structural gap where independent members receive 50% of value through rebates versus only 12% for group members.
Delivered on-invoice savings analysis revealing a consistent ~3% savings rate across both member segments despite a 3.4× volume difference, demonstrating that the $15M savings gap is driven by purchase volume, not pricing advantage.