SUMMARY:

• Mainframe professional with 11 Yrs of experience in application programming.
• Strong experience of SDLC, System design, development and Testing.
• Currently working in US leading insurance company Confidential Insurance Companies.
• Experience in Finance Domain with Banking, Insurance, Brokerage and creditcards. Worked with world leading financial advisor company Confidential (Bank of America). Expertise in account opening application including service, client and account data maintenance, inter - system communication, trade, bookings and delivery process. Worked in Statements and ATM card processing.
• Good knowledge of Insurance business.
• Worked on all phases of System development life cycle (SDLC) implementation support. Strong working skill with FILE MANAGER.
• Good working experience in onsite-offshore model, worked as Team leader in various projects.
• Strong Experience in TSO and ISPF skills.
• Strong programming skills in VS COBOL-II &PL/1 in writing new and enhancing existing on line and batch programs
• Good working knowledge in IBM MQ series in helping the business applications exchanges the information between different platforms.
• Extensive working knowledge on CICS, DB2, IMS/DB-DC, VSAM ESDS, KSDS and RRDS.
• Good experience in coding DB2 stored procedures.
• Good experience in writing and resolving the abends in DB2-COBOL programs.
• Extensive working knowledge on JCL.
• Expertise in using various version controlling tools like CHANGEMAN, PANVALET, ENDEVOR, good working knowledge of REXX, CLIST, STORED PROCEDURES.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, DB2, XML and Flat iles into the staging area.
• Experience in working with debugging tools like SMARTTEST, XPEDITER, VIASOFT.
• Experience in writing report utilities in EASYTRIEVE.
• Expertise in wring sort cards using DFSORT and SYNCSORT utilities.
• Good working knowledge with IBM utilities
• Experience in data transmission utilities like FTP and NDM C:D between
• Experience in preparing user documentation and user using MS Tool set (Word, Excel, PowerPoint)
• Good working experience Mainframe job scheduling tools (like control-M).
• Extensive working knowledge on Unit, System and Regression test executions.
• Good experience in preparing Test plans, Test cases, verifying the Test results, Defect tracking.

TECHNICAL SUMMARY:

OPERATING SYSTEMS: MVS, OS/390, WINDOWS 98/2000/XP, z/OS, UNIX.

LANGUAGES: COBOL II & VS COBOL,PL/1, JCL, SQL,,C,C++.

DATABASE: DB2, IMS DB,SQL server

OLTP: CICS, IMS DC

TOOLS: XPEDITER,VIASOFT,ENDEVOR,MQSeries,TELON,CHANGEMAN,ENDEAVOR,MICROSOFT OFFICE SUITE, POWERPOINT, FTP, SDF II, PLATINUM, FTP, SPUFI, QMF, IBM UTILITIES,TSO/ISPF, ABEND AID,CONNECT DIRECT, INTERTEST,NDM,CA11,BMC UTILITIES,TOAD,JES2,CA-7,FILE MANAGER, QUALITY CENTRE, FILE-AID, ICE-TOOL,CLEAR QUEST,,EASYTRIEVE,PANVALET,REXX,CLIST,SPUFI,HP Service manager, IBM Rational developer(Debugging),Share Point, Control-D(Reporting Tool).

Reporting Tools: Business Objects

ACCESS METHOD: GSAM, QSAM, VSAM

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Programmer Analyst

Responsibilities:

• Perform Stakeholder assessments to understand the business requirement and transform it to technical document it for IT development
• Monitoring of the daily Enterprise Platform batch flow for Bank (Loan, Deposit and Credit Card) processes. Working to fix exceptions in our daily batch run.
• Maintaining the Agency compensation system online application screens using IMS DC and CICS.
• Design, Coding and testing of new DB2 stored procedures for Agency compensation department.
• Coded newSQL/DB2/COBOLprograms to load and unload data and create reports.
• Providing the production support to Bank solution center services.
• Debugging the Online/Batch modules using IBM RDZ debugging tool.
• Coordinating with Offshore to complete the Development projects in time.
• Writing VS COBOL-II and PL/1 programs using VSAM files (KSDS, ESDS, RRDS).
• Writing JCLS using various utilities like IDCAMS, DFSORT, EAZYTRIEVE, ICETOOL etc...
• Preparing the test plans and test cases.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• DB2 performance tuning, running Explains and Catalog Management.
• Fine tuning the cursors in the DB2 programs to improve the performance.
• Analyze reported issues and fix the root cause issue
• Generate complex SORT and SAS cards for new jobs
• Generate new reports and data extracts as per user needs from heterogeneous data sources and flat files.

