Anderson Cheng
Senior Forecasting Analyst · Emser Tile
West Hollywood, CAWork Experience
Senior Forecasting Analyst
Emser Tile2017 – Present
In charge of sales and inventory forecasting processes and implementation of Demand Planning components of MRP and S&OP for a leading marketer and producer of tile and natural stone products. • Developed the new item forecasting process and supporting Excel based tool, which uses benchmarks of products with similar attributes, such as product appearance, price, application, color, and size. Has led to more accurate initial buy quantities and a much better ability to identify and react to potential inventory issues. • Built a new inventory forecasting model that provides greater detail on what is currently on-hand and planned for future production. An updated forecast is presented to upper management weekly. • Developed an Excel based planning tool now being used by all 73 company branches to assess their setting materials purchasing needs. The tool incorporates daily data uploads of reports generated through ReportsNow, and the use of macros to automate how the user views the data.
Self-Employed
Self-Employed2014 – 2017
• Founded Flavorful Foods, Inc. and developed three natural and refrigerated sauces. Ultimately decided not to launch due to concerns with shelf life and capital requirements. • Operated a family owned laundry business until the expiration of the lease on November 2016. • Attended a coding boot camp, Coding Dojo, and built two websites.
Customer Service Capacity Planning Manager, Kindle and Digital
Amazon.com2014 – 2014
Headed forecasting of customer contacts for the Kindle and Digital product categories in the Americas and Asia Pacific markets. • Managed a group of three capacity planning analysts responsible for the Digital product categories and other Kindle marketplaces. • Conducted and led research projects such as assessing contact rates based on age of device, and delay in device activation versus delivery. This included using SQL to pull data from various databases, conducting the analysis in SQL or Excel, creating summary reports, and presenting the results to the management team. • Managed reporting requirements, including weekly metrics reports on forecast accuracy and service levels, in addition to ad-hoc analysis to explain contact variances. • Led forecast process improvement projects, such as the introduction of daily forecasts during the peak period in the 4th quarter.
Demand Planning Manager - Beverage
Nestle USA2010 – 2011
Managed demand planning group responsible for $1.1B in sales. • Managed team of 5 demand planners in charge of forecasting demand for 9 brands in the Ambient Beverage portfolio. Achieved a Lag 1 item/DC forecast accuracy of 81% from a total of 240 skus and 5 DCs. • Led consensus forecast planning process and activities, and provided summary to senior leadership for use in the Sales and Operations Planning meetings. • Developed vision and assigned projects for the demand planning group, including the use of Point-of-Sales data to improve forecasting, the use of price elasticity models to estimate the impact of price increases, and improvements in promotional planning. • Teamed with Supply Planning and Deployment managers to develop performance targets for the division, and worked as a group to achieve our working capital, weeks cover, and service level targets.
Supply Chain Manager
Confections2009 – 2010
Led supply chain team responsible for planning and delivery of $260MM in sales. • Managed team of two demand planners and one deployer responsible for forecasting seasonal chocolate and candy sales, and redeploying inventory to the appropriate distribution centers. Achieved results of 82% forecast accuracy, 99.4% service level, and waste at less than 1% of total sales. • Provided business performance updates to senior management and presented proposed process improvements for their buy-in in the Monthly S&OP meeting and weekly status updates. • Provided direction on production requirements to a team of seven supply planners, and primary deployment strategy to six non-seasonal deployers. • Teamed with Sales, Marketing, and Finance to develop the seasonal confectionary business strategy and targets, including financial budgets, service level goals, customer fulfillment plans, and sku portfolio optimization.
Education
Bachelor of Science
University of California at Berkeley, College of Environmental Engineering1997
Bachelor of Science
Masters of Business Administration
University of Southern California, Marshall School of Business2002
Masters of Business Administration