SUMMARY

• 7+ years of diverse experience as a QA which includes ETL Testing, Salesforce Testing, Manual and Automation Testing experience of Client server and Web based applications.
• An accomplished Software testing professional with experience across different stages of SDLC and STLC, including Requirements understanding, Estimation, Test Design, Test execution and Defect Management.
• Extensive experience working in both Waterfall and Agile methodologies.
• Proficient in performing various Types of testing as well various Testing techniques.
• Expertise in various domains like Healthcare and Telecom.
• Extensive Point of Sale (POS), Mobile application Testing and ETL Testing experience
• Very Familiar with various types of testing tools such as Jira, HP ALM and TFS for logging defects and Test case Management.
• Experience in Backend Testing using SQL queries on Oracle and SQL Server.
• Experienced in working with different testing tools like TFS, HP ALM, HP QC, SOAP UI and JIRA.
• Excellent knowledge of Web Services testing using tools like SOAPUI /Rest API.
• Experience in Testing Secured Webservices using OAUTH, BASIC Auth, SSL certificates.
• Performed Web Services testing using SOAP UI, by sending XML Request and analyzing the results from response XML.
• Used SOAP UI/postman for WSDL Validation and used different Assertions for validating response
• Developed and Executed simple to complex SQL queries to Define, Manipulate and Query database
• Extensive Experience on testing API’s/ Web Services using Postman and SOAP UI
• Experience working in environment with a mix of onsite - offshore Global delivery model.
• Ability to coordinate effectively with development team, business partners, end users and management

TECHNICAL SKILLS

Web Servers: Apache Tomcat 4.0/5.5/6.0. x.

Application Servers: JBOSS 4.0.1/4.3.2.

Languages/Scripting: Java, SQL, PL/SQL, JavaScript, XML, JSON.

Databases: Oracle, SQL Server, MS- Access.

Testing tools: HP ALM, JIRA, Bugzilla, TFS, QTP,QuerySurge

ETL Tools: Informatica

Operating Systems: Windows 2000/NT/XP/Vista. Unix.

Web services: SOAP UI, Postman.

PROFESSIONAL EXPERIENCE

Confidential

Test Analyst

Responsibilities:

• Tested the outbound file that contains invoices that are to be paid and recurring payments to be auto termed for Medicare Advantage and ACA members.
• Tested EDI related 835, 832, 830 Files.
• Actively involved in writing Test Plans, Test scenarios, Test cases and in Test execution
• Worked on Testing QA Build Releases and verified the Release Notes.
• Involved in daily meeting with team members to keep track of defects and test execution and provided update on testing progress to clients
• Extensively used ADO to track the User Stories.
• Created ETL test data for all ETL mapping rules to test the functionality
• Prepared and ran SQL queries to verify target data extracts
• Performed QA Testing in distributed UNIX/Windows Environment, Oracle databases as back end and performed end-to-end testing. Involved in complete QA Life Cycle
• Reviewed the change request documents, and attended meetings and documented the required changes.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database.
• Uploaded test scenarios, test cases and defects to VSTS.
• Involved in test plan and test case review meetings and participated in weekend reviews with team members.

Confidential, Kettering, OH

Test Analyst

Responsibilities:

• Performed various types of testing such as Functionality Testing, POS Payment gateway testing, Reports Testing and Data Migration Testing.
• Actively involved in writing Test Plans, Test scenarios, Test cases and in Test execution
• Worked on Testing QA Build Releases and verified the Release Notes.
• Involved in daily meeting with team members to keep track of defects and test execution and provided update on testing progress to clients
• Experience in creating test data and end to end testing forPOS.
• Extensively tested payment gateway scenarios like validity of CVV numbers, swiping of both sides and Chips etc.
• Verified if the system is displaying the price, Item description, the Price, Itemized prices correctly.
• Wrote various SQL queries like Select, Update, and Joins to retrieve desired information.
• Understood various WADL files and created WebServices Testing and created various assertions to validate several conditions in a given test case.
• Verified Various negative testing scenarios such as Void entries, Unavailable Items etc.
• Extensively used SQL queries to perform various data validations.
• Performed Negative Testing to allow coverage for all out of the box scenarios
• Performed Web Services testing using SOAP UI and REST API, by sending XML Request and analysed the results from response XML.
• Performed Various types of testing such as Functional, Regression, Integration and End to End testing of several modules of the DMS system.
• Performed GUI, Functional, Web services testing, Integration testing, Manual testing, Regression, as well as User acceptance test (UAT)
• Performed Webservices Security Testing using Basic Auth, OAUTH and Certificates
• Tested RESTful Web Services using SOAP UI tool

Confidential, Hartford, CT

ETL Test Analyst

Responsibilities:

• Created ETL test data for all ETL mapping rules to test the functionality
• Prepared and ran SQL queries to verify target extracts data
• Tested Various HEDIS Reports to ensure that they are as per the requirement documents
• Performed QA Testing in distributed UNIX/Windows Environment, Oracle databases as back end and performed end-to-end testing. Involved in complete QA Life Cycle
• Tested the ETL with XML as source and tables in the data warehouse as target Testing the functionality of reversals using the historical data
• Reviewed the change request documents, and attended meetings and documented the required changes.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database.
• Uploaded test scenarios, test cases and defects to VSTS and SharePoint
• Involved in test plan and test case review meetings and participated in weekend reviews with team members.
• Responsible for running test cases and posting defects.

Confidential

Test Analyst

Responsibilities:

• Involved in Script creation, maintenance and enhancements for Sanity and regression suite.
• Prepared test cases, test data, as per test procedure specifications.
• Preparing the test plan, test estimation and identifying the risk areas.
• Involved in Smoke testing, System testing and Regression testing.
• Involved in preparation of Test Strategy documents/Test plan.
• Involved in preparing status reports and Bug reports.
• Worked on Testing QA Build Releases.
• Analyzed Inpatient and Outpatient Workflows.
• Interacted with Developers to follow up on Defects and Issues.
• Responsible for Functional Testing and Regression Testing.
• Participation in User Acceptance Testing.
• Worked as SQL Server Developer (To setup the Master Data) in QA environments.
• Participating weekend reviews with team members.
• Responsible for running test cases and posting defects using HP ALM.

Confidential

Test Analyst

Responsibilities:

• Involved in understanding the requirement document and getting the clarifications from design team.
• Involved in preparing documents related to the application.
• Tested the Mobile application on various Mobile platforms such as IPhone and Android using emulators.
• Involved in preparation of Test Strategy documents/Test plan.
• Preparation of Traceability Matrix.
• Performing Manual testing on different Android devices.
• Involved in developing Test reports using Templates and Developed Bug Reports.
• Execution of test cases and preparation of test data for manual testing.
• Performed Functional and Regression and Integration testing.
• Involved in writing SQL queries in SQL Server.
• Defect reporting and tracking using Bugzilla.
• Involved in GUI, Functional and Regression testing.
• Attending Daily calls and Project meetings to update the status.
• Communicating with developers and BA, whenever clarifications are required.