Nathan Yau Email & Phone Number

Vancouver, British Columbia, Canada

Toronto, Ontario, Canada

◆ Transformed a previously time-consuming manual process into a swift 20-minute task through the strategic implementation of VBA scripts. ◆ Performed audit on payroll data, demonstrating a meticulous approach to ensuring accuracy and compliance.

Hong Kong, Hong Kong Sar

In my last role, I compiled various management reports on market performance. I provided key business requirements for the development of an RPA-scripted statistical report. I ensured compliance with established regulations and operational procedures.Some of my key achievements and contributions:◆ Guided timely delivery of a software upgrade project with a 2-year roadmap as a Project Coordinator, demonstrating exceptional project management skills, attention to detail, and expertise in data visualization and modeling.◆ Developed User Testing and Performance Testing capabilities for a software upgrade project, facilitating comprehensive evaluation of user experience, functionality, and system performance.◆ Successfully produced valuable insights and facilitated informed decision-making by conducting data analysis and market research using advanced Excel, SQL, and Tableau skills.◆ Developed automated data wrangling process on derivative market data using Trifecta as well as automated statistical reports using Tableau, Excel, and Power BI.◆ Enhanced operational efficiency, data analysis, and reporting by developing a data model to integrate data from multiple sources on Power BI, Trifecta, and Dremio.

Hong Kong, Hong Kong Sar

I optimized VBAs to streamline operations and ensure efficient workflow within the team. I utilized root cause analysis techniques to identify underlying issues, established clear communication lines, and displayed a keen eye for detail.Some of my key achievements and contributions:◆ Engineered an advanced automated data capture process using VBA, enabling real-time extraction and analysis of market data while saving time and enhancing accuracy.◆ Proactively monitored and reported market abnormalities to the supervisor to mitigate potential financial risk.

Hong Kong, Hong Kong Sar

I addressed inquiries and requests from exchange participants. I offered comprehensive document management services.Some of my key achievements and contributions:◆ Ensured the integrity and reliability of data by meticulously entering information into relevant systems, minimizing errors, and maximizing data accuracy.◆ Facilitated thorough evaluation and compliance of guarantee applications within the SME Financing Guarantee Scheme (SFGS).

Computer Systems Technology, Diploma, Computer Science, 96%

Bachelor Of Business Administration (Bba), Human Resources Management And Services, Finance