Professional Summary:

• Over 7 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client-Server and Legacy Mainframe applications.
• Worked with IT Operations to ensure test environment readiness.
• 7 years of experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Data Stage and Ab Initio on multiple platforms.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experienced in co-ordinating resources within Onsite-Offshore model
• Expertise in testing mobile applications using Emulators and Real Devices.
• Experience testing Mobile web applications on IOS platform.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and validation of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Have knowledge on the web services.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Experience in Retail, Financial, Banking, Brokerage, and Securities industries.
• Experience with Agile, waterfall Methodologies.
• Experience in automation testing utilizing QTP, Load Runner, Win Runner and Rational Suite
• Extensively used ETL methodology for testing and 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.
• Experience in testing Business Intelligence reports generated by various BI Tools like MicroStrategy, Cognos and Business Objects
• Experience in testing the Universe business view of the database , and updating the existing Universes, developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Well versed in analyzing the XML files.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Strong ability to write and maintain extensive test strategies, plans, cases and scripts
• Strong Problem Analysis Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Experience in Installation and Implementing Mercury Interactive Test suite.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in testing XML files and validating the data loaded to staging tables.
• Good understanding of latest trends in Quality Assurance processes and methodologies.
• Good experience in Microstrategy, Cognos Business Objects Reports and dashboard testing.
• Excellent analytical, multi-tasking, problem-solving, time-management communication skills with particular emphasis on clearly communicating documenting detailed Test Requirements Tests

TECHNICAL SKILLS:

• Data Warehousing Datastage8.0,7.X/6.X Manager, Designer, Director, Administrator , Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1, SSIS, Data Stage 8.x
• Reporting Tools MicroStrategy 9.x, Hyperion Interactive Reporting 9.3, Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 Supervisor, Designer, Reporter , Web Intelligence
• Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin
• Testing Tools Win Runner, Load Runner, Test Director, Mercury Quality Center, HP ALM 11.0, Rational Clear Quest
• RDBMS Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0
• Programming UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL Plus, PL/SQL, TOAD, C
• Web Technologies JavaScript, HTML 4.0, and DHTML, Java, J2ee
• Environment UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0
• Devices Windows Mobile Device and Emulator , iPad

Confidential

ETL QA Tester

Roles Responsibilities:

• Developed PL/SQL packages for customer web based eContracts application.
• Created Tables, Custom views and Materialized Views used specifically for the application.
• Worked on Performance tuning to ensure reports and reporting environments are optimized to the fullest extent.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Wrote and modified Oracle PL/SQL procedures and functions that are called in the Java Scripts.
• Created database objects like stored procedures, function, packages, Cursor and Ref Cursors
• Performed Unit Testing and Prepared Application for Release to Testing Team. Analyzed defects found in testing and fixed Coding errors.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Excellent experience on SQL tuning.
• Prepared test environment for QA team to test the developed application from end-end.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan and Test strategy from the Business Requirements and Functional Specification for the integrations.
• Developed Test Cases for Deployment Verification, ETL Data Validation, and application testing.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Followed waterfall and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Functioned as the Onsite / Offshore coordinator for a team.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Created custom views to improve performance of the PL/SQL procedures.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data in Oracle Database.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• SQL Navigator is used to perform manual test in regular basis. Oracle is used in this project to write SQL queries.
• Wrote complex SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Writing the test scripts for manual testing.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Involved with ETL test data creation for all the ETL mapping rules.
• Preparing and supporting the QA and UAT test environments.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.1, PL/SQL Procedures, SQL, SQL Navigator 6.6, Toad 9.6.1, Oracle 10g, HP Quality Center 10, HP ALM 11.0, Java based web application, MS Excel, MS PowerPoint, Microsoft Share Point, Windows NT/XP//2003

Confidential

Sr. ETL BI QA Analyst EDW Team

Roles Responsibilities:

• Worked on the Mobile application testing Store Walk Mobile on Windows Mobile, iPad.
• Mobile Testing included Device and Emulator testing.
• Validated the data on the application against the source system Teradata.
• Determine level of testing required to validate new or revised system capabilities.
• Based on the design specification and business requirements developed the scope of the testing.
• Developed Test Plans and developed various test scenarios and test cases with input from assigned Business Analyst and data architect.
• Ensuring onsite to offshore transition, QA Processes and closure of problems issues
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing
• Report accurate testing status and test summary reports.
• Continuously improve test models, Test data and Test processes based on lessons learned.
• Coordinated component, System testing with appropriate technical groups and release management and documented testing procedures and findings.
• Extensive experience in Functional, system, Integration, Regression Testing, User Acceptance Testing.
• Reconciled test results from different tests and different group's accesses readiness and deviation of product/project performance based upon test results and product specifications.
• Loaded the data into the Teradata database using Load utilities like Fast Load, and Multi Load .
• Worked with data validations, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Involved in extensive DATA validation using SQL queries and back-end 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.
• Performed Black System testing, Regression and end-end testing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Developed detailed Test Plans and Test Cases in Quality center and executed them
• Reported bugs and tracked defects using Mercury Quality Center 9.2/10.0.
• Maintained the Traceability Matrix between Project release, Requirements, Design Components, Test Cases and Defects.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested the Oracle PL/SQL testing programs.
• Involved in automation of test cases using QTP.
• Worked on the batch testing using the Test batch runner tool.
• Validated various Reports, dashboards, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in Microstrategy.
• Validated the data in the reports and dashboards using SQL queries against the database.
• Worked with the development team in testing the Automation, Implementation, backout, backup and recovery plans.
• Participate in weekly meeting with the management team and walkthroughs

Environment: Microstrategy 9.0.2, SQL, PL/SQL,Teradata SQL Assistant 13.0 Informatica 8.6.1/8.1

, Quality Center 9.2/10, SQL Server 2008, Shell Scripting, Unix, Windows XP.

Confidential

Sr. ETL/Informatica Tester

Roles Responsibilities:

• Responsible for Business analysis and requirements gathering.
• 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.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Written several UNIX scripts for invoking data reconciliation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• 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.
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• 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.
• 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 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.1,PL/SQL, SQL, SQL Server Analytical Server, Quality Center,SQL Server Reporting Server, TOAD 9.2, Oracle SQL developer, Oracle 9.2, HP Quality Centre 9.2, DB Artisan 8.5.2, Autosys, Metal Meta Data Driven ETL , BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003

Confidential

Data Warehousing Tester

Roles Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• 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 and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2 Test Director
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Used various Functions like Prompt for user defined queries , Where For creating conditional filters , and Select.
• 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.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules

Environment: Quality Center 8.2, SQL, PL/SQL, Business Objects XIR2, Ab Initio CO>OP 2.14, AB INITIO GDE 1.14, EME, MainFrame Flat Files, COBOL II, ITG, Service center, UNIX, Oracle 10G, DB2, TOAD

Confidential

DWH/Backend Tester

Roles Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
• Written customized SQL queries for business needs.
• Did automation using PERL and UNIX Shell scripting.
• Reviewed system use cases and functional specs with business and System Analysts.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading ETL .
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos 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.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informix, DB2, Java, Cognos, SQL, Teradata V2R4 MLOAD, FLOAD, FAST EXPORT, BTEQ , XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, DTS, ERWIN, Windows XP