Summary
Overview
Work History
Education
Skills
Certification
Interests
Timeline
Generic
Clarence Rei De Belen Reyes

Clarence Rei De Belen Reyes

BI Solutions - Team Lead
General Mariano Alvarez

Summary

More than twenty years of extensive hands-on experience in the field of Accounting. Four years of handling and developing WebFOCUS, SAP scripting, VBA BI projects, and data stewardship. Assertive, hard-working, dedicated and goal oriented person. A team player and can work well independently.

Overview

21
21
years of professional experience
20
20
Certifications

Work History

Team Lead / BI Solutions team

Henkel Asia Pacific Service Center
10.2023 - Current
  • Lead and manage a team to achieve goals and objectives.
  • Set clear expectations, goals, and priorities for the team.
  • Provide guidance, coaching, and mentorship to team members.
  • Foster a positive and productive team culture.
  • Communicate effectively with team members, stakeholders, and other departments.
  • Facilitate collaboration and knowledge-sharing within the team and business partners.
  • Build and maintain relationships with stakeholders and other teams.
  • Monitor and evaluate team performance.
  • Provide regular feedback, coaching, and performance evaluations.
  • Identify areas for improvement and develop plans to address them.
  • Problem-Solving and Decision-Making
  • Identify and resolve problems or conflicts within the team.
  • Make informed decisions that align with goals and objectives.
  • Escalate complex issues to higher management when necessary.
  • Identify training and development needs for team members.
  • Provide opportunities for growth and skill development.
  • Mentor and coach team members to improve their performance and capabilities.
  • BUSINESS CONTROLLING – HAT

Senior Analyst / BI Solutions team

Henkel Asia Pacific Service Center
07.2017 - 10.2023
  • PBI support especially for A-FACTS landing page
  • Point person for Henkel Adhesives business community on all related concerns for the entire solutions and systems.
  • Daily generation and analysis of data for COPA and COLOR (APAC) for system health checks.
  • Overseeing/provision of access/authorizations for users of COLOR, WebFOCUS, FINCA 2.0, CAPRIS, SCOUT BI systems
  • Supports Monthly Business Controlling activities
  • Involves ADHOC projects from time to time
  • BUSINESS CONTROLLING – HAT

Analyst/Developer (WebFOCUS)

Henkel Asia Pacific Service Center
12.2014 - 07.2017
  • Assess potential projects and provides information to stakeholders if the development is possible in WebFOCUS BI tool.
  • Once potential projects assessed, develop system structure and mapping together with estimate time of completion for execution of project development.
  • Development (coding) of procedures in WebFOCUS test environment.
  • Creates composer file for integration of multiple reports.
  • Fix issues and errors which found during the testing or validation.
  • Once all testing and confirmation that the project is correct, request transport of files from WebFOCUS test server to production for deployment.
  • Accepts adhoc projects from colleagues who wants to automate processes using visual basic editor (Excel Macros).
  • BUSINESS REPORTING – ADHESIVE BUSINESS

Business Analyst (Business Controlling)

Henkel Asia Pacific Service Center
07.2013 - 12.2014
  • Involves in the WebFOCUS Project to be use for generation of Business Review Templates which supersedes Management Dashboard and Standard Controlling Reports.
  • Assists the Project Manager if there is a need for data comparison for WebFOCUS against the former tool BI Publisher.
  • Assisting Manila, Bratislava, and Germany team members in every requirements needed on the WebFOCUS Project.
  • Assigned on reviewing of internal Financial Performance (E6) and Positions (E7) of Legal Entities for Adhesive Business during month end closing.
  • Participates on the facilitation and presentation of Internal Projects assigned if any.
  • In-charged of preparing and generating reports to be used by Top Management from Adhesive Business to make good decisions based on relevant and accurate metrics, presented on a timely manner.
  • Create and update source files to be used for generating Management Dashboard reports.
  • Validates the accuracy of the reports before requesting approval of Adhesive Financial Controlling for publication.
  • Spearheaded the Monthly Management Dashboard Reporting.
  • BUSINESS REPORTING – ADHESIVE BUSINESS

Accounting Specialist (Purchase to Pay)

Henkel Asia Pacific Service Center
07.2010 - 02.2013

REPORTING – GLOBAL INTERCOMPANY

  • Provides timely and accurate reports eg. FTE individual performance, Productivity reports, Block reports, Unmatched payment, cash posting reports
  • Creates or design templates using Microsoft Excel Application, for efficient reporting.
  • Assists colleagues in Microsoft excel navigation and features.
  • Back up for Quality Management team (vendor relations) for reconciliation and posting of Intercompany invoices.

INVOICE VERIFICATION/RECONCILIATION – GLOBAL INTERCOMPANY

  • In-charge for collecting inter-company invoices which were created in different Henkel SAP systems.
  • Responsible for inter-company payables of affiliated companies such as Henkel Belgium NV., Henkel Netherlands, Henkel United Kingdom and Henkel Ireland Ltd.
  • Communicates through call, e-mail, or send messages to global contact partners/colleagues for issues concerning trade and non-trade intercompany payables.
  • Assists / attends to any disputes/ issues that pertain to invoices subject for posting.
  • Posts inter-company invoice, debit and credit notes.
  • Check, match and reconciles inter-company vendor receivables against inter-company payables.
  • Prepare and book inter-company adjustments during month end closing
  • Extracts data from different SAP systems and determine the list of items whose differences were under the threshold limit for GR/IR clearing purposes (Western Europe Region).
  • Conducts analysis and send proposal to local finance for GR/IR items above threshold limit

