Software QA Consultant with 10+ Experince for developing STLC

Raj Alam Singh Mand

********@*****.*** Ph: +1-514-***-****

- https://www.linkedin.com/in/rajalam- mand-389401151

PROFESSIONAL SUMMARY

10+ years of experience as Software Quality Assurance Analyst, Scrum Master and Test Architect for several Web and client/server applications in Banking, Finance, Telecom and Transport Domains, in both Manual and functional Automation testing.

Strong in analyzing Business Requirements and Functional Specifications, identifying Test Scenarios, developing test plan and test strategy documents and executing Test Cases.

Expertise in defect Logging and Reporting also investigating the root cause. (Troubleshooting for errors)

Exclusive experience Functional, Integration, Regression, Sanity, Cross Browser, System Integration Testing, Reports Testing Analyzing Build Health and Automation Feasibility analysis.

Hands on experience with, Oracle E-Business suite, Salesforce Testing and Business Intelligence - Power BI (for report validations).

Experienced in using Testing Tools JIRA, XRAY, HPALM, Spiratest for developing and maintaining test plans, test cases, test scripts, test results, defects and tracking.

Performed Test Planning and task assignment among team keeping in mind the team capacity.

Experienced in creating and maintaining Traceability Requirements Matrix and expertise in Test Case design, review, execution, defect management and tracking.

Experienced in developing and maintaining test scripts, analyzing bugs and interacting with development team members in fixing the defects.

Experienced in interacting with Business, Development and Operational teams.

Strong knowledge of Project Life cycle, Software Development Life Cycle (SDLC) methodologies like Agile/Scrum and Waterfall, Software Testing Life Cycle (STLC), Bug life Cycle.

Interacted with teams spread geographically coordinated with offshore team members regarding updates and progress

Self-starter with strong work ethics and skills in time management, multi-task, client relationship and ability to adapt and learn new things quickly, excellent MSOffice suites skills

Excellent Knowledge of Agile and waterfall methodologies also possess experience working as JIRA admin to create dashboards and defect managing.

TECHNICAL SKILLS

Testing Tools

HP ALM, JMeter, Postman, SOAPUI, XRAY, Selenium

Management Tools

SharePoint, MS-Project, Jira, AWS Cloud watch

RDBMS

Oracle, SQL Server

DB Tools

Toad, SQL Server Management Studio(SSMS).

Scripting Tools

Vs code, IntelliJ Idea, Ready Api (Api Automation)

Operating Systems

Linux, Windows

Programming Languages

JAVA, SQL Queries, Python, VB Script, Java Script, XML, HTML, Json,

Groovy, advanced JQL JIRA.

Web Browsers

Chrome, Edge, Mozilla Firefox, Safari.

CRM Tool

Salesforce

Central repository

Bitbucket, GitLab

Orchestration tools

Jenkins, AWS Code Build

Version Control

GIT, GIT hub, Tortoise GIT, SourceTree, GIT Lab

PROFESSIONAL EXPERIENCE

Client : VIA Rail Dec 2021 – August 2025

Role : Senior QA Consultant and Defect Manager

Testing Tools: JIRA, XRAY, SSMS, VScode (JavaScript), Postman, Power BI, Salesforce, Oracle EBS

Projects: EVEREST - New VIA Reservation System and Integration.

Description - This project was initiated in order to develop and implement new reservation system for VIA.

Responsibilities:

Hands on experience on Oracle E-Business suite for Financial validations

Contributed in the Successful Launch of New Reservation System for VIA Rail.

Working with XRAY and JIRA on daily basis to create test cases and ensure proper requirement coverage.

Creating/Modifying Scripts and running automation builds on AWS Code build.

Performing execution on Xray and maintaining Regression suite through automation.

Business Intelligence - Reports testing using Power BI and backend data validation using SSMS.

Creating/Modifying automation scripts on Vs code and maintaining automation repository on bitbucket

Validating script logs and troubleshooting using AWS CloudWatch

Generating Automation report using allure plugin.

Performed End -End testing for SIT phase.

Testing Salesforce Integration (Loyalty Points, Campaigns etc.)

