SUMMARY:

• Over 10+ years of professional experience in Information Technology, with extensive experience in performing Manual and Automation and ETL Testing.
• Expertise in STLC (Software Testing Life Cycle) & Defect Management Life Cycle.
• Extensive knowledge in analyzing requirements, writing and executing Test plans, Test cases and QA Procedures, setting up test environment, preparing test data, creating defect documentation, requirement traceability matrix and test summary reports.
• Expertise in entire QA Life Cycle Process, which includes design and development of Testing Methodology, Test Strategy, Test Scenarios, Test Plans and Test Cases. 
• Experience in various aspects of (SDLC) Software Development Life Cycle and Agile/Scrum and Water fall SDLC Process. 
• Experience in manual testing using UI testing and proficient in Black and White Box Testing, Regression Testing, User acceptance Testing, Regression, Continuous Integration Testing with Iterations.
• Experience in Databases Oracle, SQL Server, MS Access, Excel and DB2 and Hive.
• Experience in ETL Testing and BI process and Data ware house testing.
• Experience in Testing Business Intelligence (BI) reporting tools using Cognos, BO, and Jasper. Have tested several complex reports including Dashboards, summary reports, master detailed, drill down, drill through and score cards.
• Expert in writing complex SQL queries and data verification for back - end testing for Applications.
• Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools like JIRA, ALM/Quality Center and Bugzilla. 
• Experienced in SQA (Software Quality Assurance) including Manual and Automated testing with tools such as Selenium RC/Web-Driver/IDE/Grid and Junit/Test-NG, Quality Center, JIRA.
• Experience in Designing and implementing in different automation frameworks from scratch like Page Objects framework, Keyword Driven framework, Data Driven framework and Hybrid framework. 
• Knowledge in BDD scripts with Cucumber and writing step definitions for behavior.
• Effective in working independently and collaboratively with offshore and onshore
• Proven skills in Leading and training teams, Test Management and Meeting the deadlines.
• Excellent interpersonal, verbal and written communication skills with the ability to collaborate and interact confidently with multifunctional teams that include programmers, project management, Systems Analysts, Business Process Engineers, and staff at all levels 

TECHNICAL SKILLS:

Languages / Frameworks: JAVA, C#, Junit, TestNG

Automation Testing Tools: Selenium WebDriver / RC, Cucumber

Bug Tracking Tools: JIRA, ATTASK, Bugzilla

Testing Management Tools: HP QualityCenter / TestDirector, HP ALM

RDBMS: Oracle 11 / 10g / 9i / 8i, MS Access, MySQL

Scripting Languages: VB Script, JAVA Script, HTML5, CSS, XML

ETL Tools: Informatica Power Center 8.6.1 / 8 / 7.1 / 6. x, Power Connect, Power Analyzer, and Power, Exchange tools

BI Tools: Cognos 8 / 10, Business Objects

Operating Systems: Windows7 / 8, Windows Server 2008 / 2008R2 / 2012, MAC OS, Linux / Soloris

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. QA Analyst

Responsibilities: 

• Developed and executed the Test Plans, Test scripts, Test Cases and test results reports. 
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables. 
• Regression test cases were written and automated using Selenium Web-Driver. 
• Developed automation scripts for new enhancements using Selenium Web Driver and Test-NG. 
• Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium/Test-NG. 
• Used Java language and Test-NG framework for scripting. 
• Extensively used Selenium locators like (X-path, CSS Selectors, Fire Bug, Fire path locator) and Web-Driver to test the web application. 
• Write and update SQL queries to perform data validation from Oracle for ETL process for
• Worked on Mainframe systems like EVS1 and DBL for Data creation and.
• Interacting with developers, business analysts, UAT and Integration team for discussing requirement changes and defect status and resolution.
• Designed and executed the Automation Test Scripts using Java in Selenium WebDriver for Hybrid framework (keyword and Data driven) and Page Object design pattern in Selenium using TestNG.
• Performed functional testing of SOAP and RESTFUL Web Services using SOAP UI Tool. 
• Tested request and response XML's based web services interfaces using SOAP UI. 
• Reported software defects in Quality Center and interacted with the developers to resolve technical issues. 
• D eveloping Behavioral Driven Development (BDD) scripts with Cucumber(gherkin) and writing step definitions for behavior using Gherkin and solid understanding of Test Driven Development (TDD). 
•  Analyzed test results, tracked the defects and generated reports using Quality Center. 
•  Prepared the data to cover various scenarios and wrote SQL scripts to verify the database updates, inserts and deletion of the records. 
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables. 
• Tested applications in different types of browsers and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment. 
• Participated QA weekly meetings and various other meetings and discussed Enhancement and Modification Request Issues and defects in the application.
• Validated Data Sharing rules in Salesforce workflow, approval processes, and validation rules for Weeks and point members.

