Qa Lead/sr. Qa Analyst Resume
Toronto, On
PROFESSIONAL SUMMARY:
- Over 8+ years of professional experience in IT industry wif emphasis on software Quality Assurance.
- Expertise in Selenium Automation, Web - Service & Mobile Application testing, Manual Testing and Data base (ETL ) tester.
- Strong ability to compile Java programming (Core Java) including Class, Method, Inheritance, Encapsulation, Thread, Loop, Exception Handling etc.
- Expertise in applying Selenium WebDriver/Selenium Grid, Java, TestNG, GitHub/SVN, Jenkins, Maven to cover both web and mobile app UIautomationtesting.
- Proficient in Web Service Testing (XML) and RESTful API Testing (XML & JSON) through WSDL by using SOAP UI Pro.
- Specialized in designingautomationtest framework from scratch using Java programming, TestNG annotations, user-defined function libraries, loops, checkpoints, parameters, Data Provider, JDBC connector, POM and Page Factory of Selenium WebDriver.
- Extensive documentation skill and experience in requirement analysis, test plan and test strategy definition, use case/SOW interpretation, test scenarios/test cases anatomy, RTM (Requirements Traceability Matrix) and test report preparation etc.
- Produced Daily Defect Reports, Daily Test Progress Reports, and Test Completion Report including presenting to and obtaining sign-off from the key stakeholders.
- Actively participated in retrospective meetings & lessons learned meetings and provided feedback.
- Sound noledge and experience in creating clear, concise defect report wif JIRA, HP QC/ALM through whole defect lifecycle of open, assign, fix, retest, close.
- Best practice of complex SQL query statements creation utilizing various RDBMS (relationship database management system) including Oracle/Microsoft SQL Server/MySQL database.
- Good experience in database testing using SQL, TOAD and SQL Developer.
- Good product noledge in Canadian banking and insurance, e-commerce, retail and telecommunications domains.
- Demonstrated experience wif whole phases of software development & testing life cycle (SDLC & STLC) including requirement gathering, test planning, test case(script) design, preparation and execution, defect tracking and reporting by applying Agile, Waterfall methodologies.
- Proven experience wif various types of testing including Smoke/Sanity testing, SIT, Regression Testing, UAT/PAT Testing, Functional/Non-Functional Testing, Mobile Web/App Testing, CI Testing etc.
- A detail-oriented, self-motivated, good team player and quick learner wif strong analytical, trouble-shooting, coordination, communication and interpersonal skills; able to work in a fast-paced environment wifin minimum supervision.
TECHNICAL SKILLS:
Testing Tools: Selenium IDE/RC/WebDriver, SOAP UI, Jenkins, GIT, JMeter
Languages: JAVA, HTML, XML
IDE: Eclipse
Test Framework: Junit/TestNG, Data Driven Framework.
Web Debugging Tool: XPath, Firepath, Firebug.
Build Tool: Ant, Maven.
Processes: Agile-Scrum, Waterfall.
Bug Tracking Tools: JIRA, Quality Center (QC), HP ALM
Databases: SQL, MS Access, Oracle
Operating Systems: Windows (All Variants) Linux.
Other Tools: Browser Stack, TestRail, Subject-7.
PROFESSIONAL EXPERIENCE:
Confidential - Toronto, ON.
QA Lead/Sr. QA Analyst
Responsibilities:
- Responsible for gathering functional requirements and design document from business analyst and developers.
- Actively participated in walkthroughs of Business Requirements Documents (BRD), Functional & Technical Design documents, and provided feedback.
- Reviewed and understood the requirements and design of the mobile banking application.
- Documented the test plan identified wat types of tests, environments and data required for mobile banking application testing.
- Created test scenarios and test cases to test the mobile application using the smart phones in the test environment
- Performed test planning, test execution and test analysis on mobile application using different smart phones like (IPhone, IPod, Blackberry, Android and IPad).
- This application is tested by using Agile/scrum methodology.
- Identified and installed different vendor mobile OS simulators on the desktop computer and tested on each simulator
- Worked closely wif Developer and DBA in identifying the test environments for test execution of mobile banking application.
- Tested Bill payment module by validating the following: register bills for payment, pay registered bills, postdated bill payment.
- Tested Transfer module by validating the following: email money transfer and one-time funds transfer and also validated balances, deposits and wifdrawals.
- Performed extensive security testing on the mobile banking application by validating the XML file encryptions
- Performed System integration testing wif Interac Payment Gateway to validate the Email Money Transfer functionality by verifying the recipient email.
- Performed parameterization of the automated test scripts in Selenium to check how the application performs against multiple sets of data Contributed in developing Automation Framework dat uses Java, Selenium WebDriver and TestNG.
- Written and modified the automation test scripts as per requirement changes for every release using Selenium Web driver.
- Worked in Regression testing, Parallel Processing using Selenium Web driver in TestNG.
- Integrated TestNG wif Selenium using Eclipse to generate test execution result.
- Developed Selenium test scripts for identified test cases by using data driven, keyboard driven and hybrid framework.
- Managed the Framework dependency jars using Maven.
- Tested all mobile baking features on both Native and Web browser version and reported defects wif proper priorities and severities in Quality center.
- Executed testing on both native and web version using different carriers wif 3G and wi-fi networks.
- Performed negative testing to check if the data transmission functionality is working properly if the 3G connection is dropped and validated the transactions at the backend.
- Performed Network bypass testing on the physical devices to verify the data transmission.
- Performed regression testing to confirm bug fixes were valid and to verify proper functionality of the back-end system as well as application.
- Reported and tracked the defects using JIRA bug tracking tool.
Confidential, Maryland, USA.
Sr. QA Engineer
Roles and Responsibilities:
- Performed Functional Testing Integration testing and System testing
- Prepared Selenium Scripts for the Smoke Test and major modules to minimize the manual testing time.
- Regression testing for the bug Fixes
- Executed test cases and verified actual results against expected results
- Mobile Testing using Real Devices and Virtual Devices in Browser Stack
- Performed Browser compatibility testing using Browser Stack.
- Defect tracking and reporting by using JIRA.
- Preparing Daily Status report
- Written Test Cases dat described the steps needed and the expected results
- Designed and executed Manual Tests for Smoke Testing, System Testing, Positive/Negative Testing, Integration Testing, Regression Testing and Functional Testing.
- Involved wif SOA architecture which include Soap Web Service and RestFul Web Service Testing.
- Involved in testing Web services and XML wif tool called SOAP UI and using this tool to locate WSDL file on internet
- Created Test cases and executing them.
- Analyzed test results, tracked the defects and generated reports using JIRA.
- Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
- Participated in weeklyQAmeetings and Bug review meetings wif the Dev andQAteams.
- Provided technical support to the UAT tester during UAT testing by providing training on how to perform UAT testing
- Outlined the UAT defect tracking process and provided walk through to the end users
- Regularly participated in Test Review and Status meetings
- Provided planning and execution status reports to the management
- The project is developed by using Agile/Scrum methodology hence actively participated in daily scrum meetings and delivered the tasks wifin the timelines.
Environment:Windows XP, Java, Java Script, XML, Oracle, SQL, MS Office, MS Share Point, IOS iPhone SDK, Android, Blackberry OS, UNIX and Oracle, Selenium WebDriver, Cucumber, Jenkins, TestNG, Maven, Eclipse, JIRA, SQL
Confidential
ETL Database tester
Responsibilities:
- Involved in creating source target mappings based on the Technical Design requirements
- Involved in Business analysis and requirements gathering
- Tested design strategy of the Extract, Transform and Load for various ODW tables
- Tested mappings wif the Design Documents and performed testing for various sample data
- Tested various mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings
- Preparation of technical specifications and Source to Target mappings
- Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
- Extensively worked on backend activities by writing complex SQL queries for testing several reports developed byBIreport authors.
- Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues
- Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries
- Extensively used Pentaho PDI (Spoon) for extraction, transformation and loading process
- Extracted data from various sources like Oracle, flat files and SQL Server
- Applied appropriate validation rules and created workflow parameters to check the validations are correct so dat the workflow execution should stop
- Created lookup files where necessary for validation of critical enterprise codes and service numbers.
- Created different user defined functions for applying appropriate business rules
- Written test cases and completed test documentation
- Created ETL test data for all ETL mapping rules to test the functionality of the Pentaho jobs.
- Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
- Tested the ETL AB Initio graphs and other ETL Processes (Data Warehouse Testing)
- Worked in 24x7 execution support for the pre-production support in UAT team.
- Tested the performance of the Pentaho jobs.
- Executed batch processing and verified the jobs status and data in database tables.
- Tracked the defects using JIRA and generated defect summary reports.
- Wrote shell scripts to run PL/SQL programs and job scheduling.
- Prepared status, summary reports wif details of executed, passed and failed test cases.
- Participated in regular project status and review meetings.
Environment: Windows XP, Windows 2000/XP, Pentaho PDI, VB, VB.NET, Oracle, ODBC, HTML, XML, JIRA, SQL, UNIX, Autosys.
Confidential
Associate QA Analyst
Responsibilities:
- Involved in Scope Analysis and creating of the Test cases by reviewing use cases
- Involved in writing Test Scripts for the main application functionality such as validation, business workflow.
- Played the role of Manual Tester to analyze business requirements, understanding design specifications tounderstand application functionality.
- Prepare detailed Test Cases, Test Scenarios, and schedules based on Requirements and Design documents andexecuted according to the test plan.
- Executed and maintained manual test cases. Performed Functional, System, and Regression Testing.
- Prepared detailed status reports and updates the status to the business and technical teams during weekly review meetings.
- Involved in manually testing of various modules of the application to ensure application stability and functionality.
- Conversant wif analyzing requirements and defining high level and low-level test requirements and detail testcases.
- Performed System, Regression, Functional and User Acceptance testing.
- Conducted functionality, interface and integration testing during the various phases of the project.
- Involved in the project Kickoff meetings, Verification and Walk through meetings wif team.
- Performed Defect tracking in Quality Center. Designed scripts in Test Plan, and performed execution in Test Lab.
- Generated daily execution reports from Report Module in QC.
- Assisted developers wif reproducing defects and providing additional information as needed.
- Performed well wif strict deadlines in various subsystems sharing different requirements
- Documented ‘Requirement Traceability Matrix’ and linked the requirements to test cases to ensure test coverage
- Executed tests in QA environment by executing test cases for smoke, functional, inter System, integration, end toend, security, penetration, cross browser, regression, user acceptance and batch testing
- Identified and reported defects in quality center wif the respective priority and severity
- Performed backend testing using UNIX scripts and SQL queries to verify the Integrity of the database
- Developed SQL queries using rapid SQL to test business process of financial modules in the application
- Provided status reports on daily basis to the management
- Test Management and defect tracking was done using Quality Center 9.0
Technologies Used: Manual Testing, Quality Center, HTML, Java, Windows, MS Excel, MS power point.