SUMMARY:

• Innovative IT professional with 12+ years experience in IBM Mainframe environment.
• Key Strengths in technology design development and implementations.
• Responsible for the enhancements, developments, maintenance, production support, re - engineering, debugging, testing and documentation phases of this project.
• Domain experience: Almost 7 year experience in healthcare and insurance domain. 2 years in retail business and supply chain business. 1 year experience in child care, Currently working in finance and banking business.
• Competent with demonstrated ability to maintain excellent functioning under pressure.
• Thrive in deadline driven environment.
• Strong knowledge and experience in writing complex SQL and has performed tuning SQL queries. Used tools like Strobe report, DB2 Explain to analyze log running DB2 queries
• Experience in Software Unit Testing, Integration Testing, Regression Testing, performance, configuration and usability testing.
• Active role in requirements review, functional document review, Test Cases review and key resource for UAT phase and production roll-out.
• Created TEST cases and Test Results during SDLC testing phase.
• Experience working in large, complex state governmental social services applications.
• Extensive exposure to working in the healthcare domain.
• Has done documentation like User Requirement spec Document, Technical Design Document, System Test Case document with ISO 9001 quality standards and CMM level3
• Expertise in INSYNC, ADABAS, NATURAL, PANVALET, QMF and FILEAID as testing tools and for data manipulation and Data cleansing.
• Expertise in QA activities like creating Test cases, loading them Mercury Test Director and validating the Test Cases.
• Proficient in using web based scripting language JavaScript and developing front end layouts using HTML.
• Experience in working under stringent deadlines and ability to perform on many occasions to realize project goals.
• Worked on different languages like COBOL, CICS, JAVA Script, HTML, AS400,ASP.NET,C#, Visual Basic.
• Experience in playing a Project lead role for a Team by taking major day to day decision, allocating task and reviewing and interacting with the client.

CORE COMPETENCIES:

• JCL
• COBOL
• Cool Gen
• DB2
• Data Warehousing
• Crystal Report
• VSAM
• QUIKJOB
• Platinum
• EZT+ ( Easytrieve)
• File Aid
• PANVALET
• AS/400
• SQL Server
• ISPF/ CA-7
• Xpeditor
• CHANGEMAN
• UNICENTER & INFRA
• C
• CICS
• Visual Basic (VB)
• ASP
• HTML
• JAVA SCRIPT
• C#

TECHNICAL SKILLS:

Operating Systems: MVS, Z/OS, DOS, Windows Vista/XP/NT/2000, etc.

Tools: TSO, ISPF, VSAM, SNA, Eicon AVIVA, RUMBA, PCOM IBM Products File Manager, Debug Tool, CA Tools File Aid, ABEND Aid, Expeditor, Inter Test, DTF, QMF, SoftTech, Spufi, Platinum, IOF, SAR, TMon, In Sync, Omega Mon, Savers, OPC, CA7, CA1, CA-View, SAR, REXX, CLIST, Docu /Text, Prose, Report View, Sys View, Visio, MF Revolve, VI Editor, MS Office, Visual Studio, Infra

Version Controls: Endeavor/Ned, Changeman, Panvalet, Librarian, ELIPS, Visual source safe

Other: MS Office, Word, Excel, Power Point, Visio, Access, Outlook, PhotoShop, etc

Software Engg/Mgmt: Requirements Gathering, JAD (Joint Analysis and Discussion) sessions, Analysis, Design, Data Modeling, Coding, Testing, SIT - Systems Integration Testing, UAT - User Acceptance Testing, Production Support, User Interaction, Team Management, Reviews, Configuration Management, Quality Assurance and SEI-CMM level Processes.

PROFESSIONAL EXPERIENCE:

Confidential

Developer /Technical Assistance

Responsibilities:

• Understanding requirements for the development and subsequently documenting.
• Unit/System Testing the Release related project
• Perform Release related validation on the Release day.
• Perform maintenance of existing Toys application in COBOL, CICS, DB2, JCL
• Development of new interface for the P/C processor group .This involved creating brand new CICS screens with new functionality to add and delete. Setup new CICS file request, Jobs and COBOL programs
• Develop SQL Queries to query the database to test the back end process of the application-BLUEBOOK.
• Resolve IM tickets raised by the SPSC staff.
• Support front-end C# application and modify DB2 stored procedure calls.
• Provide technical support/guidance to the team member as when required.
• Provide estimate for the upcoming project.

Languages/Tools: IBM Z/OS, OS/390, COBOL, CICS, Changeman, Fault Analyser, DB2, MVS, QMF, SPUFI, JCL, VSAM, Quality Center, FILEAID,FILE MANAGER,C#.

Confidential

Technical Lead Consultant

Responsibilities:

• Understood requirement for the development and subsequently documenting.
• Developed complex SQL Queries to query the database to test the back end process of the application.
• Resolved QC raised by customers.
• Understood the Business and System Functional documents
• Prepared technical specifications for the existing programs and also for enhanced programs
• Involved in production implementation
• Prepared estimates for various tasks.
• Involved in System Testing, Regression and Unit testing.
• Modifying DB2 stored procedures in order to meet the front-end client interface in C# .

Languages/Tools: IBM Z/OS, OS/390, COBOL, CICS, Endevor, INTERTEST, DB2, MVS, QMF, SPUFI,C#,JCL,VSAM,Easytreive,Quality Center

Confidential

Team Member/ Programmer Analyst

Responsibilities:

• Understanding requirement for the development and subsequently documenting.
• Perform maintenance of existing FACES application in COBOL, CICS, DB2, JCL,
• Development of new interface between Family support division and Child support division in JAVA SCRIPT, HTML, COBOL, CICS, DB2,ASP.NET,C#
• Develop SQL Queries to query the database to test the back end process of the application..
• Resolve PRS raised by the Field staff.

Languages/Tools: z/OS, TSO, ISPF, JCL, COBOL, CICS, DB2, MVS, SPUFI, WEBAWARE, JAVA SCRIPT, HTML and XML,COOLGEN,ADABAS,NATURAL

Confidential

Project Lead

Responsibilities:

• Understanding requirement for the development and subsequently documenting.
• Resolving Infras and Remedy tickets
• Resolving Command Center Issues raised by participating Vendors like Virgin.
• Providing 24X7 production support in resolving critical and high-priority abends thus making sure un-interrupted production job cycle.
• Worked on the Member/group eligibility information, Coverage information, Member status, Person information, Provider Network information, Benefit and rate package information etc screens of MetaVance.
• Worked extensively on the process of modifying membership and group information by creating BMI transactions and then uploading them from mainframe to MetaVance.
• Resolve Adhoc queries regarding integration of Metavance membership & group and with related other HUMANA applications.
• Responsible for designing and developing automated reconciliation procedure between MetaVance and Virgin Health miles.
• Developed Web enrollment jobs that were using oracle database procedures to add, update or delete membership/group information through WEB.
• Extensive knowledge of the inter-relation between mainframe tables and the corresponding MetaVance screens.
• Provide Fix for reported program errors Enhancements (Application Modifications as per requirements).
• Monitoring the batch jobs that are run and solving the problems that are encountered during the run in a very narrow span of time render production Support, allowing the Production Cycle to continue.
• Work on Adhoc activities such as creates reports as per user requirements.
• Develop SQL Queries to query the database to test the back end process of the application.
• Create and Modify Reports using Microsoft Reporting Services
• Prepare test cases and test results.
• Load Test cases into Mercury Test Director
• Validate the Test cases by manually running the test cases.
• Lodge defects when test cases fail.

Languages/Tools: COBOL, Coolgen, VSAM, Ezytrieve, CICS, DB2, MVS, SPUFFI, Panvalet, FILE-AID, SQL Server 2000, Crystal Reports. Quick job, ASP.NET,C#.

Confidential, Nashville, TN

Team Member / Team Lead

Responsibilities:

• Execute all the steps of SDLC (Software Development Life cycle).
• Resolving Infras and Remedy by understanding the client's problems.
• Development of new programs, report following the company’s standard.
• Perform System testing for the release as specified by the client
• Allocating the work to the team members and assisting them with technical and business knowledge
• Enhancing and Maintenance of the existing system according to the request received. This included development also whenever required for the system.
• Production support for the module to solve the production abends.
• Responsible to create a web-based application called STATS-UP which was used to upload the Statistics to SQL Server. The Web part was developed in ASP.
• Worked as Onsite Co-coordinator for the 5-digit Unit# project which was completed successfully.
• Quality assurance.
• Work on Adhoc activities such as creates reports as per user requirements, etc.
• Doing Production Support for daily, weekly jobs.
• Reviewing task allocated to the team members
• Prepare test cases and test results.
• Load Test cases into Mercury Test Director
• Validate the Test cases by manually running the test cases.
• Lodge defects when test cases fail.

Languages/Tools: Coolgen, Cobol, CICS, DB2, VSAM, MVS, SPUFI, JCL, CHANGEMAN, FILE-AID, ZEKE, Mercury TEST Director, SQL Server 2000,Crystal Reports

Confidential, Nashville, TN

Programmer Analyst

Responsibilities:

• Impact analyses for a number of DTS packages programs were done and according to it time estimations were calculated.
• Analysis, Modification or Development of DTS packages as per requirement.
• To solve Adhoc queries.
• Monitoring daily Job run.
• Resolving errors occurred due to Job Failure in the daily run.
• Creating/Modifying the Crystal Reports as per requirement.
• Handling Adhoc client request and queries
• Monitoring of the DTS package runs.
• Resolving errors whenever the DTS package job-cycle fails.
• Running re-conciliation process to check if the results match.
• Prepare test cases and test results for QA testing

Languages/Tools: SQL Server 2000, Query Analyser, DTS, Crystal Reports, COBOL, DB2, JCL, VSAM, VB, ASP.NET,C#

Confidential

Programmer Analyst

Responsibilities:

• Involved in building the process and reverse engineer Model. In order to execute the reverse engineering, ‘Bottom up’ approach was used that consisted of execution of the following activities.
• Prepared inventory list of the various components of the existing ‘Operations’ application.
• Involved in analyzing and documenting the components of the existing ‘Operations’ application viz. RPGILE programs, Physical Files, Screen formats, and Report layouts.
• Identification of business processes, of interfaces with Operations application common processes and utilities
• Consolidation of the analysis of the individual components into business rule documents. The total code was of around 400,000 lines and team size was 30 peoples.
• Working on reverse-engineering projects demands understanding the AS/400 code and translating it into readable language.
• Prepare test cases and test results.

Languages/Tools: SQL Server 2000, Crystal Reports, RPG ILE CL/400 and COBOL/4, COBOL, DB2,JCL,VSAM

Confidential

Programmer Analyst

Responsibilities:

• Modification, Development and preparation of Unit Test Plans for testing programs
• Documentation for each stage, according to the project requirements.
• Working on development task based on specification.
• Testing the developed code.
• Preparing test cases and testing detail documentation.

Languages/Tools: SQL Server 2000, Crystal Reports, AS/400, RPG ILE/400,CL/400,COBOL, DB2,JCL,VSAM