PROFESSIONAL SUMMARY:

• Over seven years of IT experience in Software Quality Assurance and Software Quality Testing.
• Certified QA Tester from the International Software Testing Qualifications Board (ISTQB) with solid IT experience in testing methodologies, designing test plans, preparing documentation, following Standard Operation Procedures and implementing test strategies during Software Development Life Cycle (SDLC)
• Experience in manual and automation testing for web based, Client/Server and ETL applications on multiple levels of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Experience in analyzing Functional Requirement Specification (FRS), System Design Specification (SDS) and System Requirement Specification (SRS) documents and creating test plan and test cases for manual and automation testing
• Extensive experience in functional testing, unit testing, system testing, integration testing, regression testing, GUI testing, back - end testing, browser compatibility testing, and component testing in different stages of Software Development Life Cycle (SDLC)
• Extensive experience in Defect Reporting and Defect tracking process using HP Quality Center
• Experience in writing SQL Queries for back end testing in Oracle database using DML operations like select (with complex joins), insert, update, delete statements and verify the data in the reports.
• Experience in preparing test data and performing bulk loads using the oracle SQL Loader and import/export utilities in oracle database
• Experience using QTP with VBScript to support test automation using potential features like Data Driven Tests, Check Points, Regular Expressions and Functions.
• Experience in designing and creating automation frameworks for web based applications using Java, Selenium WebDriver/IDE/RC, Junit, TestNG, Maven, ANT
• Experience in testing client server application using QTP and VBScript
• Proficient in creating automation scripts from scratch and experience in developing different types of framework like Data driven, Keyword driven and Hybrid framework.
• Experienced in web-debugging tools like FirePath and Firebug for finding element locator
• Expertise in database querying, data manipulation and data population using SQL and PL/SQL in Oracle, MySQL, Netezza and SQL Server (TSQL) databases.
• Experience in testing ETL and data warehouse applications
• Sound Knowledge in data warehouse concepts and experience working in Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Netezza data warehouse
• Experience in UNIX Shell scripting (Korn/Bash), vi editor, running jobs in background and autosys scheduling tool
• Prepared status summary reports with details of executed, passed and failed test cases and involved in weekly status and task review meetings.
• Extensive experience in Software Development Process like Agile, Iterative, Incremental and Waterfall.
• Good Analytical and Communication Skills and ability to work independently with minimal supervision and to perform as part of a team. Ability to work under competing deadlines.

TECHNICAL SKILLS:

Programming Languages: C, C++, JAVA, Unix Shell Scripting (Korn/Bash), SQL, PL/SQL, TSQL, VB Scripting

Testing Tools: HP Quality Center, Quick test professional (QTP), Selenium RC/WebDriver/IDE, Mozilla Firebug, FirePath

Web Technologies: JavaScript, HTML, CSS, XML, DOM, XPath

Operating Systems: Windows 7/xp/98, UNIX (Sun Solaris, IBM Aix), Linux, MS-DOS

Databases: Oracle 10g/9i, Microsoft SQL Server 2008/2005, Netezza, MySQL, MS-Access

ETL Tools / Utilities: Ab Initio, SQL Server Integration Services (SSIS) 2008, SQL * Loader, Oracle Import/Export utility

Version control tools: Tortoise SVN, Subversion

IDE/Editors: Eclipse 3.x, Net Beans IDE, TextPad, Toad for Oracle, SQL Server Management Studio, AQT, MySQL WorkBench, vi editor, SQL*Plus

Build Tools: Ant, Maven

Job Scheduling tools: Autosys, Crontab

Web Servers: Apache Tomcat 7.x/6.x, Apache HTTP Server 2.4.1, WebLogic, JBoss

Inventory network management: Cramer OSS 5.1

Java/J2EE Technologies: Servlets 3.0/2.x, Java Server Pages (JSP) 2.x/1.x, JAXP, JDBC

Frameworks: JUnit, Log4J, TestNG, Struts 2.0/1.3

Methodology: OOPS, OOAD, SDLC, STLC (software testing life cycle)

Microsoft Packages: MS: Office 2010/2007

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Software Quality Assurance Analyst

Responsibilities:

• Analyzed Business Requirement Documents, Functional Specification Documents and User Requirement Document.
• Wrote Test Plans, Test Cases and Test Scripts for Manual and Automated testing for various components in the application.
• Maintained Test Matrix for the latest test results information.
• Developed automation Hybrid Framework (mixture of keyword driven and data driven framework) in QTP using VBScript
• Developed automation test scripts for performing regression testing, GUI Functionality on the application using QTP
• Tested user interface and navigation controls of the application using QTP
• Created page checkpoints to test the properties and contents of the web pages in QTP
• Wrote complex SQL queries and PL/SQL procedures to perform the back-end testing in the Oracle database
• Performed negative and positive testing using SQL Queries
• Executed the test scripts in multiple environments (QA, UAT and Production) to ensure that requirements were still met
• Detected and reproduced the defects, and logged defects using HP Quality Center.
• Mapped requirements with test cases in Quality Center and executed them reporting a pass or fail status, to be reviewed by the QA Manager and development team
• Attended requirements review meetings and provided feedback to ensure that the application meets all primary requirements
• Participated in defect triage meeting with developer, PM, QA Manager and other team members to provide explanation of problems.
• Experience working with off shore team.
• Actively participated in all phases of testing life cycle including documents reviews, maintaining status reports.

Environment: - Oracle 10g, Java, SQL, PL/SQL, Unix, QTP, HP Quality Center, Toad, Tortoise SVN, WebLogic, VBScript, XML, MS Office, JUnit, Eclipse

Confidential, Charlotte, NC

QA Tester/Automation Engineer

Responsibilities:

• Analyzed Business and System Requirements and interacted with users and developers.
• Developed system test plans and test scripts based on the user requirements and design documents.
• Created test cases including functional unit test cases, positive, and negative, boundary and integration test cases.
• Involved in creating test procedures, Methodologies and Policies for ensuring a thorough Testing.
• Worked in important phases of Testing Life Cycle like Smoke Testing, Integration Testing, Regression Testing, Business Functionality Testing, System Testing, User Acceptance Testing (UAT) and Load Testing.
• Performed Backend Testing on Netezza Database by writing SQL statements to ensure the retrieved data in the user interface was correct.
• Performed Data Driven Testing using QTP.
• Developed automation test scripts for performing regression testing on the applicationand maintained Local and Global Object Repository in QTP
• Developed both General and Application SpecificFunctional Libraries in QTP
• Performed GUI, Functionality, Integration and Regression testing using QTP and tested user interface and navigation controls of the application.
• Created page checkpoints to test the properties and contents of the web page in QTP
• Executed the test scripts on multiple environments (QA, UAT and Production) to ensure that requirements were met.
• Detected and reproduced the defects, and logged defects using HP Quality Center.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, logging bugs, and tracking defects.
• Generated the test execution report in HP Quality Center to be reviewed by theQAManager and development team.
• Reviewed the Business Requirements Document to understand the process and wrote test plan and test cases for positive and negative testing for the requirements.
• Assisted in creating the test environment for staging and loading the data from multiple sources.
• Prepared test data in QA environment by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Tested various reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Performed Verification, Validation, and Transformations on the Input test data files before loading into source database
• Responsible for validation of target data in Data Warehouse and Data Marts which are Transformed and Loaded using Ab Initio ETL graphs
• Reviewed the ETL mappings (using Ab Initio web interface) to ensure the transformation rules are applied correctly.
• Resolved and escalated data related issues and validated data to improve data quality.
• Loaded test data to different databases using SQL scripts and maintained a repository for data loading scripts
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Extensively tested the Micro strategy reports by running the SQL queries on the database and by reviewing the report requirement documentation.
• Analyzed defects and worked with data analyst and developers to find the root cause for the issues
• Tracked the defects using HP Quality Center tool and generated defect summary reports.
• Developed Tractability Matrix and Test Coverage reports.
• Wrote UNIX shell scripts to run PL/SQL programs and scheduled them using AUTOSYS in QA environment.

Confidential

Responsibilities:

• Analyzed business requirement documents, functional specification documents and created test specifications, test cases
• Reviewed and updated Requirements Traceability Matrix that satisfy all required project test conditions
• Designed, developed, and executed automation test scripts using JUnit that leverage black box and white box testing across functional, non-functional requirements
• Developed test automation scripts using Selenium WebDriver, JavaScript, Java, TestNG in Eclipse IDE to perform functional and regression testing for web based applications.
• Tested compatibility of application for dynamic and static content under various cross browsers using HTML Tags and XPath using Selenium WebDriver.
• Wrote automated scripts with XPath to identify the web elements.
• Extensively used Selenium IDE to record, playback and debug individual test cases
• Executed regression test scripts to ensure that the existing features are working as expected and identifying, logging, tracking and escalating bugs using JIRA
• Performed Data-Driven testing by developing Java based library to read test data from Excel & Properties files.
• Performed back-end testing using SQL queries to retrieve and verify information in the database.
• Developed SQL queries to simulate data validation reports and to stage test data for ongoing testing.
• Experience on working with TestNG for generating test reports
• Used TestNG with ANT to build XSLT Reports
• Prepared and executed batch test suite through TestNG via Ant.
• Used Subversion for code repositories and Ant for the dependencies.
• Maintained QA/Test environments and assisted in build and deploy activities.
• Involved in Defect Management, Defect Review and Defect Status Reporting
• Involved in Defect Triaging and Release sign off for Continuous Delivery cycles.
• Communicate testing status to QA lead, project managers, and teams who are involved in User Acceptance Testing.
• Participated in daily, weekly meetings and technical reviews and prepared test reports
• Responsible for preparation of Test cycle/progress reports, analysis of defect metrics and implement improvement actions for next iterations.

Environment: QTP, HP Quality Center, VBScript, PL/SQL, SQL, Unix, Oracle 10g, Netezza, JIRA, Java, Autosys, Toad, AQT, Subversion, Weblogic, Selenium WebDriver/IDE, JavaScript, Junit, TestNG, Ant, HTML, XML, XPath, CSS, Firebug, FirePath

Confidential

Software Quality Assurance Analyst

Responsibilities:

• Prepared the test plans, designed and executed the test cases.
• Designed detailed test specifications based on business requirments to implement them for various conditions of each rule, including negative and positive testing
• Automated the test cases in QTP using VBScript for the system and regression testing
• Performed defects analysis, tracking and generating reports using the HP Quality Center and arranged the quality assurance meetings for the production defects.
• Worked with developers on resolving the defects. Analyzed test results and reported the necessary corrective actions.
• Performed the integration testing of the interaction between the Service Fulfillment Cramer modules to the various external interfaces
• Performed functional and business requirements analysis to map the Cramer Inventory management system's functionality to the actual business requirements
• Generated the web reports for the Inventory based content.
• Checked the accuracy of the web reports, by comparing them with Cramer GUI and/or in the database using SQL.
• Participated in the British Telecom client conference calls.
• Have created on-boarding documents for "New Employees" and provided training on the application flow and standard testing procedures being used.
• Performed tracking of the order flow at each and every stage through Cramer and finding out the discrepancies in the flow and reporting them.

Environment: - Cramer OSS 5.1, Oracle 10g, Java, PL/SQL, SQL, Unix, QTP, HP Quality Center, Toad, Tortoise SVN, HTML, VBScript