SUMMARY

• Over 13 years of experience in Software Quality Assurance testing Web, and Client - Server Systems, database (ETL & BI) applications.
• Involved in all phases of software testing life cycles and have an excellent understanding of Software Development life Cycle used in different projects
• Experience in performing backend testing and writing SQL Queries for testing RDBMS such as SQL Server, Oracle, and Teradata for data integrity.
• Have experience working in Agile Environment
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Worked with different business users eliciting business rules and various Functional & Non-Functional requirements.
• Experience in requirements gathering by conducting Joint Application Development (JAD) sessions and Fit/Gap sessions.
• Expertise in creating scripts in Selenium-RC & WebDriver
• Proven ability in developing BDD scripts with Cucumber
• Reviews the test plans and test cases written by others for completeness and coverage.
• Extensive use of bug tracking tools like Mercury’s Quality Center for identifying, analyzing, and documenting defects.
• Conducted Root Cause Analysis in identifying system gaps and deficiencies that required a business and technical based approach for problem solving.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Team player with excellent Validation, Traceability and Analytical skills.
• Strong Verbal and Written communication skills.

TECHNICAL SKILLS

Operating Systems: Windows (XP/2000/NT/98/95), UNIX

RDBMS: Oracle, Teradata, TOAD, MS-SQL Server2005

Automated Test Tools: Selenium WebDriver/RC/Grid, Cucumber, Maven

Packages: MS Office 2003/2007.

Bug Tracking System: Quality Center, Test Director, Bugzilla, ALM, Jira

PROFESSIONAL EXPERIENCE

Confidential, Linthicum Heights MD

Sr.QA Analyst

Responsibilities:

• Implemented and maintained Page Object Model - added and updated new elements as required, created new page objects as required. Analyzed the page source to identify reliable locators for web elements.
• Createperformancescripts using JMeter and set up thePerformancetest scenario in Controller.
• Involved in developing BDD (Behavioral data development) framework and Test Environment Setup for Selenium Web driver/ Java.
• Worked on the migration from the legacy CARES system to Eligibility &Enrollment (E&E) application.
• Involved in creating cases for E&E application in consumer and worker portal with different MA (Medicaid) coverage groups, Food Stamp, Cash Assistance and Emergency Assistance.
• Mitigated the redundancy of Data Collection and maintained Data Integrity across the system.
• Worked on BI/BV interfaces testing. Performed data validations for Demographic files, CASH & SNAP daily and monthly benefit files.
• Validated the notices to be sent to Customers & Auth-Rep for all the programs. Triaged defects in JIRA with the notices development teams to make sure the correct template is followed during correspondence generation.
• Proficient knowledge in various types of software testing such as Usability Testing (UT), Smoke Testing, Sanity Testing, Positive and Negative Testing, Data Driven Testing, Regression Testing, Unit Testing, and Integrated Testing.
• Ensured content and structure of all Testing documents / artifacts is maintained.
• Tracked and reported upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
• Responsible for coordinating with the dev team for code movements into different test environments for sanity.
• Work closely with the customers/case workers in order to understand the requirement and create the test cases.
• Performed backend tests using SQL queries and written moderate SQL queries to perform database testing of the application.

Environment: Java, Qlik, Version One, DBeaver, JIRA

Confidential, Wilmington DE

Sr. QA Analyst

Responsibilities:

• Document or map business processes targeted for change both current and future state, as well as the next steps and other related outcomes
• Worked with the Project Management, Product Owner and Scrum team to determine the Product that could be released for the customers to use.
• Communicate and translate business requirements effectively between business areas and IT organization
• Participated in daily scrum meetings to discuss the application features, test cases and related issues.
• Troubleshoot on Splunk and track the actual root problems and issues
• Actively involved in QA process improvement activities - process flow, problem resolution and bug tracking in JIRA
• Automated regression test cases using Java and Web driver
• Test GUI and functionality on Android and iOS mobile devices
• Planned, Implemented and Documented all aspects of software QE including manual and unit test, integration, regression, stress and performance testing.
• CreatedCucumber Feature Filescomprising of various Test Scenarios andStep Definitionsfor BDD (Behavior Driven Development).
• Maintained the Selenium & JAVA automation code and resources in source controls over the time for improvements and new features.

