SUMMARY

• 8 years of testing experience on Web based application, Client Server application, Desktop Application, Data warehouse and manage production support issues
• Hand On experience on Product support tool (IT Service Management tool) Such as: Service +, ServiceNow and BCMR.
• Experience in Software Development Life Cycle (SDLC) as well as Software Testing Life (STLC) and Role of QA in different testing mythologies like Agile, Scrum and Waterfall etc.
• Expertise in preparing test strategies, test plans, test summary reports, test cases and test documents based on user/business requirement documents
• Extensive knowledge of project planning/execution skills, defining statement of work, project metrics, requirement definition, evaluation, test design, development, implementation
• Experience in establishing QA Procedures to meet QA Standards, documenting the Testing Procedures, Test scenarios, writing in - depth Test Cases to meet the business requirements
• Experience in Manual Testing, functional Testing, Smoke Testing, Sanity Testing, Test Data Driven Testing, Regression Testing, User Acceptance Testing, End to End Testing, System Testing and Data validation
• Ability to work closely with business analysts, project owners and developers to understand requirements and transfer them into business tests
• Experience in HP ALM, TFS, JIRA, MTM, ServiceNow, Service+ Quick Test Professional (QTP), LoadRunner and SoapUI
• Good knowledge on Visual Studio, Dreamweaver, HTML, CSS and Bootstrap
• Hand on experience on ETL (Informatica and SSIS) testing and Reporting testing with SSRS and Crystal
• Involved with every phase of the life cycle development project, maintenance and production support project, QA environment, UAT environment and continually provided value-added services to the clients.
• Experience creating Testing Matrix, Assist in process improvement, establish procedure Traceability Matrix
• Possess good interpersonal and communication skills. Strong ability to quickly learn, self-start and adopt new skills
• Ensures compliance with the customer requirements, quality policy, company standards, regulatory and external standards

PROFESSIONAL EXPERIENCE

Confidential, Carrollton, TX

QA Analyst

Responsibilities:

• Hand on experience on creating ticket and production support using Service+ and ServiceNow application
• Worked on ITSM module such as: Incident management, Major Incident management, Change Request, Problem management, and Service catalog.
• Reviewed the log file, job error and perform the data validation in production and identify the issue
• Actively involved in Root cause analyst, escalate the issue and update the status of the ticket
• Executed Test estimation, Review BRDs, communicated Business Analysts for understanding of requirements, business rules and followed Agile methodology
• Created test plans, test scenarios, test set and test cases and performed Smoke Testing, Sanity Testing, Regression Testing, End to End Testing, System Testing and UAT Testing
• Participate in Agile planning, review and test development from the user story using Jira tool
• Analyzed testing needs and designed and executed manual scripts
• Tested Web-based, Client server application and Desktop application such as E-commerce, Unify, Unisource and Dloc+
• Testing thoroughly each feature of create order, place an order, order processing, deliver the Order and Invoicing processing, manage the order in data warehouse
• Reviewed BRD, SRS to prepare Performance acceptance criteria and Conducted result analysis and communicated technical issues with developers and architects
• Performed different tests to check performance of the e-commerce applications using Performance Center
• Ran different Reports on huge production volumes to check performance of different Reports
• Reported issues in the bug reporting system and follow up with the development team
• Converted test plan and test cases in Quality Center into manual test procedures and automation scripts
• Reviewed Requirement, mapping document and transformation for ETL process
• Created test cases and perform data validation for different futures for ETL process to compare Source and Target database systems
• Tested all ETL processes developed for fetching data from OLTP systems to the target (Data Mart) using complex SQL queries
• Validate the data against the business rules, mapping document, requirements and verify that the transformed data can loaded without any loss of information during ETL process
• Performed data validation and Data Migration Testing during the Migration process
• Designs, create and run the Financial Report, Month-End Reports, Sales Report, Product Reports using SSRS report tool
• Expensively executed test cases validate test results using SQL for conversion errors
• Performed back-end testing using SQL queries to make sure that data entered has been uploaded correctly into the backend database
• Hand on experience on testing the Service layer with SoapUI
• Create and execute API test cases using SoapUI and validated WSDL, XML request and response
• Proficient in using SoapUI for testing Web Services and used several types of assertions
• Attended daily/weekly status meeting, defect review meeting, root cause analysis meeting and prepared Requirement Traceability Matrix and testing matrix
• Actively Participate in UAT testing for all releases and archived test results in SharePoint portal

