Engineer Data

KIRUTHIGA SUBRAMANIAN

Email: *************@*****.***

Phone: +1-347-***-****

Skype ID: *************@*****.***

SUMMARY

8+ years of professional experience in testing with extensive knowledge of Automation Framework Design & Implementation using Selenium, QTP/UFT Tools

Experience in Functional, Regression and System testing using manual and automated testing.

Experience in test management tools like JIRA, ALM, QC, Microsoft Project Suite, TFS and IBM Rational Team Concert (RTC)

Experienced testing XMLs, Web Services, SOAP UI, REST API & Custom Based Approach.

Highly experienced in Functional, Integration, System, End-to-End, User Acceptance (UAT) and Regression Testing.

Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.

Extensive experience in ETL/Data warehouse/Data Mart backend testing and BI Intelligence reports testing.

Involved in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.

Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.

Extensive experience in Test Case/Test Scenarios/Test Conditions Creation from Use Case, Test Case Execution, Test Data Preparation, Test Environment Setup, Defect Verification and Management, Metrics Collection, Creation of Test Design Specification, Verification of requirement specification.

Extensive working experience on Functionality Testing - Regression Testing, System Testing. GUI Testing, Integration Testing and UAT (User Acceptance Testing).

Expertise in using TFS, Jira to open bugs, create tasks and user stories, initiate change requests.

Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.

Good Experience in writing XPath to locate web elements using selenium.

Highly experienced with source code management tools like git, subversion.

Work closely with the development team to test systems for defects using Scrum, Kanban and other Agile/Lean methodologies

Work with the release management and deployment team to create and maintain an automated nightly build verification (“smoke”) test

Extensive experience of working with cross cultural teams as well as on-site - Offshore model

Experience with C# Programing, UML concepts, design patterns and web technologies.

Created and maintained Test Scripts and Test Cases based on High Level Functional Requirements Document (FRD) utilizing Visual Studio Team System (VSTS) 2008, Team Foundation Server (TFS), for manual, automated(Functional & Regression), and performance/stress testing

TECHNICAL PROFILE

LANGUAGES

SQL, C#, JAVA, VB Script, XML, XSD

APPLICATION/WEB SERVERS

PEGA Applications, web and VB based Applications, Mainframe (Hummingbird Host Explorer), IBM Tools, Excel Macros

OPERATING SYSTEM

Windows, Linux

RDBMS

Oracle SQL, MS SQL, SQL Server

TOOLS

ICEDQ, HP Quality Centre (QC), Selenium, WebDriver, Eclipse, QTP, UFT, HP ALM, JIRA, TFS, Soap/REST UI, Informatica, Toad for oracle, SQL developer, Selenium Grid, Selenium IDE, IBM RTM, CI/CD

EXPERIENCE SUMMARY

1)Working in Grand Circle LLC, USA as QA Engineer from 18th Jun 2018 to 15th May 2020.

2)Worked in DEEGIT INC, USA as Sr. Test Engineer from 05th Sep 2017 to 15th Jun 2018

3)Worked in KlickSkill Pvt Ltd, India as Sr. Test Engineer from 01st Sep 2014 to 26th May 2017

4)Worked in Bluestar Infostack Solutions Pte Ltd, Singapore as Test Engineer from 05th Dec 2013 to 15th Aug 2014

5)Worked in IGATE Global Solutions Ltd, India as QA Engineer from 04th Aug 2011 to 06th Sep 2013

PROJECT EXPERIENCE

Client: Grand Circle Corporation, MA Jun’2018 – May 2020

Role: Sr. QA Engineer

Responsibilities:

Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations − match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

Involved in Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems. Used Test director for bug tracking

Performed GUI, Functional, smoke, Security, End to End, back end, Regression and UAT testing.

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Automated Test scripts using C# with Selenium and QTP.

Prepared Test cases, according to the business specification and wrote scripts using QTP according to the test cases. Designed and updated Test Matrix and Traceability Matrix. Ensure that all the Test Cases are updated in the Quality Center along with Master Test Plan.

Executed User Acceptance Testing (UAT) Test cases for Loan Review Functionality for the End Customer.

Executed tests and log results. Designed, Communicated, and enhanced QA testing plan for the application. Prepared and executed test cases manually for different modules.

Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review. Responsible to report bugs using Quality Center and MS Excel. Created Test lab and map the defects directly to the requirements in the Quality Center and run Reports.

Executed the test case in Mainframe applications.

Updated bug status through regular communications with Development team.

Involved in UAT process before rolling out to production when required.

Performed Web Test and Load Test using VSTS and used UFT for testing other Apps.

