SUMMARY

• More than 8 years of QA UAT Life cycle experience (Manual and Automated) in testing applications using Mercury Interactive Tools in Banking/Financial, Insurance,Telecom and Retail domains
• Involved in developing Test Plans, Test Cases, Test Scripts, Traceability Matrix and Test Environments and analyzing Test Results.
• Experience in in Analysis, Design, Coding, Testing & Production Support of application software in Mainframe platform.
• Designing the mainframe security via RACF, Vanguard for various Systems/Applications.
• Monitoring and auditing the various activities of the users, developers on LPAR using vanguard, TSS and ACF2 and RACF reports and reporting the same and following up to get the security event resolved.
• Mainframe Tester and developer with progressive experience in application testing, development and support to batch processes hosted on an IBM mainframe.
• Executed the role of a team lead. Involved in testing the batch applications (black box and system testing), analysis, design and coding.
• Experience in Selenium IDE (HTML, Python, Junit, C# scripting methods)
• Establish and maintain Test Plans, Test - Case Designs, Test Scripts, Test data requirements, and Data Conditioning based on user needs and functional specifications on complex problems and requirements.
• Performed Functional testing, regression testing, performance testing, load testing, white box testing and black box testing using QTP tool.
• Expert in PERL, UNIX Shell Scripting
• Performed Black box testing, White box testing, Grey box testing, GUI Testing, Unit testing, Integration testing and System testing.
• Experienced in AS400 Testing, Validation Testing. Good understanding of all the phases of Software Development Life Cycle (SDLC).
• Strong in defining and execution test scenarios & test cases based on system specifications and functional requirements documents provided
• Proficient in using Rational Clear Quest for Defect Reporting, Tracking and bug management.
• Extensive knowledge of Software Development Life Cycle (SDLC) and Test Methodologies and test processes
• Excellent skills in Teradata, DB2, SQL Server and Oracle 9i/8i RDBMS.
• Extensive knowledge and experience in COBOL,CICS,JCL,SQL,DB2,VSAM,FILE-AID TSO/ISPF, Vanguard, IBM UTILITIES.
• Maintain accounts to control access to information systems/applications, analyze and resolve problems related to mainframe access control, user administration, and operating level system security.
• Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows, UNIX and Linux.
• Experience in testing and writing SQL and PL/SQL statements
• Experience in software testing and system design and requirement analysis. Well versed with Black Box testing, Functional testing, GUI testing, System testing, Integration testing, Performance Testing, Security testing, performance, Load and Regression testing.
• Good Experience in using tools HP Quality Center (QC), HP Quick Test Pro (QTP).
• Experience with version control, change control, and release management and experience with the configuration management.
• Experience in Testing Database Applications (ORACLE 8i/9i, DB2, MS SQL Server, Sybase and MS Access).
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Interacting with End users and gathering requirements to develop URS and QA Testing Strategy.
• Have good experience in performing Verification and Validation activities. This includes preparation of test scripts, step-by-step execution of test scripts, consolidation and reporting the bugs as per severity.
• Worked closely with test analysts, developers, support group to ensure test environment and data readiness.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Excellent communication and inter-personal skill, self-motivated, detail oriented, time bound, responsible team player and ability to coordinate in a team environment to maintain effective team relationship.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 95/98/NT/2000/XP

Databases: Oracle 10g/9i/8i and MS Access, SQL Server 2005, TOAD

Programming Languages: C, and C++, Java, COBOL, JCL, SQL, CLIST, REXX (TSO, VM and OS/2), EASYTRIEVE, QUIKJOB, Pascal.

GUI: Developer 6, Developer/2000, Visual Basic 6.0

T est Scripting: TSL, Java/J2Escript, and VB script, Shell script, ASP.NET

Testing Tools: Selenium Web Driver, Selenium IDE, Win Runner8.x, QTP,Jira and Load Runner 8.x, HP QC

Web Languages: HTML, DHTML, ASP, XML, ASP.Net

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Sr Quality Analyst

Responsibilities:

• Analyzing and reviewing the user/business requirements and functional specs documents.
• Analyzed the Test Scenarios and Conditions for each cycle.
• Performed functional, performance and system tests of IBM’s mainframe and desktop printing application software in MVS, VM, VSE and OS/2 environments.
• Performed manual quality assurance procedures and Automated tests using Selenium WebDriver and TestNG
• Assign the tasks of creating bug reports and performing tracking testing of systems.
• Performed data validation and mainframe testing in interactive mainframe environment.
• Handled the tasks of cross-system testing and prepared test cases for the project team.
• Responsible for executing and maintaining scripts in mainframe applications.
• Assigned responsibilities of planning test strategies and executing test cases in mainframe environment.
• Maintaining and supporting the administration on different Mainframe LPARS of client.
• Providing CICS transaction access to users based on the requests.
• Creating groups, dataset profiles, security rules for dataset profiles and CICS transactions, DB2 groups.
• Running DB2 Utilities like Load, Unload, Re-org, Repair, Rebuild.
• Use the Selenium WebDriver to run test cases in different browsers.
• Protecting datasets on DASD and TAPE.
• Granting DB2 group access and resolving abends.
• Granting user's access to various CICS transactions, creating new transactions for CICS via RACF.
• Resolve the RACF /access issues when the production jobs / user face any access issues.
• Executing JCLs for the daily termination jobs and creating new users.
• Manage and participate in projects to implement information security platforms
• Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing).
• Performed both Black Box Testing and White Box Testing. Used Selenium RC for testing different browser, Selenium Grid for checking instance of server and Selenium IDE for record and playback.
• Involved in writing test plans, written test cases manually, for functional testing purposes. Written detailed test plans and performed functional tests manually
• Have Worked On Validation,AS400,Web and BPT Testing
• Written QTP scripts to compare summary and detail values of the bill invoice in pdf format with the corresponding values and aggregates in the database.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server
• Prepared the Test data (Input files) for interpreting the Positive/negative/regression results based on the design requirements.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
• Written UNIX AWK Scripts to manipulate test data and input files
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Performed testing on web services using SOAP UI 2.0 for Remitter Services, Beneficiary Services, Remittance Services and Dispute Services
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Extracted data from various sources like Oracle, flat files and SQL Server20052005
• Performed Black-Box Testing and Non-Functional Testing.
• Used the T-SQL’s and verified the SQL Server database for the purpose of data verification.
• Involved in validating the data, which has been populated into the database tables using SQL Server Management Studio Interface
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Created and executed QTP test scripts for regression runs for CIV Sales and CICCT.
• Extensively worked as SOA testing and followed by Agile methodology
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Used Clear Quest for defect tracking and reporting.
• Participate in change management team.

