Igloo Products Corp. Houston, TX
Senior Forecasting Analyst Aug 2007 - Present
• Evaluate statistically generated forecasts and determine the adjustments necessary, based on business conditions, promotions, manufacturing capacity, etc. to improve overall forecast accuracy. As a result forecast accuracy improved by 9% which led to an overall reduction of safety stock carried on “A” sku’s by $400k.
• Develop sensitivity analysis models and trend analysis reports - totaling $280 million in revenue – for senior management review.
• Analyze customer specific sales trends and lead cross-functional consensus meetings with regional sales VPs for both the monthly forecast meetings as well the weekly S&OP meetings.
• Manage and lead the annual budgeting process for over 400 sku’s across 10 regions worldwide.
International sourcing specialist
• Worked with vendors in China to facilitate their production process of goods to be received by Igloo Products. This effort improved on time deliveries from China from 65% to 95% over an eight month period.
• Developed supplier score cards to identify and determine the most effective suppliers for existing products.
• Conducted evaluation and selection of new suppliers for new outdoor programs and generated the gross margin analysis.
ABN AMRO Amsterdam, Netherlands
Business Development - Intern Summer 2006
• Identified underlying problems and improved internal operations risk management through numerous internal interviews with VPs and an awareness of the ABN AMRO financial products and structures.
• Streamlined and redesigned internal deviation processes of all global business units - reducing process timing by 75%.
• Contributed significantly to cost analysis by building financial models to calculate overhead cost.
Wal-Mart (China) Investment Co., Ltd Shenzhen, P.R.China
Business Strategic Planning Supervisor 2002 - 2005
• Analyzed working processes, labor costs, and overhead costs - realizing cost saving of $3 million.
• Created models using Forecast X (advanced Supply Chain forecast software) to analyze and project revenue growth of $200 million per year.
• Created project valuation based on DCF model and performed sensitivity and IRR analysis based on different sales forecast variations.
• Conducted Operating capital plans and reconciled CAPEX totaling $2 million for Wal-Mart Logistics.
• Implemented financial controls and reporting in compliance with Wal-Mart International team and explained actual variances with budgets according to the P&L analysis.
Certification / Skills
• Chartered Financial Analyst (CFA) Level I Candidate
• Completed Bloomberg Training for Equity, Fixed Income and Foreign Exchange
• Certified Six Sigma Green Belt
• Mandarin Chinese (Fluent), Cantonese (Fluent), Japanese (Beginner), Spanish (Beginner)
• Advanced level of Microsoft Excel (Macros, Pivot tables, Forecast X, Solver, @risk, etc.) and other Microsoft Office Applications