PROFESSIONAL SUMMARY

• 7+ years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server applications using Manual and Automated testing tools.
• 7 years of experience in writing SQL queries, PL/SQL programs to perform data driven tests and involved in front - end and back-end testing. Strong noledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• Worked extensively on Informatica7.1/8.1/8.5/8.6/8.6.1/9.2
• Involved in providing production support to various Informatica ETL jobs and Teradata Database programs.
• Worked extensively on Microstrategy and Cognos report and Dashboard testing
• Having good experience in onsite and offshore coordination.
• Worked on Data files & label parameter of data file, strong in writing UNIX Korn shell scripting.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration
• Expertise in creating/developing TEST CASES and developing TEST SCRIPTS.
• Experience in working as a liaison between the team members and the manager.
• IT industry experience in Banking, Financial, Software Services and Telecommunication industries wif strong Business and Functional noledge and Ability to evaluate ETL/BI specification, verify it wif systems and Experienced wif Master Data Management (MDM)
• Good Experience in Web Based Applications (VB.Net, ASP.Net, JAVA, J2EE).
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica using Oracle, DB2, Teradata, SQL Server and UNIX.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Familiar wif Informatica Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Comfortable in working wif fixed length, delimited flat files and also worked wif large volume of data in the database/data warehouse.
• Scheduling the jobs using Autosys GUI.
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Expert in analyzing the error caused to failure of the ETL load wif reference to the log file and report them to the corresponding team to get it rectified.
• Strong noledge of working wif Data Marts (Star Schema and Snowflake Schema)

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C and C++ Concepts, PERL, Test Script Language (TSL), CSS, HTML, VBScript, JavaScript, Shell Scripting

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access 2008, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

ETL Tools: Informatica7.1/8.1/8.5/8.6/8.6.1/9.2, SSIS, SSAS

Reporting Tools: Microstrategy 9.1, Cognos8,OBIEE 10.1.1.3

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Visual Studio 2010, MS Project, MS Visio & Visual Source Safe, Octopus

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. ETL/BI Tester

Responsibilities:

• Worked wif leading offshore and onsite environment.
• Ensure that the Informatica mappings are designed as per the business logic.
• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the Mapping documents and BRDs given by the business analysts and developed test cases using them.
• Worked wif the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current
• Identify the primary key (logical / physical) and put update or insert logic to test the referential integrity.
• Created test data in order to verify all the business conditions in the mapping documents
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Worked extensively wif the SCD dimensions in order to maintain the historical data, identify the flags for exception and history load
• Analyzed test results, generate test reports, file bugs and follow up on resolution wif development & support team.
• Used LSF to run the data load jobs
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica
• Interaction wif business and development to understand the business functionality
• Excellent experience in coordinating wif offshore and onsite model.
• Written Test Cases for ETL to compare Source and Target database systems
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Created ETL test data for all ETL mapping rules to test the functionality of Informatica mappings
• Written SQL scripts to test the mappings and tested Interactive Reports
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Tested Microstrategy reports and dashboards.
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Sending weekly reports to high level management regarding the status of test execution
• Giving deadlines and time lines for testing by using mapping documents.

Environment: SQL Server 2008, Oracle 10.2, UNIX, Windows XP, ETL Tools Informatica9.1,Microstrategy 9.1, TOAD, Quality Center 10, LSF, Interactive Reports, Java, JIRA.

Confidential, IL

Sr. ETL/BI Tester

Responsibilities:

• Supervising the QA team in accomplishing their tasks as per the deadlines.
• Ensured data integrity and verified all data modifications and calculations during database migration using Informatica.
• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked wif the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current
• Identify the primary key (logical / physical) and put update or insert logic to test the referential integrity.
• 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
• Analyzed test results, generate test reports, file bugs and follow up on resolution wif development & support team.
• Used OBIEE DAC to run the data load jobs
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica
• Interaction wif business and development to understand the business functionality
• Excellent experience in coordinating wif offshore and onsite model.
• Written Test Cases for ETL to compare Source and Target database systems
• Interacting wif 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
• Created ETL test data for all ETL mapping rules to test the functionality of Informatica mappings
• Written SQL scripts to test the mappings and tested Cognos Reports
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Sending weekly reports to high level management regarding the status of test execution
• Giving deadlines and time lines for testing by using mapping documents.

Environment: SQL Server 2008, Windows XP, Informatica 8.1, TOAD, UNIX Quality Center 10,OBIEE10.1.1.3, DAC.

Confidential, CA

