SDET
Resume:
Sudhir Mutyala
***********@*****.***
Professional Summary
Have around 13 years of experience in Software testing in the areas of Web based, Client - Server applications using Manual and Automation testing techniques.
Good business knowledge in the financial, trading and healthcare industries.
Expertise in writing and executing test plans, test scripts, and test cases and performing functional, integration, regression, system, and user acceptance testing.
Strong knowledge in web services testing via Tool SOAP UI/ Restful Webservices
Worked on testing REST API using Automated RestAssured framework and SOAP UI
Good knowledge of WebDriver APIs, Java and creating different Class objects in Selenium.
Good experience in creating test scripts using WebDriver, Selenium Grid in Java.
Exceptional experience in developing and testing dynamic, database-driven applications with multi-tier interfaces.
Strong skill in backend testing using with SQL queries on oracle RDMS and SQL Server.
Good experience in tracking bugs, test case execution status, and generating overall project heath reports using Jira, HP ALM and Azure DevOps.
Assisted in Performance testing using LoadRunner.
Excellent experience in validating Data conversion, Data integrity and Data storage processes.
Knowledge in developing and executing shell scripts for testing in UNIX environment.
Well versed in reviewing and analyzing requirements for testability, conducting walkthroughs with developers, and other team members.
Handling the offshore resources and helping in understanding the on-site project.
Good experience as a facilitator, and test coordinator as having worked with Project, Tech. and Product teams, initialization of the project till release.
Good team player, detail-oriented and motivated individual with strong analytical and communication skills
Technical Skills
Testing tools
Rest Assured, Cucumber, Ready API, Fitnesse, Selenium (Webdriver)
Bug tracking tools
JIRA, Rally, Quality Center (ALM), Azure devOps
Languages
Java, Groovy,C, C++, UNIX shell, XML, JavaScript, VB Script, SQL, HTML
Database Systems
Oracle, MySQL, SQL Server, Teradata, Microsoft Access, DB2, HIVE
Other Tools
Jenkins, BigBucket, MSTR
Work Authorization: US Citizen
Professional Accomplishments
Sr. SDET Nov’22 – Present
United Healthcare - Cognizant Technology Solutions (CTS)
United Healthcare, the nation’s #1 health insurance company, offers a wide range of plan options and expert support to help a family's health insurance needs.
Responsibilities
Involved in testing COMPAS and ORMB web applications for insured member enrollment and their payment process.
Using the Quality Core frame, which is used for both API and UI testing. The API is based on Rest Assured and the UI is on Selenium-Cucumber with POM.
The existing Selenium framework has been improved by adding newer functions/methods to enhance its usage.
Created properties, configuration, a message system, UI helper to support the framework.
Verified correct CRUD operation is invoked for every user action at the UI.
Tested the functionality where it involves FIMXL format report validation, importing member enrollments, claims, payments feed from different interfaces in XML, text, csv formats.
Tested Kafka pub/sub messages via their topics manually and via Cucumber framework.
Deeply involved in creating the report layouts as per business requirement and in testing MicroStrategy Reports.
Leading the validation effort for the Policy, Member, Claim, and Rx Claim domains for Data Integrations and Publication and Subscription Testing.
Experienced in testing the SCD Type - 2, Type-1, Dimensions, and Fact tables.
Good understanding Data Warehousing and ETL testing concepts.
Experience in writing SQL and reviewing the PL/SQL scripts to validate the database systems and for backend database testing.
Expertise in querying and testing RDBMS such as Oracle, HIVE, Data Marts, DB2, MS SQL Server for data integrity.
Experience with backend database and data migration testing. Tested ETL's to ensure that the source and the target are mapped as per the requirements/specifications.
Ensure that data quality validation is done before loading the data into a data warehouse.
Initial loading of records on data warehouse and incremental loading of records later to verify newly inserted/updated data.
Involved in backend testing for different environments, like system integration E2E Testing SIT-E2E and User Acceptance Testing UAT.
Participating in the Business requirements walkthrough and Analyzing requirements and proving the inputs for Estimates.
Integrated with the CI/CD pipeline in Jenkins. These modules will run every time before pushing the code to develop/master to make sure all functionalities are in good health.
Sr. SDET Oct’21 – Oct’22
Options Clearing Corporation (OCC) - Cognizant Technology Solutions (CTS)
OCC is the world's largest equity derivatives clearing organization. It has clearing and settlement services for options, futures, and securities lending transactions.
Responsibilities
Improved the existing Core Test Framework by adding new methods. This framework is with Rest Assured-Selenium on BDD format using the Selenium-Cucumber. This framework will be common and integrated to use testing both API and UI application.
Integrated Cucumber frame to existing modules and now it has been used by BA/Pos.
Improved and added newer functions/methods to enhance its usage.
As it is too complicated to test too many securities and exchanges, assisted in improving the process of a reset script to refresh the data after execution.
Created properties, configuration, message system, UI helper to support the framework.
Verified correct CRUD operation is invoked for every user action at the UI.
Tested the functionality where it involves FIMXL format report validation, importing trade/position feed from exchanges in XML/text/csv formats.
Tested Kafka pub/sub messages via their topics manually and via Cucumber framework.
Tested and validated the position transfer via AMQ by batch/real time process.
Meeting with BA/POs in analyzing the requirements and the technical specification and know functional flows.
Helping the different team with their blockers and assisting them in writing the test scenario in Cucumber framework.
Helping conducting different Scrum ceremonies like Sprint Planning, Daily Stand ups, Retros, Backlog grooming. Improved the team strength like better understanding team capacity/velocity, co-ordination, etc.
Reviewing the code and PRs before pushing into them develop/master branch.
Create a clear set of test cases as functionality modules based on functionality like E2E, API, UI, etc., and maintain them in different modules for easy pipeline runs.
Integrated with the CI/CD pipeline in Jenkins. These modules will run every time before pushing the code to develop/master to make sure all functionalities are in good health.
Sr. QA Engineer Feb’20 – Sept’21
Central States Funds, Chicago, IL - Cognizant Technology Solutions (CTS)
Central States Funds is a healthcare provider on the brand name of TeamCare which partners with many insurance providers like Caremark, BCBS, RedCard etc.
Responsibilities
Involved in requirement gathering and analyzing them.
Validated data quality, integrity, and reliability by testing that the data in the database is accurate and functions as expected within a given application.
Validating large Json files (SuperSet files) to get parsed and saved successfully into different database repositories and objects.
Verifying DB tables, SPs and functions on Data aggregation rules, format, boundary length, Date/Time format, data integrity between tables, primary and foreign key (referential integrity) assigned, indexing the columns, etc.,
Running data tests for all data files, which include data from JSON, Text, CSV, and XML files.
Most of the end points calls other APIs or connect to other API adapters to get data from different sources. We used to validate the data from different DBs (Facets, S3)
Helping developers to create DTOs and their endpoints based on the requirements.
Created a Digital Integration API testing framework for regression suite.
Used Groovy scripts to customize and setup the different test environments, DBs, File location, storing variables at Project and test case level.
Validating Web APIs at each end points using SoapUI Pro (Ready API)
Testing Restful Web Services and creating test cases for each end point.
Used Data Source (Grid, Excel, DB) to loop through test data for test case creation.
Based on end-point functionality creating Parameter Selection, Parameter Combination, Call sequencing, Output verification and validation (assertions)
Create a clear set of test case as functionality modules and integrate with CI/CD pipeline in Azure DevOps.
Sr. QA Engineer Jun.’10 - July ’12 & Jan’16 – Feb’20
JP Morgan Chase, Chicago, IL - Cognizant Technology Solutions (CTS)
Public sector Lockbox processing, where applicant’s forms, checks, and other documents are scanned and processed. Forms and documents will flow through different interfaces before decisions are made as per the client’s requirements and rules. The Payments are collected by checks and Credit cards. Payments are processed through ECP and Pay.gov, transferring the funds to the client.
Whole application and payment process through the workflow management System (Onbase), Eflow (Form Recognition), and ECP payment system.
Responsibilities
Analyzing the requirements from federal government and breaking them down into shorter stories based on the workflow.
Involved in creating functional and technical documents with developers and business analysts.
Involved in the design and development of Automation Framework for payment system using Selenium on Eclipse and TestNG.
Tested Webservices/XML/SOAP and RESTFUL services using SOUP UI tool.
Validated WSDL, request and response JSON, and added assertions to validate the response with the database.
Experience in Automating Web Application testing using Selenium WebDriver with TestNG framework.
Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.
Executing Selenium Test Cases and reporting defects.
Experience in Data driven Testing, Cross browser testing execution using Selenium WebDriver and TestNG.
Created Automation test cases using Fitnesse suite which is extensively used to test backend decisioning and field validation.
Started testing via BDD by integrating Selenium with Cucumber.
Involved in creating complex SQL to get test data from Database and in Backend testing.
There are lot of applications that move around interfaces and across the databases. Involved in testing the Data on ETL processing.
Good at creating SQL DB Stored Procedures, which I created and used in generating Crystal Reports.
Part of the core scrum team involved from beginning of project initiation to go live.
All Projects here are going on Agile methodology with two weeks sprints, responsible for creating feasible sprint for QA.
Involved in creating Test plans, Test strategy and releasing activity of all projects.
Involved in creating CI/CD delivery model by integrating Soap UI, Fitnesse Test suite and Selenium Test suite with the Jenkins.
Written the SQL procedures as test accounts need frequent resetting the account balances. Designed and scripted the code to set registries on the application and used it to run before initializing the driver script within the Selenium framework.
Closing working with development team and technical teams to understand the project architecture.
Involved in Agile best practices, attending scrum meetings, stand-ups etc.
Automation QA Engineer Jun.’14– Dec. ‘15
Charles Schwab, Chicago, IL
Charles Schwab Holdings, Inc. is a retail, online brokerage firm, that provides brokerage services for options, stocks, futures, mutual funds, and fixed income investments in the United States and internationally. This is a subsidiary firm of Charles Schwab.
Responsibilities
Part of the core scrum team involved from beginning of project initiation to go-live.
All projects here are going on Agile methodology with two weeks sprints, responsible for creating feasible sprint for QA.
Involved in creating Test plans, testing strategy, and releasing activity of all projects.
Created test modules, test cases and requirement traceability matrix.
As an Automation Software QA Engineer started developing the framework of all existing projects.
Many projects here have a lot of data to test, so I started creating Data driven framework of all the test suite using UFT 12.0
Created Shared object Repository, Recovery Scenarios, Functions to support the Actions (Test Cases).
Created centralized Data tables to have Test data and Test results, which are in turn connected to all Actions, DB, and Functions.
Few projects need static market quotes, so integrating SQL server as test data with QTP and running the test suites.
Written the SQL procedures as test accounts need frequent resetting the account balances. Designed and scripted the code to set registries on the application and used it to run before initializing the driver script within QTP framework.
Extensive Database integrity testing includes transforming source data from different direct energy market feed providers into a targeted source database.
Created regression automated test cases which runs on Website and via XML
Testing and verifying the data is scrapped from CSV, HTML and XML files and compared with staging database.
As there was a lot of test data to be retrieved from SQL database, we extensively used database functions to get the required test data to test against the UI
Maintaining the existing Coded-UI (Visual Studio) automation test cases.
Using ALM to create manual test cases and using it overall test management tool.
Closely working with the development team and technical teams to understand the project architecture.
Involved in Agile best practices, attending scrum meetings, stand-ups etc.
QA Automation Analyst Jan.’13 – May ‘14
Aquilon Energy Services Inc., Chicago
Aquilon is a trading operations solution provider for participants in the physical electricity markets. Aquilon’s mission is to create industry solutions that provide market participants with a platform to facilitate and streamline activities from the front office through the back office.
Responsibilities
Involved right from project initialization through release, reviewing the requirements, assisting in building the application architecture, creating overall testing strategy and plan.
Worked closely with Product owner, SMEs to understand the Business Requirement’s
Extensive Database integrity testing via ETL, testing various direct energy market feeds to transform into database.
Comparing, transforming, and testing the XML, CSV, HTML source data files with database.
Designed the Automation test framework for application in UFT and Selenium. (Here in Aquilon few projects are on UFT and other are framed in Selenium)
Adopted Action driven Automation framework in UFT, created Functions, object repositories to support them.
Created Shared object Repository, Recovery Scenarios, Functions to support the Actions (Test Cases).
Scripts (test cases) are written using descriptive programming in VB script and using Functions, Recovery scenarios, Shared Objects, Environmental variables.
As there was a lot of test data to be retrieved from SQL database, we extensively used database functions to get the required test data to test against UI.
Assisted in creating the Keyword frame in Selenium WebDriver platform on current ongoing project, “Electronic Collaboration Platform.”
Created various functions and transformed them to a keyword function in Selenium Web Drive.
Good knowledge of WebDriver APIs, Java and creating different Class objects in Selenium.
Created data driven scripts on testing the application with respective Data base in Selenium framework. This involves the scripts connected to database, comparing value from DB to UI.
Created centralized Data tables to have Test data and Test results, which are in turn connected to all Actions, DB, and Functions.
Maintained Test Case in QC (ALM), created Functions on Uploading/Downloading files (Test Data/ Test Results) from QC into local/shared drives of File system.
Responsible for building Test Plan and Test Strategy for both Manual and Automation test cycles.
The current project at Aquilon is under Agile methodology, testing is conducted parallel to the development and designed in sprit cycles. So prioritizing testing activities for small pieces of function through sprint cycles.
Created QA deliverables via., Test Cycles, Test Case modules, Test Conditions and reviewed with Product team.
Representing the QA team in defect resolution. Conducting walks through with the developers and product team whenever needed to resolve the defects.
Maintain the test deliverables in QC (ALM). Created at testing status and Daily Test report.
Involved in Product Verification Test, Release Management, Warrant releases.
Contact this candidate