SUMMARY

• Over 8 years of IT experience as a Sr. QA Data Warehouse Analyst/ Tester in ETL, BI, Web based and Client/Server applications using Manual and Automated testing tools under Windows and UNIX environments.
• Expertise using Informatica and Ab Initio ETL tools along wif Business Objects and Cognos reporting tools.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) wif good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience working closely wif Test Data Management (TDM) team for data scrubbing. exists in source tables.
• Experience on Data warehousing concepts like OLAP, SCD modelling, ETL Process, Data Mart, Data Mining and Reporting.
• Experience in writing SQL Queries for different Databases such as Oracle, Teradata and SQL server.
• Excellent experience in various industries such as Banking, credit cards, mortgage financials and health care Insurance companies.
• Experience wif automation Testing Tools of Selenium IDE.
• Extensive experience in developing complex SQL queries for data validation.
• Proficient in writing SQL scripts to validate ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Extensively worked on dimensions and Facts, Data cleansing and Data Staging of operational sources using ETL processes.
• Good experience wif different data sources, data staging, data profiling, Data Cleansing, Data Scrubbing, data validation and Data Migration based on the business and functional requirements.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica using Oracle, Teradata, SQL Server and UNIX.
• Experience in testing Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x (Workflow Manager, Workflow Monitor, Source Analyzer, Mapping Designer) ETL.
• Expert in working wif fixed length, delimited flat files and also worked wif large volume of data in the database/data warehouse.
• Expert in analyzing the error caused to failure of the ETL load wif reference to the log file and report them to the corresponding team to get it rectified.
• Ability in validating and comparing the following (Expected - Actual): SQL-SQL; SQL-File; File-SQL; XML-SQL; SQL-XML
• Solid experience in black box and white box testing techniques.
• Good understanding of data warehousing concepts like Star schema, Snowflake schema, Slowly Changing Dimensions, Fact and Dimensional tables etc.
• Experience in testing Web Based, Client Server Applications.
• Experience in Quality Assurance & Testing Phases including System Testing, User Acceptance Testing (UAT), Integration Testing, Smoke Testing and Regression Testing, Post deployment testing, shake out testing.
• Extensively worked wif all phases of testing deliverables including creation of Test Strategy, Test plans, RTM, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Expertise in analysis of Problem Severity and priority in Defects Reporting System using Test Management tools like Rational Clear Quest, Test Director, Mercury Quality Center and Application lifecycle management (ALM) and communicate toward the team to resolved it.
• Prepared test data for all ETL mapping rules to test the functionality of the Informatica mappings.
• Experience working wif offshore teams. Ability to work on multiple projects which are in various phases of the system development lifecycle.
• Involved in understanding the requirements and end Users/Business Analysts and Developed Strategies for ETL processes.
• Worked in both Agile Environment and Water Fall methodology.
• Able to work collaboratively wif testers, developers and other team members in testing complex projects and in the overall enhancement of software product quality.

TECHNICAL SKILLS

ETL Tools: Informatica 6.1/ 7.1/ 8.1/9.5/9.6.1 , Ab Initio (GDE 1.14, Co>Op 2.14) and Data Stage 6.x/7.x/8.x

Reporting tools: Business Objects XIR2, SSRS, Cognos 8.0.

Databases: SQL Server 2008 R2, Oracle 9i/10g/11g R2, Teradata, Sybase, MS access and DB2.

Languages: C, SQL, PL/SQL, T-SQL, XML, HTML, XHTML, Shell Scripting, PERL, VB Script

Defect Tracking Tools: HP Quality Center, Rational Clear Quest, Mercury Test Director

Testing tools: QuickTestPro (QTP), Clear Quest and Load Runner, Selenium IDE

Scheduler Tools: Control-M and Autosys 4.5

Operating systems: Windows 2000/NT/XP/Vista/8.1, UNIX (Linux, Sun Solaris, IBM AIX)

Other skills: Siebel, Mainframe, Ultra Edit, Toad

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

ETL Tester

Responsibilities:

• Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing the test cases, test scripts by using HP Tools.
• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, System, Compatibility, Installation, End to End Testing and User Acceptance testing.
• Worked wif Business Analysts to define testing requirements to satisfy the business objectives.
• Extensively used Quality Center 10.0 for documenting Test Cases and updating the Test Results after test cases execution TEMPhas been completed.
• Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements.
• Exclusively worked on Informatica Mappings testing and developed small mappings to copy data and join multiple source tables for testing purpose.
• Involved in Testing Change Requests (CR) dat is testing base enhancements to the existing code before implementing in the Production.
• Analyzed and tested Informatica Mappings wif OLTP source data, staging and target data.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Used the Informatica Workflow manager and its run-time engine to schedule the jobs, validating and debugging its transformations, and monitoring the resulting executable versions.
• Always used to interact wif Developers to escalate testing issues and to take their valuable inputs for successful completion of Testing.
• Responsibilities include meeting wif the developers and client groups to determine performance requirements and goals and to determine test strategies dat is based on requirements.
• Extensively worked in UNIX environment and wif UNIX commands.
• Attending review meetings and walkthroughs to understand the requirement documents and the application.
• Reported the defects by entering in Quality Center defect tracking tool.
• Created issue list for each day while performing testing to keep track the status and issues.

