Tram Le

• 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

• 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

• 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

• 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

• 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