Naresh Paladugu
QA Automation Engineer
Chicago,IL
Summary
With over 13 years of IT experience, successfully managing, analyzing, automating, and implementing Business Intelligence solutions in the Finance, Banking, and Retail domains. Expertise in data warehouse management with extensive experience in automation using Selenium, API, SQL, Java, and Python. Automation Lead for over 10 years, effectively assigning tasks to offshore teams. Possessing 7 years of hands-on experience with NOSQL MONGO Database and conducting thorough data validation testing using Java Automation. Proficient in Playwright with Typescript for over 3 years. Leveraging Python programming skills to analyze large datasets and uncover valuable insights for business decisions. Passionate about utilizing data to solve complex business problems and enhance organizational efficiency. Agile leader in systems automation, fostering a team-oriented mindset and collaborating with staff from all departments to streamline productivity through technology-based solutions. Flexible approach consistently producing effective code tailored to meet organizational needs. Strong foundation in technical process automation positions as an authority on evolving solutions for uncharted problems.
Overview
15
15
years of professional experience
6
6
years of post-secondary education
Work History
ETL/Automation Engineer
Aetna Resources LLC (a CVS Health Company)
Chicago, Illinois
07.2017 - Current
- Managed documentation efforts related to the design, installation, and operation of automated systems, ensuring accurate records were maintained for future reference.
- Participated in root cause analysis efforts to resolve complex issues related to automated equipment performance.
- Completed automation of functional and regression testing.
- Served as the primary point of contact for all inquiries related to automation equipment performance, troubleshooting issues as they arose and implementing corrective actions when necessary.
- Participate in Analysis of Business and Functional requirements, Reviewing and Understanding the product specification document.
- Excellent multi-tasking skill with experience in working under multi-vendor environment
- Excellent quality and release management skills.
- Strong communications skills to interact with development, DevOps and Senior management.
- Proven experience with full-stack testing – unit testing, API & UI testing, non-functional testing.
- Strong experience in Unit testing, developing multi-threaded applications in Java, and REST API.
- Stakeholder management skills requiring interaction and reporting to director/AVP levels in client organization.
- Created and executed test cases for both Backend and Frontend testing using Python, Java scripts.
- Conducted comprehensive data analysis using Python and SQL, uncovering insights that led to a reduction in operational costs.
- Contributing to team agile planning activities and backlog prioritization and management.
- Leading and mentoring a team of automation testers.
- Assigning tasks and reviewing test deliverables and guiding team members in automating best practices.
- Communicating test progress, results and issues effectively.
- Identified automation scenario from manual regression scripts.
- Prepared and Execution of test script using Selenium.
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured.
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment.
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process.
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG.
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation.
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle.
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution.
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load.
- Leading and mentoring a team of automation testers.
- Responsible for creating test scenarios for use stories using Python and selenium.
- Executed various SQL queries to validate data and use for data driven testing using ORACLE Sql.
- Creating Automation framework (POM)
- Creating the automation scripts using the keyword driven framework which has excel as input.
- Performed Black Box and Unit testing using Equivalence Partitioning analysis.
- Used Jira as Test Repository for Requirement stories and for posting defects.
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity.
- Created Automation test framework (Page Object Model)using Selenium WebDriver.
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
- Exported Test case Scripts in Eclipse IDE Added annotations to the test. (Selenium).
- Ran tests by using Selenium remote control in different browsers.
- Used Selenium GRID to execute test cases parallel on different target machines.
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems. (validation)
- Used TestNg to run test suite and Maven as build tool.
- Creation, modification, and Execution of automation script.
- Experience in implementing different automation development efforts in Agile/Scrum and Waterfall development environments.
- Involved in design and implementation of Selenium WebDriver Automation Framework for Smoke test and Regression test using TestNG.
- Developed and executed test scripts using Selenium WebDriver and TestNG, analyzed Test Results and created Defects.
- Automated regression test cases using Selenium IDE, WebDriver, Jenkins, and Maven.
- Designed and implemented end-to-end testing solutions using Playwright, focusing on UI testing, cross-browser compatibility, and performance validation for modern web applications.
- Developed automated test scripts using Playwright to perform functional, regression, and smoke testing across multiple browsers (Chromium, Firefox, and WebKit), ensuring high-quality releases.
- Integrated Playwright test scripts with Jenkins and GitLab for continuous integration and continuous testing, enhancing automated testing execution in the deployment pipeline.
- Utilized Playwright's capabilities for testing across different browser environments, ensuring consistency and reliability of web applications on Chromium, Firefox, and Safari.
- Configured parallel test execution with Playwright, significantly reducing the overall execution time and increasing test coverage.
- Developed and maintained Playwright test automation frameworks using the Playwright Test Runner, improving test organization and reporting capabilities.
- Combined Playwright for UI testing with API automation to ensure end-to-end validation, performing API calls to verify backend functionality and front-end behaviors in sync.
- Used Playwright to measure front-end performance metrics, such as page load times, time to first byte, and resource usage, to ensure web applications meet performance standards.
ETL /Automation Tester
Sears Holdings
03.2013 - 07.2017
- Prepared and Execution of test script using Selenium
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load
- Leading and mentoring a team of automation testers
- Responsible for creating test scenarios for use stories using Python and selenium
- Executed various SQL queries to validate data and use for data driven testing using ORACLE Sql
- Creating Automation framework (POM)
- Creating the automation scripts using the keyword driven framework which has excel as input
- Performed Black Box and Unit testing using Equivalence Partitioning analysis
- Used Jira as Test Repository for Requirement stories and for posting defects
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Ran tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Creation, modification, and Execution of automation script
- Experience in implementing different automation development efforts in Agile/Scrum and Waterfall development environments
- Involved in design and implementation of Selenium WebDriver Automation Framework for Smoke test and Regression test using TestNG
- Developed and executed test scripts using Selenium WebDriver and TestNG, analyzed Test Results and created Defects
- Automated regression test cases using Selenium IDE, WebDriver, Jenkins, and Maven
- Performed functional testing of enterprise Restful and SOAP Web Services using SoapUI
- Identified correct GUI elements using various Selenium Locators like ID, name, Link Text, Partial Link Text, XPath, and CSS in creating automation scripts
- Configured application framework using excel spreadsheets and processed the spreadsheets using Apache POI
- Performed Continuous Integration of code and scripts using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs
- Performed BDD (Behavioral Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkin format
- Tested the Mobile Application using Appium with Selenium WebDriver
- Created test cases and performed Database testing to check the data is being migrated properly
- Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from Oracle/SQL Server
- Created Maven project and configured dependencies using pom.xml
- Automated and scheduled Build using continuous integration tool Jenkins Server at periodic intervals
- Involved in Defects logging, tracking, and managing Defect Life Cycles using HP Quality Center and JIRA
- Experienced in leading offshore team and adjusts work assignments or schedules to meet changing work-related priorities or demands
- Experience in creating Test Plans, Test Scripts, Test Scenarios and Test Reports using High Level and Detailed Design
- Experience in creating Requirement Traceability Matrix (RTM), and QA metrics like, Test execution status, Defect report and Daily/Weekly Status Reports
- Consistently established and maintain solid rapport with QA, development, and business counterparts
- Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments
- Expertise in writing shell scripts and updating based on the requirement
- Created automation scripts for front end validations and helped in generating the reports for failures
- Worked on both Front-end automation and Back-end testing
- Involved in extensive DATA validation using DB2 and Teradata
- Parameterized the scripts to validate the different Data Fields
- Understanding business requirement
- Identifying the test scenario for test case preparation and preparing the test cases from the available document
- Updating framework functions when needed
- Developed the automation scripts
- Preparation and execution of test script using selenium
- Reviewing the test report and preparing Test Summary report
- Created the test data for validating the input using different technique
- Reviewing the test case and scenario
- Test case execution, and Bug reporting
- Responsible for issues tracking which are encountered during testing of various modules of the application/client
- Take Specification for Defect Reports and create those reports
- Working on ETL to verify the data between source and target on Netezza
- Executing the ETL test cases using the mapping document
- Executed SQL queries using SAS programming and validated the data
- Environment: Informatica, UNIX, Shell Scripting, Selenium, WebDriver, Xpath, TestNg, Json,API, Java, Rest Services, Netezza, Oracle, Redshift, DB2, Teradata,SAS,X-Ray, Postman,Jenkins
- Participate in Analysis of Business and Functional requirements, Reviewing and Understanding the product specification document
- Contributing to team agile planning activities and backlog prioritization and management
- Leading and mentoring a team of automation testers
- Assigning tasks and reviewing test deliverables and guiding team members in automating best practices
- Prepared and Execution of test script using Selenium
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load
- Leading and mentoring a team of automation testers
- Responsible for creating test scenarios for use stories using Python and selenium
- Communicating test progress, results and issues effectively
- Created and executed test cases for both Backend and Frontend testing
- Identified automation scenario from manual regression scripts
- Prepared and Execution of test script using Selenium
- Creating Automation framework (POM)
- Performed Black Box and Unit testing using Equivalence Partitioning analysis
- Responsible for creating test scenarios for use stories using Python and Selenium
- Used Jira as Test Repository for Requirement stories and for posting defects
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Run tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- Examine the results of test to pinpoint defects in the application
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Performed data driven using jxl
- Creation and modification of script
- Execution of automation script
- Expertise in writing shell scripts and updating based on the requirement
- Developed the Automation scripts for validating data from MONGODB(NoSQL)
- Validated Data from DB2 to Mongo Migration
- Created automation scripts for front end validations and helped in generating the reports for failures
- Worked on both Front-end automation and Back-end testing
- Wrote complex SQL queries for data validation for verifying the data in the Sears Site
- Involved in extensive DATA validation using SQL queries and back-end testing
- Parameterized the scripts to validate the different Data Fields
- Extracted data from DB2 tables and upload to Files
- Understanding business requirement
- Identifying the test scenario for test case preparation and preparing the test cases from the available document
- Updating framework functions when needed
- Developed the automation scripts
- Preparation and execution of test script using selenium
- Reviewing the test report and preparing Test Summary report
- Created the test data for validating the input using different technique
- Reviewing the test case and scenario
- Test case execution, and Bug reporting
- Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database
- Preparing Reports for management like Monthly status report, weekly status report, Patch status report
- Deployment of build/Release (Test environment setup)
- Involved in interacting with developer and user acceptance testing team to resolve the issue
- Perform Backend Testing including validations
- Maintaining and setting up test environments
- Working on automating test scripts using selenium
- Running test scripts to test Mongo db
- Validating the Mongo data using the rest service and comparing it with the Db2 data
- Testing the data using the response from Json
- Performed smoke testing, system testing, user acceptance testing, regression testing, and client updating testing
- Run Testing Scripts and capture testing results and making sure that the Site is good
- Responsible for issues tracking which are encountered during testing of various modules of the application/client
- Take Specification for Defect Reports and create those reports
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Ran tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Creation, modification, and Execution of automation script
- Experience in implementing different automation development efforts in Agile/Scrum and Waterfall development environments
- Involved in design and implementation of Selenium WebDriver Automation Framework for Smoke test and Regression test using TestNG
- Developed and executed test scripts using Selenium WebDriver and TestNG, analyzed Test Results and created Defects
- Automated regression test cases using Selenium IDE, WebDriver, Jenkins and Maven
- Performed functional testing of enterprise Restful and SOAP Web Services using SoapUI
- Performed API testing using postman
- Identified correct GUI elements using various Selenium Locators like ID, name, Link Text, Partial Link Text, XPath, and CSS in creating automation scripts
- Configured application framework using excel spreadsheets and processed the spreadsheets using Apache POI
- Performed Continuous Integration of code and scripts using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs
- Performed BDD (Behavioral Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkin format
- Tested the Mobile Application using Appium with Selenium WebDriver
- Created test cases and performed Database testing to check the data is being migrated properly
- Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from Oracle/SQL Server
- Used Datastage Director to run the jobs for QA testing
- Used Talend to run the jobs and compare the results from datastage
- Used heavy SQL queries to validate data between source and target
- Interacting with developers for the bug fixes and problem resolution
- Manually executing complex system and feature-based test plans
- Creating and tracking defects found during testing using a defect-tracking system (JIRA)
- Coordinated in meetings with Business, Project Managers, Technical Analysts and Developers
- Worked on Kafka and Storm which is Real time data processing technology
- Validated data which was loaded using Storm
- Environment: Data stage 8.x, Unix, Shell Scripting, Python,Db Visualizer, Db2, MySql, Talend, Mongo dB, Selenium, WebDriver, Xpath, TestNg, Json, Java, Rest Services, Hadoop, Mongo Chef, Kafka, Storm
ETL/Automation Tester
Citizens Bank
10.2012 - 02.2013
- Analyzed business requirements, system requirements, data mapping requirement specifications from detailed Business Requirement (DBR) documents and Detailed Technical Design (DTD) documents
- Participated in the Requirement understanding discussion with Business and IT teams
- Scheduling Requirement Clarification meeting with BA team
- Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts
- Participate in Analysis of Business and Functional requirements, Reviewing and Understanding the product specification document
- Contributing to team agile planning activities and backlog prioritization and management
- Leading and mentoring a team of automation testers
- Assigning tasks and reviewing test deliverables and guiding team members in automating best practices
- Prepared and Execution of test script using Selenium
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load
- Leading and mentoring a team of automation testers
- Responsible for creating test scenarios for use stories using Python and selenium
- Communicating test progress, results and issues effectively
- Created and executed test cases for both Backend and Frontend testing
- Identified automation scenario from manual regression scripts
- Prepared and Execution of test script using Selenium
- Creating Automation framework (POM)
- Performed Black Box and Unit testing using Equivalence Partitioning analysis
- Responsible for creating test scenarios for use stories using Python and Selenium
- Used Jira as Test Repository for Requirement stories and for posting defects
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Run tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- Examine the results of test to pinpoint defects in the application
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Performed data driven using jxl
- Creation and modification of script
- Involved in developing the Test Strategy, Test Plan documents for System/Integration Testing
- Prepared high level System Test Scenarios and Test Conditions for various functional segments
- Worked on the Test schedules, Test estimates for the Test Script development and execution
- Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center
- Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals
- Performed the access check for all the databases, tools, servers and interfaces as Entry criteria for the System Testing
- Created Requirement Traceability Matrix by mapping test cases to the requirements to address all key points of functionality
- Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing
- Wrote complex SQL queries between source and target for validating ETL jobs
- Tested complex ETL Informatica jobs based on Business requirements and Business rules to load data from source Mainframe files, Views, and Stored Procedures to target tables
- Involved in extensive data validation using SQL queries and back-end testing
- Tested Business Object Reports for prompts as well as for Data validation
- Experience in creating UNIX scripts for file transfer and file manipulation
- Provided the UAT and Production support for End-to-End Test Script execution and Defect retest
- Good experience in onsite model work
- Schedule and Co-ordinate testing tasks in QC
- Organize defect triage calls Development and Business team to resolve outstanding issues
- Responsible for creating the Traceability matrix and linking test scripts with requirements
- Responsible for sending Daily status Reports for SIT Execution to the team
- Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports
- Environment: Selenium, Java, selenium IDE, DataStage 8.x, Sql Server, IBM DB2, Quality Center (ALM), SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, VSAM Files, XML, Microsoft Access
Automation Tester
Sears Holdings
03.2011 - 09.2012
- Involved in Business analysis and requirements gathering for the Dynamic Pricing Portal and Pricing Hub Projects
- Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Jira based on the Business Requirements, Functional Requirements, Business Workflows
- Participate in Analysis of Business and Functional requirements, Reviewing and Understanding the product specification document
- Contributing to team agile planning activities and backlog prioritization and management
- Leading and mentoring a team of automation testers
- Assigning tasks and reviewing test deliverables and guiding team members in automating best practices
- Prepared and Execution of test script using Selenium
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load
- Leading and mentoring a team of automation testers
- Responsible for creating test scenarios for use stories using Python and selenium
- Communicating test progress, results and issues effectively
- Created and executed test cases for both Backend and Frontend testing
- Identified automation scenario from manual regression scripts
- Prepared and Execution of test script using Selenium
- Creating Automation framework (POM)
- Performed Black Box and Unit testing using Equivalence Partitioning analysis
- Responsible for creating test scenarios for use stories using Python and Selenium
- Used Jira as Test Repository for Requirement stories and for posting defects
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Run tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- Examine the results of test to pinpoint defects in the application
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Performed data driven using jxl
- Creation and modification of script
- Involved in the data validation of the Reports that were generated using Sql queries
- Developed automated test scripts for Functional, Regression testing using Selenium IDE
- Reviewed the Business Requirements to design the Test Plan
- Lead in developing an automated solution for Mobile Application Testing
- Performed Manual Testing on Mobile Application on different Mobile OS such as I-OS, Android and Windows
- Created detailed reports of the bugs and assigned the defects using the JIRA tool
- Involved in Design and Develop QA Automation Architecture
- Involved in performing End-User Testing
- Extensively used Data Tables and Test Parameters in the scripts
- Modified scripts manually by inserting the Parameters by using Selenium for testing the web browser
- Recorded the screen using Selenium and then automated the scripts for testing the Web browser
- Used to debug the errors using Selenium by using the set points wherever it is needed
- Cross browser testing is done in all the platforms using Selenium
- Used JIRA as a defect tracking tool for reporting all the bugs
- Automated the Microsoft Outlook to verify the email produce through automated scripts
- Participated in team Meetings to discuss the issues during the various stages of testing
- Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
- Performed unit testing, integrated testing, and validated results with Business Analyst and/or customer
- Managed multiple projects from different Line of Businesses
- Involved in Regression testing of the web sites (Dynamic Pricing Portal and Pricing Hub) for each deployment making sure that the test cases are passed
- Reviewed and approved database modifications
- Involved in Functional testing and making sure that the users were able to login to the website and get the required information based on the functional test cases
- Environment: Teradata, jira, UNIX, Db2, Sql Assistant, MySQL, Putty, SQL\PL-SQL, WebSphere, Selenium, Java, Selenium IDE
Automation Tester
Wells Fargo
01.2010 - 03.2011
- Preparation of Functional Automation and Manual test plan based on business Requirements
- Analyzed business requirements, system requirements, data mapping requirement specifications from Detailed Business Requirement (DBR) documents and Detailed Technical Design (DTD) documents
- Participate in Analysis of Business and Functional requirements, Reviewing and Understanding the product specification document
- Contributing to team agile planning activities and backlog prioritization and management
- Leading and mentoring a team of automation testers
- Assigning tasks and reviewing test deliverables and guiding team members in automating best practices
- Prepared and Execution of test script using Selenium
- Architected and implemented robust automation frameworks using tools like Selenium, Appium, and Rest Assured
- Designed continuous integration and continuous deployment (CI/CD) pipelines, integrating automation tests into Jenkins/GitLab to ensure seamless deployment
- Collaborated with cross-functional teams (developers, DevOps, business analysts) to define testing strategies, reducing regression time and enhancing the release process
- Developed automated API, UI, and performance testing scripts using tools such as Postman, JMeter, and TestNG
- Managed a team of 10 QA engineers, providing technical guidance and mentorship to ensure best practices in testing and automation
- Identified bottlenecks and proposed improvements to increase efficiency in the testing lifecycle
- Introduced test data management techniques to ensure data consistency and avoid redundancy during automation execution
- Participated in the design and execution of performance tests to simulate 100 concurrent users, ensuring the stability of applications under heavy load
- Leading and mentoring a team of automation testers
- Responsible for creating test scenarios for use stories using Python and selenium
- Communicating test progress, results and issues effectively
- Created and executed test cases for both Backend and Frontend testing
- Identified automation scenario from manual regression scripts
- Prepared and Execution of test script using Selenium
- Creating Automation framework (POM)
- Performed Black Box and Unit testing using Equivalence Partitioning analysis
- Responsible for creating test scenarios for use stories using Python and Selenium
- Used Jira as Test Repository for Requirement stories and for posting defects
- Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity
- Created Automation test framework (Page Object Model) using Selenium WebDriver
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application
- Exported Test case Scripts in Eclipse IDE Added annotations to the test
- (Selenium)
- Verified the end-to-end testing of Sears.com related sites using the Selenium Automation
- Run tests by using Selenium remote control in different browsers
- Used Selenium GRID to execute test cases parallel on different target machines
- Examine the results of test to pinpoint defects in the application
- As part of compatibility testing, executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems
- (validation)
- Used TestNg to run test suite and Maven as build tool
- Performed data driven using jxl
- Creation and modification of script
- Participated in the Requirement understanding discussion with Business and IT teams
- Scheduling Requirement Clarification meeting with BA team
- Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts
- Involved in developing the Test Strategy, Test Plan documents for System/Integration Testing
- Prepared high level System Test Scenarios and Test Conditions for various functional segments
- Worked on the Test schedules, Test estimates for the Test Script development and execution
- Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center
- Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals
- Performed the access check for all the databases, tools, servers, and interfaces as Entry criteria for the System Testing
- Created Requirement Traceability Matrix by mapping test cases to the requirements to address all key points of functionality
- Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing
- Wrote complex SQL queries between source and target for validating ETL jobs
- Tested complex ETL Informatica jobs based on Business requirements and Business rules to load data from source Mainframe files, Views, and Stored Procedures to target tables
- Involved in extensive data validation using SQL queries and back-end testing
- Tested Business Object Reports for prompts as well as for Data validation
- Experience in creating UNIX scripts for file transfer and file manipulation
- Provided the UAT and Production support for End-to-End Test Script execution and Defect retest
- Good experience in onsite model work
- Schedule and Co-ordinate testing tasks in QC
- Organize defect triage calls Development and Business team to resolve outstanding issues
- Responsible for creating the Traceability matrix and linking test scripts with requirements
- Responsible for sending Daily status Reports for SIT Execution to the team
- Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports
- Selenium, Java, Informatica Power Center, Unix Korn Shell Scripting and Windows XP, HP Quality Center 10.0, Quick Test Professional 9.5, Oracle 10g, SQL Server, Teradata.
Education
Master of Science - Computer Science
University Of Northern Virginia
Annandale, VA 04.2008 - 10.2009
Bachelor of Technology - Mechanical Engineering
Nagarjuna University
06.2003 - 06.2007
Skills
Bug Tracking Tools:
- Jira
- X-Ray
- Zaphire
Testing Tools:
- Selenium
- Playwright
- TestNG
- JUnit
- Postman
- Rest Assured
- JMeter
- GitLab CI/CD
- BrowserStack
Operating Systems:
- Unix
- Linux
ETL / Reporting Tools:
- Informatica
- Data Stage
- Talend
RDBMS:
- Oracle 11g
- SQL Server
- MySQL
- Teradata
- Db2
- MongoDB
- Hadoop
- SAS
Development Tools:
- Oracle SQL Developer
- TOAD
- SQL
Additional Tools/Skills You Can Add (Optional):
- Docker (For containerized test environments)
- Git (For version control of test scripts)
- Jenkins (For continuous integration and test automation execution)
- Selenium Grid (For distributed test execution)
- Maven/Gradle (For managing dependencies and build automation in Java projects)
Timeline
ETL/Automation Engineer
Aetna Resources LLC (a CVS Health Company)
07.2017 - Current
ETL /Automation Tester
Sears Holdings
03.2013 - 07.2017
ETL/Automation Tester
Citizens Bank
10.2012 - 02.2013
Automation Tester
Sears Holdings
03.2011 - 09.2012
Automation Tester
Wells Fargo
01.2010 - 03.2011
Master of Science - Computer Science
University Of Northern Virginia
04.2008 - 10.2009
Bachelor of Technology - Mechanical Engineering
Nagarjuna University
06.2003 - 06.2007
Similar Profiles
Paige LockettPaige Lockett
HEDIS Review Nurse at Romack Resources - Aetna, CVS Health CompanyHEDIS Review Nurse at Romack Resources - Aetna, CVS Health Company
CHRISTINE DOLSCHRISTINE DOLS
SENIOR MANAGER, NETWORK CONTRACTING at Aetna, a CVS Health Company (First Health Network)SENIOR MANAGER, NETWORK CONTRACTING at Aetna, a CVS Health Company (First Health Network)
JENNIFER PATTERSONJENNIFER PATTERSON
Supervisor, Plan Sponsor Services at Aetna, a CVS Health CompanySupervisor, Plan Sponsor Services at Aetna, a CVS Health Company
Amra HuskicAmra Huskic
Market Leader – Chicagoland Region at Help at HomeMarket Leader – Chicagoland Region at Help at Home
Isaiah KnoxIsaiah Knox
Custodian at Performance CleanCustodian at Performance Clean