Yokeshwaran Ramachandran

Client: BancTec, Pay Courier

Domain: Banking

Description: The company provides document and content processing, payment processing and IT service management solutions

for clients in the financial services, manufacturing, government services and utilities industries.

Roles and Responsibilities:

• Participating in walkthrough and handover sessions
• Involving in planning and Estimation of tasks for user stories
• Executing Test Cases, track and escalate issues using JIRA.
• Perform Regression Testing every time when changes made are made to the code to fix the defects
• Participating in Test Summary/Closure Reports.
• Communicated with onshore team to discuss changes and clarification.

Product: Paperless Validation Lifecycle Management

Domain: Life science

Description : It is the most prominent company in the world provide a paperless validation solution in the field of life sciences, company has more than 70 clients around the globe with headquarters in South San Francisco, CA

Roles and Responsibilities:

• Automated API scenarios using framework as Test NG and POM model for the Valgenesis application.
• Implemented the Excel Input sheet Test Data for the Automation. Sharing final reports of automation output to clients.
• Complete understanding of the framework that was used.
• Involved in creating reusable components of automation. Experienced in ETL testing .
• Experienced in mobile application Testing.
• Track and escalate issues using TFS.
• Experience on API testing using Postman.

Project 1: Lumen Technologies, Inc.

Project Duration: Jan 2022 – Mar 2023

• Led a 3-person team in the DCO application at Lumen Technologies, Inc., serving as backend testers for upstream and downstream systems.
• Participated in ETL and API automation testing using Talend and Rest API services.
• Automated SQL scripts using cucumber with core Java for testing. Developed simple automation ETL jobs in Talend ETL tool.
• Verified server logs in Splunk and WinSCP servers. Completed 60% of automation for server logs and SFTP server for sanity and regression testing.
• Developed an automated Jenkins job for daily sanity checks in production and QA environment, based on the sanity automation framework from GIT.
• Utilized AccelQ Cloud automation tool for codeless automation of APIs.
• Resulted in a 60% reduction in testing effort after implementing Talend ETL automation job and automating SQL scripts using cucumber with core Java.

Project 2: Bath & Body Works, Inc.

Project Duration: Mar 2023 – Jan 2025

• Led a 5-person team for migration development from Mule to Talend ETL ESB application.
• Developed various interfaces with REST API, Kafka, SOAP UI, Salesforce, SAP, Ariba API.
• Involved in various database ETL development with SQL queries using Oracle, My SQL, Postgres SQL.
• Involved in coding language using core java.
• Involved in automated email template creation using HTML coding technique.
• Involved in deployment of jobs to TMC to DEV environment and promoting code into QA.
• Participated in creating Log4j settings and remote engines in TMC.
• Configured databases in TMC for deployment activities and also maintaining code in Bit Bucket.
• Suggested a testing technique to client by developing a automation framework in Talend tool to reduce manual testing error and got a client appreciation for the same.

Project 2: CommonWealth Care Alliance, Inc.

Project Duration: Nov 2024 – Present

• It is a migration project where we are migrating the talend which is pointing to teradata to be moved to Azure SQL Server.
• Since they are using Cloud Data Fabric so as per client requirements we used PySpark code to read the file and load into Azure server using DataBricks.