Senior QA Engineer - SDLC - Automation & API Testing expert

VENKAT RAO

Toronto, ON 647-***-**** ********@*****.***

PROFESSIONAL SUMMARY

Have 15 years of experience in Information Technology in the field of Software Quality Assurance of Web Applications, Windows-based, Client-Server, and Mainframe Applications

Experienced in all phases of SDLC, including Agile Scrum, Waterfall, Iterative, V-Model, TDD, and BDD methodologies.

Experienced in manual, automation, and API testing tools for Smoke, Shakedown, Functional, Regression, performance testing, Stress/Load testing, SIT, UAT, BAT, and PAT.

Successfully hosted QA sprint planning, QA backlog grooming, team, and project retrospectives.

Successfully designed test plans, test cases, test data, test summary reports, and other QA artifacts.

Experienced in identifying testing risks and mitigation during planning and steering committee meetings with stakeholders and/or business for estimations and resource planning.

Experienced in triaging issues to identify root cause in Front end and back end developed in different platforms.

Successfully presented developed applications to the project teams, support users, and business stakeholders to get fast feedback on the application.

Experienced in Database Testing using SQL queries on RDBMS databases like SQL Server, DB2, and Oracle

Strong experience performing accessibility (AODA) testing using tools such as WAVE and AXE.

Testing Tools

Automation & Functional Testing: Selenium, Playwright, QTP, Cucumber, TestNG

API Testing: Postman, SOAP UI, Rest Assured, JMeter

Defect Management & Agile Tools: JIRA, Zephyr, HP ALM, Octane, TestRail, Azure DevOps

Database: Oracle, SQL Server, DB2, PgAdmin, JDBC

Accessibility Testing: WAVE, AXE

Big Data Tools: HDFS, Hive, Pig, Flume, Oozie, Sqoop, Zookeeper

EDUCATION

Post Graduate Diploma in Computer Application (PG DCA) – Madurai Kamaraj University, India

Master of Computer Applications (MCA)-Madurai Kamaraj University India.

Diploma in Software Testing Certification-Mind Q systems, Hyderabad India

WORK EXPERIENCE

Client: City of Toronto - Jan 2025 – present.

Project: FSTP

Role: Sr Systems Integrator / Sr Quality Engineer

Highlights:

Strong Experience in creating, reviewing, and executing test strategy, test plans, test cases and Test Scripts.

Collaborate with product owner, business team and developers to understand user stories and acceptance criteria.

Design, develop and maintain automated test scripts and developed Framework as part of Agile method.

Performed various stages of testing like GUI, Integration, Functional,UAT, Regression, Load, performance testing.

Execute automated test suites, analyze test results and log defects.

Integrate automated tests into CI/CD pipelines and run the test scripts from GitLab.

Performed API testing using Postman to validate input and Output data.

Validated the Input and Output data from different Auxiliary Systems and SAP S/4 Hana Cloud.

Strong Experience in Selenium automation and Developed scripts for various scenarios.

Performed Load and Performance testing using JMeter.

Strong experience in backend testing by writing SQL queries to create and manage data using postgre Tool.

Strong experience in Accessibility (AODA) testing for Ontarians with Disability Act using different Tools.

Develop & update various reports and send the same to Stack holders.

Environment: Selenium,Test NG,Java,PgAdmin4.0,SQL,Azure DevOps, Jira,Confluence, GitLab, JMeter, postman, WAVE, AXE.

Client: Ontario Health - Dec’ 21 – Mar 2024.

Project: One Access Launcher (OAL)

Role: Sr Systems Testing/ Quality Engineer -Digital

The purpose of the project is to display all the patient records under one profile and the User is able to verify all the records.

Highlights:

Analyzed all the assigned User Stories Requirements from each Sprint.

Generated and executed Test Scenarios and Test cases for assigned stories in each sprint.

Strong experience in writing test scripts and test scenarios, testing web applications and reporting defects.

Performed various stages of testing like GUI,Unit,Integration,Functional, Regression,UAT,performance testing.

Strong Experience in Selenium -Dexter automation and Developed scripts for various scenarios.

