A*****n

Key responsibilities: • Perform regression analysis techniques to project out pricing 12-24 months and identify trends and seasonality based on historical retail prices of competitive products in a new market segment across multiple channels such as Mass, Dealer, and Online • Data mining database with 4.2+ million data points to provide regular sales KPI reports of key metrics such as sales revenue, volume, and profitability trends by region to category stakeholders • Analyze NPD and GfK point-of-sale syndicated data across multiple product lines to benchmark competition and identify price, volume, and revenue trends to guide the Product Management team’s decisions to improve pricing and product mix • Develop product road map data content and linkages to improve usability and effectiveness of business case and prioritization templates • Establish multiple fully-linked, consolidated key account sales forecast reports to be used by the Sales and Operations teams • Evaluate features and key performance metrics of leading competitive products to determine potential consumer unmet needs and opportunity spaces for new SVP products in this space • Create easy to understand dashboards and slide shows to present technical findings to non technical leadership team members and stake holders

Key responsibilities: • Helped clients track and analyze key metrics to improve their digital shelf presence across a variety of e-commerce retailers • Overall and per category ROI runs were created periodically in order to help show the growth in these areas • Provided taxonomy/navigation audits, multi-shelf listing tracking, sponsored ad assessment, and ad-hoc analyses for our clients in order to enhance the consumer shopping experience, improve SEO, and ultimately increase conversion rates to drive revenue • Performed secondary data-mining research as needed to augment primary data sources • Modified and enhanced ROI process and tools such as linked Excel and PowerPoint documents in order to improve accuracy, reduce translation errors, and shorten overall project analysis time • Worked with the following global CPG clients: Kellogg's, Mars Wrigley, Mars Pet US, Royal Canin, Edgewell, Emerson, Scott's Miracle Grow, Weetabix, and KIND • Analyzed categories that included Snacks, Confectionary, Pet Food, Hygiene Products, Over the Counter Health Care Products, Lawn & Garden, and Breakfast Foods • Audited client listings on the following retailer websites: Albertsons, Amazon, Amazon Fresh, BJs, Costco, Costco Business, CVS, Giant, Giant Stores, HEB, Hyvee, Instacart Publix, Kroger, Meijer, Sam’s Club, Smart Final, Staples, Stop And Shop, Target, Walgreens, Walmart, Walmart Grocery, ASDA, Amazon UK, Amazon Fresh UK, Iceland, Morrisons, Ocado, Sainsbury's, Tesco, and Waitrose

Key responsibilities: • Managed retail pricing and clearance events for 3 Buyers, totaling 18,000+ SKUs across 72 Product Categories • Analyzed databases with over 1,000,000 datapoints • Optimized price points to maximize gross margin dollars while balancing revenue • Managed sales promotions, end of life, and clearance event activations • Tracked and provided weekly reports of sell through for clearance event SKUs • Created sliding scale ladder scenario plans to illustrate sell through % at various discount rates • Updated system prices for weekly activation • Completed ad-hoc requests, such as taking data from a sales event and analyzing where improvements could be made for next year based on discount rate, sales volume, sales dollar loss, and margin loss • Helped two of my buyers achieve the “Buyer of The Month” award twice for having the highest buyer margin improvement companywide for that month • Produced category reviews with monthly impacts averaging 50 to 100+ bps of gross margin improvement to the category and 5 to 10 bps improvement to the division

Key Services Provided to Clients: • Inter-sheet connectivity by allowing spreadsheets to achieve true automation by developing automatic updates in cells whenever other cells in that file or even from completely separate files are updated • Microsoft Excel & Google Sheets migration by aiding in the migration process of business spreadsheets from Excel to Sheets or vice versa to meet clients’ changing needs • Custom formula creation by helping to create powerful formulas to automate calculations and streamline workflow • Data validation solutions by setting up custom data validation rules, input restrictions, and error messages to ensure accurate data entry as spreadsheets are being populated • Spreadsheet template generation by designing customizable, professional spreadsheet templates optimized for client’s business needs and workflows • Data visualization & Pivot Table design by assisting in creating dynamic pivot tables and charts to analyze and visualize data