Gagan Singh
Mobile: 902-***-**** Email: **************@*****.*** 148 Rutledge Street, Bedford, Nova Scotia, B4A 1X6
Summary
Over five years of experience in performing Software Quality Assurance & Testing.
Experience in performing testing in both Agile and Waterfall Model
Involved in Creating Test plans, Test cases and test estimations.
Experience in Manual and Automated testing for Client/Server, iOS, android and Web-Services Based application.
Preparation of traceability matrix.
Experience in designing and executing test cases based on Business and Technical requirement.
Extensive experience in Functionality testing, Integration testing, Regression testing, Smoke testing, acceptance testing, usability testing and System testing using tool Soap UI performed web services (WSDL).
Proven effectiveness in working cross teams/discipline (interact with Developers) and participated in SCRUM meetings.
Written test cases for Unit level, Functional and Integration testing.
Defect tracking and reporting using Jira and Rational ClearQuest and providing accurate updates to scrum team.
Strong skills in backend testing, SQL Queries on Oracle, SQL Server RDBMS.
Tested Salesforce, SAP and Siebel CRM applications according configuration requirements.
Proficient with Mercury Interactive automation tools such as Selenium, HP Quick Test Pro, LoadRunner and designing test cases using HP Quality Center to manage the entire testing process.
Conversant with Testing Methodologies and Software Development Life Cycles.
Good Team player with attention to detail and can perform Multi-tasking.
Education: Bachelor Of Technology (Computer Science & Engineering) - PT University, India
Client: ATB Financial, Edmonton, AB (Sep 2014 - May 2016)
Online Investment Advisor & Mobile Banking Applications (Role: QA Analyst)
Online Investment Advisor is an application for Business Administrators, managing Mutual funds information for ATB Financials. Its main purpose is to provide an easy and user-friendly solution to view, add and change mutual fund information and also to remove a fund. All these business operations have a complex set of rules associated with them. All the operation has to go for final approval and will remain in pending state before approved and get persisted. So the application data maintains three different levels of state changes, which are, pending or waiting for approval and approved or cancelled. The front end allows the user to approve any pending transaction.
Environment: HP Tools (Quality Center (QC), ALM, Quick Test Professional (QTP), LoadRunner), SAP CRM, SAP ECC 6.0, SAP PE, SAP BW, Oracle, Selenium, Oracle 11, SQL, iOS, Salesforce, Android, IBM FileNet, WebSphere AS 5, SOAP UI, UNIX, Web Services, HTTP, WSDL, Mainframes, VSAM, Db2, Jira and Rumba
Worked as a member of a QA team, responsible for system testing before deployment
Participated in the review of the requirement, scrum meetings and design specifications and Involved in all testing activities, including preparation of test scenarios and test cases, script execution, regression testing, and defect verification
Involved in creation of Test strategy based on Business and Functional requirements
Created test scenarios using a standard test scenario template and provided test scenarios to the BA for review and sign off
Updated the test data requirements using the Test scenario template and provided the test data requirements to the DBA
Created and executed test cases using Quality Center and Imported all the Requirements from MS Word into the Requirements tab of Quality Center using Word add-in and Imported test cases from Excel into Quality Center using MS Excel add-in
Configured the project settings for project, created user group and user ids for the team members using site administrator.
Performed accessibility testing on the mobile devices to make sure it’s user friendly to use for all customers.
Created all the test cases in the Test plan module and mapped the test cases to the requirements to ensure the test coverage
Mapped all the test cases into Test sets in the Test lab based on the types of test and priorities.
Salesforce CRM data is migrated to SAP CRM as park of SAP Bank Analyzer implementation
Executed all the test cases from the test lab for sanity, functionality, system integration, conversion (ETL), migration, content, security, backend, data mapping, data validation, smoke, end to end and user acceptance testing.
Tested both Native and Mobile web application using both emulators and simulators.
Very familiar with both iOS and Android operating systems.
Created Batch scripts and performed batch testing and Generated test scripts for function and regression testing using QTP.
Created a Performance test plan and used generated scripts using VU Gen and executed them using LR Controller
Enhanced test scripts using user defined functions, parameterization and logical statements.
Identified and reported all the defects to the development team with proper priorities and severities.
Extracted test planning, test execution and defect status reports from Quality Center.
Provided timely communication to project team and management and Used Quality Center for defect reporting and tracking.
Developed test cases in SOAP UI to test the Consent web services (WSDL)
Involved in testing the application in production after deployment to make sure application is working properly in the production environment.
Client: Sobeys Canada, Dartmouth, NS (May 2012 - Sep 2014)
SAP IS Retail POS System & Sobeys Mobile App (Role: QA Tester)
SAP Point of Sale application (POS) was developed for Sobeys Retail Stores. It was tested to generate statements of regular shipping to different retail sales outlets of Canada. Data was selected from different modules that handle the sales of various goods in each outlet for a specific time span depending on the sales record and performance. The application generates comparative sales statements in required regions depending on the pricing policy and cost effectiveness in each region. The testing of the application involved manual testing and automated testing using Mercury Interactive tools on large-scale database and platforms such as windows and Sun-Solaris.
Sobeys’ new iPhone and Android apps are designed to help customers discover better food, shop smarter and save time and money. The new Sobeys mobile app will help customers discover new meal ideas, find out what's new and in-season at Sobeys this week, and will make your weekly shopping planning more simple and enjoyable through its smart shopping list features and anytime access to a host of great savings in your local Sobeys store this week.
Environment: IBM Tools (Rational Robot, Rational Test Manager, Rational ClearQuest), SAP IS POS Retail, MQ Series, UNIX, SQL, HTTPs, Mainframes, Web Services, Salesforce, DB2, Soap UI, Windows, C++, HP QTP, HP QC and Oracle 8i.
Tested applications developed on SAP IS Retail POS by gathering Business Requirement Documents, Functional/System Requirement Documents, Use Cases, and Design Specifications in each phase of the application, which involves series of meetings with developers, Systems Analysts and Business Analysts to verify the testability of the requirements
Involved in development of Test plan and presented for the management for review and signoff.
Created detailed Test cases both for Manual testing according to the business requirements/Use cases in Quality Center
Performed different kinds of manual testing including Functional, System, Boundary, Integration and End-to-End tests during different phases of testing
Experience working on Page Layouts, Custom fields & objects, Validation rules, Workflow & approval processes
Extensively worked with various salesforce.com objects such as Accounts, Contacts, Companies, Reports and Dashboards
Performed mobile testing using Salesforce1 app
Performed Data Mapping tests, extensively by using SQL queries in Oracle 8
Maintained, Monitored, and documented the behavior of the application in different phases of Testing
Used Quality Center for Test Planning, Execution and Defect Tracking
Performed feature, navigation, installation, content, updates, cross platform, performance and usability testing on Sobeys mobile applications
Used Rational Clear Case for configuration management of all the testing artifacts
Performed manual testing for on-line and batch scripts and Created complex SQL statements for Backend Database testing
I have done load & stress testing using Rational Test manager and published the reports to the management
Developed scripts using Rational Robot for automation testing and identified defects, opened ticket using Rational ClearQuest.
Client: Blackberry Communications (Jan 2011 - April 2012)
Blackberry Billing System (Role: QA Tester)
I was responsible for testing GUI's of various Billing Data of Blackberry, which includes analyzing system spec's and developed test procedures, analyzing existing code, Data, Business rules and templates, on-line interaction with users, making necessary enhancement to the code, testing the changes.
Environment: Agile, HP QC 9.0, HP QTP 9.0, Loadrunner 9.0, SOAP UI, Salesforce, Java, XML, Web Services, HTTP, WSDL, Oracle, BB Mobile Apps, Groovy, UNIX
Identified the test scenarios and test cases based on the requirements, use cases and wire frames
Imported all the requirements into Quality Center from word document
Created detailed test cases in Quality Center test plan tab and mapped the test cases to requirements to ensure the traceability
Prepared the test cases for test execution by mapping the provided test data to the test cases
Grouped all my test cases in the test lab of Quality Center and executed the test cases according to the type of testing
Responsible for performing Cross browser, Content, Security, Black box, Field level validation, Functional, Integration, Interoperability, End to End and User acceptance testing
Performed backend database testing using SQL with the help of Toad and validated data at Backend server
Created a Performance test plan and used generated scripts using VU Gen and executed them using LR Controller
Identified and reported defects to the development team with proper priorities
Participated in the defect triage meeting and prepared defect triage reports to the development team
Performed retesting and regression testing on the application build based on the release notes sent by the development team
Testing Tools:
Quick Test Pro (QTP) 10.x, UFT, LoadRunner 10.x, HP ALM, HP Quality Center 10.x, Selenium, Jira, Rally Dev, PVCS
Scripting:
VBScript, JavaScript, UNIX Shell scripting
Languages:
Java, C, C++, .NET, SQL, Visual Basic 6, Visual C++, ASP, HTML, XML
RDBMS:
Oracle 8.x/9.x/11.x, MS Access, Mainframes, DB2, VSAM, SQL Server
OS:
Windows, LINUX, Mainframes and UNIX
Other:
Informatica, Web services, Salesforce, Ab-initio, SOAP UI, WSDL, HTTP, Siebel CRM, Microsoft Dynamics, iOS, Android, SAP IS Retail, SAP CRM, MS Office, Excel, Word, PowerPoint.