SUMMARY

• Over 7+ years of IT experience in various phases of IT projects such as Testing, development and application support.
• Expertise in creating Test Plan, Test Strategy documents and Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience in developing the Manual Test Suites and Automated test suites.
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Extensive experience in testing of Investment banking, Financial, and Telecom models.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to technical and functional requirements.
• Strong working experience in the Data Analysis and Testing the Datawarehouse using Data Conversions, Data Extraction, Data Transformation and Data Loading.
• Experience with all phases of SDLC under V - Model, Agile methodology.
• Extensive testing ETL experience using Informatica Power Center 8.x/7.x (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Extensively worked with creating,integrating and validating MicroStrategy reports, dashboards and objects (Attributes, Filters, Metrics, Facts and Prompts) with the data warehouse
• Extensively used ETL methodology for 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.
• Extensive experience with tools like QTP, Load Runner, Win Runner.
• Good experience in testing web based applications built on Java, J2EE, ASP.net and ASP.
• Good experience in writing SQL/PLSQL in order to data validation in migration as part of backend testing.
• 5+ years of strong data base experience Teradata, Oracle,SqlServer and sybase.
• Good expertise in using TOAD, SQL*Plus and SQL Developer.
• Experience in analyzing defect severity, priority and documentation and scheduling for the fix.
• Experience in release management and defect control management.
• End to End responsibility to close the defects and fixes.
• Good working experience in projects with offshore/onsite model as Lead and coordinator.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Experience in debugging the issues by analyzing the SQL queries.
• Proficient in working with UNIX shell scripts using puTTY Environment.
• Good experience in working with Perl and Unix shell scripts. Worked with releasing scripts live and tested.
• Good experience in working with Unix scripts in executing and validating logs for the issues.
• Involved in Job scheduling using corntab, monitoring the workflows, validating logs for the issues.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Experience in preparing reports with analyzing the defects with respect to metrics.

TECHNICAL SKILLS

ETL tools: Informatica 8.6.1/8.x/7.x, DataStage, SSIS

Business Intelligence Tools: MicroStrategy 8.x, Cognos 7.x, OBIEE 10.3.x,SSRS

Programming Languages: SQL, PL/SQL, Java, C, C#,ASP.Net, ASP3.0

Scripting Languages: HTML, DHTML, XML, Java Script, Shell Scripts

Databases: Oracle11g/10ii, Teradata V2R6/R5, SQLServer2005 Sybase

Database Utilities: TOAD, SQL Advantage, DBArtesan, Query Analyzer, Enterprise Manager, SQL*Loader

Operating Systems: UNIX, HP Solaris and WINDOWS x

Testing/Bug Tracking Tools: Quality Center9.2, MS VSTF, QTP, WinRunner, Rational TestManager,Excel

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• 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.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file clean up process.
• Executing test scripts to verify actual results against expected results by using Informatica PowerConnect for different source validations.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in Development, Unit Testing, White box, Integration, Regression and Performance Tuning and End-To-End testing.
• Involved in testing both Historical and Incremental Loads.
• Tested OLAP cubes for all business conditions
• 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.
• Extraction of test data from staging tables into Data warehouse tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Mappings
• Tested the ETL Workflows and other ETL Processes (Data Warehouse Testing)
• Worked with testing complex datawarehouse structures staging,ODS,Dimesions,Facts and Aggregates.
• Worked with validating Slowly Changing Dimensions(type1,type 2 and type 3)
• Written several complex SQL queries for validating/verifying the business rules for Data.
• Worked with complex stored procedures and functions as per the requirements.
• Experienced in testing mappings, mapplets and complex transformations using Informatica Designer.
• Worked with workflow manager in scheduling workflows, worklets and tasks.
• Worked with Workflow monitor inorder to monitor and troubleshoot the sessions.
• Tested the ETL process for both before data validation and after data validation process. Tested the log messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using Query Studio
• Worked on data Re-conciliation in Source System by writing complex SQL queries,and historical data load using SQL Loader scripts
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Tested the reports using Microstrategy ETL tool and observed the results of the report with correct data population.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries
• Worked with business team to test the reports developed in OLAP
• Responsible for meeting and interacting with users and stakeholders to identify problems in UAT, and resolve issues to improve the whole business process to help ensure stable and accurate solution
• Created user documentation and technical documentation
• Tested whether the reports developed in OLAP 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.
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in raising bugs and bug tracking analysis to resolve issues.

Environment: Informatica Power Center 8.6.1, Microstrategy8,Cognos 7,Oracle 11g/10i, SQL, OLAP, PL/SQL, UNIX, Java, HTML, XML,XSD, XSLT, VSS, Windows, Quality Center 9.2,Reports, ETL testing,FTP, SQL*Loader

Confidential, Seattle

ETL Test Consultant

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Writing the complex T-SQL queries with the basis of PDM-PDDM mapping document.
• Tested the build related scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executed tests for Full pull and the incremental/delta pull scenario’s.
• Compared and Tested Source data with target Output data.
• Shown 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
• Experienced in data analysis using SQL, T-SQL and many other queries based applications.
• Tested the reports using Sql Server 2005 and observed the results of the report with correct data population.
• Create Manual Test Suites for various modules.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Involved with ETL test data creation for all the ETL mapping rules.
• Involved in testing stored procedures & views in MS SQL Server 2005 and OLAP Cubes by MDX.
• Involved in validating Compare and Test Source data with XML Output flow.
• 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.
• Reported bugs and tracked defects using Microsoft VSTF
• Extensively worked with developing test scenarios using complex Multi-Dimensional expressions’ (MDX) for data cubes.
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in raising bugs and bug tracking analysis to resolve issues.

Environment: SQL Server 2008,SSIS,SSRS, OLAP,XML,XSD, XSLT, Flat Files, MS Excel, VSTF, METaL,SFTP, Reports, ETL testing

Confidential, Stanford, CT

ETL Test Analyst

Responsibilities:

• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• 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, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked with ETL group for understating for data loading for both dimensions and facts.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing complex stored procedures, functions and Materialized views in Sybase database
• Written SQL/PLSQL in order to data validation in migration as part of backend testing.
• Worked with Perl and Unix shell scripts. Worked with releasing scripts live and tested.
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like Unix, Linux and windows.
• Worked with UNIX scripts in executing and validating logs for the issues.
• Compared and Tested Source data with XML Output flow.
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Extensively used SQL to verify and validate the data load.
• Worked with 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
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed the tests in both the SIT, QA and contingency/backup environments
• Writing the test scripts for manual testing.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific regions
• Preparing and supporting the QA and UAT test environments

Environment: Informatica 7,Cognos TOAD, Oracle 10g, Sybase 12.3, J2EE, PuTTY, UNIX, Perl

Confidential, Stanford, CT

ETL Test Analyst

Responsibilities:

• Created Test Plan and developed an test strategy for ClearVision 3.4.3 datawarehouse
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems
• Experience in analyzing defect severity, priority and documentation and scheduling for the fix.
• Experience in release management and defect control management.
• End to End responsibility to close the defects and fixes.
• Tested stored procedures & views in Sybase 12.3
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written SQL/PLSQL in order to data validation in migration as part of backend testing.
• Worked with Perl and Unix shell scripts. Worked with releasing scripts live and tested.
• Worked with EAI tool to validate XML Messages before ending to TIBCO queue and TIBCO topic.
• Tested several Java programs for interacting with TIBCO (EAI) Message Bus and worked with interacting JMS Header and Instrument data.
• Responsible for testing TIBCO stage Queues in order to send XML messages to TIBCO Bus.
• Tested several XSD’s for setting up standards for TIBCO Bus Message Formats.
• Involved in Functional testing, End to End testing and Regression Testing.
• Used FTP and Telnet protocols in order to migrate files to heterogeneous systems like Unix and windows.
• Worked with unix scripts in executing and validating logs for the issues.
• Compared and Tested Source data with XML Output flow.
• Worked with 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
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed the tests in both the SIT, QA and contingency/backup environments
• Compared and Front End Source data with backend database.
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Extensively used SQL to verify and validate the backend.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Preparing/Upgrading and supporting the QA and UAT test environments
• Assisting users in UAT, and re-testing and delivering quick fixes.

Environment: GL ClearVision3.4.3, Oracle 9, Sybase 12.3, J2EE 1.4, TIBCO, C, ETL Informatica 7.1, PuTTY, UNIX, Windows, SQL Advantage.

Confidential

ETL Test Engineer

Responsibilities:

• Created Test Plan and developed an test strategy for Front to back feed system.
• Created Manual Test Suites for various modules.
• Writing the test scripts for manual testing.
• Prepared respective testdata using boundary analysis.
• Compared and Front End Source data with backend database.
• Tested stored procedures & views in Sybase 12.3
• Written SQL/PLSQL in order to data validation in migration as part of backend testing.
• Worked with Perl and Unix shell scripts. Worked with releasing scripts live and tested.
• Used FTP and Telnet protocols in order to migrate files to systems on Unix and windows. worked with unix scripts in executing and validating logs for the issues.
• Compared and Tested Source data with XML Output flow
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Extensively used SQL to verify and validate the backend.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific regions
• Preparing/Upgrading and supporting the QA and UAT test environments

Environment: Sybase12.3, SQL Advantage,J2EE and UNIX, Test Director 8,Oracle 9, PL/SQL, TOAD.