Data Management Test

Kalaiyarasi Arokiadass

Frisco, Texas Email: *************@*****.***

Phone: 945-***-****

LinkedIn: www.linkedin.com/in/KalaiyarasiArokiadass

Objective:

Looking for a challenging position as a professional QA and TDM analyst to effectively utilize my technical and analytical skills for the benefit of the organization.

Professional Summary:

10+ years of experience in software testing, TDM and Application Release Management

Expertise in SDLC and Agile methodology of Project development and tailoring Testing process

Created Test Strategies, Test Plans, RTM, Defect Metrics, and test summary reports.

Expertise in Manual Testing, Automation Testing, Test Data Management, API Testing, Database Testing and CRM Testing

Good experience in Automating Web application using Selenium WebDriver with java.

Experience in working on Page Object Model design pattern with hybrid framework.

Used Jenkins as continuous integration server to run automated test suites in different test environments and with different configurations.

Used version control tool GIT for code maintenance.

Knowledge on basic UNIX/LINUX commands.

Worked on web services/API testing.

Proficient in SQL queries

Proficient in Test Data Management concepts (Data Provisioning, Data Refresh, Data Subsetting, Data Masking and Data Reservation) and used ILM-TDM and web service tools SOAP UI, Postman and DevTest

Have basic knowledge of SAP concepts.

Worked on Application Admin & Release Management

Ability to meet deadlines and handle multiple tasks, flexible in work schedules.

Good Experience on conceptualizing business needs and translating them into viable technical solution.

Technical Skills:

Hardware / Platforms

Windows 2008/2010/2011

Testing

Functional Testing (Manual/Automation), Test Data Management, DB Testing, CRM Testing

Tools

UI Automation: Selenium WebDriver, TestNG, Cucumber, Robot Framework

CI/CD: Maven, Jenkins

Version Control: GitHub

Webservice: SOAP UI, Postman, RestAssured,Swagger

Databaseclient: DB Visualizer, DBeaver

Defect/Test management: HPALM, JIRA, Azure DevOps

Database

MS SQL Server, Oracle SQL Server, PostgreSQL

Language/script

Java, JavaScript, groovy, Python

Relevant Project Experience

Organization: Humetis Technologies

Title iVMS

Tools Used SOAP UI, Postman,JIRA,MS SQL server

Role Senior Test Analyst

CLIENT DESCRIPTION:

A comprehensive Staffing Solution platform that brings Vetted Project owners (Client), Skill sources (Staffing Companies) and Specialists (Candidates) together to collaborate and leverage each other’s services, solely based on fairness, compliance and credibility with no limitations, iVMS in a nutshell

ROLES AND RESPONSIBILITIES

Prepared test plan based on the requirements.

Executed various testing procedures such as functional testing, API testing, Regression testing, sanity & smoke testing for each release cycle of the application.

Performed defect analysis during and after release and provided detailed defect metrics to improve the code quality.

Dashboard creation in JIRA for all the test phases to depict the execution and defect status.

Provided demo to product team on regular interval to improve overall product quality.

Involved in API and data base testing

Organization: Wex Inc

Title Wex Fleet

Tools Used SOAP UI, Postman,JIRA,MS SQL server, postgresql, Pycharm,robot Framework

Role Senior Test Analyst

CLIENT DESCRIPTION:

WEX Inc. is a provider of payment processing and information management services to the United States commercial and government vehicle fleet industry.

ROLES AND RESPONSIBILITIES

Collaborated with product owners and business analyst to stay current on product features and intended functionality

QA Effort estimation for current ongoing projects, CRs and SRs based on the resource bandwidth and the requirement complexity

Test Strategy, Test plan creation for the new projects proposed and the resource allocation for the test phases

Defect triage for ongoing postilion migration project and retrospective meeting for the projects nearing completion

Tested Rest API in Postman by referring swagger documentation

Created accurate and efficient test scripts in Robot Framework for automating smoke,functional and regression test suites

Reviewed test automation code and provided input on team’s coding efforts.

Supported Devops integration to ensure continues integration and deployment

Organization: Collabera Technologies Private Limited

Project #2

Title Merchant Dashboard

Client Tata Digital

Tools Used postgresql, Postman, JIRA

Role Test Lead

PROJECT DESCRIPTION:

Merchant dashboard is web application allows BNPL and UPI merchants to view and manage their users and transaction.

ROLES AND RESPONSIBILITIES.

Prepared test plan based on the requirements.

Aligned the team to execute the testing processes defined in test strategy and test plan.

Executed various testing procedures such as functional testing, API testing, Regression testing, sanity & smoke testing for each release cycle of the application.

Performed test results analysis post execution of testing and provided feedback on areas of improvements in quality.

Performed defect analysis during and after release and provided detailed defect metrics to improve the code quality.

Dashboard creation in JIRA for all the test phases to depict the execution and defect status.

Provided demo to product team on regular interval to improve overall product quality.

Flutter web application automation using flutter webdriver to automate the regression test suite

Title GRIDS

Client Avenu Insights India Private LTD

Tools Used Selenium Webdriver with TestNG framework, MS Sql Server, Microsoft Azure DevOps

Role Senior QA Analyst

PROJECT DESCRIPTION:

web-based system allows recorders and clerks to consolidate entries into a digital database that seamlessly indexes, files, searches, images, redacts, and reports records in compliance with constitutional requirements.

