Romy Pagpaguitan
San Francisco, CA 707-***-**** ********@******.*** linkedin.com/in/romy-pagpaguitan-73318721
SENIOR ACCOUNTANT/SR REPORTING FINANCIAL ANLYST-ASSOCIATE VICE PRESIDENT
Extensive experience in Asset Liability management, budgeting, closings, and general ledger. Strong track record of consistently meeting reporting and regulatory requirements. Analyze business processes and implements initiatives that improve processes while minimizing risk. Works well independently, and as part of a team, in fast-paced environments. Manage, train and lead staff.
EXPERIENCE/SKILLS
Accounting: Review, analyze, and prepare consolidated financial statements and supporting schedule in accordance with the corporate monthly close schedule, including balance sheet reconciliations. Perform monthly/quarterly close procedures and work with functional groups within the organization to account for any unusual and non-standard transaction. Work closely with CFO on special projects. Assist budget and forecasting activities and variance analyses.
Regulatory/SEC Reporting: Extensive experience on CCAR FR Y-14Q regulatory reporting schedules; Risk Based Capital calculations (RBC) RWA, Basel II, SEC and Regulatory Reports :FFIEC101 Regulatory Reporting schedules; 10Q& 10K & FY9C,15.20, 31.0,RC-B, RC-Q Reports; FRY14A. Knowledgeable in DFAST,CCAR data analyses; Capital Planning. Liquidity Form 2052 reporting..
Loans & Other Banking Products: Knowledgeable and hands on experience on FAS91, FAS159, FAS133, FAS52 and FAS115, loan accounting, accruals and non accruals. Acquired knowledge in banking operations, lending, loan underwriting, servicing; investments, securities, trading assets, commercial and consumer loans, Leases, and accounting for new products. Developed complex excel spreadsheets for accurate calculations and timely reporting.
Computer Systems/Skills
Develop scripts to extract data utilizing Essbase for management reports; validate tables and error checks.
Advanced Excel Functions (Vlookup, Pivot Table), VBA, Macros,Essbase, AXIOM, Workiva, Wdesk, PowerPoint,
Oracle People soft, Windows 10, XML, XBRL reports.
EXPERIENCE
MUFG- Union Bank/US Bank, Oakland, CA 12/2015 – 09/2023
Associate Vice President - Regulatory Reporting Analyst
Prepared and submitted various schedules for FR Y14Q/M, RCI,RCT, OpsRisk and PPNR to FRB.
Collaborated and validated data from SEC Reports, FFIEC031-RC-N, RC-L, RC-C, RI; FRY9C,HC-R and RC-R.
Reviews and analyze data from various data sources and collaborate data from other regulatory reports and financial statements.
Performed variance analyses and adjustments
Follows FRB instructional changes and updates to reporting requirements
Report and support related to process improvements, controls testing and remediation activities.
Collaborate with and manage cross-functional teams which include Treasury, Finance, Controllers, Risk management, Governance, Controls and Procedures. Create presentations regarding BASEL III & CCAR/DFAST related activities.
Prepared and presented reports (Power Point) to stakeholders and senior management for certification and approval prior to FRB submission.
Prepared reports in XML and XBRL format.
Conducted training for new and current team members on processes, requirements and system functionalities.
Risk modeling, performed data validation, regression testing and validation.
Bank of the West, Dublin, CA. 09/2015 – 12/2015
Sr. Treasury Analyst-Contractor
Performed data analysis and reconciliation for Liquidity reporting FR 2052a and LCR.
Wells Fargo & Co., San Francisco, CA. 06/2010 – 09-2015
Sr. Financial Consultant-Treasury – Contractor
Performed calculation-reconciliation of General Ledger Asset balances and Risk Type exposures of Assets (RWA) subject to RBC (Risk Based Capital) Pillar1calculations. Determined the propriety of Exposure calculation process; Risk types; and risk parameters (i.e. PD, LGD, EAD) in accordance to Basel II rules.
Prepared exposure gaps analysis to determine any error in the submission of data by line of business that impact the capital charge (RBC ratio).
Analyzed FFIEC101 Regulatory reports Schedule A (Tier 1 and Tier II) and Schedule B whose Exposures type and other elements conforms to Basel II rules.
Knowledgeable in differentiating GAAP definition of assets against Basel II asset definition for types of Risks; Credit Exposures; Credit derivatives; and Credit mitigants.
Comprehensive knowledge in Retail, and Wholesale credit risks; market and operational risks. Develops and extracts Essbase data for reconciliation and management reporting.
Knowledgeable and contributes in CCAR and Dodd Frank Act data input and analyses.
Wells Fargo & Co., San Francisco, CA
Sr.Accountant – Wholesale and Retail Controllers
Prepared validation narratives for CICAT (Centralized Issue and Corrective Action Tracking), including testing and validation steps in remediating system flaws and weaknesses.
Reviews process narratives and documentation to some system processes and ensures compliance with SOX 404 as well as WFB Regulatory Reporting G&O internal control requirements.
Review Desk Top Procedures and Data Flow Diagram for system processes to ensure compliance witj SOX and WFB internal control requirements and for completeness and accuracies.
Performed GL account analyses for Loans and Unused Commitments to conform with FFIEC 031 RC-C and RC-L lines definitions; create new GLs; map to SEC Hierarchy for FRY 14 reports.
Set up and flag GL accounts to meet the requirements on report preparation instructions; conform to Basel RWA calculations and Y9C schedules.
Prepared regulatory/SEC reports 15.20 (Non Marketable Equity Investments), 31.0 Fair Value Asset/Liability roll forward, call reports RC-Q (Assets and Liability) measured at FV on a recurring basis, and RC-B (Marketable Debt Securities Pricing-Bonds; FAS157/159 Fair Value Recurring.
Calculates monthly pricing and valuation of Securities (SAFS and HTM) and records MTM gains/loss.
Analyzed Fixed Asset acquisitions, recording, depreciation, leasing and expenditures. Performed variance analyses,
United Commercial Bank, San Francisco, CA. 06/2005 – 11/2009
Senior Accountant
Responsible for month-end close.
Performed GL account setup and analyses; variance analyses; equity analyses, elimination/consolidation of financial statements and roll up of equity.
Performed Trust and Investment accounting.
Analyzed Balance Sheet and Income Statement for the holding company and subsidiaries (pre close) prior to submission and review of senior management.
Managed and led review of Balance Sheet accounts prior to close.
EDUCATION
BA Accounting
University of the Philippines
Certificate Computer Programming Courses - Control Data Institute, San Francisco, CA
LICENSES
CPA (inactive)