Performed Cross Browser Testing on different Browsers Windows, Mac, iOS& Android Using Browser Stack

Performed Accessibility testing for Ontarians with Disability Act (AODA) testing using different Tools.

Performed API testing using SOAP UI & Postman to validate Request & Response data, Time and status Codes.

Good experience in validate HL7, FHIR messages and data structures as per WCAG 2.0

Using Jira as defect management tool to log the defects.

Responsible for updating various reports like daily /weekly status reports. Sprint status reports & defect reports.

Environment: Windows 10,Mac,Mobile, Browser Stack, Java, Selenium,Test NG, Maven, Azure DevOps, Jira, Confluence, Dexter, GitLab,WAVE,AXE, SOAP UI &postman.

Client: Genentech - Aug’21 – Nov 2021.

Project: Salad Fingers- PDV

Role: Sr Quality Engineer

Create various patient records in salesforce and verify the details using different tools.

Highlights:

Analyzed all the User Stories Requirements from each Sprint and involved in preparing Sprint plan for each Sprint

Generated and executed Test Scenarios and Test cases for assigned stories in each sprint.

Performed Integration, Functional, UAT & Regression testing on the application.

Created Various PACT, Synapse & marketing patient records in salesforce

Using Verato and SOQL (salesforce Object Query language) to link and merge the patients

Responsible for updating various reports.

Environment: Salesforce, Verato, SOQL Query, Windows 10,Java, ALM Octane, Jira,

Client: LCBO - July ‘19 – Feb 2021.

Project: E-commerce- Web & Mobile

Role: Sr Quality Engineer-Digital

The purpose of the project is to validate the process of various orders placed online from different WCS Browsers and Mobile iOS & android.

Highlights:

Analyzed all User Stories, Generated and executed Test Scenarios, test cases & Test scripts for assigned stories in each sprint.

Performed Smoke, Integration, System, Functional, P1 & P2 testing,UAT and Regression testing on the application.

Validated various orders placed as a Guest & Register user like STS, STH, and SDP in different Browsers.

Performed Cross Browser testing using Browser Stack on various web browsers & mobile(ios&android)

Performed Adobe Analytics testing by inspecting various elements, HTML, page source in different browsers.

Performed AODA Functional testing using different Tools and retest the defects by verifying the expected Code.

Interacting with other teams like Business team, Dev, Configuration,UAT team to resolve the testing-related issues.

Performed API testing using the postman tool to validate all web methods and response times.

Generate the Test Scripts using Selenium Web Driver as per User stories in each sprint.

Creating and Executing test scripts for regression testing of web applications using selenium.

Working with DevOps team for process improvement and to check the existing process status.

Performed backend testing by writing various SQL queries.

Generated various reports like daily /weekly status reports, Sprint status reports & defect reports.

Environment: Windows 7, Windows 10, Agile, Java, Python, Selenium, postman, Cucumber, Test NG, Maven, WAVE, NVDA,ALM Octane,Jira, Zephyr, Azure DevOps,Confluence, Linux, SQL, Oracle, HTML, XML.

Client: CST - Mar ‘18 – Jan 2019

Project: MDS RESP RPM release

Role: QA Consultant

The purpose of the project is to advocate, develop, deliver and support solutions that will enable every Canadian resident to have sufficient financial resources to pursue post-secondary education.RPM- R-Broker maintains several types of accounts, including RESPs, RRSPs, and TFSAs. At CST, R-Broker is specifically for supporting and maintaining client and back-office records as the source system for the MDS Program.

Highlights:

Analyzed requirements and Developed detailed Test Plan and Test Cases based on the requirements.

Performed various stages of testing to validate Various accounts using SSWS Web server, POAC, and R Broker.

Extensively interacted with Business Team, Developers, and with end-users to test according to their requirements.

Performed UAT testing on various browsers using Browser stack like IE 11, Chrome, Firefox, IOS and Android.

Performed API testing using SoapUI to validate all web methods.

Designed Test scripts Using selenium WebDriver and Generated Test Reports using Test NG.

