Resume

Sign in

Data Quality Engineer

Location:
North Providence, RI
Posted:
May 24, 2020

Contact this candidate

Resume:

Pradeep Daid

Cell: 480-***-****, Email: adden8@r.postjobfree.com

Data Quality Analyst and Test Lead (Manual and Automation)

PROFESSIONAL SUMMARY:

Over 12 years of experience in the Information Technology Industry as Quality Analyst and QA Lead, which includes Requirement Analysis, Test Planning, Test Cases Design, Test Data Setup, Defect Management, Test results, Process Improvements and Team Management.

A result oriented professional with an analytical mind capable of delivering timely and desired results even in most challenging situations.

An efficient communicator with good leadership, organizational, team building, motivational and project management skills.

Involved in complex projects involving different phases of SDLC like requirements gathering, design, testing and maintenance.

Experience & expertise in Requirement Analysis, preparing Test Estimation, Test Strategy, Test plans, Test Execution & Results Reporting and Test Management process through HP Application Lifecycle Management and Microsoft Dev Azure tools. Also involved in knowledge transition and mentoring the team.

Good understanding of Software Testing Life cycle (STLC), Defect Life Cycle, Testing methodologies and Software Development Life Cycle. Worked on multiple projects simultaneously by prioritizing the tasks effectively.

Experience & expertise in Database / ETL testing using Data Warehouse concepts i.e. testing of Tables / Categories, Feed Files, Datamarts and Business Reports.

Experience in creating and maintaining workflows using Alteryx tool and Business Intelligence Reports testing using Tableau.

Expertise in developing and performing the Daily Production monitoring through Alteryx and iCEDQ tool and trigger the execution through ActiveBatch and Unix shell.

Suggested improvement processes to the team to implement in the projects so that project runs smoothly and quality of project is also high at all times.

Experienced in Front-end and Back-end Testing, Test Driven Development (TDD) approach.

Experienced in using HP ALM (or QC), IBM RTC, Microsoft TFS / Dev Azure and Jira for Test Planning & Execution, Requirement Management, Defect tracking and Reporting. Extensively involved in UAT testing.

Conducted Smoke testing, Functional testing and Regression testing through automated testing tools like Selenium, HP UFT (or QTP).

Expertise in preparing Requirement Traceability Matrix (RTM), Test Plan, Test Cases and Test Scripts with good experience in automation testing.

Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL (medium to complex) queries.

Involved in performing Integration/ API Testing using SoapUI and JMeter tool.

Experienced in documenting the testing process using MS-Office tools like Word, Excel and Visio.

Involved in different methodologies like Agile Scrum and Waterfall models.

Able to work independently, self-motivated, good team player and quick learner at new technologies.

Extensive experience on working multiple projects simultaneously.

Excellent problem solving ability, Analytical and Programming skills, Quality conscious and multitasked environment.

Leading the team towards a common goal of successfully implementing the project with highest quality into production with zero defects.

Experienced in Post-Implementation activities and documentation for the completed projects which were installed in Production under a particular release. Also involved in documenting and preparing the job-aid documents with step-by-step description for easy understanding of end users.

PROFESSIONAL EXPERIENCE:

Employer – Dotcom Team, LLC (June 2017 to till date)

Client: CVS Health (Lincoln, RI) April 2020 – Till Date

Quality Analyst

Responsibilities:

Involved in meeting with cross-teams’ / dev team and business teams to understand the business asks.

Attending the Pre-Planning and Planning meetings with team and understanding the Business Requirements and clarifying the requirements with Business Analyst.

Coordination across all testing phases, i.e. requirement analysis, test planning, test execution, defect management and test documentation.

Preparing test plan as per business requirements in Jira tool.

Executing Test Cases in Jira and documenting the test results & test artifacts.

Involved to validate API calls and API data through SoapUI tool.

Uploading testing results and tracking defects in Jira.

Providing daily status to project team and keeping them updated with the day-to-day work and issues.

Attending Backlog Grooming, Sprint Planning, Daily Scrum, Demo and Retro meetings.

Maintaining the stories and tracking progress & efforts of stories in Jira and work on multiple PBIs simultaneously.

Tools: SQL Developer, Oracle 11g, MySQL Workbench 8.0, SoapUI, WinSCP, MS Office and Jira.

Client: Grand Circle LLC (Boston, MA) June 2017 – April 2020

DQA Lead cum Data Quality Analyst

Responsibilities:

Lead QA team to achieve the common goal of successful implementation of project in-align with Business Requirements.

Drive / Lead day-to-day activities by setting priorities, assigning, reviewing work and mentoring the team and ensure their questions and doubts are clarified.

Executed source-to-target testing for customer survey data and enabled follow-up email deliveries for 5000 travelers each month.

Built new and enhanced existing Tableau data quality dashboards to report and present KPIs to executive leadership.

Involved in meeting with cross-teams’ / dev team and business teams to understand the business asks.

