Calvin Sia

**** ******* ***** ***, *********, CA 94551

925-***-****

ac7t7j@r.postjobfree.com

linkedin.com/in/siacalvin

EXPERIENCE

****-******* ******* ***** *** Ramon, CA

Manager, Demand Planning

Engaged in monthly cross functional IBP meetings to execute sales of $50M across 30+ SKUs with key stakeholders

Managed our demand forecast short term and long term by category channel & SKU to report out financial projections to VP of Finance

Monitored weekly sales performance to track against forecast projections on all items including new product launches

Successfully launched new oversized sandwich in the market increasing gross sales by $4M

Led and mentored 1direct report in demand planning & sales analysis to improve forecast bias

Improved production planning SKU mix by updating and reviewing customer ordering patterns

Support the development of trade spending (Promo, Demo, Slotting) with Marketing & Sales to align with sales growth and forecast

Analyze actual trade expense by working with Sales & Accounting and forecast full year projections

Built freight scorecards to review & improved on-time delivery schedules with customers to avoid late penalties fees

Reviewed inventory levels by SKU to mitigate risk and reduce days of inventory by 20%

Identified excess aged inventory and developed a sales plan jointly with Sales management to reduce total inventory costs by 5%

Improved fill rate levels to 99%+ to meet customer orders

Continuously enhanced and simplified our business report needs through automations to improve time efficiencies

2015-2016 McKesson Corporation San Francisco, CA

Manager, Supply Chain Strategic Program

Strategically managed inventory to key pharmaceutical chain stores that drove $300 million revenue down our supply chain through 30 distribution center channels

Collaborated with IT to build systems and tools to protect inventory to our key dedicated customers using a virtual warehouse and block other customers that purchase from our competitors when faced with a supply disruption

Increased service level rates to key customers using sequestration methods to secure product to drive up profit margins

Built out inventory stock levels on new generic launches to drive incremental sales and profitability by being first in the market

Attended customer calls to identify customers product needs through the additions & removals of pharmaceutical drugs in their portfolio

2014-2015 Senior Accounting Analyst

Effectively interpret customer contract agreements to execute $120 million annual customer rebate payouts

Review, interpret, and analyze $150 million of Generic sales through customer inquiries to resolve key issues to drive higher level customer satisfaction supporting sales contract renewal process

Prepare & post journal entries on rebate accruals for month end close as well as review & validate automated rebate reports for compliance measures on over 1,500 individual accounts

Performed SOX audit controls by identifying risk and internal control deficiencies and coordinate cross-divisional efforts to ensure appropriate execution for McKesson

Acted as the liaison between sales teams and IT to build customer rebate reports for Generic programs to execute a flawless payout of rebates

2011-2014 Nestle Oakland, CA

Demand Planner

Determined key economic financial drivers to adjust demand forecast that drove sales of $800M annually across 5 branded product lines

Managed partnerships with Northern America’s Sales, Pricing and Operations to determine key inputs driving key forecast changes including seasonality and historical sales trends

Improved product inventory in the supply chain at multiple distribution center locations by adjusting the demand forecast to optimize supply and prevent overstock or out of stock items

Contributed to process improvements on overall forecast bias with a 2% by attending customer calls to determine timing of grocery promotional events at numerous geographical locations

Mentored internship programs and rotational programs to guide new hires to successful path with the company

2011-2011 McKesson Corporation San Francisco, CA

Accounting Analyst (Contractor)

Customized Tech Rebate models per individual customer with a gross payout of $8.4million annually on technology equipment and software

Maintained customer MS Access Database for sales reps by generating queries using SQL to track historical rebate details to identify new customer opportunities to drive top-line growth

2008-2010 The Clorox Company Oakland, CA

Vendor Analyst

Booked accruals for raw materials and freight that contributed to a net sales of $5.5 billion as well as create KPI metrics for over 10 different brands

Led a team of 5 to research and analyze a $17 million freight accrual project to clean up the balance sheet

2007-2008 Columbus Foods Hayward, CA

Accounts Receivable

Reduced accounts receivable aging through developing relationships with customers by answering customer inquiries and maximizing discount incentives

2006-2007 Mervyns Hayward, CA

Data Entry

Managed sales records and transactions for over 170 retail stores to provide analysis on growth and profitability of the company

EDUCATION University of California Davis Davis, CA

Bachelor of Arts, June 2006

Major: Economics; Minor: Managerial Economics

ADDITIONAL Computer: SAP R3 & CRM, SAP BW, MS SharePoint, MS Excel, MS Access, SQL, Hyperion Essbase, KW/Hyperion,

INFO BPC, SAS PEM, TMS, AS400

Hobbies: Traveling, cars and dining

Contact this candidate