­­­­

PROFESSIONAL SUMMARY:

• Over 11 years of experience as a Quality Assurance Analyst and Test Engineering in all phases of Manual and Automation Testing in Banking, Insurance and Health care domains.
• Experience in Requirement Analysis, planning, design and execution of software Testing Activities and Quality Assurance activities of multiple applications.
• Experienced in different SDLC methodologies.
• Coordinated with Project Managers, Development Team, Business Analysts, and End - Users for better quality testing. Worked closely with business team to understand the Requirement Document in creating Test Plan.
• Designed and built Test Cases, developed, maintained and troubleshot Test Scripts, coordinated with team members in debugging effort and assisted developers in Root Cause Analysis and clarified them the results.
• Achieved proficiency in creating Requirement Traceability Matrix (RTM) and Bug Reports.
• Performed execution of test using Automation tools like Confidential Quick Test Professional (QTP/UFT), AXE tool and Selenium.
• Strong experience in Automating web applications using Selenium WebDriver with TestNG framework.
• Proficient in Java programming, Selenium WebDriver, Junit.
• Experienced in writing Test cases using locators, TestNG Annotations.
• Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, TestNG and selenium Grid.
• Good exposure in using of UFT (formerly QTP) Integrated environment (Step Generator, Synchronization, Actions, Recovery Scenario, Methods etc.
• Performed functional web services testing using SoapUI.
• Skilled in defect tracking, recording, and prevention techniques, and Bug Life Cycle process.
• Extensively used SQL to perform backend testing.
• Created Stored Procedures.
• Experience in preparation of automated tests within the Keyword driven Automation framework.
• Experience in regression test of automation scripts within the Data driven Automation framework.
• Expert in Confidential 's Quality Center for Test Designing, Requirement Mapping, Reports and Defect tracking.
• Maintains proper co-ordination with offshore team. Assigning work to offshore team and helping them technically and process related whenever needed.
• Created various Testing Metrics in the various status reports like Weekly Status Reports, Monthly Dashboard and Test Summary Reports.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining test scripts according to the business specifications.
• Extensive Technical debugging skills to assist in root cause analysis and provide possible solutions.
• Evidenced and recognized for high productivity, attention to detail, problem solving skills and the ability to effectively engage and meet the needs of Business Requirements.
• Requirement Analysis, Use Cases, Planning and Monitoring the Traceability.
• Software Test Planning, Design and Execution for Functional Testing, Manual Testing, ETL Testing& Automation Testing.
• Integration, Regression, Functional, and User Acceptance Testing.
• Business and Software Requirements Management.
• Quality Assurance & Quality Control

TECHNICAL SKILLS:

Testing Tools: QTP/UFT, Quality Center, Test Director, ALM 12, AXE tool, Selenium, Eclipse Jee Oxygen.

Programming Language: SQL, Basic UNIX, Mainframe, JCL, Understands Cobol Programming, JAVA

RDBMS: SQL, MS Access 2000/2007

Tools: TOAD, TERADATA 13.x, BRE, ACE, SQL Developer

Web/Technologies: HTML, XML, SoapUI

Operating Systems: Windows (8,7, Vista, XP, 2000, 98), Linux/Unix, Insight, Netezza

Other Tools: JIRA, SharePoint, MS Office, Teradata SQL Assistant, SVN, MAT, Informatica.

PROFESSIONAL EXPERIENCE:

Confidential, WINSTON SALEM, NC

System Quality Analyst

Responsibilities:

• Validated the Business rule specifications and the application functionality as per the Business requirements in BRD.
• Validated the business rules against the IHUB data mart SOR tables by creating the Test data, SQL queries, Automated and manual test cases.
• Created Test Cases using Element locators and Selenium WebDriver methods.
• Enhanced Test cases using Java programming features and TestNG annotations.
• Executed Selenium Test cases and provided reports.
• Performed Regression Testing using Selenium.
• Performed validation of the payments in Android mobile emulator using SoapUI tool.
• Worked with team members for setting up web services project using WSDL in SoapUI.
• Analysed the client server response codes by comparing it with DTD (Detail Technical Design) document.
• Updated SDLC tracker.
• Validated the status of exceptions.
• Created Test data for Exceptions validations.
• Perform UI testing for ISAM application and validated the UI data with DB data in SQL server.
• Validated SSRS reports in ISAM application and compared the data with DB data.
• Supporting and coordinating onsite/offshore teams.
• Participates in all the review sessions, planning meetings and discussions.
• Mapping processes, collects data and analyses processes to uncover root cause of problems.
• Work with Business teams for process Improvement.
• Co-coordinating and maintaining relationship with other teams.
• Prepared Test Plan, Requirement Traceability Matrix (RTM).
• Provided estimation for the testing effort to my manager.
• Performed gap analysis.
• Provides status report to my manager.
• Worked on Cloud Migration validation for OMDM and ISAM applications.
• Worked on Exadata migration validation.

Environment: Confidential ALM, Confidential UFT, BRD/SRS, SQL, SQL Scripts, UNIX, Teradata, ETL, OLAP, OLTP, TOAD, VB Script, XML, PL/SQL, Oracle, SQL Server, Teradata, SSRS, Informatica, JIRA, SVN, JavaScript, Exadata, cloud Migration, SoapUI, Java, Eclipse, Selenium.

Confidential, Dover, NH

ETL Test Lead

Responsibilities:

• Participates in all the review sessions, planning meetings and discussions.
• Mapping processes, collects data and analyses processes to uncover root cause of problems.
• Work with Business teams for process Improvement.
• Co-coordinating and maintaining relationship with other teams.
• Supporting and coordinating onsite/offshore teams.
• Used Splunk and Teradata viewpoint to generate metrics.
• Used DVR tool for comparing the records between different environments like Bigdata, Teradata and Oracle.
• Automated the process of DDL validation using Macros which helped in reducing 85% of manual effort.
• Used RTC and JIRA for logging and tracking the issues.
• Designed Test cases Using Selenium WebDriver and TestNG.
• Enhanced the Selenium Test cases for Cross browser testing.
• Involved in Regression Testing using Selenium.
• Validated ETL transformations.
• Validated ETL extracted business secured data using hash method.
• Extensively used knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modelling techniques.
• Experience in preparation of SMR (Senior Management Review), WSR (weekly status report) and Client MSR (Monthly Status Report) decks.
• Used Data profiling tool like Dataflux for profiling the data.

Confidential, Greensboro, NC

Sr. QA

Responsibilities:

• Participates in all the review sessions, planning meetings and discussions.
• Mapping processes, collects data and analyses processes to uncover root cause of problems.
• Work with Business teams for process Improvement.
• Co-coordinating and maintaining relationship with other teams.
• Supporting and coordinating onsite/offshore teams.
• Validate the Nat Penn data in the Nat Penn system and mapped it with Confidential & Confidential data for sweep account, ZBA account and Choiceline account.

Confidential, Hartford, CT

QA ETL Test Lead

Responsibilities:

• Participates in all the review sessions, planning meetings and discussions.
• Mapping processes, collects data and analyses processes to uncover root cause of problems.
• Work with Business teams for process Improvement.
• Co-coordinating and maintaining relationship with other teams.
• Supporting and coordinating onsite/offshore teams
• Does quality audit on behalf of the project.
• Provides Test statistics and metrics to Managers.
• Analysed XML files in Pipeline application for the data verification in testing
• Analysed the requirements from Clients and prepare Test Case as MIS number.
• Performed load validation using SQL.
• Planned, documented and tested extensive data integration process to a data warehouse and data mart.
• Implemented effective data quality testing standards, verification procedures and tools.
• Developed and presented executive level data quality status and process improvement.
• Used Confidential Quality Center: Test Center, Test Lab, Defect management.
• Validated the extracted data from Abinitio tool.
• Validated the Abinitio graphs.
• Developed & executed an advanced plan to improve data testing with tools and the QA process with industry best-practices.
• Developed & executed an advanced plan to improve data testing with tools and the QA process with industry best-practices.
• Extensively used Teradata to verify source data and target data after the successful workflow runs using SQL
• Involved in writing complex SQL queries by combing data from multiple tables with various filters
• Holds strong experience in working in the complete Software Test Life Cycle (STLC) within 'Traditional, moderated and Agile methodology testing projects'.
• Thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• In depth technical understanding of Data Warehousing, Data Validations, OLAP.
• Experience in creating Test Data, Analysing Defects and interacting with development team to resolve issues.
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Experienced in Creating and maintaining SQL Scripts to perform back-end testing on databases
• Excellent communication skills, ability to work as part of a team and on own. Versatile team player with interpersonal, technical documentation skills and efficiently handling multiple projects simultaneously.
• Created a Macro which automated the PDR process and helped in saving 90% of manual effort.

Environment: Confidential ALM, Confidential QTP, BRD, MIS, SQL, SQL Scripts, UNIX, Teradata, ETL, OLAP, TOAD, Macros using VB Script, XML, JCL, BRE, ACE (IT Express).

Confidential, Charlotte, NC

Sr. QA ETL

Responsibilities:

• Participates in all the review sessions, planning meetings and discussions.
• Does quality audit on behalf of the project.
• Provides Test statistics and metrics to QA Managers.
• Mapping processes, collects data and analyses processes to uncover root cause of problems.
• Work with Business teams for process Improvement.
• Co-coordinating and maintaining relationship with other teams.
• Supporting and coordinating onsite/offshore teams.
• Done testing on Waterfall model and Agile methodology.
• Prepared and implemented detailed test plan for the complex financial reports which included Quantitative (Data Testing) and Qualitative (Business Rules Implementation) testing.
• Analysed the Requirements from client and developed Test cases based on functional requirements, general requirements and system specifications provided as JIRA Ticket Number.
• Worked as QA Lead and performed the overall responsibility of modules and worked with other developers and ensured smooth delivery.
• Analysis of requirements and use case documents. Work with business analysts and address the gaps in requirements.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.
• Experience in Bug Tracking and Reporting using Test Director/ Confidential Quality Center.
• Work closely with client architects and formulate design for the individual modules. Prepare Technical design documents (TSD’s).
• Used PDF comparator and Excel comparator tool for validation of the pdf and excel Actuate reports.
• Discussed test cases for regression testing with quality engineers for each build and validated and executed ETL jobs scheduled in Autosys.
• Used MAT (Manual adjustment tool) to perform database insert, update and delete.
• Provided insight to the developers to enhance the system efficiency by redesigning few modules to make them reusable.
• Extensive work on SQL which included writing complex SQL queries,
• Delivered various test matrix documents like UAT defect analysis report, root cause analysis, Project test effectiveness, Prod defect analysis report, and defect acceptance report as a part of test deliverables.
• Used MAT (Manual adjustment tool) to perform database insert, update and delete.

Environment: Confidential QC, Confidential ALM, Confidential QTP, BRD, JIRA, MAT, UAT, Teradata, TOAD, SQL, ETL, UNIX, Autosys, Macros using VB script, JIRA, SVN.

Confidential

Senior Test Engineer

Responsibilities:

• Reviews all document (for example, BRD, SRS).
• Reviews and provides input to test plans, traceability matrix, test tracking documents, and test calendars.
• Participates in all documentation peer reviews.
• Prepared and implemented detailed test plan for the complex financial reports which included Quantitative (Data Testing) and Qualitative (Business Rules Implementation) testing.
• Analysis of requirements and use case documents. Work with business analysts and address the gaps in requirements.
• Identifies high risk areas specific to a project.
• Assists with the coordination of other application’s testing needs as it relates to an assigned project.
• Prioritizes test objectives and functions.
• Creates test scenarios and cases based on all documentation and traceability matrices Write scripts
• Defines and conditions test data.
• Experience in preparation of automated tests within the Keyword driven Automation framework.
• Experience in regression test of automation scripts within the Data driven Automation framework.
• Good exposure in using of QTP Integrated environment (Step Generator, Synchronization, Actions, Recovery Scenario, Methods etc.
• Assigns data to specific scripts, if necessary
• Obtains and maintains test Ids and passwords, if applicable
• Test Execution and Implementation.
• Follows testing schedule as directed by the Offshore Lead.
• Executes tests (positive and negative).
• Maintains and reconditions data as needed during test.
• Verifies all results through the application as well as the various “back-end” applications.
• Documents and validates problems and defects found during testing.
• Reproduces all errors found and provide detail documentation (e.g. screen prints, step-by-step reproduction instructions).
• Reports defects and issues to development via defect tracking tool.
• Tracks and records data entry and scripts completed for Offshore Lead.
• Reports any adverse testing conditions to the Offshore Lead (environment issues, etc.).
• Tracks and records data entry and scripts completed for Offshore Lead.
• Attends daily status meeting, discuss defects and issues found in Retests corrected defects and issues.
• Executes regression tests.
• Provides testing statistics and metrics to Test Lead.
• Participates in lessons learned, listing what went well as well as future improvements.
• Updates scripts and stores in script library.
• Executed Automated Scripts using QTP and AXE tool.

Environment: Confidential QC, Confidential QTP, PowerBuilder Applications, web testing, AXE Tool, Dartnet.

Confidential

QA Test Engineer

Responsibilities:

• Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.
• Performing Integration testing for documenting the results.
• Executed the test cases for Staging Tables and Member tables and validate the data results.
• Updated the test cases on based on the requirement changes and executed the test cases.
• Prepared Test Plans, Test Scripts, Test cases and validated the Test cases.
• Created and monitored daily incident Report.
• Involved in Regression, Release and System Integration testing.
• Involved in Reference tables updates as part of Testing.
• Used Quality Center for the bug tracking purposes.
• Participated in validating (front end) dashboards/reports, and documented results.
• Included in meetings with the Development Team to discuss the open defects.
• Supporting and coordinating onsite/offshore teams.
• Good at multi-tasking and working well under tight deadlines with high efficiency.
• Ensure all software products, applications and data meet the highest quality possible by following industry recognized QA methodologies and best practices
• Utilized Quality Center and Test Director Defect Management tools.
• Analysed various documents and prepared test cases covering all requirements of the application.
• Converted test cases for various test sets to organize execution procedures to meet project time line and deliverables. Tested functionalities of the application.
• Created documentation for client’s future use.
• Participated in overall end-to-end testing.

Environment: Confidential QC, BRD, CICS, JCL, Test Director, Defect Metrics.

Confidential

QA Tester

Responsibilities:

• Involved in BRD and TDD through WPR meeting session with Project Managers, Business Analysts and Business Clients to prepare test scenario.
• Performed Smoke testing, SIT and UAT.
• Used Transaction Management tool in different test environments to identify the claim files integrity.
• Created X12 and XML files based on different claim scenarios for HIPPA (5010) EDI transactions like 837/835.
• Validated different claim transactions in the Spec-Builder using HIPPA compliant.
• Used SQL developer to validate the extracted data in Oracle database.
• Involved in daily stand up meeting and Release meetings.
• Maintained and delivered the test results timely to all the stakeholders.

Environment: Windows 2007, Quality Center 10.0, HIPPA/EDI, Edifec/Spec Builder.