Etobicoke, ON M9V2E3
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
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.
Estimation and Planning
ETL and Database Testing
Automation web testing with Selenium
Manual Web Testing
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.
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
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