Summary

• 8 Years of experience in full Life Cycle of Software Development including System study, Requirement Analysis, Program Design, Development, Unit testing, System testing, Integration Testing, System Maintenance, Support and Documentation.
• Have Certification on IBM DB2 V8.1 Family.
• Have a Prove It score of 90% on COBOL test (basic, intermediate and advanced)
• Domain knowledge covering life cycle of the system in Mainframe applications on diversified fields of Banking, Finance, Retail Systems, Travel Systems.
• Excellent application development and maintenance experience on IBM Mainframes using VS COBOL II, DB2, IMS, JCL, VSAM, CICS, TSO/ISPF, EAZYTRIEVE and FOCUS.
• Expert in CHANGMAN, ENDEVOR and LIBRARIAN for configuration management.
• Worked extensively with tools like Changeman, Xpeditor, File-aid, and File-aid for DB2 and IMS.
• Sound knowledge in using IBM utilities, SYNCSORT, IEBGENER, IDCAMS and FILEAID utilities.
• Expert in coding SQL for retrieving and manipulating database tables using query management and reporting tools like QMF, SPUFI, QUERY MAN, PLATINUM and DB2 FILE-AID.
• Worked extensively in DB2 maintenance. Used Load and Unload jobs, REORG, Check Pending and Image copy jobs. Developed Stored Procedures as part of business requirement changes between the systems.
• Complete knowledge of techniques of DB2 database and query optimization like efficient indexing and database design that is required for the best query performance.
• Extensively worked on VSAM KSDS files, VSAM RLS, VSAM IAM files, VSAM Alternate Indexes, IDCAMS utilities for VSAM (Delete, Define, Copy, Repro, Alter, Verify) and VSAM file conversions using EZTRIEVE.
• Developed Eztrieve code for various scenarios using Match, Sort, Internal Tables & Search, Report, DB2 and File Operations.
• Worked on the Performance verification of the existing mainframe Online and Batch systems Using STROBE. Identified the necessary changes required in the system parameters and design, which will enhance the performance of the system.
• Testing skills include performing Unit, Regression, Integration, UAT and Volume testing as well as development, execution, maintenance of test plans, test specifications and test scenarios and QA processing.
• Involved in various Testing's like Unit testing, Integration Testing, User Acceptance Testing, Regression Testing.
• Update QMS (Quality Management System) documents like Project initiation, Project action plan, Detailed Requirements Specifications, Impact Analysis, File Specifications, System Run Chart (flow chart), Program Specifications, Program Development, Coding, Unit Test Plan, System Test plan, Implementation plan, and Post implementation check.
• Create test cases for the user acceptance test and co-ordinate with the users during UAT
• Extensively work on ADW Cool generated COBOL code in banking domain.
• Facilitated training of junior programmers in Coding Standards (GAME standards), Date Routines ABEND Routines of In house modules.
• Extensively worked on the Restart Logic for COBOL-DB2 Programs using BMC software product QUICKSAM.
• Extensive knowledge and work experience on the Focus applications. Developed and modified the existing focus programs including (Update, Rebuild Database, Create/Maintain databases, and Dialogue Manager).
• Extensively worked on the testing of Focus programs.
• Extensive knowledge and work experience on the CICS transactions, online programs and concepts like T-class, dynamic TSQ creations.
• Worked on Conversion Projects, like IDMS to DB2 and IMS to Open system databases and VSAM to flat files.
• Sound knowledge on C language and PL/SQL.
• Good team player with strong people skills and excellent Communication, Problem Solving skills and interpersonal skills, Innovative, Open to Learning, Receptive to Challenges and exposed to various design and presentation tools like Visio and MS-Office utilities.

Technical Skills

Programming: VS COBOL II, CICS, JCL, EAZYTRIEVE, FOCUS, C, SQL
Tools : TSO, ISPF/PDF, SYNCSORT, SPUFI , CHANGE MAN, ENDEVOR, XPEDITOR, FILE-AID, DB2-FILEAID, SUPERC, FTP, CA-7, QMF, MQ Series, MS-WORD, MS-EXCEL, MS-PROJECT, Stored Procedures, QUERY MAN, LIBRARIAN, PLATINUM, REMEDY, MERCURY, HP, STROBE , SEEC TOOL,KITE, SMART TEST, PL/SQL, XML,QUICKSAM,DATACOM.
Environment: MVS/ESA, DOS 6.22, IBM S/390, IBM 3090, 3270, WINDOWS 95/98/NT, UNIX.
Databases: DB2, IMS, ORACLE 8I, PL/SQL, VSAM and IDMS, SQL Server.
Special Skills FOCUS, EZTRIEVE.

Professional Experience

