OBJECTIVE

• To obtain a challenging position as Senior QA Tester/Bigdata Tester/ Data warehouse Tester/ETL Tester wif an emphasis on Data Warehousing to utilize my qualification and experience in Data Validation, Data Modeling, Test Case Designing and Bug Reporting successfully.

SUMMARY

• Over 7+ years of experience in manual/automation testing on web based, Client/Server and data warehousing applications.
• Well - versed wif all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in preparing Test Strategy, Developing Test Plan, Detailed Test Cases, Writing Test Scripts by decomposing Business Requirements, and Developing Test Scenarios to support quality deliverables.
• Expertise in QA process and different levels of testing like Functional, Regression, Smoke, Sanity, Load and End-to-End Testing wif business scenarios.
• Good understanding wif Business Requirement Documentation (BRD), Functional Documentation and System Requirement Specification (SRS).
• Prepared Traceability Matrix for Test Coverage using Test Management Tools.
• Experienced in Development Methodologies like Waterfall and Agile Methodology.
• Expertise in development of Test Cases and Defect Tracking using RALLY, JIRA, HP Quality Center/ALM, and UFT.
• Good Experience in testing SOAP webservices and REST APIs by using SOAP UI and Postman.
• Experience in Google Cloud Platform (GCP) Components wif data validation from On-prem to FHIR store.
• Performed Database Verification and Validation testing using SQL/Microsoft SQL/HQL/IBM data studio/ Teradata Studio Express.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Expertise in testing diverse source systems such as relational table, flat files, and XML files, Jason files.
• Validating the data files from source to make sure correct data TEMPhas been captured to be loaded to target tables.
• Well versed inGoogle Cloud Platform, Bigdata Hadoop, UNIX, and Windows Environment.
• Experiencewif automation/ integration tools likeJenkins/Tidal.
• Sound knowledge of quality assurance procedures and testing Java applications.
• Good knowledge on Selenium suite of Tools (Selenium IDE, Selenium RC, Selenium WebDriver, and Selenium Grid).
• Participated in Meetings and Walkthroughs, interacted wif other development team members to better understand system functionality in order to improve testing quality.
• Excellent Analytical, Problem solving, decision making and presentation skills.
• Can adopt to any newer technology or software at a greater pace, able to define and fulfill the project’s goals.

TECHNICAL SKILLS

QA/Testing Tools: Rally, Jira, HP-ALM, UFT, SoapUI, Postman, IBM Data Studio, Teradata Studio Express, Agility Pro.

RDBMS (Databases): Oracle SQL, MS SQL, DB2, HIVE HQL, Teradata.

ETL Tools: Informatica.

Programming Languages: PL/SQL, JAVA.

Scripting Languages: SQL Scripts, UNIX Shell Scripts.

Operating Systems: Windows, Unix.

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Scheduling Tools: Tidal, Jenkins, Splunk.

Other Tools: Confluence, SharePoint, Skype, Microsoft Team, Cisco WebEx, Putty, Secure CRT, Text Pad, Word ++, Word Pad.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Senior Analyst, Quality Assurance

Responsibilities:

• Analyzed business and user requirements to prepare test plans, test procedures, test cases, and test scripts.
• Worked in Agile Software Development methodology and participated daily scrum meetings to provide the daily updates and collectively document the team updates.
• Validated data in Google Cloud Platform (GCP).
• Validated data from source to Pub Sub and GCS bucket.
• Involved data harmonization process.
• Performed Big Query.
• Maintained log and altering through Splunk Log.
• Execute the API endpoint using Postman/SoapUI.
• Validated data using the Hive Queries for analyzing big data in Hive warehouse using Hive Query Language (HQL).
• Involved in validating the source data wif the target data in Data Warehouse (Data Migration).
• Validated dataflow pipelines which ingested from real time and batch processing.
• Involved in extensive data validation using SQL queries and back-end testing
• Worked wif developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Test newly developed features to ensure proper functioning prior to release to QA for multiple processes.
• Reviewed Data modeling, Data dictionary, Data mapping and architecture for Data flow during architecture and design phase in various projects.
• Prepared test report in QA phase and E2E testing in QA environment.
• Involved in setting up the testing environments and prepare test data for testing flows to validate and prove positive and negative cases.
• Performed variousHadoopcontrols like date checks, record checks, balance checks, threshold limits for records and balances.
• Performed Defect Reporting, Analyzing, Tracking and Report Generation using Rally.
• Involved in ETL process testing using Informatica ETL tool.
• Scheduling and run Jobs through TIDAL.
• Work wif theQAand Project Managers to set and evaluate milestone criteria to ensure released products are on schedule wif high quality.
• Coordinate and attend different team meeting,Sprint Planning, Retrospective, Review,anddailyScrum meeting.

Environment: GCP, HDFS, Map Reduce, Hive, DB2, SQL, UNIX, Data Warehousing, Rally, Agile, Tidal, UDP, Aginity Pro, IBM data studio, Microsoft team, Confluence, SharePoint, Teradata Studio Express, Splunk.

Confidential, Bloomfield,CT

QA Analyst

Responsibilities:

