We provide IT Staff Augmentation Services!

Sr. Data Quality Analyst Resume

NJ

PROFESSIONAL SUMMARY:

  • Over 7+ years of professional experience in QA Testing Projects.
  • Extensive experience in software test life cycle for various business domains like Healthcare, Banking, Retail and Insurance.
  • Multi - dimensional exposure to requirement analysis, testing, Implementation Support.
  • Strong capabilities in creating and executing test scenario and test procedures.
  • Experienced in preparing various Reports and documentation involved in testing.
  • Performed Module Coordination and effective defect management.
  • Knowledge of all stages in Software Development Life Cycle (SDLC) and Software Development Methodologies like Waterfall, Iterative, Spiral model, agile model.
  • Hands on experience in System Testing, Integration testing, Regression Testing, ETL Testing.
  • Experience in Exploratory testing, User Acceptance testing (UAT) and Beta Testing.
  • Exposure to Load and Performance Testing.
  • Excellent ETL analysis and debugging skills.
  • Good Working knowledge of Automation tools and Expertise in Selenium, QTP
  • Proficient in using SQL queries to perform back end testing for data integrity
  • Knowledge of QTP and Exposure to Load runner
  • Experienced in creating Requirement Traceability Matrix (RTM).
  • Prepared the status reports and stakeholder communications.
  • Solid experience of AGILE Methodologies, AGILE Manifesto and Scrum processes.
  • Web service testing using SoapUI with REST API Protocol
  • Proven track record in building and managing client & stakeholder relationships.
  • Highly skilled in efficient time and task management and prioritization.
  • Soft skill strengths include excellent communication, interpersonal skills with strong analytical and technical skills.

TECHNICAL SKILLS:

Test Management: Test Director 8.0, Mercury QC 8.2, HP Quality Center 9.2, 10, ALM 11, Clear Quest, JIRA, SharePoint, Selenium

Operating Systems: Windows 95/98/NT/XP/2000/VISTA, Mainframe

Browsers: Internet Explorer, Google Chrome & Fire Fox.

Databases / Tools: MS Access, Oracle, SQL Plus, SQL Developer, Toad, Data Stage 8, Informatica 9.1, DB2

Test Tools: Quick Test Pro 8.0 (Exposure), Silk Test 5.03 (Exposure), Load runner 8.0 (Exposure), XML, Nunit.

Methodology: Iterative, Waterfall, V-Model

Documentation Tools: MS Office Suite(MS Word, Excel, PowerPoint), MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Data Quality Analyst

Responsibilities:
  • Involved in complete Software Testing Life Cycle (STLC) understanding the business requirement document and creating complete test procedures, test cases and test data.
  • Worked on UNIX Platform to test an application.
  • Wrote complex SQL queries between source and target for validating ETL jobs.
  • Updated and wrote test cases and test scripts for ETL testing.
  • Written Test Cases for ETL to compare Source and Target database systems
  • Performed the Regression testing of the application after the defects were fixed.
  • Assigned the proper status to the defects during the entire bug reporting process.
  • Worked with JSON file created for each transaction during test period.
  • Tested all business scenario from UAT perspective, demo E2E flow to business Team to approve functionality.
  • Validated Test Results with cross functional Team and UAT sign off with conditional or full sign off.
  • High-level participation in System Integration Testing and UAT.
  • Worked in SELENIUM for automated transaction/data validation for each test vehicle run.
  • Followed Agile Methodologies and Software Quality Audits for all the Phases of SDLC.
  • Extensively involved in gathering start and end time for vehicle test run daily basis and analyzing the transaction details of vehicle test run in active and Standby Toll Zone Control (TZC).
  • Worked on SQL Server for backend data validation writing the SQL queries.
  • Involved in SOAP and Restful web services using SOAP UI.
  • Responsible for implementation of Hybrid Test Automation Framework build using Selenium.
  • Responsible for Report Validation in Tableau for all transaction created in Toll Zone Control (TZC).
  • Familiar with Tomcat and WebLogic application server.
  • Performed Regression, Ad-hoc Sanity and GUI testing.
  • Experienced for proper tracking of bug in JIRA.
  • Familiar with monitoring tools Nagios for checking Toll Point status by monitoring in the Host Control and Hyper map.

Environment: ALM 12.x, JIRA Oracle SQL Developer 3.0, Unix, Eclipse Mars 1, REST API, Nagios XI, Tableau Reports

Confidential, Pennsylvania

Sr. QA Analyst

Responsibilities:
  • Part of the QA team performing System testing, Regression testing and UAT activities.
  • Analysis of Business Requirements and Functional requirements and developing the test plans.
  • Development of test scripts and exporting it to Quality center and organizing the tests and executing it in Quality center.
  • Adherence to Project level metrics and tracking them for compliance
  • Utilized SQL Queries for data validation.
  • Working on Test Data Identification and documentation.
  • Peer Test case / Test results review.
  • Performing defect tracking and reporting using Quality center.
  • Developed the BRTM to determine the sync level between the deliverables.
  • Worked in all phases of Testing cycle, with focus on System testing, Regression testing and UAT.
  • Preparing Test status reports during Design and Execution Phase
  • Assisting in generating metrics to create Test Summary Reports.
  • Perform end of release Root Cause Analysis
  • Resolve various defects as assigned from daily defect / status report.
  • Perform Defect Triaging / Root cause analysis for Defect Meetings
  • Actively participated in walkthrough and review meetings.
  • Managed to complete all tasks to ensure on-time project delivery.