Confidential, Pennington, NJ

Team leader and Analyst

Responsibilities:

• Worked as Team leader in Statements, as a team leader taken care of technical management of a team and encourages groups to work together as well as takes responsibility for team building.
• Making code changes in the statement activity and portfolio programs as per the client requirements.
• Performed unit, User Acceptance Testing and Regression testing for batch; validated and documented the results. Migrated the changes from test to production with the Quality Assurance team.
• Analyzed and documented complete statement process for reengineering, as a part of US trust project.
• Created new copybooks, jobs and procedures to execute batch modules for Statements processing
• Application Maintenance of the system including
• Timely delivery of the audit statements to SQAD(Statement Quality Audit department) at month end.
• Timely response to any potential audit queries/issues.
• Error Correction system ACF/ELS availability to SQAD.
• Online transaction screen availability to SQAD.
• Formatted statement data stored in DB2 data base.All the other system across the Confidential access both IMS and DB2 data base to get the required information.
• Worked on testing process: Statement data/Product go through a complete Software testing cycle before it hits production. . In order to accomplish these testing processes there are in-house testing procedures in place.
• Three week audit testing.
• Mid month testing.
• Monthly integration testing.
• UAT testing.
• Year end clean up process
• Year-end audit.
• Maintaining the In-house online transactions. Like STZA: Historical Portfolio data, STZC: Fund tier rate,STZE - Account trait data, STZ1 - Test account database by modifying the CICS/COBOL programs.

Confidential, Princeton, NJ

Programmer Analyst

Responsibilities:

• Coded according to the specification and standards of business.
• Created procedures and JCL for the developed code in Batch.
• DB2 SQL Performance tuning.
• Devised test cases with the business unit to test system modifications.
• Preparing the Test plans, Test caeses.
• Tracking testing by using HP Quality Center tool.
• Used Quality center tool to track the issues and changes requested for bug fixing, production error request etc.
• Executed unit, User Acceptance Testing and Regression testing for batch; validated and documented the results. Migrated the changes from test to production with the Quality Assurance team.
• Analyzed, documented and resolved outstanding issues including bug fixes.
• Created defect log documents and technical documents for daily and monthly basis requests and production issues.
• Developed and implemented associated tracking reporting metrics for senior IT and business management
• Provided production support for rewritten applications.
• Extensively involved in Preparing Test Plan and Writing Test Cases.
• Involved in UAT and helped business users to test the solution before implementation.
• Define requirements using Quality Center and generate Traceability Matrices to ensure that all the requirements are covered by the test cases
• Used Quality center tool as a repository to store all the Test documentation and Test cases.
• Used Platinum tool for DB2 queries and for editing the tables in test region.

Confidential, Pennington, NJ

Team Leader

Environment: IBM Mainframe OS390, MVS, UDB DB2,IMS DB/DC, VS COBOL-II,PL/1, CICS, Assembler, DB2 Stored Procedure, SQL,, REXX, OPC Scheduler, QMF, TSO / ISPF, IBM Utilities, VSAM, IDCAMS, SCLM, SPUFI, Platinum,MQ series, CA-Intertest, ENDEVOR, CA 7, Easytrieve, FILEAID, Syncsort, DFsort, Viasoft, XML,SOA,MS Office,Syncsort.

Responsibilities:

• As a team lead design high level technical specification.
• Onsite-offshore co-ordination
• Handling Production support.
• Planning and managing resources as per the project requirements.
• By using Clear quest software tracking the tickets logged by user and fixing those issues.
• Working on creation of new PROC’s & JCL’s and OPC scheduler used to schedule the Jobs. Involving in extensive system testing and migration into production. Conducted walk through on all proposed changes, interviews with users concerning al modifications and impact analysis.
• Running LOAD utilities to refresh test database data from production region.
• Developed batch and online modules using IBM MQ series
• IMS database maintenance of this application.
• Coded & Maintained DB2 stored procedures tp share the data in AIRS system with other applications.
• Carry out meetings with client business users to get the requirement specification, do Impact analysis and feasibility study for the new functionality requirements and change requests.
• Modifying CICS online screens and then implement the screens, new business rules in mainframes.
• As a coordinator with the business users, responsible for creating estimates for the maintenance requests.
• Test case/data preparation, execution and verification of the test results and result logging
• Coordinated and Conducted Unit, System and System Integration testing
• Worked on Functional and Performance (Volume) testing with Defect Logging, Review of functional test plan prepared by team members and delegate unit testing among them.
• Preparing implementation strategy and providing the support for implementation of the programs
• Participate in release meetings for maintenance and development projects; suggest process improvements, Communicate progress, test results to the stakeholders.
• Team management and address team related issues or concerns
• Fine tuning of application programs with the help of DBA.
• Job Scheduling using CA-7 tool.
• Preparing the Test plans,Test cases,Verfiying test results.
• Tracking the testing process using HP Quality center.
• Worked on IMS data base to generate the reports and store the account information data.
• Used Fidelity tools for Income strategy Evaluator and Roath conversion and Portfolio review.
• Status reports preparation and coordination.
• Knowledge transfer to new entrants and updating application documentation

