SUMMARY

• Experienced DWH and BI Tester/Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / processing.
• Experienced in testing Web applications and client/server applications
• Over 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.
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Tested Cognos reports to check whether they are generated as per the company standards
• Solid Back End Testing experience by writing and executing SQL Queries.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Extensive working experience in RDBMS technologies like Oracle 8.x/9.x/10g/11i, DB 2 8.0/7.0/6.0 , MS SQL Server 2008/2005/2000/7.0/6.5 , Dbase, Excel and MYSQL. SQL Developer, TOAD, SQL Plus, Win SQL, Quest Central for DB2. Good at working with SQL Assistant 7.1 in Teradata environment.
• Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experienced in working with HP Quality Center 10.0, Rational Clear Quest & Test Director.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience with Agile Methodology.
• Experienced in running SQL queries using Toad and SQL Server.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Developing and Delivering System Documentation and Training; Testing and Auditing
• Excellent problem solving, interpersonal, and communication skills.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.

TECHNICAL SKILLS

ETL Tools: Informatica 8.1/7.1./6.2/6.1/5.1 , Data Stage 8.x, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS

Testing Tools: Quality Center, Win Runner, Test Director, Load Runner, QTP, Manual Testing

Database Management: Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6, Netezza

Reporting Tools: Cognos 8.0 Series, OBIEE, Business Objects 5.1 /6.1/XIR2

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX), MVS

Version control: Visual Source safe, WINCVS,PVC

Web Programming: HTML, XML,JSP, Java Script

Programming languages: C/C++, PL/SQL, VB 6.0, ABAP

PROFESSIONAL EXPERIENCE

Confidential, Bay shore, NY

ETL Data Warehouse Tester

Responsibilities:

• Involve in Business analysis and requirements gathering.
• Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testings
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Worked in an Agile technology with Scrum. Conduct QA scrum call to gather status of the offshore team.
• Communicate or KT the project details as and when needed. Provide QA testing timelines understanding the project requirement and scope of testing.
• Develop Validation plan and Quality summary report for the project
• Draft test plans based on test strategy. Reviewed, created and executed test cases and test scripts based on test strategy and test plans based on Product Requirement Document.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting Managers.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Involved in Performance testing to ensure the load and stress capability of the application. Validated documented user requirements.
• Written several complex SQL queries for validating Cognos Reports.
• Preparing daily status reports and defect reports.
• Wrote SQL scripts to perform database testing and to verify data integrity.
• Focused on Data Quality issues, problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Extensively worked on designing various output and management reports Using SQL Server
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Tested the outgoing links from all the web pages from specific domain.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• Reported bugs and tracked defects using Quality Center (Test Director)
• 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.
• Tested and worked on creating open document reports for business.
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Involved in testing the Cognos reports by writing complex SQL queries
• 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 with 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.
• Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing..
• Tested data warehouse ETL process using SSIS (Integration Service)
• Managed and executed the test process, using Agile Methodology
• Review the test cases and bug reports.

Environment: Informatica 8.6.1/8.1,MS SQL Server 2005/2008, QTP, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Linux, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1, Cognos, WEBLOAD

Confidential, MN

ETL Data Warehouse Tester

Responsibilities:

• Developed and Designed Test Cases based on the Business requirements.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively tested the reports generated in Cognos by writing SQL queries to validate the data on the report and compare with the TPW data.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Used SQL for Querying the database in Linux environment for testing the business rules imposed on data movement with Informatica ETL tool.
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Attended walkthrough meetings with the Business Analysts and development to get a clear understanding of the business and the applications being used in house.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP 10 and VB Scripting.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
• Worked with business team to test the reports developed in Cognos
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• 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.
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Developed PL/SQL procedures & triggers.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Prepared strategies for analyzing the data for ETL Team
• Worked in an agile technology.
• Involved in testing the Cognos reports by writing complex SQL queries
• Created and executed SQL queries in ORACLE and MS SQL server
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Cognos 8.x, Informatica 8.1/ 7.1.4 (Power Center Designer, workflow manager, workflow monitor), MS SQL Server 2008,Oracle 10g, PL/SQL, TOAD 8.0, QTP,SQL, Linux, Netezza, Maestro 8.0 (Tivoli Work Scheduler), Charm, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

Confidential, San Francisco CA

ETL QA Tester

Responsibilities:

• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
• 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.
• Responsible for Mini specifications document that describe the functionality of each subject area.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Managed and executed the test process, using Agile Methodology
• Analyzed the Data Dictionary developed by the Systems Analyst for developing test scripts to test the Policy and Claims systems.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts.
• Extensively used Informatica Power Center 8.1.1 to load data sourcing from Source to Target databases.
• Executing ETL - Informatica Workflows for updating test Databases from the Production servers.
• Worked rigorously with developers to create test scripts in regards to the Informatica ETL.
• Used Quality Center to track and report system defects
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Tested all the internal links and tested links jumping on the same Web page
• Tested several reports developed in MS Reporting Services which were migrated from Business Objects XI R2.

Environment: Informatica 8.1.1, Business Objects Xi R2, Windows XP, Oracle10G, Sybase, IBM DB2,TOAD for Oracle, UNIX, MS SQL Server 2008,Reflections, Agile, Mercury Quality Center.

Confidential, Seattle WA

QA Test Engineer

Responsibilities:

• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Identified the Test Cases to be automated and lead the effort for automating the product.
• Used Test Director to organize the Win Runner Scripts and schedule test execution.
• Used Test Director for Bug Reports and Defect Tracking.
• Tested User Interface inconsistency and application functionality.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in DB2 environment.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Preparation of test data for various levels of testing
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Load new or modified data into back-end Oracle database.
• 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.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Worked on issues with 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 7.1 (Power Center Designer, workflow manager, workflow monitor), OBIEE, Oracle 9i, Agile, HP Quality Center, TOAD 7, SQL *Loader, SQL Server 2000, QC, Test Director, Erwin 3.5, Windows 2000

Confidential

QA Analyst

Responsibilities:

• Developed Test Cases and Test Design using Quality Center.
• Automated the scripts using QTP by developing VB scripts. Developed functions in QTP.
• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted Functional, GUI, Regression and User-Acceptance (UAT) testing.
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated the Web Services (SOAP), both Request and Response messages.
• Tested the Source and Target databases and ETL process.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Created Traceability between Requirements and Test Cases.
• Conducted Data Driven testing to test various sets of data. Worked with UNIX Shell Scripts.
• Tracked the defects using Test Director and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Configuration management / Version control was done using Visual Source Safe.

Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP, Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-Office.