Attending the Pre-Planning and Planning meetings with team and understanding the Business Requirements and clarifying the requirements with Business Analyst.

Coordination across all testing phases, i.e. requirement analysis, test planning, test execution, defect management and test documentation.

Preparing test plan as per business requirements in Microsoft Team Foundation Server(TFS) / Dev Azure.

Writing complex SQL queries to validate that categories, ETL mappings are created as per the requirements and Data is transformed & stored as expected.

Comparison of data between Source and Target, where source can be csv file, XML file or External system such as IBM DB2 or Adobe or Qualtrics system and Target is Data Warehouse & Email systems.

Also, involved to test the data flow between different systems (such as Stage, ODS, DS & DM) and ensure that transformation logics are applied as per Business Requirements when data flows from one system to another. In addition, ensure that data is reached to Email System (Adobe) for different campaigns.

Validation of data which is being sent to external vendors and ensure that Fulfillment requests are sent based on business rules.

Validation of Call Center data and ensure that tasks are created as per the Business Requirements.

Ensure that data flows to Business Intelligence (BI) system and populating on BI Reports.

Executing Test Cases in Dev Azure and documenting the test results & test artifacts.

Uploading testing results and tracking defects in Microsoft Dev Azure.

Instituted Production Monitoring system through Alteryx and iCEDQ tools to monitor critical business rules, analyze the failures and report the legitimate failures & issues to the concerned teams.

Scheduling jobs through ActiveBatch to trigger automatic execution of iCEDQ rules with the help of Operations team and re-trigger the rules from ActiveBatch in the event of failures. Also, involved to schedule the jobs through Unix shell.

Audit the iCEDQ rules status in Tableau Dashboard, get the list of failures and analyze them.

Validating the Email Marketing campaigns as per Business Rules to ensure that only qualified travelers are selected for different Email Campaigns through Adobe.

Involved to validate API calls and API data through SoapUI tool.

Creating Rules in iCEDQ tool to automate the testing and develop/maintain Daily Production Rules Monitoring.

Validation of Web Contents and Email Data to ensure that correct content are getting embedded in the end user emails.

Validation of Surveys in Qualtrics system and comparing Survey data between Qualtrics and Data Warehouse.

Providing daily status to project team and keeping them updated with the day-to-day work and issues.

Attending Backlog Grooming, Sprint Planning, Daily Scrum, Demo and Retro meetings.

Maintaining the stories and tracking progress & efforts of stories in Microsoft Dev Azure and work on multiple PBIs simultaneously.

Automating the Business Critical workflows through Alteryx, iCEDQ and ActiveBatch tools.

Tools: Toad 13.0, Oracle 11g, MS SQL Server, IBM DB2, Activebatch, Unix, iCEDQ, Alteryx, Qualtrics, Adobe, SoapUI, MS Office, MS Dev Azure, Business Intelligence (BI) Reporting and Tableau.

Employer – Syntel Inc. (July 2014 to May 2017)

Client: State Street Bank and Trust Company (Boston, MA) May 2015 – May 2017

Test Lead

Responsibilities:

Understanding the Business Requirements and clarifying the requirements with Business Analyst or Product Owner.

Preparing the Test Strategy document and get it reviewed by project team and incorporating the Review comments.

Having good knowledge and understanding of AML scenarios i.e. transaction trends, patterns to detect the suspicious transactions.

Worked on the testing of KYC Reports and ensured that KYC Reports are generated as per the requirements.

Preparing test plan as per business requirements and uploading them into HP ALM (or QC).

Writing the Complex SQL queries to test that Data Marts are created as per the requirements.

Involved in testing of Feed Files & Categories including Primary Key, Foreign Key, views etc. as per Data Warehouse concepts and ensure that they are created (including elements mapping) as per the requirements.

Involved in the testing of Business Reports and ensure that reports are generating as per the requirements.

Preparing the traceability of Requirements -> Test Cases -> Defects in HP ALM (QC).

Assigning the work to offshore team; walkthrough of the requirements with offshore team, clarify their questions & issues and keeping the track of project.

Attending Pre-planning meeting, Planning meeting, Daily Standup, Demo and Retro meetings.

Maintaining the stories and tracking progress of stories in IBM RTC tool.

Automating the test cases through ETL tool (or excel macro) to validate that results generated by SQA prepared queries and datamart are matching.

Creating the scripts in HP UFT (or QTP) to automate the regression testing and executing the scripts for regression testing.

Responsible to provide ESP access to users (across the globe) in development & test systems of State Street. Also, responsible to resolve the user’s access related issues in both systems.

Creating new applications, client shells and user manager roles in development & test systems as per approved requests from approvers.

Updating existing applications, client shells and user manager roles in development & test systems as per approved requests from approvers.

Maintaining the approvers list and other details of different client shells.

Involved in documenting and preparing job-aid documents with step-by-step description for easy understanding of other / end users.