Environment: HP Quality Center (ALM) 11.0, HP Quick Test Professional 11.0, Clear Quest, Selenium WebDriverClear Case, Agile, MS SQL 2008/2005, Oracle 10g, Unix, T-SQL, MS-office Excel, SOAP, XML, AS400, COBOL/CICS/VSAM/DB2, RACF JCL, Windows XP, SAS/SQL, SQL, PL/SQL, SOAP UI, Shell, Perl, Load Runner, Performance Tester.

Confidential, Austin, TX

Quality Coordinator

Responsibilities:

• Analyzing and reviewing the user/business requirements and functional specs documents.
• Analyzed business and functional requirements in order to support the Loan PC, PC debt and T-deals work stream.
• Maintained Requirements Traceability Matrix (RTM)
• Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Perform User Acceptance Testing with UAT test scenarios.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing
• Performed the Automated testing by using Selenium, QTP
• Used the check points to enhance the scripts of the testing in Selenium IDE, QTP
• Participated in writing HLS (High Level Scenarios) Test Plans, Test Strategies, Test Scenarios and Test Cases from business and functional requirement documents.
• Involved in writing test plans, written test cases manually, for functional testing purpose and Stored in HP Quality Center.
• Developed SQL Stored Procedures and Queries for Back end testing.
• Performed manual testing to conduct backend testing using UNIX commands and SQL Queries
• Wrote complex SQL queries to perform the backend testing of the Oracle database using SQL developer and UNIX commands.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Creating the policies in various AS400 environments to ensure the consistent behavior.
• Worked with PERL control structures & Regular Expressions for substitutions based on matches.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables
• Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning
• Written detailed test plans and performed functional tests manually.
• Done Data Driven Test with Quick Test Professional (QTP) to test the application for different sets of data.
• Reported bugs and tracked defects using Quality Center (Test Director)
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts.
• Prepared the Test data (Input files) for interpreting the Positive/negative/regression results based on the design requirements.
• Performed Black-Box Testing and Functional Testing.
• Very strong SQL skills and experience with OLAP. Expertise in data-driven testing, drill down applications, writing test cases and test scripts
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Used the SQL’s and verified the Oracle database for the purpose of data verification.
• Involved in validating the data, which has been populated into the database tables using DB Visualizer Interface
• Exposure to various different Unix servers to validate the outputs and writing SQL statements to validate the output in the different databases s
• Used HP QC 9.0 to store Test Plans, Test Cases, Test Scripts and for defect tracking and reporting

Environment: HP Quality Center ALM 9.2, Clear Quest, Clear Case, HP Quick Test Professional 9.2 (QTP), Oracle 10g, TOAD, RDBMS, MS-office Excel, Unix, PL/SQL, PERL, Shell Script, Load Runner, Performance Tester Windows XP, XML, AS400, SOAP, MS SQL 2008/2005 SSRS, SSAS, SOAP UI

Confidential, Richfield, MN

Test Lead

Responsibilities:

