SUMMARY:

• IT Professional with over 10 years experience in testing methodologies using both manual and automation tools 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 - based,
• Client/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 in developing automated test scripts using 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,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,JavaScript, Servlets, 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),Informatica

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 Confidential, Confidential and Confidential .
• 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, Confidential 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.

Confidential, Wellesley, MA

Sr.Data Quality Tester

Responsibilities:

• 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 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
• Executed automation regression test scripts for Soarian Clinicals(eCC) application

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 ameritox’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
• 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:

• 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

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