JEYASEELAN JAYAPAL

E-mail: ad3hg2@r.postjobfree.com Mobile: +1-201-***-**** LinkedIn: Profile

Professional Summary:

Extensive experience in Software Quality Assurance, Test Management, Testing Process, Test Automation, API, ETL, Performance testing and Web UI Testing in a largescale Strategic, Digital & Cloud transformation program within a fast-paced Agile/Scrum delivery model.

Solutions oriented professional with progressive experience in QA Lead and End-to-End Testing capacity in the evolving platforms like Cloud & Big Data migration, API Modernization and Digital channel interactive UI Programs.

Gained extensive domain knowledge in Global Banking CRMS, Sales and Deals, AML-KYC, Salesforce, MS Dynamics, Global Payments, Wire, Fedwire, ACH Payments, Message Queue, SWIFT, Client Reference Data, Client Onboarding and General Insurance, Pega Claims.

Extensive experience and Knowledge in testing tools & techniques

Test Automation - Java, Selenium, Cucumber BDD, Junit, TestNG, UFT, TOSCA

API - Java, Cucumber BDD, POSTMAN, Parasoft SOAtest, SOAPUI

Performance Testing - JMeter, LoadRunner, RPT, Sitescope, Dynatrace, Splunk

ETL/ELT - Db2, Oracle, SQL Server, PostgreSQL, Teradata, SQL, HQL, HIVE, Azure SQL DB, Snowflake DB, AWS Redshift, GCP Big Query, DWH and Data Lake.

BI - MicroStrategy Reports, Cognos and Power BI Tableau Reports

Other tools- ALM (Quality Center), JIRA, qTest, Rally, GitHub, Bitbucket, Jenkins, Ansible.

Experience Summary:

QA / Test Management Experience:

10+ years of experience in QA Lead / End to End Testing, Test Process, Test Automation and Performance, ETL and API testing in the enterprise level strategic Programs.

Consulting services leading workshops, assessing testing maturity and identifying opportunities to build a strategy for implementation of full-scale testing programs.

Experience sizing testing efforts and managing projects to a budget and timeline.

Hands on experience as a Test Lead working with developers, product specialists, business analysts, and project managers in Agile and traditional waterfall methodologies.

Managed Business Partners and Business user in UAT Testing and Prod Cutover testing.

Define and implement Test Strategy, Test Plan, and Automation framework to ensure high standard of testing and quality is in place.

Execute and evaluate software quality assurance across SDLC by conducting System Testing, Regression, Integration and End to End Testing, Isolate, replicate, and report quality assurance defects and verify defect fixes. Conduct defect review and publish status report.

Automation & Functional Testing Experience:

7+ years of experience in Automation using Java and Selenium, Cucumber BDD framework.

Implemented Java based Automation development in-house Hybrid RAFT framework for Web UI, API and ETL Testing, Utilized BDD, Data Driven Test (DDT), Page Object Model and Page Factory design patterns.

Developed Automation test scripts in Java, Selenium Web Driver, Cucumber Gerkins, TestNG, Junit, SQL languages.

Executed APT test scripts and logged Bug in JIRA for resolution.

Built customized HTML reports for Step level and Test summary.

Experienced in CI-CD integration with Github/Bitbucket and Jenkins.

API / Middleware MQ Testing Experience:

7+ Years of experience in Middleware platform Testing using tools like Postman, ParaSoft SOAtest, APPWatch and Java-Based Automation framework.

Experience in handling RDF/Trig file formats for Client REST API testing.

Extensive Experience in IBM MQ, MuleSoft ESB, Messages, SWIFT Messages MT102, MT103, EXEC983, FLM, XML, Pain001. Pacs008 file formats, FTP, Wire, ACH Payments, FedWire, FTR Informatica Data eXchange, Web services, JSON, Restful services and APIs.

Prepared test cases, Test messages, files based on the feature requirement specification.

Implemented Automation framework development in Java, Cucumber BDD, Data Driven Test (DDT) methodologies for API, MQ, RESTFULL services testing.

Executed APT test scripts and logged Bug in JIRA for resolution.