• Involved in all stages of SDLC from conception to completion.
• Involved in analyzing Business and Technical requirements, developing Test Strategy document, Test Plan document, Test cases and maintaining RTM documentation.
• Built the test scenarios for various types of requests and performed Manual Testing whenever required.
• Analyzed application data using the SQL to identify the ETL processes.
• Supported the extraction, transformation, and load process (ETL) for a Data Warehouse from their legacy systems usingInformatica.
• Wrote SQL queries to test Data Integrity, Referential Integrity and performed Database Testing for the Application.
• Execute the API endpoint using Postman/SoapUI.
• Worked wif customer requirements and the peers to drive test execution and automation
• Involved in setting up a test automation and execution framework.
• Performed Regression and Integration testing to test the functionality of the modules.
• Responsible fortesting software application for inbound/outbound interface transactions for clinical integrations.
• Participate in troubleshooting and triaging of issues wif different teams for root cause analysis and providing resolutions (specially immunization code).
• Automated regression test suite and performed smoke test using SELENIUM.
• Worked wif Users and Business Analysts to define and design Test Scenarios and Test Data.
• Maintained Test Matrix for the latest test results information
• Attended periodic meetings, teleconferences and led discussions on problem resolution
• Provided inputs to Development and Project Management teams on software design and on ways to increase product testability to support more extensive test automation.
• Analysis of the test result, identification of defects and preparation of test reports, defect reporting in Jira, follow-ups, and defect resolutions.
• Used Jira for bug tracking and reporting, also followed up wif the development team to verify bug fixes and update bug status.
• Coordinated program level work between onshore and offshore team.
• Coordinate and attend different team meeting,Sprint Planning, Retrospective, Review,anddailyScrum meeting.

Environment: WINDOWS 10, UNIX, JIRA, SELENIUM, JENKINS, Oracle, MSSQL, TOAD, XML, HTML, Java, JavaScript, Data Warehousing, IBM data studio, Microsoft team, SharePoint, DB2, SQL, UNIX.

Confidential, Charlotte, NC

Software Quality Assurance Engineer

Responsibilities:

• Added to test plans and test code wif minimum supervision.
• Conducted analysis of test results to find defects in the product or to find incomplete/inadequate test cases in test suites.
• Executed Data Driven Test using UFT/Quick Test Professional (QTP).
• Conducted Regression, Graphical User Interface (GUI) and Functionality Testing using QTP
• Read and interpreted technical documentation such as functional, design, network specifications.
• Generated Test data for various types of testing like valid data and invalid data.
• Worked wif Developers, Business and Release managers to discuss ways to fix the defects.
• Analyzed test results, determined causes of failures, and wrote detailed and executive summary test reports.
• Validated the data integrity and populated in the database using SQL and TOAD queries.
• Maintained and executed Test Cases, and Test Scripts using HP Quality Center/ALM.
• Reported & tracked the bugs, performed E-mail notifications to the developers using the Quality Center.
• Manually performed System, Security, UAT and Functional Testing.
• Proactively provided daily status reports to test lead or clients on a daily basis.
• Software automation experience wif JAVA on Selenium.
• Creating, Organizing, and managing Test Automation Resources.
• Creating, Enhancing, debugging and Running Test Cases.
• Organizing, monitoring defect management process.

Environment: Quality Center, HP QTP, SQL Server, Microsoft Office tools, SQL, Eclipse, Selenium IDE, Windows.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Analyzed BRD, functional specification and required documents for testing.
• Involved in analyzing Business and Technical requirements, developing Test Strategy document, Test Plan document, and Test cases.
• Participated in peer reviews and formal reviews, suggested new enhancements to developers.
• Maintained a requirements traceability matrix in order to keep the clients and all the teams up to date wif the current progress of the project using Quality Center.
• Maintained Test Scripts, Requirements & management of test suites using Quality Center.
• Tracked the defects logged the defected and developed and maintained Defect reports & Test Metrics using Quality Center.
• Used SQL queries for Back-end testing and Data integrity testing.
• Automated regression test suite and performed smoke test using QTP and SOAP UI.
• Assisted in training the UAT users at client location upon implementation of the developed system to familiarize them of its functions and operations in production environment.
• Worked on the project based on Agile Methodology.

Environment: Quality Center-8, Quick Test Pro (QTP), HTML, XML, VB Script, SQL, PL/SQL, TOAD, SQL Developer, Oracle (9i, 10g), SQL server 2008, and Unix, MS Office, Lotus Notes, Web Services.

Confidential, New York, NY 

QA Tester 

Responsibilities:

• Created Scenario to define the events that occurred during each testing session.
• Involved in Manual and Automated testing of web-based Application,
• Analyzed the System Requirement documents
• Used Test Director for reserving, executing Test Cases, defect tracking, and the complete test management.
• Managed Test Scenarios, Test Cases, Test Steps and Expected Results in Test Director.
• Prepared Excel Sheet for Requirements and export the requirements to Test Director.
• Built the test scenarios for various types of requests using Manual Testing efforts.
• Performed Smoke test on each build and identified the critical areas and wrote Test Scenarios.
• Involved in Smoke, Functional, Regression and Usability testing.
• Participated in formal review meetings wif users and developers to report and suggest resolution to issues discovered during testing.
• Prepared the Test Data for positive and negative testing for all the scenarios.
• Executed system tests and assisted in validating test results. Ran Test Cases in both Windows and UNIX environments.
• Wrote complex SQL queries to retrieve data for database testing.
• Involved in writing and ran SQL queries to produce daily & weakly reports using TOAD.
• Defects were reported using ClearQuest. Coordinated Meetings to prioritize defects and code migration to QA Environment.
• Performed various types of testing such as UI, Functional and Regression (Regression test is performed using HP QTP.
• Involved in running the Reports and send them to the responsible and concern persons to let them know the current issues in the production.

Environment: Test Director, QTP, SQL Server, Microsoft Office, SQL, XML, Clear Quest, JavaScript, XML, HTML, Web Logic.