Environment: C#, Selenium, UFT, VSTS, Oracle 11g/12c, TFS, Tableau, TOAD, REST/SOAP UI, ICEDQ

Client: STATESTREET Bank, MA Sep’2017 – Jun’2018

Role: Sr Test Consultant

Project: Asset Management/Class Action

Responsibilities:

Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations − match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications

Involved in Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems. Used Test director for bug tracking

Performed GUI, Functional, smoke, Security, End to End, back end, Regression and UAT testing.

Automated Test scripts using QTP using VB. Excel Macros & java.

Prepared Test cases, according to the business specification and wrote scripts using QTP according to the test cases. Designed and updated Test Matrix and Traceability Matrix. Ensure that all the Test Cases are updated in the Quality Center along with Master Test Plan.

Executed User Acceptance Testing (UAT) Test cases for Loan Review Functionality for the End Customer.

Executed tests and log results. Designed, Communicated, and enhanced QA testing plan for the application. Prepared and executed test cases manually for different modules.

Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review. Responsible to report bugs using Quality Center and MS Excel. Created Test lab and map the defects directly to the requirements in the Quality Center and run Reports.

Executed the test case in Mainframe applications.

Performed Front-End Testing, Functionality Testing, and Data Driven Testing using UFT.

Involved in UAT process before rolling out to production when required.

Performed Web Test and Load Test using VSTS and used UFT 10.0 for testing other Apps.

Environment: UFT, Selenium, UNIX, VSTS, Oracle, Microsoft Test Manager, Microsoft project suite, IBM Rational Team Concert (RTC), Tableau BI Reports, JAVA, Mainframe, Postman, VSTS

Client: KlickSkill Pvt Ltd, INDIA Sep’2014 – May 2017

Role: Sr. Test Engineer

Project: Application Testing

eTutors Virtual Learning and online learning application providing an in-depth curriculum and a platform for problem solving to the students located anywhere in the world. Access to the program is through subscription.Basically, involved in the task of Regression Execution of multiple forms and applications from eTutorApplication (Both Smoke and functional testing)

Responsibilities:

Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications

Involved in Extensively during UAT testing (White Box and Black Box) of various functionalities along with the implementation team, resolved the issues and problems.

Performed GUI, Functional, smoke, Security, End to End, back end, Regression and UAT testing.

Prepared Test cases, according to the business specification and automated test scripts using QTP/UFT. Designed and updated Test Matrix and Traceability Matrix and ensured that all the Test Cases are updated in the Quality Center along with Master Test Plan.

Executed tests and log results. Designed, Communicated, and enhanced QA testing plan for the application. Prepared and executed test cases manually for different modules.

Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review. Responsible to report bugs using Quality Center and MS Excel. Created Test lab and map the defects directly to the requirements in the Quality Center and run Reports.

Provided support for Unit and UAT testing as required for the application or any other assigned application. Performed System, Functional, UAT and Black Box Testing.

Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications.

Authorized, scheduled, supervised and smoke-tested thin code and data migration from development to test environments.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Environment: Informatica, HP QTP/UFT, Oracle 11g/12c, Microsoft Test Manager, HP QC, SQL, JAVA Eclipse, Selenium WebDriver, IDE

Client: DBS BANK Pte Ltd, SINGAPORE Dec’2013 – Aug’2014

Role: Test Engineer

Project: DBS IDEAL Co-operative Banking

Major Modules:

Create Accounts

Create and process Payments (DD/CHEQUE/TT,ACH, CC)

Form Generations

Responsibilities:

Analysed Business Requirements and technical specifications for creating and implementing a test approach with effective test strategies.

Established processes and procedures to implement repeatable quality testing process by introducing metrics, test documentation, and reassigning responsibilities.

Assured that all features of a software program were thoroughly tested, detected problems were properly reported and assigned and brought to resolution.

Investigated various products from Atlassians JIRA.

Involved in utilizing ACH Network for batch-oriented electronic funds transfer in Credit card services.

Worked with both Waterfall and Agile methodologies and also worked in Quality Management software.

Performed functional testing, browser compatibility testing, Integration Testing, Automation Testing.

Involved in switching the customers old Identification pin to new Identification pin using secure ACH network while working with PCI compliance. The normal transferring time is about 3-5 days for the end users to do electronically.

Generated VUser scripts for Web Services (XML /Soap request).

Reported incidents in case of issues during execution and logged defects in HP Quality Center.

Used SQL statements elaborately to retrieve data for Database Testing.

Created and updated defect tracking logs and worked with development teams.

Assisted in the identification of QA tasks and associated level of effort.