ETL-BIG Data Testing Experience:

Around 7 Years of experience in ETL and ELT Process, Big data Hadoop Testing, HDFS, Hive, Sqoop, HBase and RDBMs Oracle 11g, Netezza, Teradata, DB2, SQL Server and BI reporting MSTR, Cognos and Power BI Tableau

Perform ETL and ELT data validation testing on Data Lake, Data warehouse applications on-premises and cloud

Data migration integrity validation between legacy databases and cloud AWS, Microsoft Azure SQL Database and Hadoop Bigdata.

Exposure to cloud data platforms GCP Big query, Azure synapsis.

Utilized RAFT Automation framework built on Java, Cucumber TDD/BDD technique for ETL and Data validation.

Proficient in writing complex SQL Queries and validate ETL/ELT Test scenarios.

Validation of Data Integrity Check, Quality, Uniqueness, Structure and Field Mapping

Validated Aggregation, FACT and DIM tables business logic within DWH tables.

Executed ETL test cases and logged defects for data discrepancies

Executed informatica and Auto-Sys Jobs for data refresh in LLEs.

MSTR, Cognos and Tableau Report data validation with Databases.

Performance Testing Experience:

5+ years of experience in performance Testing, utilized JMeter, LoadRunner and RPT.

Design, develop and execute system performance test, Load testing, Stress testing, Scalability testing, Spike testing, Volume testing, Endurance/Soak testing.

Create Performance Test scripts in JMeter for Web UI, API and DB calls.

Experience identifying memory leakage, connection issues, throughput bottlenecks in web application, infrastructure, and Cloud.

Monitoring using APM tools and publishing performance metrics such as resource data, CPU, network and database utilization, Garbage collection.

Strong Knowledge in Monitoring Tools CA Wily Introscope, Sitescope, Dynatrace, Splunk.

Certified professional in HP Load Runner, IBM Rational Performance Tester.

Career Profile:

Role

Organization

Location

Date

QA Automation Lead

(APIs, Web UI and Database)

Bank of America (Client)

Mitchell Martin Inc.

Newyork City, USA

Oct 2021 – Till Date

QA Lead / E2E Test Lead

Automation/Performance/ETL

(APIs, ETL and Web UI)

Bank of America (Client)/

AIG (Client)

Tata Consultancy Services

Newyork City, USA /

Chennai, India

Dec 2012 – Oct 2021

Performance Test Consultant

(Web-UI, APIs, and DB)

Bank of America (Client)

Tata Consultancy Services

Chennai, India

Dec 2011 – Nov 2012

Test Automation Engineer

(Functional Web UI & APIs)

Bank of America (Client)

Tata Consultancy Services

Chennai, India

Feb 2011 – Dec 2011

Test Lead & UAT Test Coordinator (AMLKYC)

Bank of America (Client)

Tata Consultancy Services

Chicago, USA

Apr 2009 – Feb 2011

Test Engineer (ETL & BI)

Bank of America (Client)

Tata Consultancy Services

Chennai, India

Oct 2006 - Mar 2009

Educational Qualifications

Degree and Date

Institute

Major and Specialization

Master Of Philosophy in Computer science - 2006

Bharathiyar University, Coimbatore, TN – INDIA

Computer Science

Master Of science in

Computer science - 2004

Vysya College,

Periyar University, Salem, TN – INDIA

Computer Science

Details of Assignments

Project Title # 1

GMAR - Client Reference Data, New York City

Client

Bank of America, Mitchell Martin Inc.

Role

QA Automation Lead

Duration

Oct 2021 – Till Date

Description

Client Reference Data:

Client Reference data platform consists of suite of applications, such as client REST APIs, Refservice APIs, Content Management APIs, SPARQL, Web UI cesium and Client Onboarding Workflows, AMLKYC profile, AMLKYC questioner, AMLKYC Restrictions and closures and Database GMAR applications LATR, Account AML reports.

1.APIs - Client REST API, Refservice APIs are built on RDF/TRIG formats to publish and validate party into cesium and allow other upstream or downstream applications to access and publish parties, AMLKYC and Accounting related data within bank.

