SUMMARY:

• IT Professional with over 10 years experience in manual testing methodologies and 3 years automation testing experience in industries such as HealthCare,Financial services,Mortgage, Transportation,Insurance,Pharmaceutical.
• Experience in designing the test strategy and test plan documents for various phases of testing.
• Extensive experience in analyzing technical and business specifications,writing system specifications and documentation and intensively checking the data flow in Web - basedClient/Server,Mainframe and Networking environments.
• Strong in writing test plans,test cases,test scripts,test scenarios.
• Experience in extraction,transformation and loading of data for Data Warehouse testing using Informatica tool.
• Proficient in identifying business rules,functional capabilities,business events and relating business rules to the process model.
• Extensive experience in executing complex SQL queries for database testing.
• Experience developing test scripts under different automation frameworks like Keyword Driven, Data Driven, Hybrid and Page Object Model(POM) framework.
• Experience in developing automated test scripts using Selenium IDE and Selenium WebDriver with Core Java.
• Experience in various types of testing like Unit/Whitebox,Integration,Validation,Functional, System,Database,Security,User acceptance,Performance,Regression,Load,Stress testing.
• Sound knowledge of Software Development Life Cycle (SDLC) with Agile and Scrum.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Operating Systems: DOS, Unix (Sun Solaris,HP),Linux 6.x,Windows 95/98/2000/NT/XP

Testing Tools: SQA,ClearQuest,ClearCase,Jira,BugZilla,WinRunner 7x/6x,LoadRunner 7x/6x,TestDirector 8.0/7x/6x,Quality Center 8.0/9.0,ALM,QTP 8.0/8.2/9.0/9.2 , Clarify,PVCS Tracker,CVS,Visual Studio 2015,TFS,Microsoft Test Manager,Selenium IDE,Selenium WebDriver,TestNGMaven,SOAPUI.

Programming Languages: Core Java,Visual Basic 5.0/6.0/.NET,C,C++,C#,SQL,T-SQL,TSL, PL/SQL.

Scripting Languages: Unix Bourne Shell, Grep, Sed, Awk, Perl Programming.

Web Development languages: HTML, DHTML, XML,VBScript,JavaScriptServlets, EJB, JSP 2.0, ASP 3.0/.NET.

Databases/Tools: Oracle 8x/9i/10g/11g,Forms 4.5/6i,Developer 2000/6i,Designer 6i, Discoverer 4i,ERwin 4.0,Reports 3.0/6i,SQL*Loader,DataStage 4.1(ETL),InformaticaPowerCenter,SAP BW/BI 7.0,BEx Analyzer,Crystal Reports,PVCS Tracker, PVCS VM,Visual SourceSafe, MySQL,Toad,ODBC,ADO,IIS 5.0,WebLogic ServerWebSphere,UML,Together 5.0,MS SQL Server 7.0/2000/2005/2008/2012/2014 , JDBC,Sybase,MS Access 97/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr.Software Test Analyst

Responsibilities:

• Tested LUI/PUI web application systems which are part of exchange product for clients like bankofamerica,chase and wells fargo.
• Designed and Developed Test Plan,Test Scenarios,Test Cases for LUI/PUI systems for different clients.
• Used Visual Studio 2013/2015 and TFS for task creation and completion
• Test cases were designed and developed using Microsoft Test Manager(MTM).
• Validated TID(transaction identification) and sequence of different events generation through both web and integration testing by dropping xml files in mpp locations for different environments.
• Validated data in tables using SQL server 2014 for various backend testing scenarios.
• Wrote complex sql queries in order to validate tables in order to check transactions placed through integration for rest api testing and mpp locations.
• Automated LOS systems LUI/PUI using selenium webdriver for regression and functional tests.
• Data driven testing framework was followed using selenium for regression and smoke tests.
• Logged and tracked defects using test manager.
• Worked on several feature requests like CCPS,Fee services,chase mpx/closr for appraisal orders.
• Worked on triaging production bugs in lower environments like devtest and staging environments to reproduce issues before assigning them to development.
• Worked with cross functional team members like business system analysts,developers and project manager in resolving issues.
• Worked on testing functionality testing,backend SQL Data validation and REST API testing using fiddler 4.0 tool for different clients and their customers/lenders.

