SUMMARY

• Over 7+ years of professional IT experience in Quality Assurance, testing stand - alone, Client Server and Web based applications using Manual Testing, HP ALM Explorer 11.5x/HP Quality Center on UNIX and Windows.
• 4+ years in Master Data Management ( MDM) that includes experience in Virtual MDM, Physical MDM and Hybrid MDM.
• Have good experience in HIVE (Data warehousing Infrastructure for Hadoop ) and have used HiveSQL (HQL) for checking the load extracts.
• Consistently recognized for excellent problem-solving and analytical skills by programmers, project managers and supervisors. Have won many number of BRAVO Diamond Recognition Awards from the clients . (For Successful Releases Validation, Leadership, Collaboration, Relationship)
• Well versed with various types Software Development methodologies - Agile SCRUM, Waterfall.
• Extensive experience in Functional, Integration, Regression, User Acceptance, System, Performance, Load & Stress Testing, Manual and Black Box Testing.
• Experience in preparing Test Design, Test Cases, Test Plan and Defect Report.
• Proficient in managing in all Quality assurance testing cycle from test planning to defect tracking and managing Defect life cycle. Analyzing bugs and interacting with development team members in fixing the defects
• Extensive experience with DbVisualizer Pro 10.0.2, Oracle 11g, SQL Server 11.0 and Teradata SQL Assistant 12.
• Extensive ETL testing experience using Infor matica (Power Center/ Power Mart, Workflow Manager, Workflow Monitor).
• Experience in testing and writing SQL statements.
• Extensive experience working in UNIX.
• Self-starter, Self-motivated, Willing to assume responsibilities, Strong team player with great leadership qualities with excellent communication and analytical skills.

TECHNICAL SKILLS

Platforms: UNIX, Windows (NT, 2000, XP, 2003, Vista), MS-DOS

Skill Se t: HiveSQL (HQL), SQL, XML, HTML

Database: MongoDB, DB2, Oracle11g, SQL Server 11.0, HBase

Defect-tracking software: HP ALM 12.2x, Rally Defect Log, GitHub Issues Log

Tools: and Utilities: IBM InfoSphere MDM Inspector 11, I BM Data Stewardship, Autopilot v6.5.5, DbVisualizer Pro 10.0.2, Teradata SQL Assistant 12, Aqua Data Studio 10.0, SoapUI 5.4.0, RESTClient 3.0, GitHub Enterprise 2.14, Jenkins.

ETL Tools: Talend ( Real-time BIG DATA Platform) 6.3.1, Informatica 9.1, DVO 9.5.0

Methodologies: Agile- Scrum, W aterfall

Office tools: MS O ffice, MS W ord, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

ETL |MDM QA Tester

Responsibilities:

• Performed database testing to ensure the Extraction Transformation Loading (ETL) process for the data being extracted from Inbound to Landing, Stage and Base Object.
• Responsible for validating the ETL extracts against the mapping document and validation of business logic rules based on the requirement and then finally the cleansed extract data is loaded into MDM.
• Using Master Data Management (MDM), we find data from multiple sources and match them to the single person based on demographics and other identifiers to create a golden record (GR).
• Performed API Validation using POSTman and RESTClient.
• Performed validation using Survivorship process in which every attribute (name, address, Location, Org etc.,) and every type code of contact data (primary residence, mailing address, home phone, etc.,) gets survived onto the Golden Record utilizing specific rules for that attribute.
• Performed validation of Match and Merge.
• Worked in Agile Scrum project implementation performing test coordination, task management using CA Agile Central (Rally).
• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting.
• Backend testing through SQL queries to support the test case results.
• As part of Agile methodology, took part in SCRUM Backlog grooming, Sprint Planning & Estimation session, Retrospective and in Daily SCRUM meetings to keep track of the progress and impediments in testing deliverables.
• Checking log files in UNIX for back end exceptions and forwarding the same to developers.
• JUnit and REST Client exposure for testing API requests and responses in JSON and XML format

Environment: Oracle 11g, MongoDB, informatica MDM, Clear Case, Cognos 8.0 Series, Teradata SQL Assistant, Clear Quest, SQL, PL/SQL, TOAD, UNIX, TFS, Putty, SharePoint, Flat files, XML files, DB2, HP Quality Center/ALM, Autosys, SQL Server 2008.