2.Web UI - Cesium UI is used for publishing and tracking newly onboarding clients, Onboarding workflows and their AMLKYC reference data.

3.Database – GMAR DB Application consist of AML Regulatory Reports, LATR, Account AML and reconciliation report. LATR feeds data daily from GM data and validates AML regulatory compliance and Account AML feeds data from Cesium and validates the party AML complicate.

Automation scope is to adopt and customize in-house java-based automation framework RAFT, Litmus Test and develop automation scripts for APIs, Web UI workflows and Database Validation functionalities and perform functional and regression testing.

Responsibilities

•Understand and implement Bank’s inhouse automation platform RAFT Java-Based platform and execution tool Litmus Test.

•Collaborate with RAFT support team and adhere with the changes introduced.

•Define and implement Test Strategy, Planning and enhance framework to ensure high standard of testing and quality is in place for the in-scope applications.

•Prepare Test cases, test data RDF/TRIG files based on the feature requirement specification for Clent REST API and Refservice applications.

•Create Cucumber feature files using BDD Gherkins.

•Develop test scripts in Java/Selenium webdriver for client onboarding UI workflows.

•Prepare Performance Test scripts in JMeter for API and DB calls.

•Schedule and execute Load, Stress and endurance test and share the performance metrics with Development and Project Team.

•Prepare complex SQL for ETL data validation and BI Tableau reports.

•Create ETL test automation scripts in Java, Cucumber BDD test methodology

•Executing and checking the script to ensure bug free scripts deliverables.

•Check in and Check out Automation codes in Bitbucket.

•Automation test execution and report Defects in JIRA

•Participate daily Agile scrum meeting and update JIRA tickets

•Schedule Litmus test for daily Health Check, Sanity and Regression testing.

•Perform release coordination in ROTA by developing Ansible playbook scripts.

Tools

Java, Selenium Webdriver, Cucumber BDD, Postman, JIRA, RDF/TRIG, JMeter, Bitbucket,

Ansible, DB2, SPARQL, Tableau

Project Title # 2

Portugal SAFT Invoice Regulatory and Stamp Duty Monthly Reporting

Client

American International Group (AIG)

Role

QA Automation Lead / End to End Test Lead

Duration

Sep 2019 – Sep 2021

Description

Portugal SAF-T Invoice Regulatory:

Portugal was the first country to follow OECD recommendation to adopt in 2019 the Standard Audit File for Tax (SAF-T) file. The Portugal SAF-T file has followed a phased development process with increasing requirements for companies.

The Portuguese Tax Authority (PTA) has stipulated that a certified invoicing system/software be used to produce invoices and relevant tax documents and have the capability to extract a SAF-T Invoicing file reported to the PTA on a monthly base. Such system certification is performed by the PTA in a controlled process.

Portugal SDMR:

This Project requires new process flow for generating Stamp duty monthly report in Portugal. Till date SD amount collected are report to PTA (Portugal tax Authority) in total, from Jan 2021 the stamp duty to be reported per Tax ID per SD code / type of transaction per region. Following Iberia system are in scope for this project.

1)Portugal GOALD Premium data extract.

2)Portugal DM Web Premium data extract.

3)New ETL job(s) on extraction, data loading, and consolidation and XML generation.

Responsibilities

•Test process Governance for all the QA Programs to adhere to the Testing Factory stand standards in agile methodology.

•Define and implement Test Strategy, Planning and framework for testing.

•Analysis feature requirements specification

•Develop Test script Cucumber BDD feature files and create java step definitions

•ETL test automation using Java, Cucumber BDD test methodology

•Prepare complex SQL for ETL data validation and BI Tableau.

•Prepare Performance Test scripts in JMeter for API and DB calls.

•Schedule and execute Load, Stress and endurance test and share the performance metrics with Development and Project Team.

•Monitor the test using APM tools Dynatrace.

•Prepare and publish Performance test report and key metrics

•Prepares / updates the metrics dashboard at the end of a phase or at the completion of project

Tools

Java, Selenium Webdriver, Cucumber BDD, JIRA, HP ALM/QC, Sybase 15/16, ETL Data

