Post Job Free

Resume

Sign in

Quality Assurance Sql Server

Location:
San Antonio, TX
Salary:
100000
Posted:
August 21, 2023

Contact this candidate

Resume:

Sravan Kumar Bantu

Sr. Quality Analyst/SDET/UAT

ady3t4@r.postjobfree.com 901-***-****

San Antonio, TX

Summary

Over 8 years of professional experience working in various domains Retail, Health care, E-Commerce, Hospitality and Banking as a Sr. Quality Analyst with Manual & Automation testing.

Excellent Hands-on experience in Software Development and Testing, experience in Manual & Automation Testing of mobile and Web applications & clients specializing in Quality Assurance Testing, QA Automation Engineer, Software Development Engineer in Test (SDET), Selenium and Tosca Tester, proficient in testing Mobile and Web based applications.

Maintain documentation templates and standards and ensure all testing documentation is complete and accurate adhering to QA (Quality Assurance) best practices.

Experience in End-to-End Design, implement and maintain Page Object Model/Shared repository, Hybrid,Data driven and Keyword Driven test automation framework using various tools Selenium, UFT/QTP, Eclipse, TestNG, JUnit framework, JIRA, Version One,and Quality Center.

Initiate the Bach run using ALM test management tool and maintaining test resources

Experience in Retail and e-commerce domain with BSS / OSS order management, Order capture, customer relationship management and telecommunication billing services.

Tested Web Services using Soap UI tool by validating request and response data XML, JSON and created Mock services for Rest API with Soap UI tool and written Groovy scripts with assertions and data-driven testing using excel data with Soap UI tool.

Experience in implementing Data Driven, Page Object Model, BDD/ATDD Automation Frameworks using Java, JavaScript, and C# programming languages.

Involved in entire QA Life Cycle, which includes Designing and Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts for Manual and Automated Testing.

Maintained a log of number of data tested, number of passes, number of fails, number of defects identified, type of defects and the severity and frequency of every defects.

Hands on experience in developing in building RPA (Robotics Process Automation) solutions using UiPath, business processes using Work soft Certify for SAP, automation scripts using UFT/QTP and Selenium automation tools.

Hands on experience with Load testing tools - LoadRunner and Jmeter to design test script, developing load test scenario and doing various level of testing that includes - Performance testing

Ability to build and maintain automation frameworks for Mobile SDK using Appium.

Design and execute features of ATDD (Acceptance Test Driven Development)/BDD using Selenium, Cucumber for Java and Ruby

Expert in automation testing technologies with Appium, Selenium WebDriver for both web and Mobile applications.

Expert in creating database tables, joins, indexes, stored procedures, views, triggers, user defined data types and functions in MS SQL server.

Good understanding of Scrum software development methodology with practices including continuous integration and deployment using Jenkins and Bamboo.

Expertise in facilitating and Extending support to perform UAT testing, Regression testing, Smoke testing, and System Integration Testing.

Good Knowledge of SOA, Web services, Client and Server-Side Validations and knowledge on ETL process.

Technical Skills:

Methodologies : Waterfall, Agile-Scrum, RUP.

Requirements Management : JIRA, Version One, HP ALM-QC.

Automation Skills : Appium, Robotium, Selenium WebDriver / IDE/ Grid, SOAP UI, Restful, Cypress, Cucumber, QTP / UFT.

Database : MS Access, MS SQL, SQL Server, Oracle 11g.

MS Office Tools : Word, Excel, PowerPoint, Visio, Project, SharePoint.

Business Modeling tools : MS Visio, Balsamiq, Rational Rose, Gliffy.

Testing Tools : Bugzilla, HP Quality Center, JIRA, and Load Runner

Operating Systems : Microsoft Windows /Xp/ vista/7/8.

Healthcare : HIPAA compliance, Medicare, Medicaid, MMIS, HL7, ICD-10.

Education:

Bachelor of Technology in Computer Science Engineering, Karunya University, India.

Master’s in engineering management, Christian Brothers University, Memphis, TN

Professional Experience:

CLIENT: Texas Health and Human Services Commission, Austin, TX Mar 2022 – Present

Sr. Software Quality Assurance Engineer / SDET

Project Description:

DSHS had originally planned to update the current Maven-based reporting system, TxHSN. However, due to ongoing quality issues with the system, DSHS will need to develop and implement a replacement system that can meet the new business needs of the program. The replacement system will allow DSHS to improve reporting and tracking of HAIs as well as enhance infection prevention activities that may prevent transmission of communicable diseases such as COVID19 in healthcare facilities. The new system will also be augmented to track infection control assessment and response (ICAR) activities in response to the COVID19 pandemic or other infection prevention emergencies. This project will ensure Texas can effectively update and expand the use of TxHSN across the state for tracking HAIs and infection Control assessments done in facilities.

The TxHSN project solution meets the legislative mandate for the TxHSN reporting alignment with the federal Centers of Medicare and Medicaid Systems (CMS) as well as replacing the current reporting system. Alignment with CMS will allow DSHS to improve reporting and tracking of HAIs, including those for COVID19. All healthcare facilities that are mandated by Texas statute are required to report their health care associated infection (HAI) data through NHSN.

Responsibilities:

Creating Automation scripts with Quick Test Professional (Selenium Web Driver,QTP-11,UFT-12.0).

Developing and maintaining test automation frameworks such as Data Driven, Keyword Driven, and Hybrid framework using Selenium.

Used various Selenium Locators like ID, name, Link Text, Partial Link Text, XPath, CSS, DOM for identifying correct GUI elements in creating automation scripts.

Utilized HP ALM to Track, Report, and Manage defects and bugs throughout the test cycleand attended Defect Status Meetings during testing cycle.

Preforming different stages of Software Development and Testing Life Cycles.

Created a framework from scratch using API testing tool called Karate for REST API Testing

performing Functional, System, Regression and Integration testing

Responsible for requirement gathering, black box test case creation, manual test case execution, and reporting defects.

Participated in QA test case creation and requirement gathering

Understanding of automation life cycle and quality process.

Exposure to all stages of SDLC, STLC, Agile Methodology and Bug Life Cycle

Involved in writing test cases and executing the same.

Performing black box testing, White Box, Functional, Regression, Sanity / Smoke, End to End testing

Used Jenkins as continuous integration server to run automated test suites

Experienced in creating Jenkins’s job and configuring pipeline to run our smoke and regression test suites.

Developed BDD tests using Cucumber by writing behaviors and step definitions. Developed required Selenium support code in JAVA for Cucumber

Working with test/project management tools like HP ALM.

Using MAVEN for build management JIRA as source code repository and Jenkins for

Continuous Integration of the builds.

Using Global/Local - Test/Action Parameters and Data-Sheets to create data-driven testing

Creating the standard library for functions and sub-procedures to reuse the code.

Experienced in load and performance testing tool JMeter

Writing Test Scripts using VB Script in QTP/ALM.

Used BDD framework with Cucumber, ruby and created future files with scenario and scenario utline files.

Involved in development of Data Driven, Modular (functional), Keyword and Hybrid frameworks.

Involved in GUI testing, user acceptance testing, integration testing, navigation testing, IVR testing, and regression testing using web and client-server applications.

Used Data Driven Testing methodology to test the application with multiple sets of data.

Creating Automation scripts using java in Eclipse Tool.

Prepared detailed reports concerning project specifications and activities.

Created functional automation test scripts using Selenium Web Driver with BDDframework.

Used JIRA to raising defects and followed bug cycle.

Worked closely with developers and other QA members to define test requirements and

Developed test cases based on the Business requirements and System requirements.

Defined test automation strategy, designed automated tests, created automated test cases,

Test plans and executed tests using Selenium.

Used Selenium WebDriver for automating of Cross Browser Testing on IE, Firefox and Chrome.

Environment: Mobile testing, AWS, Windows, Q METRY, JIRA, JIRA Test Management, Selenium WebDriver, Cucumber, Karate, JAVA, JUNIT, Jenkins, GIT, Cypress, Post Man, Source Tree, Bit Bucket, APPIUM, Perfecto, API testing

CLIENT: Capital One, Dallas May 2020- March 2022

ROLE: Sr. Quality Analyst/ Web and Mobile

Responsibilities:

Performing Cross-platform, Functional, Regression testing, UI testing for mobile app using APPIUM test automation framework

Requested different versions of IOS, Android devices analyzed the Crash reports on various mobile platforms and reported to the development team.

Responsible for implementing page object model (POM) using Selenium WEBDRIVER,and Data Driven framework to test web application.

Created multiple UI automation frameworks from scratch using WebDriverIO (Selenium), MOCHA, andRANOREX. Responsible for automation tool selection.

Developed and executed automation test scripts using JavaScript and Cypress Automation tool and analyzed test results using HTML reporter.

