SUMMARY:

• Accomplished and result - driven QA professional with 10+yrs of experience IT field, specialized in Oracle, CRM and Web based applications. Integration and Customization of Siebel 8.01 & Sales force.
• Expert in functional, regression, system, end to end, usability, exploratory, smoke, B2B and UAT testing.
• 5+ years of experience in healthcare industry and has good knowledge of HL7, EDI standards and HIPAA.
• Worked extremely hard and effectively to bring the level of system and regression testing to a much higher standard for the ICRS tools, ensure the stability of the applications by the drastic reduction of defects.
• 2+ years of experience in ETL/ Data warehouse backend testing using Informatica & Talend.
• Worked on HL7 integration projects for Confidential and various other third party clinical applications for multiple hospital facilities in USA.
• Expert in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in Automation using QTP, Load Runner and Test Director.
• Experience in using Test Management tools like HP Quality Center, ALM JIRA and Test Director for Bug Tracking and Defect Reporting.
• 2 +years of experience in automation testing using QTP and Selenium.
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control.
• Experienced in Testing on Multi-platform Client / Server applications and Web based applications.
• Experience in both Manual & Automated testing on client-Server applications.
• Outstanding dedication to customer service and client relations demonstrated by successfully delivering mission critical applications.
• Strong testing quality Assurance Experience within Agile, Scrum Methodologies.
• Comprehensive knowledge of performing end to end testing of ecommerce software, UI, and software testing.
• Vast knowledge and experience in Health Care industry, experienced in testing different healthcare ERP solutions such as FACETS, Med Plus, EPIC and other claim processing solutions.
• Extensive SOA and Web Services experience on different technology stacks.
• Experienced in testing high performance multi-layered applications including SOA, Web and legacy applications with SOAP UI.
• Mentored other team members on the development & support of HL7 interfaces for clinical applications.
• Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from initiation and definition to deployment and support.
• Closely working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Knowledge of Hospital Billing, Charge and Revenue Codes (CPT), HCPCS, ICD-9-CM, ICD-10 code books, f Prelude/ADT, EpiCare IP, Ambulatory, Resolute PB/HB and HIM, CMS 1500 professional claim forms and UB-92 hospital claim forms.
• Hands on experience in Banking Domain, Health Care with Web based applications.
• Experience in SQL and PL/SQL scripting, Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W. Tested the ETL Informatics mappings and other ETL Processes (Data Warehouse Testing) Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Experience in Reports testing in Crystal Reports XI Environment.
• Excellent at Problem Solving, Root Cause Analysis, and problem Solutions based on Impact and Risk.
• Analyze, document, and verify system change requests (defects, enhancements, new features).
• Flexible and fast learner; quickly becomes proficient with new technologies as required.
• Ability to lead a group facilitate work as team & independently and within a team, and very good team player and Enthusiastic with Excellent inter-personnel skills. Mechanical Focus and Discipline, High Work ethics, Reliable Organizational and multi-tasking skills, Strong Quantitative and Problem Solving skills, Patient and Professional attitude

PROFESSIONAL SKILLS:

Testing Tools: QTP, SOAPUI, QAComplete, Test Complete & Selenium

CRM: Salesforce & Siebel, Informatica and Talend

Source Control Tools: Microsoft Visual Source Safe 6.0 and PVCS .7

Test Management Tools: Rational Test Manager, TFS, JIRA and Quality Center & HP ALM

Version Control Tools: VSS 6.0

Data bases: SQL Server 6.5/7.0, Oracle7.x/8i/9i and MS Access

Languages: C,TSL, Shell Scripts, Visual Basic,.Net, Java Script

Web Technologies: HTML,XML,ASP,.Net, Java Script

GUI Tools: Visual Basic 4.0/5.0,6.0 and Oracle developer 2000

Operating Systems: MS DOS, Windows, UNIX.

Methodologies: Software development Life cycle(SDLC),RUP, V-model, Waterfall, Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr QA Lead

Responsibilities:

• Lead, guide and monitor the analysis, design, implementation and execution of the test cases, test procedures and test suites.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Experience in Testing various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Union, Sorter, Router, Stored procedure, http/xml source qualifier/ xml parser/ xml generator/ transaction control
• Extensively worked onMapping Variables, Mapping Parameters, Workflow VariablesandSession Parameters
• Schedule the tests for execution and then monitor, measure, control and report on the test progress, the product quality status and the test results, adapting the test plan and compensating as needed to adjust to evolving conditions.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Developed SQL scripts to validate the databases tables and reports data for backend database testing.
• Very good inscheduling, planningfor the releases, builds, and patches for the QA testing worked with multiple releases simultaneously in QA environment.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design documents.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Scheduling and automating jobs to be run in a batch process.
• Participated actively in conference calls, project meetings and delivered input.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Used Quality Center for maintaining test plans, test scripts, execution and defect reporting.
• Involved in loading the flat files into Oracle Database and involved in writing Complex SQL Queries.

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 - Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Confidential, Bronx, New York