Confidential, IL Sep 08 - Till Date
Senior developer
CSS - Central Support System

CSS is the system which supports HSBC card acquiring processing in the US. Acquiring is the process whereby a financial institution collects and processes credit and debit card transactions from a retailer, ensuring that the card holder is debited and the retailer credited accordingly. Many other processes hang off this function and are also supported by CSS, such as charging (whereby the retailer is charged for the transactions processed on their behalf) and disputes (where a transaction is disputed and decisions have to be made as to whether the dispute will be accepted and on the consequences that flow from that decision).It also involves development task for visa rebinding (introduction of HSBC VISA cards into market)It also involves doing maintenance task for various portfolios like cards, clearing, and retail.

• As part of development of visa rebinding involved in understanding the business requirement ,preparation of technical specifications, reviewed technical specifications, preparation of check list, preparation of test plans, coding, testing, Implementation
• As part of maintenance, attending the Service Requests meetings and involved Analysis, Preparation of Technical spec, Code modification, Unit or System Testing, Implementation, closing the checklist and ticket, and proper Documentation.
• Coordinated with Client & Business Analysts in gathering project related information, developing programs and implementing them successfully.
• As part of Testing involved in Unit Testing, System Testing, Regression Testing, User acceptance testing for the application to be error free.
• Extensive knowledge of QMF & SPUFI, DB2 utilities like Query man where queries are written using SQL statements to extract data from tables in order to research production issues.
• Coding and Testing for any Ad-hoc requests in Eztrieve and COBOL.
• Developed new CICS programs which read from the MQ series and parse the XML data and insert into DB2 tables.
• Expert in File Conversions (VSAM and Sequential files) as part of releases.
• Developed new programs, Jobs, SP modules (Procedures) , PARM\'s and modified existing programs using JCL, DB2, VSAM, COBOL, CICS, EZ+ as per the requirements documents.
• Developed new reports using the COBOL and Eztrieve programs as per the requirement.
• Developed Easytrieve code for various scenarios using Match, Sort, Internal Tables & Search, Report, DB2 and File Operations.
• Involved in implementation of TCLASS (Transaction Class) and ICE CHAIN as part of CICS transaction utilization.
• Created Batch JCLS for VSAM files OPEN and CLOSE in CICS region.
• Developed Complex Online CICS programs as part of MQ series flow to load data from different sources to DB2 host tables using COBOL, CICS, MQ, VSAM, and DB2. TSQ, TDQ, START command, ENQ, DEQ, SPOOL and File Read and Write commands used as part of CICS programs coding.
• Designed and defined VSAM RLS files as part of business requirement change.
• Analysis and design of test cases based on functional and business requirements.
• Generated test data thru online screens.
• Preparation of impact analysis, Issue analysis, Implementation Plan and Program flow documents.
• Execution of test cases includes JCL preparation, jobs execution and verification.
• Preparation of Strobe reports as per the client requirement.
• Coded and tested the new FOCUS programs.
• Modified the existing FOCUS programs as per the business requirement.
• Extensively worked on Rebuilding of the existing Focus databases.
• Worked on the creation of new Focus databases.
• Changes to the existing Focus programs for the modification of the existing reports.
• Developed the new Focus programs for the creation of matrix report generation.
• Written new program to extract the data from IMS & DB2 database as part of open systems Screens development requirements.
• Written new program to load data into IMS database from back up files as part of Cycle testing's.
• Resolved the IMS abends as part data load (U0039,U0047,U3303 e.t.c).
• Developed the Focus programs for the creation of reports as a part of business requirement.
• Created the test cases to test the Focus programs.
• Executing the NDM process.
• Created and implemented the stored procedures for the CSS system as part of the business requirements change between the systems.
• Developed File Aid batch cards for file activities like COPY, DROP, MOVE, REPLACE, SPLIT, SIGN REVERSAL, SEARCH and COPY.
• Maintained the existing Focus code and reviewed the code as part of system testing.
• Performed Pre production implementation activities.
• Wrote regression test scripts for all modules of application.
• Generated and reviewed test plans by including test scenarios, test cases, testing environments in PowerBuilder.
• Uploading of Test cases and logging of the defects into the quality center.
• Provided support for the user acceptance testing and created test cases for the users.
• Involved in running the test cycles in all the regions.

Environment: MVS/ESA, VS COBOL II, FOCUS, EZTRIEVE, JCL, DB2, VSAM, CICS, SPUFI, QMF, IMS, CHANGE MAN, XPEDITOR, FILE-AID, DB2 FILE-AID, MQ Series, Stored Procedure, STROBE, REMEDY, Query Man, Quality Cente.