Environment: Windows XP, Putty, UNIX, Informatica 9.0, Oracle 10g, Toad, Quality Center 10.0, Teradata SQL Assistant 12.0, MS Visio and MS Project 2003, Control - M.

Confidential, Bloomfield, CT

BI/SQL/DWH TESTER

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested Full Client reports to Web using Report conversion tool.
• Tested/found defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested various complex Web reports wif multiple data providers.
• Tested and worked on creating open document reports.
• 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.
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• TEMPEffectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power centre for extraction, transformation and loading process.
• Worked wif ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues wif migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Informatica Power Center, SQL *Loader, Business Objects, PL/SQL, SQL, Stored Procedures, Unix Shell Scripting, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Windows 2000, TOAD .

Confidential, Tempe, AZ

Sr ETL Tester / Data Analyst

Responsibilities:

• Analyzed business and system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Performed source system analysis and Data Analysis including data profiling by writing queries on the data.
• 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
• Developed Data Mapping documents.
• Involved in developing detailed test plan, cases and scripts using Quality Center for functional and regression testing.
• 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 test environment for staging area, loading the staging area wif data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Wrote several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• 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
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked wif Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Worked wif business team to test the reports developed in Business Objects.
• Used Quality Center and JIRA to track and report system defects and project enhancements.
• Focused on Data Quality issues/problems dat include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• 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 wif internal and external customers.
• Conducted Defect review meetings wif the Development team to discuss the defects which are reopened and defects which are newly opened.
• Conducted meetings wif the Production Support Team to discuss the defects which are raised during the testing.

Confidential, Portsmouth, NH

ETL Tester

Responsibilities:

• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, System, Compatibility, Installation, End to End Testing and User Acceptance testing
• Reviewed design changes, identified test scenarios, created test plan and test cases.
• Involved in scrum (standup) and used to update status of the tasks.
• Involved in project planning meetings and used to provide estimation of the testing tasks.
• Identifying/created test data dat covers identified test scenarios.
• Tested and validated Informatica mappings.
• Knowledge and experience in various Informatica Transformations.
• Executed Informatica mappings in test environment and validated business functionality.
• Validated data in back end tables which is loaded through Informatica mappings.
• Extensively used Informatica Workflow Manager to run the workflows.
• Analyzed and tested Informatica Mappings wif OLTP source data, staging and target data.
• Coordinated wif business and development teams to resolve issues during test execution.
• Execution of UNIX, Autosys Batch jobs, retrieval of logs, identification for the source of errors.
• Responsibilities include meeting wif the developers and client groups to determine performance requirements and goals and to determine test strategies dat is based on requirements.
• Flexible and versatile to adapt to any new environment and work on any project in team
• Prepared status summary reports wif details of executed, passed and failed test cases Interacted wif developers, Business & Management Teams and End Users.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.
• Reported the defects by entering in Quality Center defect tracking tool.

Environment: Windows XP, Informatica, PowerCenter 8.1, Manual Testing, Oracle, Putty, UNIX, Quick test Pro, Quality Center 9.0, Clear Quest 6.1, Autosys, SQL, PL/ SQL.

Confidential

QA Tester

Responsibilities:

• Launch of new web site and involved wif the look and feel testing of all the web pages, Top Side, Bottom navigation, category pages, family pages, checkout page.
• Has also performed extensive Regression testing wif each modification.
• Provided inputs from QA standpoint to the Design/Development teams and Stakeholders.
• Prepared Test plan, Test cases for the Module, Integration and System testing phases.
• Involved in Requirement gathering phase and performed Usability to verify “friendliness” of application.
• Prepared scripts, running tests, Analysing results in LoadRunner 9.1 for Performance testing.
• Defect tracking and Status reporting using Quality Center 10.0 defect tracking tool.
• Tested Data Integrity by executing SQL queries against Central databases.
• In-charge of Usability testing on the product and making appropriate recommendations.
• Validated the CRM functions in the product - managing customer information, cross-channel customer information access, customer history, preferences and profiling.
• Performed Functional testing for each module.
• Involved in Unit testing at developer side and then performed Integration, System and Regression testing.
• Prepared parts of the User Manual, reviewing wif the team and releasing the final document.
• Performed Database testing to check the data integrity.
• Prepared the Release notes (for every release/version) by consolidating current product status.
• Involved in setting up the various Review Processes for the QA team.
• Developed several T-SQL stored procedures functions for the web based application.
• Created invalid request to test Error handling response.
• Participated in User Acceptance testing (UAT) at the client site.

Environment: Windows XP/NT/2003, Oracle 9i, SQL Server 2000, JAVA, Visual Basic, Quick Test Professional 8.2, Quality Center 9.0