Environment: Visual Studio 2015,XML,MISMO3.2/3.3,.NET,C#,Sharepoint,RestApiFiddler 4.0,SQL Server 2014,TFS,Selenium Webdriver,Core Java,TestNG,Windows 7,MS Office,MS Project,CCT configuration tool,Eclipse.

Confidential, Wellesley, MA

Sr.Data Quality Tester

Responsibilities:

• Tested data extraction from GWR to CDA using SQL Server 2012
• Tested data transformation rules while loading data from stage to permanent tables using data mapping document and data load requirements document.
• Tested all the data validation errors and warning messages that are stored in error t table from GWR2CDA and CDA2GWR
• Logged and tracked defects using ALM/Quality Center 11 and Bug Zero tools
• Wrote complex sql queries using sql server 2012 and oracle 11g for data extraction and data load processes.
• Tested consumer data administration web application by converting manual test cases into automated test scripts using selenium webdriver for both smoke and regression tests.
• Strong knowledge of data warehouse and data quality practices and concepts
• Tested De-duplicated records of employee table in order to correctly flow into consumer table.
• Tested to map source system data to data warehouse models (both staging and presentation layer facts/dimensions).
• Identified problematic areas on ETL processes,data workflows,data transformations and data exceptions.
• Tested several Boxi and Logixml reports of sunlink to qps conversion project.
• Developed system integration test plans, design and author SQL test scripts and test sets that encompass valid and invalid data.
• Prepared test data,executed test scripts,documented test results and analysis,including defect identification and resolution
• Worked with cross functional team members like business system analysts,developers and project manager in resolving issues.

Environment: Oracle 11g,SQL Server 2012,SSIS,SSRS,Sharepoint,BugZero,ALM/Quality Center 11,Business Objects XI,Logixml,Windows 7,Selenium Webdriver,Core Java,MS Office,MS Project.

Confidential, Lexington, MA

Sr. QA Analyst

Responsibilities:

• Tested Soarian Clinicals(eCC) application for various functionalities like assessments,workflow alerts,patient information,charting and placing orders.
• Tested various enterprise reports and eCC reports by entering data in soarian clinicals application.
• Tested a government project named NHSN involving vascular accesses and different dialysis events that take place during reportable month.
• Tested various integration projects involving knowledge center(KC) data validation using Toad 10 for Oracle 11g.
• Logged and tracked defects using ALM/Quality Center 11.
• Wrote SQL queries using Oracle 11g and Toad 10 to validate integration tables data to see that eCC to KC and Dama to KC processes are working according to the requirement specification.
• Worked with cross functional team members Business Analysts,SME group,Project managers and developers in tracking issues and resolving them.
• Presented test results to SME’s to perform User Acceptance Test in production support environment.
• Tested various enterprise reports using OBI Answers and BI Publisher for different subject areas.
• Developed Test Plan,Test Scenarios,Test Cases and Test Scripts for NHSN,DAMA Interventionalist and various other integration projects based on functional requirements specifications.
• Facilitated status review meetings on testing process and Bug Scrub meetings to report the status of defects.
• Executed automation regression test scripts for Soarian Clinicals(eCC) application using QTP 9.2/10 tool.

Environment: Oracle 11g,SQL* Plus,PL/SQL,Java,Web Logic,OBIEE,Logi,Active X,Sharepoint, XML,Informatica,Windows XP/Windows 7, Toad 10, J2EE,JSP,JavaScript MSIE 8.0/9.0,QTP 9.2/10,VBScript,MS Office,MS Project.

Confidential, Columbia, MD

Sr. QA Analyst/Tester

Responsibilities:

• Tested lancelot core lab application for various functionalities like accessioning,aliquoting,extraction,data entry,results entry,specimen inquiry and reporting.
• Tested web based application online requisition(OLR) and client/server based aurora application in order to submit requisitions directly by various provider clinic accounts.
• Conducted User Acceptance Test(UAT) with end users in one of Confidential ’s lab for lancelot rollouts.
• Tested applications like lancelot,OLS,Aurora for different projects like QA/QC,Marshfield,EHR and other lab improvement projects for lancelot,OLS and aurora applications.
• Developed Test Plan,Test Scenarios,Test Cases and Test Scripts for QA/QC,EHR,Marshfield based on functional requirements specifications and other lancelot enhancement projects like Tecan Integration and Ascent Integration.
• Logged and tracked defects using JIRA and BugZilla tools.
• Wrote SQL queries using SQL Server 2008 to validate data for Marshfield,Tecan Integration and patient statement billing project involving lancelot core lab application.
• Worked with Business Analysts,Developers and Project Managers in resolving issues which are show stoppers and critical to the business.
• Conducted Status review meetings on testing process and Bug Scrub meetings to report the status of defects.
• Tested HL7 file for critical patient data for different EHR vendors to see that all the data that is present in generated Rx Guardian Report is visible in HL7 file in 7Edit tool.
• Executed automation regression test scripts for Lancelot,OLS and Aurora applications using QTP 9.2 tool.

Environment: MS SQL Server 2008 R2,Visual Studio,C#,ASP.NET,VB.NET,Active X,Sharepoint, BizTalk Server,.NET Framework,JIRA,Bugzilla,XML,SSRS,SSIS,Windows XP/Windows 7,MSIE 8.0/9.0,QTP 9.2,VBScript,MS Office,MS Project.

Confidential, Columbia, MD

Sr.QA Analyst/Lead

Responsibilities:

• Developed Test Plan,Test Cases and Test Scripts based on Functional Requirement Specifications(FRS) and System Requirement Specifications(SRS).
• Validating the data which flows from terminal application into central management system(CMS) every three minutes and once the close shift happens on the terminal side.
• Developed the test cases and executed them for the sales application which is the GUI for Point of sale systems TVM,CSK,TOM and Farebox.
• Performed functional,integration,system,regression testing and user acceptance test(UAT) on the point of sale systems like TVM,CSK, TOM and Farebox machines.
• Involved in testing the critical smartcard functionality in TVM,CSK and Farebox systems.
• Verified and Validated the parameter files which are downloaded from Revenue service system(RSS).
• Wrote complex SQL queries using TOAD 8.6 to validate the data to ensure data integrity for Back-end testing for CMS system which verifies all the transactions that come from terminal application.
• Logged defects in Rational ClearQuest and StarTeam which are used as defect tracking management tools.
• Tested Stored Procedures, Functions, and Triggers for the application using Oracle 10g and SQL Server 2005.
• Worked extensively with Business Analysts,Developers and Project Managers in resolving issues which are show stoppers and critical to the business.
• Conducted Status review meetings on testing process and Bug Scrub meetings to report the status of defects.

Environment: HTML,XML,Windows 2000/XP,Unix HP,Oracle 10g,MS SQL Server 2005Toad 8.6,SQL Developer,SQL*Plus,PL/SQL,ActiveX,WebLogic 7.0,Business Objects,Crystal Reports 11,ODBC,VC++ 6.0/.NET,COM/DCOM,Visual Studio 6.0/.NET,Sharepoint,Rational ClearQuest 7.1,ClearCase 7.1,MS Office, MS Project,CORBA Middleware

Confidential, Hartford, CT

Sr.QA Analyst /Lead

Responsibilities:

• Reviewed the functional design,requirements specification and Detailed design documents.
• Developed and executed test plans by thoroughly analyzing the Business Requirement and functional Spec documents which were provided by business for Integration and User Acceptance test environments using Quality Center 9.0 test management tool.
• Requirements traceability matrix by mapping requirements to test cases using Quality Center.
• Logged and tracked various defects using Quality Center and Lotus Notes tools.
• Designed and developed test cases using business requirements,business rules for various transactions of Commercial Intellisys which is a policy administration system for different clients of Confidential .
• Tested various transaction types like New Business issue,Change Endorsement,Renewal issue for Commercial Intellisys,Policy Decisions and PMS Mainframe Systems.
• Validated data by writing complex SQL queries for policy administration system.
• Validated both personal and commercial lines of business like GL,BOP,AUTO,Umbrella,Property.
• Performed regression testing whenever new release is deployed in QA environment.
• Tested the policy administration system and also converted manual test cases into automated test scripts for regression test of the system using QTP 9.2 tool.
• Conducted Status review meetings on testing process and Bug Scrub meetings to report the status of defects.
• Worked extensively with Business Analysts,Developers and Project Managers in resolving issues which are show stoppers and critical to the business.

