SUMMARY:

• Over all 11 years of experience in Software Quality Assurance as Sr. QA Analyst. Has strong understanding of various phases of software development life cycles and has ability to understand the business model and client requirements.
• Have good experience in testing SOA, waterfall and Agile environments.
• Have good experience in writing hands on QTP scripts.
• Have good experience in testing the applications on mobile.
• Have good experience in testing the web based testing and ETL testing by using Informatica & Datastage tools.
• Have good experience in creating test data and to verify the test conditions and test cases.
• Good experience in testing the products by using XML, HL7, EDI messages in Healthcare, Insurance and Pharmacy domains.
• Worked in second line production support to fix the data correction issues in SQL by directly interacting with various clients.
• Have experience in Analysis of Software Requirement Specifications and development of Test Scripts, Test scenarios, Test Cases based on the Requirement Specifications.
• Involved in all phases of testing such as Smoke Test, Functional Testing, Integration Testing, System Testing, Regression Testing, Security Testing and ad - hoc Testing.
• Executed Test scenarios and business process test cases to verify the design and functionality of applications as per user requirements
• Have good experience in preparation of TRM (Traceability Matrix), Release/ Defect Matrices.
• Good knowledge on SDLC, Test Life cycle, Test methodologies like Agile & Scrum.
• Held the lead position for Application Support Team and contributed knowledge to my team members.
• Worked with various clients to resolve business impact data correction issues in backend.
• Excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

Testing Tools: Test Director 8.0Quality Center 8.2/10.0QTP 9.2Load Runner 7.0Silk Test 2010 R2

Languages: SQL*PlusC/C++VB, .NetXML/HTMLJava, J2EE, Java Script,PHP

BI Tools: Business Objects XI r2/6.5.1/5.xCognos 8.0/10.0

ETL Tools: Informatica 8.6Ab InitioData Stage 8.5

Database Technologies: MS Access Oracle 8i/9i/10g/11g Toad 8.0/9.0, Oracle SQL developer 1.1.3 MS SQL Server 2000/2005 Tera Data 8.0 DB2

Operating Systems: Windows 2003/2000/XPUNIX

PROFESSIONAL EXPERIENCE

Confidential, Arlington, TX

QA Tester

Responsibilities:

• Worked as a test lead and involved in creation of Test plans, Test Strategy & Test Scenarios and Test Scripts by using the mapping documents.
• Involved in analysis of source to target mapping documents.
• Involved in code reviews, mapping reviews.
• Involved in preparation of test data.
• Imported the flat file into database and excel sheet and validated the data to find duplicates and null values.
• Involved in validating the job which are developed in IBM Data Stage.
• Involved in testing of integrated clinical data such as Immunization data, Pharmacy data, Lab Tests & Results, ICD 9 & ICD 10 coding data in back end by using SQL queries & Joins
• Involved in migration testing from DB2 to Netezza and data profiling.
• Involved in writing the automation scripts to check the source and target data by using NZDQL.
• Involved in importing the sequential files into database and validated data by using SQL queries.
• Involved in profiling the clinical and financial data.
• Involved in validating the Cognos reports.
• Involved in validating the source and target data in the EDW.
• Worked closely with the developers on review and resolution of issues.
• Prepared traceability matrix.
• Logging the bugs into defect tracking tool.
• Prepared status report and send them to managers.
• Involved in the defect tracking meetings, Agile/Scrum meetings and Implementation meetings.
• Involved in reviewing the Unit Test Plans.
• Implemented the QA process to the new QA team.

Environment: IBM Data Stage 9.1, Aqua Data Studio 12.0.6, Fast Track 9.1, DB2 9.x, Netezza 2002, SQL 2008, Oracle 10g, Cognos 10.0, Quality Center ALM 11.0, QC ALM 11.0, Windows XP/7.0, Unix.

Confidential, Nashville, TN

Sr.QA Analyst/ Tester

Responsibilities:

• Worked as a test lead and involved in creation of test plans, scenarios and scripts by using requirement documents.
• Involved in testing of integrated clinical data in back end by using SQL queries & Joins.
• Involved in profiling data.
• Involve in testing of clinical rounding reports on mobile device and web portal.
• Involved in testing of integrated GE RAD PACS, GE CV PACS, GE billing & FUJI ROSE applications.
• Involved in testing of Patient Keeper web application.
• Involved in validating ICD-9, ICD-10 and Snomed coding systems data by using NZSQL.
• Involved in validating the patient billing data.
• Involved in analysis of defects and found the root cause of the defect.
• Involved in preparation of traceability matrix and involved in risk mitigation meetings.
• Involved in preparation of defect tracking reports and send them to managers.

Environment: Meditech 5.6/6.0, Mainframe, JAVA, IBM Data Stage 8.5, Netezza 2002, Crystal Reports 10.0, QTP 10.0, Quality Center 10.0, Android, iPhone OS 3.0, Blackberry, Windows XP.