Designed and implemented page object model pattern using JavaScript and Cypress to execute E2E Web Automation.

Developed a suite on top of existing Cucumber-Karate-Selenium framework for API Automation

Created ATDD (Acceptance Test Driven Development) tests/scripts in Visual Studio using Gherkin language, C#, and Specflow testing framework

Supported framework migration effort from Java Selenium WebDriver to JavaScriptCypress

Involved in mobile testing include app testing & Test automation for web applications using cucumber.

Designed and developed tests for mobile apps testing in Android Platform using APPIUM

Involved in conducting tests on Web services transactions like automatic bill payment, wire transfers sent over HTTP or HTTPS by inspecting every XML request and response using Soap UI.

Tested web services by generating XML based SOAPUI Requests and validated the corresponding XML based SOAPUI Responses.

Performed Functional, System, Regression, Usability, Smoke and end-to-end Integration testing.

Responsible for requirement gathering, black box test case creation, manual test case execution, and reporting defects

Maintained Interface compatibility and concurrency in the project using Java 8 new features like default, static methods and Concurrency API.

Developed BDD tests using Cucumber by writing features and step definitions using Gherkin. Developed required Selenium support code in JAVA for Cucumber.

Experience of security test analysis, network and systems security assessments and security product evaluations.

Involved in setting up continuous integration system using Jenkins and working knowledge with cloud based code repository system like GIT Hub.

Environment: Mobile testing, AWS, Windows, Q METRY, JIRA, JIRA Test Management, Selenium WebDriver, Cucumber, Karate, JAVA, JUNIT, Jenkins, Post Man, C#, Source Tree, Bit Bucket, APPIUM, Perfecto, API testing

CLIENT: Hilton, Dallas January 2019- April 2020

ROLE: Quality Analyst/ Web and Mobile

Project Description:

OHW Brand/Property involves in serving the best property to Hilton customers with proper brand assign to it. Goal of this project is to provide an ease of complete Information about the property and the brand with flexible booking service to the Customer.

Essential Theme Overview: Designed for hotels offering simple accommodations, essential amenities, and services, and near area business and attractions. This is a low touch site that is quite easy for the hotel marketing team to manage.

Focus on hotel offerings: It’s clear we have hotels with unique offerings within and across brand categories. Our goal is to offer three different website design themes:

Essential - A design for hotels offering simple accommodations (10 or less room types), essential amenities and services, and near area businesses and attractions. This will be our first rollout to targeted hotels.

Explorer - A design that is thoughtfully crafted for hotels that offer a diverse selection of rooms (10 or more), on-site amenities and signature services that is beyond essential guest expectations, banquet/conference space, etc.

Experience - A unique design for the one-of-a-kind experiences and spectacular atmospheres of our most extraordinary properties.

Responsive Design -The look and feel of the site will be consistent across all devices (PC/Laptop, Tablet/ Mobile) and customers will have access to the same content regardless of their device preference.

Sensory and succinct content: Our website copy will be customer-centric – Ultimately, each guest should feel like they are the star of the story and feel a connection with the hotel before they arrive.

Responsibilities:

Responsible for creation and maintenance of Automation setup and support documentations.

Created and Executed API testing and modularized test cases using SoapUI.

Using manual and automation process using Java Selenium Webdriver for Web based application.

Experience on agile testing (CICD) with TDD & BDD frameworks with Cucumber tool.

Performing middle tier integration Web services/Web API using Postman, WCF and SoapUI automation tools.

Working on Digital Key feature of mobile app which allows end users to use their mobile devices as room key for the hotel stay which works on BLE.

Experience in SQA (Software Quality Assurance) including Manual and Automated Testing with tools such as Selenium WebDriver, WebDriverIO,Cypress,TestNG, Junit, Gherkin, Cucumber, SpecFlow, Quality Center/ALM, JIRA, and Maven.

Good skill in Defect Management and Tracking, Test Execution, Test Report generation, and Analysis using Quality Center, and JIRA.

Used Java language and TestNG framework for scripting. Used Maven for building the WebDriver project. Integrated with CI tools Jenkins for running tests on nightly basis automatically.

Automation of tests for connected room involving Edge Controller and IoT devices connected to the EC on both Android and iOS platforms.

Experience in working with Atlassian software (Jira and Confluence)

Work closely with project manager in backlog management and continuous delivery of features.

Educate and reinforce scrum methodology and agile framework to team members and key stakeholders.