Environment: HP Quality Center, QTP, Visual Studio, SQL Server, Oracle, Html, CSS, JavaScript, AJAX, Java, Windows, Linux, ACH File Creator

Client: Royal Bank of Canada Dec ’2012 - Sep ’2013

Role: Test Engineer

Project: Workflow Release 2

Automated Smoke Scripts of 14 Test cases which involves set up, modify and terminating ACH Recurring Checks and On Demand Scenario’s.

Responsibilities:

Developed Test cases for multiple releases based on Test Plans and minimal business requirements.

Assigned responsibilities of testing functionalities of IVR systems and prepare test scripts to support the testing process

Performing User Acceptance Testing in the UAT environment and executing test cases and logging defects in Quality Center (Test Director)

Involved in utilizing ACH Network for batch-oriented electronic funds transfer in Credit card services.

Created Text area Checkpoints to test the properties of the text in the application using QTP.

Performed E2E data validation involving multiple systems to ensure the data integrity.

Prepared formal test documentation including System and UAT Test plans, test cases, test summary reports, Bug fix and test evidence procedures, and reports.

Performed testing in different environments- QA, UAT and Production environment.

Conditioned the data for testing different environment.

Conducted Data Integrity Testing using Backend Testing techniques in QTP.

Environments: SQL, Windows/UNIX, HP Quality Center, MS Access, QTP, Clear Quest, JIRA, ACH File Creator

Client: Royal Bank of Canada Nov’2012 - Dec ’2012

Role: Test Engineer

Project: Applications from USWM Project

Involved in the task of Regression Execution of multiple applications from USWM projects like Morning Star, UMG, Road, DMZ (Both Smoke and functional testing)

Responsibilities:

Designed Test Cases according to the Functional Specifications.

Executed Test Cases to validate product compliance with requirement.

Executed Functional, Regression and Integration Test cases while effectively communicating Test results.

Performed Test Reporting and Analysis of Test Results.

Generated and communicated Test execution reports, performed failure investigation and Test script adjustments.

Performed Black Box, Smoke, System, User Acceptance Testing.

Used Quality Center for test plan execution and defect tracking in the application.

Was responsible for test planning, test creation, test setup& test mapping and exporting them into Quality Center.

Verified the Business Logic Implementation by constructing and executing several SQL statements in Oracle.

Created GUI files using QTP& performed Data Driven Testing (DDT).

Created automated scripts using Modular framework with QTP descriptive programming concept.

Environment: SQL Server, Visual Basic, Quality Center, QTP, Visual Studio, Oracle, AJAX, Html, CSS, Java, JavaScript, Windows, ACH File Creator

Client: Royal Bank of Canada Sep’2012 - Nov ’2012

Role: Test Engineer

Project: USWM - SQL Upgrade

Major Modules:

Build a new SQL Database environment for RBC Wealth Management leveraging SQL 2008 as the database platform

Migrate applications and databases to the new SQL 2008 environment

Design based on Active/Passive clusters (N+1)

Maintain Application and Business independence

Consolidate physical environment

Responsibilities:

Involved in the development of Test plan, Scenarios and Test scripts for manual, automation and performance testing of the various applications.

Interacted with Business Analysts on regular basis to understand the Business Requirements.

Developed automated scripts for Automated Regression Testing using Selenium RC.

Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing environment using Selenium RC.

Designed High Level Test Cases or Scenarios that map back to High Level Requirements and Use Cases.

Developed scripts for all manual Test cases using Junit.

Exported HTML Test case to Test Suite and then run on other browsers using Selenium RC.

Performed Web Services testing and Validated XML request/response data using SOAP UI.

Tested SOAP-based Web Services for enrolling customers, getting insurance information, creating claims

Performed Back-End Testing, database table manipulations of relational database systems by writing complex SQL queries manually.

Environment: Java, Selenium RC, Junit, Quality Center, SOAP UI, HTML, XML, XPATH, ACH File Creator

Client: Royal Bank of Canada Feb’2012 - Aug ’2012

Role: Test Engineer

Project: USWM - Client Source

Client Source has been developed to meet Private Client Division’s need to gather and store KYC information in a manner that is easy to create, retrieve and relate amongst our clients’ accounts. The first step is to create a client profile. The client profile contains information like the name, address, assets, income etc. about the client. This information is consistent for any account a client opens because it is specific to the client. Later, when you open an account, you will enter information specific to each account, like objectives and risk tolerance.

Major Modules:

Create Clients

Create Accounts

Form Generations

Responsibilities:

Create test scripts in TestNG framework using Java with Selenium Webdriver for regression test and maintain the same.

Check in the code into SVN.

Prepare common Methods while designing the framework.

