Jeyaprabha Arumugam

Contact : adxiw9@r.postjobfree.com/ +1-726-***-****

ERP / Workday / Peoplesoft / ETL /Quality Assurance/ HRMS / Workday SME /Senior Test Engineer / Data analyst/Team Leader

CAREER OBJECTIVE: To have a dynamic career in ERP, Data Warehousing and Oracle which gives me a chance to grow professionally and personally by exercising my knowledge and abilities in the best interest and contributing to the growth of the Organization I work for.

PROFILE SUMMARY

A highly competent and results oriented Test Lead/ Senior QA/QC Functional and Automation SDET with about 13 years’ experience in Software Testing, ETL Testing, Database Testing, ERP, Test Automation Design, Development, Maintenance and Application support projects. Proven ability during Workday upgrade testing for many upgrade versions and conversion to workday application from PeopleSoft.

Expertise in understanding Business Requirement Specifications, Functional Specifications and Design documentations and converting them into Test Scenarios to support quality deliverables.

Excellent Team Player, with strong skills in troubleshooting, Problem solving and communication

Played role as Played a role as Agile coach in project, cross auditing projects and following Agile ceremonies and have Good Experience in projects in Waterfall and Agile methodologies,

Attended different ceremonies like Program Increment (PI)Planning meeting, Scrum, Backlog grooming, Sprint Review and Retrospection.

Expertise in writing the Test Plan, Test Strategy, RTM, Test Cases and Test scripts according to the business requirement specification.

Extensive knowledge and Experience in ERP Applications like Workday HCM, Peoplesoft HCM.

Good Experience in Data Warehousing testing using ETL tool using DataStage and Oracle, Data base testing.

Good knowledge in validating Reporting tool -Tableau

Have worked on all phases of ETL Testing lifecycle from Requirement Analysis, Functional Studies, Quality Reviews to test closure and defect life cycle also.

Good knowledge of writing SQL queries to do the database validation effectively.

Have experience in running jobs in Control-M, Putty Commands, WinSCP.

Participated in regular project status meetings related to testing and lead the team to meet the deliverables on time. Also, Co-ordinated Defect review meetings with the development team (multi-Vendor) for the resolution of the defects.

Mentored team members and collaborated with them to resolve the issues.

Excellent knowledge and implementation skills in complete Software Testing Life Cycle (STLC)

Worked in various domains such as Healthcare, Retail, Insurance/P&C, banking domains.

Played role as Metrics coordinator in Quality Assurance to find the root cause for defects

Experience in working with open-source tools such as Selenium (Selenium IDE, Selenium Web Driver) Soap UI, TestNG, JIRA and Eclipse

Experience in automating Workday Application, tested different modules in Workday

Actively involved in preparation and estimation of Story Points for stories based on the criticality and priority.

Regression Test cases for Automation, Test Execution

Experience working in Workday Upgrade, System Testing, Regression Testing, Prod parallel testing, Ad hoc and Integration Testing

Extensive knowledge in Workday HCM modules like (Core, Workforce Administration, Compensation, Talent management, Time Off, Absence Management, Recruiting, Time and Leave, Benefits, Conversions, and Integrations)

Performed Database/Backend testing by writing SQL Queries for data validation and integrity, good at writing SQLs in PL/SQL as apart of PeopleSoft, ETL, Workday projects

Experienced in reporting the defects through the Defect Tracking Tools (Quality

Center/Jira) for centralized information

EDUCATION

Master of Computer Application (MCA)

Bachelor Of Computer Science (BSC)

CERTIFICATIONS AND AWARDS

ISTQB Foundation Level in Software Testing.

Oracle-PeopleSoft Human Resources Consultant certification.

qTest Certified foundation level

Received Medal and Appreciation certificate from USAA-CEO for the dedicated and extraordinary performance for the client USAA

Received Appreciation award for extraordinary performance and Contribution to the client Hewitt

TECHNICAL SKILLS

Methodology

Agile, Waterfall

Artifacts

Test Strategy, Test Plan, Test Case, RTM, Test Summary Report, Bug report

Tools/Technology