Confidential, IL Jan 08 - Aug 08
Senior developer
GWT - Global Whirl Team
Confidential, uses WHIRL (World Wide HSBC International Revolving and Lending) system for their credit card processing. This software has been developed by HI to support all aspects of credit card processing including application processing, account processing, customer care, collections, authorizations, letters, interchange tracking and MIS reports. Global Whirl (or Gold and Gold PLUS) team is responsible for enhancing the Vision PLUS package to incorporate common functionality so that the enhanced package - called Global Whirl - can be used as a basis for the Business Units of HSBC. Besides including the major systems such as CMS, FAS, ITS/TRAMS, and the Global Whirl enhancements includes in-house subsystems DPU and SFM systems. The scope of the project involves addition of new functionality and enhancements to the Global Whirl software as requested by the client (HSBC). In addition, the responsibilities also include keeping the Global Whirl Software compliant with the fixes and enhancements sent by FDI Inc.

• Design and changing the existing functionality.
• Worked on Releases and compliance activities.
• Writing the new programs/new jobs on request of business need.
• Developing new Eazytrieve programs for file conversions.
• Coding and Testing for any Ad-hoc requests in Eztrieve and COBOL
• Peer review of the Code, design documents, test plans and test results.
• As part of compliance, providing Gap analysis for new functionality.
• Prepare Technical specification of modules and processes.
• Worked on file Conversion, Compliance and Release tasks.
• Performed Region testing.
• Developed new focus programs for report generations.
• Prepared the test cases to test the Focus applications.
• Developed the JCL's for the creations of new Focus databases.
• Extensively worked on the focus applications for the creation of various reports.
• Developed new focus programs and modified existing focus programs.
• Extensively worked on the testing of Focus programs.
• Preparing analysis documents on the defects identified in UAT.
• Modified CICS maps and online programs as part of compliance process.
• Created test cases to execute the CICS online programs.
• Involved in the uploading of test cases into Quality Center.
• Involved in logging defects into Quality Center.
• Involved in the preparation Unit Test documents and Unit testing of the code.
• As a part of Testing involved in Unit testing and User Acceptance Testing(UAT).

Environment: MVS/ESA, VS COBOL II, FOCUS, VISION PLUS, EZTRIEVE, JCL, VSAM, CICS, SUPERCE, Smart Test, LIBRARIAN, FILE-AID, XPEDITOR.

Confidential, Nov 06 - Dec 07
Developer
AIRS (Account Information and Relationship System)
Confidential, is a leading global financial management and advisory company with a presence in 43 countries across six continents. AIRS (Account Information and Relationship System) is the entry point of the accounts into the system. AIRS will capture and maintains the client information like account type, trade type, ownership type etc. Main user area is Client Account Services (CAS) located in Denver. CAS directly deals with the firm's domestic branches and also receives client and branch correspondences. AIRS is made up of Account Opening (KD), Name and Address (NA), Link and Document processing (DQ).

• Understanding the Business requirements for enhancements.
• Preparation of technical specification and test cases.
• Coding and unit testing.
• Peer review of the specification documents test cases and test result.
• Preparation of delivery documents.
• Generated and reviewed test plans by including test scenarios, test cases.
• Involved in pre implementation process like preparing check list and audit.
• Involved in post implementation process like monitoring the system and closing the issue tickets.
• Coded and tested the new FOCUS programs for the report generation.
• Reviewed the Focus programs.
• Prepared the Test cases to test the Focus programs.
• Modified the existing Focus Databases.
• Involved in the upload of test cases into the Quality Center.
• Involved in the logging of defects into the Quality Center.
• Involved in cycle testing as a part of integration testing.

Environment: MVS/ESA, VS COBOL II, JCL, Physical Sequential Files, FILE-AID, QUERYMAN, SUPERCE, CHANGEMAN, XPEDITOR, DB2, PLATINUM, KITE, EZTRIEVE, Focus.

Confidential, Apr 05 - Sep 06
PROGRAMMER
TRACIE (Trip Recording and Crew Inventory Environment):
TRACIE (Trip Recording and Crew Inventory Environment) is BA\'s main system for cabin crew roster maintenance and on-the-day tracking. TRACIE is a 24hr critical operational system with over 1000 users worldwide. It maintains the rosters for over 15,000-cabin crew and balances crew across LHR, LGW, MAN, GLA and several International bases.
Every service operated by British Airways is input into TRACIE together with the crew trips planned to operate these flights. These trips form the basis of crew rosters. TRACIE checks that all services are legally crewed by the appropriate number and type of crew and produces lists of uncovered services and trips. Any schedule changes affecting trips and rosters are advised and the appropriate action taken. Flight movement information is also input automatically into TRACIE.
Following are the main functionalities of TRACIE system:

Trip management and maintenance
Roster maintenance
Crew Personnel details maintenance

