SUMMARY

• Dynamic and skilled data warehouse testing professional with diverse knowledge of system testing process and methodologies. Seeking a challenging position as a data warehouse tester in an organization that offers an opportunity to grow professionally.
• Information technology professional with over 10+ years of test experience, including 5+ years of experience in end to end testing of data warehouses, data marts, and other business intelligence solutions throughout the business intelligence lifecycle. Strong analytical and dimensional modeling skills, along with experience in developing Extract, Transform, and Load processes and data presentation layers for the end - user

TECHNICAL SKILLS

Data Warehousing: Informatica9.x/8.x,SSIS 2005,2008 R2

Databases: Oracle 11g/10g/9i/8i, Teradata, DB2,SQL SERVER

GUI Tools: SQL Developer, Toad

Reporting Tools: Cognos,OBIEE,SSRS 2005

Languages: C, C++, Java, VB Script, SQL, PL SQL

Functional Testing Tools: Quick Test Professional 9.5, Win runner 9.2

Performance Testing Tools: Load runner 8.0

Test Management Tools: Quality center 9.2

Operating Systems: Microsoft Windows 95/98/XP/2000/2003, MAC.

Web Technologies: HTML, DHTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Sr Test Analyst

Responsibilities:

• Understanding the requirement and technical specifications in detail and preparing gap analysis sheet for any clarifications with business analyst team.
• Identify the data dependency in the Heart Source System and capture the data flow between Claims SA, Payment SA, Reserve SA and Claim unit SA
• Prepare the Data Dictionary for the existing and proposed new attributes from the Siebel application Heart to the end user interface report in OBIEE
• Involved in column analysis and performed the data profiling in the source system .
• Reviewed the ETL STTM ‘s and OBIEE LLD and co-ordinated with the dev. teams to ensure the requirement coverage is achieved for the proposed dimensions and measures
• Designed the Test Strategy document and got it reviewed with the customers and business teams .
• Incorporated the V-model of software testing and performed the test activities in all the phases of SDLC
• Provided test estimates for the test cycles and designed the test approaches for the Historical and Incremental data
• Prepared test data and incorporated the test data as required into the source system
• Designed ETL testing scenarios from Source to Stage and Stage to CDM. Testing scenarios include Smoke testing, Metadata testing, Load Testing, Data Completeness Check, Data Integrity Testing, Data Correctness Testing, Data Redundancy and Unique Value Check
• Designed test scenarios for the identified metrics for achieving reconciliation between source and target
• Designed OBIEE testing scenarios for validating the individual dimensions, facts and SA and cross subject areas.
• Prepared adhoc reports in OBIEE and validated the data from CDM and conduct end to end testing from source to data mart and data mart to user report.
• Involved in designing SQL’s for all the scenarios designed in the ETL and OBIEE. Performed a dry run with the SQL’ prepared in the lower environments.
• Reviewed the test scenarios, test cases prepared by the testing team and ensured test coverage is achieved
• Load the test data into the target tables by executing the DAC plan as per the historical and incremental test cycle schedules.
• Performed different phases of testing include SIT, UAT, PROD and different types of testing include Functional data validation Confidential ETL and OBIEE, Glass to Glass testing, Performance testing
• Executed the test cases of ETL and OBIEE and capture the test results.
• Raised defects in the Quality center, followed the defect management process and co-ordinated with multiple teams for early defect fixes.
• Performed regression testing after defects fixes, validated the tables/columns and updated the QC
• Designed Glass to Glass testing approach for the source Siebel application and the target OBIEE reports
• Designed and Executed test scenarios for AS Glass to Glass testing and Update data Glass to Glass testing for all the Subject areas.
• Prepared Requirement traceability matrix for all the dimensions, metrics depicting the end to end flow from requirement, source to stage, and stage to CDM, CDM to OBIEE report.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Reported the daily test execution status with the senior management and the customers.

Environment: Informatica PowerCenter9.x, Oracle11g,OBIEE,TOAD,Erwin, Flat Files, UNIX, DAC, Siebel, ALM

Confidential - San Antonio, TX

Sr Test Analyst

Responsibilities:

• Understanding the business requirements and mapping specs documents.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Prepare the test environment setup and initiate the appropriate requests for the readiness of the environment.
• Conducted Data Profiling on the source data and identified the dependency and analyzed the existing data
• Preparing Test Scripts in QTP as per the framework and running the test scripts and capturing the test results.
• Executing the test scripts using ALM and updating the test results.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated locations.
• Tested the data loaded on daily and weekly basis from source to Stage
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into target database.
• Designing the test approach for validating the data across the layers of data warehouse architecture
• Identify the test estimates and prepare test plan covering the complete testing process
• Writing SQL queries based on the transformation logics defined in the mapping spec document.
• Reviewing the test cases and ensuring the test coverage is achieved.
• Loading the extract file data into different stages of FSDIM DW database tables through informatica workflows using Autosys for defining, scheduling and monitoring jobs.
• Comparing/Validating the data between two tables by using automation (QTP) framework.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
• Performing Negative and static testing along with count validations.
• Executed and managed test cases and reported bugs in Quality Center if we have any issues in data comparison or workflow failures.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis .
• Created Integrated summary data from multiple tables to represent the business perspective of the top management executives

