SUMMARY:

• Over 7 years of IT experience in Data warehousing and all aspects of Systems Development using Client/Server technologies that includes Requirements gathering, Analysis, Design and Development.
• Experience in testing Business Report developed in Business Objects XIR2 & Cognos 8.0 series.
• Experience in writing Excel Macros & Pivot Tables.
• Experience in writing UNIX Korn Shell Scripting for job scheduling and sequencing.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Expertise in creating Crystal Reports in Business Objects XI R2 querying the Metadata layers like Universes and Business Views for better presentation and formatting.
• 3 years of database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, TOAD, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views,, Inline Views, IBM DB2 UDB 9.0/8.0/7.0 & MS Access.
• Responsible for all activities related to the testing and support of ETL processes for large-scale data warehouses using several ETL tools.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files, VSAM Files, DAT files and XML.
• Well versed with Manual and Automated Testing methodologies and principles.
• Experienced in testing Cognos and Business Objects reports
• Configured test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Experienced and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Experience in using Mercury Test Director and Mercury Quality Center for gathering requirements, planning and scheduling tests, analyzing results, and generating defects and issues by generating reports.
• Good experience in communicating with offshore team
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Ability to manage multiple project in testing by managing team, automate process and delivered all tasks.
• Ability to develop complicated SQL script for Data validation testing by running SQL scripts and procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Proficient in SQL and PL/SQL coding.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules.

TECHNICAL SKILLS:

Testing Tools: Quality Center 10.0, Test Director 8.0/7.6/7.2, Win Runner 7.6/7.0/6.5, QTP 8.0/6.5/6.0, Load Runner 7.6/7.2, Rational Clear Quest, Rational Robot

Languages: Java, .NET, XML, HTML, SQL, TSL, Java Script, VB Script, PL/SQL

Hardware: HP-9000 Series, IBM Compatible PC Pentiums

Operating Systems: WindowsNT/2000/XP, UNIX, LINUX

Databases: MS Access, Teradata V2R6, SQL Server, Oracle, Sybase, Informix, DB2

ETL: Tools: Ab Initio (GDE 1.14, Co>OP 2.14), Informatica Power Center 7.1.3/8.6.1 , Datastage

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla

GUI Tools: Visual Basic 5.0/ 6.0, Crystal Reports 4.6/6.0

App/Web Servers: Apache, Tomcat, Web logic, Web spheres

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

ETL/BI Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Lead team of 5~6 people and co-ordinate offshore team of 12 people in INDIA.
• Managed multiple projects from different Line of Businesses.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed and approved database modifications
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database.
• Tested several reports developed using Business Objects.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Testing included unit, system testing, regression testing, Business Objects reports testing.
• Prepared the guides for UAT.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with business analysts, developers, and content department to resolve issues.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Informatica Power Center 8.1,, Business Objects XIR3, SQL, PL/SQL, Quick Test Pro 8.0, UNIX, Shell Scripts, Mercury Quality Center, SQL Assitant 6.0, MLOAD, FLOAD, TPUMP, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, CICS, Sybase, Oracle, SQL Plus, Access, SOAP, XML.

Confidential, Omaha, NE

ETL/BI QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Lead team of 6 people onsite and 4 people offshore.
• Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Used HP Quality Center to write test cases, analyzed the results, tracked the defects and generated the reports.
• Duties include database creation, administration, data mining, data conversion and report creation from multiple databases using Crystal Reports, Excel and Access
• Generated test data (on UNIX box using Perl scripts) to support development.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Extensively used Mercury Quality Center (Test Director) and created Test Cases in the Test Plan according to the specifications.
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on UNIX Shell wrapper scripts
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• 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.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: SQL, PL/SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, HP Quality Center,, Business Objects XIR2,, Flat Files, Copy Books, Crystal Reports, MVS, TSO, JCL, IMS DB/DC, ISPF, SQL *Loader, Oracle8i, SQL Server 2000/2005, Erwin 3.5/4.0

Confidential, Bloomington, IL

