Kelvin Siu

Data Analyst (Global Banking and Markets) @Scotiabank

Toronto, ON, CA

Participated in the International Business sector, facilitating the transformation of loan products from LIBOR to SOFR rates for 6 South American countries- Acted as a liaison between the business community and the IT organization, overseeing the transformation of 5 Canadian banking mortgage/lending projects to adopt the SOFR Convention following LIBOR Cessation and the CORRA Convention after CDOR Cessation- Engaged the full Lift & Shift projects to migrate 3 systems from DataStage to Talend, and received signoff from business with <0.01% of difference after migration- Analyzed data in Hadoop Big Data, MobaXterm, Talend, and Datastage environments, handling structured, semi-structured, and unstructured data from various sources- Ensured compliance with all applicable data regulations, documentation, and policies for 15 products in the Data Lineage project- Developed scripts in VBA/Python to automate testing and SQL approaches, resulting in a 20% reduction in manual tasks during testing.