Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Certification
Timeline
Hi, I’m

Aubrey Z. Bautista

Sto.Tomas
Aubrey Z. Bautista

Summary

Knowledgeable Finance Analyst bringing 11 years of experience identifying and mitigating risks, enhancing business decisions and locating opportunities. Expertise includes financial analysis, reporting, and forecasting. Develops and maintains high standards of quality and issue resolution through effective financial planning. Well-versed in completing complex analysis to develop and improve operational processes aligned with business goals.

Overview

11
years of professional experience
1
Certification

Work History

Coca-Cola Beverages Philippines Inc.

Finance Analyst
10.2015 - 03.2022

Job overview

  • Responsible for Plant's financial record and ensures integrity and accuracy, timeliness and compliance of all accounting records within Accounting Standards and Local Chart of Authority.
  • Responsible for closing of books. This includes preparing of journal entries, account reconciliation, month end closing activities and financial statements analysis.
  • Reviewing and reconciling balance sheet accounts.
  • Contributed to preparation and outlining of annual business plan, rolling estimates and risks and opportunities in coordination with other functions .
  • Prepared financial and statistical analysis and monthly presentation materials and provided analytical support for other departments.
  • Facilitates and coordinates with third party for processing and payment of Taxes to government such as, LBT,RPT and other business statutory requirements.
  • Coordinates with end-user to resolved vendor invoice issues and provides resolution to PTP to meet SLA.

Coca-Cola Beverages Philippines Inc.

Cost and Inventory Analyst
12.2013 - 10.2015

Job overview

  • Ensure correct inventory records for plant through inventory cycle count plan and calendar.
  • Monitoring of asset transfers, optimization of asset utilization and compliance to Standard Policies and Procedures of all inventory transactions.
  • Analyze, review and discuss inventory results, highlight opportunities and agree on corrective action plan for identified problem areas/root cause, and develop processes to further strengthen controls.
  • Actively audits Miscellaneous Transaction Form and Load Manifest versus transaction in SAP system.
  • Ensures recording of asset and inventory related transactions to ensure timeliness, accuracy and completeness
  • Review and reconcile inventory balance sheet.
  • Prepare journal entries for provision and adjustment of asset and inventories based on COA.

Coca-Cola Beverages Philippines Inc.

Finance Clerk
03.2011 - 12.2013

Job overview

  • Responsible for counter checking of load manifest and return sales invoice vs actual load in truck prior check-in and check-out.
  • Publish reports to other Plants/ Distribution Centers to ensures no aging of hanging shipments.
  • Performs scheduled inventory count.

Education

DATA College
City Of San Fernando, Pampanga

Bachelor of Science from Accountancy
03-2011

University Overview

Skills

  • General Ledger Accounting
  • Budgeting
  • Account Reconciliation
  • Communication Skills
  • Leadership Experience
  • Computer Proficiency
  • Problem-Solving Abilities
  • Flexible Team Player

Accomplishments

Accomplishments
  • Best Finance Analyst 2017
  • Certificate of Excellence 2018

Software

SAP

Certification

  • SAP
  • Quickbooks
  • Xero

Timeline

Finance Analyst
Coca-Cola Beverages Philippines Inc.
10.2015 - 03.2022
Cost and Inventory Analyst
Coca-Cola Beverages Philippines Inc.
12.2013 - 10.2015
Finance Clerk
Coca-Cola Beverages Philippines Inc.
03.2011 - 12.2013
DATA College
Bachelor of Science from Accountancy

Similar Profiles

  • Mark Chester D. Malayao

    Mark Chester D. MalayaoMark Chester D. Malayao

    Go To Market -Partner Development Head at Coca Cola Beverages Philippines Inc.Go To Market -Partner Development Head at Coca Cola Beverages Philippines Inc.

    View Profile
  • Jeanne Camille Lansang

    Jeanne Camille LansangJeanne Camille Lansang

    People Operations Partner at Coca-Cola Beverages Philippines, Inc.People Operations Partner at Coca-Cola Beverages Philippines, Inc.

    View Profile
  • IAN DEXTER ESQUILLO

    IAN DEXTER ESQUILLOIAN DEXTER ESQUILLO

    TERRITORY SALES MANAGER at COCA-COLA BEVERAGES PHILIPPINES INCTERRITORY SALES MANAGER at COCA-COLA BEVERAGES PHILIPPINES INC

    View Profile
Aubrey Z. Bautista