Environment: HP ALM, HP 3000, Oracle, SSIS, SSRS, SQL Server, T SQL, SSMS, Unix, .Net, SharePoint, JIRA (Agile), LoadRunner, ServiceNow, Service+, Azure SQL, MS Office, SoapUI, ETL validator, Jabber, Smart Sheet, ERP environment, HTML,CSS, Siebel CRM, MS Visual Studio

Confidential, McLean, VA

QA Analyst

Responsibilities:

• Analyzed Test Design, Mapping Documents and performed test estimation
• Created test strategies, test plans, test scenarios and test case, executed and log defects using TFS
• Developed ETL jobs as per business rules using ETL design document
• Executed Informatica Workflows individually and validated the data
• Reviewing the database Test cases and performs the Database Testing when writing the SQL queries
• Performed ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) using SQL
• Tested the messages published by ETL tool and data extracted from and loaded into Data Warehouse.
• Executed test case by writing complex SQL queries to validate the Source to Target in ETLs process
• Hand on experience writing Unix commands and validate the data during ETLs process.
• Design, development and implementation of an Enrollment Resolution and Reconciliation process for health
• Analysis of discrepancies in the eligibility reconciliation process.
• Extracted the data from different sources base on scenario and analyst them and trigger the matrix base on requirement, business rules
• Created Billing and Receivables Reports and Month-End Report using Crystal Reports
• Actively worked on EDI transactions and on the reconciliation processes
• Validated the EDI Transaction HIPPA X12 834 for health insurance exchanges and performing root cause analysis
• Tested with Premium Payment transactions, start date and end date discrepancy with MIDA and EDBO FFM and Issuer Data
• Validated the enrollment reconciliation process conciliation with CMS and CEERS if any discrepancy occurs.
• Generated the report using crystal report and validate with the database
• Analyzed of discrepancies in the eligibility reconciliation process for multiple stakeholder’s continuous process improvement of the reconciliation process
• Experience creating sample claims after completion of benefit configuration to validate the fixes done.
• Actively worked on SharePoint portal to update the case status, Run the job and track the log file and analyst the root cause
• Developed reusable functional libraries, reusable script, enhance script using QTP
• Created Project, Module and specific testing level Recovery Scenario and trigger them as required in QTP
• Executed Batch Mode and Master file, communicated with Technical architects and DBA for the performance of test results
• Utilizing Dictionary object in QTP, Maintaining Test data in Excel files and Importing Excel files from Resources module in Quality center to QTP data table
• Update the project progress report in share drive and walkthrough with the client and Signoff

Environment: Oracle, TFS, JIRA (Agile process), .Net, Java, PL/SQL, SQL Developer, Unix, MS Office, SAS, Informatica, Crystal Report, SharePoint, Alter Editor, Marco, SQL Server, Transaction Management, FileZilla, WinSCP

Confidential, Tampa, FL

Functional Test Analyst

Responsibilities:

• Analyzed Design document, Business Requirement Document
• Developed Test plans, Test case, Execute, defect log, for various testing types and levels for Medicare/Medicaid enrollment process using TFS
• Involved in testing of Facets Implementation, Tested end to end testing of FACETS Membership and benefits module
• Validated different type of enrollment plan, benefit and Duplicate member in Facets, FAZAL front end with Oracle and MS SQL database
• Developed and executed DM46/Online Electronic Control/Manual enrollment Process as per plan and loaded member into FAZAL
• Enrolled the Member through DM46 file and land it in incomplete Queue (Dup Queue, CMS Queue, Fail Queue, OPS Queue, Denial Queue and Hold Queue) as per scenario
• Tested Benefit and Pricing database tables writing SQL statement
• Experience Build new Products from scratch, Variable components, Service definition, Service rules, Deductible and Limit rules etc.
• Coordinates with internal and external customers to ensure the documentation, implementation and modification of benefit plans is completed on a timely basis
• Prepared and coordinated execution schedule for jobs related to Parallel Testing, SIT/UAT and End to End Testing.
• Worked effectively on Member/Subscriber Benefit in Facets and functionality of new features, new enrollment, enhancements and Data validation in Facet
• Update project report in SharePoint folder and communicate with Business and User for approval
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity

Environment: Oracle, FAZAL, Facets, AS 400, SQL Developer, .Net, Java, TFS Mainframe, MS Office, SharePoint, Alter Editor, Oracle, SQL Server, DM 46, Jira

Confidential, Fort Worth, TX

QA Test Analyst

Responsibilities:

• Executed daily activities of test planning, test design, test scenario, test data development, test environment configuration, test execution schedule in UAT Environment
• Validated CGS, HVILA and ILA letter template in LMS application and validate the records in different servers.
• Validated Job status in Cass, resubmit the Job and review the log files for Job errors and troubleshoot them as needed
• Validated, extract the data from Production, staging Database and work with BCMR ticket for production issues
• Validated log file created by job failed and interact with different team to solve the issue.
• Participated Major incident and Root cause analysis meeting and actively update the ticket status
• Executed assigned quality control and quality assurance audit activities
• Assists in the preparation and conduction of Quality Control routines to assist project objectives
• Monitored the jobs and ensure all are processed and send to vendor printed without error
• Determined type of error and escalates such as: System error, Template errors and Data errors
• Ensured archiving process takes place as expected, escalates issues to MST when required
• Developed and executed queries to verify backend functionality and validate data front end and back end using MS-SQL
• Maintained Requirement, Test case, Execute test case using MTM and used JIRA for Defect Management
• Create Check list for UAT test case and actively participated in test execution
• Attended daily/weekly status meeting, review meetings, defect meeting and new release meeting
• Coordinated with Team lead, project manager, BA, LOB, CDT, MST, on boarding Team, Tech team and Vendor

Environment: Mainframe, COBOL, Unix, JCL, DB2, SQL Server 2008, Java, .Net, XML, Calyx Point, MS Office, AS400, SharePoint, BCMR Ticketing, MTM, MS-SQL, DB2, .Net, JIRA-Agile, T-SQL

Confidential, Alexandria, VA

QA Tester

Responsibilities:

• Participated reviewing Business Requirements, Functional and Technical specifications with business analyst and defined the testing approach and resources and timelines
• Actively involved in Functional, Regression, System, Smoke, End to End and Integration Testing
• Mapped the Requirements to Test Cases, ensured that all requirements are covered using RTM and HP QC
• Attended sprint plan meetings to review the user stories closely with Business Analysts and Developers
• Uploaded Business requirements, test scenarios, test cases and Test execution using HP Quality Center
• Tested functionality of new features, Benefit testing, Validation, new enrollment in Facets
• Conducted Load Testing for multiple users using LoadRunner
• Prepared Performance Center scenarios for Load and Performance testing
• Measured Response times at Transaction levels at web, App servers. Highly concentrated on Transactions per sec during testing.
• Performed Web Services request and response XML using SoapUI tool
• Update the end point in WSDL file as needed
• Developed and executed SQL joint to validate Test data results in Web Services and Frond end with Database
• Created Project, Module and specific testing level Recovery Scenario and trigger them as required in QTP
• Executed Batch Mode and Master file, communicated with Technical architects and DBA for the performance of test results
• Utilizing Dictionary object in QTP, Maintaining Test data in Excel files and Importing Excel files from Resources module in Quality center to QTP data table and read the values based on the functional requirement
• Analyzed functionality of X12 Transaction and validated 270, 271, 820, 834 transaction
• Good understanding of mapping documents, transformation and, business document and other ETL Processes of Enterprise Data Warehousing (EDW)
• Tested the messages published by ETL tool and data extracted from and loaded into various databases
• Executed Informatica Workflows individually and validate Source and Target by writing SQL queries to test ETL process.
• Performed data validation according to data mapping document with data conversion logics from source system and target system
• Aggregated the data at source and compared with the Target to validate Transformations
• Validated the data in Source system writing Unix commands
• Performed reports testing which include layout, data, field and export to external file.
• Attended QA Walkthrough meetings with team member this includes technical Specification review, Functional Specification review and defect tracking

Environment: Java, Oracle, SQL Developer, MS SQL Server, Facets, Informatica, SoapUI, Quick Test Professional (QTP), LoadRunner, Transaction Management HP QC, XML, Linux, JIRA, WinSCP, Crystal Report, MS Office