stage, Github, MPP, VB.net, Power BI Tableau, AWS, Azure SQL Database.

Project Title # 3

Treasury Authorized data Provisioning (TRADs), Hadoop Migration

Client

Bank of America

Role

QA Automation Lead / End to End Test Lead

Duration

Sep 2018 – Aug 2019

Description

Treasury Authorized data Provisioning (TRADs)Phase 1:

Data migration from all the SOR’s of TRADs Provisioning to staging maintaining data quality, which is required for reverse data lineage of RDA Assessment.

Phase 2:

Migration of Data Provisioning to Big Data using Hadoop, Hive, Sqoop and Spark by creating a Unified Credit model (data model) to provide the structured data to the downstream.

Responsibilities

Test process Governance for the QA Programs to adhere to the Testing Factory stand standards in Agile methodology.

Ensuring the changes to the templates is published to the entire team.

Participating in Test Plan/Test Specifications/Test Scripts Review meetings.

Develop selenium/java script using RAFT Framework

Develop Automation test scripts in Java, Cucumber for data Validation

Prepare Complex SQL, HQL for data validation.

Data Integrity, Data Quality, Data Uniqueness, Structure and Field validation.

Data cleanliness, scrubbing and masking check

Data Validation between HDFS Vs RDBMS by running Sqoop Jobs.

SQL Aggregation, FACT and DIM table validation in DWH.

Represent QA in daily scrum calls with Scrum Master, Product, Dev/QA teams to discuss issues and action plans

Prepares / updates the Test completion Report at the end of Test phase,

Tools

Java, Selenium Webdriver, Cucumber BDD, JIRA, HP ALM/QC, Big Data, Hadoop, Spark QL,

Katka, HDFS, bitbucket, Azure SQL Database, Azure Data Studio, GCP, Snowflake DB

Project Title #4

Middleware Technologies (SWIFT Mandates, ACH Rhino, Dynamic Currency conversion, OFAC Scanning, GFD, GTMS & Other Apps, Payments Platforms)

Client

GBAM - Bank of America, USA

Role

End-to-End Test Lead / QA Lead, Middleware Data Services

Duration

Nov 2012 – Aug 2019

Location

Newyork City, NY, USA

Description

SWIFT Network will update and/or implement new message types in response to regulatory and AML requirements for every year November release. SWIFT is the Society for Worldwide Interbank Financial Telecommunication. More than 10,000 banking organizations, securities institutions and corporate customers in 212 countries use these SWIFT formats daily to exchange millions of standardized financial messages.

To support these changes, Bank of America must make changes globally every November on the wire payments systems to accommodate any new messages or updates to existing messages

Responsibilities

•Define and implement Test Strategy, Planning and framework to ensure high standard of testing and quality is in place

•Analysing and reviewing the Request Processor mapping documents and Imitative Integrated Matrix (IIM), XSD, Copybook

•Extensive experience in handling and preparing test Payment file formats SWIFT MT102, MT103, EXEC983, FLM, ISO Pain.001, Pacs.008, XML, XSD, FTP, Wire, ACH Payments, Fedwire, FTR Informatica Data eXchange, RDF and Trig files.

•Validating and tracking the services using bank internal RPST/RPIST tools

•Validation and verification of XML tags, Message payloads fields

•Develop Automation test scripts in BDD framework, Cucumber for Service Validation

•Create cucumber feature files, Data port and YAML file Set up

•Check point Review of SOA Test scripts in Parasoft SOAtool for MQ services and HTTPS services for regression testing

Tools

IBM DataPower, IIB, Mule ESB, DB2, Oracle, Java, Cucumber, Parasoft SOATest, Quality Center, XML Spy, SSH Tectia, Notepad++, AppWatch, PathWAI, Azure SQL Database, Azure Data Studio.

Project Title #5

CED Infrastructure & RAC Implementation

Client

GWBT– Bank of America, Chicago USA

Role

Performance Test Lead

Duration

Apr 2009 – Nov 2012

Description

