OBJECTIVE

To pursue a progressive career in a Business IT environment, capitalizing on acquired skills and personal traits pertaining to critical thinking and analytical skill sets.

SUMMARY

• Over 13 Years of experience in production support, analysis, design, development, enhancements, testing and implementation.
• Expert in Mainframe Technologies involving Analysis, Design, Coding, Production Support, Implementation, and testing of Application Software Maintenance with DB2, CICS, VS COBOL II, JCL, PROC, IDMS, VSAM, TERADATA, DYL280, SAS, MQ Series.
• Proficiency in executing the complete life cycle of the project SDLC .
• Well acquainted with Banking, Asset Management, Financial Services, Insurance, Government and Retail Printing business domains.
• Worked with one of the top 10 banks in North America National City Bank PNC Bank . Worked on the pioneer software of Hewitt Associates LLC TBA - Total Benefits Administration SUNGARD's Omni Plus, SUNSTAR, PNS and Brokerage systems.
• Extensive programming knowledge on IBM utilities like IDCAMS, IEBGENER, IEBCOMPR, DFSORT and MERGE etc.
• Good knowledge on Configurations management and version control tools Serena Change Man ZMF, Endevor and Work Bench.
• Experienced in writing Standard View Materialized Query Tables.
• Experience in trouble shooting the problems and debugging tools like XPEDITOR Batch and Online, Princeton and ABEND AID.
• Well exposed to Mainframe Tools File Aid, SPUFI, QMF, ROSCOE, MQ Series, Princeton.
• Good working knowledge on CA-7 Scheduler, ZEKE, Control-M, Secure send and ITSM.
• Strong knowledge in Testing methodology and Quality Assurance processing/ Testing.
• Involved in Unit testing, System Testing, Integration Testing, and functional testing.
• Good knowledge on SAR, FTP, File Manager and NDM processes.
• Developed front end CICS Screens using BMS maps .
• Involved in Performance tuning projects where the existing modules are analyzed for optimum use of system resources.
• Effectively used File Aid to create and manipulate flat files and VSAM files.
• Well tested the Mainframe applications with Quality Center Quick Test Professional Tools before promoting the code to Production.
• Hands on experience with documentation in different stages of SDLC.
• Quick learner with an ability to rapidly adapt to new technologies and new environments.
• Demonstrates excellent troubleshooting and analytical abilities, outstanding interpersonal and communication skills.
• Worked on Customer/1 and Install/1 Applications.
• Mentored a team of 5 in efficiently meeting the project delivery time lines.

TECHNICAL SKILLS

• Languages : COBOL, VS COBOL II, SAS, JCL, REXX, DYL280
• Front End/GUI : CICS, Java
• Access Methods : VSAM
• Operating Systems : Mainframe, Z/OS, OS/390, Windows, MVS, UNIX
• Database : Oracle, DB2, TERADATA, IMS, SQL, PL/SQL, Stored Procedures, MQT
• Tools : TSO, ISPF/PDF, File Aid, Xpeditor Batch Online, QMF, SPUFI, Princeton, Sync Sort, Easytrieve, CA7, ZEKE, MQ Series, Control-M, Utilities/ Clists, BTEQ, Fast Load, Fast Export, Multi Load, TPump, RACF, SDLC, Serena Change Man ZMF, Endeavor, Infoman, ROSCOE, NDM, ECM, Info man, SAR, Lotus Notes, Out Look, Abend-Aid, Secure Send, ITSM, FTP, VPN, Quality Center, QTP, File Manager, Customer/1, Install/1, Panvalet, VISIO, MS Office

PROFESSIONAL EXPERIENCE

Confidential

Senior Mainframe Designer/ Programmer

Client: RR Donnelley

• The largest companies in the world and others rely on RR Donnelley's scale, scope and insight through a comprehensive range of web-based tools and innovative technology, variable printing services, market-specific, and customized supply chain solutions. The project involves enhancement, maintenance of their existing WCSS Wallace Customer Service Support applications which combines the activities of the online and the batch process.
• Nature of work involves System Data analysis, design, development, testing, integration Implementation.

Responsibilities:

• Gather business requirements and doing the analysis and creating technical specification documents for a RR Donnelley WCSS system.
• Worked with Quick Job Spectrum to automate the Mass Change Process.
• Developed various programs using COBOL II, VSAM DB2.
• Generated various design docs using Visio, MS-Word PowerPoint.
• Wrote multiple Materialized Query Table for create Ware house Reports
• Wrote various Quick Jobs to achieve the functionality easily.
• Written program to do convert the invoices into Customer specific report printing AFP .
• Used ZEKE Scheduler to setup the Daily, Weekly, and Monthly Yearly Jobs.
• Used various JCL Utlities Debugging tools to resolve the Production Issues.
• Performed Unit, Functional, E2E, QA User Acceptance Testing before the Code Migration.
• Though knowledge about COBOL II, JCL, DB2, TERADATA, CICS, SQL, FTP, MQ Series.
• Worked on Quality Center QTP to test the code before Implementation to meet the standards of RR Donnelley.

