SUMMARY

• Around 9years of IT experience in various phases of IT projects such as testing, deployment and application support.
• ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• 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.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in testing of Investment banking and Academic clients.
• 5 years of strong data base experience in Oracle, SQL Server 2000, IBM DB2 and Sybase.
• Strong experience in testing tools like TestDirector7.6, Quality Center, Quick Test Pro.
• Expertise in writing SQL and PL/SQL statements.
• Good expertise in using TOAD, SQL*Plus and SQL Advantage.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Experience in all aspects of project development life cycle.
• Experience with integration testing of the applications using various sources like flat files, sybase and oracle databases.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Experience in debugging the issues.
• Proficient in working with UNIX shell scripts using AWK on UNIX using puTTY Environment.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• 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.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Application Data warehousing experience in Banking, Financial, Trading, Retail and Consumer.
• Extensive experience in testing of applications like GL Clear vision, Rolfe & Nolan and GMI.

TECHNICAL SKILLS

TESTING TOOLS: Test Director 7.6/8, Quality Center, QTP, WinRunner

SCRIPTING TOOLS: VBScript, Java Script, UNIX Shell Script

OS: Windows NT/2000/Windows XP, UNIX, Sun Solaris, Red Hat Linux

Reporting Tool: Business Objects 5.1 /6.1/XIR2, Cognos 7.3 Series, Crystal Reports

DATABASE: Oracle 9i/10G, MS Access 2003, SQL Server 2000/2005, MYSQL 4 and Sybase

ETL: Informatica 7.1/8.1, Data Stage 7.x, Ab Initio (GDE 1.14, CO >Op 2.14)

WEB SERVER: Tomcat, Apache, MS IIS 5.0/6.0, WebLogic 7.0

LANGUAGES: Java, C, C++, COBOL, SQL, PL/SQL, HTML, DHTML, XML, XSLT, Java Script

LANGUAGE UTILITY: MS Office 2007, Eclipse, MS Visual Studio .Net

BUG TRACKING TOOLS: Test Director 8.0, Quality Center 8.2

PROFESSIONAL EXPERIENCE

Confidential, Whippany, NJ

ETL QA Tester

Responsibilities:

• Created Test Plan and developed an test strategy for Day 2
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• 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.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports
• Created Jobs to Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the files.
• Modified the UNIX scripts for Testing purpose to check the Rollback mechanism, Restatement window logic, wrapper scripts etc.
• Involved in executing the UNIX shell scripts for loading the data from the Source to the Datamarts.
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• Published and Tested Impromptu reports to UpFront by using IWR Server.
• Published and Tested Powerplay Cubes to UpFront by using Powerplay Enterprise Server
• Prepared extensive set of validation test cases to verify the data
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Created 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.
• Tested stored procedures & views in MS SQL Server 2000/2005
• Tested OLAP Cubes by writing MDX.
• Extracted certain column of data from a number to files using PERL.
• Worked with PERL control structures & Regular Expressions for substitutions based on matches.
• Compared and Tested Source data with XML Output flow.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director)
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Performed the tests in both the SIT, QA and contingency/backup environments
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Writing the test scripts for manual testing.
• 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: SQL Server 2000/2005, SSIS, Oracle 9i/10g, XML, Flat Files, Cognos 7.3 Series, SQL, Stored Procedures, T-SQL, MS Excel, UNIX, Korn Shell Scripting, PERL& UNIX Shell Scripting Windows, Quality Center 8.2 and Test Director 8.0

Confidential, Seattle, WA

Sr.Quality /BI Analyst

Responsibilities:

• Writing the test scripts for Manual/Automation testing.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Executed UNIX Shell Scripts for Batch Job Execution.
• Written several UNIX scripts for running test loads for regression testing purpose.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• 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.
• 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 creating the design and technical specifications for the ETL process of the project.
• Prepared extensive set of validation test cases to verify the data
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• 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).
• 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
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Tested extensively on all the modules in XIr2 like Designer, Desktop Intelligence, Import Wizard, Publishing Wizard and Report Conversion Tool.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Tested Web I reports with more than 5 data providers and synchronized the data using the merge dimensions option.
• Extensively involved with backend testing by writing complex T-SQL queries.
• Tested Webi reports for various business needs.
• Tested Universes for various business needs.
• 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
• Involved in Front to Back testing for all European and Asia pacific and North Atlantic exchanges
• Preparing and supporting the QA and UAT test environments

Environment: Sybase 12.3, J2EE 1.4, Business Objects 6.x/XIR2, TIBCO, C, ETL Informatica 7.1, SQL Server 2000/2005, XML, XSD, XML Spy 2008, SQL, PL/SQL, Oracle 9i/10g, IBM AIX 5.1, UNIX, Korn Shell Scripting, Windows, Influx and Test Director 8

Confidential, Stamford, CT

Sr. ETL /QA Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Validated PDM to PDDM mapping document and PDDM to Report mapping document.
• Logged Defects and tracked them to closure using VSTF.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Written several UNIX scripts for invoking data reconciliation.
• Installed Unix from scratch and responsible for creating the test environment in Unix and Linux
• Used VSTF to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Automated the jobs using UNIX shell Scripts
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS excel,MS Access and Flat Files
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• AutoSys is used in automated job control system for scheduling, monitoring, and reporting
• Preparing and supporting the QA and UAT test environments.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Tested different detail, summary reports and on demand reports.
• Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process in a timely manner.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, PERL& UNIX Shell Scripting, HTML, Java Script, Oracle,Quick Test Pro 8.0, Quality Center 8.0, Points Portal, Autosys, MS Office Suite, Business Objects 6.x, Informatica IBM Mainframe, Rational Clear Quest, Clear Case, RUP, TOAD, Rational Tools: Requisite Pro, Clear Quest, Test Manager, Automation/Manual Testing.

Confidential, San Francisco, CA

Senior Quality Analyst

Responsibilities:

• Created Test Plans for various versions of Citi Line of Credit Reports applications from different BRQ Business Requirements created by the Project Management, and Business Line Teams.
• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB’s.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed 100% of the Test Cases in Test Director with Pass/Fail/Blocked status.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file clean up process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Used SQL for Querying the DB2 database in UNIX environment
• Extracted Data from Teradata using Informatica PowerCenter ETL, and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Performed database integrity check using SQL and Unix Shell Scripts
• Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics
• Used PERL for automating all the types of modules at a time.
• Extracted certain column of data from a number to files using PERL.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing
• Executed test cases for data validation, link verification, and content verification.
• Involved in backend testing with SQL, check the data integrity and referential integrity.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive (non-batch) mode which will write to the main test
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.

Environment: Informatica Power Center, Windows NT/XP/2000, Test Director, Clear Quest, MS Office Suite, IE, ASP, Crystal Reports, SQL, T-SQL

Confidential

Quality Analyst

Responsibilities:

• Performed Unit, Integration, functional, Load, performance, Regression testing.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Review the test cases and bug reports.
• Expertise in code reviews. Expertise in security issues of client/server technologies.

Environment: J2EE, JSP, PL/SQL, Oracle 8.x, Mysql 4.2.0, Linux RHEL 3.1, Python and QTP, Web Servers: Apache 1.3.3 and Tomcat 1.5.