SUMMARY

• 7+ years of experience in the field of Quality Assurance for Web and ERP based applications.
• Have detailed knowledge in SDLC and models like Agile and Waterfall.
• Contributed knowledge and expertise in applications in Banking, Retail and Health care domains.
• Experience in software test management from defining requirements, planning testing process, executing test cases and reporting issues.
• Experience in Smoke Testing, Integration Testing, System Testing, Functional Testing, Regression Testing,front - end GUI testing and Database testing.
• Worked on developing Test Strategy, Master Test plan, Test Data Management, Test Cases, Test Scenarios and Executing Test cases and creating Traceability Matrix.
• Expertise on Black Box Testing techniques like BVA, ECP, Decision Tables and Use Case Testing.
• Experience in Bug Tracking and Reporting using Test Director/ HP Quality Center.
• Good exposure on Bug Life Cycle.
• Strong experience in writing SQL statements in order to do back end testing.
• Good understanding of data warehousing and ETL processes including star and snowflake schemas and data mart characteristics.
• Excellent understanding of relational database concepts including normalization, referential integrity, joining tables, SQL, DDL and DML.
• Experience in testing web services SOA applications using SoapUI for security, scalability and high- volume transactions.
• Knowledge of various BI tools including IBM Cognos and SSRS.
• Knowledge of various report templates in Cognos like List Reports, Cross-Tab reports, Chart Reports, Drill through Reports.
• Good exposure in using Quick Test Professional integrated environment (Synchronization, Parameterization, Re-usable actions, Functions, Checkpoints, Recovery Scenario and Methods).
• Extensively used Environment Variables in Quick Test Professional to share across various reusable actions and functions.
• Performed Data-driven testing to insert multiple sets of data into the application.
• Experience in Descriptive Programming using Quick Test Professional.
• Excellent communication, interpersonal, analytical, logical and documentation skills with good team spirit.
• Quick learner and ability to implement new software / features independently with in short time frames.

TECHNICAL SKILLS

Scripting Languages: Java Script, VB Script

Programming Languages: C, C++, Java, VB.Net.

Web Technologies: HTML, XML, DHTML, JQuery.

Database: SQL Server, Oracle, MySQL,DB2

SQL Tools: SQL Developer, MySQL, SQL Server Management Studio

Testing Tools: QuickTest Professional, Quality Center, SoapUI, Test Link, Test Director, Microsoft Test Manager, Selenium, Bugzilla, Jira and Rational ClearQuest.

Other Tools: Microsoft Office Suite (Word, Excel, Access, PowerPoint, Outlook), Adobe Acrobat, TFS, Cognos, SSRS, Informatica power centre.

Web Servers: Internet Information Server(IIS), Apache, Tomcat

Operating Systems: Windows NT/ 2000/2003/2008, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr.QA Analyst

Responsibilities:

• Responsible for management of all Quality Assurance functions include planning, strategy, testing executionand tools.
• Ensure traceability of test cases to requirements, worked with the project Business Analyst to ensure allrequirements are tested.
• Managed and scheduled all Manual and Automation scripts from HP Quality Center using the Test Lab and Defects module.
• Logged the defects in Quality Center and maintained track of the defects throughout the life cycle.
• Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was retrieved.
• Involved in the Data Validation of the Members as well as Claims during the ETL Testing Process.
• Ability to develop SQL script for Data validation testing by running SQL script, procedures.
• Performed Data-driven testing to insert multiple sets of data into the application.
• Performed Regression and Functional testing, G.U.I Testing to ensure quality using Quick Test Professional testing tool.
• Worked with VBScript to enhance the scripts to provide utmost testing solution for Regression Testing.
• Extensively used functions while editing test scripts to minimize code redundancy and to improve the performance.
• Tested various Dashboard reports in Cognos based on the business users report requirement.
• Involved in working ICD9-ICD-10 conversion project.
• Worked with technical analysts to identify unit testing coverage and ensure any gaps are documented and addressed.
• Extensively involved in weekly walkthroughs, status reports and inspection meetings to verify the status of the testing effort and the project.

Environment: Windows, SQL Server 2008, .NET, Cognos 10(Framework Manager, Report Studio, Analysis Studio, Query Studio, Access Manager), Informatica power centre 8.6, HTML, XML, Quick Test Professional, Quality Center, SoapUI.

Confidential, Columbus, OH

QA Analyst

Responsibilities:

• Participated in review and analysis of business and system requirement specification documents.
• Worked closely with business management and development teams to understand the objectives for better results.
• Created Test Plan and Test Scenarios to cover the requirements for testing.
• Involved in gathering the Test data for specific scenarios and for the entire testing cycle.
• Created Traceability Matrix to ensure requirements coverage in test cases.
• Conducted Smoke Testing, Functional testing, Integration testing and Regression testing during the various phases of the development using QuickTest Professional.
• Wrote custom queries in SQL to retrieve data from different tables in the database.
• Validated the feed processing in different stages like File Watcher conditions, PRE ETL, ETL, POST ETL and Created parameter files in Informatica and passed them to Informatica Tasks.
• Experienced in creating SQL queries to validate the target tables loaded by Informatica
• Executed Informatica Workflows individually and validated the data.
• Calculated feed processing times stage-by-stage and reported to Manager.
• Assisted other engineers on test suite development, execution and debugging.
• Enhanced the test scripts by using reusable actions, parameterization in QuickTest Professional to broaden the scope of testing.
• Worked with development team in root cause analysis of the bugs and provide them with accurate steps to reproduce the bug in the development environment.
• Prepared a test database with test values and ran the regression tests before every release to make sure the new functionality has not impacted the existing functionality.

Environment: QuickTest Professional, Selenium, Quality Center, Informatica power centre 8.6, Java, SQL Server, HTML, XML, JavaScript, PL/SQL, Linux, Windows

Confidential, Milwaukee, WI

QA Analyst

Responsibilities:

• Actively participated in the analysis of Business Requirements.
• Developed Test Plans, Test Scenarios, and Detailed Test Cases based on the Use Case Documents, Business Requirements, and Functional Specifications.
• Maintained Requirement Traceability of all requirements vs. test cases using Quality Center.
• Analyzed the results, tracked the defects and generated reports using Quality Center.
• Recorded Bugs and reported them by creating a Bug Report Document.
• Performed Data Verification Testing by writing SQL queries in order to resolve data discrepancies and maintain data accuracy.
• Worked extensively with SQL to validate the reports data.
• Performed SOA / Web Service testing using SoapUI .
• Verified and validated the data transfer through web service calls as intended using SoapUI.
• Validate data content in different web service calls using SoapUI.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• Involved in verifying, assigning and closing defects logged by production team.
• Extensively used UNIX commands and VI editor
• Extensively used Microsoft Office Suite of products for documentation and data interpretation.

Environment: Quality Center, QuickTest Professional, Microsoft Excel, SoapUI,HTML, XML, JavaScript, Java, J2EE, TIBCO, Windows, UNIX (Linux), DB2

Confidential, Cambridge, MA

QA Engineer

Responsibilities:

• Involved in analyzing the requirements.
• Involved in writing test cases and test plan for System, functional, regression testing.
• Involved in Identifying test scenarios and test cases based on Requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in Functionality, Regression and usability testing.
• Defect logging and Tracking.
• Experienced in creating SQL queries to validate the target tables loaded by Informatica.
• Validated the source system data with the staging data using SQL scripts.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Maintained Test Matrix for latest test results information.
• Executed the Automated scripts using QuickTest Professional.
• Involved in testing the Cognos reports for Quality Assurance before delivering to the end users.
• Tested various List, drill through, master-detail, chart and Active reports which are developed using Cognos Query Studio, Report Studio and Analysis studio.
• Inserted verification checkpoints, synchronization points, and parameterized data using QuickTest Professional.
• Involved in verifying, assigning, closing defects logged by production team.
• Worked on Keyword view and Expert view.
• Involved in the analysis of Bug Severity, Bug Tacking System and bug reporting.

Environment: QuickTest Professional, Windows, UNIX, SQL Server, SoapUI,Informatica power centre 7.1.4,Visual Studio,, HTML, XML, JavaScript, CSS, HTTP, FTP, Cognos 8, Quality Center.

Confidential, OH

QA Tester

Responsibilities:

• Review and analyze Business Requirements, Use Cases, and Screen shots.
• Developed Test Cases and identified the test scenarios for complete end-to-end testing.
• Interacted with End Users, Business and System Analysts to understand the System requirements.
• Created Test data and wrote Test cases as per the Test plan and application Requirements.
• Attended the walkthroughs with the Business Analysts, Technical Analysts and Developers.
• Involved in tracking, executing and scheduling of test cases using Test Director.
• Created SQL scripts to change data and validate service response.
• Tested browser compatibility with IE, Firefox.
• Manually conducted positive/negative testing.
• Recorded results and worked with developers to communicate regarding issues in the application.
• Coordinated with the developers on defects status on a regular basis.
• Performed Retesting, and Regression Testing once issues are closed.
• Used test summary report to track defects and report the test summary in weekly meetings.

Environment: Linux, Apache Web Server, Windows XP, Test Director, Oracle, Toad, PHP.