QA Manager

Responsibilities:

• Lead, guide and monitor the analysis, design, implementation and execution of the test cases, test procedures and test suites.
• Schedule the tests for execution and then they monitor, measure, control and report on the test progress, the product quality status and the test results, adapting the test plan and compensating as needed to adjust to evolving conditions.
• Very good inscheduling, planningfor the releases, builds, and patches for the QA testing worked with multiple releases simultaneously in QA environment.
• Participated actively in conference calls, project meetings and delivered input.
• Estimate the testing to be done and negotiate with management to acquire the necessary resources.
• Involved in the planning, monitoring, and control of the testing activities and tasks.
• In collaboration with the other stakeholders, devise the test objectives, organizational test policies, test strategies and test plans.
• Expert in HIPAA Transactions testing and in-depth knowledge of HIPAA framework (Health Insurance Portability Accountability Act) rules for ANSI X12 messages 837P, 835, 276/277, 270/271, TA1 and 997 in 4010A1 Standards.
• Also used BizTalk server as middle ware server to see responses for X 12 files like 835.
• Processed 837P, 837I & 837D transactions, verified those 837 transactions converted correctly to XML file format & XC keyword file format and verified the claims data loaded to Facets & QNXT for further processing.
• Vast knowledge and experience in Health Care industry, experienced in testing different healthcare ERP solutions such as FACETS, Med Plus, EPIC and other claim processing solutions.
• Analyzed current Claim Authorization Process across all the FACETS Markets. Identified possible constrains that pends claims related to Claim Authorization Mismatch.
• Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Set claim processing data for different Facets Module.
• Used Quality Center for preparing the test plans and manual test scripts.
• Reported defects using Quality Center.
• Involved in loading the flat files into Oracle Database and involved in writing Complex SQL Queries.
• Involved in writing Complex SQL Queries using TOAD to validate the loads & Extracts.
• Processed claims in Facets & QNXT and verified 835X12's are generated and sent to Provider.
• Processed 837P, 837I & 837D transactions, verified those 837 transactions converted correctly to XML file format & XC keyword file format and verified the claims data loaded to Facets & QNXT for further processing.
• Enrolled members through online screens and 834 transactions to Facets & QNXT..
• Tested the portal application to make sure the claims, members are loading to Facets & QNXT and Providers can check the member eligibility and claim status.
• Involved in testing the Pharmacy Claims.
• Involved in testing the Medical Claims & Dental Claims in QNXT.

Environment: TriZetto (QNXT), Salesforce, Selenium, Java, SoapUI, Microsoft SQL Server 2012, QAComplete, ANTECLIPSE, Test Complete, kanbanize

Confidential, Boston

QA Manager

Responsibilities:

• Understand the testing effort by analyzing the requirements of project.
• Prepared System Regression Test strategy document to be followed before every release.
• Conduct and participate in Status meetings to Collect Data from business users.
• Handled team of 18 and successfully implemented the project with high quality on time without any slippage in schedule.
• Identified, analyzed, and documented defects (Quality Center), questionable functions, errors and inconsistencies in firmware and application functions, outputs, online screens, and content
• Identified Integration User-Stories and Tasks during theSprint Grooming,Sprint Planning Sessions.
• Point of contact for testing team, reporting status ensuring accurate coverage of requirements and business processes.
• Validated mappings of 15022, 2022 SWIFT files.
• Loaded XML files into UNIX environment on a daily basis.
• Prepared testing environments and Test Data, and conducted Smoke/Sanity testing, Positive testing, Negative testing, Error Conditions testing, Equivalence Partitioning, and Boundary Value Analysis for TEMS V3.3, V3.4
• Tested the functionality of Eagle Application according to the functional specification document, matched the test cases to the specifications using traceability matrix.
• Performed User profile Testing (authentication), Functional testing, Negative testing and End to End Testing for Eagle Application.
• Performed user profile testing, functional, negative and end to end testing for eagle application.
• Tested fair value balance system and single family non-accrual for current to loan value estimations.
• Verified proper data mapping and storage was complete and accurate.
• Used sql queries to extract data from accounting journal tables to verify output data of the reports.
• Tested the functionality of Eagle application according to the functional specification document, and matched the test cases to the specifications using traceability matrix
• Validated SWIFT files, XML files and UNF files.
• Compared the output XML files with the development.
• Error log files are attached to defects, send to development team to resolve the issue.
• Validated EDI mapping changes and VIF Loader changes.
• Prepared testing environments and Test Data, and conducted Smoke/Sanity testing, Positive testing,
• Experienced with Device Anywhere 5.0, PuTTY, and WinSCP to track application server requests in Linux.
• XML upload through winscp and verify WSDL files.
• Test execution in SOAP UI tool.
• Identified application defects to minimize number of steps to reproduce the problem
• Performed browser (IE, Firefox, Chrome, Safari) and applications android compatibility testing in virtual machine environment
• Identified and isolated software defects and reported them via HP ALM.
• Motivate the team in identify of reusable scripts and project optimization across the projects.
• Actively participated in QA team meetings and discussions
• Compared the expected results with the actual outcome and recorded the results.

