Post Job Free

Resume

Sign in

Sql Server Qa Analyst

Location:
Jacksonville, FL
Posted:
September 26, 2023

Contact this candidate

Resume:

Ushasri Pochana

Email: adzzav@r.postjobfree.com

Mobile: +1-276-***-****

PROFESSIONAL SUMMARY

Over 5 years of experience as a Quality Assurance Analyst, with a focus on manual testing and beginner experience in automation testing.

Expertise in a wide range of testing types, including Functional, Integration, System, Smoke, User Acceptance, Regression, and End-to-End testing.

Experience in healthcare domain, with focus on Eligibility, Claims, Enrollment, Recipient, and Provider testing.

Experience testing e-commerce applications both in front-end and back-end teams.

Strong work experience with testing Web Services and APIs using Postman and SOAP UI.

Solid understanding of the entire Software Development Life Cycle from Project Planning, Requirement Analysis, Design, Development, Testing, Defect Reporting and Tracking, Deployment and Maintenance.

Strong experience in testing related activities such as Understanding Requirements, Preparing Test Plans and Test Data, Creating and Executing Test Cases, Test Report Generation, Defect Reporting and Tracking.

Reviewing story requirements, design, and acceptance criteria during planning to provide timely and meaningful feedback for robust story details.

Maintain positive and productive working relationships with Developers, Product Owners, Project Managers, and other team members.

Highly proficient in Agile/Scrum, Kanban process.

Experienced in Backend Testing and can write complex SQL queries.

Excellent team player with effective time management skills and a consistent ability to meet project deadlines.

Creative and aggressive self-starter capable of working in internal, external, independent, and team environments.

Highly motivated, organized, results and detail-oriented with good interpersonal, communication, and presentation skills.

Easily adaptable to new and fast-changing technologies.

EDUCATION

Jawaharlal Nehru Technological University, India

Bachelor of Technology in Electrical & Electronics Engineering

WORK PERMIT

Employment Authorization Document (EAD)

TECHNICAL SKILLS

Test Management Tools

Jira, Test Rail, Zephyr, ALM/Quality Center, Bugzilla, QTP, BrowserStack

API Testing Tools Postman, SOAP UI, Swagger

Databases MS SQL Server, Oracle, Postgres, Cassandra Log Management Tools Graylog, Splunk

Data Serialization XML, JSON, YAML

Operating Systems Windows, Linux, Mac OS, iOS, Android Version Control Software Github, Git

CI/CD Tools Jenkins, Gitlab

MS Suite Word, Excel, Power Point, Outlook, One Note Diagramming Software Lucidchart, Microsoft Visio

SDLC Methodologies Agile (Scrum, Kanban), Waterfall Collaboration Tools

Slack, Microsoft Teams, Zoom, Skype, BlueJeans, GoTo Meeting, Confluence, Google Docs, MS SharePoint

Cloud Platforms AWS

WORKING EXPERIENCE

Speed Commerce Corp, Dallas, TX Jan 2022 – Present QA Analyst III

Environment: Jira, Zephyr, Postman, JavaScript, Java, SQL Server, Graylog, JSON, Linux, Github, Gitlab, Lucidchart, Agile Scrum, Slack, Zoom, Confluence, AWS Speed Commerce is a single-source provider of omnichannel customer experience solutions and technology for e-commerce retailers and manufacturers. Services include Warehousing, Order Fulfillment including Receiving, Picking, Packing and Shipping, Returns Processing, Inventory Management, 24/7 customer care.

Roles & Responsibilities:

In Inventory Management, verified that current and future inventory can be added, updated, and deleted using API calls.

In Order Fulfillment, tested Picking, Packing, Cuts and Shipping modules.

In Returns Portal, tested different types of returns like Blind Returns and Refund at First Scan.

In Customer Service Portal, verified Cancels, Shipping Address and Method updates, Appeasements, Bulk Cuts, modules.

Involved in Business Requirement Analysis, Use-Case analysis, and Overall Design.

Analyzed business and system requirement documents to develop test plan and test scenarios.

