Senior Enterprise Solutions Architect & Consultant

Thomas CHEUNG

Bsmt ***** Amethyst Ave, Richmond BC V7A 3A8

Cell: 604-***-**** ***************@*******.***

Career Overview

Current job title is Senior Consultantand achieved status asSolutions Architect, technical manager. Areas of expertise including IBM CICS, DB2, MQ, development, integration testing, automation testing. Facilitated problem shooting meetings to identify possible errors and suggest solutions to fix issues.

Qualifications

• B.Sc (HongKongPolytechnicUniversity) • Diploma in Management Studies (DMS)

• FCMI • MBCS • MACS • GA instructor of Dale Carnegie Course

Technical Skills

Skills Total yearsLast Used

Problem Solving and Analysis > 25 years Current

Solution Architect to provide directions and solutions on new projects > 5 years Current

System Automation, devised test plans, test cases and schedules > 10 years Current

System Analysis and Design (defining and refining requirements) > 20 years Current

SDLC Project Management (good management and leadership skills) > 10 years Current

Emergency Support (willing to work odd hours, provide 24/7 on call support) > 25 years Current

Work Experience and Achievements

Senior Consultant ICBC working remotely (Mar 2023 – Mar 2026)

Worked as MQA on IMS DB2 CICS on SYSPlex and provide system support on CICS and DB2.

Developed business rules, scripts, and integrations using Java to build Billing Center.

Worked as a MQ SME and managed process improvements, investigate MQ CPU usage and determine the cause of poor performance.

Worked as Oracle developer and managed system and produced weekly reports to Manager and VP.

Configured and enhanced Billing Center modules invoices, payment plans, collections, write-offs and adjustments.

Developed and Supported CICS DB2 programs and PL1 programs.

Worked a IMS DB2 developer on Simplex and provide system support on CICS and DB2 for multiplex.

Provided multiple parallel SYSplex for IMS DB2 multiple parallel CICS DB2 multiple parallel Sysplex.

Senior Consultant and Quality Analyst HSBC Bank working remotely (July 2021 – Feb 2023)

Worked as Oracle developer and managed system and produced weekly reports to senior Manager and

VP included general reporting and analysis.

Worked as an developeron relational databases Oracle, SQL Server, and migrated data and modeling.

Ensured understanding on performing a variety of database optimizations that will include general reporting and analysis of the efficiency of the database configuration and ensure maximum uptime according to the SLA.

Led a development team and assist junior team members on IMS DB2 for CICS system.

Ensued and understanding on performing a variety of database optimizations that will include general reporting and analysis of the efficiency of the database configuration and ensure maximum uptime according to the SLA andperiodic review of database performance.

Managed Jira system and produced weekly reports to senior Manager and VP.

Gained testing and product knowledge. Gained understanding and participates in the creation of testing strategies, plans and test cases.

Managed a backup plan and test plan for failure scenario andplaned Backup / Restoration Strategy for 24x7 operation support.

Worked as a CICS Administrator and Mainframe Administrator on HSBC project.

Consultant IBM (Kyndryl working remotely) (June 2020– June 2021)

Supported CICS DB2 programs for Air Canada.

Upgraded MQ from version 9.1 to 9.2for Cooperators and BNS. Upgraded MQ from version 8.0 to 9.1 for MTS, D+H, Air Canada, Bell, Sun Life Financial and WSIB.

Performed MQ online performance and Developed PL/I programs for MTS and WSIB.

MQ online performance and Developed PL/I programs for MTS and WSIB.

Developed CICS DB2 programs for MTS and D+H.

Developed PL/I programs for MTS and WSIB.

Performed Mainframe system upgrade for MTS, WSIB and Sun Life Financial.

Automated systems and processes to streamline operations and improve productivity.

Automated systems and keeps them updated and improve productivity by making processes smoother and better.

Senior Consultant BC Hydro – Burnaby, Canada (Feb 2014 – Aug 2017 )

Prepared test plans, test scripts with efficient SQL to extract DB2 data for all sprints test, and performed ETL code development.

Worked as Oracle developer and managed system and produced weekly reports to senior Manager and

Prepared test plans, test scripts with efficient SQL to extract DB2 data for all sprints test, and performed ETL code development.

Prepared test plans, test scripts with efficient SQL to extract DB2 data for all sprints test, and performed ETL code development

Prepared test plans, test scripts with efficient SQL to extract DB2 data for all sprints test, and performed ETL code development.

Developed test tools Pythyon, Selenium for automation test, system test and integration UAT plus performance.

Developed CICS DB2 programs for CS Project and provided CICS DB2 programs to support systems.

Worked as Oracle developer and managed system and produced weekly reports to senior Manager and

VP include general reporting and analysis.

Worked as a Subject Matter Expert (SME) on CICS DB2, SQL, Python and RDBMS to provide solutions to performance issues.