ETL/BI Tester

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked wif the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Tested the ETL business logic for different feeds and checking the log files for data counts.
• Worked wif Quality Center for executing test cases and reporting defects
• Analyzed test results, generate test reports, file bugs and follow up on resolution wif development & support team.
• Used Informatica workflows to run the data load jobs
• Monitored the workflows using Informatica workflow monitor and performed end to end testing of Informatica data load jobs.
• Tested Informatica mapping wif respect to mapping document and tailed the log files
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the ETL applications
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Proven capability in testing Cognos List Reports, Cross Tabs, Master/Detail, Charts and user defined reports
• Ability to test multi-prompt reports wif drill-thru capabilities and conditional layouts
• Experience in writing easy steps to reproduce issues and report them to Bug tracking tool wif full information including logs
• Involved in UI Application testing

Environment: Cognos 8.4, Informatica7.1, UNIX, SQL, .NET, ASP.NET Windows XP, SQL Server 2008, ETL Tools, TOAD, VSTF 2008.

Confidential, PA

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Visual Studio 2010
• Created test data for testing specific Membership functionality
• Promoted SQL Server 2008 application releases from development to QA and to UAT environments as required
• Extracted certain column of data from a number to files using SQL Scripts
• Used DBSincera for automating all the types of modules at a time
• Involved in entire QA Life Cycle, which includes Designing, Developing, and Documentation of Test Plans, Test Cases and manage them using VSTF 2010 and providing them for Project team review
• Extraction of test data from tables and loading of data into SQL tables
• Written several complex SQL queries for validating MSRA Reports
• Responsible for Data mapping testing by writing complex SQL Queries using SQL Server Management Studio
• Involved in execution of unit testing, functionality testing, smoke testing, Regression and UAT testing
• Validating the data passed to downstream systems
• Worked wif data validation, constraints, source to target row counts
• Performed Smoke testing on the new builds as a part of Build Acceptance Testing
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access
• Worked wif Data Extraction, Transformation and Loading (ETL)
• Experience in writing easy steps to reproduce issues and report them to Bug tracking tool wif full information including logs.
• Involved in testing the UI applications
• Worked wif business team to test the reports developed in MSRA
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
• Used VSTF 2010 to track and report system defects

Environment: SQL Server 2008, Windows 2008, .Net, Visual Studio Team Server 2010, SSIS,SSAS,SSRS, T-SQL, SQL, Microsoft Visio 2007, MS Access, Flat Files, Dbsincera, Onyx, Octopus, Metal, MSRA Reports.

Confidential

ETL Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Participate in Requirement Development, Automation test script code reviews, MIS configuration and change control, and Go/No-Go decisions.
• Created and configured the GUI maps for the standard and custom objects.
• Tested ETL jobs developed in Informatica environment and Worked wif work flow monitor for monitoring the job status.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Tested SCD Type II and history tables.
• Scheduling the jobs for transferring the data from OLTP system to OLAP using Autosys GUI.
• Worked extensively in scheduling the Autosys jobs.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved wif 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, analyze and compare results using Quality Center.
• Tested several complex reports generated by Congo’s including summary reports, Master detailed, Drill Down reports.
• Defined the Scope for System and Integration Testing
• Identifying field and data defects wif required information in Abinitio ETL process in various jobs and one to one mapping.
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• Worked Extensively wif SSIS to import, export and transform the data between the linked servers
• Written Several SQL Queries for validating Congo’s Reports.
• Worked and coordinated wif business people in testing Reports.
• 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 wif the dependencies
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Identified & presented effort estimations related to testing efforts to Project Management Team
• Responsible for identifying and defining the Key Performance Indicators in Fact tables.
• 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 wif 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.
• Sending package install requests for new builds and verifying proper packages are installed.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined wifin the application wif metadata.

Environment: SQL,, T-SQL, Cognos 7, XML, VSAM Files, SQL Server 2005, Quality Center 9.0, Oracle 10g, Java, Unix AIX 5.2,Autosys,data stage.

Confidential

BI Test Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked wif the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Tested the ETL business logic for different feeds and checking the log files for data counts.
• Worked wif Quality Center for executing test cases and reporting defects
• Analyzed test results, generate test reports, file bugs and follow up on resolution wif development & support team.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• Used Informatica PowerCenter work flow manager to run the data load jobs
• Monitored the workflows using Informatica workflow monitor and performed end to end testing of Informatica data load jobs.
• Tested Informatica mapping wif respect to mapping document and tailed the log files
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the ETL applications
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written complex SQL queries for data validation and data verification.
• Executes the test suite to identify regressions and unexpected side TEMPeffects
• Parameterizes test cases for use wif varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: Informatica 6.1, Windows NT, HTML, .NET, ASP.NET, MS-Office Tools, PERL, Shell Scripting, SQL, PL/SQL, XML, XSLT, IBM DB2, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script