Environment: Java, JIRA, Java Script, Selenium Web Driver, SQL, Oracle, Salesforce, SOAP UI, Cucumber, Unix, HTML5, CSS3, XML, Eclipse, Unix, Jenkins, HP ALM, SVN

Confidential, NJ                          

Sr. QA Tester 

Responsibilities:

• Tests application for Functionality Testing, Integration testing, System Testing, Smoke Testing, User Acceptance Testing, Regression Testing.
• Followed Agile/ Scrum Methodologies for all the project activities.
• Actively participating and understanding application of Agile practices - Test Driven Development (TDD), Iterative development and Continuous integration.
• Analyzed Business requirements of the product, worked with Developers, Product Owner, and other internal customers and team members to analyze Acceptance criteria and Prototypes.
• Participated in sprint meeting and Actively participated in Daily Scrum meeting and updated the status of assigned task to the team members.
• Uploaded Test plans and Test cases with different versions in QC ALM.
• Analyzed the functional specifications and helped team members to achieve test goal.
• Creating and updating Java test scripts using Selenium IDE and Selenium Web-driver and Xpath.
• Worked on testing APIs, reading and writing into the database & checking server logs.
• Validated reports by executing SQL queries. 
• Created Test Data for QA and UAT.
• Created and Validated the data as per the Mapping Documents.
• Prepared daily/ weekly status reports on Test case execution, defects, RTMs. 
• Involved in planning test execution activities, defect reporting and analyzing test metrics using JIRA . 
• Perform extensive System Integration and Regression testing to make sure existing  functionalities are intact. 
• Preform backend testing using SQL Developer against oracle database. 
• Create, Track and Report defects using QC.
• Participate in bug review meetings to triage bugs based on their severity and priority. 
• Provide Test Summary Reports to the management. 
• Working in Agile Development & Continuously Delivery Environment with frequently  changing requirements and features. 
• Responsible to prepare the Daily Status Report and Weekly Status Report.
• Tracked the project progress and effectiveness of test efforts across all teams and projects and report them to management.
• Developed Metrics for capacity and performance testing for each release and updated to management.
• Developed solutions to carry out the capacity and performance test against the metrics.

Environment: Quality Center 11.0/10.0, Java, Java Script, Selenium Web Driver, Linux, Oracle, Hadoop, SQL Server, JIRA, QC ALM

Confidential, NJ                 

Sr. QA Analyst  

Responsibilities:

• ETL Data Validation, Metric Verification and Report Testing.
• Validated ETL processes and made sure that the data from source to target tables are loaded correctly. Created and executed complex SQL queries to validate the flow of data. Tracked and reported the bugs with HP Quality center.
• Executed the SQL's against the source database and tested against the Target database and compared the Results in the Cognos reports and Excel Sheets and Metadata validation.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing.
• Writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries in Toad.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Validated the front end Cognos Reporting components created using Web Intelligence Reports as well as Back End testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse for Dash Boards with multidimensional cubes, Active Reports, Drill through and drill down and score cards.
• Involved in coordinating the development, QA and production deployment activities. Hands on experience in metadata generation, testing and production deployment using cornerstone utilities and MYSQL and hive.
• Validated data for Data mart tables from transactional level for end to end testing for ETL process.
• Proficient in using Hadoop commands to see the list of files, to take counts of the HDFS files. 
• Responsible to validate the data transferred through Sqoop between Oracle DB and HDFS. 
• Performed Regression testing after every enhancement, build installation and releases.
• Responsible for Functional testing, User interface testing and User Acceptance Testing.
• Worked closely with the Business analyst, System Analysts, Developers and DBA to solve the issues identified during the testing process in a timely manner and post Production.
• Executed tasks proficiently meeting tight deadlines.
• Experience in managing the offshore and onshore team members.
• Designed and developed front end and Back end test scenarios and Test cases.
• As a QA Lead, participated in walkthroughs for the evaluation of the test plan with the design and development.

