Shawn Lee Email & Phone Number

San Francisco, Ca, Us

San Francisco Bay Area

• Explored how heatwaves in India affect decision-making by building regression models in Python

San Francisco, California, United States

• Improved donation forecasting error by 21% vs existing estimates by using an ensemble of predictive time-series models in Python• Optimized fundraising prioritization for 10,000 fund titles by developing key performance indicators (KPIs) that track donor interest and presenting to decisionmakers using data visualization tools such as Python matplotlib• Generated over 10 CRM reports for internal stakeholders by writing SQL queries on Snowflake and modifying Tableau dashboards

National Capital Region, Philippines

• Identified $227 million in potential revenue by conducting a comparative price analysis on train and bus fare pricing, leading to the first fare increase for metro lines in nearly a decade• Reduced the time needed to generate reports from 4 hours to 1 hour by removing redundant data points and eliminating the need for manual verification by using SQL queries and Excel functions• Led a team of four members to conduct operational and financial analyses by organizing team resources, working with cross-functional project management teams, and conducting SQL and Excel training sessions• Created over 30 reports, memos, and presentations used by the Undersecretary to communicate multibillion-dollar budget proposals

• Reduced sales turnaround times by 50% by developing flexible pricing schemes to accommodate client needs

National Capital Region, Philippines

• Optimized the physical layouts of over 100 stores by collecting data on existing configurations and customer queue behavior, then running Monte Carlo simulations to estimate the expected revenue of alternative layouts using Excel and VBA• Launched 4 new products and tools through end-to-end product development from business case conceptualization and unit economics with finance, strategizing communications with marketing, and pilot testing and go-to-market (GTM) with operations• Rolled out new products to a network of 1000 stores nationwide by communicating benefits to franchisors and store managers

National Capital Region, Philippines

• Identified inefficiencies in driver onboarding by conducting Root Cause Analysis on third-party contractors• Improved document processing times by 200% by implementing standard operating procedures and forms

Master Of Science - Ms, Applied Economics, 4.0/4.0

Bachelor Of Science (Bs), Industrial Engineering, Cum Laude

Reducing Inventory Cost Through Demand Forecasting and Economic Order Quantity-Reorder Point Models