Ensures that the team is functional and productive; understands incremental delivery and the value of metrics.

Preparing and maintaining the Master Test Plan, Test Cases, Automation Test Scripts and defining test strategy and procedures.

Wrote complex automation code/scripts using C# programming language to implement the programming logic

Strong in VBScript, appropriate use of descriptive programming and regular expressions.

Solely responsible for maintaining automation code base on Stash Bit Bucket whilst aiding team members in scripting and code review.

Performed mobile testing by converting web app to mobile transforming existing web test cases to IOS & Android platforms using Appium.

Validate back end data, stored procedures, and jobs on the Oracle Database.

Constant engagement with UI-UX design and Product Managers, to build a user friendly and sound quality features and products.

Utilized PL/SQL querying for stored data in enterprise DB server also verifying the data integrity and data quality.

Generated reports from the SQL query results into logical flow maps using Tableau and created story boards with drill-down information.

Responsible for communicating the reports generated using Tableau to team members and all other required personnel.

Environment: JIRA, MS Visio,Appium,SAFe, Jira, Confluence, Bugzilla, Agile Principles, Teradata SQL Assistant, SAS, MS SQL Server, WSDL, SOAP UI, Postman, Cucumber, Tibco Spot fire, Jenkins, Tableau, Share point, Rally, MS Office, Windows XP

CLIENT: FedEx, Memphis, TN November 2017- Nov 2018

ROLE: Quality Analyst/UAT

Project Description:

EAN Expansion – Enterprise Account Number defined as an alpha numeric (20) field which currently contains a 9 – digit number. Its unique number allows customer to ship any FedEx service. Burn rate of EAN is extremely high; it has risen as a showstopper for running business to FedEx. Solutions to this initiative are to establish a solid pool of EANs to sustain business for many years. – “QA / UAT”

ECIS – Enterprise Customer Information Solution – It is a customer information portal which holds complete business customer data of FedEx services – “Data Analyst.”

CHEERS main Frame Systems retirement – Customer Handling Electronic Edit and Retrieval System which is a main frame system (legacy system) adapting to ECIS. – “Scrum Master”

Responsibilities:

Enhance, extend, expand, and maintain test automation libraries and frameworks for regression test bed.

Excellent communication, problem solving skills, coordination, documentation, project planning and interpersonal skills.

Experiences in SQL Development complete MSBI Suite Implementation. Good knowledge in RDBMS and Data warehouse concepts

Scheduling the automated test cases as part of continuous delivery after every build/code deployment using Continuous Integration tool in Devops Tools.

Jenkins Devops tool is used to run the dimensions of the check-in code to verify the extent report.

Maintained Interface compatibility and concurrency in the project using Java 8 new features like default, static methods, and Concurrency API.

Write BDD (Behavior Driven Development) tests using Cucumber and JavaScript

Secured the API's by implementing Oauth2 token-based authentication/authorization scheme using spring security.

Expert in Accessibility Testing (ADA testing) with IOS – Voice over (VO) and Android – (AND Talk back) independent platforms including Web based applications over browser compatibility using Appium and Robotium.

Developed manual test cases and automation scripts for mobile native applications both IOS & Android platforms by using Appium.

Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans. Updated and maintained JIRA stories (tickets) assigned.

Facilitated Guidelines and global test summits to provide enterprise application certification for EAN teams.

Maintained SharePoint sites for 3 different projects, Purple Hub design/creation of project content with complex inbuilt links. Educate and reinforce scrum methodology and agile framework to team members and key stakeholders. Involved in Performance tuning for the long running queries.

Involved in organizing test environments execution for all tier level applications.

Environment: Appium, Selenium WebDriver, Cucumber, HP ALM QC, Gliffy, SAFe, Scrum, Agile Principles, TeradataV13, SAS, MS SQL Server, WSDL,SOAP UI, Postman, Tibco Spot fire, Tableau, Share point, Remedy, MS Office, Windows XP.

CLIENT: Rooms to go, Tampa, FL October 2015-November 2017

ROLE: Quality Analyst/UAT

Project Description:

Along with the creation of this great furniture company, an exciting and innovative way to shop furniture was born. Rooms To Go introduced the concept of displaying and packaging furniture in complete room settings. As designers coordinate each room’s colors, fabrics, and accessories to the last detail, so customers do not have to. This approach affords customers a simplified shopping experience and increased savings when buying an entire room. As business analyst web portal has been built, converting from old legacy to new digital platform experience for web, mobile channels.

Responsibilities:

