Steven Lai

Steven Lai Email and Phone Number

Software Development Engineer at ANZ @ 汇丰
london, greater london, united kingdom
Steven Lai's Location
Chengdu, Sichuan, China, China
About Steven Lai

I am an experienced Software Engineer with 10 years working in the financial industry. Skilled in Mainframe, GCP, Unix, Oracle&DB2, Data Warehousing Mechanism. Strong engineering professional with a Bachelor's degree focused in Computer Software Engineering from Chengdu University of Information Technology.

Steven Lai's Current Company Details
汇丰

汇丰

View
Software Development Engineer at ANZ
london, greater london, united kingdom
Website:
hsbc.com
Employees:
192615
Steven Lai Work Experience Details
  • 汇丰
    Consulant Specialist
    汇丰 Sep 2021 - Present
    西安地区
    负责在GCP上分析数据以监控交易的合规性,完成application从on-prem到GCP的迁移,搭建并优化infra,持续改进Jenkins pipeline已提高DevOps覆盖,有效地缩短了产品迭代周期。
  • Anz
    Software Development Engineer
    Anz Apr 2018 - Aug 2021
    Chengdu
    GIW-EBDI participate in EBD team to create the next generation ANZ Data Ecosystem based on the Big Data platform. As a engineer I majorly focus on the development and testing work to meet the each sprint goals.Skills:Java, Spark, Hadoop, Hive, Hbase, Flume, Kafka, Zookeeper, Impala, Kudu, Python and Spring boot
  • Anz
    Software Development Engineer
    Anz Jul 2016 - Mar 2018
    Chengdu, Sichuan, China
    ANZ-ECDMECDM is viewed as platform that sources, stores and then manages significant volumes of data for analytical and reporting purposes. The data is managed across technology and business controlled domains. ECDM functionality covers a number of capabilities including analytics, reporting and operational support. Responsibility:1, Works on data quality maintenance to complete GIW data extraction and transformation ,then landing the data into ECDM. 2, Tuning SQL performance.3, Delivery Change Order according to ANZ SDLC standards.Skills:PL/SQL, Shell, SAS, ORACLE, Control-M
  • Anz
    Software Developer
    Anz Dec 2014 - Jun 2016
    ANZ-GIWDescription:GIW is ANZ's central repository of business information for retail, commercial, Institutional customers and group functions, it is a mainframe centric application warehousing data from operational source systems covering multiple geographies(AUS, NZ and APEA), GIW provides a wide range of applications supporting business strategic reporting like operational functions, etc..Responsibility:Be responsible to provide technical end to end service to business customer including production issue fixed. delivery change order(requirement analysis, code build, UT, SIT/UAT support and get implemented in the production). Skills:COBOL, Easytrieve, DB2, JCL, CA7,
  • Git
    Software Engineer
    Git Nov 2013 - Nov 2014
    Chengdu, Sichuan, China
    CCB-NCIMDescription:The project starts from designing the new system. ECIF, enterprise customer information system, the project designed migrate the old system based on SQL Server to one based on DB2. To load customers’ info into ECIF database is mainly target of the project.Responsibility:a. Do analyst about interface from source-system, design the C model and D model.b. Design the frame-work programs.c. Take responsibility of data migration.Tech Skills:DB2 Erwin REXX Control-M.
  • Ncs Group
    Consultant
    Ncs Group Nov 2011 - Nov 2013
    Chengdu, Sichuan, China
    CPF-MSODescription:a. Enhancement for LIFE system include improve the performance of LIFE ENGINE and process of policy insurance.b. Create the job set to audit payment process. verify payment revise and account structure.c. Amend the Online grogram to follow new requirement.Responsibility:a. Create program spec. Doing SIT, UAT as coordinator. Take charge of implement.b. Process system analyses. draft DRS.c. Full time response for system.Tech SkillsCOBOL/Easytrieve, DB2, CICS, JCL
  • The Bank Of East Asia, Limited
    Software Development Engineer
    The Bank Of East Asia, Limited Oct 2010 - Nov 2011
    Shenzhen, Guangdong, China
    BEA-IFPDescription:The Bank of East Asia, Limited (“BEA”), being a financial intermediary, receives funds from deposit customers and other third parties, and subsequently invests these funds in loans and investments to loan customers and other third parties. The interest payments on these funds collected and invested contribute to the Bank’s overall net interest margin, which is the difference between interest revenue earned on funds used to acquire assets less the interest expense on funds gathered.Within BEA, funds are received through business units (“BUs”) like branches, and are invested through different BUs like various loans departments. Through the participation of these BUs in the continuous funds intermediation process, the net interest margin is created. However, the contribution to the net interest margin is not equal by all participants. The discrete contributions of funds transformed within the intermediation process must be measured and assigned for assessing the overall profit contribution of each BU. This is the function of the internal fund transfer pricing mechanism.The objective of this project is to implement the new fund transfer pricing mechanism and automate the calculation under this mechanism.Responsibility:My responsibility on this project is similar with BRE majorly take charge of development work from preparing design document to get project implemented.Tech Skills:COBOL,CICS, DB2, VSAM
  • The Bank Of East Asia, Limited
    Software Development Engineer
    The Bank Of East Asia, Limited Jul 2010 - Sep 2010
    Shenzhen, Guangdong, China
    BEA-BREDescription:In order to save the manpower and improve the operations efficiency of the bank reconciliation process, Internal Audit Department has made a request to EDP Department to computerize the bank reconciliation of nostro accounts (in respect of S.W.I.F.T. agents) in a more efficient and effective way. Thus, a new system namely Bank Reconciliation System (BRE) will be developed to perform the primary reconciliation work which includes :a) daily collect the S.W.I.F.T. statements from MERVA system and keep them in computer file for later processingb) daily collect the in-house accounting records from MSA system and keep them in computer file for later processingc) On the Reconciliation Day of every month (see note), perform auto reconciliation of the items appeared in the last work month and generate computer reports which will be delivered to the Internal Audit Department for further processing on the next working day.Responsibility:Take responsible on the job involve document external design of the proposed system, prepare the project estimation, completed in large scale project development according to project plan.Tech Skills:COBOL,CICS,VSAM(Tools)ES9000(Hardware)
  • Ncs Group
    Software Engineer
    Ncs Group May 2009 - May 2010
    Chengdu, Sichuan, China
    CPF-CCGDescription:the CCG client is CPF, Center Provide Foundation in Singapore. NCSI Chengdu department took charge with developing in this project to carry out upgrade of CPF system, so why need to upgrade CPF system? Just since all CPF members are required to put aside the minimum sum at age 55 for their retirement needs, but when they retirement many members may run out of income support while still alive. The new system can provide participants with an income for as long as they live through CPF-LIFE model. New national lifelong income scheme called CPF-LIFE. At initialization of project, we checkup requirement created by PM in order to comprehend absolutely function of system model. then we completed both system design and detail design after test department in Singapore confirm our requirement analysis document. and preside over developing and UT for CPF-LIFE model. Besides that, we took charge of maintenance for CPF-BOUNS model that include updated IDMS database to DB2 accord with CWT frame, and took control of system menu by CAF frame.Responsibility:a. to be familiar with flow of business well.b. taken responsibility on developing CPF-LIFE model, batch and online.c. taken responsibility on maintenance CPF-BOUNS model base on CWT frame.Tech Skills:COBOL,CICS,DB2,EZTP(Tools)IBM-370(Hardware)
  • Ncs Group
    Software Engineer
    Ncs Group Jul 2008 - Apr 2009
    Chengdu, Sichuan, China
    CPF-ITRDescription:The purpose to this project that update the old system datebase I2DMS to one base on DB,NCSI ChengDu brach took responsibility with testing, At beginning of project,PM workingoutthe requirement analyse through communicatinng with client.then some content that ambiguity or unable to get target will be checkup by developer and tester. PM summarized opinion from developer,tester and client in order to create project schedul. followed by our tester validate requirement analysis and establish test case,meanwhile the system design and detail design processed on developer, those two documents supply test case. After that, we constructed test environment. the first edition that may be has some undeveloped model released from developer. We tested it, debug and write test report, then deliver to develop again. The second edition released from developer, that has new model and bug solved. we completed test as the first time. Repeat above process until bug count reducing to production standard. We would assist to recur bug and afresh test if client had any problem.Responsibility:Create test case for each program. make sure that test result must be the same with expected and using online debug tool, DTCN and CEDF to check every CICS routine if necessary.Skills:COBOL/Easytrieve , DB2, JCL, CICS

Steven Lai Education Details

Frequently Asked Questions about Steven Lai

What company does Steven Lai work for?

Steven Lai works for 汇丰

What is Steven Lai's role at the current company?

Steven Lai's current role is Software Development Engineer at ANZ.

What schools did Steven Lai attend?

Steven Lai attended Chengdu University Of Information Technology.

Who are Steven Lai's colleagues?

Steven Lai's colleagues are P Gyaneshwar Chary, Maricel Canor, Jags Vallandas, Marcela Zhang, Chester Ken Palaganas, Hoda Mohamed, Zoë Thirlwell.

Not the Steven Lai you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.