Senior Software Test Analyst
Over 7 years of experience in testing software applications developed on various technologies. As a tester I have involved in test design, test development and implementation of test procedures for Web, Client/Server and Legacy projects. Rich experience in different domains such as Financial, Banking and Insurance. I am having good knowledge in various software testing tools makes it easy for me to work in different testing technologies/Applications. I am interested to work in both manual and automation testing.
Expertise in complete Software development life cycle (SDLC) strategies for verification/ validation.
Experience with various types of testing like GUI testing, Web testing, smoke testing, Security Testing, Load/stress testing, Regression testing, Re-Testing, User Acceptance Testing, Functional Testing, System Testing, Integration Testing, End-to-End Testing.
Experience with Automated Testing/Performance tools such as UFT and Load Runner.
Experience in testing Web Application with SOAP UI, Postman for testing Web Service/Rest API.
Experience in preparing and executing Test Plans, Test Scripts, Test Reports and Documentation for both Manual and Automation testing.
Used ALM/Quality Center, Jira and Rational Clear Quest for tracking defects.
Tested the application Structures and Functionality’s for White Box, Black Box & Alpha testing.
Interacted with developers to assure quality of testing.
Strong experience in preparation of Defect Reports and Tracking of Defects.
Strong in back end testing using SQL queries & database tools.
Testing Web site for any broken Links and tested HTML for Java compatibility.
Extensive experience in writing and executing the SQL/PLSQL.
Highly motivated resourceful team player that takes a positive approach to problem resolution.
Ability to effectively and professionally interact with people at all levels of management.
Master of Science – Graduated
Guru Nanak Dev University (G.N.D.U), Amritsar, India
Bachelors Degree in Education– Graduated
University of Jammu, Jammu, India
(Equivalent to a Bachelor’s degree from Ontario University, as determined by World Education Services in Toronto, ON)
Bachelors of Sciences– Graduated
Punjab University, Chandigarh, India
(Equivalent to Bachelor’s degree from Ontario University, as determined by World Education Service in Toronto, ON)
Automation Tools/Defect Tracking Tools: HP ALM, UFT, Rational Robot, Rational Test Manager, Rational Clear Quest, Jira,Postman,SOAP UI, Parasoft SOA
Performance / Load Testing Tools : Load Runner, Performance Center/Controller 7.8,81,9.0,9.1
Test Techniques and Methodologies: Database Testing, Manual Testing and Automated Testing, Black Box Testing, Gray Box Testing and White Box Testing,Agile
Databases/Data Access Technologies: Oracle, Teradata, Sybase, MS SQL Server, MS Access, IBM DB2 UDB7.0, Informix.
Protocols: TCP/IP, HTTP, SOAP, HTTPS/RTE.
Office Communication: MS Outlook/Project/Word/Excel/Power Point, VISIO, Lotus Notes.
Scotia Bank, Toronto, ON
Senior QA Test Analyst
Oct 2016 – Current
This is web based application which provides customers of Scotia Bank, various financial services like Foreign Exchange (Currency), Client Net (Scan for Contacts info using Contact Manager FX online Buying, Selling of Foreign Exchange Holiday Processing for cyber pay for next deal,Spot and Same deal and deal hub transaction deals foreign exchange . The application enables the customers to check their portfolios online get breaking financial news, real time access to accounts, get electronic copies of statements, trade the stocks along with providing real time quote information etc
Analyzed the requirements from user stories.
Extensively involved in writing Test Cases.
Worked closely with development staff in all the development phases.
Prepared Test Scenario, Test Cases for the Application and Executed them.
Extensive experience in writing and executing automated testing scripts using UFT.
Developed and executed regression and performance test scripts with a combination of tools to include UFT and ALM.
Conducted Data Driven testing using parameterization in Quick test Pro to test the application with different sets of data.
Involved in writing Test plans, Test cases and RTM and also involved in the process of analyzing the expected and actual results
Develop Test Case using WSDL for Web Service Request and Response, Methods/Operations and end point of Web Service to be tested.
Worked on accessing the properties from different levels of the project using SOAP UI/ Web Services.
Experience to send the values from response of one Test Case to the request of other Test Case in SOAP UI/ Postman.
Worked on HTTP,SOAP, XPATH, CONTAIN Assertions.
Implemented web services testing on XML Schema, WSDL using SOAP UI and validated them in SOAP and in backend database testing.
Validate the JSON/ XML Response, Methods/ Operations and End Point Of Web Service.
Experience of testing Rest API using Postman/SOAP UI and verify the response with JSON Path.
Investigate, identify, analyze, define and document the business processes.
Conduct workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
Generated the test scripts for Functional, Data driven and Regression testing using automated testing tool UFT.
Used ALM to prepare Test cases, procedures and Requirements Traceability Matrix.
Created Test Analysis Report and graphs using ALM.
Executed the tests to verify the web GUI using UFT.
Actively involved in meeting, Participated in daily stand up meetings.
Involved in Volume testing to verify the system load process using Load runner.
Also executed various SQL Queries to perform the backend testing.
Environment: J2EE,ASP, HTML, XML, UNIX,VB, Oracle, SQL, QTP, UFT, Load Runner, Agile, HP ALM, SOAP UI,
Sr. Quality Assurance Test Engineer
Nov 2014 – Sept 2016
As a marketplace for global risk management, TMX exchange brings together buyers and sellers of derivatives products,which trade on trading floors, on GLOBEX electronic trading platform and through privately negotiated transactions .Futures and options provide a way to protect against and profit from price changes in financial instruments and physical commodities. TMX Trader application is a Front-End application where user can access and trade from home. TMX Trader has different versions with more added functionalities. TMX Trader is an online application where users can electronically enter orders, trades, send Cross Requests and Ex-pits for both Options and Futures.
Participated in Business analysis and requirements gathering.
Prepared test plans/test schedules with inputs from Project manager and development team.
Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
Defined data requirements and elements used in XML transactions.
Reviewed flow diagrams and XSDs to understand schema defined elements, child elements, attributes and data type.
Reviewed and approved database modifications.
Worked to verify and validate WSDL and SOAP/REST based Web Services Request and Response for Test Case.
Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
Executed several shell scripts of UNIX Korn shell for file transfers, error log creations and log file cleanup process.
Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
Worked on complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
Created Test Cases for ETL to compare Source and Target Database system.
Involved in writing load scripts using JMETER, performance testing tool.
Validate the service response with assertions.
Trigger the SOAP request through Groovy Script.
Performed Database testing using SOAP UI.
Worked with all Teradata load utilities
Involved in validating the aggregate table based on the rollup process documented in the data mapping.
Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2005 and Oracle 10g.
Prepared test plans/test schedules with inputs from Project manager and development team
Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
Environment: Ab Initio, Data Profiler, SQL, PL/SQL, Quick Test Pro 8.0, Business Objects XIR2, UNIX, Shell Scripts, HP Quality Center, Teradata V2R6, SQL Assistant 6.0, MLOAD, FLOAD, TPUMP, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, CICS, Sybase, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SOAP UI, SQL, TSO/ISPF
ING Direct, Toronto, ON
Oct 2013 – Oct 2014
ING BIS offers a full range of financial services to commercial, business customers, and consumers. Its portal provides cash management, investment services with single sign on to secure web site .With these online solutions made the consumer to Manage their funds more effectively by accessing information about their investment and borrowing transactions online like viewing accounts current-day activity or history of investments and borrowings transactions. It also allows to conduct online trading for certain fixed-income securities, including money market mutual funds and repurchase agreements.
Created and Developed Test Plans,Test Cases based on Business Requirement Documents, Use cases, Approach documents and reviewed in the Team meetings
Documented test cases based on the Business Requirement in the ALM.
Imported and exported Test Cases to ALM
Tied all the test cases to the Requirements for the Traceability matrix
Executed test cases in ALM and documented the defects in the Reporting tools
Performed Back End testing by writing SQL queries to check data integrity.
Performed Database validations, data extraction process validations by executing SQL Queries, Data Queries on databases.
Involved in executing and modifying the UNIX Shell scripts in VI-Editor for Data Extraction and verification.
Prepared Defect Reports,organized meetings with various groups
Performed a wide range of quality tests to ensure that software meets specified standards and end-user requirements.
Performed all phases of testing which includes Smoke Testing,Integration Testing, Functionality testing, Regression Testing, Adhoc Testing, negative testing, system testing, user acceptance testing (UAT) of the Application, its interfaces and Client-Server Utilities.
Worked on Creating API documentation
Experience on export and import collections
Organized Request using Collection in Web Services
Worked on Soap and Rest Request using Postman in Web Services.
Participated in various production validations
Environment :ALM, Oracle, Java, Clear Quest, UNIX, XML,Postman
Oct 2011 - Sep2013
The Application PayeXpert is an internet front end that allows the user to make changes to employee and company records that affect payroll. Earnings information, tax information, personal information, deduction information, pay cycle information, and job allocation information – all important for paying employees and for employers records. PayeXpert creates the payfile - and also allows the user to create reports from the database.
Preparing of Test cases, Test data beds and analyzing issues / defects after testing.
Interacted with Business Analysts to gather the requirements
Involved in designing Test Cases, Test Data beds and analyzing issues/ defects after testing.
Defined and maintained detail Requirement, Created Test Plan, Test cases and Traced with Requirements and report defects in Jira.
Involved in Test methodology and test life cycle(Initiate the project, Design the system, Define the system, Build the system, Test the system)
Wrote numerous SQL queries to do database testing.
Integration Testing and UAT were done for the entire System after unit testing by executing the complete flow of the application system.
Created test suite using WSDL file.
Tested the application by passing the data of Response to Request of other test.
Worked on data driving from Excel.
Prepared Documentation for the test cases, test results and test procedures
Coordinated with Team Members to evaluate the performance of the application.
Involved in Internal Quality Assurance (IQA).
Environment: SQL & PL/SQL, SQL Loader, Parasoft SOA, Oracle8i, UNIX and Window