SUMMARY:

• Over 10 years of experience in Manual and Automated testing for various client/server, web based and B2B applications.
• Strong Knowledge of System Development Life Cycle (SDLC), Project Life Cycle and Software Testing Life cycle (STLC).
• Involved in gathering business requirements, studying the application and collecting the information from developers and Business analyst.
• Extensively involved in writing Test Plans, Test Cases, Test Scripts and project related documentation.
• Highly experienced in implementing different testing methods like black box testing and white box testing.
• Involved extensively in various stages of Functional testing, Integration testing, Regression testing, User Acceptance testing and End to End Testing.
• Extensively used Mercury Quality Center 9.0/9.2 and Bug Tracking System for reporting Defects, performing bug tracking, submitting quality bugs, raising issues, defects and resolving bugs.
• Experience in tools like HP - Mercury Quality Center 11.50/11.52/9.0/9.2 , HP-Mercury QTP 12.0/8.2/9.2 , Rational Clear Quest 7.1.
• Extensive ETL testing experience using Informatica 8.1 Power Center(Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Experience in Business Intelligence testing in various reports using Business Objects, Crystal Reports and Crystal Dashboards(Xcelsius).
• Worked on joins , views, functions using SQL, PL/SQL
• Extensive Experience in using Database systems like Oracle, Microsoft SQL Server 2008/2005 and used TOAD 12.5/ 10.2/9.7/9.6 for back end testing.
• Wells versed with MSOffice Suite of products
• Excellent skills in documenting testing processes.
• Exceptional ability to quickly acquaint with new concepts and technologies.
• Team player with strong analytical, problem solving skills, excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Testing Tools: QTP 8.2/9.2/12.0, Win Runner 7.6/8.0

Languages Tested: Java/J2EE, Pega, Oracle Apps SMART, PL/SQL, VB

Databases and Tools: Oracle 11g/10g/9i, SQL Server 2008/2005, DB2 UDB, TOAD 10.2/9.7/9.6

Operating Systems: Windows 7/8/XP/NT/2000, UNIX(Solaris), LINUX

Defect Tracking Tools: Mercury Quality Center 9.0/9.2, HP ALM 11.52/11.50, Test Director, Clear quest 7.1, JIRA 4.4/3.2,Rally

Version Control Tools: Rational Clear Case 7.1, CVS, Subversion (SVN), Tortoise SVN 1.7.6

ETL tools: Informatica 8.1, BO Data Integrator

BI and Reporting Tools: Business Objects XIR2/XI 3.1, Crystal Reports XIR2/2008

PROFESSIONAL EXPERIENCE:

Confidential, Mclean,VA

UAT Tester

Responsibilities:

• Involved in testing of Post Fund Data Correction tool of Selling System.
• Involved in test data preparation from selling side to CSPLI team.
• Performed Web services testing using SOAP UI for Asset and Income projects of LPA Application.
• Involved in testing UAT Scenarios involving Confidential, Form Free and Confidential .
• Involved in testing Positive,Negative and Exception Scenarios as mentioned in UAT.
• Verified that system is working as expected as per the functional requirements included in the BRD.
• Performed Smoke Testing and Regression Testing.
• Performed Income and Asset Service Testing by accessing third party Vendors Form Free and Confidential using SOAPUI
• Involved in Test Cases Review,Result Review meetings.
• Created Test Plan,Test Strategy,RTM documents.
• Experience testing in Mainframes environment.
• Experienced in running batch jobs in mainframe system and checking logs.
• Involved in the business analysis of data required for the test cases and scenarios.
• Performed System, Back end, GUI, Functional and Regression testing.
• Participated in Defect Review Board meetings to verify and review various defects logged against the application.

Environment: HP Quality Center ALM 12.5x, SOAPUI 5.0.0, Oracle 11gr2, IBM DB2, MS-OFFICE/Excel, Rapid SQL 8.7.5, Altova XMLSpy 2015, UNIX, Version One, Putty, IBM Rational Doors 9.5, Beyond Compare 4, Windows 7, WinSCP.

Confidential, Herndon,VA

UAT Tester

Responsibilities:

• Involved as UAT Tester in the project LDNG.This project involved in testing the new application LDNG which is replaced by the existing Loan Delivery (LD) application. LDNG will serve as the central front end lender facing application for the delivery, submission and management of loans.
• The purpose of the project LDNG is to replace the existing LD application, provide integration with BRO and CBRS in order to better align business rules between LD and Early check and enable the retirement for end of life technologies.
• Conducted UAT in the Acceptance Test Environment to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Involved in Out of Sprint Acceptance Testing in parallel to the construction phase.
• Involved in parallel testing between LD Legacy and LD Next Gen.Parallel testing is executed to verify LD applications functionality is not changed unexpectedly by comparing behavior between LD Legacy and LDNG.
• Worked closely with Business and Mortgage Operations and other SME’s to come up with test scope for each iteration.
• Performed Shakeout Test in ACPT environment before beginning the test execution for each iteration.
• Involved in test data preparation, test data will include modifying Golden files and used existing golden files, modified golden mismo files for the parallel testing.
• Used XML Spy to modify the golden mismo files.
• Executed Parallel Test Cases (Business Rules Testing) against LD Legacy and LDNG ACPT environments.
• Documented results in the test case and Defect Management Tool (Rally) and used ALM for Test Case Management.
• Executed Automation Scripts to run regression tests for each new iteration.
• Involved in Progression Test to meet Test Objectives. This testing is conducted to ensure the application is working as intended by the business users and per business requirements mentioned as Acceptance criteria’s.
• Created and Execute UAT Scenario Test Cases and supported Requirements Traceability
• Identified and logged Test Case Defects in Rally.
• Involved in Regression Testing.
• Stored test plans and results on Team Foundation Server (TFS).
• Captured and tested all modifications to proposed functional requirements.
• Validated test results using SQL queries in backend using Toad.
• Created Positive and Negative scenarios for testing each edit as part of parallel testing in LDNG and LD.

Environment: Oracle 11gr2, HP Quality Center ALM 11.50, MS-OFFICE/Excel, Eclipse, Toad for Oracle 12.5,AltovaXMLSpy(x64), UNIX, Tortoise SVN 1.7.6, Microsoft Test Manager (MTM), Putty,IBM Rational Doors 9.6,BeyonCompare 4,JavaSDK 1.7, Rally,WindowsXP,Windows8.

Confidential, Mclean, VA

QA Analyst

Responsibilities:

• The purpose of project ULDD2 is to eliminate additional special codes and replace them with more granular data and also removing of unused data points.
• Involved in business rules verification of ULDD2 .Accessed BDMS System to check business rules and created test cases and created scenarios.
• Involved in Loan Delivery process including import a loan and modify a loan and export of loan in selling system
• Before execution of test cases Imported CRT and RMT data in EDS and created loan files.
• Created scenarios based on IT delivery model sent by rules authoring team and generated data using automation script.
• Worked in testing Data Quality, Credit, Charter and Utility decisions with ULDD2 as decision view type.
• Prepared Mismo XML’s using automation script. Executed scenarios once the build is delivered by developer.
• Worked on in restarting/bouncing environments once the build is ready. Used UNIX commands to run scripts which compare XML files, and to import all files in EDS.
• Imported loans in Selling System and tested that decision rule data points is implemented correctly or not.
• Validated test results using SQL queries in backend.
• Categorized defects in Mercury Quality Center based on severity and interfaced with developers to resolve them.
• Performed Functionality Testing, Negative Testing and Regression Testing.
• Involved in the process of executing the Test Cases and analyzing the Expected and Actual results.
• Responsible for updating weekly status reports which shows the progress of the testing.
• As part of ULDD2 performed regression testing of EDS GUI application.
• Created Test Cases of EDS GUI and executed and Updated test case document with the results.
• Tested new data points in a loan of ULDD2 implementation.
• The purpose of Loan Prospector release is integration of Loan Prospector with the Enterprise Decision Service (EDS) and enabling EDS as a client independent application.
• Manually tested the purchase restriction messages and codes of the application.
• Responsible for Functionality, Integration and Regression Testing of LP.
• Developed and Executed the test cases Manually.
• Participated in bugs and enhancement review meetings.
• Validated XML data and verified the purchase restrictions with codes.
• Participated in bugs and enhancement review meetings.
• Work closely with both the development teams to coordinate & schedule testing efforts.
• Build SQL queries reflecting business rules based on functional specification with multiple joins.
• Performed System, Back end, GUI, Functional and Regression testing.
• Binders is a Maintenance/Enhancements project with monthly releases for all Confidential Rules Projects such as ULDD2, LP Liabilities, LCA, ILOG .
• Experience Testing on Surface Pro.
• Created scenarios and executed using selling system in Binders project.
• Involved in preparation of data in Mismo XML format for Binders .
• Created different types of Positive, Negative, and Exceptions scenarios to test the changed decisions for the release.
• Performed Rules testing manually and using Automated Testing Tools.

Environment: Oracle 11g, HP Quality Center ALM 11.52, MS-OFFICE/Excel,Microsoft Test Manager (MTM), QTP 12.0, Rapid SQL, Mismo XML,UNIX, Rational Clear Case 7.1.2.9, Windows-NT.

Confidential, Sterling, VA

QA Analyst

Responsibilities:

• This project involved in testing multiple software releases of various applications like Contact Center, Service Bench, Shipping Gateway, Service 360 and Communication Gateway.
• Tested multiple B2B and web based applications which were developed using Oracle Apps SMART, PEGA and J2EE .
• Involved in the process of preparing the test cases, executing the test cases and analyzing the Expected and Actual results.
• Project was implementing Agile Methodologies with Biweekly releases of new modules of functionality and Bug Fixes
• Performed Functionality Testing, Backend testing (Batches and data) and Regression Testing.
• Worked on Regression Testing of SVC 360 issues and Reissues.
• Tested Mailing Labels functionality in Shipping Gateway and Task creation via SG for different sub-statuses (ABJ, ABN, ABF, ABH and ABM).
• Invoicing for GC and Check clients (PEGA, Smart and Portal 2.0), data Creation for PEM Migration GC and Check Clients
• Tested Communication Gateway functionality where Emails, Voice calls and SMS are triggered from Communication Gateway to customers.
• Used Toad 9.6 to run backend SQL Queries to perform data validation and to check data integrity.
• Tested the CG Templates for various programs like Rescue Link, Verizon Freedom, Walmart.com, Replacement Claim and DCS Depot using the applications PEGA, Service Bench, Service Hub Portal, Command Center and Shipping Gateway.
• Tested CG Templates using XML, Webservices which developed using Java and Apache Axis .
• Responsible for updating weekly status reports which shows the progress of testing.
• Retested the fixed issues and performed regression testing if necessary.
• Tested Templates emailing to Google, Yahoo and Outlook. Worked on Bounced email testing and replacing the communication type “EMAIL” with “PHONE” in CG.
• Validated the results in the Communication Gateway Request and Response Tables in the backend writing SQL queries
• Regression testing on Service Plan for any products other than Jewelry where the appointment scheduling should be successful and Tested Rescheduling an appointment of the service plan for any products other than Jewelry.
• Performed Testing appointment cancellations of Service Plans for any products other than Jewelry and Rescheduled and cancelled an appointment for the service plans for any products other than Jewelry.
• Involved in creation of Test Data for different service types CARRYIN, IN-HOME and DEPOT for various clients and Verified the task creation in SMART
• Used JIRA 4.4 for defect tracking and for logging all QA Activities .

Environment: Oracle SMART, PEGA, J2EE, Java Webservices, SOAP UI (Webservice Client), Oracle 10g, MS-OFFICE/Excel, Toad 9.6, JIRA 4.4, Rational Clear Case, Windows-NT.

Confidential, Sanjose, CA

QA Analyst

Responsibilities:

• Performed Quality Assurance services through Confidential for various clients UC Berkely, FICO and GXS.
• Confidential Straight through processing (STP) application is used to generate SQL and reports. Involved in testing Rules Engine and Integration Engine modules in the STP application which is used by Various Financial Client’s such as Citi Bank.
• Performed Manual Testing on Rules Engine and Integration Engine modules of the application by executing the Test Cases.
• Analyzed application data using the SQL to identify the ETL processes
• Wrote complex queries to compare the counts and data from source to target.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Tested a number of complex ETL mappings and transformations for daily data loads.
• Written SQL queries to validate reports against the database.
• Involved in the process of executing the Test Cases and analyzing the Expected and Actual results.
• Performed Functionality Testing, Adhoc Testing and Regression Testing.
• Involved in gathering business requirements and writing a Test Plan based on Business Requirements Specifications.
• Verified that the individual application screens are performing correctly and performed screen-based testing.
• Involved in testing analysis and data reports developed using Crystal Reports XI/2008 and Business Objects at various Client locations such as UC Berkeley, GXS .
• Involved in testing of various Business Objects and Crystal reports at F ICO . The release involved enhancing various Legacy BO Reports strictly from performance perspective.
• Involved in the business analysis of data required for the test cases and scenarios.
• Performed System, Back end, GUI, Functional and Regression testing.
• Participated in Defect Review Board meetings to verify and review various defects logged against the application.
• Modified the test procedures according to the functional documents for the current build.
• Performed Black Box, Integration and system testing.
• Developed XML test files based on XML schema.
• Responsible for updating weekly status reports which show the progress of the testing efforts.

Environment: Oracle 10g, MS-OFFICE/Excel, Mercury Quality Center 9.0,Informatica 8.1,Business Objects XI 3.1, Toad 9.7, People soft Platform, Crystal Reports XI/2008, Windows-XP.

Confidential, Columbus, OH

QA Analyst

Responsibilities:

Confidential ’s Product performance Project enhances the quality of PeopleSoft and Java/J2EE Application Releases. The project involved performing quality analysis of web based Frontend applications as well as backend data flow processes.

• Participated in process design / modification meetings which helped to later define various Testing scenarios and Test Cases.
• Involved in Managing and maintaining all approved documents according to SDLC standards.
• Prepared detailed Test Plan and Test scenarios for manual and automated testing.
• Involved in all stages of testing process including development of Test procedures, Test cases based upon requirements and performing functional test, regression test, integration test and end user tests.
• Creating test cases for ETL mappings and design documents for production support.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested ETL process to push the transactional data from the normalized data structure into the data marts.
• Developed SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Performed Data Analysis, writing SQL Queries for ETL Testing and Troubleshooting against Data Warehouse.
• Worked closely with Business users in Understanding ETL test specifications and writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications.
• Assisted in implementation of JD Edwards ERP software by conducting extensive manual test of JDE Address Book and Sales Order Entry applications.
• Executed SQL statements for data validation to check data integrity.
• Summarize test results in formal test analysis reports according to the Documentation standard.
• Executed and developed the reports using BO/Crystal Enterprises tool and validated the data on the report to the database tables.
• Involved in writing SQL queries for validation of data from source to target table.
• Familiar with all testing cycles.(Functional, System, Regression and UAT)
• Created and enhanced automated scripts using various advanced features offered by QTP.
• Developed the test automation scripts for automated testing of the application by using Quick Test Pro.

Environment: J2EE Platform, PeopleSoft, HTML, JSP, VB Script, Quick test Professional 9.2, HP Quality Center 9.2, Informatica Power Center,Business Objects XIR2,BO Data Integrator,Oracle 10G, MS-Office, Windows-XP.

Confidential

QA Tester

Roles and Responsibilities:

• Tested various data entry applications used in sales and HR.
• Performed Unit testing on dealer management application designed using VB.
• Performed extensive end user testing.
• Developed the test plans, test cases and submitted weekly bug report.
• Worked on time management module used by the company and helped keep track of time and expenses of various consultants working with the company.
• Wrote test cases as well as involved in writing test plans
• Perform Integration and Regression testing.
• Co-ordinate with developers for bug fixes
• Monitor the appropriate call routing.
• Track bugs through bug tracking System
• Involved in writing complicated SQL queries.
• Used Test director for bug tracking
• Involved in regression testing and integration testing and system testing.

Environment: Java Applets, Web logic 6.0, JSP, UML, XML, Test Director 7.6, TOAD 7.4, Crystal Reports, Windows 2000/NT, Oracle 8.0/9i, UNIX.