Tram Le Email & Phone Number

Mountain View, Ca, Us

San Francisco, Ca, Us

• Built and managed quarterly forecasts & annual planning process for the Real Estate & Workplace portfolio of over $250M+ a year, including but not limited to real estate operations of 40+ offices across the world, global events programs, onsite food programs• Presented actuals and forecasts narrative and drivers to key stakeholders, including but not limited to staff, VP of Real Estate and Workplace, and corporate finance leadership• Performed bi-monthly and quarterly variance analysis to deep dive into core cost drivers for labor and non-labor, CAPEX, depreciation, stock-based compensation within the REW functional budgets and develop narrative on variance explanations• Partnered with the Lease Operations and Technical Accounting team to model cash and GAAP financial impacts of real estate decisions• Actively tracked and managed a global location-based predictive headcount forecast to inform and actively participate in office space planning discussions with key stakeholders

Seattle, Wa, Us

• Responsible for weekly, monthly, and quarterly reports to C-suite leadership via the use of Hyperion Essbase and Excel, including performance KPIs, full P&L story telling, and variance analysis versus forecast/financial plan/strategy plan• Prepared presentation materials via PowerPoint for the CFO, Board of Directors, and Audit Committee by partnering and coordinating with all business units to consolidate and validate financial information• Partnered with regional contacts for all international markets and BI team on a daily-basis to ensure accuracy and consistency in weekly sales and store KPIs submission as well as troubleshoot inquiries regarding back-end data flow via SQL queries and datasets

Seattle, Wa, Us

• Performed monthly and quarterly FP&A reporting via the use of Oracle BI, Hyperion, Essbase, and Excel, deep diving into variance and providing visibility into OpEx spend and headcount trend for business partners• Forecasted annual OpEx budget of roughly $40 million, including projections for headcount costs, capitalization rates, and attrition rates on a quarterly basis• Managed and streamlined headcount data of 400+ employees and partner with multiple functions to ensure consistency• Automated the reconciliation process of headcount details between Workday and Mingle databases, reducing task time by 70% and receiving shout-out in monthly central org meeting for “Team Wins” recognition • Developed and maintained a headcount matrix that allows for high-level snapshots of resources under 12 different leaders and 8 funding sources as well as variances between different scenarios, allowing for better visibility of headcount trend

Dallas, Tx, Us

• Performed valuations of roughly $500 million and over 70 investments in nationwide multi-family real estate by analyzing financial statements, evaluating due diligence, collecting comparable data, researching property specific demographics and submarket economic trends• Established supportable valuation assumptions, built discounting cash flow (DCF) models, and made appropriate estimates with minimal or ambiguous information to determine net present value (NPV), internal rate of return (IRR), return on investment (ROI), profit and loss (P&L)• Maintained ongoing communication with clients and other parties in deal teams to manage project timeline• Presented investment strategies and answered deal questions from brokers and clients• Updated data in CRM system via Salesforce to ensure consistent workflow across all departments• Conducted data visualization projects for clients using Tableau• Acted as the technology subject matter expert to improve CRM user interface and consolidate resources into one virtual library

Bellevue, Wa, Us

• Performed SQL queries to extract data tailored to different business needs, providing visibility into cost drivers• Collaborated in a team of 3 members to track data, generate reports, and match team’s results with FP&A results• Analyzed trends and patterns in data under different views using Pivot Table and Pivot Chart via Microsoft Excel• Matched 10-50 daily invoices from vendors with daily and weekly uploads to ensure accuracy

Seattle, Wa, Us

• Audited and forecasted financials of 10 Amazon Business Development entities for reporting purposes• Allocated and reconciled 50+ expenses for 10 cost centers and developed a cost-saving methodology for the allocation• Prepared and allocated headcount data via Cognos to maintain accuracy, improve efficiency, and streamline the process of acquiring data for teams across the company• Created a standardized and automated P&L view with variance analysis for the Advertising businesses as part of overall Retail• Conducted ad-hoc projects from different teams through extensive use of Excel and Cognos