Confidential, Hillsboro, OR

Sr QA lead

Responsibilities:

• Hands on Experience with EMR (Electronic Medical Record) & CPS (Centricity practice solution) Applications
• Hands on experience setting up sever set up for EMR (Electronic Medical Record) & CPS (Centricity practice solution) Applications.
• Excellent experience on HCPCS, ICD-9-CM, ICD-10 code books, and knowledge on Prelude/ADT, EpiCare IP, Ambulatory, Resolute PB/HB and HIM, CMS 1500 professional claim forms and UB-92 hospital claim forms.
• Outstanding dedication to customer service and client relations demonstrated by successfully delivering mission critical applications.
• Mentored other team members on the development & support of HL7 interfaces for clinical applications Good Experience in validating immunization migration tool
• Good knowledge in drug interaction with ICD-9 & ICD 10,
• Build, test and Deploy HL7 interfaces on Confidential Data gate interface engines
• Hands on Experience setting up Knowledgebase for EMR (Electronic Medical Record) & CPS (Centricity practice solution) Application experience that includes all phases of EMR implementation; workflow analysis, project planning, design, build, validate (DBV), ‘go-live’ training delivery for the providers, nurses, patient service representatives, patient care technicians, clerks, etc., and post go-live support and optimization
• Tested software applications in a highly complex server environment.
• Documented workflows and executed comprehensive training plan to medical staff that more than doubled EMR & CPS access (from 45% to 100%) and usage (from 35% to 95%)
• Analyzed all aspects of Win 2003 Pro deployment for 12,500 workstations nationwide to ensure a smooth migration. Created desktop standardization and dashboards and provided ad-hoc reports using MS Access and SQL Query Analyzer.
• Solid understanding of QA test and bug reporting concepts
• Understand the testing effort by analyzing the requirements of project.
• Assign task to team members and ensure that all of them have sufficient work in the project.
• Development of overall test strategies, test plans for manual testing including Definition of test cycles and schedules, creating test data, executing tests Interfaces, documenting and analyzing test results using the Quality Center extensively.
• Arrange the hardware and software requirements for the test setup
• Keeping track of the new requirement from the project.
• Forecast / Estimate the project future requirements
• Provide training and assistance to the team/trainees to ensure they follow the testing and defect reporting process and concepts
• Have meetings with team on weekly basis and frequently status check meeting with the team.
• Check for timely delivery of different milestones.
• Motivate the team in identify of reusable scripts and project optimization across the projects.
• Act as the single point of contact between Development and testers for iterations testing and deployment activities.
• Track and report upon testing activities, including testing result, test case coverage, required resources, defects discovered and their status, performance baselines. etc.
• Involved in testing Components like Organization Administration, Applications, Portfolios, Application Administration, Billing and Business Process Administration
• Conducted various types of testing like Functionality, Integration and Regression.
• Modifying the Test Scripts as per the new enhancements.
• Validated the data from Front End to Back End tables in Oracle Database
• Performed backend testing by creating and executing SQL scripts
• Performed interface testing between Java and Siebel application.
• Monitor and track high Priority defects on day-to-day basis.
• Participated scheduled meetings with Development team and Business analysts.
• Validated XML documents and schemas using EAS (Enterprise audit service).
• Executed, loaded and validated XML packages with a large amount of client data into the Siebel application.
• Work with the billing software vendor to make sure that the ICD-10 codes that are likely to be used immediately upon transition are programmed into the software.
• Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances.
• Reported software defects in Test Director and interacted with the developers to resolve technical issues.
• Run test on application to check that the application functions as expected.
• QA review of Design Requirements.
• Interact with Business analysts to review the Functional testing
• Closely worked with Business analysts and developers to nail down the technical problems

Environment: EMR9.8 (Electronic Medical Record) &CPS 12.0 (Centricity practice solution) Oracle11g, Java, HP ALM, VBScript, Windows 8 professional, and RBMS Mainframe. ETL Informatics, Asp.Net Oracle11 g, VBScript, ALM, Clear Quest

Confidential, Jacksonville, FL

