Vishnu Priya.
Automation & Manual Test Engineer.
D&B Cloud Innovation Center Canada Phone: +1-647-***-**** mail:acthtk@r.postjobfree.com
Career Objective
To pursue a highly rewarding career, seeking for a job in challenging and healthy work environment where I can utilize my skills and knowledge efficiently for organizational growth.
Experience Summary
7 Plus Years of extensive IT experience in Automation, Manuel Testing and Development of software applications.
Extensive experience in generation of test scenarios and test cases from business requirement documents both for Automation and Manual.
Experience in REST API Testing (Junit).
Developed automation scripts with a multi-browser framework in Selenium WebDriver API.
Experience in Sanity, Backend, Front-end, functional, System integration, Regression, Smoke, Cross browser, Cross platform, Black box, Accepting testing, GUI application testing.
Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
Experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
Experience in testing and writing SQL statements.
Proficient experience in different Databases like Oracle, SQL Server, DB2.
Excellent skills in Bug Reporting using JIRA.
Participated SCRUMs, planning, grooming, review and retrospective meetings in Agile environment.
Excellent written and verbal communication skills in fast-paced, demanding and team-oriented settings, independent and self-motivating.
Good knowledge in Software development life cycle. Provided end-to-end system solutions for various business functions in Insurance and Banking domain projects.
Coordinated testing activities with different testing teams at multiple locations. Prioritize and manage own workload in order to deliver quality results and meet timelines.
.
Technical Skills
Programming Languages
C, C++, JAVA, SQL.
Web Technologies
JSP, HTML, Java Script,, XML, Web Services, J2EE.
Tools / Special Software
RAD, Eclipse, TOAD,SQL Management tool, JIRA, TeamCity, Selenium Webdriver, SOAP UI, Bugzilla, Postman, Gradle, Docker, Jenkins, Sensu, Kibana, WebStrom, RabbitMQ, Github, Confluence, Testrail
Database
Oracle 7.x, 8.1.6, 10g, MS Access, SQL Server 2008, Redis, Postgress
Application Server
Apache Tomcat, Web Sphere
Operating System
Mac OS X 10.9.5,UNIX, Windows 98/XP/2000/03/07
Methodologies
Agile and Waterfall.
Projects
Project 1:
Duration: Nov 2014- Till date.
D&B Cloud Innovation Center.
Software Engineer in Test Vancouver, BC, Canada
Environment: JIRA, Eclipse, Selenium Webdriver, Docker, Gradle, Jenkis, Postgress, Github, TestNG, Java, Javascript, SOAP-UI, Postman,Gradle, Kibana, Sensu, Algile, RabbitMQ, Redis, Testrail, Mac OS X.
Roles & Responsibilities
Interacted with Business Analyst and Project Manager to gather business and functional requirements.
Developed the automation scripts for function testing and executed the automation scripts.
Performed Gap analysis, by identifying any missing information in the requirements and reported them to the author.
Organized requirement review session with the business analyst to understand the project and requirements in detail.
Involved in creating Master test plan, by outlining testing assumptions, risks & mitigation, roles & responsibilities, build management process, change request flow and entry criteria
Created test cases based on use cases, non-functional requirement document
Created Test scenarios and Test cases and mapped test cases to requirements to ensure requirement coverage.
Manage and execute Selenium Automation script for Functional and Regression testing .
Written and managed REST API tests for the application.
Verified the test data in the test environment and mapped to specific test cases.
Identified Sanity test cases based on the business priorities and executed as part of testers acceptance testing.
Reported defects in JIRA, with proper priorities and severities.
Performed functional and Data-driven testing by using Automation Frame Work's like TestNG, Data-driven Frame work.
Integrated with developers and discussed technical problems, reported bugs and supported development team.
Project 2:
Duration: Aug 2014- Sep 2014 .
Insurance Corporation of British Columbia
Test analyst Vancouver, BC, Canada
Environment: IBM Infosphere DataStage Designer, IBM DataStudio, JIRA, MySQL.
Roles & Responsibilities
Tested ETL Mappings based on Business requirements and business rules to load data from legacy source flat files and RDBMS tables to target tables.
Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the business rules with in the transformation.
Verified data integrity check on the tables for Primary Key and Foreign Key relationship.
Performed data validation of duplicate data is not loaded, NULL value fields and record count match.
Verified that all field data is loaded without any truncation and rejected data with proper error logs.
Build and executed complex SQL queries using JOINS, UNION, Nested queries and SELECT statements to validate source data to migrate from source to staging database.
Performed regression testing to prove that the new code has no adverse effect upon the current system particularly in the area of corrupting data used by different applications or system performance.
Created defects and managed defects life cycle of the project using JIRA.
Interacted with the application development teams to resolve the issues through defect calls. Provided in-depth detailed information to developer to resolve defects.
Project 3:
Duration: April 2012- Jan 2014.
Wawanesa Insurance
Application Developer Winnipeg, MB, Canada
Technology and Tools: Java, SQL Server 2000, Eclipse, Selenium webdriver, Websphere, JIRA, Confluence, SVN.
Roles & Responsibilities
Involved in organizing Requirements review sessions by inviting all the QA, SA and BA's of the project.
Preparing and publicizing Test summary and Defect summary reports in the collaboration portal.
Execute test scripts and troubleshoot the issues found.
Performed Regression testing to test the impact of bug fix.
Performed the positive and negative for Web client screens validation.
Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
Updated existing and documented new functional and non-functional requirements depending upon existing change requests, new features or business modifications documented in issue log.
Performing "gap-analysis" of the Business and Testing Requirements documents
Performed Regression testing upon receiving new builds and updated the Scripts accordingly.
Creation of the Test cases in a standard template which would be uploaded onto SharePoint site.
Performed Data Driven Testing, Functionality Testing GUI Testing, Regression Testing.
Providing UAT Support for Business Users understanding of the newly developed application.
Participated in Test cases review sessions with BA's and Development teams.
Ensuring all the process and procedures are followed throughout the test life cycle.
Test new features and career site updates for existing clients in Testing and Production environments.
Performed backend testing to verify the data integrity by passing SQL commands.
Resolve issues arising after each build, assigned priorities to tasks and suggested solutions and methodologies to overcome problems and streamline everyday processes
Project- II
Wawanesa Insurance
Application Developer Winnipeg, MB, Canada
Technology and Tools: Java, JIRA, Selenium Webdriver, Eclipse, SVN, Oracle SQL, SQL Server 2000.
Roles & Responsibilities
Involved in organizing Requirements review sessions by inviting all the QA, SA and BA's of the project.
Preparing and publicizing Test summary and Defect summary reports in the collaboration portal.
Execute test scripts and troubleshoot the issues found.
Performed Regression testing to test the impact of bug fix.
Performed the positive and negative for Web client screens validation.
Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
Updated existing and documented new functional and non-functional requirements depending upon existing change requests, new features or business modifications documented in issue log.
Performing "gap-analysis" of the Business and Testing Requirements documents
Performed Regression testing upon receiving new builds and updated the Scripts accordingly.
Creation of the Test cases in a standard template which would be uploaded onto SharePoint site.
Performed Data Driven Testing, Functionality Testing GUI Testing, Regression Testing.
Providing UAT Support for Business Users understanding of the newly developed application.
Participated in Test cases review sessions with BA's and Development teams.
Ensuring all the process and procedures are followed throughout the test life cycle.
Test new features and career site updates for existing clients in Testing and Production environments.
Performed backend testing to verify the data integrity by passing SQL commands.
Resolve issues arising after each build, assigned priorities to tasks and suggested solutions and methodologies to overcome problems and streamline everyday processes.
Project 4:
Duration: Dec 2009 to 2012 Mar.
Wipro Technologies, India
Project Engineer Bangalore, India
Technology and Tools: Java, Bugzilla, SVN, Oracle SQL,SQL Server 2000
Roles & Responsibilities
Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
Attended bug review meetings, weekly status meetings, project meetings, walkthrough and interacted with business analysts and developers for defects resolving, defect reporting, analysing, tracking and report generation.
Involved in organizing Requirements review sessions with the QA, SA and BA's of the project.
Performed Regression testing to test the impact of bug fix.
Prepared Traceability Matrix with requirements versus test cases
Test new features of the application for existing clients in Testing and Production environments
Performed the positive and negative for Web client screens validation.
Project- II
Wipro Technologies, India
Project Engineer Bangalore, India
Technology and Tools: Java, Bugzilla, SVN, Oracle SQL,SQL Server 2000
Roles & Responsibilities
Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
Participated in Test cases review sessions with BA's and Development teams.
Worked on testing ETL solutions testing data at different stage using SQL queries.
Written SQL queries to retrieve data from DW(data warehouse).
Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the business rules with in the transformation
Ensuring all the process and procedures are followed throughout the test life cycle.
Involved in organizing Requirements review sessions with the QA, SA and BA's of the project.
Prepared Traceability Matrix with requirements versus test cases
Professional Certifications
Professional Certification
Java Standard Edition 6 programmer certified professional (SCJP) - 2010
EDUCATION
Bachelor’s Degree in Electronics & Communications (B.E.)