SUMMARY:

• Senior QA Engineer with 8 years experience in Software Testing Industry. Adept at the End - to-End testing of software products/projects from Requirement Analysis, Test planning, Test Scenarios, Test Cases, Test Execution, Test Documentation and Test closure with expertise in performing Manual Testing, API Testing, Database Testing & Test Automation with Selenium using Python, JavaScript.
• Strong knowledge in implementing Waterfall and Agile (Sprint/Scrum) Methodology by analyzing requirement specifications and responsible for developing Test Objective, Test Scope, Test procedures and Test Matrices.
• Adroit in Testing Lifecycle (STLC) starting from Estimation to writing/reviewing Test Plans, Test Cases and Summary reports.
• Excellent skills in understanding requirements and creating test cases out of Business Requirement Document and Functional Requirement Document.
• Experienced with extensive Manual Testing on web based applications.
• Worked on System Testing , Functional Testing , Regression Testing , Integration Testing and API Testing .
• Well versed with Bug Defect Cycle, Bug tracking using Quality Centre
• Hands on experience in writing Medium to complex database queries, debugging and fixing issues using SQL
• Experienced in Database Testing using SQL Queries with multiple Databases- MS SQL Server, Oracle and My SQL.
• In-depth knowledge of SQL & Proficient in Grouping , Function s, Sub-queries & Joins, Triggers, Procedures.
• Good understanding in Data Warehousing and ETL testing concepts and Dimensional Data Modeling using Star and Snow Flake Schema.
• Strong experience in API Testing; RESTful Web Services using Postman Rest Client by invoking POST, GET, PUT, DELETE methods .
• Experienced in Test Automation using Selenium Web Driver, Cucumber to develop automation testing scripts for web and client server applications.
• Experienced in writing Selenium Web Driver automation scripts in Java/Python using TestNG annotations, PyUnit.
• Extensively used Selenium APIs such as Take Screenshot for Capturing Failed test cases, and knowledge in using different Locators ( XPath, CSS Selector, id, Link text, Partial Text ).
• Experienced in using Apache POI to read data from external sources to feed locators in web application.
• Experienced in Mobile Apps Testing of Native, Hybrid & Mobile Web apps with Exploratory Testing on Mobile and Tablet devices using Appium.
• Knowledge in Mobile testing on Real Devices and Emulators/Simulators for both Android and iOS.
• Strong understanding of front-end technologies such as JavaScript, HTML5, and CSS3 .
• Designed and Implemented different automation frameworks as Data Driven Framework and Behavior Driven Development.
• Knowledge on other frameworks like Page Object Model (POM), Keyword Driven and Hybrid Framework.
• Hands on experience with Cross- Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.
• Expertise in different types of testing like Manual testing, Integration testing, System testing, Smoke testing, Regression testing, Black box testing, Functional testing, Database testing, API testing, GUI testing, Web / UI and User Acceptance Testing.
• Experience d in Bug Tracking and Reporting using HP Quality Center (ALM) and Configuration management tools like GIT Hub.
• Experienced with projects that utilized web technologies like XML, HTML, CSS, REST, JavaScript and high-level languages such as Python and Java.
• Dynamic and assertive Team player with a strong inclination to improve and optimize process development and implementation.

CORE COMPETENCIES:

• Selenium IDE/WebDriver/Grid
• Python, JSON, XML
• MS SQL, PostgreSQL
• Frameworks - DDD, BDD, Hybrid
• Java, JavaScript
• Postman, REST Client
• TestNG, Apache POI, Maven, Jenkins
• HP QC/ALM, JIRA
• GIT, Confluence

TECHNICAL SKILLS:

Project Methodologies: Agile/Scrum, Waterfall, Bug Life Cycle

Testing Tools: Selenium WebDriver, Selenium IDE/RC, TestNG, PyTest, Postman, REST Client

Testing Frameworks: Page Object Model, Keyword Driven, Data Driven, Hybrid Framework.

