Sanket Vaviya Email and Phone Number

1. Twinfield - Twinfield online accounting software built on Angular & React manages all accounting functions, from invoicing to management accounting for the smallest startup to the largest international group with ease. Worked with stakeholders to gather and analyze test requirements, ensuring test coverage and aligning test efforts with project objectives. Created Test Plans and Test Strategy documents for manual testing. Developed and maintained automated test scripts using Protractor/JavaScript and used Github/Tortoise Git for version controlling. Execution of Smoke/Regression/Sanity suites suite after every build and publish the detailed reports with the bugs detected and results generated. Execution of Release Cut Testing every month after the code is pushed to RC from master environment. Collaborated with development teams to identify and troubleshoot & mitigatesoftware defects, logging bugs and working towards their resolution using agile project management tool JIRA. Investigation of Nightly execution failure and Release creation of builds using Azure Devops pipelines. Hands on knowledge of SQL queries and Azure Blobstorage for verification in DBusing MS SQL Server Management Studio 18 and Azure Portal. Testing APIs using JavaScript, Postman and Swagger. Performed thorough code reviews in current project, ensuring adherence to best practices and identifying potential issues. Mentored junior team members, providing guidance and support in test automation best practices and knowledge transfer for the application. Active participation in migration discussion of automation cases from JavaScript/Protractor to TypeScript/Playwright

#1. Online Loan Banking Application Time: 2+ Year (Feb 2019 to Present)Client : Royal Bank of CanadaTeam Size : 5Testing : Functional, Regression, UI, Cross BrowserRole : Consultant (Test Engineer)1. Online Loan Banking Application - OLBA is an Online Loan creation application. OLBA helps initiate requests for various type of loan for the customer that is fully compliant with the Bank’s applicable Regulation & Risk Management policies. Involved in Requirement Gathering & Requirement Analysis and help in evaluating mitigation process for scenarios that cannot be performed. Development of Web Automation test scripts & suites, automated execution of sanity/ acceptance/functional/regression suites, nightly batch runs, analysing failures and fixing test issues using Selenium/Java with TestNG. Running Full Automation suite for every Release and analyse the root cause of failing scripts. Conducted regression testing to validate fixes and ensure the stability of software releases.

#2. NGO – Next Generation Optimization9 months (May 2018 to Jan 2019)Client : Royal Bank of CanadaTeam Size : 3Testing : Functional, RegressionRole : Senior Test Engineer Project Description-NGO (Next Generation Optimization) is RPA and RDA based project built on Openspan tool for which testing was performed based on Agile methodology. Some processes are Advice Center, Bill Payment Investigation, Account Close, Fraud Chargeback, etc.Roles and Responsibilities across Projects: Requirement gathering & Analysis, Test Case Design & Test Execution. Reporting, Tracking Bug using ALM and Root Cause Analysis of the Defects. Walk-through and status reporting with clients (Scrum Master and Developer) over stand-up calls and emails. Deployment Approval and providing Sign off. Performed testing for multiple processes with efficiency in testing as well as communication. Regression before demo to stakeholders, involved actively in demo to show the application development completed. Supported Win 10 migration testing for all the processes with ease. Providing task Estimation using JIRA and distributing the workload among the team. Played a key role within the Canada, India regional team, supported both On-shore and off-shore within the region. Identified potential risks such as late delivery and feasibility of innovative projects and developed appropriate risk response. Assist in the documentation of traceability from requirements to verification records and from requirements to design entitiesAutomation Efforts – NGO is already an RPA based automation project but after working in this project I was able to identify the manual efforts and was able to initiate the Selenium scripting for Request creation for the BOT’s and Validationfor NGO.

#3. AFA – Automotive Finance Adjudicator Tiime: 9 months (Aug 2017 to Apr 2018)Client : Royal Bank of CanadaTeam Size : 2Testing : Functional, RegressionRole : Test EngineerProject Description- AFA (Automotive Finance Adjudicator) main objective is to evaluate the vehicle Loan value and Sanction’s operations as well as the compliances related functions at RBC’s branches/subsidiaries/offices.Roles and Responsibilities across Projects: Identification of Automation Scenarios from the set of Test cases/User stories identified in Test cycle Development of Web Automation Test cases for the identified Scenarios with BDD approach using Cucumber. Running Smoke regression suite after every build and publish the detailed reports with the bugs detected Defect reporting and Analyzing Result. Communication with clients on daily basis on stand-up calls & mails. Deployment Approval and providing Sign off Keeping track of all the Requirements, using which Test Scenarios were created resulting in identification and creation of efficient Test Cases and their Execution on an Agile based Methodology and reporting and tracking the Defects and for all these tasks HP ALM tool was used. Involved in Backlog Refinement, Estimation and Sprint planning meeting. Driving of Retrospective meeting after end of each Sprint.

Project Description-This project was like any other Maintenance project where multiple enhancement on various applications were to be tested upon the requests.Roles and Responsibilities across Projects: Involved in Requirement Gathering & Requirement Analysis.  Regression Testing was performed. Applications included OLBB, OLMS, CMS, BCRMS, ILS Origenate, Casper and TSO Reporting and tracking the Bug using HP ALM

Project Description-This was L1 classroom training with Capgemini trainers where we were trained under VnV testing.Roles and Responsibilities across Projects: Underwent a 3 months intensive training in My SQL & Informatica Training was based on ETL (Extract - Transform - Load) Testing Learned about STLC, gained experience using tool Informatica