Environment: WebLogic 8.1,SQL*Plus,SQL*Loader,PL/SQL,Toad 8.6,MS SQL Server 2000/2005J2EE,JSP,JavaScript,Visual Studio,ASP.NET,Active X,Sharepoint,Oracle 9i/10g,TSO,CICSMainframe,AS400,UNIX Solaris,XML,Business Objects,Windows 2000/XP,MSIE 6.0,QTP 9.2,VBScript,MS Office,MS Project,Quality Center 9.0,Lotus Notes.

Confidential, Hopewell, NJ

Sr.System Tester

Responsibilities:

• Reviewed the functional design,requirements specification and detailed design documents comprising of many user interface screens for large application named EmBARC DP system.
• Designed and developed Test plan,Test cases based on the functional design and detail design documents for System and User Acceptance Test(UAT) environments.
• Requirements traceability matrix by mapping requirements to test cases using Quality Center.
• Wrote manual test scripts for the study specific derivations and user interface screens of EmBARC DP system.
• Extensively used Quality Center 9.0 for defect tracking and for test management purposes.
• Developed and executed test scripts for three test cycles in different environments.
• Validated the data using complex SQL queries and PL/SQL for study specific and non-study specific derivations using Toad 8.6.
• Designed and developed test cases for the study definition user interface report screens of EmBARC system.
• Logged and tracked various defects using Quality Center and Lotus Notes tool.
• Validated data integrity of the tables using Stored Procedures,Functions,Triggers with PL/SQL.
• Verified the Informatica Scheduler jobs run by the developers.
• Verified the data mapping of the various columns of different tables of the target system from the source system using Informatica ETL.
• Actively participated in Defect Review meetings involving Developers,Business Analysts and Project Managers to report the status of defects to the management.
• Worked closely with developers in tracking and resolving defects.
• Converted manual test cases into test scripts using QTP 9.0 VBScripts for datadriven, functionality and regression test of study definition and report template user interface screens of EmBARC system.
• Executed regression testing on the EmBARC whenever code changes were made to enhance the functionality of the system.

Environment: J2EE,Java Server Pages 1.3,Apache Tomcat 5.2,Informatica 7.1,ETL,Oracle 8i/9iSQL*Plus,PL/SQL,Toad 8.6,XML,Business Objects,SAS,Windows 2000/XP,MSIE 6.0,MS OfficeMS Project,Unix Solaris,QuickTestPro 9.0,Quality Center 9.0,Lotus Notes,Documentum.

Confidential, New York, NY

QA Lead

Responsibilities:

• Designed and Developed requirements and test conditions under requirements tab of Test Director 8.0 and Quality Center 8.0
• Developed test cases based on the requirements and the test conditions in Test Director and Quality center and identified test data in order to match with requirements.
• Requirements traceability matrix by mapping requirements to test cases using Test Director.
• Responsible for developing and executing test plans for Integration,System,Database and User Acceptance Tests using Test Director test management tool.
• Wrote test scripts using QTP VBScripts for datadriven,functionality and regression testing of ABS and Amex Equity Trading Systems.
• Validated data integrity of the tables by using Stored Procedures,Functions,Triggers written in PL/SQL
• Loaded bulk test data into test database server by using SQL* Loader.
• Tested Actuate Reports by generating invoices for various clients.
• Performed regression testing on the application whenever any change in code is made to enhance the functionality of the system.
• Performed backend testing using complex SQL queries for Oracle 8i/9i and SQL Server 2000 databases.
• Logged and tracked various defects using Test Director tool.
• Actively participated in Defect Review meetings involving Developers,Business Analysts and Project Managers to report the status of defects to the management.
• Customized reports using Test Director to meet various needs of defect review meetings.
• Worked closely with the developers to assist in the resolution of defects.

Environment: WebLogic 8.1,SQL*Plus,SQL*Loader,PL/SQL,Toad 8.6,J2EE,JSP,EJBVB.NET,ASP.NET,ActiveX,Oracle 8i/9i,SQL Server 2000,UNIX,ShellScripts,XML,Actuate ReportBusiness Objects,Windows 2000/XP,MSIE 6.0,TestDirector 8.0,VBScript,MS OfficeQuickTestPro 8.0,Quality Center 8.0