Brandon Tran Email & Phone Number

San Francisco Bay Area

• Spearheaded the premier global dashboard in Excel for OpenTable and KAYAK, enhancing KPI tracking efficiency for senior management and the collections team. This innovation led to a decrease in aging by an average of $2M per month, resulting in a 10% reduction in Days Sales Outstanding (DSO) between 2023-2024.• Created monthly presentations for Finance Senior Leadership on KPI statistics and provided analysis on financial trendlines (DSO, Aging, Collections Efficiency Index (CEI)). • Implemented a global lockout list to identify severely overdue accounts eligible for service suspension. This initiative enabled OpenTable to increase lockouts by 50% and reduce its overall past due balance by 20%.• Engineered a portfolio dashboard template for the Collections and Sales teams to evaluate their portfolios and identify high-risk accounts. Facilitated collaboration on escalation strategies, such as meetings with CEOs/CFOs or service suspensions, resulting in a 30% increase in successful responses and payments.• Compiled NetSuite Aging reports into Pivot Tables to facilitate easy data sharing with stakeholders and the Sales team• Cultivated strong relationships with Enterprise clients and diligently followed up on payments, achieving a 50% reduction in my annual past due balance portfolio in 2024.• Designed an Aging template for the Collections team, enhancing account review and follow-up efficiency. This initiative boosted payment collections by 20%, as collectors could more effectively manage their portfolios and maintain account oversight.• Delivered Past Due and Suspension Notice dunning to OpenTable’s 50K+ North American customers

San Francisco Bay Area

• Managed 100% of OpenTable’s Enterprise customer’s past due balances with an average portfolio of $4M. • Updated client's financial accounts and created cash receipts using GreatPlains. • Communicated with company network and document case interactions through Salesforce. • Generated Excel templates that allowed the Collection team to increase payment documentation accuracy. This resulted in a decrease of 20% in cash receipt errors.

Condensed raw data by retrieving and organizing key attributes with SQL and API'sAnalyzed Spotify's 2018 top tracks, utilziing Python and Tableau to understand trends and variables that created a hit song. Provided statistically driven recommendations to stakeholders for Lariat that would increase profit margin by 30% while also decrease expenses by 10%Organized presentations that clearly explained data driven results to both stakeholders and non-technical audiences

Oakland, California

Calculated daily financial earnings and compares amount to physical returns in register.Booked and organizes daily schedule for attending technician.Handled service transactions and provided excellent customer service.Operated company's scheduling program proactively with real-time updates.

Riverside, California

Develop programs and plan events to structure the pledging process Delegate duties to a committee of four and manage their obligationsDebrief Fraternity officers on pledge progress and upcoming eventsFacilitate weekly workshops to sharpen interview skills and build professional demeanor

Oversaw the recruiting activities and the pledging ceremony of the chapterInquired local organizations to coordinate potential sponsorshipsOperated room reservation system through campus hub to organize Fraternity eventsAssisted the chapter president’s role as well as during his or her absence

Established better relationships with other chapters in the Pacific Coast RegionCommunicated with presidents of other business organizations to plan future eventsCoordinated professional events with other chapters in the regionDevised social events with other professional fraternities on campus

Procured potential listings by researching public records on new land developmentIncreased the realtor’s presence through Facebook, Twitter, and Instagram Constructed monthly marketing reports that included an in-depth analysis on ROI Monitored Facebook ad progress to better understand and optimize ad buying strategy

• Generated pivot tables to organize patient information using SQL • Utilized SQL to wrangle raw data and determine relevant KPi's. • Created Tableau Dashboards and implemented data into presentations to share with stakeholders • Analyzed data results and developed monthly reports on case demographics.

Attended weekly instructors meetings. Planned for future class itinerariesProvided feedback to guardians of students.Mentored new instructors on proper teaching habits.

University Of California, Riverside

Discussed collaborations with Circle K and Habitat for Humanities.Contacted local volunteer organizations and shelters. Organized service events. Notified and informed collegiates about promoted service events.

Education record

Bachelor Of Science, Business Administration