Environment: SSIS 2005, Cross Database Comparator, Quick Test Professional,SQL Server, TOAD, SQL Developer, Flat Files, UNIX, Autosys, ALM

Confidential - Dover,NH

ETL Tester

Responsibilities:

• Involve in Understanding the Functional Requirements and business requirements.
• Designed test scripts from source to stage. Source is XML file and sql are designed based on XMLtable and performed data validation.
• Creating Test Scenarios and Test Scripts to validate source and Target data.
• Test Scenarios include end to end test coverage from Quotes to Policies as per the business requirement.
• Involved in Test Case Design with respect to Test Plan.
• Executing the test scripts including prerequisites, detailed instructions and anticipated results.
• Interacting with the development team to solve the problems encountered in the test scenario run.
• Analyzing the root cause of the failed Test Case and provide the corresponding data samples to client
• Tracking the defects using RTC tool and reported the defect status to multiple teams in the project.
• Attend the Status Calls and Updating the Work Status and ensured the test timelines are as per schedule.
• Used Cross database comparator tool for validating the data across heterogeneous databases
• Involved in Cubes Testing and Involved in Cognos Reports testing.
• Involved in Performance Statistics calculation and Involved in Dash board Preparations.
• Involved in Test execution and updated the defect status in QC .
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.

Environment: Informatica PowerCenter9.x, Cross Database Comparator, Teradata, TOAD, SQL Developer, Flat Files, UNIX, RTC, ALM, Cognos Reports

Confidential, Woodland Hills CA

ETL Tester

Responsibilities:

• Understanding Business Process from the requirements and converting them to test scenarios and writing complex SQL queries to suite the requirement.
• Understanding the data model architecture and entity relation among tables involved.
• Developing complex test scripts based on the Cleansing and Transformation rules given in STTM.
• Converting the SQL into SAS jobs based on the logic and Creating Sas jobs for the similar attributes using multiple approaches.
• Executing the test scripts including prerequisites, detailed instructions and anticipated results.
• Identifying the discrepancy in data and performing an in-depth analysis for mismatched records.
• Preparing and Executing different Regression tests when a new build is released and executing Database Test cases to support testing requirements.
• Interacting with the development team to solve the problems encountered in the test scenario run.
• Working with development teams to investigate, prioritize and resolve the defects based on the testing results.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing(UAT) and Data validation Testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Analyzing the root cause of the failed Test Case and provide the corresponding data samples to client.
• Tracking the defects using Excel Sheet and reporting to onsite co-coordinators.
• Raising the defects in MQC with detailed analysis report.
• Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
• Assisted Business team with planning, coordinate and execution of User Acceptance Testing.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management

Environment: Informatica PowerCenter9.x, Cross Database Comparator, DB2, TOAD, SQL Developer, Flat Files, UNIX, ALM

Confidential

Functional Tester

Responsibilities:

• Involved in studying functional specifications and Mercado specifications.
• Involved in understanding the business requirements, functional specifications and Use cases and Design Specifications in each phase of the application.
• Involved in preparing Probe question-aire document and interacted with the Onsite team for clarifications.
• Prepared Test plan, test scenarios, test cases as per the specifications.
• Involved in designing test cases and adding the Mercado related test cases.
• Configured rules,MZ’s in CMC and checking application functionality.
• Involved in Mapping of Size and Color in ML admin
• Executed test cases and raised issues in bug tracking tool Jira.
• Actively communicated with dev team in handling issues during test execution.
• Involved in testing Bazaar voice inline ratings functionality and capturing screenshots in cross browsers.
• Involved in Cross browser testing in IE6,IE7,Safari 2.x and Firefox 2.x browsers
• Responsible in development and maintenance of regression suite using QTP in QC.
• Involved in developing libraries, recovery scenarios and test scripts using QTP.
• Handled Object Repository management for every new release.
• Maintained test suites in Quality Center Lab.
• Responsible in executing test suites through Quality Center Lab and analyze test results
• Managed 3 members of testing team as well played a Lead Role
• Participating in project meeting and discussion meeting/ conference calls with onsite teams.
• Involved in retesting and updating the bug status appropriately
• Involved in validating the data as part of database testing by writing sql’s and executing them.

Environment: Oracle 8.0, Java, Servlets, PL/SQL, Windows NT/98, SQL*Loader, QTP, QC

Confidential

Functional Tester

Responsibilities:

• Involved in Functional study of the Application and Responsible for Preparation and execution of full suite of Test cases.
• Involved in preparation of Test plan document.
• Designed High level Test Scenarios and Test Cases
• Responsible for Functional and Regression testing.
• Involved in Retesting of the test cases based on the builds.
• Involved in all testing related documentation, followed Quality procedures, Developing Test reports using Templates, Developed Bug Report
• Designed test cases using Black Box testing techniques and prepare Requirement Traceability Matrix.
• Involved in Writing the Stored Procedures and executing the stored procedures.
• Co-ordinate with development team in resolving critical bugs.
• Involved in Automated Testing of the System using QTP
• Involved in Reviewing the Scripts for the Application and executing the Scripts with QTP.
• Utilized the best practices for the creation of Test Status Report and Weekly Status Report.

Environment: Oracle 8.0, Java, Servlets, PL/SQL, Windows NT/98, SQL*Loader, QTP, QC