Data Analyst
- Built search tool in Excel that provides company information and calculates adjusted emission intensity for 6 sectors and allows traders to monitor emission performance against DBS bank’s annual target - Performed risk analysis of DBS non-retail borrowers’ assets for CN and TW markets for annual sustainability report that discloses bank’s overall risk level under climate change scenarios- Using VBA and Python, mapped 240K+ DBS collaterals of the entire portfolio with latitude and longitude and floor numbers; Analyzed and visualized all collaterals on an interactive map using Folium for MAS Industry-Wide Stress Test- Obtained physical risk scores of 8 hazard types to DBS collaterals by assigning proxy assets using external dataset based on nearest distance using Python- Insured data quality by cross validating data from different vendors and internal data