Environment: Java, Selenium WebDriver, Cucumber, Maven, JIRA, SPLUNK

Confidential, Cary NC

Sr. QA Analyst

Responsibilities:

• Worked closely with SME’s to clarify requirements and to translate them into technical specifications.
• Analyzed and reviewed Business requirements Document (BRD) and System requirements.
• Worked closely with BAs and ETL Leads/Managers and was responsible to perform detailed data requirements analysis and create design specifications and operational documentation
• Developing procedures for improving and standardizing QA methodology and processes
• Performed Data mapping to identify the source data to be moved into target tables.
• Extensively used SQL Queries for data analysis, system verification and validation by joining tables
• Involved in creation of automation framework in Selenium WebDriver using behavior driven approach like Cucumber Designed smoke, sanity, acceptance, functional and regression test cases.
• Generated Selenium reports using JUnit reporter and automated report generation using ANT.
• Used Ant for building the WebDriver project. Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.
• Work with cross-functional teams to solve problems and implement changes.
• Performed data validation based on transformations and extraction
• Performed data quality checks on all internal and external vendors files by identifying the NPI (Nonpublic Personal information) columns (like loan id, application identifier, customer first name, customer last name, phone number, etc.) and building queries for different checks like (null check, length check, validity check, numeric and alphanumeric check).
• Analyzed system requirements and created Use Case Diagrams, Activity Diagrams using Visio

Environment: MS Visio, MS Office, MS Project, DB2, Quality Center, MS SQL Server, Blue Print,Cucumber,Selenium,ANT,JENKINS

Confidential, Richmond VA

Sr.Configuration QA Analyst

Responsibilities:

• Worked closely with SME’s to clarify requirements and to translate them into technical specifications.
• Requirement gathering, impact analysis activities and writing high level and low level design documents.
• Accountable for ensuring user stories to have acceptance criteria.
• Involved in the Backend testing by executing SQL statements.
• Analyzed and reviewed Business requirements Document (BRD) and System requirements.
• Performed GUI functional and sanity testing manually for each new build of the application
• Performed data validation based on transformations and extraction
• Extensively used Macros to automate existing processes for Sox Control Audits
• Performed Data mapping to identify the source data to be moved into target tables.
• Configure the pricing rules for the redemptions in Mongo Database for different categories.
• Used Beyond Compare tool to compare the versions of the file before loading data to the database.
• Optimizing the complex queries for data retrieval from huge databases.
• Test GUI and functionality on Windows 7, MAC OS X, Android, iOS platforms
• Test GUI and functionality on Android and iOS mobile devices
• Performed Data mapping to identify the source data to be moved into target tables.
• Used Teradata SQL Assistant to process business requests and to extract data.
• Performed the tests in both the SIT, QA and contingency/backup environments

Environment: Teradata, Teradata SQL Assistant, Postgres, Mongo, Version One

Confidential, Wilmington, DE

Sr. QA Analyst

Responsibilities:

• Extensively used Quality Center for test planning, bug tracking and reporting.
• Discussions and meeting with all the stakeholders involved in the projects and keeping them updated with progress.
• Developed Test Plan, Test cases, test scenarios, expected results and prioritized tests
• Review the test cases written for integration and functional testing as per the scenario
• Responsible for writing and running the Manual Test Cases in Microsoft XL and Microsoft Word and importing into ALM
• Extensively used ALM for test planning, bug tracking and reporting.
• Performed GUI functional and sanity testing manually for each new build of the application
• Responsible for thorough testing of browser and platform compatibility issues
• Execute Browser Compatibility Testing(IE, Firefox, Chrome, Safari) of a Web based application
• Create and execute End to End Use Cases for User Acceptance Testing
• Test GUI and functionality on Windows 7, MAC OS X, Android, iOS platforms
• Assisted in preparation and prepared documents and technical specifications using Microsoft Word and Visio.
• Involved in data validation, data scrubbing, data cleansing for data coming from sources during data migration/conversion.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Worked with business to establish and maintain a consistent test methodology and to resolve general questions during the testing process.

Environment: ALM, QTP, Microsoft Office, UNIX, Oracle

Confidential, Richmond, VA

Sr. ETL QA Analyst

