
CJ Bautista
Excel VBA Developer , Process Automation Specialist, Financial Reporting Expert
Kompetenzen

Meine Dienstleistungen


Arbeitserfahrung
Treasury Senior Professional
QBE • Vollzeit
Feb 2023 - Present • 3 yrs 7 mos
• Prepare daily and monthly cash forecasts to support liquidity visibility and treasury funding decisions. • Perform bank account reconciliations across multiple entities and banking partners, investigate variances, and support timely resolution of outstanding items. • Review market-linked and non-market-linked bank account interest rates and prepare recurring monitoring reports with supporting evidence. • Prepare NDF collateral and counterparty limit exposure reports to support treasury risk monitoring and control activities. • Maintain records for operating accounts, trust accounts, lines of credit, legal entities, and related banking arrangements. • Support bank account opening, closure, maintenance, service setup, and periodic transactional and monthly cleanup activities. • Monitor bank-statement connectivity across Kyriba and Quantum TMS, coordinate issue resolution, and perform manual uploads when required. • Collaborate with onshore and global stakeholders on daily and monthly business-as-usual deliverables, reporting requirements, and issue follow-up. • Maintain audit-ready documentation and supporting evidence for internal and external control reviews. • Develop and enhance Excel VBA macros and Power Automate Desktop workflows to reduce repetitive manual work and improve process consistency.
Accounts Payable Associate
Alorica Teleservices • Vollzeit
May 2020 - Feb 2023 • 2 yrs 9 mos
• Processed and reconciled petty cash funds for multiple Alorica sites, ensuring complete documentation and accurate records. • Processed invoices in Oracle and supported accounts payable controls, tracking, and issue resolution. • Prepared BIR Form 2307 documentation and maintained records for compliance and audit requirements. • Managed official-receipt tracking and organized soft-copy and hard-copy documentation through SharePoint. • Prepared backlog, reconciliation, and operational reports for management review. • Supported BIR and internal audit requirements through systematic filing, evidence gathering, and records maintenance.