ERP-Workday, Peoplesoft, ETL, SQL, SQR, Database, Tableau, People tools, Application Designer, JIRA, HPQC

Automation Tool

Selenium WebDriver

Framework

TestNG, Page Object Framework,

Test Management

HP Quality Centre, qTest

Database tools

SQL Server, Oracle, MySQL, SQL Developer, Couchbase

Work Experience:

HCL Technologies Ltd from March 2015 till date

Hexaware Technologies from September 2009 – February 2015

Project Profile

Project #1

Project Name

Freddie Mac Multi Family Data Warehouse

Client

Freddie Mac

Role

Senior Test Engineer

Tools/Technology

Tableau, Denodo, Db2

Programming Languages

SQL, VQL

Databases

DB2

Duration

Sep 2022 to till date

1.Freddie Mac: Freddie Mac Multi Family Data Warehouse

Federal Home Loan Mortgage Corporation was chartered by Congress in 1970 to support the U.S. housing finance system and to help ensure a reliable and affordable supply of mortgage funds across the country. Rather than lending directly to borrowers, Federal Home Loan Mortgage Corporation operates in the U.S. secondary mortgage market, buying loans that meet the standards from approved lenders. Those lenders are then, in turn, able to provide more loans to qualified borrowers and keep capital flowing into the housing market. The Federal Home Loan Mortgage Corporation then pools the mortgages it buys into securities, which they sell to investors around the world. Freddie Mac Multifamily Line of business helps to ensure an ample supply of affordable Rental Housing by purchasing mortgages secured by apartment buildings with five or more units.

Project Description:

Federal Home Loan Mortgage Corporation’s Multi Family BTO’s New Technology Adoption (NTA) team enables Multi Family team for adoption of latest technology patterns for three

1.SSDSP – to build a Self-Service Data Science Platform:

2.Automate the Customer Credit Reporting for Customer Compliance

3.Multifamily Data Warehouse Migration (MF DW Migration)

Role and responsibilities

Analyze Business Requirements and Identify the Business flows based on Requirement Specification Matrix (RSM) and planned User Stories

Prepare & maintain Test Plan, Testing Strategy, Test cases, Test Coverage, Test Execution and Test Results capturing test evidence and Documentation

Experience in working in Tableau to Automate Customer Credit Reporting for Customer Compliance thru Tableau Report and validating the data for CCRM

Validated the Denodo views through VQL which is created on top of files stored at NAS location(s) to pull report data .

Process file data as needed to generate reports

Attending “Scrum Daily Stand-up” meeting with the team to provide a status on the following:

o What work was done yesterday?

oWhat will be done today?

oWhat obstacles are in the way or slowing down the work?

Involved in Analysis To Migrate DB2 data warehouse to a Snowflake cloud data warehouse as a part of Datawarehouse Migration plan

Organize weekly meetings with Onsite poc and discuss overall project status.

Project #2

Project Name

HRT (Human Resource Transformation)

Client

USAA

Role

Workday Test Lead

Technology

Workday

Programming Languages

SQL, PL/SQL

Databases

Oracle Database

Test Management Tool

Quality Center 11

Other Tools

JIRA.

Duration

Jul 2016 to Aug 2022

2.USAA: HRT

HRT-Human Resource Transformation from PeopleSoft V9.0 to Workday. The goal of this HR Transformation journey is to support HR transformation with an integrated strategic platform that enables more efficient execution of HR processes through Analytics. The entire HRT journey will replace the four existing HR systems/capabilities: PeopleSoft (Core/payroll), Success Factors (Performance/Succession), Virtual Edge (recruiting) and Workspace (compensation).

Role and responsibilities

Involve in Project Increment (PI)Planning, Requirement gathering requirements, feature and help in breaking down the features stories to each Iteration with story points based on the complexity and priority. Picking the stories from Product Backlog.

Involve in Iteration review, Retrospection, Parking lot and Impediment meeting to discuss the deliverables status and associated Risks.

Attending daily Stand-up call to update the QA team status, coordinating with offshore for clarifications and solutions and reaching out to business for queries.

Responsible for all aspects of project delivery (Test Design, Test execution and defect for the QA Team).

