PROFILE:

• 6 + Years of Total IT Experience.
• 6 + Years of HP - Quality Center 9.2 Experience.
• 2 + Years of Test Manager Experience.
• 2 + Years of Microsoft Visual Studio and TFS experience.
• 1 + Years of MVC testing.
• 4 + Years of Mainframes Testing Experience.
• 2 + Years of Web Based Testing Experience.
• 6 + Years of DB2 Experience.
• 6 + Years of CICS Experience.
• 5 + Years of DB2 stored Procedure Experience.
• 3 + Years of IMS DB /DC Experience.
• 3 + Years of REXX Experience.

SUMMARY:

• Expertise in manual testing of Mainframe Applications, Web Based Applications.
• Strong expertise in SQL and DB2 Databases.
• Strong domain knowledge in Healthcare, esp., Claims Administration, Enrollment and Eligibility Modules and Mutual Fund Applications esp. TRAC and TA2000 .
• Proficient in creating Technical Specification based on Functional Requirements and High Level Specs.
• Proficient in creating Test Plans, Test Design and Test Cases based on Functional Requirements and technical Specifications.
• Proficient in preparing Project Plan and Resource allocation.
• Experienced in preparing the Metrics, Defect Reports, CAR and DAR.
• Strong knowledge on SDLC and STLC methodologies.
• Strengths include strong customer interface and problem-solving skills, estimations, requirement analysis, designing, programming and testing.
• Good Team player, Dependable Resource and ability to learn new Tools and Software quickly as required.
• Experience in developing REXX, CLIST and VB macros for aiding data entry and validations in Mainframe Testing.
• Expertise in scheduling jobs and application through OPC (Tivoli Workload Scheduler).
• Support CA-Deliver/Express Delivery, OPC Scheduling, SAR, TSO. Resolution of JCL distribution conflicts within OPC and Express Delivery.
• Experience on reporting tool EASYTRIEVE and debugging tools EXPEDITOR and ABEND-AID.
• Experience in file transfer using NDM Connect: Direct.
• Experience using ENDEAVOR and CHANGEMAN to compile and update all programs in production.
• Expertise in Manual Testing of Web applications.
• Experienced in setting up Automation for stable Web applications using Selenium Web driver with NUnit/Eclipse.
• Expertise in SQL Server 2008 R2 database.
• Coded many SQL queries and Stored procs to validate data.
• Expertise in deploying MVC applications locally and doing a sanity check before deploying into test environment.
• Experienced in testing an application in various browsers for identifying the compatibility issues.

TECHNICAL SKILLS:

Hardware: IBM-3090, IBM ES/9000 and IBM Compatibles

Operating Systems: MVS, CICS, MS-DOS, UNIX, WINDOWS95/98/2000/XP/NT

Languages: COBOLz, JCL, REXX, CLIST, SQL, C,C++,Java, XML, .NET MVC

DBMS: DB2, IMS DB, SQL Server 2008

File Organization: VSAM, PS, PDS

Tools: TSO/ISPF, File Aid, SDF II, QMF, SPUFI, SAR, Expediter, NDM, FTP, CA - Panvalet, STROBES, Omegamon, Trace Master, PRO/JCL, EASYTRIEVE PLUS, Foundation Views, Selenium RC, NUnit, Eclipse, SOAP UI, Fiddler, QTP

Scheduling Tools: OPC, CA7, Control-M, SQL Server Agent for Job Scheduling

Configuration Management: Endeavor, Change Man, Share point. Tortoise SVN, Microsoft Visual Studio

Test Management Tools: HP Mercury Center, CA- Quality Centre, Microsoft Test Manager and Visual Studio, Team Foundation Server (TFS).

PROFESSIONAL EXPERIENCE:

Confidential, Orange County, CA

QA Test Lead

Test Management Tool: Microsoft Test Manager/Team Foundation Server

Development Language: MVC .NET

Database Used: SQL Server 2008 R2

Life Cycle: AGILE Methodology

Responsibilities:

• Responsible for streamlining Business Requirements and Developing Detailed Design documents.
• Analyzing Metadata, Understanding the Production Database (PPF) and identifying the referential integrities and application relationships between all the tables in the Production Database.
• Develop, maintain, and support validation-related automation tools and test technology.
• Prepare RTM
• Project following an Agile methodology, responsible for Scrum Meetings and updating the status of scrum to State periodically.
• Support EDI testing, UAT Testing by Carrier/State clients.
• Hands on in Soap UI and Fiddler
• Hands on in GP database in payment and Invoice postings.
• Setting up Automation framework using Selenium and NUnit.
• Write the SQL queries/Stored Procs for data validation.
• Perform Local testing by Deploying MVS solution locally and do a sanity check
• Work closely with Carriers and help them have their EDI’s for validation.
• Involved in preparation of Test Plan, Test design and Test Case reviews
• Write SQL Queries in order to perform data validation and also develop Stored Procedures.
• Setting up and perform Defect Triage calls involving all stakeholders

Confidential, New Bury Park, CA

QA Test Lead

Test Management Tool: Quality Centre 9.2

Versioning Tool: CHANGEMAN for Code, SHARE POINT Server for Test Documents

Development Language: COBOL, CICS, JCL, REXX

Database Used: DB2, IMS DB/DC, DATAQUERY

Life Cycle: Water Fall Model

Responsibilities:

• Responsible for Develop Detailed Design document and updating the RTM.
• Responsible for preparing Test Plan, Test Design Document.
• Responsible for reviewing the Test cases and Test Data.
• Planning and executing System Integration Testing, Integration testing and supporting User Acceptance testing.
• Coordinating with the On-site project counterpart and provide necessary inputs to Off-shore team.
• Validate the scheduled Jobs Cycle and dependencies.
• Execute the jobs and help the team validate the test results.
• Developed Excel Macros with interconnecting to Mainframe Box for keying-in data and capturing screenshots for validation.
• Developed REXX tools for validating code against the Standards.
• Setting up Defect-Triage meeting with responsible parties.
• Responsible for CAR and DAR for the project.
• In addition to the regular activities, developed a Knowledge sharing portal for the resources using Sharepoint.

Confidential, Kansas City, MO

QA Test Lead

Versioning Tool: CHANGEMAN for Code, SVN Tortoise for Test Documents

Development Language: COBOL, CICS, JCL, REXX

Database Used: DB2

Life Cycle: Water Fall Model

Responsibilities:

• Understanding the business and the technology of the existing TA product.
• Understanding the impact of the change happening to the system i.e., doing Impact Analysis.
• Analysis, Preparing the Test Conditions, Test Cases and Test Data for the System testing, Regression testing, Integration testing.
• Working and interacting with the onsite team (Kansas City) and also with the offshore support, development team and QA Hengtian teams.
• Rewriting the existing Stored Procedures to meet the new business functionality being implemented
• Designed and involved in coding of DB2 Stored Procedures.
• Doing functional and technical reviews
• Delegation of work to the team, monitoring the load.
• Support to the testing team for Integration/UAT/Production Support
• KT sessions on Functionality of the System to new joiners and also about the processes to be followed for the Project.
• Planning and executing Integration testing and supporting User Acceptance testing conducted by Kansas City Team.
• Coordinating with the Offshore Team Assisting in Knowledge Transfer for the project.
• Coordinated the movement of code changes to development and production environments.

Confidential, Hartford, CT

QA Test Engineer

Test Management Tool: Quality Centre 9.2

Versioning Tool: Endeavor for Code, SHARE POINT Server for Test Documents

Development Language: COBOL, CICS, JCL, REXX

Database Used: DB2, IMS DB/DC

Life Cycle: Water Fall Model

Responsibilities:

• Responsible for requirement gathering, low level Design, and Estimation.
• Involved in COBOL Coded programs testing using JCL Jobs.
• Understanding the impact of the change happening to the system i.e., doing Impact Analysis.
• Analysis, Preparing the Test Conditions, Test Cases and Test Data for the System testing, Regression testing, Integration testing.
• Develop REXX tools to replicate Jobs for all the segments of System.
• Develop Excel Macros for loading and Extracting data into Foundation view tables.
• Testing of Foundation Views
• Testing CICS screens.