Confidential, Upper Saddle River, NJ

QA Analyst

Responsibilities:

• Involved in creation of detailed test plan and test cases from the Business Requirements Document.
• Involved in creation of test data by using the Business Requirement Document.
• Involved in white box testing to test the maps.
• Importing the maps to Informatica and extracting the data by running the sessions.
• Involved in validation of transformations, aggregations and look ups.
• Involved in creation of metadata database.
• Involved in loading of data into database through UNIX.
• Involved in testing of Online Information Exchange (ONIX) messages by using Altova XML spy.
• Involved in validation of XMLs and XSDs.
• Involved in Agile-Scrum meetings.
• Involved in testing of source and target data base count by using the SQL queries.
• Involved in preparation of weekly status reports and status meetings.
• Logged defects in defect tracking tool.

Environment: AbInitio 3.2, Autosys, Tera Data 8.0, PL/SQL, Cognos 8, JMS Topic, HTML, Java Script, Linux, Windows XP, Altova XML Spy, JSMQ, Exam XML.

Confidential, Mount Prospect,IL

QA Analyst

Responsibilities:

• Developed source definitions for relational and flat file sources.
• Prepared Test Cases and Test Plans for the mappings.
• Involved in testing of bank website.
• Involved in creation and modification of test data.
• Created scenarios and wrote and Executed QTP automation scripts.
• Involved in extensive DATA validation using NZSQL queries and back-end testing.
• Involved in testing of Operational Data Sources.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in finding the root cause analysis of identified defects.
• Used Quality Center to track and report system defects.
• Involved in sprint meetings.
• Worked on issues with migration from development to testing.

Environment: IBM Data stage 8.5, Netezza 2002,XML, ASP.Net Framework 2.0, SQL 2005, Unix, QTP 9.2,T-SQL,Toad, Windows NT/XP/2000, Quality Center 9.0, IBM Rational Clear Quest 7.1.

Confidential, Burlington, NC

QA Analyst

Responsibilities:

• Worked as ETL test leader and co-ordinated the testing activities with cross functional teams.
• Involved in gathering and analyzing Business and System Requirements as well as functional and technical specification documents.
• Involved in testing of HL7 messages and EDI transactions 835.
• Involved in testing of ICD 9/10 coding systems.
• Involved in testing of web services.
• Involved in creation of meta data database using Data modeling principles.
• Extracted data from Relational Sources in the form of flat files by using Informatica.
• Prepared Test Cases and Test Plans for the mappings developed through the Informatica tool.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.
• Performed data analysis by using sql profiler and prepared data mapping excels.
• Written several complex SQL queries for validating the migrated data.
• Checked the performance of the SQL server by loading huge amount of data.
• Preparing status reports and sending them to leads.

Environment: Java/J2EE, QTP 9.0, Quality Center 9.0, Oracle 9i, Informatica 8.1, IBM Rational Clear Quest 7.1, Unix.

Confidential

Sr. Quality Engineer

Responsibilities:

• Created staging database by using metadata.
• Validated Informatica mappings, workflows and extracted the data in flat files by using DTS.
• Created and executed SSIS packages.
• Verification of XML files, Source excels, Target Excels, Release Notes and Snapshot Documents.
• Imported the metadata XMLs, DTRs (Data Retrievals) into LDMS and validated the XMLs as per the business logic.
• Added indexes to the DTRs to increase the performance.
• Validated the Lookups, Expressions and Validations as per the business logic in requirement specification.
• Fixed data related issues in SQL server and cleared the transaction and audit log files.
• Executed the packages to load the data into target database.
• Performed the Database Validation and UI validation with the migrated data to check whether data is getting populated or not.
• Involved in testing of webservices.
• Involved in testing of HL7 messages and Lorenzo Product website.
• Involved in testing of ICD 9/10 coding systems.

Environment: C#.Net, .Net Framework, SQL Server2005/2008, Windows 2000/XP, MS Visual Studio 2005/2008, IBM Rational change 5.2,SSIS, IBM Rational Clear Quest 7.1.

Confidential

Quality Engineer (Test Lead)

Responsibilities:

• Worked as Test Lead and contributed the product knowledge among the team members.
• Involved in customer support to analyze issues in backend by interacting directly with clients.
• Involved in testing of Patient application administration, Clinical, Medical and Billing modules.
• Written Test cases for requirements for enhancements
• Involved in testing of HL7 messages by using XML spy and EDI transactions.
• Involved in testing of ICD-9 & ICD-10 coding systems.
• Involved in testing of healthcare insurance claims 835 & 837.
• Written test scenarios and documented the test result as they are executed.
• Performed User Interface Testing, Integration Testing,System Testing & UAT.
• Logging and keeping in track of defects.

Environment: VB, Mumps, MSMQ,SQL 2000, Oracle 8i/9i, Toad, Doors, Test Director, Windows, iAssist.