SUMMARY:

• Experience in Data Warehouse applications testing using Informatica Power Center on multiple platforms. Reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools. Overseeing Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Experienced in data warehouse development works involving data migration, data conversion, and ETL operations using Power Center 6.2/5.1.
• Fine - tuning SQL overrides for performance Enhancements.
• Developing complicated SQL script for Data validation testing by running SQL script, procedures.
• Participating in all aspects of SDLC; build and execute test suite using Microsoft Test Manager. Proficiency in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Working on Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Estimating and preparing schedule for different phases of Test cycle.
• Handing Critical Defects and Production Related Defects. Knowledge of UNIX Utilities, Shell Script to automate process. Using ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• Testing business reports developed in Cognos. Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Providing Functional testing, Integration/System testing, Regression testing and User Acceptance testing.

TECHNICAL SKILL:

Data Warehousing: Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x, Ab initioReporting Tools Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and Dimension tables, Pivot Tables, Erwin

Testing Tools: HP Quality Center, Rational Tools

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS, Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases: Oracle 10g/9i/8i, MS SQL Server … DB2, Teradata V2R6 , Netezza NPS 8050

Defect Tracking Tools: TFS, Bugzilla, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Eagan, MN

ETL /MDM Tester

Responsibilities:

• Extensively involved in business analysis and requirements gathering.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Analyzed the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology. Tested reports and ETL mappings from Source to Target. 
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in HP Quality Center with Pass/Fail/Blocked status. 
• Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions.
• Created Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the Cognos reports. 
• Validated Cognos Standard Reports created based on Frame work manager and Cube. 
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides.
• Performed Data Driven Testing of the Application for different users/data sets.
• Prepared test data for various levels of testing. Gave production support in scheduling and tested this data with the existing data.
• Developed Test cases for the data warehouse in Oracle System. Worked on Oracle to implement the project and written the Test Plan and Test Cases for the module Sales Cycle.
• Used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Developed detailed System test plan including test procedures and test cases.
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness.
• Developed test automation scripts for Regression and Performance testing.
• Identified and resolved many application bugs and bottlenecks. Verified all the functional and load requirements are met.

Environment: Informatica Power Center 8.1, MDM, AQT, PUTTY, SQL, SQL Server 2005/2008, UNIX, Oracle 9i and SAS 7.2, IBM Notes

Confidential, NC

Manual Tester

Responsibilities:

• Performed manual testing using the test cases for positive and negative testing.
• Created Test Plan and developed a test suite for testing purpose.
• Supported BA and Business Users during UAT phase.
• Involved in Agile development methodology.
• Defect Tracking and Bug Reporting was performed using Quality Center.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans.
• Reviewed Test assignments and executed test cases as assigned. 
• Performed UAT testing.
• Created Test Cases, Test Scenarios in Quality Center ensured traceability to Business Use Cases and according to application.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed extensive Data Integrity testing by executing  SQL  Statements on Oracle &   SQL database.
• Executing the Test cases for the mini regression and full regression testing. 
• Supported the business team during User Acceptance Testing. 
• Involved in Smoke, Functional, Integration, System, Regression, UAT Test Execution and Management. 
• Prepared the Test Plan and Testing Strategies for 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.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: Quality Center 9.0, Agile, UNIX Shell Scripting, Oracle, SQL *Loader, Series, Oracle8i, SQL Server 2000, Windows 2000, HP ALM, JIRA

ETL QA Tester

Responsibilities:

• Extensively involved in business analysis and requirements gathering.
• Loading Flat file Data into Teradata tables using UNIX Shell scripts.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Tested data feeds from XML to Database.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Tested   data migration  to ensure that integrity of   data  was not compromised.
• Created   ETL mapping documents for every mapping and   Data Migration  document for smooth transfer of project from development to testing environment and then to production environment.
• Tested several   data migration  application for security,   data protection and   data  corruption during transfer.
• Developed test cases to accomplish ETL   data migration.
• Wrote   data conversion and   data migration  scripts for ETL process.
• Data migration  - Includes   migration  of   data  from legacy environment to Oracle System.   
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications.
• Involved in testing Cognos reports for data quality and cosmetics according to requirements.
• Conditional testing of constraints based on the business rules.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in HP Quality Center with Pass/Fail/Blocked status.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Accessing Mainframes and validating the data.
• Tested and validated the Cognos Report Net reports by running similar SQL queries against the source system(s). Worked on backend testing by writing complex SQL queries.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Compared query result sets from different database systems using UNIX diff command.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center.
• 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 9.1, Cognos8.4, Quality Center, MS SQL Server 2008, Oracle 11g, SQL, PL/SQL, IBM DB2,SQL *Loader, Mainframes, UNIX Shell Scripting, Windows XP/2000

Confidential

ETL Tester

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Wrote test cases based on ETL mapping document for testing the entire ETL job.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files. Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Developed Test Cases to cover overall quality assurance testing. Executed the Test cases for Crystal Reports. Maintained Test Logs and Reports in Quality Center.
• Rebuilt testing of the BI Reports from Cognos to Crystal Reports. Oversaw business processes to learn business requirements.
• Validated the data extracted from different systems into Source.
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of the application.
• Prepared Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Rational Clear Quest to report bugs found in different testing stages. Executed Test Procedures and documented Test Results.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executed jobs through sequencer for better performance and easy maintenance.
• Assisted with performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

Environment: Informatica, Quality Center/HP ALM, Crystal Reports, SQL*Plus, SQL, Rational Clear Quest, Oracle 8.0, Clear Case, SQL Server 2000, PL/SQL, Windows 95, and UNIX