Responsible for Smoke testing, Integration testing, Database testing, regression testing and API testing.

Worked in Agile environment and provided testing of complex next generation features for Salesforce CRM.

Performing Cross-platform, Functional, Regression testing, UI testing for mobile app using APPIUM test automation framework.

Automating scripts running for quality check of order management and customer chart inputs.

Automate test scripts for product wise and revenue report generation.

Built Webservices Test Scripts, Test plans, JMS Test Plans and Web Test plans usingJMETER.

Experienced in documenting & tracking defects and regressions.

Strong experience in the field of Information Technology in Software Development Life Cycle (SDLC) with emphasis on Software Testing/Quality Assurance.

Extensively involved in Unit testing, Load Testing, GUI Testing, Integration Testing, Regression Testing, Data Driven Testing, Functionality Testing and UAT on Client /Server and Web-based applications.

Hands on experience in Mocking libraries -Lisa Mocking and Cucumber libraries for rest api testing

Experience of security test analysis, network and systems security assessments and security product evaluations.

Involved in designing of Automation Test cases using Selenium WebDriver, Java, JUNIT, Ant

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012.

Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.

Worked on HP ALM, Rally, Confluence and other test management tools.

Performed Data driven testing using Selenium WebDriver, Junit functions and JDBC Connections which reads data from scripts using property and XML files. Used statistical techniques for hypothesis testing to validate data and interpretations.

Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans.

Build and grow relationships with external agencies/organizations to advocate for consumers and guarantee the best continuity of care. Responsible for Requirement gathering, Business Process Flow, Business Process Modeling and Business Analysis with Document and Records Management

Experience working with Content Management Systems (dotCMS)

Environment: Agile/Scrum, Jira, UI - Html, CSS, Cucumber, oracle.10, ATG/BCC, JAVA, SharePoint, MS Office, Rational Requisite Pro, Rational Rose, UML, HP ALM QC, Version one.

CLIENT: Regional Health, Atlanta, GA November 2014- September 2015

ROLE: Quality Analyst

Project Description:Under limited supervision, gathers and analyzes user needs for developing and modifying clinical and/or business applications in the healthcare environment. Analyzes complex results, including Workflow and GAP analysis, proposes solutions and/or recommendations in addition to building, configuring and/or modifying applications using existing application tools.

Responsibilities:

Worked in SDLC Waterfall Methodology

Performed SWOT and GAP Analysis to discover new functionality requirements, prioritized them based on actual business needs, prepared Functional Requirements and Use Case Specification document

Create, design, and format requirement specification documentation including process flows, and other information or processes needed to describe required system changes for development and QA for downstream customers. Reviewed design documents, business requirements and prepared test cases.

Involved in Identifying and setting up test data to be used for test execution.

Implemented automation using Selenium WebDriver, JAVA, Selenium Grid, Cucumber, Maven

Developed and executed test cases and test scenarios and followed up defects using Spiral Test.

Kept the application extremely simple by encapsulating all the complexity of the system in coarse grained services. Owned and managed the Sprint Backlog, Impediments list

Demonstrated guidelines of HIPAA, HL7 compliance while handling patient data. Worked on HL7 for the exchange, integration, sharing and retrieval of electronic health information.

Analysis for making system compliant with HIPAA. Management of patient profile transfer (PPT) reports created by data team by verifying the associated data.

Participated in the analysis of the existing processing, worked with fellow business analysts in methodology for defining ICD-10 mapping processes and documenting business requirements.

Configured HIE API to allow user applications to communicate with the modules of the system.

Assisted in developing the Test Plan, Test Cases and Test Scenarios, based on business requirements & technical specifications. Implemented and developed Automated Software Quality Assurance End-End Business scenarios using Selenium WebDriver. Tested and re-tested all defects found during testing period.

Used Selenium WebDriver, Jenkins to create nightly automation scripts.

Developing step definitions from Gherkin feature files.

Supporting Triage team by querying data log tools like Splunk and analyzing the root cause for the failures in the applications.

Client facing on daily basis and Coordinating with offshore teams.

Worked on Implementing API Documentation using Swagger2 to understand the REST services.

Collaborated with the Business Users to organize and conduct UAT.

Demonstrated understanding and experience with SQL queries.

Environment:SDLC (Waterfall, Scrum-Agile),HP-ALM QC, UML, SQL Server, Tableau, .NET, MS Word, MS EXCEL, MS PowerPoint, JIRA



Contact this candidate