SUMMARY:

• 8+ years of diversified experience as a Senior Quality Assurance Analyst in Web - based Applications, Client-Server, ETL, Web Services, Database Applications using Manual and Automated Testing Tools, proficient with Hadoop technologies and ETL process testing.
• Experience in performing Black Box, Functionality, Integration, System, Regression, Performance, Load and Database Testing.
• Strong experience working in Mortgage, Financial and Healthcare domains in all phases of the SDLC.
• Excellent knowledge on Software Testing Levels, Bug Life Cycle and Testing Life Cycle.
• Expertise in writing and executing Test Cases/Scripts and Test Scenarios to satisfy Requirements.
• Interacted with Business Analysts, Business Users and Product Managers for gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Good Experience in test management activities using Test Management Tools.
• Extensively executed SQL Queries on Oracle and SQL Server tables in order to view successful transactions of data and for validating data.
• Experience in testing web based applications built on Java, J2EE, .Net and Mainframe technologies across different browser combinations and windows based applications built on Java and .Net
• Experience in web technologies and frameworks (JSON, XML).
• Very good knowledge on Hadoop architecture and tools like HBase,HDFS, Zookeeper, Spark, Hive, Oziee, Ambari.
• Experience in working on Windows, Linux / Unix environment.
• Strong experience on working Agile Methodology, Waterfall Model and Iterative Model.
• Very good experience working on HIPAA translation based claim processing systems (claims and encounters) and other ANSI X12 EDI implementations.
• Have good Knowledge of HIPAA and 21 CFR Part11 Guidelines.
• Expertise in EDI transactions used in healthcare industry and good knowledge of HIPAA X12.
• Extensive knowledge on the Inbound and Outbound HIPAA transaction sets with both 4010A and 5010A HIPAA versions along with ICD code migration from ICD-9 to ICD-10.
• Experienced in analyzing Functional Requirement Specifications (FRS), Detailed Functional Requirements (DFR), Use Cases and System Design Specifications (SDS).
• Experienced in user training and creation of accurate documentation.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.

TECHNICAL SKILLS:

Databases: Oracle, SQL server, DB2, HDFS, Sybase, MS Access, MS Excel.

Database client tools: Toad for Oracle, AQT, ODBC, TOAD, SQL Plus, XQMF, Oracle SQL Developer, HBase, Hive-Hue.

Languages: COBOL, C, JAVA, SQL, MySQL, VB, .NET.

BI Tools: MicroStrategy (9.x), Crystal Reports, Tableau, Cognos 8.x.

ETL Tools: Informatica Power center 8.1, Ab Inition, Control-M, and Autosys.

Testing Tools: Quality Center 11.0,HP ALM, RQM, Confidential Doors, RDNG, CLM, Silk Central, QTP, Selenium, SnagIt, SOAP UI, EDI X12, At-task, Slack.

API Testing Tools: Postman for REST API.

Load Performance Tools: Para Soft SOA.

Utility Tools: Putty, WinSCP.

Bug Tracking Tools: RTC, JIRA.

Processes: Agile/Scrum, UML, Visio, Waterfall.

Operating systems: Windows 98/NT/2K/XP/Vista/7, MS-DOS, UNIX, Main Frames.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. SQA Engineer

Responsibilities:

• Understanding requirement in Confidential Doors and design test plan, test cases and test scripts in RQM according to Functional Specs and Activities of the Business Stream WP4H GxP HIPPA and Part 11 Modules.
• Performed REST API functional testing in POSTMAN.
• Participate in daily standup and SCRUM and interact and assign tasks to offshore team.
• Validated the Secure server connections in UNIX putty and using putty commands to read exception in logs.
• Performed Verification and Validation of System security measures.
• Verified that the communication/transport channel between the web application and the database repositories is configured to use compliant algorithm.
• Verified that web application writes Audit trail information for every API operation that it implements for each component.
• Verified and Validated Platform Audit and application audit trail information as per Epics
• Validated and verified the Hadoop components configuration in Ambari console.
• Performed validation on if the data can be extracted from HBase and associated Audit logs can be found by system generated keys.
• Ensured that JSON formatted logs are delivered to flat file repository and can be queried using one of the methods described in the Reporting Guide for Audit Service (jq, java) or plan text.
• Created an arbitrary SQL DDL Schema for a DataMart database to be created. Using the DataMart API endpoint, initiated a Create/Update/Delete DataMart request as Data scientist user and verified the HTTP response code.
• Verify Onboarding and Offboarding of users in each CI
• Validated if the Spark jobs ran as scheduled and error logs generated if job fails.
• Performed End-to-end testing from ingestion of resource to retrive an audit trail(.csv file) from platform audit service based on ID to ensure that system is Part-11 Compliant.
• Performed negative testing by bringing Kafka down.
• Involved in HA(High Availability) testing for few components/Services.
• Validated if the resource created/ingested is flowing through as designed in Hive and HDFS and also verified HDFS logs are generated when there is transfer of data from Data Reservoir for external use.
• Ensure that the test results conformed to the OQ’s and SOP’s.
• Ensured that Data at Rest and Data in Flight are secured/encrypted using SSL or TLS protocol and used secure connections.

