SUMMARY

• Over 7+ years of IT experience in Software testing as Quality Assurance, Analysis/Design, Testing, development, and implementation of test plans, test cases and test procedures in web based (internet/intranet).
• Highly skilled in ETL testing wif Datastage, UNIX Shell Scripts, Teradata, Oracle, SQL, PL/SQL, SQL*Loader, SQL Server.
• Enormous technical and functional expertise in Data modeling using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling and OLTP systems.
• Superiorly well versed in teh art of oral communication in coordinating technical issues between Testers and Developers.
• Diversified experience in Manual and Automated testing; extensively used automated Testing Tools such as Mercury Interactive Test suite in both Windows and UNIX environment (Win Runner, QTP and Test Director).
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing wif business scenarios.
• Proficient at performing data analysis and excellent understanding of data management.
• Excellent understanding of SDLC. In depth noledge of one or more development methodologies.
• Experience wif implementing and operating software control management, automated build management and automated testing.
• Experience wif Agile Methodology.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing teh Traceability Matrices.
• Extensively used teh Load runner to develop teh performance test scripts to meet teh performance testing requirements.
• Experience in all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Expert in Mercury Test tools (QTP) Quick Test Pro, Test Director, Quality Center, Win Runner.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Very strong noledge of RDBMS and Data Warehousing Design Concepts.
• Involved in Sprint Planning meetings, Requirement Review meetings, weekly Bug tracking meetings, Status meetings.
• Worked on complex SQL queries for data validations and data verification for both ETL and BI testing.

SKILLS SUMMARY:

Toolsets: Datastage 8.0.1, Informatica 8.6.1/8.1, SQL DTS, Telelogic Synergy, Mercury Test Director.

Database: Oracle 8i/9i/10g, SQL Server 7.0/2000/2005, Teradata 6x/5x, MS Access

Tools/Utilities: TOAD, SQL* Plus, MS Visio, Teradata SQL Assistant, Erwin, VSS, Autosys, Control - M

Languages: SQL, T-SQL, PL/SQL, Visual Basic 6.0, VBA, Excel, Access, C/C++, XML, XSLT, XSD

Platforms: Windows, IBM AIX, HP-UX, Linux

BI Tools: Business Objects 6.5/XIR2, Cognos 7.3/8.0 Series, SQL Reporting Services, Crystal Reports

EXPERIENCE SUMMARY:

Confidential, Charlotte, NC

Data Warehouse Tester

Roles & Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure teh proper delivery of teh application into teh production environment.
• Developed data quality test plans and manually executed ETL and BI test cases and RTM’s.
• Involved in writing teh Test cases and Test scripts based on Source to Target Mapping documents and Data Model diagrams. Developed Traceability Matrix.
• Prepared testing strategy, testing schedule, test Cases depending upon teh Requirement documents for integration and system testing.
• Coordinated wif teh Developers regarding teh Defects raised and Retested them against teh application.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate teh data between Enterprise Data Warehousing and Data Mart Staging Tables. Strong usage of Mercury Quality center management tool for a centralized control over entire project.
• Performed Functional, Screen flow and Work flow test scripts as per teh user requirements.
• Developed data integration scripts and resolved data related issues during initial loads from different sources.
• Worked wif DataStage Director for monitoring performance statistics of each stage.
• Developed Excel models and templates to verify results and performed extensive data analysis and reconciliation.

Environment: IBM Websphere DataStage 8.0.1, Erwin, SQL, PL/SQL, DB2, XML files, DOM, Oracle 11g/10g, TOAD, Windows XP Professional, DB2, Teradata V2 R5, Business Objects UNIX Shell Scripting.

Confidential, Omaha, NE

ETL Test Engineer

Roles & Responsibilities:

• Written complex SQL queries to validate teh data against teh target based on ETL mapping specifications.
• Tested complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load teh data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Performed backend testing in Oracle /SQL Server My SQL database and analyzed teh log files for different error codes for ETL processing.
• Wrote many SQL/PL-SQL scripts to verify data in teh DB and verify consistency wif Web Portal BI reports.
• Extensively coordinated wif teh Engineering team/Product team/QA team to discuss challenging issues/bugs/features faced while testing teh product.
• Responsible for developing test plans, testing strategy, test cases and execution of teh complete test cycle for teh backend for ETL and BI needs.
• Wrote many SQL/PLSQL scripts to verify data in teh DB and verify consistency wif ETL mapping.
• Interacting wif developers and trying to track/verify bugs in teh corporate Bug database and ensure smooth progress and completion of teh QA cycle.
• Involved in testing universes and reports for correct mapping of teh objects and data correctness.
• Experience in documenting Functional, Technical Specifications and Test Cases.
• Wrote SQL Statements to extract Data from Tables and to verify teh output Data of teh reports.

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange, Oracle 10g, MS SQL Server 2005, Oracle, windows, Mainframe, HP Quality Center 10.0, Rational Clear Quest, XML Files, XSD, XML Spy 2011, Business Objects XIR3

