PROFESSIONAL SUMMARY:

• Over 10 years experience in Requirement Analysis, Quality Assurance, Quality Control and Testing of Client Server, e-commerce, Health, financial and Web-based applications. Experienced working with Governmental Organization and Fortune 500 environment such as FISA and New Jersey Motor Vehicle Commission.
• Expert in writing and analyzing the business requirements and formulating Test Plans as well as in developing Test Strategies and implementing the right Test (Regression, Functional, System, Integration, Re-Test, End-to-End, Performance, Security and UAT). Responsible for developing and executing Test Scenarios, Test Cases and Test Scripts for testing different functionalities of applications as well as in creating new Test Data for Test Conditions and Test Scripts.
• Proficient in documenting Testing Defects and participating in defect review/Status/GO-NOGO meetings with Developers, users and various members of the team to resolve those defects. Maintains Test Logs, Test Summary reports, tracks/reports defects using ClearQuest and Test Director and utilizes RequisitePro for requirements management. Highly successful in verifying reports with new and existing data as well as the source and target data marts, in validating report data/results with query results (SQL) and in debugging, tracking and reporting bugs using Test Director.
• Worked as a Senior Manual Tester in the implementation phase of a Data Warehouse application. Tested if computations involving business rules are correct and inserted correct values into target warehouse tables. Was involved in every aspect of project from beginning, entire coding part in, to tracking of work progress.
• Knowledgeable about the Software Development Life Cycle (SDLC) process and Software Engineering Methodology based on Rational Unified Process (RUP) and has good understanding of Relational Database Management Systems (Oracle, SQL Server).
• I have excellent oral and written communication skills and confident in providing training to other Testers on testing applications.

TECHNICAL SKILLS:

Rational Suite 2002/2003 (Robot, ClearQuest, ClearCase , IBM Manual Test Manager, Rational Test Manager, Rational Manual Tester 7.0, Rational ReqPro 7.0, Rational Functional Tester (RFT), Rational Performance Tester (RPT), Test Director 8.0, QTP8.2, Quality Center, Mercury Tools 6.5, HRMS 7.5, PeopleSoft 7.52 Financial & Distribution (AP, AR, BI), PeopleSoft 7.60 IA, People Tools, People Code, BO 6.5/XI, Oracle Oracle9i/10g, JSP, Servlets, EJB, HTML, DHTML, UML, JavaScript, Java, J2EE, DB2, SQL, SQL Loader, SQL Server, Postgre SQL, Shell Scripting, Visual Basic 5.0, OS/390, File-Aid, Trizetto Facets 4.32, Sybase, MQ Series, EDI, Toad, MQ Series, WebSphere, Informatica5.1, Windows XP Professional, Win 98/NT, UNIX (Solaris), UNIX scripts, UNIX (AIX), Linux, Apache Server with Browser Clients, Mainframes (COBOL, QMF, DB2, SQL, TSO/ISPF, JCL, CICS, TSO, MVS, SPUFI, PANVALET), MS-Excel, MS-Word, MS Access 2K, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX
Senior QA Analyst/ Project Lead
August 2011 to Present

Responsibilities:

• Currently working CPI Project for Citi and is a complex project with many different functional subsystems (LoanPath and Business Banking) that will utilize multiple tools and technologies.
• Analyzes Business and User requirements, Use Cases and User Interface Screens (UIs).
• Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.
• Develops and executes Functional, End-to-End, System Test Scenarios, Test Cases, Test Scripts and Test Data for testing different functionality of the applications.
• Conducts Smoke, Functional, Integration, System, back-end, Re-test, Load, Performance, End-to-End, Regression, Security and User-Acceptance (UAT) Testing.
• Works closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.
• Documents testing defects, including the follow through on correction and retesting.
• Attends project-related meetings and walkthroughs to obtain data to continually add information to the test plan and cases.
• Conducts weekly status meetings and defect review meetings.
• Review of Test team work and provide suggestions on Test plan, Test cases and Scripts.
• Responsible for creation and maintenance of Test Labs and setup of Test Labs in Quality Center.
• Responsible for development of necessary infrastructure for SIT and UAT.
• Responsible for interaction with UAT groups and document UAT suggested enhancements.
• Responsible for manual and automation testing.
• Responsible to liaison with other teams to resolve integration and regression issues
• Creates new Test Data for Test Conditions and Test Scripts
• Uses Quality Center for requirements management and Clear Quest for defect tracking
• Performed Cross Browser Testing using Google Chrome, Internet Explorer 6.0/7.0/8.0
• Develops and executes SQL queries in SQL Developer as well as in Oracle Database to perform Back End Testing.
• Develops execution Plans in MS-Excel and updates Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.
• Maintains Test Logs, Test Summary reports and participates in defect review/Status/GO-NOGO Meetings.
• Maps Defects with Test Case ID.
• Performs maintenance testing as well as trained other Testers on testing applications.

Environment: Quality Center 10.0, Quick Test Pro 10.0, BO 6.5/XI, MS-Excel, MS-Word, MS Access 2K, Oracle 10g, SQL Developer, JAVA,J2EE, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional, UNIX.

Confidential Trenton, NJ
Senior QA Analyst/ QA Lead
June 2009 to July2011

Responsibilities:

• Currently working MATRX Project for NJMVC. Motor Vehicle Automated Transaction System (MATRX) is a complex project with many different functional subsystems that will utilize multiple tools and technologies.
• Analyzes Business and User requirements, Use Cases and User Interface Screens (UIs).
• Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.
• Good knowledge on HP service manager.
• Develops and executes Functional, End-to-End, System Test Scenarios, Test Cases, Test Scripts and Test Data for testing different functionality of the applications and Q&R in the MATRX.
• Conducts Smoke, Functional, Integration, System, back-end, Re-test, Performance, End-to-End, Regression, Security and User-Acceptance (UAT) Testing.
• Documents testing defects, including the follow through on correction and retesting.
• Attends project-related meetings and walkthroughs to obtain data to continually add information to the test plan and cases.
• Works closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.
• Performed Cross Browser Testing using Google Chrome, Internet Explorer 6.0/7.0/8.0
• Develops and executes SQL queries in SQL Developer as well as in Oracle Database to perform Back End Testing.
• Creates new Test Data for Test Conditions and Test Scripts
• Requested for ETL Batch jobs (Informatica) to test the BO Reports.
• Runs the Q&R ETL’s and verifies if ETL extraction process from MATRX has completed successfully
• Verifies TPI Reports with New and Existing data and validates Report data/results with query results (SQL)
• Tests functionality of TPI Application and verifies Report results on the Applications.
• Uses RequisitePro for requirements management and Clear Quest for defect tracking.
• Writes Test Cases and Test Scripts using Rational Manual Tester Manager.
• Inserts Synchronization points and verification points in JavaScripts whenever necessary.
• Runs Test Suites from Test Manager and conducts Test Management using Rational Test Manager.
• Performs Regression Testing using the Rational Functional Tester.
• Uses Rational ClearCase for maintaining different versions (Configuration Management).
• Migrates data from the previous version to the next version using Rational Clear Case.
• Reports defects using ClearQuest.
• Develops execution Plans in MS-Excel and updates Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.
• Maintains Test Logs, Test Summary reports and participates in defect review/Status/GO-NOGO Meetings.
• Daily 15 minutes, participated in Scrum meetings at the end of the day.
• Maps Defects with Test Case ID.
• Performs maintenance testing as well as trained other Testers on testing applications.

Environment: Rational Manual Tester 7.0, Rational Test Manager 7.0, Rational ReqPro 7.0, Rational ClearQues7.0, Rational Functional Tester (RFT), Rational Performance Tester (RPT), BO 6.5/XI, MS-Excel, MS-Word, MS Access 2K, Oracle 10g, SQL Developer, JAVA,J2EE, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional, UNIX scripts, UNIX (AIX).

Confidential New York City, NY
Senior Systems Integration Tester
November 2007 to June 2009

Responsibilities:

• Analyzed Business and User requirements (Detail Design Documents & Package Test Scripts (PTS)).
• Developed and executed Functional, Integration, System Test Cases, Test Scripts and Test Data for testing different functionality of the applications and Q&R in the VENDEX.
• Conducted Functional/Base Case, Integration, System, back-end, Re-test, Performance, End-to-End, Regression, Security and User-Acceptance Testing (UAT) manually.
• Documented Testing Defects, including the follow through on correction and retesting.
• Attended project-related meetings and walkthroughs to obtain data to continually add information to the Test Plan and Cases.
• Worked closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.
• Interacted with Developers and on site Vendor to discuss and to resolve defects and their priorities as well as to develop and test applications.
• Developed and executed SQL queries in MS Access as well as in Oracle Database to perform Back End Testing.
• Created new Test data for Test Conditions and Test Scripts.
• Ran the Q&R ETL’s (Submission Package Batch Jobs, Email letter generation batch jobs, Vendor/Contract batch jobs, Regular ETL’s, SA ETL’s and Publisher( daily, weekly, bi-weekly and Monthly basis ETL’s)
• Verified ETL extraction process from VENDEX have completed successfully, ran the reports based on the criteria, verified reports with New and Existing data and validated report data/results with query results (SQL).
• Verified Report results on the Applications, reported defects using ClearQuest and developed execution Plans in MS-Excel.
• Updated Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Mapped RMs with Test Case ID.
• Performed Maintenance Testing as well as trained other testers on testing applications.

Environment: ClearQuest, BO 6.5/XI, MS-Excel, MS-Word, MS Access 2K, Oracle 10g, SQL Server Studio Manager/Query Analyzer, JAVA,J2EE, DB2, JCL, WINDOWS XP Professional, UNIX scripts, UNIX (AIX).

Confidential, Portland, OR
QA Analyst
June 2006 to October 2007

Responsibilities:

• Provided 24/7 supports to Technical and Functional Specifications.
• Gained extensive experience writing on UTDDs (Unit Test Design Documents) and SDDs (System Design Documents).
• Participated in Business Analysis, Requirements Review and Technical specs inspection.
• Involved in writing Test Plans and developing Test Cases from Business Requirements in Test Manager.
• Conducted White Box / Black Box Testing, System Testing, Functional Testing, Integration Testing, Regression Testing, UAT, Load Testing, Browser Testing and Performance Testing.
• Participated in testing various interfaces (Inbound and Outbound) of Facets.
• Tested various reports and custom reports from facets.
• Validated Provider, Member, Membership, Billing and the claims data through EDI based on ANSI 837 claims implementation guide.
• Tested the loading of claims data into Facets. Testing is done both manually and by using ROBOT.
• Developed automated Test Scripts using SQABASIC defining scenarios and procedures to test the performance, security, recovery and reliability of the application.
• Synchronized SQABASIC Test scripts and inserted Bitmaps for greater accuracy of testing.
• Developed Test logs and exceptions, managed requirements using RequisitePro and tested the data loading and data mapping.
• Extensively used SQL queries to verify database table in the backend as part of Transaction Testing,
• Tested the CICS Screens, the database integrity by writing SQL Queries using QMF and other various menus, options and utilities.
• Worked with JCL extensively to schedule and execute the jobs
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Used Clear Quest as error tracking system.
• Interacted with developers, Users and various members of my team to discuss and to resolve defects and their priorities.

Environment: Rational Suite 2002/2003 (Robot, ClearQuest, IBM Manual Test Manager, Rational Test Manager), Trizetto Facets 4.32, Sybase, MQ Series, EDI, Toad, Java/J2EE,TIBCO, JMS, Oracle9i, Mainframes (Cobol, QMF, DB2, SQL, TSO/ISPF, JCL, CICS, TSO, MVS), MS Project, Win NT, Unix (Solaris).

Confidential, Foster City, CA
QA Analyst
October 2003 to June 2006

Responsibilities:

• Involved in gathering requirements and maintained requirements in Requirement Manager of Test Director.
• Developed and executed software System Test Plans and Test Cases. These Scripts were developed after reviewing the business requirements document, and technical specifications document.
• Tested Extraction Methods and Source Transformations are properly accessing required Source data.
• Tested Computations involving business rules are proper and correct values are inserted into target warehouse tables.
• Checked all transformation routines are properly working or not.
• Validated Aggregate values in the target with the non-aggregate values in the source tables.
• Developed the Test Cases to test functionality, and interface of the application.
• Planned and managed tests using Test Director and performed Manual Testing.
• Used Test Director to store all testing results and metrics.
• Conducted Functional, Integration, System, Regression.
• Tested the data loading, data extraction and transformations in Informatica.
• Validated the source and target data marts, validated the reports from Business objects and wrote complex Stored Procedures and functions using SQL.
• Wrote SQL Queries to retrieve the data from various Tables and to test the database.
• Used ClearCase in conducting version control and configuration management.
• Generated automated Test Scripts using Quick Test Pro (QTP).
• Developed VB Scripts, used various checkpoints and developed reusable functions using QTP.
• Performed data driven testing using QTP.
• Involved in testing applications developed using J2EE framework.
• Used TIBCO connectors as Middle-Tier.
• Developed XML test files based on XML schema, generated XML data files using XML Spy, validated the J2EE Web services and tested the Java Components, EJB, Servlets, JSP pages and Applets.
• Wrote Functions for testing customer and billing data with database and validating the conditions.
• Used QTP for Regression Testing using on each new build of Application under Test.
• Prepared Test Data for the UAT as per the specifications of BRD.
• JCL was used to schedule jobs.
• Tested the online and batch programs.
• Worked with SQL Queries in QMF to test the database integrity.
• Worked with DB2 and VSAM files to pull the test data.
• Debugged, tracked and reported bugs using Test Director.
• Performed Cross Browser Testing using Netscape Navigator and Internet Explorer.
• Participated actively in the team meetings with the Developers for fixing the bugs.

Environment: QTP8.2, Quality Center, Test Director 8.0, ClearCase, Java2.0, J2EE, TIBCO, JMS, JSP, Servlets, EJB, HTML, DHTML, MQ Series, Toad, Web sphere, Informatica5.1, Business Objects5.1, Oracle9i, SQL, Mainframes (COBOL, VSAM, DB2, JCL, CICS, MVS, TSO/ISPF, SPUFI), SQL Loader, Shell scripting, UML, Windows NT, UNIX, MS Excel

Confidential India
Manual Tester
October 2001 to September 2003

Responsibilities:

• Identified the Test Requirements based on application business requirements and blueprints.
• Performed manual testing and maintain documentation on different types of Testing viz., Positive, Negative, Regression, Integration, System, User-acceptance, Performance, and Black Box
• Involved in analyzing the applications and development of test cases and in doing System Testing of the entire applications along with team members.
• Tested applications manually. Developed Test Scenarios and Test Procedures based on the Test Requirements.
• Participated in Preparing Test Plans. Carried out unit/module testing and wrote MR’s. Performed Database testing and wrote SQL queries and stored procedures to validate data.
• Documented errors and implemented their resolutions.
• Created Test Scripts, executed Test Scripts and developed Test Objectives and Test Procedures.
• Participated in user training and submitted status reports weekly.

Environment: PeopleSoft 7.52 Financial & Distribution (AP, AR, BI), PeopleSoft 7.60 IA, People Tools, People Code, Visual Basic 5.0, SQL Server, MS-Word, Ms-Excel, DB2, and Windows98/NT

Confidential, India
Manual Tester
March 2000 to September 2001

Responsibilities:

• Involved in every aspect of Project from the beginning, entire coding part in Stores, and tracking of work progress.
• Wrote all the Database Methods used in the entire Project and did Ground work for Reports.
• Performed almost all client side validations in JavaScript.
• Developed Test Plans, which specify testing overview, approach, strategy, roles and responsibilities.
• Designed and developed Test Cases, Test Procedure and Test Scenarios.
• Interacted with Developers and DBAs regarding Y2K problem and defect reports.
• Conducted Performance Testing, Multi-user Testing, Data Integrity Testing, Functional Testing, Load, Volume and Stress Testing. Tested the application manually.
• Performed testing to validate all the User Interface of the application.

Environment: Linux, Apache Server with Browser Clients, PERL, CGI, HTML, Java Script, Postgre SQL, Rational Suite, Manual Testing, PeopleSoft 7.52 Financial & Distribution (AP, AR, BI), PeopleSoft 7.60 IA, People Tools, People Code, Oracle 8i, SQR 4.3, CRYSTAL5.0, UNIX (Sun OS 5.6), Win NT, VB5.0, C++, SQL Server, PFE, OS/390,MVS, JCL, COBOL, VSAM, CICS, DB2

EDUCATION:

• Bachelor of Science in Mathematics, Physics and Chemistry.
• Diploma in PGDCA.