SUMMARY

• Around 17 years of diverse experience in Quality Assurance (QA) and Software Development Life cycle (SDLC) in QA in Reports/ETL/Client Server and eCommerce Web applications.
• Extensive experience in working on different domains like Tolling back office, Equity Derivatives Banking Finance. Expertise include testing and QA /ETL in financial investment banking sector.
• Proficient in Designing Test plans, Test Cases, Test Scripts and Test Procedures.
• Experience in using automation tools - Ranorex/TestRail/QC/Selenium.
• Excellent skills in testing web-based applications & ETL validation skills.(Target & Source data validation testing)
• Excellent skills in Manual Testing & back end SQL PROCEDURE writing for test data analysis
• Extensive experience in running various kinds of tests such as Unit, Functional,System Integration Testing, Regression, System, End to End, Backend and Black Box, User Acceptance Test (UAT) for Web (N-Tier) and Client/Server Applications.
• Extensive experience in Testing in ETL(SSRS),data validation, Java with Selenium and automation frame work, SOAP protocol web services & Reports validation.
• Experience in estimation of test effort and coordinate test schedule with overall project schedule.
• Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools like QC & JIRA.
• Possess excellent communication skills along with verbal and written skills.
• Good team player and have ability to work independently.
• Implementing in Python,TestNG, BDD and Cucumber frame work for web based application automation and migrating existing selenium project and client server application with Ranorex.

TECHNICAL SKILLS

TESTING TOOLS: Test Director8.0,QC,Clearquest,Jmeter,Web Services,JIRA,TestLink,Toad,Soap UI

LANGUAGES: SQL, C, TSL (Test Script Language),VB Scripting,Unix command level,SQL PROCEDURE WRITING & DEBUG

TECHNOLOGIES: Cognos Reports 8.0/10,Cognos BI,JAVA 1.2,.Net 3.5,ASP.Net 2.0,XML,XMLSpy tool,EJB,FIX,TCP/IP Protocol,WebSphere,Tibco,HTML, DTS,Ddata

PACKAGES: MS Office 2003 (MS-Word, MS-Excel, MS-Power Point, MS-Access).

OPERATING SYSTEMS: Windows NT, Windows 95/98/00

DATABASES: Sybase 12.5,SQL Server 2005/2008 R2, Oracle 10g.

PROFESSIONAL EXPERIENCE

Confidential, NY

Lead QA Engineer

Responsibilities:

• Developed Test Scripts of back end for test cases utilizing QC/TestRail/JIRA to address open issues, functional testing and obtain Business Analysts sign off.
• Review test results with developer BAs in France and Dev Team in US members during functional and SAT, FAT testing phases.
• Team member in implementation team of project and major experience in testing onsite in UK, Canada based clients and working closely with Operation team.
• Extensive SQL usage in SQL Server as Backend testing & SQL PROCEDURE wiring for test data analysis.
• ETL validation & Testing target and source data of DMV data and client migration data validation.
• Working with off shore team located in UK, India and France.
• Involved in the site implementation testing in UK during project implementation
• Experience in third party interface implementation with Back Office system testing like Bank Interface, Rebill, IVR, PCN, Tolling related software systems.
• Lead team for Automation frame work with Ranorex/Selenium for applications and leading the scripting team for automation of client/Web clients.

Environment: QC, SQL Server 2012, C#,Windows 10,SharePoint,SQL Server,JIRA,TestRail,SSRS Reports with Microsoft reporting Services,Selenium Webdriver,Ranorex

Confidential, NY

Senior Engineer /ETL (QA)

Responsibilities:

• Developed Test Scripts utilizing Test Link to address open issues, sanity testing and functional testing and obtain Business Analysts sign off.
• Review test results with developers and Team members.
• Extensive SQL usage in SQLServer as Backend testing.
• ETL validation & Testing target and source data develop SQL directly against the database to independently determine dat the results are accurate
• Data model and relations ships validation.
• DTS for data transfer and validating in source and target.
• Involved with Team to design and executing test cases

