John Foo Email & Phone Number

Petaling Jaya, Selangor, Malaysia

Smart pricing: Combined price elasticity, competitive landscape, profitability metrics to derive optimal price increase & minimize volume impact. Used to determine price increase for > 200 SKUsDistribution process: Rolled out distribution process based on SKUs & customers across 3 markets. Uncovered >1.5% incremental volume growth potential through distribution of best rate of sale & best volume driversRetailer engagement project: Created tool which automated contractual payout potential, purchase recommendations to retailer including value incremental & percentage of competitors carrying SKUContractual terms analysis: Used retailer vs own profitability & segment profitability analysis used to scrutinize >RM 40mio of contractual trade terms

Shah Alam, Selangor, Malaysia

Leading my team away from adhoc projects to a robust data driven process focused on sustainable, profitable growth. Applying revenue growth management principles on > 600mio of salesPack price architecture: Analyzing competition vs own SKUs to drive price increase / pack change / pack rationalization conversations resulting in > 4mio gross margin improvement.Channel, customer and brand profitability: Driving efficient allocation of trade spend by channels, customer and brands diverting > 2mio spending from less to more profitable areasOptimizing promotions: Driving key account teams to account for past promotions and optimizing future promotions in a "promotion council" using ROI, uplift, trade spend, gross margin and budgeting data as data points worth > 100mio of sales.Trade spend budgeting & management: Created a “bottoms up” budget model to allocate > 100mio worth of spending between channels and customers and re-allocating actual spend – used by finance team to enter general ledgers into SAP to normalize monthly profit and loss statement for the companyData democratization: Using a combination of Excel, Power Query, Power BI, VBA to create a single source of sales / trade spend / gross margin truth consolidating over 30mio rows of data into multiple pivots / tables / charts resulting in over 100hrs/yr savings from sales, marketing & finance teams

Kuala Lumpur, Malaysia

Presenting sales analytics including promotion / campaign evaluation, closure rate, incremental sales and ROIPreparing monthly forecast of trade spend landing using accruals and recovery estimation based off trend analysis Preparing and presenting EBITDA based on impact of product mix on COGS and trade development spend (TDS)Simulating net proceed of sales (NPS) and TDS for presentation to senior leaders worth RM1.9B and RM300M respectively including highlighting risks and opportunities for hitting NPS targets and constraining TDSOrganize and run monthly business meetings with customer managers to show EBITDA including actual and forecasted NPS, TDS, fixed operating expenditure and cost of goods. Drive process improvement: Used combination of new processes and Excel to track over and above (O&A) spending resulting in 600hrs/yr savings; customer P&L project resulting in 290hrs/yr savings; O&A presentation project

Penang, Malaysia

Consolidated financial analysis and presented summary findings to senior leaders for spending of USD$150M Created business plan including financial simulations for internet of things projects of USD$54M NPVCoordinated and co-author “The economic impact of Intel on Malaysia” used for tax incentives USD$50MMonitored business unit expenditures in accordance with budget and company guidelines

Toronto, Canada Area

Project managed and trained the entire software development team leading to a new high speed market data warehousing application which was nine times faster than the previous applicationCommunicated among various functional groups including senior management, the help desk, product team and sales team in the development of IRESS’s core exchange (Toronto Stock Exchange) interface engineInnovatively found an intraday technical solution during a severe market data crisis which affected all vendors on the Toronto Stock Exchange to provide necessary information for customersPerformed requirements analysis of “end of day” infrastructure which resulted in architectural design documentationProvided training and development to technical support staff who provided support to clients such as TD, RBC, CIBC

Project managed a team of software developers which included tasks such as resource estimation and assignmentProvided training and development to select teams of software developers which enabled them to develop software for a protocol changeCreated technical documentation for developers and non-technical documentation for clients to help them understand the impact of a protocol change on their work processProvided technical support to clients such as UBS Warburg, Macquarie, JP Morgan for operational problems

Initiated and organized the first scholar leadership training program for 20 software engineering graduates who would later become supervisors of their own software development teamsSupervised 3 software engineering teams which was pivotal in the creation of a database tool for medical professionalsPrepared and ran weekly open ended workshops for 30 students which explored the software process engineering

Masters Of Business And Administration, Business

Activities and Societies: Rotman Business Design Club Rotman Management Consultant Association Rotman Public Speaking Club 1st place.

Management (Honors) And Software Engineering (Honors), Commerce And Engineering

Activities and Societies: Overseas Christian Fellowship Badminton Club Table Tennis Club Chess Club