Organize weekly meetings with offshore managers, Onsite Coordinator & Onsite manager to discuss the Project goals and report the health of the overall project status.

Performed Integration Testing in Vendor Development environment and System Testing in SIT environment and User Acceptance Testing in Pre-Production Environment.

Involved Preparation of Traceability Matrix and mapping the Test Cases with the requirements and Test Metrics in Quality Center.

Reported bugs in Quality Center with server logs information from Web and DB servers.

Worked in upgrade versions and in various Workday HCM Modules like core, compensation, Talent Management, Compensation, Bonus, Recruiting, Time off, Absence Management etc.

Preparing SQLs to Validate the data in oracle database to ensure source and target data are some.

SME for Workday Recruiting Module End to End Functionality and QA POC for the HR Team.

Preparation of Test plan, Detailed test case Preparation, Test execution, linking the requirements and cases and execution with JIRA Test management tools to reflect executed scripts

Validate the data in Kafka to ensure the Tokenization to ensure Secured data is flowing to Downstream with Tokenized Personal Information (PI Data)

Automating the regression & project cases using Selenium

Logged defects and tracking using JIRA and Defect management tool

Coordinating with offshore on daily basis Explaining, assigning task, and clarifying queries

Experienced in testing several types of integrations and its process to validate the data

Project #3

Project Name

Fusion Accounting Hub

Client

USAA

Role

ETL Tester

Tools Used

DataStage 9.1, Control-M,

WinSCP, HP Quality Center 11.0, SQL Developer

Programming Languages

SQL, PL/SQL

Databases

Oracle Database

Test Management Tool

Quality Centre 11

Duration

Feb 2015 to Jun 2016

3. USAA: FAH

USAA is transforming its financial operations and plans to add value to the business by reducing transaction processing. The Fusion Accounting Hub module has been identified as a key technology component within this transformation process. FAH will provide a common sub ledger environment for processing sub system feeds, providing mechanisms that support more transparency in Rules maintenance, promoting, sharing and rationalization of rules logic across subsystems and creating the accounting necessary to post to the PeopleSoft GL and downstream systems.

Role and responsibilities

Validating the data using SQLs between the databases Existing system (FREND) and new system (FAH)

Involved in the comparison of Existing system (FREND) with new system (FAH) using- Compare utility tool

Involved in the identification of scenarios, test data preparation and preparation of test scripts according to the requirements.

Co-ordinated effectively with ETL Development team, PeopleSoft Dev team in resolving the issues.

Involved in the End-End testing of 24 Interfaces.

·Involved in the upload of test cases and requirements (stories) to QC, raising defects and linking the defects to the corresponding test cases

Played role as Agile spoc for the team

Involved in the SIT Testing of Finpal Interfaces for Phase 1 and Phase 2

Involved in Early testing in Dev Environment and Test environment:

Majority of the issues were found in early testing which helps the prod parallel testing as a defect free.

Test plan, Detailed test case Preparations and Test Execution in qTest

Attending daily Stand-up call to update the team status, clarifications, Risks, and solutions.

Regression scenario preparation for the existing frend jobs

Involved in the comparison of Existing system (FREND) with new system (FAH) using- Compare utility tool

Error scenarios preparation for the negative validation for all the Finpal interfaces

Project #4

Project Name

Rehosting CVS Pharmacy (From IBM platform to Hewitt Platform)

Client

Aon Hewitt

Role

Senior Test engineer

Tools Used

PeopleSoft HCM 9.1, Oracle 10g, HPQC

Programming Languages

Peoplecode, SQL, PL/SQL

Databases

Oracle 10g

Test Management Tool

QC

Duration

March 2014 to Jan 2015

4. CVS Pharmacy

To rehost the PeopleSoft HRMS 9.1 application from IBM platform to Aon Hewitt Platform. I was in involved in the Customizations and NA payroll testing.

Role and Responsibilities:

Played a Role as a Team Lead, monitoring the Status and Reporting to Onshore and discussing the issues on daily basis

Validating the data in PeopleSoft data base using SQLs to ensure the data transactions and accurate output populated.

Peer review of test cases done by team and monitoring the status.

Attending daily Stand-up call to update the team status, clarifications, and solutions.

