ALLAN PAUL F. HILARIO
1893 Potrero Street, Lolomboy, Bocaue, Bulacan
--
PROFESSIONAL SUMMARY
Strong knowledge and experience on general accounting, payroll process, billing and recharges, accounts
payable and financial reporting and analysis.
Performs reconciliation of balance sheet account for financial reporting purposes ensuring integrity and
compliance of ledger on global accounting policies and standards.
Cost/Variance analysis related to balance sheet/P&L for financial/management reporting and budgeting
purposes.
Intercompany and joint venture accounting and recoveries
Proficient in using different SAP/ERP System
Advance MS Excel skills (including Marco VBA) and efficient user of other MS Office tools/ applications.
Handle several migration process and support on some GL clean-up project
Championing continuous improvement mindset
Yellow Belt Lean Six Sigma Certified
CSA and peer review tester, to ensure compliance on SOX and accounting policies
SAP ERP Super User
PROFESSIONAL EXPERIENCE:
SHELL BUSINESS OPERATIONS- MANILA
(A member of SHELL Companies in the Philippines and Royal Dutch Shell)
23/F Solaris One Bldg., 130 Dela Rosa St.,
Legaspi Village, Makati City
FINANCE SPECIALIST (RTR PAYROLL ACCOUNTING)
March 24, 2014- Present
Subject Matter Expert for various countries supporting (Australia and EU countries) for various class
of business (upstream, downstream, P&T, Chemicals etc)
Assist the team members being a subject matter expert for any issues for the countries
supporting/team’s 1st line of support for any escalations and issues for the countries supporting.
Performs reconciliations and analysis of various General Ledger accounts for financial reporting
purposes and ensuring ledger integrity and compliance with global accounting policy and guidelines
Perform monthly/quarterly/yearly closing activities such as posting of payroll files, accruals, writeoffs, adjusting entries, and other manual journal entries.
Prepare and monitor recoveries to different customers (Intercompany and Joint venture partners)
ensuring that recoveries are current that will significantly affect companies working capital and cash
flow.
Provide and prepare monthly/quarterly and adhoc reports and commentaries on balance sheet and
P&L to financial controllers, finance managers, budget holders and other parties.
Compliance with the financial SOX controls and accounting policy in doing payroll activities.
Provides supplementary information for statutory and Year-end reporting.
Supports various Continuous Improvement projects and initiatives.
Support and handles several migration and Balance Sheet clean-up projects.
CSA and Peer Review Tester, testing of several controls (Sox and Key non) and other process GL
accounts to validate if compliant with accounting policies and guidelines.
ERP Super User
o Roles and Responsibilities of Super User
Performing training and testing to a high standard to support the system
implementation and retrofit
Proactively resolving end user issues and feeding back resolutions.
Supporting operational change by championing processes and systems to colleagues
(e.g. Embedding the integrated support model and following new processes),
providing coaching where required
First line of support for end users, working local business hours
First point of contact on how to use SAP system for their areas.
Support the facilitation of change activities during process / system changes
including testing and data preparation
Facilitating change requests (web forms) when users require additional/ less roles or
users have joined or left Shell.
Selected Achievements:
Finance Operation EVP (FO EVP) Nominations
o Italy Payroll Balance Sheet clean-up
o Norway Expat Tax Account Process improvement and clean-up
o Support on Malaysian Accounts clean-up project
Special Recognition Award(SRA)- monetized reward calculated based on percentage annual salary
o December 2014 - Italy BS clean Up
o March 2015- Singapore entities handling in lieu and support on MY clean-up project
o May 2016- Successful migration
SDDMAIC Continuous Improvement Initiative
Create Excel Macro Template that eliminates clerical activity of report generation, previously
done in 6-8 hours, down to 30 mins or less
Simplifying payable activities by maximizing excel functionalities and elimination of non-value
adding steps for NL pension payables which reduce working time from 5 days to estimated 2
days or less.
IBM BUSINESS SERVICES
U.P. Ayala Technohub, Quezon City
BALANCE SHEET RECONCILIATION ACCOUNT OWNER
May 2012-March 2014
Reconciliation of Balance Sheet Accounts
o Prepare monthly reconciliation of general ledger accounts (payroll, fixed asset, cash
account, intercompany etc) to validate current period ledger balances for financial reporting
purposes and investigate the variances detected and recommend entries and actions to
close variances.
Accounting Entries
o Accrual Calculations and entries
o Manual journal entries for adjustments, reversals etc.
o Set up, Recoveries, Reconciliation, Corrections, Amortizations, etc
Accounts Receivables and Payables
o Prepare, process and connect with 3rd party customers for outstanding billing and
receivables.
o Process invoices that are due to vendors.
Other Deliverables
o Cost and Variance analysis of BS and P&L accounts for reporting and budgeting purposes
o Attends various work related meetings and interlocks w/ various Service Line contacts and
Clients
o Preparation of RCA
o Provide reports required by internal and external clients and auditors
Selected Achievements:
IBM F&A Tower People of the Month
o Perform beyond what is expected, which draws attention and recommendation from higher
management and client as well.
Balance Sheet Reconciliation Account Owner Promotion
o Within 1 year, promoted from being BSR Associate to BSR Account Owner.
EDUCATION AND TRAININGS ATTENDED
Bachelor of Science in Accountancy
Polytechnic University of the Philippines
Sta. Mesa Manila-
Lean Six Sigma Methodology, May 2014
Yellow Belt Training
Shell Makati
Advance Excel Training, August 2013
Classroom Led Training
IBM- Libis Quezon City
REFERENCE
Available upon Request
