SUMMARY

• 7+ years of IT experience in Quality Assurance for ETL, BI, Web based, Client/Server applications using Manual and Automated testing tools.
• 6 years of experience in Data Warehouse applications testing using Informatica Power Center and Ab Initio on multiple platforms.
• Wrote extensive SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Expert in Oracle database testing.
• Have the ability to evaluate an ETL/BI specification, verify it with Systems experts and data architects, and assess if it complete and fully understand EDW and ETL Architecture.
• Experience in Business Intelligence in generating various reports using Cognos and Business Objects
• Strong knowledge of test methodologies: Object Oriented test methodology, Service Oriented Architecture, Top to bottom and Bottom to top test methodology, QA Validations & QA Compliances to ensure the Quality Assurance Control.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL
• Expert in writing PERL & UNIX Shell scripting for various needs including text processing, data archiving, data parsing and database connectivity.
• Experience in testing XML files and validating the data loaded to staging tables.
• Used Test Director, Quality Center and Business Process Testing for management of test plan, test design, test execution and defect log phase. Rational Quality Manager for management of STLC including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Extensive experience working with ETL tools like Datastage, Informatica, Ab initio, SSIS and Autosys tools.
• Experience in IBM Rational Suite for maintaining test requirements, test flows using Requisite Pro, automate tests using Rational Robot and Rational Functional Tester, Rational Manager, Defect tracking using Rational Clear Quest, version control using Rational Clear Case.
• Efficiently performed Defect Tracking using various tools like Quality Center, Test Director, Rational Clear Quest, Remedy Tool, PVCS Tracker, and Bugzilla.
• Experienced with ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• 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. Having good knowledge on Oracle Data Integrator. Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.

TECHNICAL SKILLS

Data Warehouse Tools: Informatica 8.6/8.1/7.x, Ab Initio (GDE1.15, Co>Op 2.15), Data Stage

BI Tools: Cognos 8.0 Series, Business Objects XIR3/XIR2

Database: Oracle 10.2/9i/8i, Sybase12.5, SQL Server 2005/2008, IBM DB2, Teradata

Change Mgt Tools: Test Director 8.0, Quality Center 10/9.2/8.2, Rational Clear Quest

Functional Test Tools: WinRunner 7.0, Quick Test Pro (QTP), Load Runner 8.0

Languages: PL/SQL, T-SQL, SQL, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest 7.1, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, BugZilla, JIRA, XML Spy

Version Control: Synergex PVCS Tracker, Rational Clear Case 7.1/7.0.1/7.0.0, Visual Source Safe 2005, Control Version System CVS

Scripting languages: TSL, SQA basic, Java script, VB Script, HTML, XML, XSLT, PERLShell Scripting

Web Technologies: XML, HTML, JavaScript, VBScript

MS Suite: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr ETL/QA Tester

Responsibilities:

• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Worked with AutoSys for orchestration of files
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Tested all the backend programs, Informatica Mappings and update processes.
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc
• Reviewed Informatics 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.
• Trained and coordinated with the offshore team members in understanding the requirements and test cases for UAT.
• Tested several data validation graphs developed in Ab Initio environment.
• Created Test Cases in Quality Center, executed Test Cases, and reported defects.
• Tested several Informatica Mappings to validate the business conditions
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• The reports that were created in Business Objects were testing by running the SQL statements
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Reviewed the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Experienced in writing UNIX script.
• Tested Operation Data Store process of ODS/DWL product
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Designs, test scripts, for data driven test for Web- based pricing and underwriting system
• Involved in deployment of programs using web logic server
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on AutoSys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.6.1, Business Objects XIR3, SQL, PL/SQL, Teradata, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2, Oracle 9.2, HP Quality Center, Rational Suite, IBM ODS/DWL, DBArtisan 8.5.2, AutoSys, MQ’s

Confidential, Reston, VA

ETL/SQL/BI Test Analyst

Responsibilities:

• Written complex SQL queries for Credit Rating System and Risk Rating System and validated the ETL Conditions.
• Managed multiple projects for EDWH Group for all testing activities related to both ETL and BI
• Involved in rebuild testing of the BI Reports from Cognos to Business Objects Reports and written extensive SQL for comparing the records against source data.
• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Created and maintained test reports, identified bugs and reported findings using Quality Center
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations and Ensured that the mappings are correct
• Conducted data validation testing and extracted certain column of data from a number to files using PERL.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Tested several data validation graphs developed in Ab Initio environment.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• A given test case will be a ‘Pass’ if the EDW results (expected value) match exactly with EDM (actual value).
• 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.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Used PERL for automating all the types of modules at a time and Worked with PERL control structures & Regular Expressions for substitutions based on matches.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Written UNIX Shell scripts for cleanup, error logging, text parsing, job scheduling and job sequencing.
• Tested data feeds from XML to Database.
• Validated the XML data.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in quality center
• Load new or modified data into back-end Oracle database.
• Involved in testing procedures, functions, packages and triggers as a part of backend testing using Toad.
• Identified and recommended training required to the testing effort
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts

Environment: Teradata V2R6, SQL Assistant 6.0, TOAD, Win SQL, Windows XP, Quality Center 9.2, Oracle 10G, SQL Server 2005/2008, SQL, PL/SQL, Informatica 8.1, XML, XSLT, XSD, XML Spy 2008, PERL, Shell Scripting, TOAD, UNIX, IBM ODS/DWL, VB Script, VSAM Files, COBOL II, JCL, File-Aid

Confidential, San Francisco, CA

ETL/BI Tester

Responsibilities:

• Analyzing new Business requirements for each & every release and worked with analysts and business team for any gaps found during the test analysis
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Incremental development/testing of Enterprise Data Warehouse.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Debugging and Scheduling Informatica Jobs/Informatica Mappings and monitoring error logs.
• 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 Hyperion reports for Hierarchies, Aggregation, Conditions and Filters.
• 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 ie 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.
• Involved in writing and implementation of the test plan and developed test cases and Test scripts in Quality Center.
• Tested several Informatica mappings and ran for test data loading.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Preparing Defect Reports and Test Summary Report documents.
• Checking the status of ETL jobs in UNIX.
• Interacted with Business Analyst, Database Administrators, development team and End Users.
• Preparing Test plan, Test scenarios and writing & execution of Test cases
• Identified Test Conditions in according to the BRD’s and Change Requests
• Written and Executed the UNIX test cases on EDI format and verify Translation response
• Performed Reliability testing for testing the UNIX servers
• Responsible for execution of Batch jobs and population test data for other teams
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Responsible for FTP jobs to transfer data between UNIX test servers.
• Responsible for Production Monitoring during peak hours
• Regression Testing for Each and Every Release Using Win Runner
• Used Quality Center & Rational DDTS as Test Management tool.
• Responsible for doing System Testing, Functional Testing, Integration Testing, Load Testing and Smoke Testing.
• Extensively worked on Backend using SQL Queries to validate the data in the database.
• Testing the XML’s for the all the validations like request and response.
• Used Rational Clear Case for version controlling

Environment: Informatica 6.,5.1, Oracle 10g, Unix Shell Scripting, SQL, PL/SQL, XML, XSLT, XSD, Teradata V2R5, IBM DB2, Flat Files, Quality Center, VSAM, COBOL II, MVS, JCL, Copy Books, Rational Clear Quest, Clear Case, Autosys

Confidential, MI 

ETL/BI Tester

Responsibilities:

• Validated that the design specifications meet the requirements and data flow.
• Written test cases developed the validation steps and reviewed them with test team lead.
• Developed test scripts using SQL and PL/SQL according to the mappings and rules specified in mapping document.
• Reviewed test cases, validation steps and test scripts with business users and team lead.
• Used Microsoft Excel to test small amount of data imported from different database management systems.
• Used Access database to import connections from different databases systems and validate the test cases.
• Attended Daily Status Call with Manger, Development Team and QA Team to discuss the project updates.
• Documented test cases, test scripts and test results in Microsoft Excel.
• Responsible for keeping up with the test schedule and interacting with software engineers to ensure clear communications on requirements and defect reports.
• Conducted performance testing of the application using Load Runner
• Performed process based testing of the applications
• Executed manual and automated testing of J2EE-based applications running on BEA Weblogic servers.
• Provided test cases for java environment J2EE, JUnit, JBuilder and SOA applications for Web based client server.
• Analyzed, reported and kept track of defects using Test Director.
• Submission of test results, weekly status reports and test summaries to the QA lead and project manager
• Conducted Training Sessions and Knowledge Transfer Sessions to develop skill sets of team members

Environment: SQL, ETL, MS Access, Windows, J2EE, JUnit, JBuilder, WinRunner 7.5, Test Director 7.5, Load Runner 6.0, PL/SQL, ASP, and XML/DHTML.