Frederick Lai

Experience

• 

  Kuehne+Nagel

  Feb 1994 - Jul 1994

  Job Placement

  - Maintain the Accounting System on AS400 using COBOL- Develop a Custom Order Tracking System using Clipper 5.2 on MS-DOS.

• 

  Lecco Systems Limtied

  Sept 1994 - Aug 1995

  Programmer

  - Liaison with business analysts to assess the customer’s requirement- Develop programs for Business Information Management System by using SQL Forms3.0, SQL ReportWriter, Pro*C, PL/SQL and SQL*Plus- Responsible for module and program testing- Implement and migrate the data of the old system for the clients.- Perform system tuning, support, and troubleshooting

• 

  Liu Chong Hing Bank Ltd

  Sept 1995 - Feb 1996

  Programmer

  - Liaison with user representatives to gather their requirements- Responsible for preparing program specifications, unit tests and fixing test plan- Develop a customer information module of a banking system by using JAM, SQL ReportWriter, and Pro*C.- Conduct the unit test, system test, site test and user acceptance test.- Responsible for preparing program specifications, unit tests and fix test plan- Perform system tuning

• 

  Advanced Systems Integration Limited

  Feb 1996 - Jan 1999

  Senior Analyst Programmer

  - Liaison with user representatives to gather their requirements - Responsible for preparing program specifications and unit test plan- Subcontract to Hong Kong Monetary Authority, responsible for system/design database, design, development, testing and training on Human Resources Management System provides managing employee information, benefits and training records.- Develop a Purchase Order System by using Oracle Forms 5.0 & Reports 3.0, and Oracle 8 for Swire Properties.- Develop a Business Information Management System using Oracle Forms 5.0 & Reports 3.0 and Oracle 8 for E.P.S.A Corporation Limited and Oriental Logistics Company Limited- Responsible for managing a team of two developers to re-engine the Securities Trading System for Vickers Ballas Hong Kong to support bilingual (English and Traditional Chinese) and migrate the existing RPT report into Pro-C, which resolved the un-supported issue of RPT.- Subcontract to Rating & Valuation Department, responsible for migration of the rates and government rent system from Oracle Forms 3.0 to Forms 4.5 and providing technical advice for migration problems to other contractors- Prepare and conduct for Y2K system test for the Fund and Unit Trust Management System in Citibank Asia Pacific Technology.- Subcontract to Citibank Asia Pacific Technology, responsible for development and maintenance of the Fund and Unit Trust Management System that provides the end of day batch processing to calculate the value of the unit trust. The system uses Oracle Forms as the front-end and Oracle Database as the back-end Show less

• 

  Airport Authority Hong Kong

  Jan 1999 - Jan 2023

  - Liaison with various departmental representatives and business partners for user requirement study- Source and evaluate options of solutions provided by vendors and make recommendations to users- Supervision external contractors such as DXC, IBM and Framework Agreement vendors to review contractor progress reports, monitor the statuses of outstanding system issues by implementing fixes or upgrades and the enhancement delivered that effectively address the users need- Monitor the 7 x 24 mission-critical airport systems to identify areas of possible enhancement; work with contractors for optimal solutions to stabilize the system- Planning, coordinating and conducting system activities such as site acceptance tests, fix tests, regression tests and production implementation to ensure the quality of the system- Work with IT sub-units, users and vendors to prepare the migration plan for the obsolete hardware and software- Support Airport Services Integration Platform, Web Content Management Platform, Enterprise Document Management, Live Chat Engine Services- Provides 7 x 24 application expertise to front-line support- Project planning, resource planning, schedule and budget monitoring- Participate in the tender process Show less - Act as team lead to manage various mobility projects, airport and corporate systems projects- Carrying out the data analysis on the information collected from the mobile app to understand the user experience and working with the system owner to plan the improvements.- Project planning, resource planning, schedule and budget monitoring- Liaison with various departmental representatives and business partners for user requirement study - Planning, coordinating and conducting system activities such as site acceptance test, fix test, regression test and production implementation to ensure the quality of the system- Participate in the various tender and procurement processes such as provision of display replacement, provision of a problem and incident management platform- Design the functionalities and features of the system to meet new business needs such as Upstream check-in manifest system and enterprise mobile app.- Supervision internal developers and FA vendors to review contractor progress reports and monitor the status of outstanding system issues by implementing fixes or upgrades and the enhancements delivered that effectively address the users' need- Support Flight Information Display System (FIDS), Terminal Integrated Management Enterprise System, Frequency Visitor Channel, Compliant/Enquiry/Feedback System, Friend of Airport website, Drawing Registration System, Web Content Management Platform, Service Standard Information System, Enterprise Mobile App and public app, My Flight- Monitor the 7 x 24 mission-critical airport systems to identify areas of possible enhancement; work with contractor for optimal solutions to stabilize the system Show less - Involve Baggage Reconciliation System Project from Ultra to SITA and enable the support of RFID- Support Baggage Reconciliation System, Web Based Flight Information Display System, Baggage Message Gateway, Air-to-Sea Gateway, Universal Display System, Pier Information Management System- Gather user requirements from the airport operation team and HKIA baggage handling group- Manage SITA to deliver the enhancement- Carry out onsite User Acceptance Test, Production Test and production launch- Provide 7 x 24 support to the IT operation team- Problem Troubleshooting Show less

  • Manager, (Application Infrastructure)

    Apr 2020 - Jan 2023

  • Assistant Manager (Mobility and Analytics)

    Apr 2010 - Mar 2020

  • Senior System Analyst

    Apr 2005 - Mar 2010

  • IT Systems Officer

    Apr 2001 - Mar 2005

  • Assistant Software Officer

    Jan 1999 - Mar 2001
• 

  Avensys Consulting

  Oct 2023 - Dec 2023

  System Architect

  Second to DXC Singapore on the high-level system requirements and architecture design review of the systems operating in Changi Airport in T5