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.

• 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

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

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