• As a part of production support used to do the daily maintaince activity.
• Responsible for understanding the business functionality.
• As a part of maintaince involved in the Preparation of program specification and test cases.
• Coding and unit testing.
• Permanent fixing of production abends.
• Peer review of the specification documents test cases and test result.
• Generated and reviewed test plans by including test scenarios, test cases.
• Involved in Unit Testing, System Testing.
• Worked as primary support in solving the production issues.
• Raise the production issues and close the tickets after permanent fix through KITE.
• Extensively worked on the CA-7 as Part of the Production Support.
• Involved in the upload of test cases into the Mercury Quality Center.
• Involved in the logging of defects into the Mercury Quality Center.

Environment: MVS/ESA, VS COBOL II, JCL, VSAM, FILE-AID, SUPERCE, ENDEVOR, XPEDITOR, CICS, DB2, Stored Procedures, IMS DB, KITE, CA-7, Mercury.

Confidential, Feb 03- Mar 05

Project #1: CAR (Current Account Re Engineering)
The objective of Current Account re engineering is to migrate process oriented functionalities from KK to ZVKK which are still performed by the present KK System. Migration of the system from KK to ZVKK will result in modularizing the business functionalities which will increase the business. The business logic functions could be reused, migration from flat files to DB2 will result in system being continuously available for the users, with immediate updating. The existing systems will be reverse engineered to get the functionality and the business logic embedded within these systems and removes the unused code.

• Understanding the Business Requirement
• Preparation of mapping documents for conversation process
• Preparation of Technical specification documents
• Program Specification documents along with test plans
• Coding new conversion COBOL programs and JCL for execution of COBOL programs.
• Coding and unit testing of COBOL programs.
• Peer review of the specification documents, code, test cases and test result.
• Performed different type of testing on application to ensure that application is error free.

Environment: COBOL, JCL, DB2, Sequential Files, CICS, QMF, SPUFI, FILE MANAGER for DB2, FILE MANAGER for FILES, CHANGEMAN, XEPADITOR.

Project #2: GDS
The current development environment of GDS uses a third party tool called ADW Cool to generate the COBOL code. ADW/COOL which is the operating system that tool currently runs on, are out of date, and are not being supported any more by its vendors, so there is a fundamental reason to migrate to another system. The scope of the project is to migrate the COBOL code generated by ADW Cool to Native Cobol. While doing so we will be performing variety of actions and to aid in the actions Deutsche Bank has come up with a tool set. This tool set has been written using REXX procedures and the best part of it is everything has been automate and integrated with in the same tool. This tool is very powerful and easy to learn at the same time.

• Converting the ADW Cool generated COBOL code to native COBOL code using the tool.
• Ad-hoc request day-to-day work.
• Writing the new programs/new jobs on request of business need.
• Writing detailed test plans and test requirements hierarchy and Preparing test results.
• Prepare low-level specification for system service request.
• Running Test Cycles based on client request.
• Peer review of the Code, design documents, test plans and test results.

Environment: COBOL, ADW COOL, File Aid, JCL, DB2, ENDEVOR, XPEDITOR, REXX.

Confidential, Feb 02 - Jan 03
Project: ICS (Integrated Customer System)

Fidelity Brokerage and Technology Company need to consolidate the two systems into Integrated Customer System (ICS).The present two systems Customer Accounts and FBSI name & address has redundancies within themselves. Consolidation of the systems would results in Fidelity in making the system maintenance and enhancements cheaper and faster. Migration from IDMS to DB2 will result in system being continuously available for the users, would provide more technological options for further enhancements to the system. This would also remove the redundancy of the available data. The existing systems will be reverse engineered to get the functionality and the business logic embedded within these systems. This would save considerable time and efforts.

• As a part of conversation project involved in impact analysis using the SEEC tool.
• Preparation of technical specification documents (TSD's) for the conversion process from the IDMS to DB2.
• Responsible for preparation of test cases, coding and UTR's.
• Developed COBOL programs using IDMS and DB2.
• Prepared test cases to execute conversion programs.
• Prepared regression test cases to check the existing system functionality.
• Performed keen review on TSD's, code changes and test cases.
• Peer review of the Code, test plans and test results.
• Execution of test cases includes job execution and verification.
• Developed quality related documents as part of implementation.
• Developed programs for file conversions.
• Conducted the meeting with end users, and prepared MOM's (Minutes of Meetings).
• Conducted the knowledge sharing sessions related to conversion process.
• Participated in pre and post implementation process.

Environment: COBOL, JCL, DB2, VSAM, IDMS, TSO ISPF/PDF, QMF, SPUFI,SEEC TOOL, FILE MANAGER For DB2, FILE MANAGER For FILES.

Education
Master in computer science