SUMMARY:

• Worked as Senior Quality Assurance Analyst having total 9 years of experience in manual testing.
• Worked as a client partner handling offshore teams.
• Excellent understanding of the Software Development Life Cycle (SDLC) and Testing Life Cycle (STLC) Process.
• Expert in test scripts development, execution and coordinating with development team to fix bugs.
• Good experience in preparing QA Artifacts like Test Scenarios, Test Plan and RTM.
• Sound domain knowledge of Banking and Financial Services and Health Care domains.
• Worked in Confidential of California, Confidential, CIGNA Health Care and National Stock Exchange Projects.
• Predominant knowledge in SQL Backend testing.
• Strong background in ETL/Data warehouse testing using ETL tools.
• Write SQLs to validate the transformation and data cleansing rules defined in data mapping documents.
• Good knowledge on UNIX commands like wc, grep, cut, sort, more, cat etc.
• Excellent understanding in using SoapUI for testing Service Oriented Architectures (SOA) and Web Services (SOAP, WSDL).
• Skilled Web Tester experience testing websites from an end - user role to ensure they function appropriately.
• Good knowledge on testing applications using Message Broker, Message Queue, Mainframes and Windows SDK.
• Worked in all sort of Testing such as System Testing, System Integration and Regression testing.
• Experience in using Test Management tool like Quality Center, ALM and Defect Management tool JIRA.
• Resourceful team player and capable of delivering tasks within stringent timelines.
• Good communication skills, interpersonal skills, self-motivated, quick learner and team player.

TECHNICAL SKILLS:

Operating System: Windows, Mainframes, Unix

Programming Language: C, Windows SDK

Tools: HP Quality Center, Command Editor, IBM Web sphere Message Broker, ETL Data stage, Informatica

Database: SQL, DB2, Oracle SQL Developer

Web Technologies: XML, SOAP UI

Packages: MS Office

PROFESSIONAL EXPERIENCE:

Web QA Analyst

Confidential

Responsibilities:

• Tested Confidential Website for functionality and efficiency from an end-user perspective.
• Conducted Functional, End-to-End testing/System testing, Smoke, Regression testing for both GUI and Back-end processes.
• Performed database testing to ensure data atomicity, consistency, integrity and durability across the database using SQL queries.
• Documented all findings and assigned pass/fail statuses in ALM.
• Logged many defects and followed on the Defect Life Cycle using JIRA.
• Analyzed issues and provided feedback to development team.
• Communicated with clients to ensure functional requirements are met.

Environment: SQL, JIRA, ALM, TRIPAPAZ.

Confidential

Senior Quality Assurance Engineer

Responsibilities:

• Worked on data conversion from legacy systems to Oracle db in Conversion phase.
• Tested the Provider Information Management Systems web application which is developed based on the PIMS Oracle db backend.
• Worked on the domains like Practitioner, Provider, Business Entity, Networks, Locations and Payment Information domains.
• Develop and execute test cases.
• Write complex SQLs to validate the transformation logic and rules in ETL.
• Worked on Conversion and Integration phases of the project.
• Preparation of daily testing report.

Environment: ALM,JIRA, Oracle SQL Developer, Informatica, SQL.

Confidential

Quality Engineer

Responsibilities:

• Develop and execute test cases.
• Write SQLs to validate the transformation and data cleansing rules in ETL Datastage.
• Validate data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads.
• Perform different ETL validations like Data validation on source and target tables.
• Run/Validate ETL jobs in DataStage.
• Preparation of daily testing report.

Environment: JIRA, UNIX, IBM Aqua Data Studio, IBM Datastage, SQL, UNIX.

Confidential

Test Analyst

Responsibilities:

• Develop, execute and maintain test cases in QC.
• Write SQLs to validate the transformation and data cleansing rules in ETL Datastage.
• Validate data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads.
• Perform different ETL validations like data-data, data-file, file-file based on source and target.
• Run/Validate ETL jobs in DataStage.
• Create Test Strategy, Test Plan.
• Preparation of daily testing report.
• Test and defect Management using HP Quality Center.

Environment: Quality Center, ETL Datastage, Mainframes, DB2 Command Editor, CA Workstation, SQL, UNIX.

Confidential

EAS Web services

Responsibilities:

• Developed and executed Test scripts.
• Message broker will utilize XML SoapUI as input and send the request to EAS Web services.
• Worked on SOAP UI to validate the EAS Web services.
• Prepared all the QA Artifacts such as Test Plan, Requirement Traceability Matrix.
• Involved all types of Testing like System, System Integration and Regression Testing.
• Prepared the Test Execution status report.

Environment: Quality Center, SOAP UI, XML, Message Broker

Confidential

Responsibilities:

• Involved in System Testing, System Integration Testing and Regression.
• Prepared Test Scripts and Scenarios.
• Worked on Quality Center for uploading scripts.
• Performed Claim format validations by mapping the contents of the dataset with the copybook in Mainframes.
• Worked on Message Broker to ensure that the claim formats are routed to the respective destinations.

Environment: Quality Centre, Message Broker and Mainframes

Confidential

Tester

Responsibilities:

• Prepared and Executed Test Scripts.
• Involved in Functional testing of the front end NEAT System.
• Involved in System Testing, System Integration Testing and Regression Testing.
• Performed MOCK test for release before going to live.
• Done Defect Management.

Environment: Quality Center, Microsoft Visual Studio, VOS (Virtual Operating System) on Stratus Mainframe System, Defect Tacking Tool.

Confidential

Design Engineer

Responsibilities:

• As Design Engineer performed duties like writing programs in programmable logic controller (PLC) used in commercial and industrial control applications.
• Also involved in end-to-end testing of the application.
• PLC programming uses ladder language to attain desired functionality.
• Worked on AutoCAD software for circuit wiring diagrams.