RAC Project addresses the current gap in the Banks Client Data Management (CED) environment of not supporting a 24x7 global operation. CED is the System of Record for GCIB Legal Entity information supporting client regulatory and reporting requirements for BAC. Due this RAC Implementations CED will have a stated SLA of 24x7 target uptime, and the necessary supporting processes will satisfy a 24x7 operational model, or at minimum a 24x6 operational model for helpdesk functions to support a Global user base introduced by the Merrill Lynch portfolio. The scope of this initiative will be to convert the current database instances from single instance to Real Application Cluster (RAC) database instances.

Responsibilities

Defining Performance Test Strategy, Planning and scheduling required level of Load testing

Project Estimation and Fund allocation for the team members

Managed team schedules, milestones, and deliverables using internal tools for all technical issues related to scripting and configuration

Designed and Developed Load Runner scripts based on the most performance centric workflows

Tracked daily progress and reported any issues and proposed resolutions

Created Executive summary reports for project stake holders

Participated in Performance Tuning Analysis with Engineering team

Performance Monitoring using CA Wily Introscope, Dynatrace, HP SiteScope, Splunk tools

Reviewed Oracle AWR reports and discussed performance tuning with DBA's

Tools

Load Runner, Rational Performance Tester, HP Quality Centre Oracle 10G, SSH Tectia Client

Project Title # 6

Rational Rollout – Bank of America, USA

Role

Performance Engineer

Duration

Jan 2008 – Apr 2009

Description

Rational Roll out effort consists of conducting Research and Proof of Concept on Rational 2007 Tools such as RFT, RPT, RST and Rational Clear Quest. IBM Signed off on the Proof of Concept conducted. All Automation, Performance and SOA Assets were converted from HP Mercury to Rational tool set.

Responsibilities

Building out the Rational Test Environment

Proof Of Concept and Sign Off on Rational Tool Set

Design and analysis Automation and Performance Use Cases

Reviewing the Automation and Performance Use Cases with the Project Stake Holders

Developing Automation and Performance Scripts using Rational Tool Set

Reviewing the Automation and Performance Scripts with the Project Stake Holders

Executing the Automation and Performance Scripts and sharing the test Results with Project Stake Holders

Tools

HP Load Runner, Rational Performance Tester, Rational Services Tester, Rational Clear Quest, HP Quality Center

Project Title # 7

1. UB Profitability Consolidation

2. LaSalle Bank Conversion / Bank of America, USA

Role

ETL Test Engineer

Duration

Oct 2006 – Jan 2008

Description

BOA acquisition of La Salle bank there is a need to migrate relevant La Salle Clients and Prospects to the existing CED database. Conversion of all required data elements will Provide foundation for the conversion from the La Salle tool suite to the CRMS CIBR tool suite and support other CRMS efforts and applications. LaSalle Client data are extracted from MS Access Data base as a Tilde-Delimited Text File and are loaded into staging table. Only success and Exception records are moved to CED and all the result actions should have an entry in result table. We have migrated the Client MI data, Market Manager Data, Sales Logic data, Guarantor data, and Eagle Leasing data during this project.

UB Profitability Consolidation and its primary purpose is to provide a single source of profitability data to Commercial and GCIB profitability tools in Universal Bank. To implement these changes, work effort will be broken up into various work packets. Each work pacts are spited up based on the financial data and Account details; PDB and PRF tables are implemented to consolidate the profitability data and moved into ACCUMULATOR tables.

Responsibilities

Analysis and Understanding of the design documents HLD, LLD and mapping documents

Preparation of test cases using Oracle SQL queries

Executing the SQL Test cases to validate Data Integrity and data consistency

Executing the SQL Test cases to validate the transformation logics

Executing the SQL Test cases to verify the records migrated accurately

Logging the defects in Quality Center and publish status reports

Tools

Oracle 10g, Teradata, PL SQL Developer, HP Quality Center

PERSONAL DETAILS

Sex

Male

Nationality

Indian

Marital Status

Married

Current Location

New Jersey, USA

Contact Number

+1-201-***-****

Visa

H1B, I-140 Approved – Priority Date Apr-2018

Contact this candidate