Professional Summary:

• 7 years of IT experience in the Analysis, Design, development, testing and Implementation of ETL Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experienced DWH and BI Tester/QA Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
• Good skills and understanding of SQA methodologies and practice
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Data Migration Test and Study Configuration Test.
• Ability to perform root cause analyses and drive improvements
• Effectively manage multiple work assignments and priorities.
• Excellent understanding and expertise in writing complex SQL DDL, DML and DCL queries to perform back-end testing.
• Strong working experience on DSS Decision Support Systems applications, and Extraction, Transformation and Load ETL of data from Legacy systems using Informatica.
• Well versed using UNIX commands for shell scripting.
• Extensively used ETL methodology for supporting data extraction, transformations and loading, in a corporate-wide-ETL Solution using DataStage and Informatica.
• Expertise in Testing complex Business rules by creating mapping and various transformations using Informatica.
• Worked with HP Quality Center and Clear Quest for Test Management and defect tracking.
• Good experience in testing SOA web services project.
• Excellent experience in developing Business Intelligence Applications using Business Objects and Crystal Reports.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Developing and Delivering System Documentation and UAT Test scripts and auditing documentation for maintaining ITIL.
• Excellent problem solving, interpersonal, and communication skills.

Technical Skills:

Confidential

BI/DW QA Engineer

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• 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.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• 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.
• Conducted Data Migration and Data Cleansing
• Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Participated in change review meetings and suggested on the testability of the CRs.
• Tested the reports like drill down, dill up and Pivot reports generated from OBIEE.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• System was implemented using Informatica and the Warehouse in Teradata. Fast-Load, MultiLoad, BTEQ Fast-Export were the Teradata utilities used
• Performed Report Testing using Business Objects XIR4 by writing SQL queries to validate the data on the report and compare with the DWH data.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting and AutoSys.
• Participated in walkthrough and defect report meetings periodically.
• 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.
• Wrote data conversion and data migration scripts for ETL process
• Retesting 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.

Environment: MVS, Informatica 9.0, Oracle 10g, AutoSys, Teradata V2R5 Teradata SQL Assistant, PL/SQL, TOAD 8.0, SQL, UNIX, Quality Center 10.0, Business Objects XIR4, OBIEE

Confidential

BI/DW QA Engineer

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Tested data migration to ensure that integrity of data was not compromised.
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• As a ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Tested several Business Objects Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI's, Grouped List, Cascade and Web Reports.
• Tested and validated the Business Objects reports by running similar SQL queries against the source system s .
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 9.8
• Tested several data migration application for security, data protection and data corruption during transfer.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations

Environment: Informatica 8.6.1/9, Business Objects XIR3, WinSQL, QTP 9.5, Quality Center 9.8, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2.

Confidential

ETL QA Tester

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Involved in Data migration and Data distribution testing
• Validated all the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Validated all the session logs.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Enhanced the Ramp Up and Ramp Down time's to simulate the real time scenarios.
• Generated Load Runner reports with Running Vusers, Hits per Second, Throughput, Average Response time and Total Transactions per Second graphs.
• Created a Performance Report for the end to end testing in comparison with the baseline and final values.
• Uploading the Performance Test Plan, Test Scripts, Scenarios and Final Reports in the Quality Center for every application.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Also worked closely with the developers for the Performance Tuning of a new application by gradual Scaling of the application.
• Assigned critical performance Defects to the developer using Quality Center.
• Weekly meeting with the management team and share the Status Report on the weekly basis.
• Tested and validated data on Hyperion reports

Environment: Hyperion, Quality Center QC 9.0/9.2, VB script, SQL, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle 9i, Informatica 8

Confidential

DW Tester Product Sales Data Mart

Responsibilities

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Scheduling the UNIX script from the CRONTAB
• Unit tested the mappings using SQL scripts.
• Tested mappings to load data into II slowly changing dimension tables.
• Suggested to create Oracle Indexes on some of the source tables
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts for trend analysis .
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, data values, functionality, calculations, fonts, headers cosmetic.

Environment: Informatica Power Center 7.1 Power Center Designer, workflow manager, workflow monitor , Mercury Test Director 6.5, QTP 7.2, SQL Loader, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.