SUMMARY

• Having +8 years of Information Technology experience; all of her experience is relevant in ETL/ Data Warehouse Testing and is being presented for ETL QA Analyst.
• Experience in software QA Testing and Data Warehouse using ETL tools Informatica, SSIS, Data stage and Reporting tools SSRS, OBIEE and Business Objects.
• Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target Data Warehouse.
• Strong experience in Cognos reports, cubes, extracts and Data Warehouse tables testing.
• Sound knowledge and experience in Data Warehousing and Business Intelligence Testing using different tools like SQL, SSIS, SSRS, DataStage, Cognos etc.
• Expertise in writing and executing test cases based on given software requirement specification and developed detailed Test Plan.
• Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
• Experience in Problem solving and Bug reports using Defect Tracking Tool Mercury Quality Center.
• Highly motivated, organized, able to work independently and able to switch between projects quickly.

TECHNICAL SUMMARY:

Testing: Manual Testing, DWH - Testing, Report testing and ETL Testing

Manual Testing: Functional Testing, System Testing, Regression testing

Defect Tracking Tool: MQC, Test director, JIRA

Data Warehousing: SQL Server 2008, Teradata7.2, SSIS, Cognos 10, DataStage

Operating Systems: Windows NT, 9x, 2000, XP, 2003 Server, Linux, SUN Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior ETL Tester

Responsibilities:

• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• 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.
• Load source file data into data warehouse using SSIS package.
• 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.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Executed the Test cases for Cognos.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
• Created and executed SQL queries to perform source to target testing on Oracle database.
• Coordinated with different users in UAT process.
• Performed Unit testing for all reports and packages.

Environment: Oracle9i, Mercury QC 9.0/11, SQL SERVER 2008, Cognos 7.0 Series, Windows XP/2000 and UNIX.

Confidential, Wilmington, DE

ETL/SQL Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Extensively used Cognos to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata. Reviewed Cognos mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Extracted data from various sources like Oracle, flat files.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos.

Environment: SSIS, Oracle8i, SQL, Cognos 7.0 Series, WindowsXP/2000 and UNIX.

Confidential, Chicago, IL

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Cognos ETL tool.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing.
• Involving in Functional Testing & Regression Testing
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results

Environment: SQL Server 2000, Teradata V2R6, Crystal Reports, Oracle 8i, Microsoft Business Intelligence, MS Excel, Flat Files.

Confidential, Weehawken, NJ

QA Tester

Responsibilities:

• Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
• Gathered and Analyzed Functional and Performance requirements.
• Involved in project planning, coordination and implemented QA methodology.
• Extracted test data by understanding relational database design diagrams Created.
• Designed, Created and executed manual Test Cases.
• Reviewed Test cases for automation and provided inputs about the scope of Automation.
• Prepared documentation about the automation suite architecture.
• Peer Review of the scripts and made recommendations for updates if any.
• Used SSIS to load source files into landing database.
• Performed extensive backend testing by writing Complex SQL queries.
• Setup the Performance test environment with the support of technical team.
• Response time, throughput, hits per second, etc were studied by graphs and reported.
• Created manual & automated test cases for testing web services.
• Used Test Director for storing, maintaining the test repository, bug tracking and reporting.
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner.

Environment: Windows XP, SQL*Plus, Oracle 8i, MS Office Suite, SQL Navigator

Confidential

ETL Tester

Responsibilities:

• Analyzing the user specification/Client requirement documentation.
• Prepared and reviewed detailed test scenarios and test cases covering the mappings and Reports.
• Reports creation and data validation.
• Execution of test cases and defect tracking through Quality Center.
• Involved in collection of test metrics.
• Participated in review meetings and status meetings.
• System testing of the application and raised maximum number of defects.
• Identified design flaw and got good appreciation from client.
• Update testing status to client in client meeting on daily basis.

Environment: SQL, PL/SQL, UNIX and Mercury Test Director.

Confidential

ETL Tester

Responsibilities:

• Proof of concept development for Back Ground Reports Module.
• Involved in preparation of test cases.
• Involved in Functionality Testing and Regression Testing.
• Testing manually all the Screens for Privileges of user.
• Effective Coordination between Development team and testing team.

Environment: Spring - Hibernate, JBoss Application Server, SQL and Mercury Quality Center.