Sheldon Yao

Experience

• 

  Provident computer Consultants Inc.

  May 1998 - Sept 2001

  Computer Programmer/Analyst

  • Provided production and on-line support• Participated in quality assurance testing• Prepared weekly compare report for the IDMS/DB2 Database Compare• Developed/revised and tested programs using COBOL, CICS, DB2, IDMS, JCL, ADS and VSAM• Created AD Hoc reports requested by various users

• 

  Kraft Canada Inc.

  Feb 2002 - Nov 2005

  • Managed customer orders from order development, pricing, delivery, invoicing and payment using Customer Order Management (COM), and Warehouse & Transportation Management System (WTMS).• Dependent on designated ordering process as agreed to between Kraft and customer, and creating/processing orders as required• Responsible for all invoices and deductions on account base assigned. Ensuring invoices are paid on time, deductions are coded and either resolved or forwarded to the responsible party for resolution • Maintained deduction management within timeline required• Interacts with Customer Business team members, providing lead knowledge as it relates to order management, delivery requirements, accounts receivable and deduction management• Supported CBT for new product initiatives and provides lead on tasks related to job responsibilities• Supported and provided leadership as required on logistics initiatives in conjunction with Customer Supply Chain Manager• Achievement and Recognition • 2005 Map-rating: Spectacular Show less • Responsible for cash/cheque application. This included application of payment to customer AR, provided supporting documentation to CSCS and support them in account reconciliation• Prepared various reports such as weekly and monthly sight draft reconciliation for management used• Responsible for all invoices mailing.• Responsible for entering reclamations and sight draft into customer order management (COM)• Interacted with CSCS and sales, and provided lead knowledge as it relates to sight drafts and reclamations. Show less

  • Customer Supply Chain Specialist – Food Service Division

    Nov 2004 - Nov 2005

  • Financial Transaction Coordinator

    Feb 2002 - Nov 2004
• 

  Kraft Canada

  Nov 2005 - Jun 2011

  - Managed all activities and functions relating to optimizing assortment and shelf management with retail customers.- Supported Category Advisors in managing 8 categories for Wal-mart. Categories include Spreads, Desserts (Dry and Ready to Eat), Cheese, Cookies & Crackers, Enhancers, and Condiments.- Supported Sales group in creating various reports that will be use on their day to day business. This includes Gross Profit Report, Monthly Allowance Reporting, Warehouse and Store Level Inventory Report, and Category Management Report for IRI.- Acted as the Category Advisor for Shopper's Drugmart Fields, and Zellers for various categories. This includes Spreads, Desserts (Dry and Ready to Eat), Cheese, Cookies & Crackers, Condiments, NPF, Confection (Front of Store).- Actively participated in various internal projects.- Advance knowledge in ProSpace/JDA.- Advance knowledge in using Microsoft Office- Proficient in using Costco IRI data.- Advance knowledge in Retail Link and CPFR. - In-depth knowledge in Market Data (Nielsen's, SPECTRA, Answers, XOF etc.) Show less • Responsible for collaborating with all levels of Kraft Product Supply, Kraft Sales and Wal-Mart replenishment in the planning and forecasting of Wal-Mart’s store and DC level inventory needs to ensure proper replenishment. • Responsible for analyzing store in-stock levels to determine actions needed to achieve and maintain store in-stock goals as well as recommend actions to ensure in-stocks are maintained during promotional events. • Responsible for organizing and conducting collaboration meetings.• Monitored promotional activities and did necessary recommendation to avoid out of stock and over stock situation.• Created various reports that will monitor warehouse and on hand inventory, Instock situation, case fill rate report, store count analysis, and Ad Trackers.• Awarded Vendor of the Year and Grocery of the Year by Wal-mart Canada 2006• Awarded Customer Business Team of the Year 2006 and 2007 Show less

  • Space Management Specialist (Planogram Specialist)

    May 2008 - Jun 2011

  • CPFR Analyst - Wal-mart Canada

    Nov 2005 - May 2008
• 

  Mondelēz International

  Jun 2011 - now

  - Advise various C&G customers on confectionery category by providing meaningful insights in regards to category/market performance, market trend, shopping behavior, and promotional analysis by leveraging Nielsen and/or Customer consumption data. - Responsible for building and maintaining customer's planograms based on category and market insight.- Worked with the following C&G Customers: Couche Tard, Circle K, CST (Ultramar), 7-eleven, Gateway, Pioneer Gas, Petro, Mac's Ontario, London Drugs, Rexall/Katz, and Coleman/Focenco.- Proficient in AC Nielsen, 7-eleven IRI, Petro Toolbox, and Wal-mart Retail Link Show less - Conducts in-depth analysis of category productivity (both customer and market specific) and effectiveness, including space allocation versus volume, shelf inventory, product assortment, promotional analysis, modular effectiveness, new product development, and cost-margin analysis.- Collects and analyses customer sales and financial data to support assortment and shelf-management recommendations- Leverages SPECTRA reports and shares findings and implications with all business partners (internal & external).- Builds business recommendations using basic category management tools e.g. Nielsen, customer data (Retail Link), and JDA.- Created various adhoc reports and templates which includes some of the following: - Monthly Billables - Weekly Consumption Report - Margin Analysis Report - Monthly Promotional Analysis Show less

  • Account Planning Manager - Walmart

    Sept 2017 - now

  • Category Advisor - C&G Channels

    Mar 2014 - Sept 2017

  • Category Advisor - Wal-mart's Front of Store (D82)

    Jun 2011 - Mar 2014