Environment: Quality Center 10, Oracle 11g, Informatica 9.1, SQL Developer, Mainframe

Confidential, Tampa, FL

Quality Analyst Consultant

Responsibilities:
  • Analyze functional requirements and design documents
  • Create Test Scenarios and Test Cases
  • Conduct Test Scenarios and Test Cases review meeting with business stakeholders.
  • Setup the test data for all test cases using SQL - Test Data Mining
  • Execute test cases and report defects
  • Responsible for Test cases and execution of Customer Information Module
  • Performed ETL Testing. 
  • Used mapping document and developed SQL queries to compare results and validate Informatica data.
  • Used quality center to create the Test plan, store Test cases and run the Test sets.
  • Involved in writing various Test Scenarios.
  • Tracked and verified Defect in Quality Center.
  • Performed execution of test cases manually to verify the expected results.  
  • Used SQL tool (SQL Developer) to run SQL queries and validate the data. 
  • Adherence to policies and procedures of the customer.
  • Involved in performing Data Inspection for the files loaded from Source to Landing.
  • Involved in Regression Testing, Data Mapping / Data Transformation Testing.  
  • Follow up with developers on defects status on a daily basis.

Environment: Quality Center 10, Oracle 11g, Informatica 9.1, SQL Developer, Mainframe

Confidential, NC

QA Analyst

Responsibilities:
  • Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
  • Interacted with Business Analysts, Developers and support team to define the testing requirement documents along with the QA Manager and mentored the QA Team accordingly.
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
  • Completely tested and verified that the source data is extracted correctly, transformed and loaded into the DB2 Data Warehouse.
  • Worked closely with the development teams to replicate end user issues.
  • Performed UAT testing across vendors to check for a defect free product/release.
  • Web services API Testingwith expertise in Open Source tools like Selenium WebDriver, Selenium
  • Involved in System, Performance and Integration testing of Data Stage jobs.
  • Identified and documented the defects in Quality Center 9.0
  • Test procedure and test case preparation, defect tracking and monitoring using HP Quality Center.
  • Created test cases and executed test scripts using Quality Center and Used to track and report system defects.
  • Validated the most granular data items against OLTP systems and identified the source tables from which the data warehouse extracts data.
  • Test planning, designing test cases, test execution, defect reporting and analysis.
  • Coordination of test cycles with client.
  • Preparation of test data and documentation.
  • SQL Queries and compares using Toad.
  • Exposure to ETL scenario preparation and testing

Environment: Data Stage 8.0, Crystal Report 10, SQL Server 2008, HP Quality Center 9.0, MS Excel, Toad for DB2

Confidential, Denver, CO

QA Tester

Responsibilities:
  • Analyzing Business Requirements, UI Specifications.
  • Creating Test data and Executing Test cases using Test Director 8.0
  • Performing defect tracking and reporting using the Clear Quest Tool.
  • Wrote the basic Performance Test script for Login and Single Sign On.
  • Participating in the entire development life cycle from the functionality requirements through deployment & maintenance.
  • Worked in all phases of testing cycle, mainly Black Box Testing, Domain Workflow Testing and System testing.
  • Worked in Test data creation and identification
  • Used SQL plus to run SQL queries and manipulated test data
  • Exposure to Automated Test tool Silk Test 5.03, QTP, Load runner
  • Resolved various issues as assigned from daily defect / status report.
  • Responsible for Morning Production System Sanity Check (Scheduled Morning Test).
  • Actively participated in walkthrough and review meetings.
  • Managed to complete all tasks to ensure on-time project delivery.

Environment: Web, Client-Server, Oracle 8i, CICS, J2EE, Web Logic, SQL, Security

Confidential, Scottsdale, AZ

QA Tester

Responsibilities:
  • Involved in preparation of Test plans, Created test cases and responsible for executing the Test Scripts.
  • Responsible for designing, developing test plans use cases and executing test scripts.
  • Performed functional, Regression, User Acceptance Testing and system testing.
  • Interacted with Business users and Technical team in providing clear solutions to requirements.
  • Used Test Director for preparing the manual test scripts.
  • Test execution-using Test Director.
  • Worked with developers using Test Director to fix the defects.
  • Performed Manual and automated testing and defect tracking and resolution of applications and solutions.
  • Bugs were reported to Developers using Test Director and after rectification from Developers regression testing was performed.
  • Performed Functional testing, User Acceptance testing (UAT), System testing.
  • Developed detailed test plans from use cases detailed specifications etc. develop test cases for Functional and User Acceptance testing.
  • Developed base line scripts for testing the future release of the application using Quick Test Pro.
  • Script enhancements and Data Driven Testing were implemented with Quick Test Pro.
  • Used PVCS Tracker for reporting the Bugs and performed regression testing after fixing the bugs.

Environment: Visual Basic. NET, ASP.NET, VB Script, Oracle, SQL, Windows 98/NT/2000/XP, Quick Test Pro, Test Director and PVCS Tracker.

Hire Now