• Involved in writing test plans and test cases using requirements and use case documents and business requirement documents.
• Worked with PERL for file manipulations
• Created Test Strategy and Test plan for the testing effort.
• Created UAT test cases and scenarios based on Use Cases, and made sure that UAT test cases meets the business requirements
• Assisted in System Test and UAT testing scenarios as required
• Conducted Smoke, Gray box, Non Functional, Functional, System level testing and Integration testing
• Maintained Requirements Traceability Matrix (RTM).
• Wrote the user defined functions in QTP script usable Actions by using Quick Test Pro.
• Wrote Descriptive programming in QTP using VB Script.
• Wrote UNIX Shell Scripts.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Verified data integrity by Backend testing of the application by writing SQL queries
• Played a major part in testing and timely delivery of the product.
• Performed black box functional, data driven, database GUI and cross browser testing.
• Created GUI maps, data-driven tests and synchronization points in Win Runner TSL script to verify key functionalities.
• Involved in testing of GUI by inserting checkpoints in Win Runner TSL scripts for single or multiple objects and text.
• Performed backend testing using SQL Queries and UNIX SHELL SCRIPT
• Written detailed test plans and performed functional tests manually.
• Reported software mismatches (from the test planning), to the development team using HP Quality Center
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Prepared the Test data (Input files) for interpreting the Positive/negative/regression results based on the design requirements.
• Quality Center used for Test Cases development and test execution status tracking
• Used Load Runner to check the source of performance delay: network or client delays, CPU performance, I/O delays, or issues with database server.
• Performed UAT testing for each UAT release build.
• Used SQL for Querying the DB2 database in UNIX environment
• Provided back end testing for database auditing and data validation using SQL scripts.
• Tracked bugs using Test Director and generated the defect reports for review by the client and the management teams
• Generated testing reports and metrics, trend graphs according to the test plan.

Environment: Environment: Load Runner, HP QTP 9.0, HP Quality Center 9.0, EJB, MDB, XML HTML, MS SQL, HTTP, Eclipse, Clear Quest, Clear Case, MSSQL Server, SOAP UI,JBoss-4.0, Windows Perl and UNIX Shell Scripting, Perl, Load Runner, Performance Tester, SQL, PL/SQL 2000, ASP.NET

Confidential, Columbus, OH

Quality Analyst

Responsibilities:

• Analyzed Requirements, involved in identification and documentation of required system and functional testing efforts for all test scenarios (Positive and Negative tests)
• Created test plan, test cases and test scripts.
• Involved in setup and configuring test environments.
• Performed Smoke Testing of the application as an entrance criteria for the newly developed builds
• Involved in Black Box testing.
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Created UAT test cases and scenarios based on Use Cases, and made sure that UAT test cases meets the business requirements
• Used SQL for Querying the DB2 database in UNIX environment
• Used Autosys for scheduling the jobs.
• Performed System, Functional and Regression testing of applications using Quick Test Pro.
• Developed the Test Automation Methodology for automated testing entire application by using QTP Tool.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX)
• Involved in setup and configuration of test environments.
• Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL statements on Oracle 9i Database.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Performed backend testing for data validation using SQL Queries. Validated data using SQL joins.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Used SQL queries to validate the data between the backend and the frontend
• Performed Backend testing using SQL and UNIX commands
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings
• Verified data integrity by Backend testing of the application by writing SQL queries.
• Developed and executed Test Cases and Test suites For Black-Box Testing.
• Performed manual testing of the website to determine ease of usability of the website.
• Designed Test Plan and Test Cases using Test Director.
• Used Quality Center to track and report system defects
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed System, Integration, Compatibility and Black-Box testing of applications.
• Conducted Functional Testing of the application.
• Maintained Traceability Matrix and Validation Matrix.
• Used Test Director for Bug Reporting.
• Played a major part in testing and timely delivery of the product.

Environment: UNIX, PL/SQL, Oracle, HP QTP 8.2, HP Quality Center 8.2, XML, Test Director, MS-Word, Perl, Load Runner, Performance Tester, Clear Quest, Clear Case, Perl, Shell, Oracle 10g, ASP.NET, WinSQL, Test director, Web Services, WIN NT/2000, Ms-Excel, MS-Word, SQL

Confidential

Quality Analyst

Responsibilities:

• Involved in end to end manual and automated testing of the application.
• Prepared test methodology and developed master test plan after analyzing system requirements specification document (SRS).
• Developed test cases, scenarios and organized them using Test Director.
• Used Test Director for analyzing Test results and bug tracking.
• Defects and issues were logged in Test Director following Liberty Mutual Standard guidelines.
• Performed boundary value analysis (BVA).
• Prepared Requirements Traceability matrix.
• Developed test scripts for GUI, functionality and regression testing using Quick Test Professional.
• Used various checkpoints to verify the expected behavior of the Application under test (AUT).
• Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing with QTP.
• Wrote the Descriptive programming in QTP with using Visual Basic
• Involved in writing SQL queries (DDL, DML, DCL commands) to test data integrity of the backend database.
• Wrote User-Defined functions in the test scripts.
• Coordinated with QA team members in resolving critical issues with the development team.
• Reviewed project deliverables for completeness and quality in compliance with project standards and specifications.
• Presented daily and weekly status report updates to Team Lead, Test Group and Managers.

Environment: Quick Test Professional 8.x, Test Director8.x, VB Script, Oracle, ASP.NET, Apache, UNIX, SQL, MS Windows