SUMMARY:

• Around 11 years of experience in Automation (Selenium WebDriver) and ETL/DWH/BI Testing initiatives.
• 3+ years of proven ability in developing Selenium WebDriver Automations using testNG, CUCUMBER BDD, Java, Javascript, AngularJS (protractor), Jasmine.
• Integration of smoke and regression automation suite with continuous integration tools like Jenkins
• Achieved dollar savings and excellent ROI by automating entire regression suite for SCIOMINE application
• 5 years of experience in working closely with QA Managers from client location(Charlotte NC USA)
• Good Knowledge in Mapping/workflows in Informatica and SSIS, dashboards and workbook in Tableau reporting tool.
• Experienced in creating/ executing web services test scripts in Parasoft and SOAP UI (HTTP and MQ)
• Excellent experience in each phase of Test Life cycle, Estimations, Test Plans, Test Strategies, Agile/waterfall lifecycle, Defect management/ reporting.
• Coordinated with Business users during User Acceptance Testing for several projects
• Experienced in writing complex SQL Queries to validate the Data Warehouse/ Mart tables.
• Good experience in leading large projects both at onshore and offshore.
• Strong knowledge in test management tool like JIRA, HP Application Lifecycle Management.
• Maintained the automation code in SVN over the time for improvements and new features.
• Strong knowledge in database tools like Toad for Data Analyst, Toad for ORACLE, Squirrel Client for Netezza, Aginity for Netezza, Nexus by Teracom and Teradata SQL Assistant. Experienced in Running the Autosys jobs through iXP/UNI

TECHNICAL SKILLS:

Automation tools: Selenium WebDriver, Rational Functional tester

ETL Tools: Informatica, SSIS

Reporting Tools: Tableau, Microstatergy

Database: Oracle 9i/10G, Netezza, SQLserver

Middleware Tools: Parasoft, SOAPUI

Test Management tool: HP ALM, QC

Scripting Languages: Java, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential

Automation Test Lead

• Experience in resource planning, scope assessment, testing framework, reporting metrics, communication plan, defect metrics, change management.
• Ensured the automation effort, schedule and prioritization is in the right direction, while leading the automation team.
• Allocating work packages to the team along with continuous monitoring and mentoring of the team members.
• Create daily status reports and keep all the concerned stakeholder apprised of status / risks for respective features.
• Preparing Reusable functions to improve robustness, re - usability, and maintainability of their test scripts.
• Reviewing the product requirements, functional and design specification documents to determine and prepare automated test cases.
• Working closely with various Dev team members to understand testing objectives and ensuring that all issues are resolved in a timely and efficient manner.
• Working closely with team members to automate the execution and verification of reports created by all products.
• Provide practical approach to complex product testing, specifically in the areas of the automation of test cases for the purposes of regression testing.
• Ensured that there is a proper coordination between the Management, development and QA to meet automation goals.
• Technologically updated to make use of current technologies to provide extensible automation

Environment: Selenium Web Driver, Java, cucumber BDD, Selenium Grid, Sql Server 2008, Continuous Integration as a part of DevOps, JIRA Confidential

ETL Test Lead

Responsibilities:

• Coordinating with the Business Analysts and Project team to understand the business/test requirements, Project Functional Specification, HLD and LLD.
• Performing test estimates from the business requirements
• Development of System Test Plan based on the Requirements and Design documents.
• Development of Project Plan & Test Estimation based on the project scope
• Creation and Review of Test Scenario, Test Scripts & Test Specifications based on requirements and Design documents.
• Tracking the test coverage through Traceability Matrix
• Preparing Test Environment and Test data.
• Preparation of ETL Test scenarios and Test scripts
• Preparing Smoke test scripts and performing Smoke testing after every deployment
• Preparation of SQL Queries to validate business conditions and backend data.
• Execution of the Test scripts.
• Coordination with other upstream and downstream teams to perform end to end testing
• Addressing any testing issues faced by the test team. This includes test data, business requirements and non-functional aspects
• Reporting the status to project team
• Accountable for Delivering and Clarifying the Use Cases to the Performance/Automation testing groups
• Preparing Causal Analysis Reports.
• Reporting and tracking of defects till closure
• Coordinating User acceptance and Post production testing and obtaining User’s sign off.

Environment: . HP Quality Centre, Informatica Power Center, SSH Tectia Client, Nexus by Teracom, Aginity for Netezza workbench, microstatergy, Tableau

Confidential

Test Lead

Responsibilities:

• Requirement analysis with Business Analyst and Project stake holders
• Design and XSD analysis with System Architects and Developers
• Discussion of the Project Plan with Project and Change Managers
• Preparation of Test plan & Work break down structure for the Testing activities
• Preparation of Test approach document and reviewed with project stakeholders
• Reviewing the System Test Cases and User Acceptance Test Cases with Project Stakeholders
• Participation in the Daily and Weekly Status reporting
• Coordinating End to End Data testing between upstream and downstream
• Conducted the Entry and Exit criteria review meetings with project stakeholders and Business partners
• Preparing and Maintain the QA allocations/Forecast
• Reviewing and Analysing Change Request & its impacts

Environment: . HP Quality Centre, Parasoft, Soap UI, SSH Tectia.

Confidential

ETL Test Lead

Responsibilities:

• Analysis and understanding of Project Functional Specification document, HLD and LLD.
• Development of Design Document, Test Plan and Testing Efforts document.
• Prepared Test Environment and Test data.
• Prepared various documents like Traceability matrix, Causal Analysis Reports.
• Conducted SIT and UAT Testing Artifacts review.
• Managed the SIT Test Execution.
• Publish the SIT Test Execution results.
• Publish the daily and Weekly status Reports to Project team and QA manager.
• Updated daily task status to Onsite Manager.
• Maintaining 100% QA for the applications all the applications which are validated

Environment: HP Quality Centre, Oracle 9i, TOAD, Microstrategy

Confidential

ETL Tester

Responsibilities:

• Analysis and understanding of Project Functional Specification document, HLD and LLD.
• Development of Design Document, Test Plan and Testing Efforts document.
• Co-ordinated with Onshore Team
• Performed peer code review.
• Prepared Test Environment and Test data.
• Prepared various documents like Traceability matrix, Causal Analysis Reports.
• Conducted SIT and UAT Testing Artifacts review.
• Managed the SIT Test Execution.
• Publish the SIT Test Execution results.
• Publish the daily and Weekly status Reports to Project team and QA manager.
• Updated daily task status to Onsite Manager.
• Maintaining 100% QA for the applications all the applications which are validated

Environment: ORACLE 10G, TOAD, QC and PL/SQL Developer