SUMMARY

• 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 Confidential defect free product. Expertise in (Manual/Automation) Testing of Client/Server, ETL, Business Intelligence, Mainframe and Web based applications.
• 7+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
• Play Confidential lead role / coordinator in developing, and executing test plans, test cases, and test scripts for wide variety of systems such as (Telecom, Health Financial, Mortgage, e - commerce, client/server, interfaces, in bound, and out bound of the Firewalls, system security).
• Experience using query tools for Teradata, Oracle, IBM DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Strong experience in Banking, Financial, HealthCare, Insurance, and Manufacturing domains.
• Experienced in mentor, coordinate and lead team members.
• Extensive knowledge in Performance Test Life Cycle.
• Involved in Performance tuning of database Servers
• Extensive experience in MANUAL and AUTOMATED testing using automation testing tools, Test Management Tools (Mercury Quality Center, Test Director, Clear Quest) and Functional testing tools (Quick Test Professional, Win Runner, Rational Robot, Silk Test) and Performance testing tools (Performance Center, Load Runner).
• Represent QA in all phases of product development including requirement, Analysis, design, construction, testing, implementation, code reviews and support.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• 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.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in Confidential corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, 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 Confidential liaison between the team members and the manager.
• 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 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 Confidential 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.1/7.1.2/6.1. X (Repository Manager, Designer, WorkflowManager, and Workflow Monitor),Parallel Extender, Data Mining,), EME, Data Profiler, SSIS, Ab Initio, (GDE 1.14, Co>Op 2.14)Test Mgmt Tools Test Director, HP Quality Center, Rational Quality Manager

Mercury Interactive: QuickTestPro9.5/9.2/8.0, WinRunner 9.2/9.0/8.0/7.5 , LoadRunner9.2/9.0/8.0, TestDirector9.0/8.0/7.5, Quality Center9.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,, MS Access, Bug zilla.

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

Operating Systems: Windows Vista/ XP/NT/2000, AIX UNIX, LINUX

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

Web Development: HTML, XML, VBScript, Java Script, XSLT

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Sr Data Quality Test analyst

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Worked with leadership team to analyze current SDLC process and recommended process improvements
• Worked with SSIS system variable, passing variables between packages.
• Used T-SQL for Querying the SQL Server2010 database and data conditioning.
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Tested the reports like DrillDown, DrillUp and Pivot reports generated from OBIEE
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Worked in Sales Forecasting and Vehicle Ordering projects using SAS and Macros
• Tested the correct data transition from information source systems into data warehouse target tables, using SQL and SAS (UNIX env.).
• Validating the data against staging tables and warehouse
• Responsible for ETL batch jobs execution using IBM Tivoli application to load data from core database(i.e. ETM database) to Staging and Data mart tables
• Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata SQL to transfer, cleanup Confidential summarize data
• Written Complicated SQL queries in IBM DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Provided the Defect Management Cycle session to team members while working in HP ALM (Quality Center)
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Worked on Tivoli to run scheduled and Ad hoc batches to perform online activities.
• Perform system testing to ensure the validity of the Report requirements and migration of risks prior to formal acceptance.
• Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing).
• Executing and monitoring jobs through Control-M.
• Performed Interface and Integration (SIT) Testing
• Developed QTP Scripts to automate the reusability and regression functionality. Developed reusable functions and reusable actions in QTP
• Extensively used SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Work closely with the software engineers to ensure successful, high quality releases.
• Working with Tivoli job scheduler for submitting the jobs and monitoring the jobs
• Preparing the SQL queries to fetch the data from databases.
• Worked with job scheduler tool Tivoli for running the ETL batch jobs and monitoring the batch jobs
• Knowledge on Data validation, Data merging, Data cleansing and Data aggregation activities
• Execute theETLjobs sessions and workflows
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
• Experience with Data profiling, Data Validation and Data Integrity andData Cleansing and ETL processes using Informatica
• Extensively used test management tools like Quality Center, and QTP to carry out test case documentation, execution, and defect logging
• Perform User Acceptance Testing with UAT test scenarios.
• Prepare the SQL queries to fetch the data from databases.

Environment: Informatica 9.1, Informatica Power Center, Oracle, SQL Developer, SQL Server 2010, SSIS, T-SQL, .Net 4.0, ASP.net 4.0, OBIEE 11g, Web Methods and Web Services, Control-M, Load Runner/Performance Center,, SAS/ACCESS, SAS/ETS, SAS/ODS and SAS/SQL, UNIX, C, C#, Teradata V2R6, HP ALM Quality Center 10.0, QTP 10.0, Autosys, Tivoli, SQL, PL/SQL, SOUPUI

Confidential, Pittsburgh, PA

