SUMMARY:

• Almost 6 years of experience in Quality Assurance (Manual and Automation Testing). Expertise in Analyzing and Testing (Automated using Selenium) Web - based, Mobile, Client-Server and Mainframe applications. Experience in fields of Insurance, HealthCare verticals.
• Extensively worked on each phase of the QA life cycle and involved in all the phases of Software Testing Life Cycle.
• Proficient in QA Testing Methodologies, Test cases, Test procedures by analyzing business, system and functional requirements.
• Expertise in Preparing and Executing Unit, Integration and system Test Cases.
• Expertise in performing Smoke Testing, Sanity Testing, and Regression Testing.
• Experience in testing database applications of RDBMS in ORACLE, SQL Server, PostgreSQL and Sybase.
• Expertise in Oracle SQL, Analytical functions, PL/SQL, Performance tuning, Data modeling, Data Analysis.
• Strong knowledge in developing SQL, PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links & triggers.
• Extensive hands on experience in performance tuning of SQL queries & PL/SQL programs.
• Expertise in back-end development, updating and testing using SQL queries.
• Extensive knowledge of SQL Server Management Studio for query designing and maintenance
• Expertise in User-Acceptance Test scripts and assisted users in conducting UAT.
• Expertise in developing automation framework from scratch in Selenium.
• Expertise in performing Regression Testing (Data Driven Testing DDT) by getting data from Text Files, Excel Sheets, Data Tables and Databases automatically by writing scripts in Selenium.
• Expertise in HP Tools (Quick Test Pro/UFT, ALM/Quality Center) to create, maintain and automate test scripts.
• Expertise in using Descriptive programming for dynamic applications where repository keeps changing.
• Expertise in testing Healthcare Claims (various stages in Facets).
• Extensive knowledge of HL7 messages.
• Extensive knowledge working on HIX (Healthcare.gov, MAhealthconnector.org) including EDI transactions and checking /verifying data from various HIXs.
• Experience in Testing Mobile applications by using Emulators both IOS and Android.
• Efficient in manipulating Test Scripts generated by QTP executing Functional Testing and Regression Testing using Data Driven Framework.
• Expertise in Bug Tracking Using Quality Center/ALM
• Efficiency in managing test script repositories over multiple builds, evaluating the correctness of scripts and re-scripting for enhancements and fixed defects in the application.
• Excellent communication and documentation skills with experience in presentation of highly technical material. Highly energetic professional with an ability to work independently as well as good team player.
• Experience in Defect Tracking and Reporting using Bugzilla and Quality Center/ALM.
• Working knowledge of multiple databases like Oracle, SQL Server and MS Access.
• Extensively worked on database testing (Oracle, SQL Server) and validated the applications against database by writing multiple complicated SQL queries.

TECHNICAL SKILLS:

Testing Tools: Selenium, Quick Test Professional QTP Quality Center(ALM)Other Testing Software: Quality Center, BugZilla, Doors, SAP, Perfecto Mobile, JIRA

Scripting Language: C++, Objective-C, JAVA, PL/SQL, VB Script

Databases: Oracle, MS SQL Server, MS Access, MySQL, DB2, Sybase

Web Technology: JSP, JSTL, HTML, XML, Spring MVC, Hibernate, DAO

Operating Systems: Windows, MS - DOS, Mac OS, Unix/Linux

Software Packages: Microsoft office, NetBeans, Adobe Flash Builder, Eclipse, SpringSource Tool Suite, Xcode, Vizio

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Quality Assurance Engineer

Responsibilities:

• Performed manual as well as automated testing on application
• Reviewed cross department deliverables, kept accurate record of errors and resolutions.
• Tested and verified data obtained from HIX (MA health connector).
• Verified and Validated EDI transactions from HIX
• Extensively worked on Testing Backend by writing SQL Queries.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Extensively worked on SQL - Views, Stored procedure, Functions, Packages, Triggers, Joins, Group by, Having, Delete/Truncate difference, SQL loader, Creating reports/ exporting data, Fine tuning queries
• Created of back end database procedures, functions and packages based on the technical specifications.
• Tested Healthcare Claims - Duplicates, services, ambulatory, payments in Facets
• Converted HL7 messages both manually and automatically to data for testing.
• Checks HL7 message formats from various sources.
• Performed overall Test management through Quality Center (QC/ALM) including writing requirements in Requirements Tab, Test Cases in Test Plan, Execution in Test Lab and Defects in Defects Tab.
• Maintained traceability between defects, test cases and requirements using QC.
• Helped team understand the use of QC parameters so as to convert Manual Test Cases into QTP automated Test Cases directly from QC
• Used descriptive programming in QTP/UFT where making repository was not possible.
• In-depth research and analysis was performed on legacy systems to understand data mapping for reporting purpose.
• Documented test plans for positive and negative scenarios for functional, GUI and security testing.
• Created logical execution paths of different test sets in quality center
• Generated weekly reports to track test planning and overall test management
• Worked in Agile work environment for some assignments
• Actively participated in discussions and group sessions