Confidential, Pennington, NJ

Consultant - Programmer Analyst

Environment: IBM 3090, MVS, COBOL, Assembler, DB2,I DMS,IMS, JCL, CICS, ENDEVOR, VSAM, DB2,FILE-AID, QMF, SPUFI, VIASOFT,INTERTEST, IDCAMS,SPUFI, Platinum, CA-Intertest, REXX, ENDEVOR,XML.

Responsibilities:

• Modifying CICS online screens and then implement the screens, new business rules in mainframes.
• Create Technical Specifications Document, Prepare unit Test Plans, Code construction.
• Developed batch and online modules using IBM MQ series
• Analyze impact changes, Design the online screen using BMS, programs and file structure, Modify/write program code, Perform testing & unit test plans. Staging and auditing through Endevor, Used CA-7 to monitoring the jobs
• Developed Batch Application in VS COBOL II and DB2,IMS on OS/390 System.
• Project Management plan, Preparing Low level design, performing functional specification documents, performing technical Specifications documents, Involved in System Analysis and Application Design, Involved in Database Design.
• Job Scheduling using CA-7 tool.
• Unit Testing, resolving the issues in the project.
• Used Fidelity tools for Income strategy Evaluator and Roath conversion and Portfolio review.
• Created a tool in REXX to check the volume of data in files
• Used SPUFI for database retrieval and manipulations. Prepared specifications, Test Cases and Test plans, Participated in Status and review meetings.
• Verifying the test case results and updating HP QC about the Defects.
• Defect tracking and coordinating QA team.

Confidential, Pennington, NJ

Programmer Analyst

Environment: IBM Mainframe OS390, MVS, UDB DB2, VS COBOL-II, CICS, DB2 Stored Procedure,IMS, SQL, JCL, OPC Scheduler, QMF, TSO / ISPF, IBM Utilities, VSAM, IDCAMS, SCLM, SPUFI, MQ series, Platinum, CA-Intertest, ENDEVOR, CA Insight, Easytrieve, FILEAID, Sync sort, DFsort, Viasoft, MS Office.,XML,MQ Series.

Responsibilities:

• Participated in the full life cycle of a new Maintenance and enhancement of the project. This is included researching technical and user requirements, creating details designs conversions, programming and coding of the COBOL II batch and online programs that were required to meet the project specifications.
• Developing code as per the defined standards
• Activities as a senior system specialist involve: Emergency Maintenance, Permanent Maintenance of applications and Project implementation with application specific activities like system testing, bug-fixing.
• Carry out meetings with client to get the requirement specification, do Impact analysis and feasibility study for the new functionality requirements and change requests.
• Used SPUFI for database retrieval and manipulations.
• Developed application programs using IMS database.
• MQ programming for the transformation of messages and routing to the destination
• Prepared specifications, Test Cases and Test plans, Participated in Status and review meetings.
• Co-ordination with Testing Team and maintaining the system test region.
• Post Implementation Support: Design Review and Code Review, Provide code optimization as a part of code review, Debugging and Troubleshooting technical issues in System Testing phase and suggest alternate designs and code fix for the issues Log, validate and close Issues, Manage and assist the team for Technical/Non-Technical issues. Interacting with business users to resolve the mainframe application issues, reports and production support issues, Wrote JCL’s for Batch jobs, Used Viasoft to test online and batch applications.
• Used SPUFI for database retrieval and manipulations. Prepared specifications, Test Cases and Test plans.
• Participate in release meetings for maintenance and development projects, suggest process improvements, Communicate progress, test results to the stakeholders.
• Involving Production support and testing CICS transactional programs, testing program through intertest, File transferring using FTP/ NDM process, create Test Plans UAT, Problem created against test regions, to identify by the group id support group.