Sr. Qa Analyst/ Sr. Test Automation Developer Resume
TorontO
EXPERIENCE SUMMARY:
- Over 6+ years of professional experience in IT industry with emphasis on software Quality Assurance Testing, technology (manual andautomation) of Web based applications and Client server applications.
- Solid understanding in complete Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC), Defect Life Cycle,QAStrategy andQAMethodologies - (Agile & Waterfall).
- Experience in Automation testing using Selenium WebDriver/RC/IDE/GRID, QTP, TestNG/JUnit, Maven/Ant, Cucumber, Appium, Jenkins, SOAP UI and HP Quality Center.
- Excellent experience of build tools likeMavento manage external JARs and managing Javaautomationprojects and dependencies.
- Extensive experience with writing test scenarios onCucumberfeature file.
- Experience in Non-Functional testing using JMeter, LoadRunner, Neoload for performing Load, Volume, Performance, Endurance, Stress and Cloud based testing.
- Experience in monitoring servers using tools like SiteScope, AppDynamics and Dynatrace Performance Viewer.
- Analyze the CPU Utilization, Memory usage, Garbage Collection and DB connections to verify the performance of the applications.
- Generate performance graphs, session reports and other related documentation required for validation and analysis. Publish results and receive appropriate signoff. Prepare detail status reports, and monitoring of all defects and issues.
- Having good exposure to integrated testing artifacts with Continuous Integration (CI)with Jenkins sever.
- Experienced in working on Selenium Web Driverautomationscript in Java for Page Object Model (POM) cross-browser testing. Used testing annotations to group the test methods and for cross-browser.
- Hands on experience in writing the programming of OOPS using JAVA, VB Scripting.
- Extensive experience in implementingQAMethodologies, Test Plans, Test Cases, Test Scenarios and test deliverables for various applications.
- Very good hands on experience with Data Migration Testing, Data Base Testing and Big Data (ETL) testing.
- Excellent understanding of Cloud based technologies e.g.: AWS, Azure.
- Expert in Non-functional and Functional testing, Sanity testing, Integration testing Regression testing, Smoke testing, Black Box and white box testing, UI, and User Acceptance Testing (UAT).
- Experience in using Java as client library for Selenium WebDriver to design and developed Automation test Framework using Junit and TestNG.
- Experience in Mobile APP testing on Android, iPad and iPhone, Emulator, Simulator to perform Mobile App testing, phone functionality and native app testing.
- Good working experience on SOAP UI for testing and validating various web services used in the application.
- Strong experience with SOA architecture which include Soap Web Service and Restful Web Service Testing.
- Expertise in documenting defects with high level of detail, accuracy, and informative recreation steps using Quality Center, HP ALM, JIRA, Zephyr and BugZilla etc.
- Experience in database query manipulation, SQL, PL/SQL statements, stored procedures, and triggers.
- Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment.
- Sound knowledge and experience in creating clear, concise defect report with Confluence, JIRA, HP QC/ALM through whole defect lifecycle of open, assign, fix, retest, close
TECHNICAL SKILLS:
Test Automation Tools: LoadRunner, JMeter, Neoload, Selenium WebDriver, TestNG, JUnit, Selenium Grid, SoapUI and Appium.
Web Technologies: XML, HTML5, Ajax, Java Scripting, CSS, Angular JS.
Database: Big Data (Hive, HDFS, HBase), Oracle, SQL Server, MySQL.
Programming Languages: C, C++, Java, VB Scripting, JavaScript and Python.
Version Control Tools: VSTS, Clear Case, GitHub.
Defect Tracking Tools: BugZilla, HP-QC, JIRA.
Monitoring Tools: AppDynamics, Dynatrace, SiteScope.
Other Tools: HP-ALM, Confluence, SharePoint, Microsoft Visio, Microsoft Project, Windows, Linux.
Cloud Technologies: AWS, Azure.
PROFESSIONAL EXPERIENCE:
Confidential, Toronto
Sr. QA Analyst/ Sr. Test Automation Developer
Environment: Java, JavaScript, LoadRunner, Performance Center, Selenium WebDriver, TestNG, JIRA, Oracle, Jenkins, Soap UI, Eclipse, SQL Server, XML, VB Script and REST
Responsibilities:
- Documented Master test strategy and test plan based on requirements, design and project documents
- Created Test scenarios, Test cases and Test scripts according to requirements and Use case’s documents
- Provided Test scenarios and Test cases to the business analyst for signoff.
- Supported Offshore team as an application lead.
- Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
- Found performance degradation issues like “Out of Memory” problems and improved Thread pool utilization, Memory Leaks, JDBC connection Pool size, & Transaction Rollbacks.
- Analyzed Load pattern and created test scenarios to emulate the real-life stress conditions
- Interacted with the Business Analyst and application teams to discuss the performance requirements and load test strategy
- Developed the performance Test Plans and Load Test Strategies
- Developed Vuser scripts using Web (HTTP/HTML), Ajax (Click and Script), Web Services, Microsoft .Net, ODBC, Oracle NCA, PeopleSoft Enterprise protocols.
- Created customized LoadRunner VuGen scripts Confidential API level with manual correlation, user defined functions, development libraries (classes and methods), and error handling.
- Enhanced Vuser scripts by adding correlations, parameters, condition controls, and checking/validation functions
- Conducted Performance Review of Oracle Database for business-critical applications with Senior Leadership team
- Generated Statspack/AWR reports from Oracle 10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
- Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
- Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
- Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
- Identified test cases to automate. Automated those test cases using Selenium WebDriver, TestNG and Java technologies (Eclipse IDE), contributed in framework creation.
- Responsible for writing and maintain Selenium WebDriver scripts for regression and functional testing using data driven framework.
- Implemented Data Driven, POM using Java, and Selenium WebDriver.
- Involved with S Design and Implemented RESTFUL Web Services using various data format (JSON, XML) to provide an interface to the various third-party applications. OA architecture which include Soap Web Service and Restful Web Service Testing.
- Involved in testing Web services and XML with tool called SOAP UI and using this tool to locate WSDL file on internet, create Test cases and run them.
- Analyzed test results, tracked the defects and generated reports using JIRA and Confluence.
- 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 with 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 walkthrough 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 within the timelines.
Confidential
ETL Tester/ Automation Tester
Environment: Java, JavaScript, LoadRunner, Performance Center, HP-ALM, QTP, SQL Server, Appium and Cucumber.
Roles and Responsibilities:
- Analyzed Business Requirements, Functional Requirement and High-Level Design documents.
- Created LoadRunner Scenarios and Scheduled the Virtual user to generate realistic load on the server using LoadRunner.
- Created and implemented Performance tests using Mercury Interactive LoadRunner.
- Involved in developing the Test Plan Strategy, build the test client and test environment.
- Enhancing the scripts using Generator and performed Parameterization and Correlation to meet the requirements.
- 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 Hive to validate reports and troubleshoot data quality issues
- Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
- Created ETL test data for all ETL mapping rules to test the functionality of the Pentaho jobs.
- Worked on Control-M for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
- Worked in 24x7 execution support for the pre-production support in UAT team.
- Executed batch processing and verified the jobs status and data in database tables.
- Written Test Plan, Test Scenarios and Test Scripts to follow the CMM Level 2 standards.
- Involved in performing load and stress test on the application and server by configuring LoadRunner to simulate hundreds of virtual users and provided key metrics to the management.
- Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data using QTP.
- Performed extensive functional GUI level testing and wrote /modified tests from scratch.
- Created the Regression Test cases and automated them for the purpose of regression testing.
- Implemented QTP for automating the Regression Sets.
- Designed the Data Driven tests in QTP script to validate with different sets of test data.
- Tested the applications response for positive and negative sets of data with data-driven testing procedures.
- Modified the scripts by inserting Text, Bitmap and Synchronization checkpoints.
- Created and managed objects in the application using Object Repository in Quick Test Pro.
- Performed System Testing (SIT), End to end testing across components of banking applications; core banking, ABM, POS, IVR, fraud, AML, financial and non-financial transactions and Functional Testing Confidential field level, screen level and application level for business rules.
- Involved in Mobile Testing includes App Testing. Test automation for web application using Cucumber.
- Involved in testing application on different mobile Platform such as iOS and Android devices.
- Implemented mobile automation frameworks using Appium.
- Performing Cross-platform, Functional, Regression testing, UI testing for mobile Native app, web apps and hybrid apps using Appium test automation framework.
- Experience with Mobile Compatibility testing and Mobile application testing - iPhone, iPads /tablets
- Tracked the defects using HP-ALM and generated defect summary reports.
- RTM - requirement traceability matrix created for defects associated with test cases, test cases mapped with requirements in release cycles are tracing back to requirements for assessing coverage analysis
- Actively participated in Stand-up meeting, walkthrough meeting, weekly assessment meetings and daily bug triage meetings and interacted with developers and business analysts to ensure high quality of the application under test as part of the Agile/Scrum process.
Confidential
Automation/ Performance Tester
Environment: Java, Selenium WebDriver, TestNG, Maven, Cucumber, Jenkins, JMeter, Dynatrace.
Roles and Responsibilities:
- Involved in analyzing Business Requirement Documents and Technical Specification document and developed test plan and test cases for testing the application.
- Provided support in the performance testing using JMeter task includes developing test plan, test script and reports.
- Good experience in using APM tool Dynatrace in monitoring business transaction across all tiers (web/app/DB) of the applications.
- Develop scenario-based testing for the JMeter scripts.
- Create, schedule and run the scenarios using JMeter and generate necessary graphs
- Extensively worked on JMeter to create Thread Groups and test Web Application for various loads on key business scenarios
- Created and executed JMeter scripts for performance testing of portal
- Provided support in testing Web Application Performance Testing.
- Provided support functional testing of the Web Application.
- Performed functional testing to identify various critical points in the application and automated it by using Selenium Web Drivers.
- DevelopedAutomationscripts for new enhancements using Selenium Web Driver and TestNG.
- Designed, executed and maintainedautomation Test Scripts in Selenium WebDriver using Java, TestNG.
- Performed Regression and Integration Testing using TestNG framework and executed assertions.
- Involved in Web Application GUIautomationcreating regression suites using Selenium Web Driver, TestNG, and Eclipse.
- Involved in preparing a report of allautomationdifficulties and test results for further application using Maven.
- Involved in the usage of BDD framework to develop Cucumber Step Definitions, Scenarios and Features using acceptance criteria.
- Configured Continuous Integration environment, using Jenkinsto kickoff daily builds andautomationsuitesJenkins, Maven and GitHub.
- Perform different types of testing Smoke, Functional, GUI, Integration, System, Regression, User Acceptance and Production support.
- Used Firebug and Firepath to identify and locate elements as needed, along with creating customXpath using xml functions.
- Involved in validating Sanity, functional, Integration and Regression test suites using Selenium and the request and response of the Webservices (SOA) through SOAP UI.
- Performed Web Services Testing and XML validation by creating test case suite using SOAP UI.
- Uploaded test cases executed test cases and logged defects in ALM.
- Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
- Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
- ParticipatedQAweekly meetings and various other meetings and discussed Enhancement and Modification Request issues and defects in the application.
Confidential
ETL Tester
Environment: Windows XP, Windows 2000/XP, OBIEE, Oracle SQL
RESPONSIBILITIES:
- Involved in creating source target mappings based on the Technical Design requirements
- Closely worked with Business Analyst in addressing requirement gaps, resolved contradictory statements in early stage of STLC
- Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
- Involved in writing Complex queries using SQL for Data Integrity checks.
- Participation in Requirement / Use Case analysis, Risk analysis and configuration management.
- Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
- Created Test Cases using the SDLC procedures and reviewed them with the Test Manager.
- Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
- Retested the modifications, once bugs are fixed after reinstalling the application.
- Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
- Developed presentation and testing implementation learning to other testing resources for cross functional training.
- Extensively tested the OBIEE report by running the SQL queries on the database by reviewing the report requirement documentation.
- Validating the Data files from source to make sure correct data has been captured to be loaded to target tables
- Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
- Validating the Archive process to purge the data that meet the defined business rules.
- Actively participating in project specification reviews, writing and maintaining QA technical documentation.
- Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.
Confidential
Manual Tester
Environment: Manual Testing, Quality Center, HTML, Java, Windows, MS Excel, MS power point.
Responsibilities:
- Review Business Requirement Documents, Test areas and the Functional Specifications of the application.
- Develop Test Plan and Test Strategy to test the application according to the Requirements, Test areas and Functional Specification of the application.
- Developed Test Scripts using Functional Requirement Documents. Test scenarios are created for Positive, Negative, Boundary cases, etc. Performed all types of testing on workflows and server software.
- Understanding and Analyzing complex business and functional requirements.
- Involved in UAT testing in UAT environment, Prepared UAT test cases and testing estimates.
- Preparing Functional Test Cases/Scripts in ALM under Test Plan, And Review Test Requirements, Creating Test Plans and Test Strategy documents.
- Preparing and Executing SIT test Cases/Scripts in ALM, Creating Functional/Regression Test Cases in ALM.
- Perform detailed testing and write/execute test plans for black box, white box and regression testing
- Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues, Defect Management by Logging and Tracking bugs during execution in Test lab.
- Ensure that all the test cases are updated in the ALM along with Master test plan Generating Matrices Reports and Charts for Defect Analysis to analyze statistical nature of the defects.
- Performed system testing, server rehost testing, regression testing, and black box testing.
- Directly Interact with Project Teams, Developers, Business Analysts and Clients for Test requirements, clarifications and Testing.
- Provide daily status report, defect matrices, daily updates to lead Provide daily status report on task assigned to the Project Manager/Client.
- Assisted developers with reproducing defects and providing additional information as needed.