PROFESSIONAL SUMMARY:

• Over 9 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server applications.
• Worked with IT Operations to ensure test environment readiness.
• 6 years of experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Informatica .
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs .
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Experience in Financial, Banking, Brokerage, and Securities industries
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Experience in testing the Universe (business view of the database), and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Automated detailed test cases by using Quick Test Pro.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Well versed in analyzing the XML Files.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test suite.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)

TECHNICAL SKILLS:

Data Warehousing: Informatica 8.6/8.1/7.1/6.1 , SSIS, GDE 1.15.

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables.

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

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

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

Web Technologies: HTML 4.0, and DHTML, J2ee

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

ETL/ SQL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Involved in automation of test cases using QTP.
• Did functional testing using QTP.
• Executed SQL statements to check if the data integrity has been maintained.
• Executed SQL statements to test the integration between application and database
• Performed Backend testing manually using complex SQL Queries and Query Analyzer by connecting to the database server.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Created SQL server Analysis Projects using MS SQL Server 2000.
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.

Environment: Informatica 8.6/8.1/7.1/6.1 , SQL,PL/SQL, HP Quality Center 10, HP QTP 10,Rational Clear Quest, MS Excel, Business Objects Enterprise XI R3, Teradata 12.0 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant.

Confidential, Wilmington, Delaware

ETL/ BI Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• 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.
• Used Quality Center for bug reporting.
• Tracked and reported the bugs with Quality center.
• Written several UNIX scripts for invoking data reconciliation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Extensively used Informatica power center for extraction, transformation and loading process.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Extensively Queried through SQL to check the database record
• Developed SQL scripts to perform Backend Testing.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.6,PL/SQL, SQL, SQL Server Analytical Server, SQL Server Reporting Server, TOAD 9.2, Oracle 9.2, HP Quality Centre 9.2, DB Artisan 8.5.2, Autosys, Metal (Meta Data Driven ETL), BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//200

Confidential, San Francisco, CA

ETL MANUAL Tester

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Worked with QTP for Regression Testing
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules

Environment: Quality Center 8.2, SQL, PL/SQL, Business Objects XIR2, Service center, UNIX, Oracle 10G, DB2, TOAD.

Confidential, Woodland Hills, CA

ETL/ QA Tester

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• 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.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• 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.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Involved in pager rotation program to support 24 x 7 production support.

Environment: Informatica 6.1, MVS, UNIX (K-Shell Script), Oracle 10G, SQL Server 2005, DB2, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, Autosys

Confidential, San Francisco, CA

ETL/ Backend Tester

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
• Written customized SQL queries for business needs.
• Reviewed system use cases and functional specs with business and System Analysts.
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica, DB2,Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, FAST EXPORT, BTEQ), XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, SunOS 5.8, DTS, Windows X