PepsiCoBusiness Analysis Manager
Mar. 2008 - Mar. 2011Plano, Texas, United States · On-siteDeveloped scorecards for business teams that enabled improved sales execution, using a variety of disparate data sources to report sales results, ASN, DEX, and other supply chain metrics. Led business teams to understand business solutions for ad-hoc projects and analysis to meet customer requirements for pricing, in-stock, sales overlap reporting, and order cycle time. Designed databases to analyze data and provided advanced metrics for reporting, using spreadsheet models with menu-driven reports that gave valuable and actionable information to sales teams. Managed RSI vendor data for several retailer accounts to ensure data integrity and analytical focus, and assisted sales team with report requests and understanding and use of POS data.
Gained experience with CPG data, including IRI, Retail Link, Star 2.0, Spectra, and point-of-sales data.
Replaced tenured individual and took over a variety of advanced reports, which involved extensive VBA (visual basic) programming with ease and under minimal direction. Developed pricing scorecard to provide visibility to pricing inputs for over 165 bottlers, which resulted in a 75% increase in compliance with retailer promotions requirements. Created a scorecard for category managers to provide sales overlap reporting using data that was incomplete, disparate, and non-standard, which resulted in ability to view annual sales overlaps on three different levels at a glance.