SUMMARY

• Over 7 years of diverse experience in Information Technology with emphasis on Quality Assurance for the implementation of User/Business/Functional requirements to enable the product as a defect free product. Expertise in (Manual/Automation) Testing of Client/Server, ETL, Business Intelligence, Data Warehousing, Mainframe and Web based applications.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experienced in testing Cognos and Business Objects reports.
• 8 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Expertise in developing Software Test Plans, Test Case Design and Test Scripts based on User Requirements Specification (URS) and System Requirements documents.
• Proficient in writing SQL queries to perform data driven tests and involved in front - end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Represent QA in all phases of product development including requirement, Analysis, design, construction, testing, implementation, code reviews and support.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 8.0 Series and Business Objects XI R2
• Strong in writing UNIX shells scripting. Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in working as a liaison between the team members and the manager.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, and Ab Initio using Oracle, DB2, SQL Server and UNIX.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Worked with PERL for file manipulations
• Converted SQL queries results into PERL variable
• Experience with Mentoring and Coordinating a team of QA resources, Identifying and Managing Risks, Estimating Work, Resource sharing between the projects, tracking project progress, Delivering projects as per the deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica 8.5/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), EME, Data Profiler, SSIS, Ab Initio, (GDE 1.15, Co>Op 2.15), DATA STAGE 7.5.1

Mercury Interactive: QuickTestPro 9.5/9.2/8.0, WinRunner 9.2/9.0/8.0/7.5 , LoadRunner 9.2/9.0/8.0, TestDirector 9.0/8.0/7.5, Quality Center 10.0/9.0/8.2

IBM Rational Suite: Rational Performance Tester 8.0/7.0, Rational Clear Quest 7.1/7.0.1, Rational Clear Case 7.1/7.0.1/7.0.0

Bug Reporting: Rational Clear Quest, Test Director, Quality Center 9.2, MS Access 2008, Bug zilla

Programming Languages: SQL, PL/SQL, T-SQL, XML, XSLT, PERL, Shell Scripting

Operating Systems: Windows Vista/ XP/NT/2000, IBM AIX UNIX, LINUX, HP UNIX, Sun Solaris

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005/2008 , IBM DB2, Teradata V2R6, Sybase 12.3

Web Development: HTML, XML, VBScript, Java Script, VBA, XSD, XML Spy 2008

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

ETL/QA/Data Warehouse Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• 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 with iterative development environment using Agile Methodology.
• Did testing on ETL Informatica process for various data loading scenarios.
• Involved in developing the UNIX scripts for Informatica Workflows using parameter files and monitoring the workflows on testing environment.
• Did testing on multiple Informatica mapping for data validation and data conditioning.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Work with source system personnel on source data delivery issues and interacted with DBA for setting up test environment.
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• Validated Business Objects dashboard reports by writing several complex SQL queries based on reporting logic.
• Worked with PERL scripts for data parsing, text processing and connecting to database.
• Developed UNIX scripts and AUTOSYS scripts to load extract files in to staging tables using sqlldr.
• Executed SQL queries using TOAD to find useful test data to verify various functionalities of the application and also done the back-end verification.
• Tested PL/SQL Packages to transform/load the staging data into schema using business logic.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Attended Bi-Weekly Defect Review and Defect Status meeting. Provide update to management on testing status and some other issues.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Perform Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Did data validation on Teradata using Teradata SQL Assistant and BTEQ.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Worked with thin client and thick client (Business Objects XI R2).
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Understand business /transformation rules which are involved in developing the source to target mappings, write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries.
• Worked with all kinds of Teradata utilities including TPUMP, FLOAD, FEXPORT, and MLOAD & Teradata Assistant.

Environment: Informatica 8.1/7.5.2, Teradata V2R6, SQL Assistant, BTEQ, FLOAD, FEXPORT, MLOAD, SQL Assistant 6.0, SQL Server 2008, Agile, MVS, COBOL II, ISPF, VSAM, Copy Books, JCL, HP Quality Center 9.2, SQL/PLSQL,, Business Objects XIR2, XML, XSLT, XML Spy 2008, Korn Shell Scripts, UNIX, Windows XP

Confidential, Bloomfield, CT

ETL/SQL tester/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.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Managed and executed the test process, using Agile Methodology
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Responsible for monitoring data for porting to current versions.
• Analyzed and tested various Business reports for Hierarchies, KPI’s, Aggregation, Conditions and Filters developed in Business Objects
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Preparing Defect Reports and Test Summary Report documents.
• Checking the status of ETL jobs in UNIX and tailing the log files while the loading is under processing.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Worked on informatica to resolve production issues perform testing and debugging of mappings and reports.
• Conducted Performance testing under off load and peak load conditions.
• Lead test case review sessions
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• 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.
• 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.
• Worked on issues with migration from development to testing for different data loading jobs
• Extracted certain column of data from a number to files using PERL.
• Worked with iterative development environment using Agile Methodology.
• Validated cube and query data from the reporting system back to the source system.
• Used Rational Clear Case for version controlling
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Oracle 9i/10g, SQL, PL/SQL,, Agile, Business Objects XIR2, Quick Test Pro 8.0, VSAM, COBOL II, Copy Books, Quality Center 8.0, Business Objects 6.5.1, ETL Tools Informatica 8.6, IBM Mainframe, PERL, TOAD, Rational Performance Tester 7.0, Rational Clear Quest 7.0.1,Rational Clear Case 7.0, XML Files, XSD, XML Spy

Confidential, Wayne, PA

Data Warehousing Test Analyst

Responsibilities:

• Created Test Plans for various versions of Line of Credit Reports applications from different Business Requirements (BRQ) 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 LOBS’.
• Tested the stored procedures functionality vs. ETL mapping after the migration of code from PL/SQL to ETL mappings.
• 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.
• 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
• Executed 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, and User Acceptance Testing including GUI testing
• Executed test cases for data validation, link verification, and content verification.
• 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 7.1, Windows NT/XP/2000, XML, XSLT, XSD, Autosys, SQL Server 2000, Test Director, Clear Quest, MS Office Suite, SQL, PL/SQL, PERL

Confidential

Data Warehouse Analyst/Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes and compares results using Quality Center.
• Participating in the MR/CR review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Created and executed test cases for ETL jobs to upload master data to repository.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting