Test Automation Software Development

Shwetha Nallavelly

***************@*****.***

770-***-****, LinkedIn: https://www.linkedin.com/in/shwetha-nallavelly-625157181/

Work experience Summary:

Over 13 years of diversified experience in Software Development Engineer in Test with skills in Test Automation/ Performance/manual/ functional testing of client-server, web-based distributed and Data warehouse systems. Experienced in ESB, Middleware with EMS and MQ systems in various domains like Financial, Health care, Insurance, Utility and Telecom. Primary skills in Java/unix Test Automation. Experience in design and implementing different automation frameworks from starch like Hybrid framework, Keyword Driven, Page Object and Data Driven frameworks for a number of projects. Experience in web applications testing with Selenium IDE and Selenium WebDriver, JUnit, TestNG and Log4j. Solid Hands-on Experience in writing test cases and writing feature files in Gherkin language using Cucumber tool. Hands-on experience in testing SOAP & Restful web services using SOAP UI.

Professional summary:

●13 years of testing experience in Information Technology with emphasis on Quality Assurance with Manual Testing and Automation Testing on Healthcare, Media and Insurance domain.

●Involved in designing and developing strategic Test plans, Test Cases, Test Scripts, Test Scenarios, Test Reports for manual and automated test cases.

●Experience of working as a part of Scrum team and contributed in backlogs and Sprint planning sessions following Agile SDLC methodology.

●Experience in preparing the monthly and weekly status reports to the clients and project office.

●Good Exposure to all stages of Software Development Life Cycle (SDLC), Software Testing life cycle (STLC) and Bug Life cycle.

●Experience in TDD (Test-Driven Development) to write automated tests before writing code, ensuring each piece of functionality works as designed.

●Participated in developing Regression scripts.

●Worked in an agile development environment with frequently changing requirements and features.

●Helped product owners with user stories creation. Attended the Daily Standup meetings and updated the JIRA items status for all components.

●Experience in leading, designing and implementing various web-based enterprise applications and middleware solutions in AWS and on-premise Test automation in JAVA.

●Conducting JIRA meetings with Business /Developers for testing prior to each release.

●Strong AWS product knowledge, understanding of product features, design and hands on the native services using AWS SDK 1.0 and 2.0.

●Experience in BDD (Behavior-Driven Development), focusing on defining system behavior from a user perspective, promoting collaboration between developers, testers, and stakeholders to ensure the software meets expected functionalities through detailed user stories and acceptance criteria in JIRA.

●Witten and mentored a team in writing test cases and scripting them. Cucumber framework used to write gherkins for automation scripts.

●Prepared the Features File having the test scenarios, Created Step Definition and Runner class. Used Scenario outline for passing multiple values and Regular Expressions.

● Automation tool and scripting experience for both front end and APIs (Selenium Web driver, C#, Java, JavaScript, Visual Studio, VSTS Coded UI, Cucumber, MS Test, Python and JMeter).

●Developed test Automation Scripts in java/J2EE using eclipse tool, maven to create the java project structure and JENKINS for CI/CD builds. Used cucumber-JVM html reports to generate test reports in CI/CD.

●Performed Manual and automation regression test during hardening sprint. Communicated testing issues with the Scrum team.

●Strong Q/A & Automation Testing/engineering experience in diverse industries.

●Experienced in various domains Banking/Financial/Insurance/Healthcare and Utility.

●Experienced in Java/J2EE, UNIX/Shell Scripting, REST/Web services protocols.

●Experience with API concepts and technologies such as REST, JSON, XML, SOAP, YAML, GraphQL, and Swagger.

●Experience with GraphQL in scenarios requiring flexible, client-specific queries and real-time data and testing web APIs.

●Experience in writing Automation scripts to make requests to fetch data from multiple data sources with a single API call using GraphQL.

●Familiarity with NoSQL databases and their integration with financial systems.

●Understanding of NoSQL database principles and concepts and testing them.

●Experience in MongoDB testing where simultaneously query data from multiple MongoDB instances are fetched. Understanding of NoSQL database that stores data in a flexible, JSON-like format called BSON.

●Wrote Rules for Complex script involving 100’s of dynamic values for regression.

●Excellent verbal & written Communication skills. Meet all requirements in your job requisition.

●Testing experience in cloud environment (AWS s3)

●Experience in automation AWS services such as Lambda, RDS, Redshift, EC2, EMR.

●Experience in event-driven/micro webservice in the AWS cloud

●Design, develop and execute automation script in python using PySpark.

●Familiarity with DBT (Data Build Tool) or similar data transformation tools is a plus.

●Good exposure to all the Oracle concepts as Joins, Views, Indexes, Partitioning, PL/SQL.

●Expert in retrieving database information, writing SQL Queries and transforming data to information as needed.

●Performed extensive Backend Testing of the applications using PL/SQL Queries.

●Good understanding and exposure of Core Java concepts such as Abstraction, Encapsulation, Inheritance, Polymorphism, Collections, JDBC (Java Data Base Connectivity) Programming and Interfaces.

●Knowledge in developing end to end automation using Selenium Web Driver/RC/IDE/Grid, TestNG, Jenkins.

●Extensive experience in white box testing, Black box testing Functional, Integration, Unit, API, Regression, User Acceptance (UAT) and System Testing.

●Knowledge in mobile apps test automation, verifying functionality across different devices and operating systems without manual intervention, ensuring quality and consistency throughout the development cycle.

●Good Knowledge on using web technologies like JavaScript, HTML& CSS.

●Strong at bug-reporting, bug-tracking and change management using Test Management tools like Quality Center.

●Extensive experience in testing applications implemented in JavaScript, XML, HTML, SQL Server and Oracle.

●Strong Knowledge in UI testing which used JSP, HTML, CSS, Ajax, XML.

●Experience in testing and automating the Rest service API’s test using Typescript and Playwright.

●Strong Knowledge of web service like WSDL Soap, Restful webservices.

●Experience in Understanding the code written in different programming languages Java, HTML, JavaScript and CSS, SQL, and Oracle.

●Experienced using Web-debugging tool like Fire Path and Firebug for finding elements locator.

●Experience in API testing using Postman for manual testing and Playwright for automating both API and UI.

● In-depth knowledge of the WebdriverIO framework, including its API, configuration options, and best practices.

● Strong proficiency in JavaScript for WebdriverIO and weservice/UI test automation.

●Proficiency and experience in programming languages JavaScript and Python.

●Familiarity with AEM architecture, including Sling, JCR, and OSGi frameworks.

●Experience testing AEM integrations with third-party systems (e.g., analytics, marketing platforms).

●Experience with cloud-based AEM implementations (Adobe Experience Cloud).

●Validate AEM templates, components, and workflows for functionality, scalability, and performance.

●Perform end-to-end testing, including APIs, front-end, and back-end systems integrated with AEM.

●Collaborate with developers to implement best practices for testability in AEM applications.

●Hands on Experience on Project management system like VersionOne.

●Excellent Communication skills, Team Participation skills, Leadership qualities, Analytical skills and Problem-Solving skills Good communication and presentation skills with ability to communicate at all levels.

●Quick Learner and interested to learn new technologies.

Technical summary:

Testing Tools

Cucumber, HP Application Lifecycle Management/ Quality Center, Selenium WebDriver/IDE, JIRA, SOAP

UI, Jmeter, Eclipse, JUnit, TestNG, IntelliJ, Apache POI, My SQL, SQL Developer, MS Office, Excel IBM Rational tools.

Build Tools

Maven, Jenkins, SVN, GIT.

Databases

Oracle 9i/10g/11g, DB2, Mongo DB, Teradata, Sybase, MS SQL Server, MS Access, IBM DB2 UDB7.0, Informix

Languages

C, CPP, Java, HTML, J2EE, JSP 1.1, Spring MVC, ASP, JavaScript, Java protocol (java RMI), Servlets, Python, PySpark, AWS S3, AWS Services, RedShift, kafka, SQL, PL/SQL, T-SQL, XML, HTML, XHTML, Shell Scripting, PERL, Java Script, SOAP UI, Restful and VB Script.

Web/Application Servers:

IBM Web Sphere, BEA Web Logic, Apache and Microsoft IIS, & EJB.

Bug Tracking/ Automation tools

HP ALM, Jira, Version one, TFS, Test Director 6/7.5/8.0, HP Quality Center and Clear Quest. Auto it, Worksoft Certify, HP QTP.

Testing types

Automation, Manual, Functional, Integration, Regression, system, Performance, unit testing’s

Test Techniques

and

Methodologies

Database Testing, Manual Testing and Automated Testing, Black Box Testing, Gray Box Testing and White Box Testing, Waterfall, Agile, Scrum.

Operating systems

Windows10, Windows 7, Vista, XP/2000/98/NT/95, UNIX and LINUX, AIX, Sun Solaris OS.

Work experience:

Fannie Mae, Reston, VA March 22 – Dec 2024 AWS SDET Project: Application Program Interface Ecosystem (BusinessGateway-B2B)

Project Description: Business Gateway applications in AIE are used to transfer the business-related files using SFTP, HTTP and ESB protocols in AWS cloud. Process requests and formulates responses; also publishes technical exceptions. Reads and writes the messages. Realizes the various communication channels and actuates the various transport channels spanning between Fannie Mae and the Clients. Manages the file transfer and persists the necessary run time activity information.

Responsibilities:

●Worked in an agile development environment with frequently changing requirements and features.

●Helped product owners with user stories creation.

● Attended the Daily Standup meetings and updated the JIRA items status for all components.

● Experience in leading, designing and implementing various web based enterprise applications and middleware solutions in AWS and on premise Test automation in JAVA.

● Conducting JIRA meetings with Business /Developers for testing prior to each release.

● Strong AWS product knowledge, understanding of product features, design and hands on the native services using AWS SDK 1.0 and 2.0.

● Witten and mentored a team in writing test cases and scripting them. Cucumber framework used to write gherkins for automation scripts.

● Prepared the Features File having the test scenarios, Created Step Definition and Runner class. Used Scenario outline for passing multiple values and Regular Expressions.

●Created Automation script using Robot Framework on Python for web based application.

●Created and maintain server-side integration tests - Python, JSON documents, Mongo DB, and Robot Framework CI/CD and code quality monitoring automation.

● Developed test Automation Scripts in java/J2EE using eclipse tool, maven to create the java project structure and JENKINS for CI/CD builds. Used cucumber-JVM html reports to generate test reports in CI/CD.

●Performed Database/Backend testing by writing complex SQL Queries for data validation and integrity, good at writing complex Joins and knowledge in PL/SQL.

●Designed selenium Python and Karate BDD framework for validating containerized web services (Rest API).

● Performed Manual and automation regression test during hardening sprint. Communicated testing issues with the Scrum team.

● Conducted walkthrough of test cases & test results with scrum team. Provided Sprint Demos to product owner and product manager.

● Created and Updated User Acceptance Test documentation. Participated Releases by maintaining Release Documentation, Release Calendar.

● Supported Business shakeout tasks for production Release. Prepared professional presentations for Corporate Projects.

Environment: Java, Python, Cucumber, JUnit, Html, Xml, JSON, JIRA, Eclipse Mars, ALM, Maven, Jenkins, putty, Unix, Oracle, WinSCP, SFTP, Internet Explorer, XML Formatter, Firefox, Chrome, Postman, HTTP Requester, SQL, Windows, Secure File Transfer Protocol (SFTP) · Agile Methodologies · Amazon Web Services (AWS) · AWS Lambda · AWS CloudFormation · AWS Identity and Access Management (AWS IAM) · AWS Command Line Interface (CLI) · Amazon S3 · Amazon Relational Database Service (RDS) ·

Fannie Mae, Reston, VA Jan’17 – March 22 Automation Quality Analyst

Project: Application Infrastructure Services (BusinessGateway-B2B)

Project Description: Business Gateway applications in AIS are used to transfer the business-related files using SFTP, HTTP and ESB protocols. Process requests and formulates responses; also publishes technical exceptions. Reads and writes the messages. Realizes the various communication channels and actuates the various transport channels spanning between Fannie Mae and the Clients. Manages the file transfer and persists the necessary run time activity information.

Responsibilities:

●Worked in an agile development environment with frequently changing requirements and features.

●Helped product owners with user stories creation. Attended the Daily Standup meetings and updated the JIRA items status for all components.

●Conducting JIRA meetings with Business /Developers for testing prior to each release.

● Witten and mentored a team in writing test cases and scripting them. Cucumber framework used to write gherkins for automation scripts.

●Prepared the Features File having the test scenarios, Created Step Definition and Runner class. Used Scenario outline for passing multiple values and Regular Expressions.

●Developed test Automation Scripts in java/J2EE using eclipse tool, maven to create the java project structure and JENKINS for CI/CD builds. Used cucumber-JVM html reports to generate test reports in CI/CD.

●Developed reusable methods and POJOs used Jaywayassured and Httprequester to write SOAP and REST requests.

●Developed Python customer library for automation needs.

●Strong Knowledge in UI testing which used JSP, HTML, CSS, Ajax, XML.

●Experience in testing and automating the Rest service API’s test using Typescript and Playwright.

●Strong Knowledge of web service like WSDL Soap, Restful webservices.

●Closely worked with Developers testing components in Dev. Env, Integration of the components in SIT and raising Story Defects for the user story identified and collaborating with Dev. to provide Bug free features.

●Created Python virtual environments and creating package library for Robot Framework.

●Also performed In-Sprint over-Sprint regression, Subset of Overall Regression Suite apart from Component and Integration Testing leveraging UI automation and API Automation.

●In-depth knowledge of the WebdriverIO framework, including its API, configuration options, and best practices.

●Strong proficiency in JavaScript for WebdriverIO and weservice/UI test automation..

●Responsible for executions of Change requests from Python bindings to Java Bindings in Selenium WebDriver.

●Experience testing AEM integrations with third-party systems (e.g., analytics, marketing platforms).

●Experience with cloud-based AEM implementations (Adobe Experience Cloud).

●Validate AEM templates, components, and workflows for functionality, scalability, and performance.

●Perform end-to-end testing, including APIs, front-end, and back-end systems integrated with AEM.

●Collaborate with developers to implement best practices for testability in AEM applications.

●Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL Server.

●Worked and collaborated with the App Developers to improve the labeling of the UI Elements to better facilitate the automation of the App.

●Involved in handling the files and integrating the results with the UI using Python scripts.

●Performed Manual and automation regression test during hardening sprint. Communicated testing issues with the Scrum team.

●Experience with API concepts and technologies such as REST, JSON, XML, SOAP, YAML, GraphQL, and Swagger.

●Experience with GraphQL in scenarios requiring flexible, client-specific queries and real-time data and testing web APIs.

●Experience in writing Automation scripts to make requests to fetch data from multiple data sources with a single API call using GraphQL.

●Familiarity with NoSQL databases and their integration with financial systems.

●Understanding of NoSQL database principles and concepts and testing them.

●Experience in MongoDB testing where simultaneously query data from multiple MongoDB instances are fetched. Understanding of NoSQL database that stores data in a flexible, JSON-like format called BSON.

●Created/updated Agile testing document. Updated the share point/Confluence pages with the updated test results and shared to all users. Updated the Requirement Traceability Matrix (RTM), with Test Case id.

●Good knowledge of Back-End Testing, applying JAVA JDBC library and writing complex joining SQL Queries to perform Database and Back-End Testing.

●Created and Updated User Acceptance Test documentation. Participated Releases by maintaining Release Documentation, Release Calendar.

●Supported Business shakeout tasks for production Release. Prepared professional presentations for Corporate Projects

Environment: Java, Python, Cucumber, JUnit, TestNG, Html, Xml, JSON, JIRA, Eclipse Mars, ALM, Maven, Jenkins, Tibco Designer, GEMS, EMS Administration tool, Smart bear, Tibco Admin tool, putty, Unix, Oracle, Toad, SharePoint, WinSCP, SFTP, Internet Explorer, XML Formatter, Firefox, Chrome, Postman, HTTP Requester, SQL, Windows.

Fannie Mae, Reston, VA Jun’16 – Dec’17 Automation Quality Analyst

Project: Application Infrastructure Services (ESB-SOA)

Project Description: AIS used ESB clients. ESB clients need to be able to reliably and independently regenerate and replay a message. The Event service admin is diagnostic and utility software which provides the capability to examine the content of a message and replay one or more messages. Security Service provides an ability to have controlled access to view and replay messages. The messages logged onto the event service follow ESB API standard format.

Responsibilities:

●Followed Agile sprint methodologies for Development.

● Coordinated with business teams to clarify requirements and business needs.

●Helped product owners with user stories creation. Attended the Daily Standup meetings and updated the JIRA items status for all components.

●Conducting JIRA meetings with Business /Developers for testing prior to each release.

● Witten and mentored a team in writing test cases and scripting them. Cucumber/Selenium framework used to write gherkins for automation scripts.

●Used cucumber to write gherkins.

●Developed test Automation Scripts in java/J2EE using eclipse tool, maven to create the java project structure and JENKINS for CI/CD builds. Used cucumber-JVM html reports to generate test reports in CI/CD.

●Used GIT and version control Management.

●Intense experience in Unix/linux environment.

●Performed Manual and automation regression test.

●Logged and reported defects in ALM and JIRA.

Environment: Java, Cucumber, JUnit, TestNG, Html, Xml, JSON, JIRA, Eclipse Mars, ALM, Maven, Jenkins, Tibco Designer, GEMS, EMS Administration tool, Smart bear, Tibco Admin tool, putty, Unix, Oracle, Toad, SharePoint, WinSCP, SFTP, Internet Explorer, XML Formatter, Firefox, Chrome, Postman, HTTP Requester, SQL, Windows.

Tata Consultancy Services, India Jun’10 – March’14 Software Engineer – Java/J2EE

Project: Operation/Project Portal

Project Description: The Operation Portal mainly focuses on the reconstructions and development activities related to the projects going to be developed by the Organization team. It is an integrated workspace for managing project documentation and processing. It introduces online project processing templates, and built-in clearance and disclosure processes. An advanced collaboration space helps task teams manage project tasks more effectively.

Responsibilities:

●Involved in capturing the business requirements, design, development and testing of the application.

●Developed the implementation for the methods which are given in the form of abstract methods.

● Developed application with Object Oriented Perspective.

●Implemented Java and Design patterns like Factory, Abstract factory, Singleton, Iterator patterns.

●Implemented and handled exceptions with customized exception handlings.

●Established JDBC connections to perform backend SQL validations.

●Performed Unit testing in Junit.

●Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment.

●Used Quality Center to manage and organize STLC activities like Requirements coverage, Test Case Management, Test Execution Reporting, Defect Management, and Test Automation.

●Review system specifications for design functionality and user documentation ensuring functionality coordinates with user instructions.

●Participated in reviewing the Test Plans and Test Case Templates for the GUI and functional testing.

●Worked with Microsoft Visio in creating flowcharts for various modules for better understanding of the system.

●Performed UAT testing with various test data set up and with multiple roles to meet UAT requirements.

●Helped in creating Requirement Traceability Matrix (RTM) to analyze changes and identify the areas of application for Regression Testing.

●Used SQL queries, to extract the data from the database using SQL developer. Environment: Java, J2EE, JUnit, Quality Center/ALM, JIRA, Internet Explorer, Firefox, Chrome, SQL, Windows, MS Visio, C, C++, Shell script, Unix, Oracle, Share Point, XML/JSON, GCC, HTML.

Education:

● Bachelors in Information Technology, JNTU, Hyderabad, India -2010

Contact this candidate