Created and executed test cases in Zephyr, raised defects, and tracked them to closure.

Actively involved in Functional, Regression, Integration, Smoke, and End to End Testing.

Identified test failures by performing root cause analysis and reported them in JIRA.

Used Postman tool to make REST API calls like Get, Post, Put, Patch, Delete & verify responses.

Verified the accuracy of JSON request and response data.

Created and executed SQL scripts in Microsoft SQL Server as part of database validation.

Verified errors in and warnings in Graylog during testing and reported them back to developers.

Worked in Agile Scrum development methodology with a 2-week sprint cycle.

Used Gitlab to deploy code to QA, UAT and Production environments.

Used Lucidchart to create Integration and E2E flow diagrams.

Created test documentation in Confluence.

Worked actively with developers, Product Owners, and other QA team members to complete projects in time.

Worked with QA members from other teams on E2E testing of multiple projects.

Provided knowledge transfer to new members of the team. Texas Department of State Health Services (DSHS), Austin TX Oct 2020 – Dec 2021 QA Analyst II

Environment: Jira, Test Rail, QTP, .Net 4.5.1, SQL Server, Windows, Git, Jenkins, MS Suite, MS Viso, Agile Scrum, Microsoft Teams, GoToMeeting, Google Docs TPHVS – Texas Public Health Vaccine Scheduler (Recipient Portal) TPHVS is the public facing side of the system that allows Texans to sign up and schedule an appointment to receive COVID-19 and other vaccines from participating vaccine providers. CES – Client Encounter system (Provider Portal)

The Client Encounter System (CES) is the provider-facing side of the system that can be used by providers to create and manage COVID-19 and other vaccination events. YTB - The Your Texas Benefits Login portal

This portal allows residents, families, and low-income people in the state of Texas to apply for benefits such as Food Stamps using Supplemental Nutrition Assistance Program (SNAP), Temporary Assistance for Needy Families (TANF), Medicaid and Medicare. These services are offered to Texas residents by the Texas Department of Health and Human Services Commission

(TDHHSC). The Texas Department of Health administers several programs through the yourtexasbenefits.com portal.

Roles & Responsibilities:

Validated in Recipient Portal that customers can sign up and schedule various vaccination appointments.

Validated in Provider Portal that provides are able to create and manage end to end vaccination events.

Validated vaccine appointment scheduling by creating event-based URLs and registering to see if the appointment slots are available or exhausted.

Validated appointment scheduling, vaccination event creation for different manufacturers like Moderna, Pfizer and J&J.

Validated appointment scheduling via email and SMS communication.

Validated Your Texas Benefits (YTB) Login Portal used for applying benefits such as SNAP, TANF, Medicaid and Medicare.

Played a key role in the analysis and design phase, evaluating and finalizing design options for new business requirements.

Involved in Sprint planning, User Story development and Story Point estimation for the user stories.

Used Jenkins as Build and Deployment tool for QA environment.

Created manual test cases in Test Rail for Recipient Portal, Provider Portal, and YTB Portal.

Conducted comprehensive web-based testing and extensively used SQL Server for validation of test data.

Created and executed automation test scripts using QTP.

Analyzed application, system, and security errors, and performed regression tests on user stories to ensure their stability.

Used to do lot of ad hoc testing to find and get the defects fixed.

Worked with DSHS UAT team and monitored defects logged in Jira and worked for the closure.

Involved in the production deployment activities and helped to validate the systems after the deployment and reporting the issues observed.

Continued to work on the production defects after the deployment of Recipient Portal, Provider Portal, and YTB Portal in production.

Verizon Wireless, Richardson, TX Mar 2019 – Sep 2020 QA Analyst II

Environment: ALM/Quality Center, BrowserStack, Postman, Swagger, Oracle, Splunk, Windows, iOS, Android, Github, Gitlab, MS Suite, Agile Kanban, BlueJeans, SharePoint Verizon is a telecommunications company that offers a variety of services, including mobile phone, internet, and television, to both individuals and businesses. They have built a widespread network that covers a large geographic area, ensuring that customers can stay connected in many locations. Verizon's network is highly regarded for its speed and reliability, consistently outperforming competitors in terms of network coverage. In addition to their strong network, Verizon provides various plans and devices for customers to choose from. This allows individuals and businesses to select the options that best suit their needs and budget. Whether it's unlimited data, family plans, or affordable options for light users, Verizon aims to offer flexibility and choice to their customers.