Environment: QC/ALM, QTP/UFT, Selenium, TOAD, Oracle 9i, C#, ASP.NET, ADO.NET, XML, Visual Studio.NET, Visual Source Safe, IIS

Confidential, Lexington, MA

Sr. Quality Assurance Engineer

Responsibilities:

• Successfully performed manual as well as automated testing on application
• Effectively interacted with Business users/Physicians/RN /Management
• Created test plans and executed test cases in an effective manner.
• Reviewed cross department deliverables, kept accurate record of errors and resolutions.
• Extensively worked on QC, EMR (Electronic Medical Records).
• Automated Data warehouse testing using Selenium
• In-depth research and analysis was performed on legacy systems to understand data mapping for reporting purpose.
• Documented test plans for positive and negative scenarios for functional, GUI and security testing.
• Prepared test data for the entrance and exit criteria in integration testing
• Created logical execution paths of different test sets in quality center
• Generated weekly reports to track test planning and overall test management
• Worked in Agile work environment for some assignments
• Actively participated in discussions and group sessions

Environment: Selenium, Quality Center, TOAD, Oracle, C#, Visual Studio.NET, Visual Source Safe, IIS

Confidential, Wellesley, MA

Sr. Quality Assurance Analyst

Responsibilities:

• Project involved testing backend on MS SQL Server and SIT (System Integration Testing).
• Verified and Tested data from MA connector HIX.
• Verified and validated data, EDI transactions both manually and automatically.
• Managed and performed backend testing of Extracts using ETL specs and designed conversion of the whole process into Automated Business Process Testing in Quality Center by using automated (QTP) Business Components.
• Tested various healthcare Claims in Facets.
• Worked on converting QTP/UFT scripts to Selenium.
• Helped develop QTP and Selenium Automation Framework from scratch.
• Wrote reusable actions and functions where-ever possible to support reusability of scripts.
• Used Test and Action parameters for all dynamic data to make sure scripts are reusable.
• Integrated QC/ALM with QTP to control both automation and manual testing through QC.
• Designed ETL specs for Testing, Reporting, Referential Integrity and Conversion Concepts.
• Created models using Agile methodologies (SCRUM) and remodeled the test cases / scripts for team to follow.
• Used Regular Expression for dynamic objects.
• Used descriptive programming for dynamic application.
• Responsible for the management of the Testing Solutions, Strategy and Analytics and made Business Process Mapping documents to make team understand who does what, what processes/strategies and standards are being followed and what/how systems are linked.
• Formed strategies and taught QA dept. the correct methods to convert existing test cases to QC test cases using Parameterization.
• MS Project and Visio Professional were used for Project Management
• Quality Center was used for overall Test Management. Project involved QC administration.
• Developed automation frame work to make efficient way to integrate requirements, test cases, scripts, defects and report utility in QC.

Environment: Java, JAVAEE, JSP, Ajax, BM Websphere, Weblogic, Facets, MS Project, MS Visio, Quality Center, Toad, SQL Server, LoadRunner, JAVA, J2EE, C, C++, BPT, Oracle, SQL Server Management Studio, SharePoint, SQL, Oracle, QTP (VB Script), Selenium, LoadRunner, SQL.

Sr. Quality Assurance Analyst / Tester.

Responsibilities:

• Automated Test scenarios for GUI, Functionality, Security, Database and Regression Testing.
• Performed Data Driven Tests using Data Tables, Data Sheets and Databases to validate the same scenario with different test data. Using QTP.
• Helped develop automation framework in QTP.
• Overall Test Management was done using QC.
• Created comprehensive test plan, methodologies, test process, and test procedures from requirements document and design documents, provided validation of multiple interfaces.
• Worked with team members to ensure testing deliverables are in compliance with the quality standards and deadlines.
• Responsible for running test scripts for applications and modules. Handled the tasks of preparing test cases and test scripts of various modules.
• Executed the automation scripts and updated the old scripts which had new UI changes.
• Prepared SQL scripts for back-end testing to check the database records, performed database updates and corrections, developed stored procedures, Functions and Database Triggers, extensively applied DDL, DML and DCL commands for definition, manipulation and controlling data.
• Performed integration and user acceptance testing. Built client relationships and managed client expectations throughout the project.
• Coordinated with internal departments including Quality Assurance, Development, and Production Support.

Environment: VB.NET, Oracle, XML, C#, Mainframe, QTP, Quality Center (ALM), IBM Rational ClearQuest, IBM Rational Doors, BPT, Automation Testing, UA