Attend the Project Kickoff Meetings (PKM) with PM and Dev and understand the requirements.

Prepare the estimate for the PKM attended and share with Leads.

Create the test plan in QC by referring to the BRD.

Set up the test plan review meeting with Dev and PM and explain the test scenarios/cases in QC.

Responsible for deploying code & setup of QA and UAT environment

Troubleshoot the issues with set up of applications or other setting issues.

Perform testing on applications like Web, IVR, Batch processing, Real-time payments posting, Recurring Daemons and Crystal reports, Email notifications of One Time, Recurring and Mobile payments.

Test DTS, SSIS packages to Import/Export of data.

Identify and track defects while effectively coordinating efforts with developers or responsible parties to ensure defect resolution. Provide analysis and data for use in debugging.

Logging and Tracking defects using HP ALM.

Involved in handling the Production Issues and preparing RCAs for the issues reported.

Interaction with onsite coordinators, Dev and PMs for clarifications or other needs.

Prepare Daily status and send to the onsite coordinator.Prepare and maintain documents such as test environment sheet, metrics sheet, RCA doc, sign off doc, readme doc.

Environment: Eclipse, TestNG, SVN, MS SQL Server 2008., Windows, Oracle, Selenium IDE, Selenium RC using Java, WebDriver, QC, SQL Developer, Sharepoint, ACH File Creator, Mainframe

Client: Royal Bank of Canada Jan ‘2012- Feb’2012

Role: System Associate

Project: USWM - (WORKFLOW PH 1 Application)

Workflow is a multi-year program with the purpose of enhancing, improving and simplifying the RBC Wealth Management processes. The purpose of the Workflow program is to enhance the end-to-end productivity and efficiency by redesign and automation of the RBC Wealth Management work processes

Responsibilities:

Involved in defining Test objectives for the applications and performed Manual Testing.

Involved in cross browser testing using Netscape Navigator and Internet Explorer.

Involved in developing Integration Test Plans, System Test Plans and Performance

Test Plans

Developed Test Plan, Test Procedures and Process for UAT testing and involved in Installation

Responsibilities include acceptance testing, functional testing, Integration testing, System

testing, performance testing, stress testing and load testing the system

Used SQL Queries to verify the data from the Oracle database.

Conducted Regression Testing of the web-based application by using Win Runner

Recommending continuous process improvement, maintain QA standards and artifacts

Defect and Change Tracking was done using Test Director.

Involved in the User Acceptance Testing, Participated in various meetings and enhancement and Modification Request issues.

Environment: Java2.0, Mercury Tools (QTP, Test Director and Load Runner), TOAD, SQL, MS-Office, ACH File Creator, Mainframe

Client: Royal Bank of Canada Aug ‘2009 - Dec’2011

Role: System Associate

Project: Retail and PSG Application

I worked for Two Applications under Retail App Project (GRADS and CASPER) for the automation of regression test cases.

CASPER: The CASPER (Credit Application Scoring, Processing and Electronic Reporting) system is the place where all the credit products offered by the bank are initiated once the client approaches for one. CASPER offers products to both Personal as well as Business clients. Once a credit application has been processed successfully, no further action is possible on that from CASPER.

GRADS: Global Receivables and Disbursements System (GRADS) enables business clients to either credit or debit their customers at any Financial Institution located either in Canada or USA in Canadian or US currencies.

Responsibilities:

Designed Test Cases according to the Functional Specifications.

Executed Test Cases to validate product compliance with requirement.

Executed Functional, Regression and Integration Test cases while effectively communicating Test results.

Performed Test Reporting and Analysis of Test Results.

Generated and communicated Test execution reports, performed failure investigation and Test script adjustments.

Performed Black Box, Smoke, System, User Acceptance Testing.

Used Quality Center for test plan execution and defect tracking in the application.

Was responsible for test planning, test creation, test setup& test mapping and exporting them into Quality Center.

Created GUI files using QTP& performed Data Driven Testing (DDT).

Created automated scripts using Modular framework with QTP descriptive programming concept.

Was responsible for creating reusable user defined function in QTP to assist the Modular framework based test scripts.

Executed Test cases and identified mismatches and reported defects into Clear Questand tracked them till they were fixed.

Performed data validation to validate calculations and compare field migrations.

Participated in ongoing product specification and code reviews.

Participated in process improvement initiatives.

Acted as a validation and quality assurance professional across the different stages of the Testing lifecycle.

Environment: SQL Server, Visual Basic, Quality Center, QTP, Visual Studio, Oracle, AJAX, Html, CSS, Java, JavaScript, Windows, ACH File Creator, Mainframe

Contact this candidate