Aditya Shrivastava, Quality Assurance (QA) Developer in Toronto, ON, Canada
Aditya Shrivastava

Quality Assurance (QA) Developer in Toronto, ON, Canada

Member since May 12, 2020
Aditya is a quality expert with more than 12 years of experience in QA in automation and functional testing, primarily in automation. He has expert-level experience in diverse automation tools/technologies including Selenium WebDriver, TestComplete, UFT, Robot framework, BDD Cucumber, and RESTAssured. He's skilled in writing complex SQL queries and queries in Hadoop using Scala.
Aditya is now available for hire

Portfolio

Experience

  • Quality Assurance (QA) 12 years
  • SQL 11 years
  • Java 8 years
  • Selenium 8 years
  • HP UFT 4 years
  • Python 3 years
  • Robot Framework 3 years
  • REST Assured 2 years

Location

Toronto, ON, Canada

Availability

Part-time

Preferred Environment

Software QA, Unix, SQL, Jenkins, VBScript, Java, Selenium, Eclipse IDE, Test Automation, APIs

The most amazing...

...thing I've done was automate database testing with a large volume of data for a regulatory project, considerably reducing the cost and time of execution.

Employment

  • Test Automation Lead

    2019 - PRESENT
    Bank of Montreal (Contract)
    • Created a framework using Python with pandas and Robot Framework to automate test cases to compare and verify the database with a large volume of data for a banking client.
    • Mentored new members of the team to bring up overall project productivity.
    • Implemented logic to handle batch SQLs and compare database to database, database to JSON, and database to CSV file. Implemented Allure reporting in the Robot framework.
    • Increased automation in the project from 0% to 70%.
    • Reduced the execution time of the regression suite from two weeks to one day through automation.
    • Implemented Appium WindowDriver to automate desktop applications using open-source Appium.
    Technologies: WindowDriver, Robot Framework, Market Risk, Capital Markets, Greenplum, Oracle, PyCharm, Bitbucket, SQL, Pandas, Python
  • Senior Associate - Projects

    2016 - 2019
    Cognizant Technology Solutions
    • Automated IBM Message Queue using UFT. MQs were provided as input and expected output was verified. These tests were performed with different data.
    • Used JIRA to understand requirements and used HP AL to manage test cases and test executions. Managed defects in HP ALM.
    • Automated the end to end flow for the trade cycle for institutions.
    • Implemented Selenium and UFT as per the need for the project to be automated.
    • Wrote complex SQLs and mentored fellow teammates for the same.
    • Wrote basic shell scripts in UNIX to achieve automation for basic daily commands for projects.
    Technologies: HP Application Lifecycle Management (ALM), Jira, Confluence, Unix, HP UFT, Java, VBScript, Scala, Hadoop, SQL, FRTB, Capital Markets, Market Risk, REST APIs, Selenium, Robot Framework, Python
  • Team Lead

    2012 - 2016
    Persistent Systems Limited
    • Automated a telecom application based on Salesforce Sales Cloud. It was an application developed for customer care executives to reduce the wait time to average 30 mins from 2 hours.
    • Learned and implemented TestComplete with VBScript for automation. Brought up automation in the team from 0% to 95%, reducing execution time from an average of one week to one day.
    • Wrote shell scripts on Unix to automate Unix-related tasks for the project. Wrote script in Unix to search for specific words from logs to make verification easier.
    Technologies: Salesforce Sales Cloud, Telecommunications, Capital Markets, SQL, Unix, TestComplete, VBScript, Java
  • Software Engineer QA

    2011 - 2012
    Ebusinessware India Private Limited
    • Gathered requirements from businesses and clients in the insurance domain. Created functional test cases in HP Quality Center.
    • Navigated through CICS screens and other mainframe screens to perform functional tests. Facilitated mainframe batch execution.
    • Mentored team members on mainframe testing. Executed tests for system testing and regression testing.
    Technologies: Insurance, Unix, Web UI, SQL, Mainframe
  • Software Engineer - QA

    2010 - 2011
    A3Logics India Private Limited
    • Understood business requirements for the logistics domain and created functional test cases.
    • Automated functional test cases using HP QuickTest Professional, and created test cases in HP Quality Center.
    • Executed tests for system testing, SIT, and regression testing.
    • Mentored and trained more than 30 QAs from the company for ISTQB that resulted in more than 80% of QA cleared the ISTQB exam and the company‚Äôs certified QA percentage shot up exponentially.
    Technologies: HP QuickTest Professional (QTP), Logistics, SQL, HP UFT
  • Programmer Analyst

    2007 - 2010
    Cognizant Technology Solutions
    • Headed mainframe testing involving logging into TSOs and running JCLs to get result data from SDSF. Navigated through mainframe screens, and edited and executed JCLS.
    • Created test data for multiple test teams using SDSF. Blended in with the working environment and clients very quickly.
    • Interacted with clients on a daily basis discussing QA activities and status. Learned a lot about the domain and client interactions.
    Technologies: SQL, Unix, JCL, Mainframe

