Jay Ford Agustin

Experienced OneStream Consultant with hands-on experience delivering full-cycle CPM implementations, including system configuration, reporting solutions, and end-user training. Known for a practical, business-focused approach to technical challenges, and a strong ability to collaborate across finance and IT teams. Skilled in helping clients streamline financial reporting processes while supporting long-term solution adoption.

• CPM Platforms: OneStream XF, Oracle Hyperion Financial Management (HFM), BlackLine Reconciliation
• ERP Systems: PeopleSoft
• Programming & Scripting: VBA Macros, VB.NET, SQL
• Productivity Tools: Microsoft Excel (Advanced)

● Financial Reporting and Consolidation

● Financial Analysis

● General Accounting and Reconciliation

● Lease Accounting - IFRS 16 and ASC842

● Functional Support – HFM and OneStream

• Certified Public Accountant
• OneStream Certified Associate
• VB.Net Introduction
• The Complete SQL Masterclass

AMCO Solutions - Makati City, NCR, Philippines

Senior CPM OneStream Consultant (April 2024 - February 2025)

CPM OneStream Consultant (December 2021 - April 2024)

• Configured a wide range of OneStream components, including Cubes, Workflows, Data Sources, Transformation Rules, Form and Journal Templates, Cube Views, Dashboards, and System Security settings.
• Developed and maintained various reporting solutions in OneStream such as Custom Reports, XF Cube Views, Dashboards, and Report Books, supporting high-level corporate performance reviews and decision-making processes.
• Served as a trusted point of contact for client support—troubleshooting OneStream-related issues, resolving technical concerns, and delivering timely, structured responses to ensure high client satisfaction.
• Participated in the full-cycle implementation of AMCO’s Lease Accounting Solution, from gathering requirements through to system installation, configuration, training, and post-deployment support.
• Worked closely with project managers and other team members to communicate project status, address open issues, review action items, and ensure alignment with project timelines and deliverables.
• Conducted thorough user interface testing for the Lease Accounting solution, documenting defects and collaborating with development teams to achieve successful user acceptance testing (UAT).
• Facilitated training sessions and workshops for end-users and stakeholders, enhancing the adoption and proficiency of OneStream solutions across client organizations.
• Authored and maintained detailed technical and process documentation to support ongoing development, user reference, and knowledge sharing.
• Mentored other consultants on OneStream architecture, AMCO's Lease Accounting Solution, optimization strategies, and implementation best practices, fostering team capability and project success.

QBE Global Shared Services Centre - Taguig City, NCR, Philippines

Finance Service Analyst (December 2019 - December 2021)

Finance Service Specialist (January 2018 - December 2019)

• Analyzed, examined, and interpreted accounting records, reconciled reports, and financial data.
• Processing journal entries and performing accounting corrections to ensure accurate accounting records.
• Reconciliation of medium and high complexity accounts in Blackline.
• Resolves daily issues and escalations, provides valuable contributions for their resolutions, and communicates information to the POC to prevent further issues.
• Processing of invoices to relevant expense accounts and departments.
• Assists in audit-related requirements.
• Analyzes reports for trends, variances, and movements.
• Process improvements to streamline processes.
• Maintains the DTP of current processes and incorporates documentation updates as required.

Bachelor of Science in Accountancy

University of Saint Louis Tuguegarao, Cagayan, Philippines

April 2017

Jason Call

Group Development Director, AMCO Solutions

jason.call@amco.one

Ruchita Arora

Managing Consultant, AMCO Solutions

ruchita.arora@amco.one

Rochelle Camba

Subject Matter Expert, AMCO Solutions

rochelle.camba@amco.one