Roles & Responsibilities:

Worked on various projects including Fraud Portal, Enrollment, Billing, Customer Notifications and Usage pages.

Verified customer enrollment and tested different plans in Wireless, Internet, TV, and Phone services.

Worked on different payment methods like Credit Card, Verizon Gift Card, Verizon Dollars, Online Bank Payment.

Followed Agile Kanban methodology and participated in retrospective meetings to identify areas for continuous improvement.

Collaborated with business users, along with BA/PM, to understand and analyze the requirements to derive a comprehensive test plan/strategy for the application.

Used Github as code repository, Gitlab as build and deployment tool to test and UAT environments.

Collaborated with developers, system engineers, and testing teams to develop test cases for scenarios, conduct baseline testing, identify & address application defects and generate reports.

Effectively utilized ALM/Quality Center for managing and executing test cases & defect tracking and reporting.

Used BrowserStack for compatibility testing across multiple browsers, multiple operating systems, and multiple mobile devices to ensure seamless user experience.

Used Postman and Swager tools for building, modifying, and testing Web API requests and responses.

Actively participated in the defect handling process and attended defect triage meetings.

Performed backend testing by writing complex SQL queries in Oracle, including joins and other statements.

Developed and maintained a regression test suite, while conducting comprehensive web functional testing.

Used Splunk to identify log files for client and server related errors in the test environment.

Performed User Acceptance Testing (UAT) and worked closely with business users to obtain acceptance of user stories.

Provided regular updates to the PM/Manager regarding test case progress, execution, defect handling, regression testing, UAT, and acceptance of user stories.

Conducted weekly user story demonstrations to business users.

Actively participated in production support for Enterprise/Maintenance Releases

(ER/MR).

Blue Shield of California, El Dorado Hills, CA Mar 2018 – Feb 2019 QA Analyst I

Environment: Jira, SOAP UI, OpenText, Java, Oracle, Windows, Jenkins, MS Suite, MS Visio, Agile Scrum, Skype, MS SharePoint

Blue Shield of California is a Health care Insurance company which is a nonprofit, independent member of the Blue Shield Association with 4.7 million members, 7,800 employees and is headquartered in California. Blue Shield of California provides dental, vision, healthcare service plans like HMO, HMO D-SNP, PPO, and PDP plan with a Medicare contract and a contract with the California State Medicaid Program at an affordable price. Roles & Responsibilities:

Worked on a web-based enrollment application that allowed customers to create accounts, log in, access their insurance information.

Verified that users are able to upload files to check eligibility of claim status, apply for claims online, check the status of their claim applications, and pay bills against claims.

Tested EDI files transfer using OpenText, validated the data present in different EDI files such as 837, 835, 834 and compared that with the data in the database.

Tested SOAP Web Services, validated Request and Response XML using SOAPUI tool.

Worked in an Agile environment and participated in all Sprint-related activities, including Sprint Planning, Sprint Review, Sprint Retrospective, and Scrum meetings.

Managed deployments to Test environment using Jenkins as a build and deployment tool to ensure smooth testing and deployment processes.

Developed and executed test cases to ensure that functional requirements were met.

Reported defects using Jira to ensure prompt resolution and maintain quality.

Conducted data retrieval and validation using SQL queries in Oracle as part of Database Testing.

Participated in daily and weekly review and status meetings with the team to ensure progress and identify areas for improvement.

Worked with team members to develop test strategies for projects.

Reviewed test cases with the team to ensure good test coverage based on requirements.

Collaborated closely with development and product management resources within the team to ensure effective communication and timely resolution of issues.

Led testing efforts for multiple projects simultaneously, prioritized tasks, and ensured on-time delivery.



Contact this candidate