Sr. ETLSQL Data Quality Test Analyst

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Lead responsibility for QA automation planning, design and manage scripts
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Wrote MACROS in Teradata to generate less channel traffic and easy execution of frequently us
• SQL operations and improves the performance.
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment.
• Responsible for developing test scenario, test suite, test plan and test cases for Performance Testing using Loadrunner and Performance Center.
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Create custom built reports from the Control-M batch server
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• 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.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• 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).
• Used SQL for Querying the UDB DB2 database in UNIX environment
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD
• Involved in Database tuning to enhance the application performance.
• 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..

Environment: Informatica 8.1/7.1,Parallel Extender, Data Mining, OLTP, OLAP IBM DB2, SQL Assistant, Teradata V2R6, OBIEE 10.1.3, TOAD, C, C#, LoadRunner/Performance Center, .Net, ASP.Net, T-SQL, Teradata SQL Assistant 6.0, MLOAD, SQL Assistant 6.0, SQL Server 2008, SSIS, MVS, Autosys, COBOL II, ISPF, VSAM, Copy Books, JCL, HP ALM Quality Center 9.2, QTP 9.2, SQL/PLSQL, XML, XSLT, XML Spy 2008, Korn Shell Scripts, UNIX, Windows XP

Confidential, Pittsburgh, KS

Sr. SQL Data Quality Test Analyst - Credit Risk Data Warehouse

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Worked as Lead with the functional team to analyze the business requirements for preparing the test plan and test cases.
• Worked as Confidential lead to resolve issues during critical phase of projects and guide junior testers and even played the role of Confidential mentor whenever required
• 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.
• 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.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Involved in small projects and produced sample reports using SAS and Easytrieve
• Creation and execution of test cases on Oracle Reports and OBIEE.
• Running reports for the executives on the Orders history and mile stones using OBIEE.
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Loaded the data into the Teradata database using Load utilities like (Fast Export, FastLoad and MultiLoad).
• Generate Analyze data and create reports using SAS
• Played Confidential significant role of QA testing at various stages of the project including Data
• 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.
• Interacted with Business Analyst, Database Administrators, development team and End Users. Performed Load and Performance testing using Rational Performance Tester.
• Conducted Stress testing using Rational Performance Test.
• 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.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• 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.
• Extracted certain column of data from Confidential number to files using PERL.
• 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.

Environment: Oracle 9i/10g, SQL, SQL Server 2008, SSIS, PL/SQL, T-SQL, Quick Test Pro 8.0, VSAM, COBOL II, Copy Books, OBIEE 10.1.3, Quality Center 9.0, QTP 9.0, C, C#, Ab Initio (GDE 1.14, Co>Op 2.14), Autosys, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, Teradata V2R6 (MLOAD, FLOAD, IBM Mainframe, TOAD, Rational Performance Tester 7.0, Rational Clear Quest 7.0.1.

Confidential, Springfield, Illinois

Sr. ETL/SQL QA Back end Test Analyst

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan, and the Business Requirements documents.
• Lead and Analyzed Business requirements, Develop test plan and test cases for manual and automated testing of the application
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS’.
• Extensively tested several OBIEE reports for data quality
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Performed front-end testing on OBIEE Executive Dashboard portal
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Creating appropriate SAS programs for data extraction and analysis
• Using SQL and SAS macro programming to respond to requests for data
• Tested all OBIEE Dashboards according to the requirement
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• 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
• Executed SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• 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.
• Create DataStage Parallel Jobs to extract, transformation and loading of the data using DataStage design toll in the parallel processing mode.
• Worked on DataStage Version Control Tool for Migrating jobs from one environment to another environment.
• 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
• Designed Test Case documents for Performance testing in Quality Center and report defects.
• 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: Data Stage 8.0/7.X/6.X,Windows NT/XP/2000, XML, XSLT, XSD, Autosys, SQL Server 2005, SSIS, OBIEE 7.3,, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETS, Quality Center 9.0, QTP 9.0, Test Director, Clear Quest, MS Office Suite, SQL,PER

Confidential ; Minneapolis, MN

ETL/SQL Test Engineer

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
• 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, XML, XML Spy, QTP 8.2, Quality Center 8.0, Load Runner7.0, Cognos, Oracle 10g, Unix AIX 5.2.

Confidential

Backend/Performance Tester

Responsibilities:

• Writing test plans and test scripts
• Written complex SQL queries.
• Performed testing in mainframe environment
• Tagging the Testable and Non Testable requirements in FSS
• Updating the tagging process for new versions of FSS
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back - end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Heavily involved in interacting with UNIX Shell scripts.

Environment: Windows NT/2000, SQL, PL/SQL, UNIX, Manual Testing, XML, PERL, .Net, DB2, ASP.Net, Test Director 9.0/8.0 & Win SQL.