SUMMARY:

• Senior IT professional with 11 years of extensive full life cycle application development experience in business applications and project experience. Demonstrated expertise in development activities of mainframe on - line and batch applications. Strong analysis and design capabilities with Mainframe skills

TECHNICAL SKILLS:

Technology and Tools: DB2 V10.1SQL CICS BMS DB2 Stored Procedures VS COBOLCOBOL IIEasytrieve Plus SAS VSAMMVS/JCLTSO/ISPFIDCAMS MVS UtilitiesIntertest CEDFFile - AID for DB2 SPUFISQLQMFEndevor V.15 File ManagerXPEDITORDFSORTNDM GDGDB2 IBM Utilities OPC Scheduler MQ SeriesFault Analyzer BMC Catalog manager CHANGEMANSTARTOOL IBM Data studio 4.1.0.0 client RDZ client Version 9 for Z/OS SOLA Client 2.20 Basics of ETL tool Data Stage (Ver8.0/7) and Informatica Share Point

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Responsibilities:

• Worked on the development of Cobol programs, DB2 stored procedures, JCLs and PROC for AIU
• Coding of CICS programs for mainframe based online applications for AIU
• Coordination with the Quality Assurance(QA) and User acceptance team to make sure all the testing is done for AIU project
• Maintenance, Deployment and monitoring of mainframe based applications
• Ongoing support for the DB2 stored procedures and the online screens
• Development of SQL code to perform data Inserts, Updates and Deletes in DB2 database
• Scheduling mainframe jobs using OPC Scheduler

Confidential, Chicago, IL

Responsibilities:

• Worked on the CML data warehousing project
• Involved in business requirements gathering from the users monthly TDR/IFRS reports
• Developed SAS programs and UNIX scripts to move SAS files from mainframe to UNIX server
• Developed JCLs with DFSORT for TDR/IFRS reporting
• Ongoing support for the CML migration projects
• Worked on decommissioning of older version of mainframe jobs
• Scheduling jobs using CONTROL-M scheduler

Confidential, Jacksonville, FL

Responsibilities:

• Worked on the Mutual funds online trading project
• Involved in business requirements gathering from the users for the Trading system
• Developed DB2 batch modules and CICS online modules for the new enhancement of the online trading system
• Coded major modifications. Executed DB2 Utilities, performed data validation, and analyzed problems
• Involved in all phases of the project starting from requirement analysis to implementation and support

Confidential, Charlotte NC

Responsibilities:

• Worked on the online banking self enrollment enhancement and banking services enhancement
• Developed DB2 CICS batch modules to build MQ OAG messages for retrieval processing by the User Interface Front end and mid tier processes
• Development new native stored procedures called by user interface and front end applications
• Development batch programs and JCLs for the delta processes for the application’s database
• Worked on CICS screen changes for new screens and new field additions
• Created technical design documents, Unit test plans and scripts
• Have worked on sequential file comparisons using DFSORT and ICETOOL
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.0/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.

Confidential

Responsibilities:

• Worked on the Mutual funds remediation project for retirement accounts
• Developed technical specification documents, Integration test scripts
• Developed Cobol programs and JCLs to identify mutual fund transactions for remediation and calculate the mutual fund fees
• Worked in OPC Scheduler for scheduling and executing the JCLs for remediation process
• Created programs in Easytrieve and DFSORT for sending statements for remediation

Confidential

Responsibilities:

• Worked on the Mutual funds transaction tracking project
• Developed DB2 batch modules to receive and process the new funds and do the fund setup with the other details of the fund.
• Created new programs for tracking the history of Mutual fund transactions with DB2 as database
• Coded major modifications. Executed DB2 Utilities, performed data validation, and analyzed problems
• Involved in all phases of the project starting from requirement analysis to implementation and support

Confidential

Responsibilities:

• Worked on the Mutual funds transaction tracking project
• Developed DB2 CICS modules to receive and process the new funds and do the fund setup with the other details of the fund.
• Coded major modifications. Executed DB2 Utilities, performed data validation, and analyzed problems
• Developed batch programs for the share class conversion between different fund classes
• Involved in all phases of the project starting from requirement analysis to implementation and support

Confidential Hopewell NJ

Responsibilities:

• This project was to calculate the Preferred financial advisors among the Pool of financial advisors
• Involved in business meetings for JAD sessions for designing the project
• Preparation of BRS and SRS, Technical specifications
• Creating unit test scripts, Development and unit testing - Done in COBOL, JCL, DB2
• UAT, Production support and Maintenance

Confidential

Responsibilities:

• Worked on migrated the entire investment customer from Confidential to the Confidential servers.
• Involved in business meetings for requirements gathering for the project
• Involved in designing new DB2 tables for the investment customers and DB2 stored procedures for this project
• Development and unit testing, UAT, Production support and Maintenance
• Worked on migrated the data in the GWIM system to the new HUB
• Involved in business meetings for requirements gathering for the project
• Coded COBOL programs, JCLs, Easytrieve programs to support this project
• Development and unit testing, UAT, Production support and Maintenance
• Worked on the project that stores customer information for the Financial advisors
• Worked on resolving of production tickets by analyzing the COBOL, CICS DB2 programs and reporting to business
• Developed DB2 batch and CICS programs in support of this project. Created CICS - COBOL programs with the CICS BMS screens
• Created CICS online screens using BMS and have done screen modifications.
• Involved in checking the DB2 performance using the DB2 IBM utilities
• Worked in SQL queries, Unload and load for DB2

Confidential

Programmer Analyst

Responsibilites:

• Worked on the Production support of batch jobs and CICS online screens
• Worked on enhancement for the functionalities in custody management and corporate actions
• Worked on resolving of production tickets by analyzing the COBOL, CICS - VSAM programs and reporting to business
• Developed DB2 batch modules to receive and process the new funds and do the fund setup with the other details of the fund.
• Created CICS online screens using BMS and have done screen modifications for the securities setup and securities modification