John F.

Experience

• 

  Unilever

  May 2000 - Dec 2003

  Assistant Manager-Accounts

  • Accounting for Fixed Assets including capitalization and disposals as well as countrywide consolidation for onward reporting. Conducted HO wide Fixed Asset count with help of external consultants. Worked with Corporate Controller and Supply Chain team to dispose of idle assets as well as to put together CAPEX budgets.• Involved in the preparation of Quarterly/Annual Statutory Financial Reports. Used Business Objects to develop queries and extract reports. Managed country wide General Ledger and reporting timetables. • Started at Sales Branch, responsible for Branch Administration and Distributor Claims audits. Relocated and Promoted to Corporate Controllers Department at the Head Office in Nov’01• Started as Junior Manager -Commercial at Sales Branch, responsible for Branch Administration as well as review of Distributor Claims for various distributor level promotions the company ran to boost sales. Moved to Corporate Controllers Department at the Head Office in Nov’01. Show less

• 

  Schlumberger

  May 2004 - Nov 2017

  • Working with multiyear revenue data from eight plants, reviewed, analyzed and re-sliced data to identify an additional ~$600K savings not previously captured.• Developed a working template to identify ideal Months’ Supply of Hand(MSOH) for Plants, based on historic data analysis of product sale and lead times.• Provided business/functional feedback to SAP Implementation Team as SAP was being rolled out in two pilot plants in the US. Supported SAP Finance implementation team with Data Validation and development of training materials for As-Is vs To-be.• Working closely with Completions Product Group Controller and Plants, established management driven controls on Internal Transfer Price quoting process and prepared detailed analysis identifying reasons for Transfer Price leakage based on Multi Year data from 8 Plants worldwide. Show less • Identified and realized ~$1 m of savings during downturn; monitored progress and developed tracking mechanisms to ensure we remained on track; provided periodic updates to Plant and Product Group Management. • Identified $0.3m of dead inventory of one part and ensured this was properly sold/disposed of.• Identified an unfavorable open-ended contract and ensured we were able to exit from this contract.• Simplified complex, multi-tier royalty computation based on analysis of multi-year revenue and royalty data.• Nominated to act as Product Group Controller (Functional Manager) during a one-month transition period.• Manufacturing center finances – including preparation, review, analysis and reporting of, Monthly Actual Results of Management Financial Reports (P&L, BS, BS Recons & other reports); Capital Projects Review and Approval; Inventory health, obsolescence review, inventory provisions and standard cost reviews and updates; Purchase Price Variances; Work Order Variances and Operating & Facilities Costs review with an aim to manage/control costs. No significant findings from Internal Audit review in January 2015.• Preparation and presentation of Annual Budgets and Quarterly Rolling Forecasts to Group Management and building multiple P&L Simulations models in constantly changing environment.• Collaborated with and guided Finance Shared Services Team members as required. Show less • Instrumental in resolution of HFM Eliminations rules for US consolidated Manufacturing Legal Reporting and development of time savings solutions (saved ~8+hours/Monthly during close cycle)• Provided accounting, consolidation and reporting support for Management and Legal results of 12 Manufacturing Plants in US with a supporting team of three management accountants.• Reviewed Balance Sheet Notes, Fixed Assets (Sub Ledger vs GL), Journal Entries and all schedules prepared by team for presentation to controller and US Legal Reporting Manager.• Management of E&M P&L and Balance Sheet including involvement in budget and forecast preparation process for Engineering and Manufacturing HQ and IT groups. Show less • Worked closely with HFM team and External IT consultants in successful deployment of revised Manufacturing P&L in Hyperion (HFM) to capture more granular Manufacturing results without compromising existing Eliminations rules.• Improved turnaround time by finding alternate HFM data extracting methods. Developed Excel/Hyperion SmartView based models for consolidation of comments. • Responsibilities included consolidation and reporting of EMS Worldwide P&L (~$4+ billion Revenue) and Balance Sheet using Hyperion Financial Management [HFM] within tight deadlines. This role was heavily focused on ensuring, Elimination Rules with HFM were accurate and, on providing comments for swings in Elimination results. • Required preparing timetables, co-ordination, feedback and follow up with around controllers/plant accountants worldwide across multiple time zones.• Prepared consolidated Financial Reports (P&L and Balance Sheet) including commentary, for EMS Global Controller as well as for Schlumberger Global Consolidation team. • Worked with IT team to develop EMS Finance dashboard using oracle based BI tools customized for Schlumberger called OFS (Oilfield Services) Reporter. Show less • Within a month of deployment, in Mar’07, was made responsible for providing functional support for the worldwide Intercompany Transactions system called IST (Internal Service Ticket) – this was developed in LAWSON’s (ERP) based web interface. Prepared and updated online training material used during deployment of the system. Based on feedback from users coordinated with IT Team to implement start up bug fixes and later on, developments and enhancements to the system.• Prior to above assignment was part of team that helped reduced Worldwide Intercompany differences from tens of millions of dollars to less than $10K. Involved in reporting of consolidated intercompany balance, area wide Sub Ledger to General Ledger reconciliations, coordinating the balance confirmation process, master data clean up, testing and implementations of new systems.• Started working with Schlumberger, in May’04, with a successful hand over of Intercompany tasks from UK based team to newly set up team in Dubai. The team was divided by geographic areas, was initially responsible for coordinating with intercompany accountants in Europe and Africa (EAF), and later handled Russia (SLR) followed by Middle East and Asia (MEA) – worked with a wide range of nationalities Show less

  • Project Manager-Support/Analytics(Contract)

    May 2017 - Nov 2017

  • Manufacturing Controller

    Feb 2014 - May 2017

  • Business Analyst /Accounting Supervisor

    Jun 2010 - Jan 2014

  • Consolidation and Reporting Analyst

    Apr 2008 - May 2010

  • Intercompany Co-ordination

    May 2004 - Apr 2008
• 

  Weston Foods

  Jun 2018 - Nov 2019

  Senior Financial Analyst -Business Transformation

  • Developed a comprehensive auditable model to capture impact of pricing actions using a large data set, with capabilities to drill down to SKU level.• Identified areas of opportunity and developed reports and adoption scorecards to monitor and report on progress in Travel , Maintenance & Repair savings projects.

• 

  The Clorox Company

  Nov 2019 - now

  -Developed modeling tool to establish pricing for direct to consumer sales via various eComm platforms using established fulfillment services(eg. Fulfilled by Amazon-FBA)as well as company’s own fulfillment service via 3P logistics partner.-Provided sales team financial analysis and scenario modeling to drive decision making during negotiations with customers.- Developed Power BI based tool to help sales team identify focus area (Categories/Brands/SKUs) for gross margin improvement and net revenue management. Show less

  • Assistant Manager Finance- eComm(US)

    Jan 2022 - now

  • Assistant Manager - Financial Reporting(Canada)

    Nov 2019 - Mar 2022