SUMMARY

• Over 7 years of Experience in Data warehousing Analyst, Quality Assurance and 6 years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture Designing And industry verticals like Banking, Financial, and Brokerage.
• Proficient experience with SQL Server and MSBI tools like SSIS, SSAS, and SSRS
• Extensive testing ETL experience using Informatica 8.6/8.5/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Worked extensively with Dimensional modeling, ETL Processes.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration
• Solid Back End Testing experience by writing and executing SQL Queries
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Experience in data ware house tools like Informatica, SSIS and Ascential Datastage Director.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
• Good working experience inOracle, Unix ShellScripting
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/8.1/7.1/6.2/ 6.1 /5.1, Informatica Power Exchange, Power Mart 6.1/6.0/5.2/5.1, Data Transformation Services (DTS)

Databases: Oracle 10g/9i/8i/8.X/7.X, SQL Server, DB2 UDB, Teradata

Database Tools: Oracle SQL*Plus, SQL Navigator, TOAD, SQL Server Management Studio 2008

Dimensional Modeling: Star-Schema Modeling, Snowflake Modeling, Physical and Data Modeling

Scheduling Tools: Cron Tab, Autosys

Drafting Tools: ERWin 3.5/4.0/4.1/7.1, Rational Rose, Microsoft Visio, UML

Development Tools: Microsoft Visual Studio 2008, Visual source safe

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

Operating Systems: Windows XP/2000/NT/95/98, UNIX (Solaris 5.7/5.8/5.9, HP-UX)

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

Sr. SQL/ETL/BI Tester

Responsibilities:

• Created SQL server Analysis Projects using MS SQL Server 2000.
• Migrated objects from SQL Server 2000 to SQL Server 2005
• Designing the template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets
• Ensured that the mappings are correct and Conducted data validation testing
• Worked with business analyst and developers in setting up test data
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Extensively test the reports for data accuracy and universe related errors
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Preparing manual test cases and test data for Scenarios
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data
• Implemented SDLC, QA methodologies and concepts in the Project
• 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
• Responsible for testing Business Reports developed by Business Objects XIR2
• Experience in creating UNIX scripts for file transfer and file manipulation
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Created ETL execution scripts for automating jobs
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Tested Operation Data Store process of ODS/DWL product
• Used workflow manager for session management, database connection management and scheduling of jobs

ENVIRONMENT: ETL informatica 8.6,SQL Server 2008/2005, SSIS, Oracle 9i/10g, XML, Flat Files, Cognos 7.3 Series, T-SQL, MS Excel, UNIX, Korn Shell Scripting, Windows, Quality Center 9.2 and Test Director 8.0

Confidential, Chicago, IL

ETL Tester

Responsibilities:

• Developed the Test Plan based on the Business requirement doc, Design and Analysis doc, Business workflows, Configuration Specifications doc, Vendor system and Subject Matters experts.
• Creation and execution of SQL queries on the DB also testing the SQL queries in the workflow of the application.
• Developed and Executed the Test Cases for various scenarios based on requirements.
• Used Toad and Win SQL to validate the data in Database
• Created shell scripts for automating the jobs to load dimension and fact tables using scheduling tool Autosys
• Generated Reports and Documented and Communicated test results on daily bases.
• Used Rational Clear Quest for bug tracking and followed up with development team to verify bug fixes, and update bug status.
• Checked Front-end validations and Front-end creation (images, Forms & pages).
• Written SQL statements manually to validate data from Database using SQL*PLUS Environment
• Written shell scripts to invoke the SQL Loader to load the data into oracle DB from flat files using control files.
• Created SQLs for QA testing and assisted in testing the data
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Created Tech design document and had walk through with QA team and Production team
• Modified the test cases and re-ran them for the purpose of Regression Testing.
• Generated Reports and Documented and Communicated test results on daily basis.
• Coordinated UAT and sign off for application before rolling out to production.
• Writing UNIX Shell Scripts for automating process.
• Designing the Reports model using Business Framework Manager.
• Created Unix Shell Scripts wrote Scheduler utilities for automating the backup of Database/ Transaction log.

ENVIRONMENT: HP Quality Center 9.0, Informatica 8.6, Informatica 9.1, Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP, Internet Explorer, SQL, TOP Team, JIRA, Analytix, OBIEE, SPOTFIRE, ETL

Confidential, Bethesda, MD

Test Engineer

Responsibilities:

• Understanding the Requirements using the Use case, Traceability Matrix and Associated documents
• Understanding the approach for Test Design phase, Writing/Reviewing Test Cases for the Test Conditions sCoordinating with Business team to discuss on Project related action items
• Planning for Test Execution activities to accomplish tasks on Daily/Weekly basis
• Reporting metrics/status reports for Test Execution phase on Daily/Weekly basis
• Reporting Defects in Quality Center on testing the application
• Back End Testing was done to verify and validate data
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.

ENVIRONMENT: Windows MS Visio, MS Office Suite, Client Server, UML, Manual Testing, RUP, SQL MS Project, MS Access, Test Director

Confidential, Hartford, CT

SQL Tester

Responsibilities:

• Prepared Test Plan and Test cases for the project.
• Developed test strategy, test plans and created test cases by going through all the documentation, walk through and detailed design documents.
• Developed scenarios for Regression testing, Integration testing, Functional testing and backend testing which covers more than 90% of Critical scenarios for the application.
• Performed Backend Testing and Used SQL queries to validate the entries in database.
• Executed SQL queries for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Performed Black box testing, Smoke testing, Functional testing, Regression testing, User Interface testing, Security testing and Integration testing.
• Interacted with different development teams to coordinate testing

Environment: Active Visual Studio .NET 2005, Microsoft Visual SourceSafe 6.0, SQL Server 2000, T- SQL, MS Access 2000, Windows XP.

Confidential, Charlotte, NC

HP QA Engineer

Responsibilities:

• Involved in preparing the TRD (Technical Requirements Document) through Business requirements document.
• Developed test strategy, test plans and created test cases by going through all the documentation, walk through and detailed design documents.
• Developed scenarios for Regression testing, Integration testing, Functional testing and backend testing which covers more than 90% of Critical scenarios for the application.
• Involved in analyzing the changes made from the previous release.
• Involved in entire Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Prepared test data to make sure all the scenarios are captured and tested.
• Validated reports after execution, and comparing expected results with actual results.
• Created SQL queries to verify the database updates, inserts and delete of the records and validate reports.
• Created and executed SQL queries to fetch data from database server to validate and compare expected results with those actually obtained.
• Involved in entire SDLC.
• Performed Black box testing, Regression testing, User Interface testing, Security testing and Integration testing.
• Used HPQC for reporting, tracking and verification of fixed bugs.
• Used SQL queries to validate the entries in the database.
• Involved in the development of test plans, test strategy, test scenarios and test cases
• Interacted with different development teams to coordinate testing.
• Participated in the Usability Testing.
• Performed daily Smoke Tests.

Environment: Informatica 8.0,Business Objects and 8.6, Oracle 10g, Teradata, Toad, UNIX, Quality Center 9.2, Java, EJB, Web Logic Server