Evan Ryan Email & Phone Number

New York, Ny, Us

Marlborough, Ma, Us

● Analyze member behavior to create data-driven corporate merchandising strategies by improving sales and profits through optimizing assortments, space, marketing ROI, and value ● Evaluate business cases, identify risks, and build financial models for strategic initiatives including:o Reducing space dedicated to the Pet category and repurposing the space for innovative categories/itemso Optimizing POG configurations in Active Nutrition to reduce store labor by 50% while growing saleso Performing SKU rationalization to reduce the number of SKUs per category by up to 40% to drive inventory performance while minimizing loss or improving sales and margin● Directly improved EBITDA by +$31.2M to-date (exceeded target of 2% of COGS by 110bps) through assortment optimization, commodity-driven clawback, and data-driven vendor negotiations● Developed and instituted analytic processes as part of the effort to increase Own Brands penetration by +800bps to 30% of total sales● Serve as Project Manager for merchandising division-level projects and category reviews by gathering requirements and gaining alignment with cross-functional team members

Marlborough, Ma, Us

● Build financial models to value profit improvement opportunities during vendor cost negotiations ● Perform competitive benchmarking and evaluate market trends, customer insights, vendor insights, extensive SKU/brand/vendor-level analysis, and assortment analysis through in-market analysis and data analytics ● Perform deep-dive analyses on an ad hoc basis in Excel and Tableau to determine the root cause of sales/margin/promotion performance and develop plans to optimize problem areas

Boston, Massachusetts, Us

• Managed a project to migrate the reporting standard from nine Excel reports to one Tableau workbook• Created reporting dashboards for presentations to executives • Reviewed financial models to identify quantitative and qualitative risks as part of the internal Model Risk Management initiative

Stavanger, Rogaland, No

• Negotiated contracts and drafted responses for crude oil, gas liquid, and crude products pipeline, trucking, rail, cargo, and swap transactions across all trade desks• Per special request, provided numerical analysis and developed presentation materials across business areas using advanced Excel skills (e.g. VBA for Excel, pivot tables)

Stavanger, Rogaland, No

Master Of Business Administration (Mba), Finance And Data Analytics

Bachelor Of Science, Mathematics