AS400 Experience Resource

Merwin Koshy

**** ****** ** *** • Union City • California • USA 94587 • Cell: +1-650-***-****,

acr9cm@r.postjobfree.com

Systems analyst, with 8+ years of IT experience in IBM System – I (AS400).

Has experience working in AS400 development projects in Retail and Insurance Domain

Presently working in San Francisco, California at Client location, holding a valid H1B Visa,

Technical Expertise -

Platform

:Iseries AS/400

Languages:

:RPGLE, SQLRPGLE, CLLE, CL, Service programs, embedded SQL, LANSA

Database:

:DB2/400

AS400 Tools

:Iseries Navigator, ALDON, MKS and Hawkeye

Professional Experience -

8+ years of experience in the IT industry

Currently working in Cognizant Technology Solution US Corps

Have experience working for Williams Sonoma Inc, COSTCO accounts.

Work Experience

Working in Cognizant Technology Solution from Jan-25-2010 to Present

Repositioned to California for the last two years as Systems Analyst at client location

Currently working as onsite lead and Developer for retail client on Order Management Systems

Worked in UST Global as Senior software engineer from March-08-2007 to Jan-20-2010

Earned note of appreciations from the client for excellence in work.

Was selected as a star performer in the both Cognizant and UST Global

Software methodologies:

Has worked extensively in projects based on water fall model and RUP model

Have been involved in different phases of a project Requirement gathering, Conceptual Design Phase, Creating solution design, Technical design, QA, UAT, Implementation in production

Key facets

Has a very strong coding exposure in SQLRPGLE, and embedded SQLs, including creating formal training program for Team members on writing efficient SQLs

Worked in the Insurance domain in the Motor Insurance, using Lansa and SQLRPGLE for a period of 3 and half years.

Good domain knowledge in retail, and specifically in Order management and care centre applications to handle customer orders

Well horned analytical skills with experience to approach a problem from different angles.

Excellent leadership skills in leading team at onsite, and offshore, and reaching out to Clients, Business partners to determine appropriate Solutions for different Business processes

Certifications taken:

IBM eServer i5 iSeries RPG ILE certified programmer

INS21 - Property and Liability Insurance Principles

Cognizant - Retail Domain

Duration: July-15-2013 to Present

Location: SFO California, USA

Account: Williams Sonoma Inc

Application Overview:

Order management system

The order management system (OMS) is on AS400 system. There are different channels to place and order such as the ECOM website, Phone order entry, Mail order entry.

The OMS systems receive the orders through the order entry channels. The Phone Order and mail order entries are directly on AS400. The Orders placed on ECOM is interfaced to OMS.

The orders once received in AS400 are processed by the “Editing” Jobs. These jobs check the orders for errors. If Errors are detected, the Order is pushed into the Interactive Editing queue.

Such orders are picked up by the order editor personnel, and the error is rectified.

After vetting the order, the orders are invoiced.

The Credits and Returns are also handled with the system

The different Systems that interact with AS400 and not limited to the below list are

1. Sterling - OMS

2. PKMS – Pick Ticket management

3. CHASE and ADS for Settlement processes during Invoice process

4. Carlson Fulfillment system

TIBCO and MOVEIT have been very much in use in the different Interactions with other non-AS400 Systems

Main Projects worked

Project - Tokenization

Currently the Client systems store Credit card number in the Encrypted format and are compliant with PCI. But since this process is adding cost in terms of PCI compliance, and also does not eliminate risk, the client is planning to remove Credit card details from the Client systems and store Tokens instead. For this it will have a third party Vendor where the Credit card will be send, and in turn receive a token for the credit card.

All processes like authorization settlement, search Customer details by credit card, issuing credits on returns, etc will have to be performed using this tokens.

-Prepared the impact assessment, Conceptual design, Solution Design, Technical Design and Development for the Changes

-Lead development along side resources on various teams both on site and offshore.

-Lead offshore team of ten resources single handedly.

-Managed the deliverables of ten resources.

-Prepared the architectural solution design for the project.

