SAP
Vivian Y. Laurente
Accountant
Auckland
Summary
Highly experienced Production Accountant with 34 years of dedicated service at Coca-Cola Europacific Partners NZ Ltd. Current responsibilities include product costing, production usage and price variance analysis, forecasting, month-end tasks, and budget completion within the Commercial supply chain area. Provides essential support to stakeholders throughout the supply chain. Extensive knowledge of systems and processes has made me the go-to person for resolving SAP-related issues and providing training to colleagues. Successfully assisted operations outside of New Zealand in resolving SAP issues. Proficient in various systems used within Coca-Cola Europacific, including SAP, IBM Maximo, Blackline, Tableau, and Promapp systems. Previous experience with Hyperion Enterprise, Oracle, and Business Objects systems.
Overview
40
40
years of professional experience
1
1
Certification
1
1
Language
Work History
Production Accountant
Coca-Cola Europacific Partners New Zealand
Auckland, New Zealand
01.2010 - Current
- Responsible for purchase price variance analysis and forecast
- Collected and reported manufacturing usage variances and assisted the production team in resolving process order issues
- Provided analysis to determine root cause of usage variances in order to put in place corrective measures.
- Played an instrumental role in preparing the yearly budget aligned to the company's overall objective.
- Provided inputs for freight analysis, project recoveries, royalties, and concentrate kit calculations
- Responsible for preparation of project recoveries report and forecast
- Involved with month end processing and reporting including analysis and reconciliation of accounts preparation
- Assists in the inventory stock take as needed and provides monthly support to Café direct stock take and monitors Kronenbourg/S. Damm keg container deposits
- Collaborated with team members and other areas of the business to provide better understanding and trace sources of data in SAP
- Prepared quarterly reports for TCCC profit inventory as well as that of psd caps, psd preforms and resin
- Contributed in the Juice plant setup, Auckland CSD new can line setup
- Involved with the system testing of SAP, IBM Maximo, Tableau, IDA
- Involved with Fixed Asset Register project that facilitated the tracing and labeling of existing assets
- Involved with the preparation and accounting for the capitalization of CAPEX projects including the can line project installed in the Auckland CSD plant
- Managed the customs duty and excise declaration for the alcohol products ensuring compliance with the NZ Customs Department
- Handled all customs audit
- Subject Matter Expert (SME) for Profectus project relating to product costing and customs excise taxes
- Played an instrumental role in providing Projectus project leads have a better understanding of NZ systems and processes involving product costing and alcohol workflow
- Provided the Logistics Team support for month end completion task
- Helped in clearing out purchase order grir items that were still reflected in the balance sheet
- Regularly monitors purchase price variances of major commodity materials such as sugar, aluminium cans, and resin
- Oversees the management of cost roll process and analysis of SKU costs for the different brand partners such as Jim Beam, Monster, Fortune Favour, Estrella Damm, Paradise Beverages, and C&C Int'l.
- Helps the NPD team, Brand partners, S&OP team in the cost roll of materials and finished goods
- Prepares risk and opportunities matrix report for purchase price variances and project recoveries
- Involved with the systems testing and enabled various stakeholders to have a greater understanding of the SAP system
- Collaborated with the IT developers to automate the monthly cost burden journal entries to improve workflow efficiency
- Monitored and tracked freight expenses relating to importation and exportation of materials and finished goods
- Involved in manufacturing efficiencies tracking and monitoring
- Provide insights for major causes of price and usage variances
Financial Analyst
Coca-Cola Amatil New Zealand Ltd
Auckland, New Zealand
01.2005 - 01.2010
- Consolidated month end results for NZ, Fiji, and Papua New Guinea businesses
- Collected and submitted all forecasting results report for NZ, Fiji
- Monthly reports preparation submitted to CCA Australia and key users in CCA NZ
- Prepared daily sales reporting issued to key users in NZ
- Handled the loading and maintenance of actual results, forecasts, and budget data into the Hyperion enterprise
- Involved with the system testing for Oracle, Hyperion Enterprise, Business Objects
- Facilitated smooth month-end close processes by efficiently reconciling accounts and addressing discrepancies promptly.
Inventory Accountant
Coca-Cola Amatil New Zealand Ltd
Auckland, New Zealand
01.2000 - 01.2005
- Heavily involved with the inventory control process
- Conducted regular spot check of inventory & stock take for the eleven warehouses of CCA NZ
- Provided analysis report on various forms of finished goods stock losses
- Participated in the month end and reconciliation process
- Involved with the systems testing of Oracle, Basis
Bank Coordinator
Coca-Cola Amatil New Zealand Ltd
Auckland, New Zealand
01.1995 - 01.2000
- Responsible for the reconciliation of all bank accounts
- Processed all foreign currency transactions
- Report preparation on foreign currency exposures
- Involved with month end and reconciliation process
- Tracked cashflows of the business
Central Credit Controller/Accounts Payable Coordinator
Coca-Cola Amatil New Zealand Ltd
Auckland, New Zealand
01.1990 - 01.1995
- Handled the collection of accounts with the Central North and Lower North island for CCA NZ
- Performed weekly and monthly cheque runs
- Moved to the accounts payable team after 2 years with the main responsibility of processing of transactions to pay suppliers
- Performed payment runs
- Conducted reconciliation of accounts
- Handled customer and supplier issues resolution
Auditor
Garments and Textile Export Board
Metro Manila, Philippines
01.1985 - 01.1990
- Performed audit of various garment manufacturing firms to check on compliance with set government tax rules and garment quota allocation
- Performed audit of bonded stock warehouses
- Checked on internal control process of various garment firms
- Audit report preparation including appropriate recommendations
Education
Bachelor of Science - Commerce – Major in Accounting
University of Santo Tomas
Manila, PhilippinesSkills
- Cost analysis in product development
- Stakeholder relationship management
- Budget finalization
- Data forecasting
- Price Variance Analysis
- Production Usage Analysis
- Cost analysis in product development
Affiliations
- Certified Public Accountant (CPA), Philippines
- Associate Chartered Accountant (ACA), New Zealand
Awards
- 2009, Awarded a roundtrip ticket to the Philippines for consistently providing timely and accurate month end reporting.
- 2017, Awarded the January ambassador award and Finance annual award for developing and supporting a culture of financial control and accountability.
Software
Oracle
Hyperion Enterprise
Business Objects
Tableu
IBM Maximo
Certification
CPA - Certified Public Accountant
Timeline
Production Accountant
Coca-Cola Europacific Partners New Zealand
01.2010 - Current
Financial Analyst
Coca-Cola Amatil New Zealand Ltd
01.2005 - 01.2010
Inventory Accountant
Coca-Cola Amatil New Zealand Ltd
01.2000 - 01.2005
Bank Coordinator
Coca-Cola Amatil New Zealand Ltd
01.1995 - 01.2000
Central Credit Controller/Accounts Payable Coordinator
Coca-Cola Amatil New Zealand Ltd
01.1990 - 01.1995
Auditor
Garments and Textile Export Board
01.1985 - 01.1990
Bachelor of Science - Commerce – Major in Accounting
University of Santo Tomas