Brandon Bao

Risk Management Specialist @First Hawaiian Bank

Urban Honolulu, HI, US

Prepare quarterly CECL economic forecasting materials.• Analyze asset quality and portfolio monitoring data and proforma ACL results to determine qualitative adjustments.• Prepare data inputs into RStudio to run ACL calculation.• Support the execution of the ACL estimate from data loading to generating outputs.• Prepare ACL disclosures for the Controller’s Division and ACL results for the Call Report.• Perform peer group and other ACL analyses as needed.• Prepare ACL reports for the Audit Committee, the Board of Directors, and the Controller’s Division.• Perform non-quarter-end ACL estimates in RStudio to inform the Controller’s Division.• Conduct monthly GL reconciliations with SQL and Python scripts• Adhere to all SOX and operational controls, producing necessary SOX control evidence and obtaining appropriate approvals.• Utilize SQL and Tableau to produce monthly and quarterly credit risk reports for Management and other stakeholders.• Fulfill ad-hoc requests for data extracts, reports, and analyses.• Perform user acceptance testing (UAT) on the bank’s credit risk reporting database (Risk Data Mart - RDM).• Collaborate with the Data Services Center to resolve data issues.