Experience

• 

  Capcom

  • Dallas

  • Retail Data Analyst

    • Aug 2006 - Jan 2014
    • Dallas

    Responsible for utilization of retailer web-based vendor management systems to support fact-based selling and ensure Capcom meets vendor performance requirements. Supported sales presentations, planning, and forecasting by developing analytical reports based on statistical point-of-sale and inventory data. Monitored sales and analyzes performance trends to identify issues and opportunities. Completed transactions in vendor management and order entry systems. Site Administrator for multiple retailer web-based sites and trained other Capcom personnel as required.Essential Functions & Responsibilities:Obtain and utilize POS and Inventory information to: • Analyze and report sell-through performance by platform, category, and item (Weekly)• Prepare trend analysis and historical data to drive forecast reports (W)• Complete periodic modular updates (as needed)• Create ad hoc measures and reports as required/requested (W)Sales and Sales Administration support:• Prepare reports for business reviews (W)• Assist in development of fact-based sales materials (Quarterly)• Participate in sales calls and Vendor meetings (as needed)• Prepare summary reports from merchandizing service providers (i.e. Mosaic) (Monthly)• Create ad hoc measures and reports as required/requested (W)• Act as administrator on all retailer based websites (as needed)• Load non EDI account sales and inventory data in SAP (W) Complete required transactions including: • Co-op, price protection, and roll-back processing (Q)• Writing SSO - store specific orders (as needed)• Item set ups and maintenance (Q)• Order processing/correcting if required (as needed)Vendor Performance Monitoring:• Establish and maintain vendor performance/scorecard database (W)• Identify and promptly report performance issues (W)

• 

  THQ

  • Dallas

  • Retail Sales Analyst

    • Apr 2003 - Mar 2005
    • Dallas

    Analyzed the Wal*Mart US and Canadian business and Sam’s Clubs US utilizing Wal*Mart’s Retail Link system and made recommendations to ensure Wal*Mart goals were met with respect to in-stocks, margins, turns and weeks on hand. Wrote all orders (initial and replenishment) for Wal*Mart Canada and orders as needed for the US, based on historical data and/or current rate of sale. Utilized CPFR to suggest forecast modifications on assembly replenishment items. Produced daily and weekly reports for all aspects of the business, as well as ad hoc reports for special projects as needed. Provided internal weekly fiscal year POS forecasts for all titles utilizing current and historical selling trends. Prepared account presentations in PowerPoint outlining past performances, new products and strategic goals and objectives. * Wal*Mart Canadian became a direct account in fiscal year 2004 which resulted in a 51% increase over prior year in dollars at the register and a 17% increased over the Wal*Mart given goal – Margin improved 23%* Fiscal year 2004 retail turns increased 10% for US Video Games* Fiscal year 2003 THQ achieved a 37% increase over prior year in dollars at the register while maintaining an in stock level of 97% in US Video Games at Wal*Mart

• 

  Electronic Arts (EA)

  • Dallas

  • Retail Sales Analyst

    • Sep 1999 - Apr 2003
    • Dallas

    Provided extensive analysis of the Wal*Mart and Sam’s business utilizing the Wal*Mart Retail Link system. Wrote initial orders and replenishment orders for video games based on historical data and / or current rate of sale. Maintained inventory levels for titles to support current rate of sale for hits driven business. Selected stores to receive product based on sell through data and other pertinent information. Produced daily and weekly reports for both aspects of the business. Produced and analyzed ad hoc reports for special projects as needed. Helped provide internal forecasts for individual titles by applying current selling trends to similar titles / products. Utilized CPFR to suggest weekly forecast on assembly replenishment items. Retail Link Site Administrator, providing training and support for all Retail Link users. * For Wal*Mart’s fiscal year 2002 helped achieve a 54% increase over prior year in dollars at the register (video games) and a 21% increase over original goal - placed 2.26M units * EA was awarded Wal*Mart Supplier of the Year 2001 for Dept. 5 – video games achieved a 39% increase over prior year in dollars at the register and 10% increase over goal while decreasing weeks on hand by 39% - wrote 304 orders placing 2.87M units * Placed 3M units during calendar year 2000, maintaining prior year’s numbers during a very difficult transition year* Wrote store specific orders totaling over 809k units during the Sept. - Dec. 1999 time period

• 

  The Brinkmann Corporation

  • Dallas

  • Sales Analyst

    • Sep 1997 - Sep 1999
    • Dallas

• 

  Nike

  • Dallas & Minneapolis, MN

  • Business Analyst

    • Jul 1990 - Jun 1997
    • Dallas & Minneapolis, MN