Conduct research on future utility price trends and volatility to assess the impact of macro shifts on energy costs, providing both quantitative and qualitative insights to support investment in capital projects that mitigate future energy cost hikes Assess future cost savings through a Discounted Cash Flow model to provide guidance on the University’s decision in campus EVs expenditures Consolidate and visualize system-wide utility spending from various data sources to identify main cost drivers and sources of greenhouse gas emissions across 3 years

Led the development of a Power Automate flow to streamline the ETL process from ERP system, saving 5 hours of manual work per week and enhancing Power BI reporting for better data presentation and accessibility Supported the development and testing of an advanced Power Automate flow, extracting key information from over 2,000 Engagement Contracts for faster data retrieval and analysis Utilized Alteryx for high-volume data cleaning, ensuring efficient data handling across multiple systems and sources

Conducted extensive company research via Bloomberg Terminal for provide insights and actionable recommendations on potential portfolio holdings in the Consumer’s sector Formulated opinions with enhanced DCF model, while integrated market analysts’ projections as well as ESG factors to identify risks which are not effectively captured in financial models Received approval from the investors panel for a Buy Pitch presentation of a company in the Food & Retail industry, share price has since been up 55%