Software/ Tools : TSO, ISPF/PDF, COBOL II, OS/ JCL, PROC, DB2, SQL, TERADATA, SDLC, IMS, CICS, AFP, REXX, VSAM, Easytrieve, SPUFI, QMF, Stored Procedures, Princeton, File Aid, SAR, CA7, ZEKE, FTP, MQ Series, Quality Center, QTP, Xpeditor, Endeavor, VISIO, Customer/1, Install/1, MS-Office.

Confidential

Senior Mainframe Programmer Analyst

Confidential is one of the good well established individual financial organization which manages/ invests Ohio State Employees Employers monthly contributions and pay out the benefits for the rest of their lives and the lives of their survivors. It offers Pension, Health care and Disability benefits to their customers. It has got good tracking system on customer calls and also sends the correspondence letters to their Employers.

Nature of work involves System Data analysis, design, development, testing, integration Implementation.

Responsibilities:

• Gather business requirements and create technical specification documents for a Savings system at OPERS.
• Did the through in-depth analysis to find out the root cause for the Account Value Formatting, Calculation Work sheet modules Severe Deadly errors.
• Performed Data Cleanup activities to allow the system to calculate the Account Value totals for maximum members of the OPERS.
• Designed, developed Data Integration Project to assist the track, analyze the problems / errors in the OPERS savings system.
• Responsible for preparing and documenting the technical specifications from functional specifications.
• Developed various programs using COBOL II, VSAM DB2.
• Generated various design docs using Visio, MS-Word PowerPoint.
• Converted regular SQL to MQT's to improve the performance of the application.

Software/ Tools : TSO, ISPF/PDF, COBOL II, OS/ JCL, PROC, DB2, SQL, SDLC, CICS, MQT, Easytrieve, VSAM, SPUFI, QMF, Princeton, File Aid, Control-M, SAR, CA7, Xpeditor Online Batch, Endeavor, MQ Series, FTP, Clear Quest, Customer/1, Install/1, Mercury Quality Center, VISIO.

Confidential

Programmer Analyst Advanced

• Confidential is a global provider of human resource benefits, outsourcing and consulting services. Hewitt's three business segments are: Benefits Outsourcing, Human Resource Business Process Outsourcing HR BPO and Consulting, help clients develop, implement, and deliver strategies and programs that for human resources business process design, administration, and technologies, as well as help manage the human elements necessary to acquire, develop, motivate, and retain the talent required to meet business objectives.
• As a Programmer Analyst Advanced I am responsible for implementing a new version 4.x of Health and Welfare applications to production. As part of Benefits Implementation Group BIG I coordinated with the Domain Manager to understand the business requirements, different health plans,
• and different provisions and I am responsible for converting Client requirements into clear analysis artifacts and test plans. PAA delivers analysis to create the most efficient batch processes for the system that meets the needs of the client. Also PAA is responsible for coaching to Programmer Analyst, for both technical and domain knowledge.

Responsibilities:

• Gather business requirements and create technical specification documents for a global financial institution.
• Analyze the feasibility in implementing the business requirements by considering different constraints involved and help the business owner in implementing the application.
• Responsible for preparing and documenting the technical specifications from functional specifications.
• Developed different programs as per specifications using COBOL II, DB2, TERADATA, JCL, SQL, and SAS.
• Generated various reports using COBOL II, SAS, DB2 DYL280 programs.
• Evaluated the SQL statements for performance using SPUFI, QMF and Princeton.
• Preparing the test plan and the finding the test cases for performing the Unit testing.
• Responsible for executing the Unit test plan using the test cases for the developed programs and log and resolve the defects.
• Creation and execution of system test scripts to prove the system meets the functionality.
• Participated in Unit, Integration, System, User Acceptance testing and Business Verification testing, log defects and complete changes.
• Worked on Pioneer software's developed by Hewitt: TBA Total Benefits Administration , Conversations, Work Bench, BFQUERY, SAS Macros, SDLC.
• Scheduled the jobs in production using Control-M.
• Wrote the source code as per Hewitt standards, using Base SAS, SAS macros, SAS Procs, DB2, TERADATA, JCL.
• Systems/ Code Analysis Assistance Test plan design Assistance.
• Test the source code as per the test plan and implement it into production through Endeavor.
• Worked closely with Peer Programmers, Domain Managers to complete the projects in time.

