AS400 and Trade Transformations

PERIYASAMY SINGARAVEL SINGA

AS*** – Application Analyst,

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

+65 9897 7452

Skill’s

AS400, OS400

DB2/400, Query/400

RPGLE, RPGILE

COBOL/400

CLLE/400, SQL/400

Sub Files, Printer Files

Data Queue, Journal

MQ Series, XML

TAMIC Tool

DSP, MBASE Handler

FTP, SFTP

ALDON, THENON

Business Skills

Core Banking:-

LOAN, NPL, COLLATERAL.

DEPOSIT, BWCIF

Retail System:-

Purchase Order, Data Warehouse

Merchandise System.

Trade:-

Banker Guarantee, SBLC.

Trackers

HP Service Manager, Jira

Confluence, Share Folder

System I-Navigator, Winscp,

Agile, SDLC.

Personnel Details

DOB 01-09-1992

Gender Male/Single

Passport No Z4469190

Nationality Indian

Language English

Notice Period *Immed

B.Engg (CSE) Anna University, India. 2010-2014

CAREER SUMMARY (10 Years)

Lead the experience with development & Production Support at IBM I- Series of DB2/400, RPGLE, SDA, RLU, COBOL, XML, Data Queue, etc…

Working on Trade Transformation migration project of M25 + Strategic Program plan of BG and SBLC products.

Meeting with business team and vendor to discuss the scope of Trade transformation and match existing business to vendor application.

Good understanding of how technology relates to business and applies such knowledge to support the needs of the business.

Strong workflow and data flow analysis skills, and ability to acquire a working knowledge of departmental operations are required.

Robotic Job scheduler, Batch/Interactive Support, Analysis the Spool files, Migration, System performance, DR activates and PTF install.

Preparing CAB document of the implementation planning to deploy the objects into production environment.

QuessCorp – MAYBANK - Singapore

May 2022 to Till

Working on FITAS Trade Transformation project and BAU support.

Implementing on Strategy planning of Trade Transformation project + M25 and decommission the existing FITAS business.

Understand the current flow of Trade business and verify the vendor application. Vendor needs to be add business logic if any requires.

Trade Transformation interface application such as BWCIF, SIBS, Watch list, Kondor+ and Data warehouse with help of ESB/MQ services.

Supported on configuration such as Security setup of users, Static data, System Tailoring and parameter setup.

HCL Technology – OCBC - Malaysia

May 2018 to Apr 2022

Supported on SilverLake system as Core Banking (SIBS).

Assisted with SilverLake to introduce a new Loan product type and tested products end to end as scrum methodology.

Find the probability of the NPL buckets by using SilverLake system.

Developed the code fetching flat file one system to other system.

Developed patch program to resolve the abnormal/reverted transaction and it should be sync with today’s batch file to process.

Supported vendors such as Orange Gum, PWC, and Fuji Xerox. Island Pacific Retail Systems – India

Mar 2014 to Mar 2018

A Software Developer Various levels such as L1, L2, and L3.

Build the Price Look up and sales audit module based on Registers.

Leaded the Warehouse and Web Store team.

Designed and developed of Retail & Inventory Management, Pricing & Promotions, Merchandising & GL logs modules.

Retail Based on Item, Facility hierarchy and Prepack, Item Set, Stock, Allocation PO etc.

PROFESSIONAL EXPERIENCE

Project #1:

Client : MayBank

Project : FITAS Loan & Trade Transformation.

Period : May 2022 to till.

Environment : AS400 (THENON, CLLE, DB2/400, COBOL/400). Project Summary:

The Trade Transformation Project is a key regional initiative for M25 + Strategic Program. FITAS and new Finastra solution (Fusion Trade Innovation) will run concurrently post-cut over until outstanding transactions settled in FITAS.

Undertakings provide security to beneficiaries in the form of a promise by the issuing bank on behalf of the applicant to reimburse the beneficiary for the amount of the standby/guarantee if the applicant defaults. Undertakings are normally subject to the laws and customs of the country of issue. A bank may therefore request a counter undertaking when dealing with a bank in another country. In this case, the issuing bank provides a counter indemnity to the overseas bank to cover the liability incurred by them. Project #2:

Client : Oversea-Chinese Banking Corporation (OCBC) Project : SIBS – SilverLake Core Banking

Period : May 2018 to Apr 2022.

Environment : AS400 (CL, DB2/400, RPGLE, COBOL, SQL/400, QRY/400, ALDON). Project Summary:

The SIBS system is using Silver-lake product which is covered end to end core banking. The system is based on parameter setup to process the loan module and support to communicate MBASE and DSP handler’s application such as SOA, EDW, IB, GL. The SIBS system is a centralized back-end system designed to process and support transactions. The main banking system has all the processes including deposits, loan and loan processing and ATM operations. A non-performing loan (NPL) is a loan that the borrower defaults on because they have not made the payments for a specified period of time. The time period varies depending on the industry and the type of Product settings. The calculation is on loan formulas based on Product type. Project #3:

Client : Primark.

Project : Merchandise Retail.

Period : June 2014 to Apr 2018.

Environment : AS400 (CL, DB2/400, RPGLE, SQL/400, QRY/400). Project Summary:

Primark would like to setup a module to export the orders to the third party called SoftCo from the IPMS produ cts. A new interface is required to send all GRN details to SoftCo. This will be an incremental file so a GRN will be sent o nce and once only to SoftCo. This file will include all GRN details whether or not a pre- receipt existed prior to the GRN. The originof this data will be the IP Receiving Module. When goods are received into I P the system allocates a unique receipt number. It is this number which will be used to determine whether a receipt ha s been sent to SoftCo or not. The implication of this is that once a receipt has been sent it will never be sent again. PRODUCTION SUPPORT ON AS400

Work on Production issues and defects to provide timely diagnostics, recommendations and resolution.

Experience with Data restoration whenever user requires or Due to tracking of issues/bug.

Creates and maintains complete documentation relative to support for all applications.

Monitor Production environments and batch job runs and Job Scheduling.

Understand the processing for a client, the underlying business rules and apply them to detect. DECLARATION

I hereby declare that the above written all statements are true to the best of my knowledge and brief. Place: Singapore Signature,

Date: (Periyasamy Singaravel Singa)

Contact this candidate