Confidential, Seattle, WA

QA Analyst

Responsibilities:

• Involved in creating source target mappings based on teh 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.
• Tracked defects through Quality Center and Clear Quest.
• 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 design strategy of teh Extract, Transform and Load for various ODW tables.
• Tested mappings wif teh Design Documents and also performed testing for various sample data.
• Created test suites for functional and regression testing using QTP.
• Worked wif all Teradata load utilities.
• Use Quality Center for all test phases as a repository, test management, test execution, and test reporting activities
• 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 center 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.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Validated cube and query data from teh reporting system back to teh source system.

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange, Oracle 10g, MS SQL Server 2005, Oracle, windows, Mainframe, HP Quality Center 10.0, Rational Clear Quest, XML Files, XSD, XML Spy 2011, Business Objects XIR3

DWH Tester (Customer Data Mart - Global Consumer Group)

Roles & Responsibilities:

• Done database testing on Oracle, SQL Server, Teradata and MYSQL databases using SQL queries.
• Designed and executed teh test cases on teh application as per company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records wif logical delete using flags.
• Interacting wif senior peers or subject matter experts to learn more about teh data.
• Modified XML files to manipulate teh data to fake teh web services.
• Provided excellent support during QA/UAT/Beta testing by working wif multiple groups.
• Optimized teh SQLs and Tested Informatica mappings which handled millions of records.
• Parameterized teh automated scripts for running multiple sets of data.
• Tested different ETL mappings and transformations.
• Tested different Cognos cubes (dimensions, measures) by creating analysis on front end and verifying wif SQL on backend.
• Performed Functionality and Regression testing of source application, Cognos and Data integration.
• Performed Ad-Hoc Testing for Cognos tool upgrades and ETL tool upgrades.
• Performed Black Box testing for testing all teh business requirements and teh System functionality
• Created test data in source application to run approved test cases.
• Supported UAT Testing effort by coordinating wif end users and executing UAT test cases.
• Tested re-usable components in Informatica, Oracle and UNIX.
• On-Call/Production Support provided during day-time and off-hours.
• Performed Database and Text checkpoints of Quick Test Pro.
• Proved accuracy in doing sanity checks, smoke tests after teh install of new scripts used by ETL.
• Read and understand teh Log files to verify teh processes for debugging and/or test data verification purposes.
• Prepared ETL Test Data based on ETL mapping document.
• Create Test plan and Test Cases to cover overall functionality of teh application.
• Regression Test Plan and Production Acceptance test plan for teh test releases.
• Prepare and execute Test Cases for end-to-end functionality testing.
• Generated testing reports and metrics, trend graphs according to teh test plan.
• Created and executed SQL queries in ORACLE and MS SQL server.
• Performed tests on various browsers for Cognos Reportnet reports.

Environment: Informatica 8.6.1, Cognos 8.0 Series, HP Quality Center 10.0, MS SQL Server 2008, Oracle 11g (SQL, PL/SQL), TOAD, MS Access, QTP 9.2, Teradata V2R6, Teradata SQL Assistant, XML, XML Spy 2010, J2EE, Sybase 12.5, IBM AIX 5.5, Shell Scripting

Confidential

Software Engineer

Roles & Responsibilities:

• Worked on gathering requirements for loan level and pool level amortization process.
• Prepared detailed business requirement documents.
• Reviewed teh Business Requirement Documents and teh Technical Specification.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of teh application.
• Performed System Testing and Integrity Testing using WinRunner.
• Developed, tracked and managed Issues Log created during teh test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Coordinated teh Onsite and Offshore teams to resolve issues.
• Track and report upon testing activities, including teh test case execution stage, defect status if any defects opened during execution and teh testing results status.
• Executed teh UNIX shell scripts that invoked SQL loader to load data into tables.
• Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.
• Maintained Traceability Matrix to track teh requirements to teh test cases to ensure complete test coverage in teh Mercury Quality Center.
• Prepared Test Plan from teh Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executing SQL statements and manually verifying teh contents.
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, Autosys, Test Director, JSP, Java Script, HTML, Windows NT/2000, UNIX