#dreamjob

Completed analysis for the CEO and VP of Merchandise Planning and Analysis. Consistently met deadlines, and provided thorough, well-reasoned analyses.• Analyzed the cost/benefit of special merchandising programs which resulted in the elimination of unprofit-able programs.• Performed margin analysis on a recently acquired chain.• Researched Pest category online competition.• Measured the impact of different store formats on the cat division.• Analyzed the relationship between fuel prices and store sales.• Created and prepared financial scorecard slides with key performance indicators for Board of Directors and Monthly Operating Review meetings.• Designed and maintained analysis of secondary space effectiveness to measure the incremental sales and margin associated with end cap and promotional space in stores. Led a small group on this monthly project, and completed over 200 analyses in 1.5 years.• Led an efficiency project for an analytic group within the Merchandise Planning Department. Interviewed analysts and reviewed all reports, summarized findings, developed solutions and built new, standardized, and more informative and interactive reporting.• Created a monthly price inflation forecast used to develop the comp sales forecast. The inflation forecast is based on SKU level data and factors in future price testing and price increases.• Coordinated a quarterly food brand margin decomposition analysis for the CEO including scheduling meetings and deadlines, updating templates, incorporating customer and accounting data, and finalizing the PowerPoint file.• Led the Rewards & Recognition committee for the Merchandise Planning department. Revamped the department awards and created the Golden ‘Stache award.• Maintain a daily weather impact report and monthly employee sales report

Managed and prioritized a queue of 30 active store level tests as the principal testing specialist for PETCO, reporting directly to the VP of Merchandise Planning and Analysis.• Consulted with business partners to determine testing design and process, selected test stores and markets, built control models, and set up the reporting. Collaborated with partners in the Pricing, Advertising, Merchandising, Finance, and Operations departments.• Managed high profile test analyses including store price strategy testing, circular and direct mail testing, and rewards program testing.• Analyzed test results, providing conclusions and recommendations, interpreted customer data collected through customer loyalty card, and provided data to business partners that directly impacted decisions on pricing, assortment, planograms, and promotions.• Acted as the primary contact internally for software training, account creation, and troubleshooting, and managed relationship with APT (Applied Predictive Technologies) software representatives

Reported and analyzed sales for Procter & Gamble's Iams and Eukanuba brands ($100+ million business). Worked closely with the P&G team to develop sales driving opportunities at PETCO based on sales trends. Developed reporting for new product launches and assisted with forecasting.• Reviewed and analyzed the overall results and ROI for P&G marketing efforts including advertisements, in-store offers, direct-to-consumer mailings, and FSI’s.• Analyzed loyalty card data for P&G household purchasing behavior; designed and published reports identifying customer loyalty, market basket, and new customer trends and retention.

Maintained web site for IR/PS and used Dreamweaver to create pages, write text, and edit content.• Conducted research and edited press materials for the Public Relations department

Marketed events through website and newsletter; coordinated events by booking event space, managing reservationprocess, and creating profit/loss reports after events; and supported the Board of Directors by preparing meetingagendas and reports. Responsible for bookkeeping and payroll.