Worked as automation collaborate with Automation Technicians, IT Project Managers, and the upper management team in an organization. They perform most of their duties in office environments and report to an engineering manager or a director of engineering. They can work part-time, full-time, or on contract in an organization.

Developed CICS DB2 programs for CS Project and provided CICS DB2 programsto support systems.

Worked as a MQA & DBA on CICS DB2 and provide production support on CICS and data base.

Designed, installed and implemented CICS DB2 programs for UAT.

Developed test toolswith Selenium Pythyon for automation test, system test and integration UAT plus performance.

Consultant ICBC (The Insurance Corporation of British Columbia (Crown Corporation) – North Vancouver, Canada (Feb 2012 – Jan 2014 )

Worked as a developer on IMS DB2 CICS on SYSPlex and provide system support on CICS and DB2.

Provided multiple parallel SYSplexfor multiple parallel CICS DB2 Sysplex.

Developed IMS DB2 CICS programs for SYSplex and provide system support on CICS and DB2.

Amended PL/I programs for system to support CICS and DB2.

Worked as MQA and managed process improvements, determine business requirements and system

Managed Jira system and produced weekly reports to senior Manager and VP.

Worked a IMS DB2 developer on Simplex and provide system support on CICS and DB2 for multiplex.

Worked as MQ SME for MQ performance and Mainframe system and Mainframe programming.

Solutions Architect, Manager, Technical Lead and DB2 HSBC Bank (Apr 1998 – Aug 2012)

Worked as a DBA on Internet Banking, Mobile Banking, CICS DB2, GP Me2Me Payment.

Collected and documented user requirements. Designed and developed database architecture for information

Performed data analysis mapping and modeling. Collaborated cross functional teams to develop and document DB2 solution requirements

Worked as a Solution Architect on Proof of Concept (POC) on the following Web and internet projects: Mobile banking, GP Me2Me Payment, Gold Suite, Message Broker replacing in-house EAI.

Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data

Coordinated with Mainframe system programmers to resolve Mainframe issues.

Performed data analysis mapping and modeling. Collaborated cross functional teams to developed and documented solution requirements

Worked as a DBA for database upgrade, dropping and creating new tables for HSBC projects. Performed regular DB2 monitoring, backup, and table reorganization.

Worked as a MQ Expert on Chicago for 15 months.

Worked as a Subject Matter Expert (SME) on DBA role to trouble shooting database issues and build alternative index to fix the performance issues and provide solutions on dead lock issues.

Designed the logical and physical data models for HSBC projects. Collaborated cross functional teams to develop and document solution requirements, data modeling, data mapping specifications between the source systems data and the dimensional models.

Developed and amended PL/I programs for system to support CICS and DB2.

Maintained systems for keeping raw data, metadata and other data assets secure and accessible within the HSBC systems.

Performed design, development, integration, testing, troubleshooting, and implementation of Message Broker process flows, verified test results with testing tools SQL, crystal reporting, and log files.

Worked as information Architecture on storage networks and connectivity testing effectively and keep the tight project on schedule without any delay.

Setup, supported and managed development and DB2 environments for testers with automation tools that saved up to 30% in recourses and 20% in IBM mainframe project duration.

Managed enterprise environmentswith data backup, recovery, code deployment, inventory and access data authority.

Approved and defined projects storage usages, data retention, storage classes according to SDLC.

Worked on IBM FileNet, Records Management/IER.

Tuned up DASD performance by relocating data to different data packs to eliminate traffic jam.

Prepared, reviewed and presented test plans to senior management team and VP.

Produced weekly testing summary reports with HP QC and setup automation process with HP QTP.

Worked on MQ backup and restore and monitored MQ online performance.

Investigated defects and identified whether issues were caused by hardware or software problems. Used various testing tools as well as strong IT knowledge to narrow down the issues to save 40% in defects resolution time.

Worked on Cross EBC payment for SWIFT MT 103 message and MT 999 message.

Transformed data for migration in different forms like XLS/XML/database tables using Perl and Python.

Prepared, reviewed and presented test plans, test cases, and test scripts to IBM RQM system. Produced weekly testing summary reports with IBM RQM, managed defects and code drop schedule.

Managed a joint venture China Trade Project which was developed in China by a 3rd party. The new system had to be integrated into our existing banking system. Setup automation scripts for testing which could be run 24/7.Most testers and developers were located in China; however, team leaders and managers were in Canada.

Led Vancouver local team and off shore teams in China and India in identifying testing issues, implementing test procedures, processes improvements, defect resolutions and root causes analysis.

Designed and setup new DB2 tables for Hex systems including Schema, Primary Keys, and Foreign Keys. Verified DB2 database with SQL, crystal reporting, batch report and log files.

Contact this candidate