Confidential, Durham, NC

Sr. SQA Engineer

Responsibilities:

• Deploying the builds on test environment. (RDL, .war, .jar, SQL scripts, Autosys File copy) and performed smoke test on Rules Package Engine.
• Developed Automated Test Cases and Test Scripts for Letters Compliance Project (which involves Guardian, Venture and In - house letters) in Selenium
• Reviewed Business Requirement Document (BRD), Functional Requirement Document (FRD) and transaction Implementation guides.
• Performed testing on Letter Trigger Rules and the data points as per the criteria.
• Analyzed and prepared Test data in order to validate the letter trigger conditions are as designed.
• Involved in Backend testing using SQL Queries. Validated the changes made to the Stored Procedures and views and worked on Autosys tool for scheduling jobs and validated the ETL process.
• Used Altova XML spy tool to validate the XML file and the data points after the letter generation.
• Validated the letter PDF generated (only for in-house) against the designed letter template.
• Involved in testing the Quote Portal UI changes.
• Involved in Testing SSRS reports and validated the report results against DB results.
• Responsible for Creating, Enhancing and Executing test cases using RQM, CLM and AttTask.
• Developed test scripts by using Para Soft SOA
• Mapped the test scenarios to the requirements (Traceability).
• Preparing the test data as per the scenario (All lines of business).
• Performing regression in SIT region and involved in Defect life cycle and Triage calls.

Confidential, Durham, NC

Sr. QA Engineer

Responsibilities:

• Responsible for regression and smoke testing by coordinating with developers for every old(prod) and new release to ensure that system processes are running from end to end and validate the system is ready for full scale testing.
• Tested Stored Procedures, Views to check the status of the target database before moving records into it.
• Reviewed Business Requirement Document (BRD), Functional Requirement Document (FRD) and transaction Implementation guides.
• Responsible for setting up performance data in SQL server and Oracle DB for different Application testing.
• Involved in End - End testing of DMA and SMA Projects.
• Worked with Jira stories and mocked data as per conditions in the DB in-order to test the stories and the BAT scenarios.
• Validated the Backend testing using SQL Queries.
• Worked on the third party application called Vestmark generating trades, model rebalancing, resolving the breaks, etc.
• Perform responsibilities of developing test scripts by using SOA test tools
• Responsible for testing the backend code changes with positive and negative test cases.
• Involved in Testing Outlier reports and validated the report results against DB results.
• Responsible for Creating, Enhancing and Executing test cases and creating defects using Quality Center, Jira and mapped the test scenarios to the requirements (Traceability).
• Preparing the test data for Intra month, SMA QIR Project as per the scenario.
• Validated the SMA QIR EDI files as per the mapping document.
• Used SOAP UI Web Services tool for regression testing Web Services- Confidential and the legacy services.
• Involved in setting up data in backend DB in order to enable the performance tab on Fid.com.
• Involved in Defect life cycle and Triage calls and responsible for keeping team members on track toward completing the terms of goals.

Confidential, Durham, NC

Sr. SQA

Responsibilities:

• Deploying the builds on test environment.(RDL, .war, .jar, SQL scripts) from Jenkins.
• Developed Test Plan, Test Cases and Test Scripts for Claims and Cold storage module.
• Identified and developed Automation test cases and scripts in Selenium.
• Reviewed Business Requirement Document (BRD), Functional Requirement Document (FRD) and transaction Implementation guides.
• Performed testing on Claims UI, EDI, Letters Rules engine and Reporting Subsystem.
• Analyzed and prepared Test data and Tested 260, 997 response and 259 Transactions.
• Worked with the EDI team to validate the input and the translated files based on the mapping guide.
• Performed testing on Letter Trigger Rules and the data points as per the criteria.
• Used Altova XML spy tool to validate the XML file and the data points after the letter generation.
• Validated the letter rules in Rules engine and PDF generated (only for in-house) against the designed letter template.
• Involved in testing the Quote Portal UI changes.
• Involved in UAT support.
• Worked with Jenkins to get the build in .war format and deployed on application server in order to test the Rules and Validated the Backend testing using SQL Queries.
• Involved in database testing by writing and executing SQL queries to validate that X12 files against DB in appropriate tables in Different Testing Environments.
• Involved in Testing SSRS reports and validated the report results against DB results.
• Responsible for Creating, Enhancing and Executing test cases using RQM and AttTask.
• Mapped the test scenarios to the requirements (Traceability).
• Preparing the test data as per the scenario (All lines of business).
• Performing regression in SIT region and Involved in Defect life cycle and Triage calls.

