SUMMARY

• Software Test Analyst with 5.7+ years of experience in Logistic, Retail Domain, Pharmacy, having sound knowledge of Various QA Methodologies, TDM Methodologies SDLC , having sound knowledge of SOA, Data Ware House Testing, Manual Testing, Automation testing, Data Migration Testing and Test management tool Quality Center (QC) and (Jira) along with proficiency in writing SQL queries.
• Sound knowledge of SDLC and STLC.
• Knowledge of ETL/BATCH testing using Informatica and Data Stage ETL tool. SOAPUI, QTP testing tool.
• Test management HP Quality Center, HP ALM, JIRA.
• Black box testing of various applications.
• Defect logging and tracking.
• Sound knowledge of Quality Center.
• M anual Testing and practical implementation of its concepts.
• Test Case creation, Test case execution, identifying Test Strategy and creating Test Plans.
• Comprehensive knowledge of database management systems (SQL SERVER, Oracle and Teradata) and proficient in writing SQL Queries.
• Knowledge of Retail, Pharmacy and Logistic domain.
• Excellent analytical and logical skills along with a critical and technical approach.
• Training the team on various flows and processes specific of testing and projects.
• Involved in project level process documents and Matrices (Estimation, RTM etc.).
• Preparing test conditions and running the scripts in UNIX putty.
• Review of test deliverables.
• Preparation of test metrics and test reporting.
• Involved in taking knowledge session for the new members in the team.
• Used SOAPUI for checking the request/Response of the web services.
• Over 4 years of Software industry experience as a Quality Analyst (QA).
• Currently working with Confidential as the Software Testing Engineer (
• Analyze, evaluate, and review requirements for new applications and modifications to existing applications for appropriate functionality and testability.
• Creating, Managing and reviewing the testing artifacts (Test cases, Test Plan, RTM, etc.) before delivery to the client.
• Preparation, modification and validation of Test data.
• Writing and Executing SQL Queries for Data Validation.
• Following - up the issues and queries till closure.
• Involved in preparing project level process documents and maintaining the same.
• Generation of various kinds of reports and graphs from Quality Center and Jira system.
• Sending a Status Report to the client on the daily basis.

TECHNICAL SKILLS

Software/Tools Exposure: Windows XP/Vista/7/8, QC, PerfaWare, SOAPUI,QTP,MSTR reporting tool, MSTR IM,Informatica, Oracle, SQL Server, Teradata Web based, Application BasedLanguage C, SQL, JAVA, Mainframe

Operating System: Windows, Unix

Database: SQL Server, Oracle

Manual Testing: Smoke Testing, Sanity Testing functional Testing, Regression Testing, Database Testing, Web Service Testing, Batch testing etc.

Testing Automation Tool: Automated the scripts using the SOAPUI, QTP, Informatica

Defect Management &Test Management Tool: JIRA, Quality Center 10.0

Softwar: Q/A Standards & Procedures Development, SDLC Testing, test plan .Design & Development.

PROFESSIONAL EXPERIENCE

Confidential

QA Lead

Environment/Tools: Toad for Oracle, SQL Server, IntelliDB, UNIX Putty, Quality center .

Responsibilities:

• MDX is Confidential Data Exhange which is an ETL project.
• Data from different sources is loaded into the Target using wrappers.
• Data from different sources is loaded in to the Target tables.
• Then we use IntelliDB an
• Automation tool which is used to validate the Schema, data comparison and record count.
• All the results captured during the validation for the test cases were upload in ALM.

Confidential

QA Lead

Environment/Tools : Toad for Oracle, SQL Server, QTP, UNIX Putty, Quality center.

Responsibilities:

• CVS Test Data Management team deals with the test data requests coming from the QA, Regression, UAT and Regression teams via HP Quality Center.
• The Service requests are placed in HP QC and are fulfilled on FCFS basis using QTP scripts, Tar files, SQL queries etc.
• The test data created by the TDM team is used by the QA, Dev and Regression teams for testing.
• This project mainly deals with Creation of patients and prescriptions on the RX connect application which is automated by QTP.
• QTP takes the input data from the excel macros such demographics info of the patients and prescriptions to create the data in the RXC application.
• Once the data is created the output data is updated in the output columns of the Excel macros.
• After creating the test data the service request is assigned back to the data requester and marked as "Completed" in Quality center.

Confidential

Team Member

Environment/Tools: SOA, SOAP Pro 4.0, J-Meter, Selenium, Jira, (SQL Queries), DATA Driven Framework, Teradata, DB2

Responsibilities:

• In this project we are creating a "REWARD System", which will give the bonus point to his customer depending upon the different offer available on that day along with the STATUS of that specific customer (Gold customer, silver customer, Platinum customer and all.)There are different operation available (57 operations) based on that customer will get rewards.
• The aim of our Testing team is to test all the different services using SOAP Pro Tool.
• The client have huge Database having millions of records .
• We are using the sharding concept to divide the whole database into the 256 shards.
• It will increase the performance of the DB. For SOA testing, we are using the "Data Driven Framework".
• In the data driven framework, we are passing the input using the external files (excel, txt etc.) and sending the request to the server and server will provide the response.
• That response will be validated against the DB using the groovy validation.
• If the expected and the actual value is same then the Test case status will be passed and vice versa.
• In this way the whole test report will be updated automatically using groovy scripts.
• Finally the updated Test report will be send to the client through mail using the groovy scripts.

Confidential

Test Engineer

Environment/Tools: SOAP UI, TOAD tool for Oracle, Teradata DB, Unix Putty, and Informatica.

Responsibilities:

• The CEE Campaign Management Project implements the Teradata Relationship Manager (TRM or CMT) tool, which contains a set of capabilities to support flexible targeting and segmentation as part of the overall opportunity workflow.
• This program is intended to Improve the patient/member experience by offering time and money saving opportunities and by promoting proper medication utilization and adherence through various communication channels.
• TRM will be used for two specific communication campaigns (commercial Retail to Mail (RTM) and core, non-pharma-funded, Adherence to Drug Therapy (ADT) - also called Compliance and Persistence or C&P) managed by the CEA Team.
• This was a Data Warehouse Testing Project which includes the validation from Source to Target.
• Source for this project was Toad for Oracle and Target was Teradata.
• The Data is moved from Source to target using informatica workflows and UNIX batch jobs.
• Once this is done we used to do the validation between the source and the target tables.

Confidential

Team Member

Environment/Tools: SOAP UI, TOAD tool for Oracle, Teradata DB, Unix Putty

Responsibilities:

• The Confidential Partnership project aims to provide a system which includes a better interface, scalability, money saving options, better delivery to customer through various communication channels.
• This program is includes creation of order and delivery of order to various vendors through different communication channels.
• I was involved in validating the whole cycle of order placement through Confidential website manually.
• Used SOAPUI for doing the Web services testing using the request and response method.