Tools: ETL Tool, Internal system (ESP), Squirrel, Oracle 11g, MS Office, IBM RTC, HP UFT (or QTP) and HP ALM (or QC).

Client: FedEx Corporation (Memphis, TN) July 2014 – April 2015

Test Lead

Responsibilities:

Go through the BRS (Business Requirement Specification) & SRS (System Requirement Specification) documents and conducting BRS & SRS review meetings with different stake holders and providing test estimates.

Coordination across all testing phases, participation in BRS, SRS review, Test WPR and Sign-Off.

Preparing the Test Strategy, Test Plan & Test Cases to test the project and get it reviewed by project team and incorporating the Review comments. Manage the team and coordinate as bridge between client & team.

Performing Smoke Testing as soon as the build is delivered for testing before starting the actual testing.

Assigning the work to offshore team and reviewing the work done by the team along with defects in HP ALM.

Generating the weekly status report and sharing it with all stakeholders.

Conducting execution review meeting and providing testing sign-off at the end of testing cycle.

Supporting the end users and resolving their queries related to new functionality / system once project is implemented in Production. Also, documented and prepared the job-aid documents with step-by-step description for easy understanding of end users.

Tools: Desktop based application, Mainframes, SQL Server, MS Office and HP ALM (or QC).

Employer – Infosys Limited (October 2007 to July 2014)

Client: Aetna Inc. (Phoenix, AZ) February 2014 – July 2014

Test Engineer

Responsibilities:

Preparation of Test Strategy, Test Plan & Test Cases to test the project and get it reviewed by Business Analyst and incorporating the Review comments.

Assigning the work to offshore team; walkthrough of the requirements with offshore team and clarify their questions & issues. Managing the team and coordinating as bridge between client & team.

Involved in test data creation as flat files based on the business requirements.

Executing the test cases and uploading the results along with Defect reporting and tracking in HP Quality Center.

Also involved in creating the test data and providing the test data to Business and Development teams to perform their UAT & Unit testing.

Attending defect triage meeting and updating the defects in HP Quality Center (ALM) as per discussion.

Tools: QNXT, UltraEdit, SQL Server, MS Office and HP Quality Center (or ALM).

Client: Northwestern Mutual Life Insurance Company (Milwaukee, WI)

April 2013 – January 2014

Test Engineer

Responsibilities:

Attending the Requirement Gathering sessions with project stake-holders and providing them test estimates.

Preparing the Test Strategy, Test Plan & Test Cases to test the project and get it reviewed by Requirement Lead and incorporating the Review comments.

Attending the daily stand-up meetings with project stake-holders and providing status to project team on daily basis.

Assigning the work to offshore team; walkthrough of the requirements with offshore team and clarify their questions & issues. Along with, managing the team and coordinating as bridge between client & team.

Executing the test cases and uploading the results in SharePoint. Also, Defect reporting and tracking in HP Quality Center (ALM).

Providing weekly status to client and keeping them updated with the work in progress and issues.

Storing all the Testing Artifacts / Test Results at project SharePoint location.

Tools: Internal system, MS Office, HP QTP and HP Quality Center (or ALM).

Client: Allstate Life Insurance Company (Mysore, India) December 2007 – March 2013

Test Engineer

Responsibilities:

Understanding the Business Requirements to come up with the strategy to test the functionality / change in the system and preparing and providing the test estimates of the project to Onsite Coordinator.

Preparing the Test Strategy, Test Plan & Test Cases to test the project and get it reviewed by Business and incorporating the Review comments.

Executing the test cases and uploading the results in HP Quality Center (ALM) along with defect reporting. Also, providing the daily status to Onsite coordinator and keeping them updated with the day-to-day work and issues.

Attending the Daily / Weekly meetings with the client / project stake-holders (telephonic) and provide them updates on necessary basis. And raising the issues in the meetings which are blocking the execution / progress in the project.

Keeping the up to-date mapping of “Requirements – Test Cases – Defects” in Quality Center (ALM).

Performing Integration/ API Testing using SoapUI and JMeter tools.

Subject Matter Expertise (SME) on Mainframe based Correspondence system of Allstate.

Involved in mentoring new members in the team and getting them on track with latest progress in the project.

Collaborating with the team across Northbrook (IL), Northern Ireland and Mysore and supporting them on a daily basis.

Executing the Regression scripts (QTP / UFT) every week to ensure that new code is not affecting other areas of the application.

Tools: Mainframes (CICS & ISPF), SoapUI, JMeter, Beyond Compare, VBScript, Ultra Edit, MS Office, HP QTP (Quick Test Professional) and HP Quality Center (or ALM).

EDUCATION

Master of Computer Applications (MCA) from Indira Gandhi National Open University (IGNOU), New Delhi, India in year 2011.

Bachelor of Computer Applications (BCA) from Punjab Technical University, Jalandhar, Punjab, India in year 2007.

CERTIFICATIONS

ISTQB



Contact this candidate