SUMMARY:

• Experienced Professional with 7+ years of experience in the field of Information Technology with an emphasis on Quality Assurance and Automated Software Testing.
• Proficient in Manual Testing, Automation Testing, Web Services Testing, ETL Testing, Data validation, Developing test plan, test cases, requirement traceability Matrix and writing SQL.
• Experience with HP ALM, Quality Center, Jira to develop Test plan, Test cases, executing Test cases in Test lab, and creating and tracking defects in Defects module.
• ASTQB Agile Tester
• ASTQB Foundation Level certified Tester
• MCP ( 70 - 461 Querying MS SQL Server 2012).
• Experience in testing ETL, web based & client server applications, data analysis & data validation, report and user interface testing.
• Efficient in writing queries and creating scripts using inner, outer, self joins, sub- queries, co-related sub-queries using operators of except, union and the various other SQL functions such as sum, min, max, count etc.
• Experience in data validation by row count, data type match, length validation, Null validation, checking constraints and identifying data mismatches.
• Experience in HP ALM, Quality Center, and Jira in the development and execution of test cases and defect management.
• Performed Extraction, Transformation and Loading (ETL), Change Data Capture, Incremental Load testing.
• Involved in functional web services testing using SOAP UI.
• Able to compare data from heterogeneous data source using excel.
• Knowledge in star and snowflake data warehousing modeling schemas
• Query optimization including reviewing of indexes & execution plans.
• Knowledge in UNIX command and scripting.
• Knowledge in scheduling tasks using Windows Task Scheduler, AutoSys and Cron Jobs.
• Experience in Automating web applications using TestNG Framework, POM, Selenium IDE, Selenium web driver using Java.
• Knowledge of Jenkins, Cucumber.
• Familiarity with Waterfall and Agile SW development cycles and testing methodologies.
• Experience in Regression, Unit, Functional, Integration/System, User Acceptance testing, Security testing, Cross platform, Scalability, Usability, Smoke Testing.
• Strong problem solving skills from problem identification and analysis to the resolution of the issue.
• Able to work in multi-platform Environments like Windows and UNIX.
• Proficient in using tools like SQL Management Studio, Aginity Workbench, SQL Developer and strong understanding of Relational database concepts.
• Knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Leadership skills include effective communication skills, problem solving skills, dependable and productive, eager to learn new skill sets, works well with other team members and maintains a flexible work ethic.
• Knowledge of Black-Box testing techniques, Smoke testing, Sanity testing, performance testing, load testing, stress testing, Exploratory testing, browser compatibility testing, cross browser testing, UAT Testing.

EXPERIENCE:

Sr QA Analyst /Program Analyst

Bethesda, MD

R & R:

• Involved in testing the data flow from flat file source to Staging SQL Servers then to Netezza the Data Warehouse appliance.
• Involved in Metadata testing by validating row counts, data type matches, length validations, null validations, and check for constraints.
• Created flat files (csv, tab) based on the data mapping documentation and tested the data flow.
• Validated the ETL data flow processes by using the mapping documentation and transformation rules.
• Comparing data between SQL Server and Netezza by reviewing the data transformation logic and writing SQL to match the same using ANSI standard inner joins, outer join, union, except operators etc.
• Attending review meeting, presented project progress and status, and testing data validation methods used.
• ETL Audit table testing using SQL Script after ETL processing.
• Tested Web Services using SOAP UI. REST Web Services was implemented and JSON data format used for data sharing.
• Verification of ETL packages to ensure right mapping of columns, right source and destination before deployments.
• Tested the files processed after the Scheduled File Watcher jobs and validated the data in the database once the ETL Job is done
• Performed negative testing by simulating errors in the stored procedures and correcting alert generation.
• Experience in developing SQL queries to successfully retrieve and manipulate data for database validation
• Written SQL Queries in Netezza for validating the Cognos reports based on Report Specification document.
• Used Jira to review, track and resolve Testing Incidents, Business Incidents and Change Request.
• Provided feedback when reviewing Test Plan and Design Documents against the Requirements. Provided regular update to the Requirements Traceability Matrix.
• Involved in creating the Test plans, Test cases and performed testing for MS Sql Server 2008 upgrade to MS Sql Server 2016.
• Understand fundamental clinical research processes and data needs.
• Cognos Report testing including UI testing, Functionality testing, Security testing and Performance testing, UAT testing
• Report data validation of standard and pivot reports against database.
• Provide data validation of clinical data for Natural Language Process Pilot (NLP)
• Written Test Scripts using java for automating the regression suite for NIH web application(Cognos) testing in IE, Firefox and chrome with TestNG Framework

Environment: Jira, Jira Agile, MS SQL Server 2012, 2016, SSIS, Netezza, Cognos, MS Office, (Excel, word), Soap UI Tool,Aginity Workbench, SFTP, Iguana Server, Oracle 10G, AutoSys Job Scheduler, Eclipse, Selenium web driver, TestNG, Java

QA Tester

Mclean, VA

R & R:

• Involved in testing the compatibility of the 4 applications on IE11, Firefox and Chrome.
• Prepare test cases for browser compatibility testing.
• Mapped Requirements to test cases.
• Executing test cases and Logging defects in HP ALM.
• Preparing test result documents.
• Involved in Compatibility, Cross Browser, Functionality, Smoke and Regression testing.

Environment: HP ALM, IE9, IE11, Google Chrome, Firefox, MS Word and MS Excel, IBM Rational Doors, Virtual Desktop Interface (VDI).

QA Tester

R & R:

• Involved in developing Test plans, Test cases based on the requirement document from business analyst.
• Mapping the source data to destination tables
• Involved in the GUI and functional testing of the interface used by Aetna Business for viewing and Involved in testing of the usage of data by downstream application. 
• Worked with Business Analyst to map business requirements to test cases.
• Hands on experience working on Test management tool like HP ALM for writing and executing Test cases and Defect management.
• Executing Test cases in Test lab, and creating and tracking defects.
• Tested Web Services using SoapUI tool .
• Validated WSDL, request and response XML. Added Assertions to validate the response
• Writing SQL Queries to test, confirm data integrity. 
• Preparing and presenting reports to track the execution of Test cases and defects

Environment: HP ALM, Java, WebSphere, MS SQL Server, SoapUI, MS Word and MS Excel.

Rockville, MD

QA Tester

R & R:

• Executing manual regression tests for ARI applications. Agile development methodology was used, with releases every 2 weeks.
• Prepare test cases based on requirement document in Quality Center.
• Revise and update regression test suite.
• Co-ordinate with off-shore regression testing team for the integration of ARI with other applications.
• ARI release co-ordination with end users.
• Write SQL to validate the ETL flow is providing the desired results.
• Prepare performance comparison report for modified business critical stored procedures.

Environment: Quality Center, SQL Server 2008, Windows 2008/7/Xp, .Net, SharePoint.

Tester

R & R:

• Involved in developing Test plans, Test cases in Excel.
• Executing Test cases in Test lab, and creating and tracking defects.
• Involved in GUI, Functional, Integration testing.
• Preparing and presenting reports to track the execution of Test cases and defects
• Verify table schema to ensure the right constraint like check, referential exists to map to the business requirements.
• Ensure database objects have error handling defined.

Environment: ASP, SQL Server 2000/2005, Windows 2003, ASP, MS Word and MS Excel