Derek Li Email & Phone Number

Austin, Tx, Us

Austin, Texas, United States

- Automating Trips BU’s trading models with Excel, Think-cell & Tableau, reduce total processing time by 75%, enabling increased focus on deep-dives into KPIs to advise C-level for P&L strat planning in various Expedia lines of products- Designing & monitoring Air Carrier report dashboard to track airline supplier status, highlighting the correlation in American Airline vs. Expedia’s loyalty programs which accelerated traffic upticks & NBV growth- Mentoring junior team members, equipping an intern from a non-tech background with advanced Excel & Tableau skills, leading to the only returning offer in Marketing department

Austin, Texas, United States

- Led competitor analysis to benchmark Hotels BU’s market share against Booking Holdings. Identified travel demand trends in the US Southeast, informing strategic decisions for Expedia's growth- Gathered market demand & competitor intelligence insights in Expedia’s Market Insights Monthly report to help the Brand Marketing team pivot to last-minute booking campaigns, Enabling more targeted strategies and aligned business goals- Conducted agile project management, hosting grooming sessions to enhance task transparency. Managed timeline & status in Kanban boards, delivered 60+ projects across multi-BUs, and oversaw high-visibility transformational projects in QBR

Austin, Texas, United States

- Led several Client Product Training workshops and iterated on over 100 product features based on stakeholder feedback- Facilitated JIRA-based Sprint Ceremonies for our dev team, ensured a 100% on-time delivery & met our business standards- Designed & streamlined a product QA/QC & testing process for AWS/Python developers, reducing time to delivery by 25%+

Austin, Texas Area

- Led testing & automation efforts for user feedback surveys of various GIS data based applications like Apple Maps- Streamlined Apple Maps QA/QC process with Python script enhanced progress accuracy and cut down time efforts by 75%- Developed an integrated JIRA BI dashboard to track the product development & testing lifecycle to effectively coordinate efforts across multiple teams at Apple, effectively reducing time to delivery of product features by 20%

Atlanta, Georgia

- Performed data scraping & cleaning from complex dataset to deliver BI solutions to 300,000+ local vendors via SQL & R- Collaborated with clients to develop a web app via ESRI suites & Tableau dashboard to improve click-through rate by 30%- Leveraged financial forecasting models to inform client business decision making & drive deeper insights from data

Worcester, Massachusetts

- Coordinated multiple stakeholder requirements to design an enterprise database in SQLite and regulated 10,000+ records- Analyzed location pattern in network analysis to optimize survey routes for field teams by reducing 50% of traveling time- Presented ad-hoc & reoccurring report requests to clients using Power BI & Excel spreadsheets

Master'S Degree, Geographic Information Science And Cartography

Activities and Societies: Student Planning Association, Student Alumni AssociationFor more details, please visit my portfolio.

Bachelor'S Degree, Environmental Science With Geoscience Concentration

Activities and Societies: Hus-skiers and Outing Club, Terra Society, Boston Kendo Kyokai, Downhill Snowboarding, Classical Piano, Jazz.