SUMMARY

• 6 years of Professional Experience in Software Quality Assurance Testing in different environments and platforms.
• Excellent understanding of entire Software Development Life Cycle and Testing Process, Techniques and Strategies
• Experience in Healthcare System with prime focus on Claims, Provider, Eligibility and Prior Authorization.
• Extensive experience in Manual Testing, ETL testing and quality assurance of Client/Server and Web applications in different domains like Healthcare Insurance, Banking and Confidential .
• Good working noledge of Claims Processing, HIPAA Regulations and 835, 276, 277 Transactions for health care industries.
• Extensive experience in reviewing Business Requirement Documents, Functional Design, Technical Design Documents and preparing Test Cases, Test scripts and Execution.
• Experience in creating Test Plans, Test Case Procedures, Test Scripts, Test Logs and Test Reports.
• Experience in performing different types of testing like Sanity, Smoke, Functional, Integration, Regression, Ad - hoc, System, Security Testing and User Acceptance Testing (UAT).
• Expertise in Silk Central and HP Quality Center for complete Test Management.
• Expertise in developing Automation Frameworks for Web Applications using QTP.
• Extensively using SQL, MS-Access, Oracle in querying backend DB tables for Data Validation and Verification.
• Proactively interacting and collaborating with Business Analysts, Technical Analysts, and developers while designing the test cases and understand the appropriate data required for testing to achieve the goal within the stipulated time.
• Experience with implementation of ETL Processes. Knowledge in OLAP, DataWarehouse, DataMart Concepts and methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Highly adaptive to a team environment and proven ability to work in a fast paced environment with excellent communication skills.

TECHNICAL SKILLS

Testing Tools: HP Quality Center, Silk Central, QTP, Load Runner

ETL Tools: Informatica

BI Tools: COGNOS 8.4/8.3/8.2/8.1, Impromptu 7.x/6.x

Web Reports: Report Net 1.0/1.1, Impromptu IWR 7.x/6.x, Crystal Reports XI/10.

RDBMSTools: Oracle10g/9i/8ii,SQL*PLUS,XQMF,TSO,TOAD,SQLServer2005/2000.

Databases: MS SQL Server 2000/2005, Oracle 8i/9i/10g, MS Access, DB2.

Languages: C, C++, SQL, PL/SQL.

Web Technologies: IIS, Apache, JavaScript, XML, HTML, Front Page, CSS and VBScript.

Applications: MSOffice(Word,Excel,Access),Windows95/98/2000/XP/7,Linux,UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NC

MANUAL Tester

Responsibilities:

• Involved in complete testing phases of the NCMMIS Medicaid Health Insurance project.
• Involved in Testing of various builds of Customer Service Requests (CSR’s) like Provider, Recipients, Claims,Prior Approvals, Managed care, Customer reports (SAS reports).
• Participated in walkthroughs for Use case analysis and reviews with Business Analysts and developers establishing quality policy conformances to prepare Test cases and test scenarios.
• Designed the Test cases for all assigned CSR’s in Silk Central and executed them with proper Test data.
• Interacting with PEGA screens to perform validation of background check details of Provider using WSDL/XML file in SOAPUI.
• Prepared test data prior to test execution and executed the test cases, validated the actual results against the expected results.
• Performed Functional, Integration, Regression Testing and logged the defects that occurs in each testing phase/cycle.
• Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Tested the EDI 837 claims, Developed test cases and test scripts for all Institutional and Professional HIPAA Transactions.
• Responsible for validating claim transactions, both sent/received.
• Data manipulation of the X12 files in order to get the desired results with respective to negative testing.
• Good understanding in loops, segments and elements in the file.
• Involved in Testing of creating new Pega process to generate Prior Approval Rejection Letters to Providers and sent them to Providers Inbox.
• Involved in testing of Provider enrollment, re-enrollment, manage change requests and re-verification processes.
• Involved in Testing of Provider Termination process, Online Entry of Termination Reason Codes to terminate a provider from Health Plans/Benefit plans, CCNC/CA program /Accreditation and notify provider termination through a letter.
• Submitted JCL’s in Mainframe to assign Recipients from Terminated Provider to an ACTIVE provider or an exempt number.
• Verified and Validated the customer reports generated in FILENET, REPORT2WEB tools.
• Extract Output files using File Manager and Wrote complex SQL Queries in XQMF to perform data validations for various letters and reports.
• Performed User Acceptance Testing (UAT) to ensure that proper functionality is implemented.
• Report the daily status of test case execution summary to Project Teams.

