CV/Mission IDMS freelance

Summary of Experience

8 Year’s experience with Tata Consultancy Services
Skills Profile

Operating System
Software Products
Tools

Windows NT, XP
UNIX
MVS

C & C Oracle
CICS
IMS DC
IMS DB
DB2
HDAM
BDAM
VSAM
SPUFI
ASSEMBLER
COBOL
IDMS

Quality center
Data Manager
Easytrieve
Data Xpert
Inter Test
Expediter
File AID

Career Profile

Client Name: VISA

Start Date: Mar 2007 End Date: Jan 2008

Project #1: VISA

The scope of the project is to make changes in the clearing and settlement system according to the requirements of the European region, which in turn depends on the requirements of the members. This project involves making modifications to VISA’s Real-time Settlement Interface Application (RSI) to cater to the regional business requirements of Visa Europe (VE).

Role performed: Project Manager and Onsite coordinator (Level I & II certified Developer)

Tasks Performed:

Project Planning & Tracking, Client Liaison
Functional & Technical coordination
Interaction with customer on understanding their business goals & objectives
Involved in review process for the Deliverables

Client Name: GE HealthCare, France

Start Date: Oct 2006 End Date: Jan 2007

Project #1: Oracle-MUST

Master data of GE health care is stored in Oracle/Mainframe database. The source system is Oracle and the target system is in Mainframes. This project is to fix disconnects between oracle databases and the mainframe systems.

Role performed: Project Manager and Onsite coordinator

Tasks Performed:

Functional analysis of source systems
Project Planning & Tracking, Client Liaison
Functional & Technical coordination (All the teams – US/UK/France/India)
Interaction with customer on understanding their business goals & objectives
Involved in review process for the Deliverables

Client Name: AXA Corporate Solutions, Chennai

Start Date: May 2005 End Date: Sep 2005

Project #2: Genius Aviation Migration

This is a data migration project, migrating data related to aviation policies in AXA Corporate Solutions (AXA-CS). Source data is present in MVS mainframes (DB2 tables & VSAM files) and also in MS Applications (MS-Access). Scope of the project is to build business transformations rules between source and target systems and apply them to source data and generate flat files (containing transformed data) in a form/layout as required by Genius, which a third part product supplied by Xchanging. This product is customized according to the flexibility and need of client. GENIUS is supported by DB2 400 database

Role performed: Project Manager and Developer

Tasks Performed:

Functional analysis of source systems
Project Planning & Tracking, Client Liaison
Functional & Technical coordination
Causal analysis for production bugs occurring after service delivery
Involved in review process for the Deliverables
Coordination of Unit and System testing

Client Name: AXA Corporate Solutions, France

Start Date: Jan 2005 End Date: May 2005

Project #3: Genius Aviation Migration

This is a data migration project, migrating data related to aviation policies in AXA Corporate Solutions (AXA-CS). Source data is present in MVS mainframes (DB2 tables & VSAM files) and also in MS Applications (MS-Access). Scope of the project is to build business transformations rules between source and target systems and apply them to source data and generate flat files (containing transformed data) in a form/layout as required by Genius, which is a third part product supplied by Xchanging. This product is customized according to the flexibility and need of client. GENIUS is supported by DB2 400 database

Role performed: Project Manager and onsite coordinator

Tasks Performed:

Functional analysis of source systems
Project Planning & Tracking, Client Liaison
Functional & Technical coordination
Causal analysis for production bugs occurring after service delivery
Preparation of data mapping rules
Coordination with development team (varying between 4 to 7) at offshore (India)
Involved in review process for the Deliverables
Coordination of Unit and System testing

Client Name: BOA, Chennai

Start Date: Feb 2004 End Date: Nov 2004

Project #4: APO RAD POX INITIATIVES