Responsibilities:

• Performed testing in agile scrum methodology and involved in daily scrum meetings.
• Involved in Understanding of ETL Mapping document (Ab Initio) and to validate source database to Target database.
• Performed backend testing using SQL queries to check backend data and data integrity.
• Executed Test cases using Quality Center in Test lab.
• Worked with the development team to create a suite of test data to exercises data validation and actual ETL functionality.
• Assisted in the implementation of QA processes to ensure correctness of data flowing through each stage of ETL process.
• Involved in executing the UNIX shell scripts for loading the data from the Source to the Datamarts.
• Validating the Archive process to purge the data that meet the defined business rules
• Involved in writing the Integration, System and Regression Test Cases
• Imported existing Test Cases from Microsoft Excel to Quality Center.
• Automated manual tests under regression using QTP for GUI and functionality testing.
• Participated in Testing Methodologies like Planning, Execution, Bug Tracking and Analysis meetings
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Involved with ETL test data creation for all the ETL mapping rules
• Extensively involved in Functional, Regression and Backend Testing.
• Assisted business users to perform User Acceptance Testing (UAT).
• Co-ordinating with offshore team in allocating the tasks.
• Developed automated test process. Used to create scripts for regression testing.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Tested daily, monthly and quarterly loads end to end.

Environment: Quality Center 10, UNIX, putty, Teradata, Microsoft Word, DB Visualizer, Oracle11i, ALM, QTP

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Involved in writing Test plan and test cases by reviewing requirements document
• Conducted Defect Review meeting twice a week to discuss regarding progress of project.
• Extensively used Quality Center for test planning, bug tracking and reporting.
• Managed the overall testing effort, including coordination of testing personnel and test lab resources.
• Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.
• Involved in manual testing of application.
• Bugs were reported to developers using Quality Center after rectification from developers and then Regression testing was performed.
• Coordinated in testing with UAT team - clarified requirements, shared test cases and provided test data
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Performed Functionality testing using QTP
• Created and managed in Object Repository in Quick Test Pro (QTP)
• Wrote detailed test case checklists and test cases for the Scanner.
• Conducted browser compatibility testing in various browsers like Mozilla Firefox, Safari, Netscape Navigator and Mac operating system
• Tracked QA task progress, mitigated risks, took corrective actions, resolved issues with parties involved and escalated as needed.
• Responsible for executing the test cases for Personal Accounts and Business Accounts that included both Checking and Saving accounts
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Identifying Critical test case on each release and updating Regression Suite
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing and End to end Testing of ETL code and reports.

Environment: J2EE, Oracle 9i, HP Quality Center 9.2, Windows XP, QTP

Confidential, Columbus, OHIO

QA Analyst

Responsibilities:

• Analyzed and reviewed Business requirements Document (BRD) and System requirements.
• Involved in System Testing for the above application for Manual and Automated Testing.
• Involved in preparing Test Plan document based on business requirements and system requirements.
• Tested the back end Data Base by preparing Queries with SQL to retrieve data from database.
• Prepared detailed test procedures, test scenarios, test scripts and schedules based on requirements and test design documents.
• Wrote detailed test case checklists and test cases for the product, including traceability matrix to requirements
• Performed Functionality testing using QTP
• Created and Performed Data Driven Testing
• Performed cross browser testing to ensure compatibility of the application on IE and Netscape
• Tested the ETL process for both before data validation and after data validation
• Executed the test scripts and compared the Actual and expected results
• Tested reports by creating Reporting queries and validated them for accuracy.
• Maintained the Quality Center for backups, adding new Users, Projects and Domain.
• Involved in Handover meetings, Business Analysis and design reviews for each release.
• Effectively coordinated with the users and development team.
• Coordinated in testing with UAT team - clarified requirements, shared test cases and provided test data.
• Tracked the defects by using Quality Center.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Created and executed batch tests on the refined application interfaces.
• Conduct manual and automated testing to ensure deliverables as per client specifications and testing the Modules according to user requirement.
• Prepared the Test Approach document
• Tested the Database integrity by writing SQL queries

Environment: J2EE, Oracle, HP Quality Center9.2, Quick Test Professional, MS Office 2003, SQL, TOAD, QTP