QA Lead

Responsibilities:

• Act as the single point of contact between Development and testers for iterations testing and deployment activities.
• Track and report upon testing activities, including testing result, test case coverage, required resources, defects discovered and their status, performance baselines. etc.
• Analyzed business requirements, and Functional requirements and Involved in writing detailed test cases for the Integration testing and system testing.
• Development of overall test strategies, test plans for manual testing including Definition of test cycles and schedules, creating test data, executing tests Interfaces, documenting and analyzing test results using Mercury Quality Center extensively.
• Conducted various types of testing like Functionality, Integration and Regression.
• Check for timely delivery of different milestones.
• Conducted Exploratory testing for the Retail application to gather requirements
• Involved in testing Components like Organization Administration, Applications, Portfolios, Application Administration, Billing and Business Process Administration.
• Testing the Achieved service request from different screens and retrieves the requests.
• Keeping track of the new requirement from the project
• Forecast / Estimate the project future requirements
• Arrange the hardware and software requirements for the test setup
• Assign task to testing team members and ensure that all of them have sufficient work in the project.
• Prepare the agenda for the meeting, for example: Weekly Team meeting etc.
• Frequent status check meeting with the team.
• Check for timely delivery of different milestones.
• Conducted Exploratory testing for the Retail application to gather requirements
• Modifying the Test Scripts as per the new enhancements.
• Validated the data from Front End to Back End tables in Oracle Database
• Performed backend testing by creating and executing SQL scripts
• Monitor and track high Priority defects on day-to-day basis.
• Participated scheduled meetings with Development team and Business analysts.
• Responsible for validating the Different Benefits to the different health plans depending on the Business requirements.
• Validated XML documents and schemas using EAS (Enterprise audit service).
• Executed, loaded and validated XML packages with a large amount of client data.
• Log project related issues in the defect tracking tool identified for the project.
• Run test on application to check that the application functions as expected.
• Used BMC toot to trace the defect code that is integrated with the mercury quality center.
• Developed UAT plan and test case scenarios to guide a select group of key end-users in testing user interface and functionality of the application.
• Successfully Completed User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.

Environment: Oracle9i, Java, Mercury Quality center 10.0, VBScript, Windows XP professional, RBMS Mainframe. ETL inforormatica

Confidential, Reading, PA

Sr QA Analyst

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements, creating and executing test cases.
• Compared the expected results with the actual outcome and recorded the results.
• Working with the Development & Business team for process improvement and release planning.
• Analyzed application data using the SQL to identify the ETL processesModifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Created some macros in Teradata to load the test data in to Target tables.
• Involving in Testing Crystal Reports for the data validation in Sim Corp Project Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts. Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: /Tools: HP Quality Center, Teradata R6, Oracle10g, QTP, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting

Confidential, Milwaukee, WI

Siebel QA Analyst

Responsibilities:

• Review Business Requirements and Specifications and understand the scope of the application
• QA review of Design Requirements.
• Written test plans and test cases for Integration Testing and System Testing using business requirements and design documents.
• Wrote test cases and test scripts for the functionality testing.
• Interact with Business analysts to review the Functional testing
• Manage defects and assign to developers using Test Director.
• Performed System Testing, Integration Testing, End to End Testing
• Validated the data from Front End to Back End tables in Oracle Database.
• Participated scheduled meetings with Development team and Business analysts.
• Monitor and track high Priority defects on day-to-day basis.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes
• Closely worked with Business analysts and developers to nail down the technical problems
• Reported software defects in Test Director and interacted with the developers to resolve technical issues

Environment: Siebel eMedical 8.0 Asp.Net Oracle9i, VBScript, Windows XP, Manual Testing, Test Director8.0

Confidential, New York,NY

QA Tester

Responsibilities:

• Work with Leads and Campaign module
• Reviewed Business Requirements Documents and the Technical Specification.
• Attended Technical Design meetings to understand in depth of the application.
• Written test plans, which detailed the testing scope, strategy, Hi-level test requirements, and necessary resources.
• Documented Manual test cases corresponding to business rules and other operating conditions.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Involved in business requirements, user requests and bugs Scrubs meetings
• Wrote test cases and test scripts for the functionality testing.
• Performed End-to-End testing manually.
• Closely worked with developers and System Engineers to nail down the technical problems
• Performed Regression testing.
• Involved in the documentation of training material of this application.
• Used Win Runner for testing system’s GUI, functionality, verifications and validations.
• Used Load Runner to create and define virtual users of different simulation groups to test the load, stress and performance of the web site.
• Used Win Runner data driven test to populate LOV through Call center

Environment: - Siebel Finance 7.0/7.5.2,java Win runner, TestDirector7.6, Load runner, Windows NT and UNIX