Resume

Sign in

Etl testing, automation testing with selenium

Location:
Etobicoke, Ontario, Canada
Posted:
September 22, 2018

Contact this candidate

Resume:

Nehal Vyas

***, ***** ***** *****

Etobicoke, ON M9V2E3

+1-647-***-****

ac6424@r.postjobfree.com

Sr. QA Analyst and Team Lead with 14 years of experience in Manual and automation web Testing, Database and ETL Testing, System Analysis, software development

Summary

Experience in the complete life cycle of project development (SDLC), System / Business Analysis, Design, Development, Testing, End User Training & Documentation skills.

Ability to interact professionally with all levels of the organization, discuss problems, resolve conflicts, and attain satisfactory solutions

Having Excellent problem – solving and leadership skills.

Ability to interact professionally with clients, discuss problems, resolve conflicts, and provide satisfactory solutions.

Hands-on experience in performing Database and ETL testing, Automation web testing using Selenium, unit testing, system and integration testing, middleware testing, experience of agile methodology, and has an outstanding ability in designing & executing test cases and reporting skills as per the functional requirement documents.

Involved in management activities and well versed with Software testing procedures.

Core Strengths

Team Management

Estimation and Planning

ETL and Database Testing

Automation web testing with Selenium

Manual Web Testing

Technical Skills:

Hands on Experience in ETL testing as well as database testing.

Hands on Experience in Automation Testing using Selenium with TestNG framework and Java programming language and manual web testing.

Strong working knowledge of SQL and PL/SQL.

Strong working knowledge of Bug Reporting tool HP QC ALM 11.52

Experience in ETL Tools Informatica PowerCener by running and monitoring the workflows and Microsoft Azure SQL Data warehouse.

Experience in MS SQL Server 2000/2005, IBM DB2, and Oracle by creating queries and stored procedures, views, functions.

Sound working knowledge of Microsoft tools.

Employment History

Accenture (India) Private Ltd. From November 2016 to January 2018

Company promoted me as Software Test Lead in December 2017

Started working as Application Development Senior Analyst in November 2016

Fusion Business Analytics: The prime objective of Fusion Business Analytics project is to help the client create an analytics solution to enable self-service BI, support analytics, robust visualization. The project includes ETL Informatica module, Azure module and reporting module.

Technologies used: Informatica Power Center, QlikView Reporting tool, Microsoft Azure SQL Data warehouse, HP QC ALM 11.5, Selenium with TestNG and Java.

Worked as QA Team Lead

Communicated with US Based client and US based onsite members regarding the requirement and status. Attending status calls, requirement understanding calls.

Prepared the various reports like daily/weekly status report, Monthly Metrics, Test Closure Report.

Created master test plan and other documents for test planning and estimation

Identified the test scenarios and Created and uploaded the Test scripts and created Requirement Traceability Matrix in HP Quality Center tool.

Actively involved in System testing of the project that includes ETL Testing and Report testing.

Running and monitoring the workflows in Informatica Power Center to load data in SQL Data Warehouse from existing Oracle database, Preparing and running SQL queries to validate the data loaded in SQL Data Warehouse, Validating the facts and dimensions along with transformation in SQL Azure Data Warehouse using SQL/PL SQL according to mapping sheet, validating the reports generated in QlikView, Qliksense.

Created the test scripts using selenium for Regression testing of Reports.

Monitoring defect status and tracking them to closure using the ALM.

Performed a key role in integration testing by coordinating upstream project members, onsite coordinators and providing the status report to client.

Actively involved in User Acceptance Testing (UAT) by creating UAT test cases and supporting the client with the testing process.

IBM (India) Private Ltd, Parent Company: Artech Info-systems

From August 2014 to February 2016

Joined the company as Sr. Software Engineer

Project 1: Campaign Management Data Warehouse (CMDW): The project is for US based Insurance Company. The strategic Campaign Management project for initial launch (MVP) covers the Data integration and Channel Integration work streams.

Technologies used: DB2, HP QC ALM 11.5, SQL, Informatica Power Center and Soap UI

Worked as QA Team Lead

Attended requirement walkthroughs and provided the requirement understanding to the resources working on the project.

Actively Worked with Project manager for resource identification and selection.

Created the data mapping sheet as per the requirement document.

Communicated with the US Based client and the US based onsite members regarding the project status.

Actively involved in the generating the test scenarios and test scripts based on the requirements and mapping sheet.

Created the SQL scripts to validate the data integration of the project.

Participated in middleware/web service testing using Soap UI.

Actively involved in Integration testing of the project by coordinating with upstream members, onsite coordinators.

Project 2: Salesforce.com (SFDC): (about the project)

Technologies used: Selenium with TestNG framework and Java.

Created the automated test scripts using selenium for Regression testing of the SFDC website.

Avon Corporation Ltd, India From April 2009 to November 2012

Joined company as System Analyst

Coordinated with clients for requirement understanding and Created Functional Requirement Document.

Coordinated with company management for project status and developer team lead to provide requirement understanding.

Performed the manual web testing and database testing for the Customer Relationship Management (CRM) software.

TM Systems Pvt. LTD., Ahmedabad From September 2008 to February 2009

Joined company as Software Developer and Tester

Developed and tested the report generation tool for the company that enable clients to generate customized reports as per the requirements using the technologies C#.NET 2005, MS SQL SERVER 2005

Vyasil Infotech Pvt Ltd. From March 2008 to September 2008

Joined company as Software Developer

Developed the inventory management software using the technologies C#.NET 2005, MS SQL SERVER 2005 and Crystal Reports.

Anik Computers & Technology, India From December 2003 to February 2008

Joined company as Software Developer

Developed the software for Insurance agents using Visual Basic 6.0 – Oracle 8.0

Education

NAME OF THE DEGREE PASSING YEAR

Diploma in Electrical Engineering 1998

From Technical Education Board, Gujarat, India

Post Graduate Diploma in Computer Application 2003

From Bharatiya Vidya Bhavan, Gujarat, India

Bachelor of Arts with Sociology 2000

From Gujarat University, Gujarat, India



Contact this candidate