Summary
Overview
Work History
Education
Skills
Timeline
Generic

SHARAN JAYAMOHAN

LISTOWEL

Summary

Overall 11 years of experience as Quality Assurance Analyst. Experience spans across Data testing, Automation testing, Web application testing, ETL testing, BI report testing, Mainframe testing, MDM testing, BPM testing, CRM testing, mobile device testing, API testing, and enterprise system testing. Possess a good knowledge in Data warehouse concepts, Data Quality Assurance, BI reporting, ETL processes, Oracle DB, Teradata DB, Exadata DB, SAP Hana, SAP ERP, and cloud databases such as PostgreSQL and Informatica tools. Experienced in developing a testing framework using Python. Good exposure to Agile & Waterfall methodologies, Integration testing process, End to End testing process, Regression testing, UAT and Sanity testing. Extensively involved in all the phases of testing life cycle from Requirement gathering to Test Planning to Test Design and Execution. Experienced with various types of testing like GUI testing, Web testing, API Testing. Expertise in project management tools like HP ALM, Atlassian JIRA, Atlassian Confluence, and Qtest. Strong organizational skills and ability to multitask and meet the challenges of a fast-paced environment. Possess good knowledge in selenium automation scripts and Python programming. Experienced in developing data comparison and quality assurance tools using Python. Strong experience in writing and maintaining QA sign off documents, defect triaging, reporting and tracking. Expertise in interpreting PL/SQL packages, SQL functions, and Teradata bteq scripts. Expertise in Amazon Web Service applications. Excellent communication skills both technical written communication and oral.

Overview

11
11
years of professional experience

Work History

Senior Test Automation Developer

RBC Royal Bank
07.2022 - Current
  • Developed Python automation test suites using robot framework for ETL testing, saving 65% of manual work.
  • Integrated automation framework with Git and Jenkins
  • Converted business logic and mapping document to complex SQL queries for enhanced ETL testing.
  • Evaluated emerging trends in test automation, recommending suitable toolsets for adoption when appropriate.
  • Conducted thorough code reviews, contributing to improved overall code quality and maintainability.
  • Mentored junior team members, fostering a culture of learning and continuous improvement within the team.
  • Transformed legacy manual testing processes into efficient automated workflows through the implementation of cutting-edge testing tools.
  • Coordinated closely with developers to resolve defects promptly, ensuring minimal impact on project timelines.
  • Leveraged advanced tools and technologies to create innovative solutions for challenging test automation scenarios.
  • Balanced competing project demands while maintaining close attention to detail in all aspects of work history as a Test Automation Developer.

Senior QA Analyst

Ministry of Transportation - Ontario
08.2020 - 06.2022
  • Created test data in Mainframe and ran multiple JCL to generate output files
  • Tested and setup data in SAP GUI using different t-codes
  • Analyzed the business, technical requirements (Use Cases) and came up with test plans
  • Designed and executed test cases in both SIT and UAT.
  • Planning, Organizing and implementing the testing efforts
  • Automating test cases using robot framework (python)
  • Testing reconciliation reports data using python dataframes
  • Implemented data testing framework using python
  • Coordinating different government organizations to effectively test the integration module
  • Following up with business stakeholders on the requirements
  • Creating test data for execution of test cases and providing test data set to downstream organizations
  • Validating the mainframe JCLs by executing the jobs and validating the output EBCDIC files
  • Testing Licensing Control System built on mainframe.
  • Worked in conjunction with the developers to create and use data-driven Selenium automation test scripts using Selenium WebDriver, Java and TestNG
  • Maintained and Enhanced in-house ETL test automation testing tools built on Python program
  • Expertise in creating RTM, test scenarios and test cases
  • Timely updates about the testing status to the stakeholders in the daily scrum meeting and weekly status reports sharing test execution metrics

Test Analyst

Infosys Ltd
05.2019 - 08.2020
  • Identified the testing effort and scope for both the tracks and came up with test plans
  • Both manual and automation verification of MDM PIM platform using selenium web driver
  • Data migration testing between SAP and Netezza DB
  • Created a testing POC framework using pyspark
  • Experience in BPM workflow validation using TIBCO workspace and open space
  • Validation of SAS reports and analytics
  • Experience in root cause analysis and defect diagnosis techniques
  • Experience in functional and workflow testing, in agile methodology and execution of test cases in both SIT and E2E testing phases using Qtest tool, with defect logging in JIRA tool
  • Performed Functional, Smoke, Integration, Regression, Ad-hoc, System Integration Testing (SIT), Regression Testing (RT), End to End Testing
  • Developed and supported the implementation of an automated test framework
  • Extended QA role to do business analysis to validate the requirements against the user stories.

Test Analyst

Infosys Ltd
06.2013 - 05.2019
  • Client: CVS Pharmacy Project - Enhanced Home Delivery
  • Good understanding of data warehouse/data Integration concepts and defined test strategies specific to the project needs
  • Experience in data analysis, data validation, and ensured data completeness, data transformation & data quality for various data feeds coming from various sources
  • Experience in BI report testing in Microstrategy Reporting tool, in waterfall methodology and execution of test cases in both SIT and E2E testing phases
  • Experience in exploratory testing of self-service MSTR modules
  • Created accurate and efficient SQL queries to verify the result set generated through MSTR tool
  • Analyzed oracle PL/SQL packages using TOAD to setup test data and to validate the code's adherence to business requirements
  • Analyzed teradata bteq scripts to verify the flow of data into semantic layers
  • Scripted and optimized complex SQL queries to maximize success of data testing
  • Debugged Oracle packages, bteq scripts and located root causes of defects by reviewing the code
  • Understanding the project requirements and creation of test cases and scenarios based on them
  • Used HP ALM tool for test design, test execution and defect tracking.

Education

Bachelor of Technology -

01.2012

Skills

  • Python, Robotframework, Selenium, UFT
  • SOAP UI, POSTMAN, MicroStrategy, AWS tools, Unica, Selenium, Filezilla, Control-M, TOAD
  • Oracle, Teradata, Exadata, Netezza, SAP Hana, MsSQL, MySQL, PostgreSQL, RedShift
  • HP ALM, Jira, Qtest, Visio, MS Office Suite, Azure Devops
  • ETL, TIBCO MDM, TIBCO BPM, Informatica, SAP ERP, Amazon Web Service

Timeline

Senior Test Automation Developer

RBC Royal Bank
07.2022 - Current

Senior QA Analyst

Ministry of Transportation - Ontario
08.2020 - 06.2022

Test Analyst

Infosys Ltd
05.2019 - 08.2020

Test Analyst

Infosys Ltd
06.2013 - 05.2019

Bachelor of Technology -

SHARAN JAYAMOHAN