Environment: Java, PHP, Selenium, JIRA, Soap UI, Oracle, Edge, IE 11, Google Chrome, Firefox, Unix, XML, SQL

Client: BMO Financial Group Toronto - Mar ‘17 – May 20 17

Project: Model Risk Inventory System (MRIS)

Role: Sr .QA Analyst

Model Inventory data remediation is one of the key workstreams of the enterprise model inventory remediation work. All active vetted/approved models with a business identified mandatory attributes extracted from Live link MRIS.

Highlights:

Analyzed Business Requirement, Functional Specification Documents to prepare Test cases based on Test Plans.

Involved in various testing types like Integration, Functional, UAT and Regression testing on the application.

Validated test data extracted from Risk Inventory systems

The validated model inventory contains all active vetted and approved models assigned MD/MO group

Environment: JAVA, Mainframe, Selenium WebDriver, Jira, Agile, Test NG, HP ALM, Linux, SQL, Oracle, MS Excel, HTML.

Client: TD Bank, Toronto - Mar ‘16 – Feb 2017

Project: Client Reporting

Role: Sr.QA Analyst

Client reporting Engine transforms the Organization's reporting capabilities to a single Reporting composition engine and that allows for Agile and flexible changes and improved design to generate new Statement.

Highlights:

Involved in preparing sprint plan, Test Cases and Test Data for each sprint of the project.

Performed various stages of testing for mutual Funds Securities,RSP,RRIF,RESP, and TFSA throughout the process

Performed Smoke, system Integration, Functional, Regression, UAT, and BAT Testing's

Validate the test process from DPP to Interim, Interim to XML, and XML to statements.

Interacted with all other teams like Dev team, Business team, offshore team to resolve the testing-related issues.

Supported UFT Automation team to understand the process and provided test data to run the script

Coordinating Offshore team on a day-to-day testing activity

Environment: Java, SCALA, UFT, HP ALM, JIRA, Confluence, Oracle, IE 11, Chrome, Unix, Microsoft Office 2013, .NET Server, SQL, XML, Microsoft Windows 7.

Client: Royal Bank of Canada, Toronto- Dec ‘14 – Nov 2015

Project: HSBC (PIM)

Role: Sr.QA Analyst

RBC I&TS (Royal Bank of Canada, Investor & Treasury Services) supports HSBC (PIM) (Private Investment &management) to manage various accounts (like Personal, Joint, Trust, RRSP, TFSA, RRIF, LIRA, LIF, mutual funds & securities) with EPW (Enhanced Private Wealth) and Custody (GPLUS, TRUST & Millvus).

Highlights:

prepared detailed Sprint Test Plan and Test Cases for HSBC (PIM) based on Business and Functional Specifications

Performed system Integration, Functional, Regression, UAT, and BAT Testing's

Verified EPW and Custody total value, currency and account details matching or not.

Used Selenium WebDriver to create test scripts for Functional and Regression testing

Involved in extensive DATA validation using SQL queries and back-end testing

Environment: HP ALM11.5, Java, Mainframe, TSYS, Unix, JIRA, Confluence, Selenium, SQL, VB Script, Symcor, TOAD, Oracle, Cobol, Windows 7, Windows NT/XP, XML, MSOffice 2013, MS SharePoint

CIBC, Toronto

Senior QA Analyst / QA Analyst Jul 2009 – Jun 2014

Project-1: Multicurrency (Finance)- Jul ‘13 –Jun ‘14

Multicurrency has been integrated with ECIF (Enterprise Customer Information file) and complete end-to-end Integration testing has been done to verify the changes. ECIF API (Application Programming Interface) communicates with FTOL API via Web services/XML Files and the changes done in ECIF should be successfully reflected in Core application and FTOL (Fixed Term Online).

Highlights:

Created CIF in ECIF Application for Multicurrency and RIF, Worked as a QA Analyst in Production Support Team

Opened various Accounts in FTOL for different currencies such as Euro, Pound, and Dollar.

Changed various properties in ECIF and verified the XML Request and Response as sent by ECIF to FTOL.

