In-House Hong Kong

RESUME

Personal Details

Name : Shum Po Cheung

Sex : Male

Address : */*, **** *, ******** Building, 34 Victory Avenue, Homantin, Kowloon, Hong Kong

Contact No : 92224489 (Mobile)

E-mail address : *****@**********.***

Academic Qualification

Master of Science in Mathematics in Finance and Actuarial Science – The University of Paris-Dauphine - 2007-2009

In-house exposure

Aug 2024 to Sep 2025 (restructure plan)

Assistant IT Supervisor ETS-TestConsult Ltd

In-house developing and implementing live ERP application (Invoice/HR/Quotation Issuance-Report generation/Work Instruction-Order) hosted on intranet, written by Visual Basic/ C# based upon the debugger of Visual Studio 2019/2012, with certain minor POC developed to be deployable by Sharpdevelop/Monodevelop IDEs in cross-platform states. API modules maintainable with embedded features as well as by self-developed Stored Procedures frequently tuned up with internal users new requirements. Application Support for existing production mainly from data perspective, imported/ingested by tools like not only SSIS on SSDT, with further extended usage working on constructing ETL POC and Crystal report generation under UAT environment. Adding a few SSAS developing applications on SSDT 2015 for testing data as a QA platform. Both data or ERP are version-controlled on Gitea

Infrastructure task: cross-platform test installation of Hadoop/Hive/Spark. Simple trial for typical map-reduce example.

Agency/temp contracts with Secondment exposure (TEMPORARY IN NATURE – QA exposure fundamentally)

Apr 2024 to July 2024

QA Tester Kinetix Systems Limited secondment to Hong Kong Insurance Authority

Projects/Duties

•Automated QA duties: utilising Apache JMeter for doing performance testing on the platform of Insurance Portal, by development of jmeter native scripts through both recording and correlation of parameters reusing from one request to subsequent request. Concurrent Thread Groups are set up for random data parameters from both submitters and approvers. Proactively seeking knowledge reference regarding to testing of API in order to import Swagger API definition file into Katalon/Apifox. Follow up Load Test Plan from time to time.

•Manual testing: working among QA teammates to follow/edit Redmine issue logs for both Admin Portal and Insurer Portal as requested by the Lead.

Nov 2023 to Mar 2024

Senior Analyst II - Software Engineering DXC Technology Enterprise Ltd

Projects/Duties

•Websites/Web server Load Testing using testing tool Apache JMeter for developing and developed use cases (with a certain research coverage on evaluating another http archiving tool, eg Fiddler)

•Automation on Jenkins pipeline written by Ant scripts for running JMeter load tests both from a standalone machine or remote slave server to achieve distributed testing so that frontend and backend testing are jointly managed in DevOps and agile methodology

May 2023 to Oct 2023

System Analyst DBS Bank s/b Robert Walters (HK) Ltd T&O team – Overnight patches coordination and execution with Infrastructure/Network teams under Configuration Management Best Practice

Semi-Permanent position (global Indian SI) (TEMPORARY IN NATURE – 24*7 exposure fundamentally)

Feb 2022 to Mar 2023

I.T. Analyst (Analyst Programmer – Data Engineering) Tata Consultancy Services Limited (seconded to Cigna International Group) - employed as a successor for primary 24*7 support, but upon being acquired by another Insurer

Production Support: troubleshooting on a 24*7 basis for CDC service on IBM Data Replication Management Console, importing message streaming from Kafka on Linux server-AS400)/DSR(SSIS server on Windows server).

Data integration and migration: liase with Software Architect to provide data ingestion and integration in Data Warehouse/Data Lake on cohort-based population for IFRS17 project: following scheduled timeline with tuning needs come from each regular meeitng with BAUs (which maintain and deploy own data marts for example using Workiva), utimately manually executing data pipelines on Talend Data Integrator with TAC.

Infrastructure team tasks: implementating yamls and python scripts for ServiceNow Ticketing system and executing/deploy pipelines on Redhat Openshift/Azure DevOps(CI/CD) in order to release to production state.

Jan 2021 to Feb 2022

Analyst Programmer Vtech Corporate Services Ltd

Data Warehouse responsibility: ETL job maintenance for mostly divisional or functional reports/snapshots generation and support by designed alert schedules on the platform of in-house app with technology provided by Oracle Datawarehouse/Talend Data Integration Studio;

Business Intelligence tasks: Marketing/sales/financial management reports by pivot analysis based on engineered tables developed through ETL/PLSQL coded in data warehouse or live queries; further enhancement or complication imposed by excel macro with VBA, in order to compose automated function designed and tested for fulfilment of particular static pivot table snapshot requested by management users.

Uploaded template design and built for storing live queries with the in-house app.

Product development and support guide documentation.

User portfolio interaction and requirement elicitation.

SQL Performance Tuning workout with DBAs.

June 2019 to Jul 2020

Senior Associate (Full-stack Developer) Hong Kong Mortgage Corporation

Projects/Duties

•Key Technology: backend->J2EE, Struts Framework, Oracle PLSQL stored procedures/packages/triggers/functions; front-end->Javascript, Jquery, Html5, CSS

•Line responsibilities: With founded flexibility on full stack experience gained through applications developed for initial CR building loan repayment schedule in infrastructure finance and securitisation division, I work for related enhancement projects to drive the user deployment on tailored-made products provided to financial institutions.

•The enhancement is about signing off certain approver-triggered dayend process by re-engineering limited source code changes first of all. By then, implementation support on online approval provided to user communicating in terms of stored procedure (i.e. for calculating fields according to various sets of conditions) on Oracle over the re-engineered web platform developed using Java and Struts framework. In general terms, it is accomplished by: 1) Regular troubleshooting over transition versions controlling on my newly developed features during UAT before production launched; 2) In-depth fine-tuning functions and packages script both from the perspective of approver and that of maker and 3) Continuous improvement in line with version control system regularly to comply with business rules elicited with user during UAT phase.

•Jasperreports BI application development on OracleDb about Aging schedule before publishing and progressively pushing online mode, making use of stored procedure call, subdataset, crosstab and table filter features.

•Proof-of-concept prototype application testing with Nodejs, Django web and Angular

July 2016 to Mar 2019 (Government Contract T24..26 related exposure)

Senior Analyst Programmer Chong Hing Bank limited s/b Robert Walters (HK) Ltd

Projects/Duties

•Key Technology: Linux shell scripting; Oracle SQL/Pro*C; Websphere Application server administration

•Line responsibilities: With Linux servers Oracle database is free to connect for the testing and development of modern products (i.e. Trade Finance/Bills of Lading) in order to compromise with client’s user team implementations. Wholly join testing team for supporting deployment onto SIT, UAT and QA servers, by coordinating with spectacular financial software vender.

•Interim implementation on legacy client software written in C/C++ compiler and subsequently utilizing Pro*C to code for request and respond in between new testing solutions and Linux server, and enhancing extraction and loading of both structured and unstructured data.

•Data massage and manipulation on migration project by stored procedures in Oracle PL/SQL/MongoDB/Libreoffice Calc/JDBC on weblogic

Senior Programmer to Analyst Programmer Computer and Technologies (Hong Kong) Holding limited – Water Bureau

•Key Technology: Power BI; Spring framework; Oracle PLSQL; Weblogic Application server configuration

•Line responsibilities: Work as contractor providing IT application support and user requirement eliciting for revamp project on Water Department generally

•Benefited by adequate infrastructure with client its corresponding Oracle database is free to connect for the testing and development of Spring MVC application secured by Spring Security using an Ldap authentication in order to compromise with client’s user team implementations.

•Business Process implementation with regular discussion notes supporting and subsequently turning into UML preparation for building solutions

•Proof-of-concept models development for demonstration purpose utilising J2EE frameworks/javascript/jquery/html5/jsp/java on application server Weblogic/Tomcat

•Data management and manipulation from web via Power Query/BI with further exploration on OBIEE/ODI on Oracle Solaris 11

•Data conversion project involvement on producing new mapping for transition using Power Query, SQL and PL/SQL in accord with certain metadata provided by Oracle, to act along with ETL methodology

•Manipulating data under Excel Object Model via VBA importing tables from Oracle database.

•

Programmer Infotech Services Limted – Education Department Bureau

•Key Technology: Web framework; MSSQL; Apache Tomcat Application server configuration

•Project routines ~ Application development supporting to financial budgeting users mainly with huge data reporting needs primarily on web server on Windows in order for our team to plug it into three-tier approach utilizing both open source application server closely adhered to Java EE on IDEs like NetBeans, and MSSQL to allow rooms for further layers to be deployed therewith. Continuously fine-tuning developing projects on SSRS under business logic according to documented functional requirements with corresponding configurations. Primary programing languages written are Java and SQL.

•Potential changes contemplating with System Analyst ~ considering probable changes around more advanced UIs (e.g. JSF2) and backend tools (e.g. Hibernate/JPA) to well-equip ourselves in order to prepare for likely changes on functional requirements according to maintained flexibility gained through flexible environment offered. Testing functionality of the prospective environment consisted of agreed UIs and backend tools vigorously through integrated examples reflecting practical scenarios. Interim solution would be an expected integration among Spring MVC and JPA(with eclipselink) after trying out a spectrum of possible components mix through unit and integration testing with well-selected samples. Utilizing Maven/Gradle/Git on Eclipse to build model and exert versioning control being focused on comparing with previous versions respectively.

Institutional temp experience (Research exposure)

November 2013 to July 2016 (Contracts end)

Research Assistant The Hong Kong Polytechnic University – Department of Accounting and Finance

Research Assistant The Chinese University of Hong Kong – Institute of Digestive Disease

Research Assistant The Hong Kong University of Science and Technology

Professional Qualification

Progression in Graduate Diploma in Statistics (Paper I & II)

Course P, FM of SOA Exam

Relevant skills

Language Skills : Cantonese, English, Putonghua

Computer Skills : Programming lang-STATA, .Net/C#, MATLAB, Perl, Scala, Python, Java; Automation tool-VBA; Infrastructure tools-Docker for VM combo, Git(e.g fetch/log/status/add/commit/push), J2EE Framework-Struts/Spring, JPA; Databasing-MySQL/OracleDatabase/Access/MSSQL; Integration Tool-Eclipse, TOAD, Intellij; Front-end stack-Javascript, Node.js; Middleware-Webspere\Weblogic configuration

Typing Speed : 30wpm

Referees

Dr. Martin C.S.Wong – Associate Professor – School of Public Health and Primary Care, The Chinese University of Hong Kong

*************@*****.***.**

Dr. Leung Wing-Yin – Assistant Professor - School of Accounting and Finance of The Hong Kong Polytechnic University

*******.*****@*****.***.**

Contact this candidate