Confidential

Sr. Software QA Analyst/ETL-MDM Tester

Responsibilities:

• QA Deployment Lead responsible for deployment plan night of release and execution of plan
• Performed database testing to ensure the Extraction Transformation Loading (ETL) process for the data being extracted from Data Lake (semi structured flat files), transformed and loaded into the target database.
• Responsible for validating the ETL extracts against the mapping document and validation of business logic rules based on the requirement and then finally the cleansed extract data is loaded into MDM.
• Using Master Data Management (MDM), we find data from multiple sources and match them to the single person based on demographics and other identifiers to create a golden record (GR).
• Performed API Validation using SoapUI and RESTClient.
• Interacted with External Team to perform Test Data Request (TDR) and publish GR XML in Data Lake.
• Performed validation using Survivorship process in which every attribute (name, address, keychain IDs etc.,) and every type code of contact data (primary residence, mailing address, home phone, etc., ) gets survived onto the Golden Record utilizing specific rules for that attribute.
• Performed validation of Survivorship Rules based on Tier, Last Updated and Keep All Unique.
• Involved in the Split/Merge process performed on the member records to publish GR records.
• Worked on HIVE (Data warehousing Infrastructure for Hadoop) and have used HiveSQL (HQL) queries for validating the load extracts.
• Acted as the Subject Expert in the functionality assigned for the project by thoroughly understanding the Business Requirement Document (BRD) and Functional Requirement document (FRD).
• Worked in Agile Scrum project implementation performing test coordination, task management using CA Agile Central (Rally).
• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting.
• Used HP ALM Explorer for developing Test Plan, Test Cases, Test Scripts, Test Case execution & Defect Tracking.
• Prepared and loaded the Test Data by executing Data Load Scripts for the Incremental / historical Load testing and validation.
• Backend testing through SQL queries to support the test case results.
• As part of Agile methodology, took part in SCRUM Backlog grooming, Sprint Planning & Estimation session, Retrospective and in Daily SCRUM meetings to keep track of the progress and impediments in testing deliverables.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• Validating the web server logs using UNIX commands and ran batch job for TDR request.
• Aided with system expertise for transitioning from legacy Talend ETL processing to modern Kafka Stream API processing
• Tasked with automating test scenarios for thousands of healthcare and application rules
• Tested Data with TDD mindset for several new Kafka APIs /Monitored activity and logs with Grafana and Kibana
• API automated testing with Maven Projects (Cucumber & Java) and Jenkins pipeline solutions
• JUnit and REST Client exposure for testing API requests and responses in JSON and XML format

Environment: Teradata SQL Assistant 12, HiveSQL (HQL), Talend (Real-time BIG DATA Platform) 6.3.1, Autopilot v6.5.5, DB2, DbVisualizer Pro 10.0.2, IBM InfoSphere MDM Inspector 11, IBM Data Stewardship, Agile Scrum Methodology, HP ALM 12.2x, Unix, SoapUI 5.4.0, RESTClient 3.0, GitHub Enterprise 2.14, Microsoft Office 2010.

Confidential, Boston MA

Sr. ETL QA Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Tested Cognos reports to check whether they are generated as per the company standards
• Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation
• Different Data Stage components especially are used effectively to develop and maintain the database
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Analyzed the requirements for the project from DOORS requirements/version control tool.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2008 with high volume data
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation
• Extraction, Transaction and Loading was done using different Components and different expressions using Data Stage to create test data.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Exclusively used test plan module to write and test lab module to execute the test cases in HP Quality Center/ALM.
• Exclusively used requirement module for requirement and defect module for entering the defects in HP Quality Center/ALM.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Extensively used Data Stage for extraction, transformation and loading process.

Environment: Oracle 11g, IBM Data Stage 8.0, Clear Case, Cognos 8.0 Series, Teradata SQL Assistant, Clear Quest, SQL, PL/SQL, TOAD, UNIX, TFS, Putty, SharePoint, Flat files, XML files, DB2, HP Quality Center/ALM, Autosys, SQL Server 2008.