SUMMARY

• Over all 9 years of experience in Software Quality Assurance as 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 knowledge on system administration creating DHCP & DNS Servers.
• Have good experience in testing the web based testing and ETL testing by using Informatica.
• 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.0

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

BI Tools: BusinessIntelligenceXIR3/XIR2/6.5.1/5.xCognos 8.0

ETL Tools: Informatica 8.6Ab InitioData Stage

Database Technologies: MS AccessOracle 8i/9iToad 8.0/9.0, Oracle SQL developer 1.1.3MS SQL Server 2000/2005

Operating Systems: Windows 2003/2000/XPUNIX

PROFESSIONAL EXPERIENCE

Confidential, TN

QA Analyst

Responsibilities:

• Worked as a test lead and involved in creation of test strategy, test plan, project metrics, scenarios and test cases by using requirement documents.
• Participated in functional and technical specifications reviews.
• Involved in entering the data in Meditech and checked the HL7 outbound messages.
• Involved 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 in SOA environment.
• Involved in testing of ICD-9, ICD-10, CPT & Snomed coding systems.
• Involved in testing EDI claims 835 & 837.
• Involved in data mining and validating the data in backend by using sql server.
• Involved in testing of web services by using SOAP UI.
• Involved in creation of automated scripts by using QTP.
• Involved in creation of Vuser scripts to check the performance of application.
• Involved in defect tracking and agile scrum meetings.
• Involved in User Acceptance Testing.
• Involved in preparation of defect status reports and send them to managers.

Environment: Meditech 5.6/6.0,AS/400, Mainframes, Java, Business Intelligence 11.0,HTML, QTP 10.0, Informatica 8.1, Quality Center 10.0,Oracle 9i,Andriod, iPhone OS 3.0, Blackberry, iPad, Fiddler, Window 2000, Unix, Linux.

Confidential, NJ

Lead 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 webservices testing by using REST.
• Involved in creation of metadata database using Data modeling principles.
• 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 testing of source and target data base count by using the SQL queries.
• Wrote and executed the automation scripts in QTP to check the functionality of application.
• Involved in testing of webservices.
• Involved in automation of scripts and logging of defects in defect tracking tool.
• Involved in preparation of weekly status reports.
• Participated in Scrum meetings.

Environment: Talend, Oracle SQL Developer 2.1, Java, Java Script, Mainframes, HTML, Unix, QTP 10.0, Quality Center 10.0, Altova XML Spy, XSD, WSDL,JSMQ, Doors, Linux.

Confidential, Burlington, NC

QA Test Lead

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 webservices testing by using SOAP UI.
• 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: C#.Net, QTP 9.0, Quality Center 9.0, Oracle 9i, Informatica 8.1, IBM Rational Clear Quest 7.1, Unix.

Confidential, Mount Prospect, IL

ETL Test Lead

Responsibilities:

• Developed source definitions for relational and flat file sources.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Wrote and Executed QTP automation scripts.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in testing of Operational Data Sources.
• Involved in security testing.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Used Quality Center to track and report system defects.
• Worked on issues with migration from development to testing.

Environment: XML, ASP.Net Framework 2.0, SQL 2005, Unix, QTP 9.2,Oracle 8i,Toad, Windows NT/XP/2000, Quality Center 9.0, IBM Rational Clear Quest 7.1, IBM Security AppScan 8.0.

Confidential

Sr. Quality Engineer

Responsibilities:

• 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.
• Followed the Waterfall model.
• 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, SQL 2000, Oracle 8i/9i, Toad, Doors, Test Director, Windows, iAssist.