ACCOUNTS PAYABLE ASSISTANT

Performance Network Inc.
03.2010 - 06.2010
  • In-charge in processing of supplier invoices, match and validates data against JDE systems application in order to process the correct figures for preparation of journal voucher report, transmits afterwards to treasury department for check preparation.
  • Assigned in validation and reviewing of importation disbursement vouchers, checks the amount, prepares entries, and transmit to treasury department as soon as possible to avoid penalties in demurrages fees with Bureau of Customs.
  • Performs bank reconciliation.
  • Attends to incoming calls of suppliers for tracking and monitoring of their collections (payment of suppliers invoices).
  • Assigned in setup of cash advances, clearing and adjusting entries of transfer of cash advances using JDE One world systems applications.
  • Prepares entries for Production, Non-Production, and Electronic Purchases.
  • Prepares and setup intercompany and interbank fund transfers using JDE One World systems application.
  • Assigned at United Laboratories, Inc
  • GL Department Duties

TAXATION

Performance Network Inc.
01.2010 - 03.2010
  • Provision for Income Tax reconciliation against Expanded Withholding Tax Account of trade and non-trade transactions using SAP.
  • Proper accounting, verifying and matching of issued certificates of customer taxes withheld.
  • Accounts Payable versus Accounts Receivable offsetting reconciliation
  • Verify and validates the correctness of service receipts of service providers for proper offsetting with their corresponding balances.
  • In-charge with proper filing of related documents which pertains with taxation.
  • Prepares Summary of Alpha list of Withholding Taxes per period using BIR validation module.

INTERCOMPANY BILLING

Performance Network Inc.
01.2009 - 10.2009
  • Daily accounting of intercompany sales within United Laboratories and its sudsidiaries.
  • Accounting for other non-trade charges
  • Monthly billing of employee medicine incentive.
  • Validating, posting of intercompany sales and issuance of credit notes.
  • Preparation of Adhoc reports which may assign from time to time

BOOKKEEPER

Public Safety Mutual Benefit Fund Inc.,Philippines
11.2007 - 07.2008
  • Prepares accounting entries on disbursement vouchers
  • Prepares accounting entries on cash/check collections
  • Create, update and completion of month end report on cash receipts books.
  • Create, update and completion of month end report on cash disbursement books.
  • Monitoring of aging and its liquidation for other assets (advances to officers and employees)
  • Check attachments or supporting documents on every general fund disbursement vouchers.
  • Prepares report on cash advances schedule and liquidations for financial report schedule.
  • Posting of month end report for general ledger using Accpac software.
  • Assists in preparing interim financial statements
  • Reconciliation of monthly Insurance premium collections.
  • Assigns in cash analysis of every funds and creates schedule for preparation of transfers.

ACCOUNTING CLERK

Public Safety Mutual Benefit Fund Inc.,Philippines
09.2005 - 10.2007
  • Receives and logs incoming documents (e.g., Disbursement vouchers, internal memo, etc.)
  • Preparations of voucher for replenishment of petty cash transactions
  • Provides accounting entries on the disbursement vouchers
  • Assists in reconciling Insurance premium collections
  • Forwards the vouchers for processing to the concerned personnel/department
  • Prepares journal vouchers
  • Monitoring of cash advances schedule and liquidations

Education

Bachelor of Science - Accountancy

Wesleyan University Philippines
01-2001

Skills

Developer - SAP Scripting integration to VBA MS excel

VBA developer for MS Excel

JDE One World system application

SAP

ACCPAC – Accounting Software

Certification

Becoming a Critical thinker – Henkel

Interests

Swimming, Bowling, Badminton, Guitar playing

Timeline

Team Lead / BI Solutions team

Henkel Asia Pacific Service Center
10.2023 - Current

Senior Analyst / BI Solutions team

Henkel Asia Pacific Service Center
07.2017 - 10.2023

Analyst/Developer (WebFOCUS)

Henkel Asia Pacific Service Center
12.2014 - 07.2017

Business Analyst (Business Controlling)

Henkel Asia Pacific Service Center
07.2013 - 12.2014

Accounting Specialist (Purchase to Pay)

Henkel Asia Pacific Service Center
07.2010 - 02.2013

ACCOUNTS PAYABLE ASSISTANT

Performance Network Inc.
03.2010 - 06.2010

TAXATION

Performance Network Inc.
01.2010 - 03.2010

INTERCOMPANY BILLING

Performance Network Inc.
01.2009 - 10.2009

BOOKKEEPER

Public Safety Mutual Benefit Fund Inc.,Philippines
11.2007 - 07.2008

ACCOUNTING CLERK

Public Safety Mutual Benefit Fund Inc.,Philippines
09.2005 - 10.2007

Bachelor of Science - Accountancy

Wesleyan University Philippines
Clarence Rei De Belen ReyesBI Solutions - Team Lead