Title

Mainframe/AS400 System Analyst

Client

Confidential

Period

Confidential

Project Background

• TARABS Tata Accounts Receivable and Billing System is a proprietary TCS insurance billing product that caters to the requirements of small and large Insurance companies.
• The project involves the requirement gathering, analysis, design, development and testing of customizations to TARABS, installed in client, a primary medical professional liability insurer, to cater to its billing needs.
• TARABS has both direct billing and Agency billing functionality. The product has been in production since 1991.
• The client had the product installed in April 2004.
• TARABS, a DB2 based system, runs on Mainframe using CICS, for the current client the product is ported to AS400 and the presentation layer is web enabled.

Technical Details

Hardware

IBM 3090, Z10EC, AS/400

Operating System

OS 3090, Z/OS, WINDOWS, OS/400, UNIX

Language

COBOL II, REXX, CLIST, Java, JSP, C, RPGLLE, JCL, CL, Shell Scripts

Special Software/ Techniques

DB2, TSO/ISPF, CASEPAC, Mastercraft GUIMOD, CICS, WebSphere MQ, Oracle BEA Weblogic, Perl, Oracle, TIBCO, Sun One, REVINE, INFREX, CONSULT, JBOSS, SYNCQUANTO, Micro Focus COBOL, Kleopatra, GPG

Certification and Important Trainings

Technical

IBM DB2 UDP V 7.1

Domain

AINS INS 21 Property and Liability Insurance Principles

Project/Quality Management

Project Management E1 Competency, Internal Auditors Training

Special projects and skills

Billing, Accounting/Finance and Collections

Confidential

Working on TARABS for the 7 years has added to my domain knowledge on the Billing, Accounting/Finance and collection business process and makes me a Subject Matter Expert SME on billing solutions. Unlike a service, working for this product needs an end to end understanding, its architecture and it life cycle and experience in TARABS has provided me an opportunity to explore the billing domain.

Special projects and skills

Confidential

Confidential

Having product and the business knowledge, TCS decided to modernize TARABS to newer platform and re-engineer the product to cater to the current trends. Have headed the project to prove this concept.

As a technical lead, have had the opportunity to work with multiple teams and technology/domain specialist to identify different architecture, tools and techniques available to achieve the same and a realistic estimate.

Special projects and skills

Project Management Auditing

Confidential

Worked as a project leader from June'08 to Feb'13 and was made familiar with project management activities.

This allowed me to understand the emphasis of the quality management process in a distributed organization like TCS. Trained extensively on the TCS iQMS system on the various process of ISO Triple ISO , CMMI, PCMM, PMP, TBEM, Agile methodology and Six Sigma .Attended various seminars, workshops, events etc. to bring best practices into TARABS project.

Internal Auditor and Information Security Auditor. Have been a part of internal audits for various projects to assess the quality process and the information security process. Received an award as the Best Auditor in Oct'10.

In addition, acted as the Crisis Management leader CML June'08 to Feb'13 , Information Security coordinator ISC June'08 to Feb'13 , Knowledge Champion June'08 to Nov'11 , Defect Prevention Prime DP Prime June 07 to Nov'11 .

Special projects and skills

Interfacing a Legacy system to Web Portal for the Insured

Confidential

The insurance client wanted to provide an option to the Insured to pay their bills via their web-site. Have worked on the project to interface TARABS with the Web-Portal.

During the first phase the client made the single payment option available via the Web-Site for the insured. Headed the offshore team for backend process.

During the second phase the client wanted to make the Auto Payment available for the insured. Headed the onsite team during this phase.

Special projects and skills

ACH-EFT Recurring Payments for a Legacy System

Confidential

TARABS being a Legacy system, in many proposals a gap identified that TARABS doesn't provide an option of ACH-EFT Payments. I headed a project from the offshore to interface and TARABS to JP Morgan Chase PayConnexion, so that the client's Insured could make payment using Credit cards or bank account through PayConnexion admin channel.

Phase 2 of the project is to make Auto-Payments available via Pay Connexion. For that TARABS was enhanced to communicate the bill details to the Pay Connexion such that the payment can be automatically deducted. I have headed this project from offshore.

Special projects and skills

Installation of the Product to Z10 Mainframe system:

Confidential

In 2008, TCS purchased new Z10 EC Mainframe system. Have headed a project from TARABS side to migrate the TARABS project from IBM z3090 to IBM Z10EC. Now we have installed and configured and made the product to work on the z10EC system from scratch.

Special projects and skills

Websphere MQ Installation

Confidential

In 2012, one of the TARABS customers wanted to have the Web-Front End version of the TARABS to be interfaced to their backend. For this I have worked from offshore on a project to interface the Frond-End Web to the Backend Mainframe via middle ware IBM Websphere MQ.

Special projects and skills

TIBCO messaging from RVRD to JMS:

Confidential

In 2013 the client decided to buy a new AS400 System running on V7R1M0. The existing TIBCO messaging service RVRD is not supported in the V7R1M0 system. So client decided that all the TIBCO RVRD messaging to be moved to the TIBCO JMS. From TARABS side, have worked on a project in onsite to move the TARABS middleware TIBCO from TIBCO RVRD to TIBCO JMS messaging service.

Special projects and skills

Encrypt/Decrypt the feeds in/out of the system

Confidential

TARABS being a billing product all the payment were handled by TARABS. For the client TARABS is interfaced with the Chase Bank and Chase bank communicates the payment details to the TARABS. Since this is a sensitive data which is transferred via Internet, Chase Bank made a mandatory rule that all the communication happens to/from the external system to be encrypted. Headed a project to encrypt and decrypt the feeds in and out of TARABS.

Special projects and skills

Installation of TARABS on different Webserver

Confidential

TARABS being a billing product with Web Front end, for one of a TARABS client I have worked on a project to port the web components on JBOSS web server and for another client on IBM WebSphere Application Server.