SUMMARY

• Overall 7 years of experience in ETL / Data Warehousing / Business Intelligence Quality Assurance Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Has solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Involved in all testing phases of a Data warehouse projects dat includes Requirements Gathering, Analysis, Testing Estimations, Testing for end - to-end IT solution offerings.
• Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
• Extensive experience in writing SQL to validate teh database systems and for backend database testing.
• Experience in Manual Testing.
• Good knowledge in Data Warehousing concepts, SQL/PLSQL, SAS and UNIX.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Proficiency in understanding of business processes involved in testing of projects.
• Excellent analytical, problem-solving, communication and interpersonal skills.
• Self-motivated, energetic team player wif demonstrated proficiency for learning new tools and business environment.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/8.5/8.1/7.x, SSIS, DataStage, Ab Initio

QA Tools: HP - Quality Center, Test Director, Microsoft TFS

DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000, DB2, Sybase Teradata V2R6/V2R5

Version Control Tools: Rational Clear Case, WIN CVS

Requirements Tools: Doors, Rational Requisite Pro

BI / Reporting Tools: IBM Cognos 8.0, Business Objects BOXI, SSRS, Micro Strategy

Operating Systems: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

Scheduling Tools: Autosys, Control M

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL Back End Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented teh process to perform functional testing of teh application
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging teh SQL-Statements and stored procedures for various business scenarios.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving teh old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• As a ETL Tester responsible for teh business requirements, ETL Analysis, MVS, ETL test and design of teh flow and teh logic for teh Data warehouse project using Informatica, Shell Scripting & PERL
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records wif logical delete using flags
• Helped teh testing team documenting teh system requirements and testing system development. Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT).
• Tested teh different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into teh data warehouse
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Informatica 9.1, XML, XSLT, PERL, WinSQL, SQL Server 2008, QTP, Teradata 13, ALM/HP Quality Center 11, QTP, sDTS, T-SQL, SQL, TOAD, Teradata SQL Assistant, Oracle 11g, PL/SQL, SAS, Cognos 8.0, MS Access/Excel/Visio

Confidential, Vienna, VA

ETL Tester

Responsibilities:

• Prepared teh test case documents wif teh help of BRD, FRS and other supporting documents.
• Attended walkthrough meetings wif teh Business Analysts and DEV team to get a clear understanding of teh business and teh applications being used.
• Created test cases and queries to test teh data move for business card data to load from source to stage and to target.
• Developed and designed test cases based on teh Business Rules and Mapping Documents.
• Validated teh data coming from various sources using complex SQL queries.
• Prepared Traceability Matrices to track teh requirements wif teh test cases and make sure none of them has been missed.
• Logged defects using HP Quality Center 10, linked defects wif requirements and generated Defect Reports in QC.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Worked wif other members of teh QA and Development teams and managed efforts wif offshore team in improving teh processes, methods, TEMPeffectiveness and efficiency.
• Attended daily status call wif Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• Performed Report Testing by performing UI testing and writing SQL queries to validate teh data on teh report and compare wif teh DWH data.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during teh Testing process.
• Retested teh resolved defects/issues after teh developers fix teh defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated teh status of teh testing to teh QA manager, and accomplished tasks for teh assigned work to teh Project Management team regularly.

Environment: Informatica 9, HP Quality Center 10.0, Agile, Oracle 11g, PL/SQL, TOAD, SQL, UNIX, Microstrategy

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all teh ETL processes developed for fetching data from OLTP systems to teh target Market Data warehouse using complex SQL queries.
• Tested teh entire compliance reports generated using Business Objects BI tool by validating teh data in teh report against teh database according to teh requirement specifications using SQL.
• Tested PL/SQL procedures dat were developed to load teh data from temporary tables in staging to target tables in teh data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them wif closure of teh defects.
• Performed data validation on teh flat files dat were generated in UNIX environment using UNIX commands as necessary.
• In teh pre initial load phase validated teh data table additions and code tables based on Code table values document and teh Source to MDM data mapping document.
• Performed independent MDM services testing by preparing xml transactions.
• Tested teh XMLs feeds received from another source which is a third party for data consistency.
• Tested teh ETL wif XML as source and tables in teh data warehouse as target.
• Tracked defects to closure by coordinating wif teh dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from teh source to teh report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of teh requirements based on teh scope.
• Tested teh data consolidation for Master Data Management (MDM)
• Worked wif teh DSO team to understand teh source to target mapping document and accordingly helped them to clean teh source data to decrease teh defects and to ensure dat final data matches wif teh data warehouse standards.
• Prepared test data to cover all teh test scenarios.
• Prepared UNIX scripts to run teh informatica ETL jobs from command line.
• Maintained all teh test cases in HP Quality Center and logged all teh defects into teh defects module.
• Tested teh migration of reports from Business objects XIR2 to XIR3.

Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, Oracle 10g Informatica 8.6, Business Objects XIR3, TOAD for Oracle

Confidential, FRAMINGHAM, MA

QA Analyst

Responsibilities

• Designed and developed UNIX shell scripts as part of teh ETL process to automate teh process of loading, pulling teh data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, data archiving, error log creations and log file cleanup process.
• Developed and Tested UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Written several complex PL/SQL statements for various business scenarios.
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, wif fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Worked extensively wif mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
• Did data parsing, text processing and connecting to teh database using PERL.
• Developed UNIX Shell scripts to automate repetitive database processes
• Tested several ETL routines and procedures.
• Identify teh primary key (logical / physical ) and put update or insert logic
• Deleting teh target data before processing based on logical or physical primary key
• Design and execute teh test cases on teh application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Written Teradata MLOAD, FLOAD, BTEQ, TPUMP, FEXPORT & Case statements.
• Tuned database and SQL statements and schemas for optimal performance.
• Expertise in SQL queries for teh cross verification of data.

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, SQL Server 2000, T-SQL, SQL, PL/SQL, Teradata, Visual Basic 6.0, Windows 95, XML, XSLT, XSD, UNIX, Korn shell scripting, PERL, MVS, JCL, ISPF, VSAM Files, OS/390