SUMMARY

• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
• 7+ years of experience in the Information Technology industry, involving analysis, ETL and BI testing of DWH applications and reporting applications in the Banking, and Financial Domains and Telecom domains
• Possess specific experience performing Regression and Functional Testing.
• Proficient in Mercury s Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
• Good skills in SQL and PL SQL and Unit testing.
• Hands on expertise in Data ware housing concepts and tools.
• Involved in the ETL processes using Datastage, Informatica,Abinitio,SSIS,SSRS and Autosys tools.
• Expertise in possess specific testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-end and User Acceptance Testing.
• Extensive Experience in Agile Methodology of SDLC.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Good experience in Cognos & Business Objects Reports testing
• Well experienced in writing complex SQL queries for extracting data from multiple tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking
• Defined and Implemented Processes and Procedures for QA Departments
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels

TECHNICAL SKILLS

Web Technologies: XML, HTML, Java 1.4/1.5, J2EE, XSLT, Java Script

App Servers: Java Web Server, Apache Tomcat, Web Logic 8.x, IBM Websphere 7.x

GUI Tools: Visual Basic 6.0, Developer 2000

Databases & RDBMS: ORACLE 7.X, 8, 9i, 10g, MY SQL, MS Access 2003, DB2, SQL Server 2005,SQL Server 2008, Teradata V2R5/V2R6, IBM DB2 8.x, Sybase 12.3

Operating Systems: MS-DOS 6.22, WINDOWS ’95,'98 & NT/2000/XP, Unix

Languages: C, C++, Java, SQL, PL/SQL, VB Scripting

Web Browsers: Internet Explorer 6.0, 5.0, Netscape 7.0, 6.0, Mozilla Firefox 1.5

Defect Management Tool: Test Director 8.0, Quality Center.8.2/9.1

Data Warehousing Tools: Informatica Power Center 8x, Data Stage 7.x, Ab Initio Co>Op 2.14/ GDE 1.14)

BI Tools: Business Objects 6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Web Intelligence, ZABO, InfoView, 3 Tier Business Objects, BCA, BO XI R2

Main Frame: MVS, JCL, COBOL II, VSAM, OS/2, ES 9000, IMS DB/DC, Copy Books

PROFESSIONAL EXPERIENCE

Confidential, Syracuse, NY

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Participated in reporting summary documents reviews.
• Developed Test Cases and Test Scripts for System and UAT Testing
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI
• Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Cognos Reports.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Coordinate very closely with the developers regarding functionalities and defects.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Raised defects in Confidential Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Provided the Test status to the Tech lead, Project lead and the team mates.
• Effectively communicated testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested data from various sources like Oracle, flat files and SQL Server

Environment: Informatica 8.5.1, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, JavaScript, Visual Source Safe 6.0,QTP 9.0, Quality Center 10.0, SQL, PL/SQL, PERL, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, .NET 2008, Teradata V2R6, Cognos 8.0 Series.

Confidential, Charlotte NC

ETL/BI Tester

Responsibilities:

• Identifying business rules and processing logic and creating and defining requirements to be used across all inbound interfaces.
• Obtained a detailed knowledge of the business process being followed in the project environment
• Extensively used Informatica power center for extraction, transformation and loading process.
• Involved in Unit testing and integration testing of Informatica mappings.
• Used SQL for Querying the DB2 database in UNIX environment
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.
• Designed and developed Oracle PL/SQL scripts for test data Import/Export
• Extensively worked with TOAD for querying Oracle Database
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Totally involved with data validation and data conditioning process for testing the quality of the data. Performed white box and black box testing.
• Extensively worked with Quality center for Uploading test cases and defect tracking and reporting defects
• Extracted the business requirements from the end users keeping in mind their need for the application, and documented it for the developers
• Prepared several test scenario for the work flow of the entire ETL cycle
• Prepared test conditions and Test Cases for modules assigned
• Conducted Defect tracking according to status and Priority and maintenance of defects
• Involved in Documenting/Executing business test cases
• Performed detailed analysis of data issues encountered during business acceptance testing
• Actively involved in the daily testing status meeting in which the defects identified were discussed
• Worked with Data Extraction, Transformation and Loading (ETL)
• Involved in testing data mapping and conversion in a server based data warehouse
• Developed and executed test cases and verified actual results with expected results
• Worked with developers in understating the ETL code for writing several complex test plans for testing both front-end and backend

Environment: IBM DB2, Informatica Power Center v7.1.2, UNIX AIX, DB2, Windows XP, XML, XSD, Oracle 10g,TOAD,Mercury Quality Center

Confidential, East Hanover, NJ

Data warehouse/ETL QA

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Tested various jobs and performed data loads and transformations using different stages of Datastage and pre-built routines, functions and macros.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Initiated and developed new techniques to improve the testing process and improve the performance of the test scripts.
• Tested Datastage Hash files for extracting and write data to an intermediate file in a job.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated the execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Employed data modeling, table normalization (de-normalization for Adhoc) in establishing data and application integrity.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Updated the status of testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Submitted Final Test Report and required documentation for the entire project within the assigned time frame.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Validated all kinds of transformations used in every work flow, used to transform data.
• Validating the data flow from source to target.
• Checking the data flow from one end to another by using SQL queries
• Worked with technical staff to create, interpret and implement business requirements into technical specifications.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Developed automated test scripts using QTP to perform Functional and Regression testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Data Stage7.x, Java, SQL, PL/SQL, Oracle 8i+9i, HTML, TOAD, XML, UNIX, Test Director, Quick Test Pro, Quality Center, Shell Scripting, MVS, COBOL II, VSAM, JCL, ISPF, CSV files, Flat Files

Confidential

Software Test Engineer

Responsibilities:

• Understanding of complex financial business requirements
• Writing test plans and test scripts
• Maintained Progress Report of team members for update on individual work during test execution cycle
• Written PL/SQL procedures and numerous SQL queries to go ahead with testing for the data against the requirements
• Performed testing in mainframe environment
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Heavily involved in interacting with UNIX Shell scripts
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Exporting test cases to Test Director
• Preparation of Data Requirements
• Accessing mainframes and validating the data
• Identify & record defects with required information for issue to be reproduced by other teams.
• Worked with high-volume, real-time DB2 database applications and systems
• Conducted Bug Review meetings for update on defects from development team & retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application
• Experienced in coordinating resources within Onsite-Offshore model
• Conducted Training Sessions and Knowledge Transfer Sessions on new applications
• Managing testing documents in Test Director
• Understanding of Business Logic and data flow

Environment: Windows, SQL, PL/SQL, Mainframes, SAP BP, SAP XI, JCL, .Net, DB2, ASP.Net, Test Director