ROLES AND RESPONSIBILITIES.

Introduced automated testing on the project that previously had a fully manual test environment.

Implemented hybrid automation framework from scratch using selenium webdriver and TestNG.

Identified test cases to automate and develop automation test scripts for smoke and regression test suits.

Followed Behavior Driven Development (BDD) as much as possible.

Executed all selenium test scripts in different browsers to ensure the compatibility.

Validated REST API services using postman.

Organization: Cognizant Technology Solutions

Title Whole Game System

Client The Football Association [Information, Media, and Entertainment Domain]

Tools Used Selenium Webdriver, Postman, MSSql Server

Role Senior QA Analyst

PROJECT DESCRIPTION:

Whole Game System(.Net) is a web-based system used by The Football Association Limited (“The FA”), County Football Associations (“County FAs”), Other Football Associations (as defined in The FA's rules), leagues and clubs for several their football administration functions which mainly enables club, league and referees to administer their day-to-day activities.

ROLES AND RESPONSIBILITIES:

Have been involved in requirement analysis and test plan phase for all monthly releases.

Facilitating daily scrum calls

Analyzing Test Cases for the feasibility to automate and reviewing with functional team.

Test planning, writing automated scripts, test execution, defect logging and defect Triaging with the dev team.

E2E functional testing of CRM application

Developed a framework using Selenium with BDD Cucumber and maintained and identified the scenarios to be automated.

Continuous maintenance of the developed automation scripts whenever there is a functional change in the application.

Functional and integration testing for B2C implementation (Single sign on-SSO) for WGS & PFF

Title Test Data Management

Client Loblaw Inc [Retail]

Tools Used Selenium, QTP, SOAP UI, Dev Test,Oraclesql server, DB visualizer.

Role Team Lead

PROJECT DESCRIPTION:

The centralized Test Data Management team established in Loblaw to provide thought leadership on test data management for large scale projects where test data management activity is very time consuming & complex and offer data masking solution to make sure privacy & confidentiality of personal or business sensitive data is not compromised when used for testing purposes.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Lead the central TDM team by handling all internal activities related to a project, attends all meeting at offshore and reports the progress of the overall project to senior management.

Test data provisioning for functional and regression test cases for both SAP and Non-SAP application

Have worked on data subsetting and data refresh by creating SQL queries to extract the data from SAP QA database as part of Data subsetting and having the data in TDM database for faster data identification.

Have been involved in test strategy preparation for the new projects/releases as part of test data strategy.

Have worked on data masking by identifying the sensitive information and defining the masking rules for each sensitive fields and ensured the successful implementation by coordinating with respective teams (DBA, Infra, business, and functional)

Have been part of Test Data Masking analysis to enhance security of sensitive data across QA environments. Collected data across multiple applications and its QA environments and analyzed the data for potential sources of Sensitive information for Data Masking

Title SOF integration

Client Payless [Retail]

Tools Used Microsoft SQL Server, Epicor, HP QC

PROJECT DESCRIPTION:

Payless has upgraded their POS systems from Fujitsu to EPICOR as part the Store of the Future (SOF) project. Current store environment is a highly modified Fujitsu POS that has exceeded End of life. Current Corporate environment to support stores POS software is aged and past end of life as well to include Sales Audit and CRM database. This project mainly focuses on the system integration between the interfaces such as Product, Store, Tog and Tax.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Have worked on all the critical interfaces like Store, Product, Tlog and tax.

Have been involved in Test Designing – Writing Test Scenarios and Test Cases in HP QC

Have prepared the test data setup required for the testing various scenarios.

Have performed the complete testing on the databases and ensured that the data is updated in the target databases from source database.

Have performed the end-to-end testing on the files that are delivered to Epicor by payless team and ensured that valid data is delivered in the requested format.

Have raised defects in QC whenever an issue is identified and ensured that the raised defects are fixed by dev team and been closed on time.

Backend Testing by testing schemas and data along with the data comparison b/w source and destination.

Title Walgreens-Pharmacy

Client Walgreens [Healthcare]

Tools Used HP QC, Eclipse

Role QA Analyst

PROJECT DESCRIPTION:

Walgreens Co, E-Commerce websites pave an avenue for an end user to buy Walgreen’s and other third-party dealer’s products, online. The site offers different capabilities like pharmacy, photo, clinic, health info and online shopping. Pharmacy takes care of the prescriptions, their refills, information regarding drugs, direct contact with pharmacy staff through Chat etc.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Requirement analysis

Preparation & Execution of functional test cases/scenarios

Scripting for the feasible test cases for automation using selenium.

Documenting and reporting defects

Regression Testing

Go live testing.

Title Infrastructure Application Release & Admin Management Support

ClientMarks & Spencer [Retail]

Role Team Member

PROJECT DESCRIPTION: Cognizant ARM team manages all the release activities that are planned in M&S production regions. All the change management activities need the sign-off from ARM before performing the release management activities.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Played a key role in delivering the end-to-end lead role for application admin and release management activities.

Managed and validated all the release management reports that are shared across Cognizant and M&S management: Daily change report, Sev1 incidents, Weekly support changes, changes planned & delivered report, Change report for top 30 applications.

Played a key role to ensure the PST region is in synchronization with the production region by generating the PST synchronization and utilization report.

Reviewed and validated the 3rd party software’s and managing agents that are used by support teams.

Representing the SPAF meeting for privileged Access.

Contact this candidate