SUMMARY

• Over 7 years of extensive experience in Quality Assurance testing of data warehousing, Web Based and Client/Server applications.
• Possess excellent knowledge & experience in providing data warehousing solutions and data warehouse concepts.
• Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Performed test planning, test execution, test data, test coordination, configuration management and defect management areas for the web based, middleware and mainframe applications
• Excellent experience in Quality Assurance and testing, worked as ETL Tester, Data Tester and QA Analyst.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall.
• Experience in job scheduling tool.
• Good in UNIX commands and understanding of shell scripting.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, OLTP, SQL Server, Oracle and ETL.
• Extensive experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB2 9.1/8.0, Teradata V2R6/V2R5, MS SQL Server, Excel and MYSQL, SQL Developer, TOAD, Quest Central for DB2.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Worked with Functional /Testing tools as QTP, Quality Centre, Test Director, Rational ClearQuest
• Experience in Mercury Quality Centre, HP - ALM - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter

BI & Reporting: Business Objects XIR3/R2, Cognos.

Testing Tools: Quality Center, HP-ALM, Jira

Databases: Oracle, MS SQL Server, IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: Autosys

Operating System: UNIX, WINDOWS, Linux, MS-DOS

Testing Methodologies: Water fall, Iteration, STLC, Agile

Languages/Tools: SQL, PL/SQL, SQL Developer, TOAD, UNIX shell scripts, PERL, XML.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

ETL Tester

Responsibilities:

• Participating in requirement walkthroughs and creation of test plan.
• Writing Test Cases from the Test Plan and manually tested the application.
• Participating with users in understanding the business requirements.
• Executing test cases in Quality Centre.
• SQL queries were written to perform operations like joins in the source database.
• Retrieving records from multiple tables from Oracle Database through SQL by using joins.
• Executing SQL queries to perform testing using SQL to test Oracle Database to validate and test data using TOAD.
• Tracking and analysing defects in the application using JIRA a defect tracking tool throughout the bug life cycle.
• Working on Informatica Power Centre to check the log files.
• Manually conducting Positive Testing / Negative Testing.
• Performing Regression Testing after bug fixes or system enhancement.
• Performing Integration testing and Configuration testing.
• Performing User Acceptance Testing (UAT).
• Involving in job scheduling using Autosys.
• Extensively working in the Unix Environment using Shell Scripts.
• Documenting defects in Quality Centre.
• Using JIRA as well for story writing and defect tracking.
• Attending the Weekly meeting.

Environment: Informatica 10.2, UNIX, ALM/Quality Center, JIRA, Autosys, Toad 12.10, PuTTY, Oracle Client 12.1.0

Confidential, Providence, RI

ETL Tester

Responsibilities:

• Analysed business requirements, data mapping specifications and developed Test Plans, RTM, Test Cases.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Conducted detailed reviews on every deliverable like Test Cases, Defect reports and Test summary reports.
• Coordinated with QA Lead/Managers and resolve issues that occur during all phases of testing.
• Attend daily status calls with customers and provide status on testing progress.
• Provided Test status & Defect status reports.
• 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 ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica Power Centre Work Flow monitor.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
• Involved in recording change requests on the Change Requests.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Used TOAD & SQL Navigator for Querying Database.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validated the data passed to downstream systems.
• Strong Informatica and data loading experience.
• Involved in various testing phases like Integration Testing, System Testing.

Environment: Informatica 9.1, DB2, Cognos, SQL, PL/SQL, Teradata 13, Teradata SQL Assistant, XML, UNIX, Shell Scripting, WINSQL, ALM/Quality Center 11

Confidential, Wilmington, DE

ETL/QA Tester

Responsibilities:

• Involved in development of test plans, analysed the business requirements and data mapping documents and developed test cases.
• PL/SQL queries were written to perform operations like joins in the source database.
• Vigorously worked on Manual Testing. Written Test plans, Test Cases and Test Scripts.
• Analyzed and reviewed project documentation, business rets to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written several complex SQL queries.
• Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• 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.
• Creating and executing SQL queries to perform Data Integrity testing on Oracle Database to validate and test data using TOAD.
• Involved in job scheduling using MS SQL server Agent.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Involved in extensive DATA validation using SQL queries and back-end testing
• Executed workflows created in Informatica by the developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Used TOAD Software for Querying ORACLE.
• Performed quality assurance reviews on all System Development Life Cycle.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Involved in defect life cycle.

Environment: Quality Centre, Informatica Power Center 8.6, SQL, Agile, Business Objects, Teradata, Visio, JIRA, Oracle, UNIX, TOAD, T-SQL, SQL Server, XML Files, Flat Files.Load Runner

Confidential, New York, NY

ETL Tester

Responsibilities:

• Enhancement and implementation of Guidewire Claim Center Integration and System Test Specifications.
• Responsible for different Data mapping activities from Source systems to Reporting.
• Involved in all walk through for test designs, data designs and code reviews.
• Developed Test cases & Test Scenarios for new features and involved in Test estimation.
• Excellent knowledge on Agile and waterfall Methodology.
• Extensively involved in understanding the BRD and mapping document.
• Helped with filling the requirement traceability matrix for enhancement of a system to support testing.
• Developed complex SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Performed Regression, smoke, sanity and data quality testing writing complex SQL queries.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Responsible for validating the files availability, format and data on UNIX server
• Executed SQL queries to verify the flow of data between back end and front end.
• Written complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
• Strong hands-on experience in maintaining and using IBM Rational Clear Quest for Defect reporting, tracking & Change Management.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Reviewed High Level and Low-Level Design docs and clarified design solutions with Developers.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Performed data validation testing of production defect using SQL and resolving and testing back end process.
• Participated actively in system, performance, regression and UAT testing for every new build released.
• Demonstrated an organized, systematic, disciplined and analytical approach to problem solving.
• Hands-on experienced with defect tracking tools like HP ALM.
• Extensively involved in UAT by supporting Testing and implement QA Process for data load and reporting using Cognos Series 8 V-10.2.2.
• Presented Daily Analysis Report to highlight bugs, issues and risks involved.

Environment: SQL Server 2008/2012, Informatica 9.5, Cognos Series 8 V-10.2.2, Report2Web, HP ALM, OnBase application, Guidewire, Autosys.

Confidential

QA Tester

Responsibilities:

• Developed Test Cases for Functional as well as non-Functional, and Regression
• Testing based on the Design Document, User Requirements and Use Case Diagrams
• Planned Test cases and performed Functionality of GUI, Security, Configuration, Back-end and Acceptance Testing Manually
• Worked with other members of the QA and Development teams and offshore team (Pune, India) in improving the processes, methods, effectiveness and efficiency
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Manually performed Smoke Testing of the new builds for Basic Functionality Checking
• Build a lean Regression Test Suite for Manual and Automated Testing
• Created UAT test cases and scenarios based on Use Cases and made sure those UAT test cases meets the business requirements.
• Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
• Implemented Database Checkpoints for Back-end Testing
• Expertise in SQL queries for inserting data by join different database and cross verification of data
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Test Director was used for bug reporting and tracking

Environment: ETL (Informatica 6.2), Oracle 9i, SQL, PL/SQL, UNIX, Test Director, TOAD, SQL Navigator, Windows XP Professional, Putty, SSH Pro, Smart FTP, MS Excel 2003, MS Word 2003, Remedy, PVCS Version Manager, Text Pad 5.0