SUMMARY

• A dynamic professional with 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 with teh onsite-offshore model that includes all teh SDLC phases, support activities and coordination with teh 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 with 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 with stakeholders and SMEs to assist teh fulfillment of teh project goals and objectives.
• Define and document key business processes.
• Efficient in documenting existing processes, preparing Business Requirement Documents (BRD), analyzing Business Requirements, working with Requirements Traceability Matrices (RTM), re-engineering business processes.
• Facilitated User Acceptability Testing UAT successfully.
• Worked with Analysts, Managers, Developers and Testers for complex projects during teh 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 with proficiency at grasping new technical concepts quickly and utilize teh 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 with teh 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 teh complex and challenging Store Procedures and batch programs and integrating with teh online Java screens.
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with 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 teh regular tasks.
• Provide code and report walk through for teh business users by facilitating various meetings.
• Responsible for Unit Testing in development environment, UAT testing, production implementation and post-install validations for teh change.
• Make changes to teh DB2 tables using teh 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 teh 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 teh Oracle Flexcube.
• Provided applications development and support and utilized troubleshooting and diagnostic tools.
• Analyze and performance tune DB2 programs by coordinating with teh DBA.
• Documenting teh process of analyzing and fixing production related issues in Abend Log.
• Perform noledge transfer of teh entire application to other team members.
• As a project leader, efficiently worked in business and system analysis, project design, development and implementation of teh Quantum View Data Base and Quantum View Notify Systems.
• Coordinated technical tasks in development and infrastructure within teh core and extended team, refined operating processes with IT staff and teh user, managed deployment activities, documented teh environment/support and operations procedures.
• Worked with teh development team to brainstorm on solutions, put together estimates and proposals, and directed teh work of teh 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 with teh offshore team.
• Perform as mentor and training consultant for new staff exposed to assembler andmainframesystems
• Support teh DASD environments that relate to substantial amount of data transfer to and from teh 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 teh 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 teh transition of teh application from teh SMEs involving teh offshore team TEMPeffectively and preparing an exhaustive transition handbook.
• Coding of many of teh complex and challenging batch programs as a part of new enhancements.
• Unit Test teh components and record teh results to verify if all requirements are met.
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components.
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh code after completion of Unit Testing.
• System Testing
• Deployment of teh code to teh production with all teh required documentation.
• Involved in QA Meetings for teh code and construction tasks and project planning with teh Client.
• Assigning tasks to offshore team and reviewing all teh deliveries and generating status reports.
• Writing programs to automate commonly used manual activities.
• Creating documents of teh new programs or code fixes required for teh future use of teh 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 with teh 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 teh transition of teh application from teh SMEs involving teh offshore team TEMPeffectively and preparing an exhaustive transition handbook.
• Coding of many of teh complex and challenging batch programs as a part of new enhancements.
• Unit Test teh components and record teh results to verify if all requirements are met.
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components.
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh code after completion of Unit Testing.
• System Testing
• Deployment of teh code to teh production with all teh required documentation.
• Involved in QA Meetings for teh code and construction tasks and project planning with teh Client.
• Assigning tasks to offshore team and reviewing all teh deliveries and generating status reports.
• Writing programs to automate commonly used manual activities.
• Creating documents of teh new programs or code fixes required for teh future use of teh 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 teh development of a majormainframesoftware program product related to Advanced Function Printer (AFP) printer technology coding of many of teh complex and challenging Store Procedures and batch programs.
• Proactively learned teh CA-ADGEN to analyze and migrate teh code to COBOL
• Designed teh 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 teh test results of ADGEN programs with teh test results of new COBOL programs
• Performed job scheduling activities like script preparation and job definition in CA7
• My technical responsibility was teh design and development of teh IBM MVS JES2/JES3 spool to printer output interface, which utilizes teh IBM Functional Subsystems Interface Facility (FSI) and SAPI interface
• dis interface enabled teh Job Entry Subsystems (JES2 & JES3) to communicate output to All Points Addressable AFP printers.
• Teh interface was written in assembler language utilizing Supervisor State, Key Zero, and Cross Memory code. Teh product was called XPAF and enables XEROX printers to compete with IBM in teh all points addressable printing world
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh 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 teh Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on teh High Level Design document.
• Coding of many of teh complex and challenging Store Procedures and batch programs.
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh 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 teh Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on teh High Level Design document.
• Coding of many of teh complex and challenging Store Procedures and batch programs.
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh 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 teh Functional Specification document passed on from Onsite Team.
• Preparing Low Level Design documents based on teh High Level Design document.
• Coding of many of teh complex and challenging Store Procedures and batch programs.
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh 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 teh High Level Design document.
• Coding of many of teh complex and challenging Store Procedures and batch programs.
• Unit Test teh components and record teh results to verify if all requirements are met
• Co-ordinate with Team for TEMPeffective integration of Batch Program with other components
• Perform peer reviews for other members in teh team
• Perform Regression Testing in case of any change in teh 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