Confidential, MA

Automation Tester

Responsibilities:

• Implementing business requirements, system requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Developed automated test scripts using QTP to perform Functional and Regression testing of web based applications.
• Performed Integration Testing, System Testing, Regression Testing, User Acceptance Testing (UAT), Performance and Back End testing of an application.
• Involved in developing detailed Test plan, Test cases and test scripts using Mercury Quality Center for Functional and Regression Testing.
• Tested application on different web browsers and different platforms for compatibility.
• Analyzed test results and prepared analysis reports based on QTP scripts.
• Automated test cases using QTP and enhanced scripts in QTP using different checkpoints, parameterization of data and inserting synchronization points.
• Used Reusable actions to avoid lengthy test scripts.
• UsedVB DescriptiveProgrammingfor object identification and created and maintained Function Libraries.
• Used Quality Center to track and report system defects and bug fixes.
• Performed Data Driven Tests to test the application functionality with different test data using Quick Test Professional.
• Data validation and Database integrity testing done by executing SQL statements.
• Performed quality assurance reviews on all System Development Life Cycle.

Confidential, NYC

MANUAL/Automation Tester

Responsibilities:

• Analyzed source to Target data mapping and developed test scenarios to verify the data migration from different data sources.
• Designing test cases and test suites, tracing them to requirements and executing them in QC.
• Preparation of status reports and defect reports for daily status meetings and sending them to all the stakeholders of the project.
• Created Automated Test Scripts in VBScript using QTP and automate regression test suites.
• Prepared Functional Libraries having reusable functions written in VBScript.
• Extensive use of UNIX commands to move Source files to ETL QA Server
• Performing Test data set-up in XML for Testing and update Test data based on the Requirements.
• Established Database connection by developing VB scripts inorder to validate the data transformed from source to target according to transformation logics.
• Involved in testing different kinds of informatica transformations like Summary, filter, Sort, Rank, Aggregator etc.
• Developing SQL queries to compare data in source and target databases.
• Responsible for the validation of any additions/modifications to the Cognos reports before released to the production environments.
• Managing testing of enhancements and customizations of existing ETL processes.
• Conducted Knowledge Transfer and Training Sessions for new Team Members.
• Worked in onsite-offshore model wherein regularly interacted with offshore through emails and weekly status calls.

Confidential

Manual Tester

Responsibilities:

• Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables and suggest any corrective action.
• Developed test cases from different Use cases, flow charts and executed them
• Performed Positive testing, Negative testing, Functional testing, Navigational testing, and Regression Testing in different phases.
• Working with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation and actual ETL functionality (properly processing good data i.e., transformations, calculations, and derivations).
• Responsible for the validation of any additions/modifications to the reports before release to production.
• Testing reports in cognos using review checklists for Quality Assurance before delivering to the end users.
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Extensively used Oracle and SQL/PL-SQL to perform backend database testing for data integrity.
• Defect tracking is done in QC to add, review, repair and analyze defects.
• Worked closely with development staff to resolve the defects and testability issues throughout Software Test Life Cycle.

Confidential

Automation Tester

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Performed Functional, Integration and System Testing and logging the defects that occurs in each phase of the respective testing.
• Involved in testing of each phase of the application using Quick Test Pro and Quality Center.
• Identify the common Automation flows so as to write the QTP functions and also write the Generic functions such as Verifying the Pages and Entering Data on Pages etc.
• Created object repositories to store the information of objects present on Web and windows based application.
• Checked the Integrity of the Backend Data by creating Database functions and also by Database Check Points using QTP.
• Created test input requirements and prepared the test data for Record and Playback testing.
• Extensively used SQL to perform backend database testing in data integrity test.
• Performed User Acceptance Testing (UAT) to ensure that proper functionality is implemented.
• Organized Test Cases, defect tracking and document the test data for both Manual and Automated Tests in Quality Center tool.
• Defect tracking is done in QC through Defects Tab to add, review, repair and analyze defects.