Experience

  • A Web-based Equipment Tracker and Management App
    http://www.interasset.com

    A web-based app for tracking and managing containers worldwide. It showed tracking, cleaning, location, and current status (ready, in cleaning, in transit, refrigerated, etc.) of containers using APIs.

  • Market Risk Project to Align the Institution as Per Regulatory Guidelines
    https://www.risk.net/definition/fundamental-review-of-the-trading-book-frtb

    It is a market risk application in the capital markets domain. I worked as a test automation lead responsible for automating applications within a domain. I implemented an automation framework using Python with pandas, NumPy, and Robot Framework. Created automated tests to compare a huge volume of data between databases, database vs. JSON files, database vs. CSV, and other combinations.

    Contributed to the implementation of Appium WindowDriver using Java to automate the desktop application, moving from UFT (paid) to Appium (open-source).

    Implemented Allure reporting in the Robot Framework.

    Learned and implemented Ansible for CI.

  • Sales App for A Telecom Services Provider

    Salesforce-based application for sales flow for a telecom services provider. Services included wired, wireless, and mobile services. The target was to reduce call center wait times to improve customer experience. Using test complete automation was performed, bringing test automation from 10% to 95% within defined time, reducing test execution time considerably.

  • RV Sharing Site

    An RV marketplace where RV lovers can host or rent RVs and earn money and friends. The website is built on Node.js technology. Being responsible for QA activities of the project, I was involved in all activities, including test plan and test case creation, test scriptwriting for both manual and automation testing. Wrote defects and tracked them. Automation is done using Cypress.

Skills

  • Languages

    Java, VBScript, SQL, Python, JavaScript
  • Frameworks

    Selenium, Robot Framework, Appium, Hadoop, Cypress.io
  • Tools

    PyCharm, Jenkins, REST Assured, Bitbucket, Confluence, HP Application Lifecycle Management (ALM), Salesforce Sales Cloud, HP QuickTest Professional (QTP), JCL, Windows Driver Kit (WDK), Jira
  • Paradigms

    Agile, Automated Testing
  • Other

    Quality Assurance (QA), APIs, Capital Markets, Market Risk, HP UFT, WindowDriver, FRTB, Mainframe, Web UI, Logistics, API Testing, Web-based Testing
  • Platforms

    Unix, Oracle, TestComplete
  • Libraries/APIs

    Pandas, REST APIs
  • Storage

    Greenplum
  • Industry Expertise

    Telecommunications, Insurance

Education

  • Bachelor of Technology degree in Metallurgy and Materials Engineering
    2003 - 2007
    National institute of technology, Jaipur - Jaipur, India

Certifications

  • Certified Scrum Master
    APRIL 2018 - PRESENT
    International Scrum Assembly
  • Certified Testing Professional
    OCTOBER 2010 - PRESENT
    ISTQB
  • Sun Certified Java Programmer
    JULY 2009 - PRESENT
    Sun Microsystems

To view more profiles

Join Toptal
Share it with others