AG

Andrew Gerton

Operations Manager · Sam's Club Ecommerce

Cincinnati, OH

In My Own Words

Experienced Analyst with a demonstrated history of working in the retail industry. Skilled in Cross-team Collaboration, Microsoft Excel, and Microsoft PowerPoint. Strong operations professional with a Bachelor's degree focused in Economics, Management, and International Studies from University of North Texas.

Work Experience

Shipping Analyst

Sam's Club Ecommerce

2018 – Present

Manage all shipping related expenses (+$134M annually, representing the single largest P&L expense) using data-driven analysis to drive business insights. Serve as a key strategic business partner supporting merchandise operations to over 14 Sam's Club ecommerce merchant teams. Create and modify SQL queries designed to monitor shipping revenue and expense across all levels of Sam's Club ecommerce business. Investigate and resolve shipping errors in product configuration to avoid vendor penalties and ensure a positive member experience. • Cross-functional coordination with Merchandise, Planning, Replenishment and Supply Chain teams to create and implement optimal shipping solutions • Create, maintain and analyze reporting to track and monitor key metrics, including sales trends, membership growth, shipping expense, profit, NPS, and reseller activity • Perform regular audits of product setup in Oracle ATG Web Commerce, and conduct training for all Merchandise Associates • Create and lead shipping training for Sam's Club ecommerce merchant teams incorporating best practices and policy guidelines to reduce shipping costs and enhance member experience • Event Captain for shipping related matters for FY19 sales events (i.e. Black Friday, Holiday, Cyber Monday, etc.) • Develop weekly NPS reporting of what members are experiencing to support and drive business decisions • Create ad-hoc reports for merchandise teams (i.e. Sales YTD, MTD, Events, Top-Sellers, etc.)

Controlled Substance Analyst

Walmart Stores

2017 – 2018

Leveraged pharmacy expertise to conduct an impartial analysis of controlled substances ordering practices for Walmart stores across the US. Collected and consolidated pharmacy dispensing and shipment data from multiple sources, prepared and analyzed reports for leadership review, maintained accountability to both internal Health & Wellness management and government agencies. • Partnered with internal and external stakeholders to ensure program compliance with federal laws regarding controlled substances • Prepared collateral for Senior Leadership Council to analyze prescribing habits of over 1,500 medical professionals • Identified emerging controlled substance compliance risks, including analysis of industry data • Supported Health and Wellness compliance reporting and initiatives related to controlled substances

Lead Pharmacy Technician

CVS Pharmacy

2010 – 2017

Collaborated with pharmacists to ensure customers received quality care; ensured all health and safety standards and protocols were met; maintained both company and patient confidentiality in accordance with HIPAA, state and federal guidelines.

Education

Bachelor of Science

University of North Texas

2013 – 2017

Bachelor of Science