Brandon Bao Email & Phone Number

Urban Honolulu, Hawaii, United States

• 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.

• Collaborated as team member of the backend development team for IntelliPro's Customer Journey product• Developed and tested time based APIs and functions• Integrated email sending APIs and functions with updated core module

Coatesville, Pennsylvania, United States

• Preparation of monthly Deposit Loan Operation reports for the Board of Directors• Compiles reports for the ALCO (Asset Liability Capital Committee) and Credit Committees• Composition of weekly, monthly, and quarterly reports to support commercial and retail sales• Create any ad-hoc reports to support management team• Implements automatic reporting through Sageworks (analysis software) Advanced Reporting• Assisted Credit and Loan Operation in the integration of Sageworks • Creation and maintenance of 77 report templates in iCore (core processor) and Sageworks• Maintains data accuracy for Sageworks with iCore as Single Source of Truth• Administers all accounts payable functions within the bank• Performs daily and monthly reconciliation of 21 general ledger accounts• Collaborate with accounting in preparation of monthly and quarterly financial statements• Assists in quarterly and monthly audits

Suzhou, Jiangsu, China

• Trained and supervised substitute staff in the operation of the software before end of contract• Maintained and updated the materials list while acting as support for colleagues• Collaborated with Kingdee support staff to efficiently implement the new management software• Set up material identification codes by interpreting and categorizing almost 1100 materials• Created employee hours tracking sheet for HR to streamline employee work hours processing• Greatly improved the office supplies tracking efficiency for administration by creating a VLOOKUP compatible excel sheet• Performed ad hoc tasks for HR, accounting, and administration as neededKey Achievement: Collaborated management and R&D staffs to compile a master list for all materials, which was then uploaded into Kingdee KIS to standardize purchasing for all departments

State College, Pennsylvania Area

• Investigated, analyzed, and settled all cash drops and credit card charges• Collected deposits from all OTA reservations to help streamline check-in process• Extracted data from Opera POS to assist management with decision making• Gathered and compiled all essential data for the accounting director• Acted as manager on duty for the overnight shift• Accommodated hotel’s staffing needs by cross training as a front-desk agent and housekeeper

Shanghai

• Analyzed daily check-in reports and compiled arriving VIP reports for front desk and all department heads to assist them in personalized greetings• Ensured smooth check-ins for VIP guests as well as make sure all respective amenities, such as desserts and fruit baskets, are placed in the room before the guests arrive• Helped facilitate a friendly environment for foreign VIP guests by communicating with them in a manner that is familiar to their culture• Attended to VIP guests’ needs and managed front and back of the house logistics in Club Millesime, an exclusive Sofitel club lounge; such as cleaning, counting inventory and maintaining equipment• Attended daily meetings with front lobby manager for status report and help facilitate discussion among front lobby divisions• Create customized welcome letters for arriving VIPs

Shanghai City, China

• Provided personalized service for new arrivals• Served as translator and tour guide for foreign guests• Collaborated with front desk agents to improve customer experience. • Helped train new staff members.

Master'S Degree, Software Development

Master Of Finance, Corporate Finance, Cumulative Gpa: 4.00

Bachelor'S Degree, Hospitality Administration/Management, Cummulative Gpa: 3.20, Major Gpa: 3.56

Activities and Societies: Elite League of Hospitality in Asia (ELHA), Korean Student Association (KSA)

High School Diploma

Activities and Societies: Cornerback in The Spartans football team