Projects & Case Competitions
This section highlights the projects, school work, and case competitions I have completed, showcasing my experience in sustainability strategy, financial analysis, audit and tax practices, and data-driven business decision-making.
UW Management Consulting Club Case Competition
In this case competition, my team & I developed an ESG-focused investment and transition strategy for Aramco, centered on optimizing a $1B capital allocation plan to support decarbonization, carbon management, and operational efficiency initiatives. The project involved conducting integrated financial and operational analyses to evaluate the long-term profitability and sustainability impact of proposed investments, balancing emissions reduction goals with financial returns. I built data-driven models and dashboards in R and Excel to identify key performance trends and support scenario analysis, enabling clearer decision-making around capital deployment. The final recommendation package included strategic investment priorities, risk considerations, and measurable ESG outcomes, presented to simulate executive-level decision-making. This experience strengthened my ability to connect sustainability objectives with financial strategy while applying rigorous analytical and communication skills in a high-pressure, real-world business setting.
William Liang, Edwin Liu, Mei Ka Pow, Yash Sah
Analytic Methods For Business 1: Final Group Project
Built an interactive Cinema Performance Dashboard in Excel/R to analyze box office and concession revenue, ticket sales, and profitability across multiple dimensions including movie type, day of week, and screening room. Integrated financial and operational KPIs such as gross profit, gross margin, and revenue per patron to evaluate business performance and customer spending behavior. Developed visual analytics to compare revenue streams, identify seasonal trends, and highlight key revenue drivers such as new releases and concession combo deals. Enabled data-driven insights for optimizing pricing strategy, improving concession profitability, and supporting cinema operations decision-making.
Analytic methods for Business 2: Final Group Project
Conducted a comprehensive statistical analysis of over 2.9 million cleaned taxi trip records to explore fare patterns, infer population characteristics, and evaluate relationships between key variables using R and statistical modeling. Concepts such as Descriptive & Inferential Analysis, Central Limit Theorem Validation, Confidence Intervals & Hypothesis Testing, Comparative Analysis, Regression Modeling was used in this project.
Stock Picking Presentation
In my AFM 121 End of Term Presentation, my team and I looked at whether it’s better to buy stocks based on expert picks, random selection, or stock indices. After comparing performance, we recommended stock indices because they offer better diversification with 560 companies across two major economies and lower risk. The indices lost 5 percent, while expert picks lost 0.5 percent and random stocks dropped 11.5 percent. We also considered how a 1.5 percent annual fee would affect expert returns and found that experts would need to outperform the benchmark by at least 1.5 percent every year to make the fee worthwhile. We looked at outside factors too, like interest rates, inflation, and defensive market shifts. Verizon’s subscriber and cash flow growth stood out as an example. Our random picks covered industries like tech, finance, retail, food, health, and entertainment. This project helped me get better at comparing investment strategies and using real market trends to back up a recommendation.
Mei Ka Pow 