SUMMARY

• A dynamic professional wif 8+ years of rich experience in Mainframe Application Development and Maintenance & Support activities.
• Extensive experience in design and development ofmaintainand database programming
• PL/SQL Developer used to query specific tables for analysis and data validation of Oracle Db used by UI.
• Experience in UNIX scripting for Export/Import for data, automating bank file loads.
• Expertise in Mainframe Technologies including COBOL DB2, JCL, VSAM, REXX, SOFTECH, PLATINUM, SPUFI, FILE MANAGER, QMF, XPEDITER, QUALITY CENTER, ENDEAVOR, DEVELOPMENT CENTER, CLP, TESTOR, PANVALET, FILE AID, TSO, ISPF and IBM Utilities.
• Has been working as Onsite Project Lead at client location from last 4.5 years which included project co - ordination, application development, release management and client management.
• Rich experience of development as well as support activities wif the onsite-offshore model that includes all the SDLC phases, support activities and coordination wif the offshore team.
• Extensive experience of application development in Mainframes technologies including DB2 database maintenance, JCL and Performance tuning.
• Work involves fixing abends such as Space abends, File contention errors, VSAM space abends and DB2 abends.
• Experience working on Oracle onUNIX,Linux, Windows.
• Managed across systems data usingSQL*Loader,Triggers, Stored Procedures, Functionsand packages.
• Experience and in-depth working noledge in various Oracle andSQLserver tools to work wif databases, Reporting and Business Intelligence based applications like OracleSQLDeveloper, SQL station, Toad, Query Analyzer etc.
• Extensive experience in design and development ofmainframeand database programming
• Worked closely wif stakeholders and SMEs to assist the fulfillment of the project goals and objectives.
• Define and document key business processes.
• Efficient in documenting existing processes, preparing Business Requirement Documents (BRD), analyzing Business Requirements, working wif Requirements Traceability Matrices (RTM), re-engineering business processes.
• Facilitated User Acceptability Testing UAT successfully.
• Worked wif Analysts, Managers, Developers and Testers for complex projects during the SDLC
• Solid processing of various SDLC phases.
• Possess noledge of Software Development Life Cycle, Agile Methodology, and Project Management.
• Exceptional communication, collaboration & team building skills wif proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

TECHNICAL SKILLS

Software Products: Development Centre, TSO/ISPF, Mainframes OS 390, Windows XP, ISERIES

Tools: Platinum, SOFTECH, SPUFI, File-Aid, File Manager, XPEDITER, Quality Center, Endeavor, Development Center, CLP, Tester, PANVALET, IBM Utilities, MS-Word, Visio, Excel, Microsoft Project

Language/Framework: COBOL, DB2, JCL(Job Control Language), VSAM, CICS, OS/390(Mainframes), SQL, BAL/Assembler, PL1, RPG, SAS, EXEC, REXX, CL, VB)

DATABASE: DB2, IMS/DB-DC, ORACLE, SQL, BAS, ACCESS

PROFESSIONAL EXPERIENCE

Confidential, Westlake, TX

Sr. Mainframe Production Support Executive & Project Lead

Responsibilities:

• Working as a project lead at onsite and providing 24 X 7 production support & maintenance co-coordinating wif the offshore team.
• Analysis, designing and coding STX( Suspicious transaction system ), WTS ( compliance system), FX Ocharlie interface from Oracle Flexcube to Mainframe.
• Coding of many of the complex and challenging Store Procedures and batch programs and integrating wif the online Java screens.
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components.
• Provide temporary and permanent solutions to Production Abends.
• PLATINUM,QMFandSPUFIused to query specific tables for analysis and data validation of DB2 table modificationsbyCOBOL/BatchJCLandOnline modules
• Provide automated Solutions to reduce manual effort on some of the regular tasks.
• Provide code and report walk through for the business users by facilitating various meetings.
• Responsible for Unit Testing in development environment, UAT testing, production implementation and post-install validations for the change.
• Make changes to the DB2 tables using the LOAD/UNLOAD utilities in test and production environments.
• Handle responsibilities of analyzing test results and troubleshooting environment issues
• Oracle Flecube to mainframe interface development involved COBOL Programs, JCLs, PROCs, ISPF/TSO, File-AID, CA Quick Edit and Endevor in IBM ES-3090 under the MVS/ESA operating system, Data base mapping Involved Micro soft Office products, ORACLE DB and ORACLE GI ( Generic Interface) tool.
• Writing Easytrieve/COBOL/JCL programs for generating adhoc reports and extracts from the Oracle Flexcube.
• Provided applications development and support and utilized troubleshooting and diagnostic tools.
• Analyze and performance tune DB2 programs by coordinating wif the DBA.
• Documenting the process of analyzing and fixing production related issues in Abend Log.
• Perform noledge transfer of the entire application to other team members.
• As a project leader, efficiently worked in business and system analysis, project design, development and implementation of the Quantum View Data Base and Quantum View Notify Systems.
• Coordinated technical tasks in development and infrastructure wifin the core and extended team, refined operating processes wif IT staff and the user, managed deployment activities, documented the environment/support and operations procedures.
• Worked wif the development team to brainstorm on solutions, put together estimates and proposals, and directed the work of the development team.

Environment: Mainframes Technologies including COBOL,DB2,JCL, Development Centre, Command line Processor, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, TESTOR, Quality Center.

Confidential, Deerfield, IL

Sr. Mainframe Production Support Executive & Project Lead

Responsibilities:

• Working as a project lead at onsite and providing 24 X 7 production support & maintenance co-coordinating wif the offshore team.
• Perform as mentor and training consultant for new staff exposed to assembler andmainframesystems
• Support the DASD environments that relate to substantial amount of data transfer to and from the mainframe. Implement new file transfer technology and develop supporting routines and exits
• Prepared user documentation and flowchart using WORD, prepared test cases. Running LOAD utilities to refresh test database data from production region. Fixed bug raised in the review process.
• PLATINUM,QMFandSPUFIused to query specific tables for analysis and data validation of DB2 table modificationsbyCOBOL/BatchJCLandOnline modules
• Identify,troubleshootand resolve application issues and code defects ofOraclebased applications, MPX,DB2,MainframeandCICSsystems
• Develop and test batch streams ofJCLexecutingCOBOLcode using my expertise inTSO/ISPF,JCLandCOBOL
• Taking the transition of the application from the SMEs involving the offshore team effectively and preparing an exhaustive transition handbook.
• Coding of many of the complex and challenging batch programs as a part of new enhancements.
• Unit Test the components and record the results to verify if all requirements are met.
• Co-ordinate wif Team for effective integration of Batch Program wif other components.
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.
• System Testing
• Deployment of the code to the production wif all the required documentation.
• Involved in QA Meetings for the code and construction tasks and project planning wif the Client.
• Assigning tasks to offshore team and reviewing all the deliveries and generating status reports.
• Writing programs to automate commonly used manual activities.
• Creating documents of the new programs or code fixes required for the future use of the support team
• Development/ Coding in AS400 and CL
• Query formation and testing of queries using SQL and WRKQRY in AS400.

Environment: Mainframes Technologies including COBOL, VB, FL/SQL, ORACLE, ORACLE FORMS/REPORTS 6I, COM, DCOM, CRYSTAL REPORT JCL, VSAM, CICS, PANVALET, File Manager, TSO/ISPF, IBM Utilities.

Confidential

Responsibilities:

• Working as a project lead at onsite and providing 24 X 7 production support & maintenance co-coordinating wif the offshore team.
• Provide Lead role for testing of old and new systemusing expertise inCOBOL/JCL, PL/SQLandOracle
• Identify, troubleshoot and resolve application issues and code defects of Oracle and Mainframe Systems.
• Taking the transition of the application from the SMEs involving the offshore team effectively and preparing an exhaustive transition handbook.
• Coding of many of the complex and challenging batch programs as a part of new enhancements.
• Unit Test the components and record the results to verify if all requirements are met.
• Co-ordinate wif Team for effective integration of Batch Program wif other components.
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.
• System Testing
• Deployment of the code to the production wif all the required documentation.
• Involved in QA Meetings for the code and construction tasks and project planning wif the Client.
• Assigning tasks to offshore team and reviewing all the deliveries and generating status reports.
• Writing programs to automate commonly used manual activities.
• Creating documents of the new programs or code fixes required for the future use of the support team
• Development/ Coding in AS400 and CL
• Query formation and testing of queries using SQL and WRKQRY in AS400.

Environment: Mainframes Technologies including COBOL, JCL, VSAM, CICS, PANVALET, AS400, File Manager, TSO/ISPF, IBM Utilities.

Confidential, Minneapolis, MN

Mainframe Developer and Tester

Responsibilities:

• Designer and developer on the development of a majormainframesoftware program product related to Advanced Function Printer (AFP) printer technology coding of many of the complex and challenging Store Procedures and batch programs.
• Proactively learned the CA-ADGEN to analyze and migrate the code to COBOL
• Designed the new programs and jobs followed by coding and unit testing
• Provided support from design till end-to-end testing
• Developed a REXX tool to validate the test results of ADGEN programs wif the test results of new COBOL programs
• Performed job scheduling activities like script preparation and job definition in CA7
• My technical responsibility was the design and development of the IBM MVS JES2/JES3 spool to printer output interface, which utilizes the IBM Functional Subsystems Interface Facility (FSI) and SAPI interface
• dis interface enabled the Job Entry Subsystems (JES2 & JES3) to communicate output to All Points Addressable AFP printers.
• The interface was written in assembler language utilizing Supervisor State, Key Zero, and Cross Memory code. The product was called XPAF and enables XEROX printers to compete wif IBM in the all points addressable printing world
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.

Environment: Mainframes Technologies including COBOL, DB2, JCL, REXX, DB2, XPEDITOR, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, Quality Center.

Confidential

Responsibilities:

• Preparing High Level Design documents based on the Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on the High Level Design document.
• Coding of many of the complex and challenging Store Procedures and batch programs.
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.
• Groomed fresher’s, Conducted noledge sharing sessions on Data by Exceptions and complex pagination concepts for fresher.
• System Testing, Mirror Testing

Environment: Mainframes Technologies including COBOL,DB2,JCL, Development Centre, Command line Processor, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, TESTOR, Quality Center.

Confidential

Responsibilities:

• Preparing High Level Design documents based on the Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on the High Level Design document.
• Coding of many of the complex and challenging Store Procedures and batch programs.
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.
• Groomed fresher’s, Conducted noledge sharing sessions on Data by Exceptions and complex pagination concepts for fresher.
• System Testing, Mirror Testing
• Implementation to Integration region

Environment: Mainframes Technologies including COBOL, DB2, JCL, Development Centre, Command line Processor, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, Tester, Quality Center.

Confidential

Responsibilities:

• Preparing High Level Design documents based on the Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on the High Level Design document.
• Coding of many of the complex and challenging Store Procedures and batch programs.
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.

Environment: Mainframes Technologies including COBOL, DB2, JCL, Development Centre, Command line Processor, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, Tester

Confidential

Responsibilities:

• Preparing Low Level Design documents based on the High Level Design document.
• Coding of many of the complex and challenging Store Procedures and batch programs.
• Unit Test the components and record the results to verify if all requirements are met
• Co-ordinate wif Team for effective integration of Batch Program wif other components
• Perform peer reviews for other members in the team
• Perform Regression Testing in case of any change in the code after completion of Unit Testing.

Environment: Mainframes Technologies including COBOL, DB2, JCL, Development Centre, Command line Processor, Platinum, SOFTECH, SPUFI, File-Aid, XPEDITER, Endeavor, Tester, Quality Center