Languages: Python, SQL, JavaScript, C, UNIX, R, Apache Spark, Spark SQL, PostgreSQL

Markup Languages: HTML, CSS, XML, JSON

Database: My SQL, Oracle, SQL Server, Hadoop Framework

Utilities: Eclipse IDE, Firebug, Toad, GIT, Fire Path

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome

Python, Pandas, Tableau, R: Studio, WEKA, Google Analytics

Defect Tools: HP Quality Center (ALM), JIRA, Confluence

MS Office Tools and other tools: Outlook, MS Word, MS Excel, MS PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge, NJ

IT - Senior QA Engineer

Responsibilities:

• Assessed & analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.
• Reviewed product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.
• Involved in various SDLC Phases such as Requirements Analysis, Test Case Development, System Testing, Database & Regression Testing. Also conducted End to End testing for each release.
• This project followed 100% agile based methodology and all project activities are being managed in CA Agile Central (formerly Rally). ALM is also used for defect management and reporting.
• Participate in PI Planning, Sprint Planning, Sprint Reviews, Scrum Meetings and other agile activities.
• My other day to day responsibilities include reviewing the business requirements, preparing project estimates for QA tasks and resources, creating and reviewing the test strategies and test plans with business partners, creating and reviewing test scripts and test cases.
• Wrote complex SQL validation scripts for backend database testing.
• Collaborated with database development team for testing implementation.
• Worked on Creating and updating the tables, views using the Joins, Sub-Queries.
• Experienced working with triggers, stored procedures.
• Participated in meetings with the project managers and other key project team members as well as the Business partners to understand the complex requirements and technical specifications of the project and conducted the KT sessions with offshore team members on the same.
• Involved in Regression Testing on DEV / QA / UAT Environments.
• Identified the correct GUI web elements uniquely by using different types by locators like Id, Name, Link Text, CSS, XPath.
• Performed Cross browser compatibility testing using Chrome, Firefox, IE browsers.
• Performed Synchronization testing by creating Implicit wait, Explicit wait, and Fluent custom wait conditions to make sure the scripts work properly.
• Coordinated with the team members in creation and execution of automated regression suite.
• Automated the Smoke/Sanity test cases for the application using Selenium.
• Implemented Behavior Driven Development framework with cucumber that is developed by the core team to support UAT regression.
• Team player with leadership qualities to coordinate works and lead QA Team for EPMP project.
• Involved in preparing monthly QA metrics and Weekly status reports.

Project Environment: Selenium Webdriver, Selenium IDE, Rally, SharePoint, MS Office, SOAP UI, Rest Client, Perfecto, Java, TestNG, Jenkins and Maven, GIT.

Confidential, Irving, TX

IT - TDM Lead / QA Analyst

Responsibilities:

• Orchestrated the activities of TDM Team i.e., Test Data Management, which is responsible for on-demand data generation and provisioning of different kinds of non-production data-sets to meet the agile needs of multiple Testing and Development teams.
• Coordinated and Streamlined data activities for UAT, third party and PEN testing teams & educated them to arbitrate Defects/Issues.
• Coordinated with teams working on the different projects, completing the QA tasks. The tasks included performing Manual, Performance and Automated Testing of the functionalities. The projects were managed in Application Lifecycle Management (ALM, which is Quality Center's version 11.x).
• Data Requirements gathering from the Test Leads, BA’s; create Data creation and delivery plan.
• Analyzing the test scripts & finalizing the test data required (Test Data Matrix) to run the tests across various systems & DB’s.
• Planned, delegated and supervised the daily activity of TDM team according to Project/Test Priorities.
• Audit defects, Performed root cause analysis, diagnosed them to underlying issues with requirements, data or the process.
• Developed and Executed SQL queries in Toad to retrieve data, to check storage and accuracy of data in database tables.
• Validated the data through various stages/systems of data movement from Banking Systems (DB2) to Customer View to Core Trading Platform.
• Involved in Automating the Data Creation process with Selenium using Python.
• Assisted business analysts to clarify requirements' ambiguities, define user stories, and generate test data.
• Worked with development & Testing teams to assist with their troubleshooting, resolution and validation.
• Participated in Defect Triage meetings to review defects at the Program level while working with Cross Functional Teams.
• Aided in planning Data Migrations between Test Beds/Environments for parallel testing of different sprints and validating the rightness of migrated data for Test Purposes.
• Prepared detailed status reports and update the status to the business and technical teams during weekly review meetings.

Project Environment: Test Data Management (TDM), Toad, Mainframes, DB2, Oracle Database Enterprise Edition, UAT Support, Agile/Scrum, Selenium Webdriver, Eclipse, Python, PyDev, PyTest, HP QC/ALM

Confidential

QA Analyst /Test Consultant

Responsibilities:

• As the part of System Integration Testing (SIT) OM&E team, tested functionalities as well as integration of Order Management & Execution with the other systems/modules.
• Responsible to test the E2E functionality of different Order Types for the BUY & SELL of different Asset Classes.
• Reviewed the Business Requirement Documents (BRD) and System Requirement Specification (SRS) and developed the detailed System test plan.
• Worked closely with Business, Development teams to create test scripts and test cases to ensure coverage of all areas of the product/feature(s).
• Carrying forward the knowledge from CAT phase to SIT - Responsible to review & re-write the test scripts to attain better Test coverage.
• Created complex manual testing test cases from approved requirement and design documents and traced them to the relevant use case.
• Tested application on different Firefox & Google Chrome browsers for compatibility.
• Performing defect analysis to identify the Root-Cause i.e., which systems is causing the defect & assigning it to responsible Delivery partners.
• Performing Re-testing to evaluate the broken functionality is fixed and closing the defects.
• Involved in the project Kickoff meetings, Verification and Walk through meetings with team.
• Generating the Test Execution Report & Defect Report on weekly basis to communicate with client.
• Assisted developers with reproducing defects and providing additional information as needed.

Project Environment: HP Quality Center /Application Life Cycle Management, REST API, XML, MS Project 2007

Confidential

QA/Test Analyst

Responsibilities:

• Assessed & analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test Cases, Test data, Test procedures, Test reports.
• Owned several areas like Account opening, Client & Account data, Order Management & Execution and MI Reporting in this phase.
• Conversant with requirements analysis and defining high level and low level test requirements and detail test cases.
• Performed Acceptance testing on core trading platform using different test methodologies i.e., (Smoke, Functional, Integration, API, E2E) to ensure the changes, improvements made are not detrimental to the system holistically.
• Performed API/Web Service testing using Advanced RESTClient and Postman.
• Responsible for Test Data setup & Knowledge Transfer of Account Data as it is linked to all other modules.
• Identified, analyzed, and documented the bugs and issues with functionalities, output, online screen, and content.
• Performed initial debugging procedures by reviewing configuration files, logs or APIs (XML/JSON) and conducted exploratory tests to determine breakdown source.
• To ensure the tests has been run across all applications i.e., Admin (FNZ One) & Client GUI’s (GenUI) for the owned areas as per agreed contracts.
• Responsible for documenting work for quick references Guide utilizing MS WORD

Project Environment: Manual Testing, API Testing, Advanced REST Client, HP QC/ALM, Microsoft Excel, Google Chrome, Firefox, Microsoft outlook

Confidential

Software Test Engineer

Responsibilities:

• Played the role of QA to analyze business requirements, understanding design specifications to understand application functionality.
• Prepare detailed test cases, test scenarios, and schedules based on Requirements and Design documents and executed according to the test plan.
• Executed and maintained manual test cases. Performed Functional, System, and Regression Testing.
• Involved in manually testing of various modules of the application to ensure application stability and functionality.
• Performed System, Regression, Functional and User Acceptance testing.
• Conducted functionality, system and systems integration testing during the various phases of the project.

Project Environment: HTML, UI Testing, MS Office, Microsoft Excel, MS Word, Internet Explorer, Microsoft outlook, PowerPoint