Hand on experience using Smartbear Bit Bar for Browser and Mobile Testing.

Leading Defect Triage meetings and organizing WAR rooms for brainstorming on Testing Phases and troubleshooting defect source.

Created dashboards to filter and report critical defects.

Creating Test execution cycles and helped team in execution and mapping test cases to given Requirements (RTM).

API Testing using Postman and API Automation using Ready API.

Data Migration Testing in New System from Legacy System.

Testing with Oracle E-Business Suite (EBS) customizations, and integrations function correctly by validating workflows, data integrity for VIA revenue department.

Client : Canadian National Railways March 2018–Dec2021

Role : QA Analyst Lead and Test Architect

Testing Tools: HP ALM, SQL, Wireshark, shell, SOAPUI, Postman, PyCharm, Linux, Ranorex

Environment: JAVA, PHP, HTTPs, Python

Projects:

Release Automation and Supervisory Monitoring

Description - This project was initiated in order to develop in-house tool which can be used to

Monitor LOCO and Wayside Components such WIU, Radio etc.

Release Automation

Description - This project was initiated in order to develop in-house tool which can be used to Run deployments on the Locomotives over the air.

PTC (Positive Train Control)Plan A

Description: This project was initiated to set up the PTC rules for the CN tracks in United States. Project includes developing and validation of all PTC scenarios in accordance to line up with FRA requirements.

Responsibilities:

Working with ALM and JIRA on daily basis to create test cases and ensure proper requirement coverage.

Meeting with Project stakeholders (BA, SA and design team) to identify the business requirements.

Responsible for developing Test strategy, Test Plan and Test report based on the given requirements.

Mapping the test cases to the respective requirements and building RTM for Audit Purposes.

Assigning Tasks to testers to execute test cases, verified results and reported results in HP ALM and Jira.

Creating API testing scripts using JMeter and Postman.

Web Automation using Selenium with Python.

Responsible for performing Functional, Integration and Regression Testing

Successfully completed assigned tasks in a given estimated time by project manager.

Used Wireshark for validating EMP protocol messages sent to the server from LOCOs.

Validating subdivision files using google earth (validating data through satellite) and reporting any discrepancies.

Involved in gates forgetting the sign off from the stakeholders.

Client: MindGeek Montreal May 2017 – Feb 2018

Role: QA Analyst

Testing Tools: Jenkins, IntelliJ Idea, Spiratest

Environment: JAVA, PHP, https

Project: Website Network Maintenance

Description: This Network was developed to provide members of the site to access the videos of reality kings network, which consists of 56 sub sites and also to maintain the quality of the network in order to assure proper functionality of the web sites.

Responsibilities:

Involved in gathering and understanding Project Scope, Project Plan, Project Goals, Business and Functional Requirement documents required for documenting the Master Test Plan

Responsible for testing the websites with both manual and automation (using selenium scripts on IntelliJ Idea)

Developing test automation scripts.

Involved in creating quarterly master test plans based on project scope and requirements

Assigning Tasks to testers to execute test cases, verified results and reported results in Spiratest and Jira.

Responsible for performing Functional, Integration and Regression Testing

Successfully completed assigned tasks in a given estimated time by product director.

Used Jenkins for scheduling, running, and testing the site functionality through automation scripts.

Client: PACE Credit Union Feb 2016 – March2017

Role: Quality Assurance Analyst

Testing Tools: HP ALM, QTP

Environnent: JAVA, WebLogic, Oracle 11g, Linux

Project: Mortgage Serve

Description: This application was developed to provide complete account administration through innovation service delivery systems for mortgage loan origination process to perform operations for both new and existing customers.

Responsibilities:

Involved in gathering and understanding Project Scope, Project Plan, Project Goals, Business and Functional Requirement documents required for documenting the Master Test Plan

Responsible for testing the application with mostly Manual and partly Automated strategies

Involved in creating test plans based on functional specifications and user requirements.

Executed test cases, verified results and reported results in defect manager of Quality Center

Responsible for performing Functional, Integration and Regression Testing

