SUMMARY

• Over 10 years of experience in Mainframe Technology including analysis, design, development, test, implementation, integration and support on mainframe.
• Experience in Bank, Credit card, Retail & Automotive industry system development.
• Experience in SDLC methodologies and understanding of Agile methodology.
• Expertise in obtaining project requirements from business Analyst, user and manager and formulating the requirements into functional and technical specifications.
• Proficient in IBM Mainframe Technologies such as COBOL, JCL, DB2, CICS,VSAM, NATURAL and tools using XPEDITOR, INTERTEST, SMARTEST, FILEAID, CHANGEMAN, PANVALET, ENDEVOR, TSO/ISPF in MVS, ROSCOE environment and has enough working experience in Ms SQL Server, Microsoft Visual Basic.
• Expertise in project documentation, flow charts and diagrams using EXCEL, WORD, VISIO, POWERPOINT and ACCESS.
• Versatile experience in providing 24X7 on call support.
• Good Programming and Communication Skills with excellent work ethics, easy adaptability to demanding time schedules coupled with positive user interaction and excellent team spirit.
• Exceptional ability to quickly master new concepts.

TECHNICAL SKILLS

Languages: COBOL, JCL, VB,NATURAL, PL1, JAVA, C, C++, FORTRAN, PASCAL, Quickjob.

OLTPS: CICS.

Files: VSAM, ADABAS.

Version Controller: CHANGEMAN, PANVALET, ENDEVOR.

Debugger Tools: SMARTTEST, XPEDITER and INTERTEST& VB - IDE.

Databases: DB2, MS SQL SERVER,, ORACLE.

Database Tools: SPUFI, FILE-AID/DB2, QMF, PALTINAM.

File Tools: FILE-AID, STARTOOLS.

Scheduler: AJS, CA-7, GUI-IDE, VB.

MS Office: OUTLOOK, EXCEL, POWER POINT, WORD, PROJECT, ACCESS, VISIO

Web Related: HTML, FLASH, VB/JAVA Scripts.

Tools: BMC, ABEND-AID, QUICKREF (QC), MQSERIES, SAR, SARG, ABACUS, SYNC SORT, CRYSTAL REPORT and FTP.

Operating Systems: WINDOWS X 95 XP NT, UNIX & LINUX, OS/390.

Hardware: IBM S/390, PENTIUM PC, IBM COMPATIBLES.

PROFESSIONAL EXPERIENCE

Confidential, Enon, OH

Developer

Responsibilities:

• Analysis of the specifications provided by the clients, Analysis the programs, Impact analysis.
• Coordinating with the Business Analyst and users on the client requirements.
• Create understanding document, Detail design document.
• Provide estimation for new development/enhancement.
• Develop new COBOL/DB2/Natural/PL1 programs, jobs for new merger Clients HESS, Wilco.
• Modify the Confidential existing COBOL/DB2/Natural/PL1 programs.
• Testing (unit testing, Integration testing, system testing)
• Gets development approval from business user on PPM.
• Retrieve program production using PANVALET if it is new program create stub using AMP.
• Analysis, Create or modify program in ROSE, TROSE.
• Compile, debug, and test the program using .SPA, STOW.
• Document test case, test results, job flow, flow charts on HP QC using MS Word, Visio.
• Get email approval from business user, MTP (move to production) approval PPM.
• Special compile for production source, load using .SPA, NATMOVE.
• Register the components details on AMP for deployment.
• Create QA deployment request for HP, get AMP approval for UB31.
• Performed After deployment support.
• Log the incidents, enhancement, and development on GEMINI.
• On call support pager.
• Investigate incidents, resolve the incidents& find root cause analysis.

Environment: COBOL,DB2,NATURAL,PL-1, JCL, ADABAS,CICS,VSAM,TSO/ISPF/PDF,CA-7,PANVALET,FTP, ROSCOE,AMP, SPA, DATAMOVR, NATMOVE, HP QC, SAR, JEMINI,IRIS and PPM (Project portfolio management), OS/390,Windows XP,IBM S/390, IBM z/OS, Pentium PC, IBM Compatibles

Confidential, SMYRNA, TN

Mainframe Tech Lead

Responsibilities:

• Developed new COBOL/DB2/CISCS programs using PANVALET, Developed new JCL using TSO/ISPF.
• Receiving incident tickets (SEV1, SEV2, and SEV3 & Service) from application group for batch Job/ Online ABEND’s.
• Acknowledging and working on high priority tickets (SEV1 & SEV2) for Job/Online ABENDs using REMEDY tool.
• Identifying batch Job ABEND dumps details, using SAR; Online ABENDs are using ABEND-AID, compiled source listing obtained for Online/Batch programs using SARG.
• Tracing missed SAP file from MQ and Mainframe to MQ are identified, Creating SPR and run job, resend the file to SAP, Based on SAP file information, the respective job is identified from PRO tool or search utility.
• Analyzing COBOL/DB2/CISCS programs, modifying it using PANVALET, Jobs are modified and placed in SPEC Library for problem areas.
• Manipulating data in file/VSAM file using File-AID.
• Retrieving the members from production, LOCK/UNLOCK, Compare the PROD and Development, Scan, and Rename members using PANVALET.
• Compiling and scan for programs using Programmer's Toolbox.
• Debugging Online and batch programs using SMARTTEST.
• Identifying check pending tables using DB2 command option.
• Created JCL for DB2 Repair check pending status for the table spaces.
• Refreshing the DB2 tables using DB2 utilities, UNLOAD data from DB2 table image copy to GDG file and LOAD data into testing environment tables.
• Writing embedded SQL in COBOL programs and test SQL in SPUFI before place it into program.
• Creating, modifying, customizing data and extracting, loading the table using DB2 File AID and it’s utilities.
• Identifying table space, Plan, Database, Image copy, Dataset, Index, package for tables using BMC CATALOG MANAGER for DB2.
• Writing SQL DB2 queries in batch jobs for data manipulation in the PROD. Environment.
• Wrote DB2 Bind/Dual Bind jobs for test and production environment.
• Run the job from SPEC JCL for Special Run.
• Updating incidents in Remedy for job ABENDS.
• Resolving ABEND’s and updates resolution method in remedy and closing the tickets.
• Assigning Tickets to offshore team based on less severity tickets SEV3 & SEV4.
• Mentoring offshore team to solve the issues in terms of COBOL/CICS/DB2 programs, JCL/PROC/PARM/FTP’s
• Created CRA for moving components to prod. System.
• Created change, scheduling the change, providing working info, getting approval from BA (business Analyst) and coordinating change in Remedy change management.
• Assigned task to HP team, Scheduler team for moving the components from Test to Prod.
• Represented change management meeting for all the changes made to the components.
• Supporting change management team to move the components to prod.
• Creating Enhancement work orders.
• Editing/Listing NMM1 Mainframe components using version control CA-ENDEVOR tool.
• Creating packages to move the components in prod. Using CA-ENDEVOR.
• Download what if Audit report from Mainframe for VIMS application sent to users and run What if process for user request.
• Referred online documents support using QuickRef.
• Monitoring Jobs, from PROD libraries, SPEC Libraries, Skeleton jobs, check predecessors, Restarted jobs, Abended Jobs are using CA7 tool in production environment. The Prod. Environment includes two LPAR’s (NMM1 Manufacturing & NMC1 Headquarters).

Environment: COBOL, JCL,NATURAL, DB2, ADABAS,IMS-DB, CICS, VSAM,TSO/ISPF/PDF, CA-7, PANVALET, SPUFI, FILEAID, ENDEVOR, FTP, REMEDY, OS/390,Windows XP,IBM S/390, IBM z/OS, Pentium PC, IBM Compatibles

Confidential

Module Lead

Responsibilities:

• Analyzing SOW and user specifications and creating new COBOL/DB2 programs and modifying existing programs according for migrate financial data from Host to SAP.
• Migrated from Flat Vehicle billing file system into DB2.
• Prepared DDL for shared event queue and shared event queue detail tables.
• Created LLD document for a new program and modified program.
• Developed a new COBOL/DB2 program for and modified three programs.
• Wrote ADABAS Query to connect, fetch model, VIN information from CV ABABAS file.
• Develped SQL query, CUROSR for Vehicle contract information, sales event information, Vehicle information, and Vehicle receivable information for company vehicles.
• Define ZAIN and ZADR event for Vehicle sold and reversal in the program and event tables.
• Wrote Restart logic using DB2 SQL queries.
• Set up the UAT test data for various conditions for Sold vehicle and reversed vehicles for Confidential and NMAC vehicles.
• Created NMAC billing file for FTP and inserted Confidential billing record into the event tables.
• Uploaded Unit Test conditions and Unit Test results in HP QC and Resolve tools.
• Responsible for overseeing the Quality procedures related to the project (QC & Resolve) for team.
• Define new PARM and PROC and modified job steps to accommodate new program.
• Handled two member team and trained, assigned task to them, review assigned items.

Environment: COBOL, JCL, DB2, VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID, FTP, OS/390, Windows XP, IBM S/390, Pentium PC, IBM Compatibles.

Confidential

Module lead

Responsibilities:

• Wrote LLD for business lane NML, NMX.
• Developed 3 new programs for each business lane NML, NMX.
• Developed SQL CURSOR for header details, Part inventory details and invalid part details.
• Developed SQL query for invoice details, buyer details, country origin, part description.
• Developed SQL query for ISF validation (shipping to address, vanning location address, consolidator address and shipment management)
• Developed SQL query for buyer code, loading port code, Final destination code, shipping method code and its validation.
• Heavy use of SPUFI.
• Used PANVALET tool to create and modify the COBOL/DB2 codes.
• Interacted with Dot Net Team for CS for ITAG users to modify failed ISF conditions by host.
• Responsible for overseeing the Quality procedures related to the project (QC & Resolve).
• Modified the job step for Pre ASN file, if the file is empty, email notification will be sent to EI users.
• Created new job extracts for ISF validation are passed’ I’ and failed ‘J’, and passed validation FTP’d to EI
• Created new job Failed ISF validation, which will be reprocessed by client server team (ITAG users), updated part details will be reprocessed and successful will be FTP’d to EI.
• Setup the test data for UAT testing for various conditions as per the business direction.
• Created CRA, CMT and got the business approval for deployment.
• Post Implementation support.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients.
• Design - Understanding & DD.
• Developed new programs for EV vehicles.
• Testing - Unit testing & System testing.
• Data setup for System Testing & UAT.
• Worked in this module for resource substitute.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Module Lead

Responsibilities:

• Analysis of the specifications provided by the clients.
• Prepared understanding document and LLD document.
• APR confirmation process - JOB, PARM, PROC.
• Testing - Unit testing & System testing.
• Debug online program and batch using SMART TEST.
• Interacted with Builder Team for Builder to HOST interface (Procedural gateway).
• Developed/Modified online program to accommodate new sales type APR.
• Rectified data coming from client server Builder.
• Data setup for System Testing & UAT.
• Responsible for overseeing the Quality procedures related to the project (QC & Resolve).
• CRA & CMT.
• Deployment Plan.
• Post Implementation support.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Interacted with JAVA team to replaced green screen with Java front end.
• Capture the order details data using defined OMS transactions.
• Analysis of the specifications
• Design- Understanding & DD and Coding.
• Developed new programs for order cycles.
• Testing - Unit testing & System testing.
• Debug data from HOST interface (Host Bridge).
• Data setup for System Testing.
• Responsible for overseeing the Quality procedures related to the project (QC & Resolve).
• Implementation support.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients
• Design - Understanding & DD.
• Create packages; check out the programs for code changes using change man.
• Stage PARM, PROC, JCL and Programs.
• Developed new programs/modify the existing program.
• Auditing, Freezing and approving the package using change man.
• Testing - Unit testing & System Testing.
• Created new DB2/SQL Jobs for LACD & APD.
• New Jobs scheduled in AJS (Automatic Job Scheduler).
• Interacted with SAP Team.
• Data setup for System Testing.
• Responsible for overseeing the Quality procedures related to the project.

Environment: COBOL, JCL,CICS, DB2,VSAM, Quikjob, CHANGEMAN, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients
• Design - Understanding & DD.
• Create packages; check out the programs for code changes using change man.
• Stage PARM, PROC, JCL and Programs.
• Developed new programs/Modify the existing programs for third party vendor product.
• Auditing, Freezing and approving the package using change man.
• Monitor the baseline while production deployment.
• Testing - Unit testing & System testing.
• Interacted with Falcon Interface team.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients
• Design - Understanding & DD.
• Developed new program/Modified existing programs MB-ESP.
• Debug the CICS program using INTERTEST.
• Testing - Unit testing.
• Data setup for System Testing.
• Responsible for overseeing the Quality procedures related to the project.

Environment: COBOL, JCL,CICS, DB2,VSAM, PANVALET, SMARTTEST, SPUFI, FILEAID,FTP, FILE, AID for DB2, OS/390,Windows XP,IBM S/390, Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the specifications provided by the clients.
• Created detail design document.
• Developed new programs/Modified existing programs for PAP.
• Testing - Unit testing.
• Peer Code Review.

Environment: VB 6.0, SQL Server, Crystal Report,VB-IDE,Windows NT,Pentium PC, IBM Compatibles

Confidential

Team Member

Responsibilities:

• Analysis of the regional program specifications provided by the clients.
• Created high level design document.
• Developed new programs.
• Unit tested new/regional programs.
• Peer Code Review.

Environment: VB 6.0, SQL Server, Crystal Report,VB-IDE,Windows NT,Pentium PC, IBM Compatibles

Confidential

Team Member.

Responsibilities:

• Created high level design based on specification document.
• Created low level document for renewal function.
• Modified renewal programs.
• Unit tested expiry/renewal/MIS programs.
• Peer Code Review.

Environment: VB 6.0, SQL Server, Crystal Report,VB-IDE,Windows NT,Pentium PC, IBM Compatibles