Preparation of test plan, test case, Test execution, linking the test cases in qTest

Functional testing of NA Payroll, customizations, Reports.

Involved in Report generation using SQRs.

Identifying the critical Test Scenarios related to PeopleSoft Modules such as Workforce Administration, NA Payroll.

Project #5

Project Name

BMO (Bank of Montreal) HCM 9.1 Application Support

Client

Aon Hewitt

Role

Senior Test engineer

Tools Used

PeopleSoft HCM 9.1, Oracle 10g, HPQC

Programming Languages

Peoplecode, SQL, PL/SQL

Databases

Oracle 10g

Test Management Tool

HP Quality Centre

Duration

April 2013 to Feb 2014

5. BMO (Bank of Montreal)

The customer is the first chartered bank and highly diversified financial services organization and provides a broad range of retail banking, wealth management and investments banking products and solutions in North America. They have more than 40,000 employees in USA and Canada including the acquired banks. I participated in customizations and NA payroll testing. I was involved in the in-support activities of PeopleSoft HCM 9.1.

Played a Role as a Team Lead, monitoring the Status and Reporting to Onshore and discussing the issues on daily basis

Peer review of test cases done by team.

Preparation of test plan, test Scripts, test cases execution.

Validating the data in PeopleSoft data base (backend)using SQLs to ensure the data transactions and accurate output populated.

Functional testing of NA Payroll, customizations, Reports.

Involved in Report generation using SQRs.

Identifying the critical Test Scenarios related to PeopleSoft Modules such as Workforce Administration, NA Payroll.

Project #6

Project Name

PS upgradation for the Canadian Imperial Bank of Commerce

Client

Aon Hewitt

Role

Senior Test engineer

Tools Used

PeopleSoft HCM 9.1, Oracle 10g, HPQC

Programming Languages

Peoplecode, SQL, PL/SQL

Databases

Oracle 10g

Test Management Tool

HP Quality Centre

Duration

August 2012 to March 2013

6. CIBC- Canadian Imperial Bank of Commerce

Provide an upgrade of PeopleSoft HRMS application from 9.0 to 9.1. SIT scope of testing covers functional for HRMS modules, Canadian Payroll including Report testing, Interface testing and customized objects. I participated in the customizations.

Roles and Responsibilities:

Took the ownership of complete customizations of many modules like core, Workforce administration, compensation, bonus.

Preparation of Test Plan, Test Case Preparation, Test Executions.

Validating the data in PeopleSoft data base (backend)using SQLs to ensure the data transactions and accurate output populated.

Involved in customizations and reports testing to validate the worker data

Involved in back-end testing using SQLs in AQT tool.

Executing the Test Cases, Tracking defects and Reporting.

Coordination with team members and Developers in tracking and closure of defects.

Involved in Report generation using SQRs, and independently took care of all Customizations.

Project #7

Project Name

Unisys-PS ASM SupportControl Change Request)

Client

Unisys

Role

Peoplesoft Tester

Tools Used

People tools

Programming Languages

SQL, PL/SQL

Test Management Tool

HP Quality Center,

Duration

September 2009 to December 2011

7. UNISYS: US Electric Power Generation & Distribution company

Unisys one of the largest electric power holding companies in the United States, supplying, and delivering energy to approximately 7.2 million U.S. customers. (HRMS, Payroll) maintained in PeopleSoft. I participated in Support activities of PeopleSoft HRMS 8.9

Role and Responsibilities:

Played a role as Metrics coordinator and presented the reports for each quarter to the entire Quality team.

Analyzing the Business Requirement Document through co-ordination with Business Analyst.

Validating the data in PeopleSoft data base (backend)using SQLs to ensure the data transactions and accurate output populated

Identifying High Level Test Scenarios for the Change Request related to PeopleSoft Modules such as Workforce Administration, NA Payroll.

Preparation of High-Quality Test Scripts using HP Quality Center.

Involved in Workforce Administration Module for testing of various SQR generated Reports.

Adherence to Quality Process in all test activities involved.

Education and Visa Details:

Qualification: MCA (Master of Compute Application)

Work Authorization type: H1B

Contact this candidate