PROFESSIONAL SUMMARY:

• Experience in designing complex SQL queries for databases like Oracle, Teradata, SQL Server.
• Experience in Datawarehousing Testing which includes - ETL Testing, Database Integration Testing, Cognos Cube Testing, Batch Process Testing.
• Developed and executed plan for data profiling and BI (Business Intelligence) reports.
• Planned, developed, and tested extensive data integration process (PL/SQL) to resolve the issues with mapping transformations.
• Detailed approach for ETL Testing - transforming the input files such as XML, Excel File into the database using import/export functionality of databases, creating the SQL files which will intact the transformation logic based on requirements and comparing the SQL Result with the Target databases.
• Developed inline view queries, and updated SQL Queries to improve the query performances.
• Designing complex SQLs, Matching the data set and rectifying the reason for the data issues, and reporting back to Development team for defect fixes.
• Identifying the data related issues - Data Loss and making sure the data integrity.
• Designed Unix Shell Scripts and command line utility to interact with Informatica server from command prompt.
• Scheduled ETL Loads for SIT and/or UT in the testing environment in the Informatica.
• Performed Functional, Negative, Regression tests on enhancements to the web application. Involved in Smoke, Integration, System, Retesting and Regression Testing.
• Worked as a Customer interaction and QA Lead QA Role by managing the project from start-up until project deliverables.
• Experience in Test Management activities such as Test Planning, System Study, Requirement Gathering, Test Scenario identification, Test Case Design and Execution, Defect Life Cycle.
• Good experience on working with Automation Functional Testing Tool Selenium 2.0 using Java.
• Experience in testing with tools such as Selenium Web Driver, and cognizant in-house Automation Test framework.
• Extensively used Selenium WebDriver (data-driven, XPath locators) to test the web application.
• Extensively used Firebug and Fire path for Firefox browser and XPath helper for Chrome browser to retrieve XPaths of the elements.
• Experience with Setting up Selenium tools from scratch and configured various other peripherals tools to performed Selenium test. Java Setup, Setup Eclipse and Webdriver client. Configuring Eclipse with Webdriver, Adding APOI and Log4j jars and installing TestNG.
• Good experience with Core Java to develop tests in Eclipse IDE for Automation using Selenium WebDriver.
• Experience in developing, maintaining and executing Automated Test Scripts Using selenium.
• Good experience on working with Test Management Tool QC 10.0, ALM 11.0, ALM 12.0.
• Guiding and mentoring the team members and knowledge transition of the system. Participated in Weekly QA status meetings, Scrum meetings and coordinated with the Developers and Business Analyst to resolve and close defects.
• Experience in working with different domains such as Life Sciences, Man log (Manufacturing and Logistics).
• Appreciated by Manlog CG (Customer Goods) Practice
• Appreciated by Confidential Innovation for IISP project in Year 2010.

TECHNICAL SKILLS:

Testing Tools: Selenium, WebDriver(Java), Load Runner 8.0

Database Tools: Informatica, Toad, Teradata

Languages: VB Script, Java, C#, C++, PL/SQL, Excel Macro Handling (using VB Script), Oracle9i

Defect Tracking Tools: JIRA, QC/ALM, Bugzilla, Rational Clear Quest

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome Management

Version Control Tools: SVN, Visual Sourcesafe

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Automation & Manual QA Lead

Responsibilities:

• Responsible for Project Estimates, Allocating and defining the project scope and timelines for QA Activities
• Worked on ETL Testing, Database Integration Testing (Teradata). worked on Framework development in Eclipse IDE using Selenium WebDriver and Java.
• Developing scripts using Cognizant in-house Automation framework for designing and executing test scripts.
• Extensive use of Fire Bug, Fire Path, Xpath, CSS Selector, ID, Name locators are used to identify objects
• Enhancing test cases using Java Programming features.
• Developing, Debugging, and Executing Automation Test scripts for the manual test cases.
• Performing Regression and smoke testing.
• Involved in regression and retesting the application and closing the defects.
• Client Interaction and QA Lead role.
• Guiding/Mentoring the team members and knowledge transition of the application.
• Have faced Project audits for maintaining and improving the project quality and standards.
• Test Management - System Study, Requirement Gathering, Test Scenario identification, Test Case Design and Execution, Defect Management
• Complex SQL Query design, identifying data related defects such as data loss, and making sure the data integrity.
• Involved in Reviews, Team meetings and scrum calls with Oracle development team.
• Conducted UAT Testing for the application.