ETL/BI Tester

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.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Worked with ETL group for understating mappings for dimensions and facts.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• 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.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Involved in Functionality testing.
• Responsible for writing shell scripts (wrapper) to schedule the jobs in development environment.
• Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the DB2 database in UNIX environment.
• Tested several data validation graphs developed in Ab Initio environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Defect tracking is done in the Test Director 8.0 to add, review, repair and analyze defects.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Tested the reports developed by Cognos series and checked whether they are as per the company Standards
• Worked with the DW Architecture team in Testing complex Delta processing Loads.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Involved in creating both positive and negative test data to cover all business scenarios.
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.

Environment: Ab Initio (GDE 1.12, Co>OP 2.12), SQL, Cognos, TOAD, XML Files, Windows 2003/XP, Java, J2EE, JSP, Servlets, Oracle9i, TOAD, SQL/PL-SQL, Sun Solaris 9 (SunOS 5.9)

Confidential, Berkeley Heights, New Jersey

ETL Tester/SQL - Foreign Life Insurance & Retirement Data Mart

Responsibilities:

• Performed Data Analysis of existing data through SQL.
• Led & conducted JAD sessions to identify the flows and processes involved in the content.
• Prepared project reports for management and others. Assisted project managers in the development of weekly and monthly status reports.
• 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 Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL graphs 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 tables and loading of data into SQL tables.
• 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 cleanup process.
• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Created ETL test data for all ETL graphs based on transformation rules to test the functionality of the application.
• Created complex reports using business Objects Web Intelligence and worked on performance of the report by tuning complex SQL’s
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Business Reports.
• Tested several stored procedures.
• 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
• Used Test Director to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Worked on data quality, data organization and delivery.
• Organized cross training of team members and users to become more responsive.

Environment: Oracle 9i, Business Objects 6.5/XI R2, Ab Initio (GDE 1.13, Co>Op 2.13), Test Director, XML, XSLT, XSD, UNIX, Shell Scripting, IBM AIX 5.3, SQL, PL/SQL, MVS, COBOL II, JCL, ISPF, VSAM, Data Profiler, Teradata V2R5

Confidential, Groton, CT - EDWH

ETL to load the Exceptions Data Mart.

Responsibilities:

• Analyzed the Functional Specifications by interacting with business analysts and developers.
• Analyzing the Test Plan based on Business Requirements, which describes the testing scope, strategy,
• Test requirements and necessary resources.
• Involved in developing detailed test case s based on use cases for manual tests as well as automated tests.
• Involved in manual testing and automated testing using Test Director to develop test cases, test scripts, executing the scripts and logging the defects.
• Developed automated test scripts using Test Script Language (TSL) to perform Functional and Regression Testing.
• Created User Defined Functions to perform Data Driven Test.
• Involved in Functional, Regression, Performance and User Acceptance Testing (UAT).
• Parameterized the data using Data Driver Wizard for Test Script Reusability across various Test Modules.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Developed Test data requirements and data dependencies, and conditions for all test cases.
• Responsible in developing Test Cases with Test Director using it as a Test Management Tool.
• Extensively used SQL queries for Back-End Testing.
• Involved in Performance Testing using Load Runner.
• Involved in creating virtual users, Recording User Scripts using VuserGenerator (VuGen), inserting transaction points to calculate the Transaction response times and employed Rendezvous Points to simulate real world scenario.
• Extensively used Test Director for Test Planning, Bug tracking and Reporting.
• Provided a weekly project report that includes Test Metrics and status reports.
• Authored and executed Batch Tests in Win Runner and QTP to run a large group of tests in an unattended manner.
• Participated in meetings with developers to discuss enhancements and Modifications.

Environment: SQL, Informatica 6.1, WinRunner 7.5, Quick Test Pro 6.5, TestDirector 7.5, SQL, LoadRunner7.8, Windows 2003/XP, Java, J2EE, JSP, Servlets, Web Logic 8.1, IIS, MS SQL Server 2000, JavaScript, HTML, DHTML, TOAD, Oracle 9i, Sun Solaris.