Wesley Ng

Designed, developed and maintained large volume databases for delivering and filing of weekly/monthly reports while ensuring accuracy, timeliness and thoroughness
Expanded and optimized the existing data process by developing a cloud-based framework using AWS (Amazon S3) and Python and achieved a 30-40% efficiency improvement in workflow
Communicated and collaborated with business partners to understand data requirements, and designed the queries to extract the relevant data for reporting
Validated and cleansed data using reasonability and reconciliation tests for all generated data in order to ensure accuracy and completeness
Identified, cleansed and analyzed any data anomalies and issues on a day-to-day basis with the collaboration of the technology team
Delivered presentations to the management team and facilitated knowledge transfer sessions for peers on newly designed database systems implemented in Python
Interacted and collaborated with the Tableau dashboard team by delivering organized data that aligned with technical and business requirements
Maintained comprehensive documentation to ensure effective understanding and utilization of data process systems

Designed, developed and maintained large volume databases for delivering and filing of weekly/monthly reports while ensuring accuracy, timeliness and thoroughness, Expanded and optimized the existing data process by developing a cloud-based framework using AWS (Amazon S3) and Python and achieved a 30-40% efficiency improvement in workflow., Communicated and collaborated with business partners to understand data requirements, and designed the queries to extract the relevant data for reporting., Validated and cleansed data using reasonability and reconciliation tests for all generated data in order to ensure accuracy and completeness., Identified, cleansed and analyzed any data anomalies and issues on a day-to-day basis with the collaboration of the technology team., Delivered presentations to the management team and facilitated knowledge transfer sessions for peers on newly designed database systems implemented in Python., Interacted and collaborated with the Tableau dashboard team by delivering organized data that aligned with technical and business requirements., Maintained comprehensive documentation to ensure effective understanding and utilization of data process systems.

Led project team meetings to review JIRA issue tickets, monitor outstanding issues, and facilitated communication of project updates to ensure adherence to deadlines
Updated project documentation to support the software development life cycle of various projects
Developed an Excel-based system to automate a manual input process used for testing purposes, which was adopted by the business as a continuous improvement for the existing workflow
Executed functional testing of risk calculators for risk factor models to assess compliance with the BMO’s regulatory capital calculation requirements and provided tickets for both successful and failed cases

Led project team meetings to review JIRA issue tickets, monitor outstanding issues, and facilitated communication of project updates to ensure adherence to deadlines., Updated project documentation to support the software development life cycle of various projects., Developed an Excel-based system to automate a manual input process used for testing purposes, which was adopted by the business as a continuous improvement for the existing workflow., Executed functional testing of risk calculators for risk factor models to assess compliance with the BMO’s regulatory capital calculation requirements and provided tickets for both successful and failed cases.