BOA- APO: The project support, maintain and enhance the APO Application, which is the Account Processing online System. Account Processing Online (APO) applications collect, edit and apply all online financial data, and most administrative transactions for California checking, savings, Time Deposit and Individual Retirement Account products. APO is unique to California, Bank of America and supports various delivery channels.
BOA RAD POX Initiatives: The project involves enhancements to APO and RAD POX applications.
RAD (Retail ATM Delivery) is an authorization system for all Proprietary and Issuer ATM transactions by Bank of America California customers. POX (Point of Sale) is an authorization system for all point of sale and check card transactions by Bank of America California customers

Role performed: Developer

Tasks Performed:

Code development
Unit testing
Preparing Test Plan, Test conditions & Test cases
Analysis

Client Name: VISA, Chennai/UK

Start Date: Aug 2003 End Date: Jan 2004

Project #5: VDPS

The scope of the project is to make changes in the clearing and settlement system according to the requirements of the European region, which in turn depends on the requirements of the members. This project involves making modifications to VISA’s Real-time Settlement Interface Application (RSI) to cater to the regional business requirements of Visa Europe (VE).

Role performed: Developer (Level 1 Certified)

Tasks Performed:

Analysis done based on the specifications provided by the Client.
Code development
Unit testing
Preparing Test Plan, Test conditions & Test cases
Analysis done based on the specifications provided by the Client.

Client Name: VISA, Chennai/Japan

Start Date: May 2003 End Date: Aug 2003

Project #6: Data Warehousing

This project is to cater for Member bank reporting as well as visa internal reporting; a need for an architecture, which could support all business needs, is felt. Visa US and Europe have separate DW systems and AP decided to venture into one of its own. All transactions related to AP region is collected and sent to US for processing and cleansing. This cleansed data will be received as a form of flat file and then transformed and loaded into the DW. Data marts or simply aggregate tables will be designed to meet the various Business Applications’ reporting needs using the OLAP tool Microstrategy 7.2.2. DB2 is decided to be the backend database on a mainframe.
The objectives behind the initiative are:
Support Business Applications from a common data source.

Role performed: Developer

Tasks Performed:

Analysis done based on the specifications provided by the Client.
Code development
Unit testing
Preparing Test Plan, Test conditions & Test cases
System testing and IQA Code/System testing
DB2 DBA
Coordination of Unit and System testing
Database analysis & data extraction thru DB2 batch unload utility

Client Name: VISA, Chennai

Start Date: March 2003 End Date: May 2003

Project #7: RAMS

Project Risk Management, VISA AP intends to build an Application, Risk Activity Monitoring Service (RAMS), which would help identify the merchants who skim the accounts. The merchant where the skimming occurs is called a Common Purchase Point (CPP). VISA Analyst, Issuer, Acquirer, and Law Enforcement will access the application for identifying the CPPs. To identify the suspected CPPs based on the rules given by Risk Management. To help VISA Analyst to narrow down the suspected CPPs from the calculated metrics using the visualization tools. To alert the members about the merchants who are identified as CPP. To help acquirers, issuers and law enforcement enter the information related to CPP merchants and accounts.

Role performed: Developer

Tasks Performed:

Functional analysis of source systems
Analysis done based on the specifications provided by the Client.
Code development
Unit testing
Preparing Test Plan, Test conditions & Test cases
Developed REXX tool
System testing and IQA Code/System testing
Database analysis & data extraction thru DB2 batch unload utility

Client Name: Lehman Brothers, Chennai

Start Date: Nov 2002 End Date: Mar 2003

Project #8: IDMS – DB2 Conversion

Lehman Brothers is a global investment bank serving the financial needs of corporations, institutions, governments and high net worth investors worldwide. Lehman Brothers actively participates in the global capital markets through a closely integrated network of offices anchored by a worldwide headquarters
in New York and regional headquarters in London and Tokyo. Since Lehman Brothers was founded in 1850, it has built a global reputation for providing state-of-the-art research, distribution, trading, and financing services.
The project is for migrating the Trading System application from IDMS database to DB2 database. This is the pilot phase of the project where in only 20% of the IDMS records are converted to DB2 tables and the remaining records are retained in IDMS. The online portion of the application has been built using CICS. The data replication to synchronize the IDMS and DB2 product. DB is done through a...

CV IDMS, Missions IDMS