Environment: Test Link, SQL Server 2005/2008,C#,Windows XP/2008,SharePoint,SQL Server, DTS,DataWare Housing Reports with Cognos 10,.Net,Wherescape RED,Mobile Apps,Yellowfin

Confidential, NY

QA Tester

Responsibilities:

• Developed Manual test cases utilizing Quality Center to address open issues, sanity testing and functional testing and obtain Business Analysts sign off.
• Review test results with developers and BA’s in USA, Paris and India utilizing Quality Center.
• Sign off on testing as phases are completed with release management.
• Extensive SQL usage in Sybase as Backend testing using Win Sequel.
• Installing new builds in test environments and managing the test environments.
• Validating End of Day and Regression test results using Araxis Merge.
• Client Statements, and Collateral, Price Testing and PnL attribution analysis in EOD process.
• Developed Integration, System, Regression and Post Implementation Test cases to cover all over Quality Assurance Testing.
• Tested Application for broken links etc.
• Soap protocol based Web service testing by using the 'Insert Request' and 'Insert Web Service Request' options, customize the individual requests in the Web Test to locate Web service pages.
• Involved in performance testing of PRE and POST versions of application.
• Involved in preparation of Defects Matrix and Automation Testplans.

Environment: Quality Center 9.2, Citrix, VC#,ASP.Net, webservices 9.2, Sybase 12.5, Crystal Reports 11, JIRA,Soap protocal(Web Services testing), Tibco,Lotus Notes, Araxis Merge, VB Scripting,.Net, WebLogic,SQL Server

Confidential, NY

QA

Responsibilities:

• Execute cases for open issues, sanity testing, and functional testing and document the results.
• Extensive SQL usage in Sybase as Backend testing using DB Artisan.
• Debugging the tests, running the tests on new version, examining the results.
• Performed Backend testing using SQL Queries for reports, interfaces.
• Executing scripts to check the status of Autosys job in QA Environment.
• Developed test scripts from manual test cases for Regression
• Attended Project Meetings, Release Meetings and QA/ ETL status meetings
• Did negative testing to find how the function performs when it encounters invalid unexpected values.

Environment: Actimize Case Manager Platform, Autosys, JAM, TWIKI, Documentum, IBM Ondemand Platform, SQLServer, DB Artisan, ClearQuest,Xterm Unix, DTS,Informatica PowerCenter7.1.1, TestDirector8.0, Windows XP

Confidential, OH

QA Tester

Responsibilities:

• As a team member involved in developing QA ETL test plan covering functional, integration, regression and end-to-end testing.
• Performed manual testing on different modules of the application.
• Participated in various planning and retrospective meetings and discussed on Enhancement and Modification requests.
• Tested Application for broken links etc.
• Did extensive Regression testing on the new builds

Environment: HTML, XML, JSP, Web logic Server, Oracle 8i, WinNT, Unix, SQL, JavaScript, Netscape 5.79, IE 5.x,DB2

Confidential

Senior Tester/Developer

Responsibilities:

• Involved in doing System testing of the entire applications along with team members
• Applications are tested manually.
• Developed test scenarios and test procedures based on the test requirements.
• Participated in Preparing Test Plans.

Environment: JAVA2.0, ETL,Servlets. Applets, XML, JDBC, Oracle 7.3, SQL Loader .

Confidential

Developer/QA Tester

Responsibilities:

• Document test plans and test cases based on the Solution definition documents and use case documents.
• Evaluated Screens to the Customer specified Standards and Specification in regards to the flow and Appearance of the Application.
• Tested security privileges of the application using different User Id’s and Passwords

Environment: UNIX, Windows NT, Oracle, VB, ASP, HTML, IE 4.

Confidential

Programmer/Analyst

Responsibilities:

• Involved in the design of an improved forecasting system to optimize and automate the reordering of raw materials.
• Performed Manual Testing on all environments including the DEV box to get the initial picture of the application.

Environment: Window 95, Oracle 7.1, Visual Basic.