Oscar Li

Saudi PHAP Project, Quantium (Health and Government Vertical)

• Conducted data exploration, manipulation, and trend/pattern analysis using Excel and SQL
• Collaborated with the team to deliver a dashboard that includes key performance metrics at the hospital and cluster level
• Assisted with deck creation for client presentations and handover documentation
• Contributed to the success of the project, leading to an extension project coming later this year

Department of Education Project, Quantium (Government Vertical)

• Conducted extensive research and performed gap analysis to assist the governance team in achieving their objectives
• Engaged with stakeholders to understand their needs and concerns and provided suggestions through brainstorming sessions
• Assisted with deck creation and presentation
• Created a demo PowerBI dashboard to visualize data quality and completeness metrics for the data registry
• Prepared a technical guide documentation to build the dashboard

Location Data Project, Quantium (Enterprise AI Vertical)

• Conducted market research on location data and brainstormed use cases with SME engagements
• Assisted in prioritizing use cases based on the features and limitations of the Telstra Location Data Project
• Conducted quality assessment of the existing location data pipeline using PySpark
• Contributed to a tender opportunity from Transport sector by providing coverage of the location data at demographic and geographic distributions
• Provided suggestions on the logic that can be used to identify stays and trips from ping data, weighting methodology, and how to reduce noise from the data to help another Quantium team build a new pipeline for insurance use cases

• Providing research on ESG themes and preparing annual report on investment activity against university’s Socially Responsible Investment policy.
• Discovering how well Carbon Intensity Model was played by performing back testing using Bloomberg.
• Understanding and applying ECL model to assess possible credit risk of current portfolio amongst different asset classes.
• Building automation VBA for data filtering process and table updates.
• Assist with timely preparation of periodic performance management and preparation of analysis including commentary on performance attribution analysis and performance against benchmarks.
• Assist in maintaining portfolio data for portfolios on Bloomberg to ensure data integrity.
• Work collaboratively with team of Treasury and Investment to ensure a high level of efficient and value-added services are delivered consistently across all University’s investment portfolios