Coordinated among many 3rd party vendors such as HP, TCS, and CGI.

Environment: Java, MS.Net, Mainframe,XML,Soap UI,SQL,ORACLE, HP ALM,Mainframe,Oracle 10g Windows 7,MS Office 2013

Project-2: Whole Sale Automotive Lending (WAL) (Finance) - Jan’13 to Jun ‘13

Wholesale Automotive Lending (WAL) Operations supports Vehicle financing between automotive Dealers and Manufacturers. Wholesale Indirect Lending (WIL) is replaced by WAL. The goal of the WAL financing system Replacement project initiative is to replace the Legacy mainframe system applications.

Highlights:

Verified front-end Total Debit and credit account values and GLS 15000 Report should match.

Verified online web Source file accounts and Values with various Reports like Report 28 & 29

Environment: Mainframe, MS.Net, ALM (HP QC), TOAD, JIRA, SQL, Oracle, XML, MS Excel 2013, MSWord 2013, MS Access 2013, Windows XP, MS SharePoint.

Project-3: Foreign Exchange Portal (Capital market)- Jan’12-Dec ‘12

New DCC (Daily cash currencies) screens added to the FX portal screens that will support the creation and publishing of DCC bulletins along with the functionality. The purpose of the project was to add new DCC screens to the FX portal and that will allow the user to reconcile Base 24 transactions, WSS bulk deals are created using Base 24 transactions and Master card records.

Highlights:

Verified the system calculated the Rates for each issuance currency, tier, and pair based on the parameters provided by the user

Verified system publish start and End parameters in the FX Portal and publish the bulletin until the close of business

Validated Wallstreet systems (WSS) and master Card Reconciliation Report and Exception Reports.

Validated Foreign Exchange (FX) Admin screen, Currency List screen, and Bulletin Rules screen.

Environment: Java, ALM (HP QC), JIRA, J2EE, Web Logic, Mainframe, UNIX, Oracle 10g DB2, SQL. Windows 7, MS Office 2013

Project-4: Equity/Market Linked GIC’s (ELGIC/MLGIC) (wealth management)- Jun ‘11 – Dec ‘11

Market-Linked GICs offer the best of both worlds the security of a GIC and the growth potential of the equity markets. The product is available for sales in Non-Redeemable Term 3 & 5 years On Non-Registered Personal GIC's, RRSP, and TFSA.

Highlights:

Verified DVP input data should match with the Product Report, Bundle central reports-balances and Percentage

Performed various kinds of tests like Integration, Functional, and Regression testing.

Extensively tested 3 and 5 years of non-redeemable personal GIC's, RRSP, and TFSA.

Tested source to target data mappings using SQL commands

Environment: Mainframe, ALM (MQC), TOAD, SQL, Oracle, XML, MS office 2013, Windows XP, Windows 7

Project-5: HST calculations (Finance)- Jan ‘11 – Jun ‘11

Harmonized Sales Tax (HST) validates various tax changes to different provinces like QC, BC, and PEI. The province of Prince Edward Island (PEI) has announced their intention to harmonize their Provincial Sales Tax (PST) with the Federal Goods and Services Tax (GST) into a single blended sales tax (HST) and the province of BC roll back from HST to GST and PST

Project-6: CORE Application (Wealth management/Investment)- Jan ‘10 – Dec ‘10

The core is a window-based application. CORE is the book of record for CIBC's RSP, RIF, and TFSA, it has a User Interface used by various users in the CIBC Core batch process that runs daily and gets files from CIBC’s internal COINS System. These files get uploaded into the CORE System on a daily, weekly, monthly, and yearly basis. Using FTOL to test the application in the Front end.

Project-7: SIEBEL CRM Data (Wealth management)- Jul’09 –Dec ‘09

The data migration for Siebel CRM is in process. All the data which is greater than 7 yrs are Purged and the data which is less than 7 years are archived. A Purge and archive batch is run every day to ensure that the batch is migrating the right data to purge and Archive. The main objective of this Data migration is to ensure that no data is lost and all the Service requests present in Siebel CRM are archive and purged with all the attachments.

Contact this candidate