Project – Customer Visibility

Customer Visibility project dealt with Enhancing processes in and communication systems in OMS systems to keep the customer informed accurately and at appropriate times the different status or actions taken on the sales order. This included migrating the E-mails from the legacy system to Sterling, Giving a closer estimate of the delivery and Shipping dates, listing down notes for Care Centre folks to refer and speak to customers are required, communicating the parameters to E-Com web sites and Sterling OMS systems for better customer visibility on order status. This project had different phases over a year.

-Prepared the impact assessment, Conceptual design, Solution Design, Technical Design and Development for the Changes.

-Lead development along side resources on various teams both on site and offshore.

Other Projects worked on

-Loss Prevention

-Bad Debt

-Gift Registry

-Border Free Project

-OS Upgrade testing

Cognizant - Insurance Domain

Duration: Jan-25-2010 to July-12-2013

Location: India

Account: Travelers Insurance Inc.

Main Projects worked

Project – Reporting Forms

This project dealt with developing the system to generate Reporting form polices for transportation insurance. Reporting Forms unlike the normal policy would have the user Report the premium and Exposure on the coverage. Initially a policy would be issued with the estimated exposure and premium. Based on the User reported Exposure and premium for a month, monthly reports would be created in the system

The Front end is in Dot Net, while the Back end is in Iseries. All the processing and logic resides in the back-end and the requested information is sent back to the front end.

Made changes to the existing LANSA programs, being called for developing the reporting Forms.

Project Description - Binding Pricing Re-write

This Project involved in re-writing programs to accommodate dot net calls to backend (AS400) from 1.0 to 2.0. It involved studying the existing business and design, and designing new program with use of procedures and XML parsing.

It involved writing with new architecture design to modularize the code. I involved detailed analysis of the entire existing code and removing redundant logics in the existing pricing programs.

Other Projects worked on

worked on in Insurance

Domain

-D&B

-Accel Next Generation

-Employee Benefit Liability

-Maintenance and Enhancement of Application of transportation insurance application

UST Global - Retail Domain

Duration: March-08-2007 to Jan-20-2010

Location: India

Account: COSTCO

Main Projects worked

Project Description - SQL Proof of Concept (POC)

Around 1100 programs were earmarked has having bad SQL or what is called SQL anti-patterns. This was understood to have performance issue in the AS400 system. To study the issue and to come up with optimum solution was the objective of SQL POC project. Anti-patterns in RPG were identified as those code or logic which affects the performance of a system. The performance tuning of query was required to be performed.

Had experience in fine tuning, rewriting SQL query, and using tools like Iseries Navigator as aids in optimizing the performance of the SQLs. Used Iseries Navigator for performance Data Base (DB) monitoring and analyzing the obtained outputs.

Gained good understanding on anti-patterns like, logging of QTEMP table, Programmatic joins, using UDF’s, Difference between CQE and SQE, OPNQRYF, Do’s and Don’ts when writing an SQL. Also had firsthand experience in estimating the effort required, for rectifying 3148 anti-patterns spread over 1100 programs.

Project Description – Direct to warehouse ordering

This project is related to the automating processes such that, based on the forecast sales sheets, the system would auto generate the suggested buy. Other functionalities like, how much a truck has to be loaded, the delivery dates when multiple warehouses are involved and the related logistics were also automated to help the buyer buy efficiently for the warehouses. The complete testing of this system to catch defects and make it bug free, was the task.

Other Projects worked on

-Buying Enhancements

-Forecasting testing

-Testing Lawson ERP package

Academic qualifications -

B. Tech (Electronics and Communication Engineering)

2002-2006

SNMIMT (Affiliated to MG University, Kerala, India)

Secured an aggregate of 70.14%

12th (Higher Secondary School)

2000-2002

Wilson College Jr section, Chowpathy, Mumbai, India

Secured an aggregate of 76.67%

10th (Secondary School Certificate)

2000

St. Francis D`Assisi High School,

Borivali, Mumbai, India

Secured 82%

Contact this candidate