Software/ Tools : TSO, ISPF/PDF, COBOL II, OS/ JCL, PROC, DB2, SQL, SDLC, CICS,

TERADATA, VSAM, SAS, SPUFI, QMF, Princeton, File Aid, Control-M, SAR, CA7, TBA, Xpeditor, Conversations, ROSCOE, MQ Series, BFQUERY, Batch Online, Endeavor

Confidential

Programmer Analyst

• Confidential is a leading global financial services firm with assets of 1.1 trillion and operations in more than 50 countries. The firm is a leader in investment banking financial services for
• Consumers and businesses, financial transaction processing, asset and wealth management, and private equity. Under the JP Morgan, Chase and Bank One brands, the firm serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients.
• The nature of work involves the Enhancement, Maintenance and Conversion activities to the Banks 2 of the CTO Centralized Technical Operations Applications. Two applications are ACE Automated Check Express RIM Routing Interface Monitor .
• The ACE RIM are the critical applications which play a major role in posting the check information before those get posted in WDC DDA applications.

Responsibilities:

• Analysis of Online Batch system problems.
• Fixes to Online Batch problems.
• Improving the performance changes.
• NDS Conversion activities.
• Clean up the unwanted stuff from JCL's, Proc's Programs.
• Participated in Unit, Integration, System Client Acceptance testing.
• Coordinated with other teams to get the requirements.
• Used to initiate the Status meetings.
• Did Enhancements, developments day in and day out.
• Very good transition plan followed at the time of completion.
• Software/ Tools : TSO, ISPF/ PDF, COBOL II, JCL, DB2, PROC, Batch Online, SQL,
• CICS, VSAM, File Aid, SAR, ZEKE, CA7, Sync Sort, ECM, Infoman, QMF, SPUFI, Change Man ZMF, Easytrieve, Endeavor, NDM, SDLC
• Confidential is one of the reputed top ten banks in North America headquartered in Cleveland, Ohio. Its core businesses include commercial and retail banking, mortgage financing and servicing, and consumer finance and asset management.

Trust Application Support and Development

• The nature of work involves the Enhancement, Maintenance and Production to support to the Bank's 5 Trust Applications under Asset Management Systems. The 4 TRUST Applications: Personal
• trust system PTS , SUNSTAR Stocks Bonds Transfer System , Pension Systems, BKR Brokerage SND Performance reporting system .
• The Trust Application Services Group provides support for multiple lines of business in the areas of Asset Management, Fiduciary Services, Custodial Services, and Stocks Bonds Transfer
• Agents/Advisors. Asset Management consists of providing investment advice to both high net worth individuals as well as institutional clients such as pension plans Corporate/Government offices.
• Provide production support for record keeping of Personal Trust System Omni Plus
• 24 X 7 Omni Plus Personal Trust System Application Support
• Omni upgrdes Annual Releases Patch Fixes
• Development/modification of custom reports and statements
• Custom Code Maintenance Ad hoc reporting
• Daily pricing support and automation File transfer protocols and transactions

Responsibilities:

• Modify, enhance and support Batch in Trust Management System in Mainframes.
• Analyze, code using COBOL, JCL, DYL280, VSAM, DB2 utilities for enhancements in Trust 5 Applications.
• Carry out extensive unit, integration, system user acceptance testing of the applications.
• Using Change Man ZMF to build, checkout, stage promote packages requiring code changes.
• Giving 24 X 7 Production Support by meeting SLA's.
• Proven problem research and resolution skills via on-call tech support of daily batch jobs.
• Monitor, schedule, modify batch schedule using CA7.
• Familiar with EDI terminologies, worked with various File transfer methods.
• Created and ran queries using Princeton, QMF, and SPUFI utility.
• Participated in code walk throughs and reviews as required.
• Coordinating with Client and Onsite as and when required.
• Documenting the programs and analysis of the functionality.
• Providing the updates to Clients/ Managers regarding the status of the requests.

Software/ Tools : OS/ 390, TSO, ISPF/ PDF, COBOL II, JCL, DB2, PROC, SAS, CICS, VSAM, ROSCOE, Stored Procedures, File Aid, Batch Online, SQL, SDLC, Endeavor, SAR, Princeton, MQ Series, QMF, SPUFI, Sync Sort, CA7, DYL280, Change Man ZMF, INFOMAN, NDM, UNIX, Xpeditor, Abend-Aid, Abend Xls

Confidential

Mainframe Programmer

Software/ Tools : OS/ 390, TSO, ISPF/ PDF, COBOL II, JCL, DB2, PROC, CICS, VSAM, File Aid, Xpeditor Batch Online, SQL, SDLC, QMF, SPUFI, Sync Sort, CA7, ROSCOE, Ellipse