Confidential

Sr. Test Lead

Responsibilities:

• Client Interaction and QA Lead role.
• Guiding/Mentoring the team members and knowledge transition of the application.
• Have faced Project audits for maintaining and improving the project quality and standards.
• Test Management - System Study, Requirement Gathering, Test Scenario identification, Test Case Design and Execution, Defect Management
• Complex SQL Query design, identifying data related defects such as data loss, and making sure the data integrity.
• Involved in Reviews, Team meetings and scrum calls, generating status reports.
• Conducted UAT Testing for the application.
• Appeared for Project Audits and work-arounds for maintaining the project standards and quality. Change in plan in order to mitigate the project risks.

Confidential

Sr. QA Lead

Responsibilities:

• Guiding/Mentoring the team members and knowledge transition of the application.
• Involved in Operational Qualification (OQ), Validation Planning and Strategizing the test process.
• Test Management - System Study, Requirement Gathering, Test Scenario identification, Test Case Design and Execution, Defect Management
• OQ Test Case Design, Execution, Defect Management
• Prepare Validation Summary Reports
• Involved in regression and retesting the application and closing the defects.
• Involved in Reviews, Team meetings, generating status reports.

Confidential

Sr. QA Lead

Responsibilities:

• Performed smoke test after every build deployment and reported the defects at early project stage.
• Identify Test Scenarios, and Test approach based on the Align Data Consumption.
• Prepare Estimates, defining project scope, and timelines for testing activities.
• Test Management - System Study, Requirement Gathering, Test Scenario identification, Test Case Design and Execution, Defect Management
• Complex SQL Query design, identifying data related defects such as data loss, and making sure the data integrity.
• Involved in Reviews, Team meetings and scrum calls, generating status reports.
• Conducted UAT Testing for the application.

Confidential

Sr. QA Lead

Responsibilities:

• Prepare Estimates, defining project scope, and timelines for testing activities.
• Test Management - System Study, Requirement Gathering, Test Scenario identification, Test Case Design, SQL Design and Execution, Defect Management
• Involved in Reviews, Team meetings and scrum calls, generating status reports.
• Complex SQL Query design, identifying data related defects such as data loss, and making sure the data integrity.

Confidential

Sr. QA Lead

Responsibilities:

• Designing complex SQL Queries, identifying the complex data scenarios and rectify the problems such as data loss, data integrity and/or duplicate data in the target database.
• Exporting the data from the difference sources such as XML, Excel, Flat files into the source database and then comparing it with the staging tables and in the target databases.
• Peer review the test cases, SQLs, and test results.
• Involved in Reviews, Team meetings, attending relevant Programs, status reports.

Confidential

Test Engineer

Responsibilities:

• Understanding MDM and Siebel CRM systems.
• Analyzed System requirements specifications (SRS) and High Level Design documents to understand the functionality of the application.
• Involvement in preparation of Test scenarios, Test cases design and execution.
• Prepare Test Reports, design SQL Queries and report the data related defects.

Confidential, Pennsylvania

Test Engineer

Responsibilities:

• Understanding ELN workflows for different types of experiments.
• Validation Testing activities such as OQ, IQ, & PQ
• Involvement in preparation of Test scenarios, Test cases design and execution.
• Prepare Test Reports, QA metrics preparations.

Confidential

Test Engineer

Responsibilities:

• Unix Testing - Batch Process Testing (Backend processing)
• Integration Testing - SAP Implementation in client domain - Publishing documents which brings Customer, Employee, Material master data feed into SLD TNG
• Identify critical business flows for Load Testing.
• Identifying Scenarios for LR Script, Recording LR Scripts.
• Enhancement of LR Scripts - Parameterization, and Correlation.

Confidential

Test Engineer

Responsibilities:

• System Study, Business Scenario analysis, Test Case Design