Test Automation Etl Testing

TS.Prasad

Phone #: +1-214*******

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

https://www.linkedin.com/in/prasad-reddy-sdet/mailto:**********@*****.***

Professional Summary

Seasoned Automation Expert with 14+ years of experience in building cutting edge testing solutions.

Worked in different domains such as Banking, Leases and Loans, Insurance, Background Verification.

Having good Experience on BDD Framework and Page Object Model (TDD).

Designed and Implemented Selenium (Java) Modular and Keyword Driven Framework.

Having good Experience in API Testing by using RestAssured.

Expert in using OOPs in Automation Frameworks Implementation.

Implemented Parallel Execution Using Docker Container.

Certified professional in HP Quality center and Quick Test Professional(UFT).

Experience with Software Development Processes and Models like Agile and V Model

Experience in performing Functional, Regression and Automation testing.

Expertise in implementing data driven, hybrid and BPT automation framework for regression and functional testing.

Having good experience in ETL testing and Tableau Dashboard Validation.

Proven track record in creating strategy, Proof of Concept of the architecture, building and managing Test Automation Projects.

Having good experience in writing Test Automation Strategy and Plan.

Having good experience in Agile (Scrum and Kanban system).

Experience in using Test Management tools, Defect Tracking Tools and Configuration Management Tool JIRA and HP-ALM

Participated in all Testing life cycle activities such as Test plan preparation, Test case preparation, Test Execution, Test Report preparation and Defect Tracking.

Have got good experience in managing team and Delegating tasks.

Proven ability to work independently, in a team environment, and in fast-paced environments.

Quick learner, exceptional problem-solving and troubleshooting capabilities.

Excellent Team player with good Communication and Interpersonal skills.

Ability to deal efficiently with escalations and difficult situations/people under pressure.

Technical Skills

Testing Tools

Selenium,TestNg, Cucumber(BDD),API Testing with RestAssured, PostMan,Insomnia,QTP9.2,9.5…UFT14.50, QC, JIRA, Test Link, ALM,QTest,Docker.

RDBMS

SQL Server,ORACLE, MongoDB,Postgre,DynamoDB

Cloud Technologies

AWS-EC2, S3 bucket and Lambda

Languages

Java, C,VB scripting, Java Scripting

Operating Systems

Windows 2000,Win10,XP,UNIX

Web Technologies

HTML,XML

CI/CM Tools

Bamboo, Jenkins,Eco-System, Git and Github,Maven,Perforce

Others

In house trainings on Selenium and Framework Usage.Kafka,RabbitMQ,Github copilot

project experience

Project #1

Title: Broker-Dealer Replatform(Wealth Management) Jun 2024 to till date

Client: US Bank, Irving, TX

Company: Synechron

Role: Lead Automation QA Engineer (SDET)/Test Architect

Project Description:

Broker-Dealer Replatform is an extension of Fidelity’s Wealthscape Application, designed to streamline and modernize the brokerage account onboarding process for both individual and business users. The application facilitates seamless onboarding by initiating KYC checks and pre-filling customer financial and suitability information retrieved from Wealthscape.

Key processes include initiating an e-Signature request via e-Signature Ceremony, ensuring secure and compliant signature collection. Upon successful onboarding, the platform captures and transfers customer audit data to FileNet for long-term archival and regulatory compliance.

Roles and Responsibilities:

•Work on Agile Methodology and active participation in daily stand-up meetings, Iteration planning, Retrospections, Defect Triage Meetings and accountable for functional, automation deliverables and any applicable enhancements.

•Designed and Implemented Page object model Framework with Cucumber and Selenium WebDriver and TestNg for UI Automation with JAVA.

•Performed BDD (Behavior Driven Development) using Cucumber Features, Scenarios and Step Definitions.

•Interpret application architecture and identify areas for automation to improve efficiency and coverage.

•Developed an API Automation Framework Using RestAssured with JAVA.

•Automated End to End Scenarios Covering different HTTP Methods (GET, POST, PUT, and DELETE).

•Used Swagger to get REST API Specification and Documentation.

•Enhanced BDD Cucumber framework, by creating reusable functions library and utilities

•Involved in identifying the Regression and Smoke tests.

•Creating Automation Test Approach and Test Plan.

•Used Selenium WebDriver to perform cross-platform, cross-browser testing, launched the tests from hub and executed the tests on the nodes.

•Used Postman/Insomnia for API Testing

•Involved in the review of the automated scripts and Merge into final branch.

•Wrote SQL quires and validated data in the backend and performed database testing.

•Integrate Test Automation into CI/CD pipelines using Jenkins, GitHub Actions.

•Identifying key AWS services used in the application (e.g., EC2, S3, Lambda) to design appropriate test cases.

•Ensure that test automation runs as part of the build and release pipelines in Azure DevOps

•Collaborate with developers, product owners, and DevOps engineers to define quality goals.

•Defined and implemented a comprehensive testing strategy aligned with product and release goals.

•Established quality gates and exit criteria for different test phases (Smoke, integration, E2E, regression).

•Defined and tracked KPIs such as defect leakage, automation coverage, test execution rate

•Set up dashboards for real-time visibility into test and release health using tools like Jira

•Defect Analysis and Continuous Improvement.

•Drove test data management and environment stability initiatives to reduce test failures due to infra issues.

•Facilitated test planning and risk analysis workshops during sprint and release planning.

•Ported the automation regression suite to the UAT environment by implementing a new strategy to maintain test data consistency between IT and UAT environments.

•Worked closely with Business/Product Stakeholders to Prioritize the QA Activities.

•Manage onsite/offshore teams, providing guidance and mentoring on test design and execution.

•Presented demos to the business team upon QA Signoff stories

PROJECT# 2: Feb 2020 - May 2024

Project Title: New Platform

Client: Accurate US,Irvine,CA

Company: Encora Innovation Labs

Role: Lead QA Automation Engineer

Project Description:

New Plat form Application is developed by Accurate Company which is a pioneer in back ground checking of various components such as Employment, Education, Driving License, Drug etc. The data can be mainly filled by Recruiter which is called as 1-Pass orders creation and if the Candidate himself fills the data, then it is called as 2-Pass order.

Responsibilities:

•Automation feasibility analysis.

•Proof of Concept in the early phase to see if that project was a good piece for automation.

•Interpret application architecture and identify areas for automation.

•Framework designing and planning of Selenium using Java.

•Created Selenium Grid for Parallel Execution.

•Involved in identifying the Regression and Smoke tests.

•Creating Automation Test Approach and Test Plan.

•Created Framework for RestAssured API Testing.

•Implemented Page object model Framework by using Cucumber.

•Creating reusable functions library and utilities.

•Involved in the review of the automated script.

•Used extensively AWS Cloud technologies (S3 Bucket, Lambda,EC2 and DynamoDB)

•Performed ETL testing.

•Performed Database testing using SQL.

•Performed ETL Job monitoring and subscription delivery monitoring.

•Designed and Validated Dashboards using Tabelau.

•Validated Business Intelligence Reports based on the customer need by triggering the ETLs.

•Used ALM as Test Management tool, to track all the Testing activities.

•Defining priorities, and delegating tasks.

•Actively Participating in SOS and updating the Automation impediments on various releases.

•Actively participated in Release cycle and done PDV’s on PROD env.

•Worked Closely with PO to define automation Priorities.

•Assist the Testing Team with on-going automated test execution.

•User guide creation script execution and maintenance.

•Created various QA metrics to measure the Testing Efforts.

•Work with management and quality assurance personnel to meet automation goals.

•Present automation plan and future efforts to management.

•Trained functional testers on Automation and Mentorship and training of new team members.

ROJECT# 3: Nov 2012 - Jan 2020

Title: Info Lease

Client: Solifi,Minneapols,MN

Company: Solifi

Role: Sr. QA Automation Engineer

Project Description:

The asset finance industry with millions of assets and financed goods dependent on its reliability and flexibility with accuracy and stability at its core, Info Lease provides an amazing range of capabilities. Info Lease delivers sound leasing operations, rich functionality for loans and robust reporting which are all scalable to the needs of your organization including regulatory compliance.

A wealth of proven Info Lease modules for adding new functionality to your system including Loans, Floating Rate and Revolving Accounts, Support for international currencies and tax structures, Use of Open Database Compliant (ODBC) Relational Database Management System (RDBMS).

Responsibilities:

•Interpret application architectures and identify areas for automation.

•Designed and implemented Page Object Model and Keyword Driven Framework with Selenium - Java.

•Created Selenium Grid for Parallel Execution.

•Created Functions to Upload files to Server and verify the same in selenium

•Involved in identifying the regression tests

•Worked Exclusively on Payments Module(Wire,ACH,DD)

•Creating Automation Test Approach and Test Plan

•Created Framework for RestAssured API Testing

•Creating reusable functions library and utilities

•Involved in the review of the automated script

•Defining priorities, and delegating tasks

•Performed Database testing using SQL and ORACLE.

•Assist the Testing Team with on-going automated test execution

•User guide creation script execution and maintenance.

•Presentation of script execution and test data maintenance to the end users.

•Present automation plan and future efforts to management.

ROJECT# 4: Dec 2008 - Oct 2011

Title: Rapport

Client: Solifi, Minneapolis,MN

Company: Solifi

Role: QA Engineer

Project Description:

Rapport is user friendly product developed for Equipment leasing and Loans. Rapport is a web based front end application which is highly configurable. The Product follows the workflow defined as application submission for leasing, Approval, Contract Set-up, Booking a contract. All these workflow is controlled by Universal Admin which is used for setting user defined access level. The product is most complex which is tested with two different backend. Rapport helps user to submit credit applications via the web and then book them as contracts into a back-end lease/loan system. Rapport will work with two backend IDS product called Profinia and Info Lease.

Responsibilities:

•Test Requirements Study and prepare the ambiguity sheet.

•Preparing the Base line Document for Automation

•Involved in Designing and Implementation of Framework by using UFT

•Writing the Scripts for the Framework

•Peer Review of the scripts

•Creating Test Environment for Automation Scripts Execution

•Executing the Smoke and Regression Scripts during the Main and patch releases.

•Reporting the defects through ALM

•Publishing the Smoke and Regression Results on each build to different versions

Education

Master of Science from S.V. University, with 73% Tirupathi. In April 2004

Bachelor of computer Science from S.V. University, with 83% Tirupathi. In April 2002

Contact this candidate