Environment: Business Objects - Cognos 10.0.2/8, informatic Power Center 9.5/8.1, SQL, PL/SQL, SQL Server, Linux (sun Solaris), Oracle 11/10g, TOAD, HP Quality Center 10, Java, QC bug tracking tools, JIRA, CRM, Hadoop, HIVE SQL

Confidential, NJ

QA Analyst

Responsibilities:

• Created and executed test cases and automated test scripts for Regression testing.
• Validated aggregate views for SLA level agreement counts.
• Extensively executed SQL queries in order to view successful transaction of data and for validating data.
• Executed Test Cases and reported defects using Bugzilla and tracked bug through resolution.
• Responsible for weekly status updates showing the progress of the testing effort and open issue to be resolved.
• Experience with Oracle Financial applications for Synchronoss Internal Billing system

Environment: Oracle, Windows, Java, Bugzilla, SQL

Confidential,NY 

QA Analyst

Responsibilities:

• Prepared Test Cases to test basic functionality and reported the defects through Test Director.
• Performed Test Script Execution by using Quick Test Pro 9.
• Recorded and designed the test steps needed in Test Director to recreate the symptoms so that developers may reproduce and isolate the cause of defects.
• Verified the rectified bugs by testing the application both manually and executing the scripts using Quick Test Pro 9 In addition, made entries for adjusting the status of the defects using Test Director.
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
• Conducted Black Box Testing against the applications whenever there is a change in the design of the application.
• Worked extensively with Quick Test Pro and recorded scripts for Stability Acceptance Test.
• Performed Stability Acceptance Testing using Quick Test Pro for testing the functionality and sanity of the application.
• Reused the stored properties of the objects stored in the Object Repository while performing Regression Testing.
• Followed the Testing Processes and coordinated with team members for producing deliverables (exit criteria) on schedule.
• Reported the identified defects using Test Director while performing manual testing for each enhancement feature.
• Contributed for preparing documents at all phases of testing.

Environment: Visual Basic.Net, ASP.Net, SQL Server 2000, Windows NT / 95 / 98, Windows XP, Manual Testing, Test Director 8.0, Quick Test Pro 9.

Confidential,NY

QA Teste

Responsibilities:

• Analyzed system requirement specifications and developed test plans, test cases to cover overall QA System Testing.
• Worked closely with Customer Business Unit Managers, Stakeholders and Functional Subject Matter Experts (SME).
• Documented Project Charter and generated reports related to High-Level Functional Requirements using Rational Rose document generator.
• Analyzed Portfolio Management, Investment Planning, Financial Planning, Customer Support and
• Investment Strategy Tools and processes.
• Enhancing the TSL Scripts with Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Performed Manual Functional testing and Automated Testing using WinRunner, Load Testing of the application using Load Runner against new builds.
• Used the SQL to perform the Backend Testing on the Oracle database.
• Performed Black Box Testing, System Testing, Integration Testing, Performance Testing, Functional Testing, and Backend Testing.
• Developed automated test scripts using Win Runner using TSL.
• Extensively used data parameterization, GUI checkpoints, database checkpoints and synchronization statements
• Developed and executed SQL queries for backend testing
• Implemented whole life cycle of QA Methodologies starting from Planning, Capturing, Creating, and Executing, Reporting and Tracking the defects using Mercury Test Director.

Environment: Windows 2003 Server, Windows 2000, VB, Mercury Tools - WinRunner, Load Runner, Test Director (Quality Center), Rational Rose, SQL Server, Oracle 9i, Sybase and Unix, HTML, ASP, VB script.