IA Ymer Hermo

Senior Financial Analyst | Financial Automation & ETL | Reconciliations & Reporting
📍 Manila, Philippines ✉️ ia.hermo7@gmail.com 📞 +63 998 946 3556
80% – 100%
Reporting Cycle Acceleration
1 – 3 Days
Post Month-End Turnaround
4 Institutions
Enterprise Banking & Finance

Featured Impact Spotlight

Case Study • Workflow Automation

Month-End Reporting Automation & Discrepancy Resolution

Engineered automated ETL financial workflows using Alteryx and TLM to compress standard monthly closing periods, delivering audited financial packets directly to global stakeholders.

Alteryx TLM Workflows Variance Analysis Audit Trail Creation

Key Deliverables & Solutions

Automated Financial Dashboards

Dynamic financial reporting templates that automatically aggregate, clean, and visualize KPIs, revenue trends, and operational variances from raw system extracts.

Excel Power Query Power BI KPI Tracking

Reconciliation & ETL Pipelines

Automated Alteryx and Excel data-cleaning workflows built to reconcile complex general ledger accounts, isolate data discrepancies, and eliminate manual processing errors.

Alteryx Data Matching Variance Resolution

Month-End Close Packages

Structured management decks, variance commentary reports, and complete balance sheet audit trails finalized and ready for executive review within 1–3 post-close days.

Financial Reporting Audit Trails SOP Documentation

Core Competencies

Financial Analysis & Strategy

Portfolio Performance Financial Reporting Budgeting & Forecasting KPI Dashboarding Variance & Trend Analysis Financial Reconciliations Cash Flow Analysis Audit Readiness

Systems & Data Automation

Advanced MS Excel Alteryx ETL Power Query TLM Systems Power BI (Basic) SQL (Foundational) Python (Foundational) Process SOPs

Professional Experience

Macquarie Group
Oct 2024 – Jan 2026
Senior Associate, Financial & Data Analysis
  • Compressed monthly financial reporting cycles by 80% to 100%, consistently submitting critical closing packages 1 to 3 days post month-end using Alteryx and TLM workflows.
  • Executed portfolio-level financial analysis across complex asset classifications to isolate performance trends and reconcile data anomalies.
  • Maintained tight financial planning frameworks through systematic data validation and automated audit trails.
  • Engineered structured, presentation-ready financial reporting models utilized directly by global internal stakeholders.
  • Automated operational data pipelines to seamlessly bridge cross-functional financial workflows.
Land Bank of the Philippines
Sep 2022 – Mar 2024
Accounts Assistant, Financial Review
  • Accelerated reporting turnaround by 80% to 100% by finalizing comprehensive operational accounts review packets within 1 to 3 days post month-end.
  • Audited balance sheets, general ledgers, and operational supporting document tracks to maintain regulatory compliance.
  • Managed baseline budget parameters and executed deep-dive variance evaluations across multiple business accounts.
  • Investigated structural ledger discrepancies and partnered with clearing units to correct operational recording variances.
Security Bank Corporation
Dec 2018 – Mar 2020
Operations Specialist
  • Executed rigorous data verification routines and ledger reconciliations to secure system integrity and reporting reliability.
  • Compiled portfolio health datasets and maintained structural risk frameworks across production environments.
  • Integrated operational control checkpoints that cut reporting errors and strengthened internal audit compliance metrics.
Accenture
Aug 2016 – May 2018
Transaction Processing Associate
  • Executed high-volume financial transactions while exceeding quality thresholds and client SLAs.
  • Governed comprehensive ledger entries and system uploads to guarantee transaction tracing audit-readiness.
  • Collaborated with standardizing cohorts to streamline shared operational processing scripts.

Education

Far Eastern University
June 2012 – May 2016
Bachelor of Science in Business Administration (Major in Financial Management)