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...
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
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
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
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
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
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.
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
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
C & C Oracle
CICS
IMS DC
IMS DB
DB2
HDAM
BDAM
VSAM
SPUFI
ASSEMBLER
COBOL
IDMS