Successfully detected defects, created defects using Quality Centre and reported to development team.

Used Quality Center for requirement management, planning, scheduling, running tests, issue management and project status analysis

Implemented Defect Management and worked with all the four modules of Quality Center

Analysis of application related issues, system errors logged by clients and Re-test the functionality on receiving the fixes from the Development Team in Quality Center

Participate in data gathering and identifying the gaps in the new developments

Inserted Bitmap and Text checkpoints where needed, to compare the current behavior of the application using QTP/HP ALM

Participated in data testing to review data using SQL queries and helped defining data redaction procedures

Integrated with developers and discussed technical problems, reported bugs and supported development team

Captured and maintained test results log, defect log, status reports and test data requirements template

Coordinated with development team members, other stakeholders and resolved critical issues, client escalations etc.

Generated details status report providing details of number of test cases executed, pending, failed, passed, defects identified.

Client : Central Bank of India, Mumbai, India May 2014 – Dec 2014

Role : Quality Assurance Analyst

Testing Tools: HP ALM, Quick Test Professional 10

Environment: JAVA, XML, Linux, Oracle 11g, Window 2008, .Net

Project: Portfolio Management System

Description: Central Bank used Siebel Financials to implement the Portfolio Management Online system for the Portfolio Management department to perform all the portfolio management needs like new account creation, assignment to portfolio managers, update customer portfolios and print portfolio statements.

Responsibilities:

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.

Requested the project manager to give a high-level overview of the project, timelines and project milestones

Reviewed the project plan and understood the testing deliverables and timelines

Involved in creating Master test plan by outlining testing assumptions, risks & mitigation, roles & responsibilities, build management process, change request flow and entry criteria

Scheduled MTP review session and invited all the stake holders for MTP review sessions

Updated the Master test plan after review and provided it for final sign-off to project manager

Created Test Scenarios and Test case folder in Quality Center.

Uploaded the requirements from word documents to requirements tab of Quality Center using Word add-in

Created Test scenarios, Test Suites, Test cases, Test procedures and mapped them to the requirements to ensure requirement coverage

Generated various types of custom Reports using SQL Queries (Joins) and tested them manually

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

Executed test cases from Quality center test lab to perform Black box, Regression, Functionality, Load, Performance, Integration, Smoke, End to end and Adhoc Testing

Reported defects in Quality Center with proper priorities and severities

Interface with development team members to ensure version control

Generated details status report providing details of number of test cases executed, pending, failed, passed, defects identified.

Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote functions for the parameters to read new data from the table upon each iteration – Performed Data-driven testing using QTP

Company: Reliance Communications, India April 2013 – April 2014

Role: QA Intern

Project: Billing Software (Online Tracking of Usage Details)

Online Tracking of Usage Details was an enhancement to the existing billing software. Eligible customers were able to monitor their usage online within the billing software.

Responsibilities:

Participated in review of business and functional requirements that served as the basis for test case design and testing the Online Tracking System.

Participated in weekly meetings and peer-to-peer review of test plan and test cases for the Online tracking System under tests.

Ensured responsibilities within my scope were carried out accurately and in accordance with the schedule and quality requirement.

Created the test cases in excel, imported and executed them in Quality Center and then Verified output of testing process for the Online Tracking application.

Executed the test cases to perform Smoke, Functional, System, System Integration and Regression testing for the Online Tracking application.

Logged the defects and clearly communicated the defects to the developers and updated the comments in HP Quality Center and took sign off from project lead.

Interface with development team members in resolving defects and ensuring quality of product is maintained

Produced supporting documentation such as screen prints and reports to assist defect resolution.

Trained peers and interns provided process and product knowledge of software to be tested.

Prepared High-Level overview of status report, test plan, training materials, SOP, in MS-PowerPoint for reference.

Education:

Bachelors Punjab Technical University, India. (2010-2014)

Post-Graduation in Project Management (Lambton College), Toronto (Dec.2014-Dec.2015).

Certifications:

Scrum Alliance – Certified Scrum Master. (Badge attached to LinkedIn Profile)

Contact this candidate