SUMMARY

• Over 7+ years of IT experience in Quality Assurance, Software Testing and Data Analysis of various business applications in Client/Server environments, Web - based applications, Data Warehousing solutions,ETLand Business Intelligence solutions.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Excellent knowledge on Agile Methodology.
• Experience working with Cognos Business Intelligence. (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Cognos Connection).
• Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
• Test Data Management (TDM) between multiple systems in Distributed Environment.
• Expertise in QA process and different levels of testing like unit, Functional, Regression, andData Integrationtesting with business scenarios.
• Worked on Business Intelligence tools likeCOGNOS, Business Objects.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage.
• Good working experience inOracle, Unix ShellScripting.
• Worked in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.

TECHNICAL SKILLS

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

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

Defect Tracking/Bug Tracking Tools: HP ALM, JIRA, TFS, Bugzilla

Scheduling Tools: Control-M, Autosys

Enterprise Software: SAPHANA, SAP BI, Crystal Reports

ETL Tools: Informatica 9.5/9.1/8.1/7.1.2/6.1. X (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Data masking, Data Integrator, Data Mining, OLAP, OLTP, Web Intelligence, Essbase Excel Add-in, DataStage, Ab Initio, SSIS

BI/Reporting Tools: Cognos, Business Objects, Crystal Reports, MicroStrategy, OBIEE, SSRS

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

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX, LINUX, Windows 7, 10.

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

Testing Tools: HP ALM/QC, Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

ETL QA Tester

Environment: Informatica 9.5.1, Cognos, HP ALM/Quality Center 11.5, Autosys, Agile, Teradata 13.0, DB2, SQL, PL/SQL, TOAD, Teradata SQL Assistant, XML, Oracle, UNIX, Shell Scripting, WINSQL

Responsibilities:

• 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.
• Wrote SQL and PL/SQL scripts to validate thedatabasesystems and for backenddatabase testing.
• Developed Test Cases for Deployment Verification,ETLData Validation, Cube Testing and Data Report testing inCognos.
• Tested ComplexETLmappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the extracted data from flat files and oracledatabase, and tested the applied business logic on the transformations.
• This project is about CustomerDataIntegrationCustomerDataIntegrationincludes the systems, processes and rules required to harmonize disparate customerdatainto a best version of the truth.
• Implemented Best Practices using ODI forDataIntegration.
• Designed Test Cases to monitor specificDataWarehouse setup for the Self-Direct Brokerage accounts.
• These accounts had additional filters on productdatawithin thedataminingtools that purposely controlled information viewed by the account.
• Maintain, improve and support currentETLanddataintegrationprocesses.
• CreatedETLtest data for allETLmapping rules to test the functionality of the Informatica Mappings.
• Extensively involved in testing the application developed inAgileMethodology and detailed designs.
• Extensively usedETLmethodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETLsolution usingETLtools like Informatica.
• PerformedDatabaseTesting to validatedatabaseusing TOAD, Checked Data Integrity and Constraints by SQL Queries.
• PerformETLrun throughAutosysjob and validated the run after it gets completed.
• Tested Daily, Monthly and Aggregate data reports fromCOGNOSas per business requirements to check data displayed in report matched with expected application data.
• Tested the adequate information gathering or not whenAutosysjob fails.
• Extraction of test data from tables and loading of data into SQL tables.
• Developed and Tested UNIX shell scripts as part of theETLprocess, automate the process of loading, pulling the data.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Tested theETLprocess for both before data validation and after data validation process.
• Tested the messages published byETLtool and data loaded into various databases.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Used Quality Center to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging of jobs.

Confidential, Atlanta, GA

ETL QA BI Tester

Environment: Informatica, MicroStrategy, Teradata, Agile, JIRA, SQL, SQL Server, XML, XSLT, XML Spy, UNIX, Shell Scripting, QTP

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Used Informatica Workflow Manager to schedule and run Informatica mappings and Workflow Monitor to monitorETLexecution and logs.
• Involved in testing all the reports that were generated through MicroStrategy.
• Tested MicroStrategy reports for Report layout, Attributes/Metrics, positions, Totals and Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters.
• Involved in testing MicroStrategy reports including conditional formatting testing and threshold testing.
• Created test data for testing specific Membership functionality.
• Executed SQL queries to perform backenddatabasetesting and verify/modify user data.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Report, track, reopen and close the bugs onJIRA.
• Creating/reporting defects inside client JIRA.
• Logged defects inJIRAand created the sub task for the work.
• Coordinated and managed testing activities as per theagilemethodology followed by project team members.
• Extraction of test data from tables and loading of data into SQL tables.
• Performed data validationtestingafter theETLprocess using Informatica.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.
• Validating the data passed to downstream systems.
• Responsible for checking data indatabaseby writing and executing SQL statements.
• Worked with data validation, constraints, source to target row counts.
• Wrote and ran Unix Scripts for batch jobs.
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access.
• Created macros to automate the process of refreshing the data in MS Access.
• Provided technical support and coaching to team members about functionality of MS Access.
• 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 Microsoft Excel and Word to document the test status reports and the Test Data.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Confidential, Chicago, IL

ETL/DWH QA Tester

Environment: Informatica Power Center, Agile, Teradata, Quality Center, MicroStrategy, UNIX Shell Scripting, Oracle, QTP, SQL *Loader, Oracle8i, SQL Server, Windows, TOAD, PL/SQL

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Enhancing the QTP Quick Test Pro Scripts with GUI checkpoints,DatabaseCheckpoints.
• Identified the test cases that needs to be automated using QTP.
• Involved in writing and executing script for regression and functional testing using QTP and HP ALM.
• Performed extensiveDatabaseTesting by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Performed Functional, Integration, Regression and System (End-End), and Back-End Integration Testing with back end OracleDatabaseusing SQL Queries.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed UAT testing.
• Extracted data from Teradata using Informatica Power CenterETLto load onto the targetdatabase.
• Used Teradata SQL to save queries to a file so they can be run automatically from the same file in the future.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Managed and executed the test process, usingAgileMethodology.
• Used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Tested both conditional formatting and threshold level testing for several reports developed in Microstrategy
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Creating test cases for ETL mappings and design documents for production support.
• Executed test cases for web-based MicroStrategy reporting application.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Confidential, Dallas, TX

ETL QA BI-Reports Tester

Environment: Informatica, Teradata, MicroStrategy, Quality Center, SQL, PL/SQL, DB2, UNIX Shell Scripting, Toad, Oracle, XML, Autosys, TSO, Windows

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Created Manual Test Suites for various modules.
• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document).
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used UNIX to verify the session log files for error and warning details.
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Compared query result sets from different database systems using UNIX diff command.
• 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.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Maintained the batch processes using Unix Shell Scripts.
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings, Generated the detailed reports.

Confidential

ETL Test Engineer

Environment: Informatica, Quality Center, Business Objects, Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director

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.
• Responsible for complete manual testing of application under test (UAT).
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Written complex SQL queries for data validation and to verify the extract rules.
• Performed black box/functional testing, regression testing on Application under Test.
• Performed manual testing on various modules of the Application.
• 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 effects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing for all ETL feeds.
• 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.