SUMMARY

• Around 7 years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in ETL and BI testing for many data extractions and data migration projects.
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Experienced in DW projects ETL testing against DW testing with Informatica PowerCenter and data stage tools.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing
• Experience testing the Golden Record and data Sync generated using MDM software.
• Experience in BI, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Experience with ETL test automation tool Informatica DVO.
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client - server and web-based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
• Experienced and Proficient in SQL queries.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

Testing Tools: Quality Center, QTP, Rational Suite, SOAP UI, Postman

Data Bases: Oracle, SQL Server, IBM DB2, Teradata, Sybase

Database Tools: TOAD, PL/SQL Developer, SQL* Plus

ETL Tools: Informatica PowerCenter 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Datastage 7.x

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: OBIEE, Tableau

Operating Systems: UNIX, Windows Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Languages: Java, C, C++, SQL, PL/SQL, HTML, DHTML, XML, XSLT

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL/MDM Test Lead

Responsibilities:

• Responsible for Gathering test requirements and scoping out the test plan.
• 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.
• Performed validation using Survivorship process in which every attribute (name, address, phone number 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
• 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: SQL Server, HiveSQL (HQL), DB2, Civica MDM, 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, Charlotte, NC

Technical Test Lead

Responsibilities:

• Responsible for Gathering test requirements and scoping out the test plan.
• Designed and tested UNIX shell scripts as part of the ETL testing process to automate the process of loading, pulling the data for testing ETL loads.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested both conditional formatting and threshold level testing for several reports developed in OBIEE.
• Reported bugs and tracked defects using ALM/Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules.
• Used Informatica DVO for the automation of ETL test scripts.
• Written SQL complex queries to verify data is flowing from source to target and from the target reports have been generated using OBIEE.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Strong ability in 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
• Tested various ETL processes developed using ETL tools like Informatica Power center, SSIS, Ab Initio and Data stage
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Experienced in data analysis using SQL, PL/SQL and many other queries-based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Validated the reports to make sure all the data is populated as per requirements.
• Responsible for leading and coordinating with offshore team.

Environment: Informatica, OBIEE, SQL, PL/SQL, Agile, Visio, ALM/HP Quality Center 11, Oracle, UNIX, TOAD, T-SQL, SQL Server, XML Files, XSD, XML Spy, Flat Files

Confidential, Morrisville, NC

Sr.ETL/QA BI Tester

Responsibilities:

• Attended walkthrough meetings with the Business Analysts and Dev. team to get a clear understanding of the business and the applications being used in house.
• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Used Informatica PowerCenter 9.5 to extract, transform and load data from multiple Sources.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Worked with various transformations like Aggregator, Ranker, Lookup transformation, Filter transformation, Update transformation, stored procedure transformations etc.
• Tested complex Informatica mappings, transformations, workflows and sessions using Workflow Manager and Workflow Monitor in Informatica Power Center.
• Wrote Test Cases for ETL to compare Source and Target database systems.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Reported bugs and tracked defects using HP ALM/Quality Center.
• Logged defects using HP ALM/Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• UNIX and Oracle are used in this project to write Shell Scripts and SQL queries.
• System was implemented using Informatica and the Data Warehouse in Teradata. Fast-Load, Multi-Load, BTEQ & Fast-Export were the Teradata utilities used.
• Performed Report Testing using Crystal Reports by writing SQL queries to validate the data on the report and compare with the DWH data.
• Extensive experience in Functional, System Integration, Regression, User Acceptance, Black Box Testing, Performance, Stress, Conformance, Interoperability and Configuration testing. Involved in testing the B2B (XML) based applications using QTP and SOAP UI.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica.
• Strong testing experience of various ETL process developed using Informatica PowerCenter.
• Responsible for validation of Target data in Data Warehouse.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine tuned the queries for better performance.
• Retesting and Regression testing the resolved defects/issues after the developers fix the defects.
• Involved in preparing Test Data/ Test script for UAT and participated in UAT signoff.
• Updated the status of the testing to the QA manager and accomplished tasked for the assigned work to the Project Management team regularly.
• Involved in testing the Cognos reports by writing complex SQL queries.

Environment: Informatica 9.5, Oracle 11g, SSIS, SQL, PL/SQL, Teradata V2R5, Teradata SQL Assistant, SQL Developer, TOAD 8.0, UNIX, HP ALM/Quality Center 10.0, Cognos, Crystal Reports

Confidential, Louisville, KY

ETL/QA BI Tester

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects
• Worked closely with (TDM) Test Data Management team for data scrubbing. Used to send work order requests to Test Data Management team when sensitive data exists in source tables.
• Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Used Informatica Power Center and its all features extensively in migrating data from OLTP to Enterprise Data warehouse
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Written complex SQL queries for validating the data stored in different database tables.
• Helped the team in analyzing the data to be able to identify the data quality issues
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Applied rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
• Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing. Also manually tested the application for each system build, for both negative and positive testing.
• Communication with the client for weekly status report
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Worked with Data replication, Data retention and ILM process and Partition Extender jobs.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Informatica power center 9.1, SQL, PL/SQL, Business Objects, Unix Shell Scripting, Oracle11g, ILM, TDM, ALM/HP Quality Center 11, Autosys, Microsoft Visio