Confidential, Raleigh, NC

Sr. QA Tester

Responsibilities:

• Worked with the functional team in understanding the requirements.
• Developed Test Plan, Test Cases and Test Scripts.
• Extensively worked in Testing Claims, Provider, Recipient, Prior Approvals and Reporting Subsystem.
• Tested HIPAA transactions & EDI Code sets standards like 837,834 I/O, 835,276/277,278 and 270/271.
• Participated in conversions from different transaction.
• Worked with the EDI team to validate the input and the translated files based on the mapping guide.
• Created Requirements Tractability Matrices (RTMs) to ensure complete coverage of requirements, identify all test conditions and test data needs.
• Database testing by writing and executing SQL queries to validate that X12 files against Data Base in appropriate tables in Different Testing Environments.
• Involved in Testing Mainframe and SAS reports by JCL submission and FTP the file from mainframe Server to SAS Server in-order to validate the report results against DB results.
• Responsible for Creating, Enhancing, and Executing test cases and bug tracking using Silk Central.
• Participated in weekly Project status meeting and updated the HIPPA 5010 testing Progress.
• Preparing test lab structure to execute scenarios.
• Used SOAP UI Web Services tool for testing Web Services, inspecting WSDL files, generating SOAP envelopes, and automating or accelerating many other common XML tasks encountered when developing Web-Service enabled applications.
• Worked on mini projects like Enhancements and CSR's for different modules.
• Performing regression in both Test and Stage (Pre-Production Environment).

Confidential, Jersey City, NJ

Sr. QA Analyst

Responsibilities:

• Analyzing the Business requirements, Functional specification and Design specifications and creating the GAP analysis for the changes to Business Requirement.
• Prepared Test Strategy, Test Plan, Test Cases and Test Scripts for System Integration Testing and User Acceptance Testing.
• Exported Test Cases to Quality Center and executing test scripts manually.
• Created Traceability of the test cases to Requirements in Quality Center.
• Performed testing for Data Validations, Data Extractions, Data Transformations, Data Completeness, and Database Connectivity.
• System Integration Testing and Regression Testing to make sure the End to End process is working correctly after the defect fixes and change fixes are made
• Created test data to cover all the test scenarios and created User Acceptance Testing training document for the Business Users.
• Created weekly defect status reports and actively coordinated with the developers to resolve the issues and wrote complex SQL queries in DB2 using TOAD to execute the test cases.
• Worked with UNIX to perform different file validations.

Confidential, Mclean, VA

Sr. QA

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to Functional Specs and Activities of the Business Stream.
• Performed Interface and Integration (SIT) Testing.
• Extensively used SQL queries for data validation and backend testing.
• Data profiling, Data Validation, Data Integrity and Data Cleansing and ETL processes using Ab Initio.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and wrote scripts in SQL to validate the outputs.
• Conducted meetings and reviews with developers and testing team.
• Extensively used Parallelism features of AB INITIO, and simple Ab Initio guidelines to improve performance.
• Validated the data that was populated into Data warehouse Fact and dimensional tables using Ab Initio Data Warehouse tool

Confidential, Ashburn, VA

QA Tester

Responsibilities:

• Prepared the Test Plan, Test Scenario and Test Cases based on Functional Specification Document.
• Provided review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.
• Performed Data profiling, Data Validation and Data Integrity and Data Cleansing.
• Performed Interface and Integration (SIT) Testing and Regression Testing.
• Conducted User Acceptance Testing with UAT test scenarios.
• Validated the MSTR Report format and data validation against the DB.
• Wrote and executed SQL queries for data validation and backend testing.
• Worked with Database testing Involved in Data Migration Testing and preparing documents.
• Found and reported defects and subsequently validated the fix, repeating the process until the defect was closed.