• Recently joined our vascular and interventional oncology business as a senior analyst responsible for developing commercial analytics solutions to support a $1.1B+ sales organization.

• Transform siloed data/reporting from 8 sales divisions into a cross-divisional reporting platform, managing the end-to-end analytics lifecycle (Taking requirements, blending/mastering necessary data, developing new reports/analytics, presenting insights, and enabling users to self-serve). •Built sales/rebate forecasting reports (using SQL, Python, and Tableau) used daily by 500+ sales reps, analysts, and executives.•Supporting design of price negotiation tool to manage contracting decisions for thousands of products and to categorize new deals based on their strategic features. •Provide internal consulting on analytics and data warehouse strategy for infrastructure that supports 8k U.S. commercial employees.

• Performed ad-hoc data analysis on multi-channel, e-marketing campaigns to provide recommendations for overall e-commerce strategy. • Working primarily with Excel VBA and Power Pivot, pulled data from Google/Facebook Ads and married it to in-house PnL data to model trends in campaign performance. Insights were crucial in maximizing return across 100+ campaigns and in quickly identifying high-growth opportunities.

• Transformed complex data from various sources to provide cross-functional analysis on sales and inventory for CEO, using Java, VBA, SQL, and C.•Developed comprehensive VBA macros/Excel Add-ins for key pivot table reports, enhancing insights on sales, inventory, and profit trends. My recommendations optimized prices/margins, minimized warehouse costs, and guided future product distributions.