SUMMARY

• 8+ years of extensive experience as a Quality Assurance Engineer/Business Analyst involving in the entire SDLC and working with DWH ETL/BI applications.
• Extensive experience in the Information Technology industry, involving analysis, ETL and BI testing of DWH applications and reporting.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Coordinate the testing efforts for: QAT, SIT, UAT, Regression, Smoke, Integration, Migration, Performance, Stress and Data Driven
• Well experienced in writing complex SQL queries for extracting data from multiple tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Technical strengths and automated test tool expertise includes Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
• Hands on expertise in Data ware housing concepts and tools.
• Extensive experience working with ETL tools like DataStage, Informatica, AbInitio, SSIS, SSRS and AutoSys tools.
• Good experience in Cognos & Business Objects Reports testing.
• Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking
• Defined and Implemented Processes and Procedures for QA Departments
• Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels

TECHNICAL SKILLS

Databases: MS Access, DB2, SQL server, Oracle, Teradata V2R6

Data Warehouse Tools: Ab Initio, Informatica 9.1,8.1/7.1, SSIS, MS DTS Packages

BI Tools: Cognos 8, Business Objects XIR3, Crystal Reports, OBIEE

Languages: C, C++, Java, PHP, HTML, XML

Operating Systems: MS Windows 2000/XP/Vista/7, Sun Solaris2.8, Mac OS X, Unix

Requirement Mgmt Tools: IBM-Rational RequisitePro, Rational ClearCase, HP Quality Center, QTP

Project Mgmt Tools: MS Excel, MS Word, MS Project, MS Outlook, MS SharePoint, Lotus Notes

Business Modeling Tools: OOAD, MS Visio, Rational Rose, UAT

Defect Reporting Tools: Rational ClearQuest, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

QA ETL Tester

Responsibilities:

• Setup for each version Execution- on the Kanban Board for MIT and S2S Execution (Backlog, Ready, In-Progress Request, In-Progress Response, Complete and Accepted).
• Designed the test cases ALM for Calendar Execution for ARM, FRM & Conversion pools to be sent according to the Use Case Scenarios planned for four Sprints.
• Attended the Sprint Planning Meeting for understanding this sprint Focus.
• ECF files from Upstream Application. Generating MISMO standard file as described by ‘Uniform Mortgage Data Program Initiative’ from ECF file for respective Interface.
• In Case of Exception Received find out the root cause and logging the Defect in I-CART.
• Discussing the Defect in Internal-DRB meeting, E2E meeting and with CSP Team for Addressing Defects, which are resolved, closed, and Deferred to next Sprint.
• Sending FNMA-MISMO files and Receiving Responses from CSS for various Interfaces.
• Uploading the Database tables, from where the MISMO standard XML file picks the Loans from.
• Generating Reports from ALM, I-CART Defects and Daily FNMA-CSS Dashboard Reports.
• Keeping track of In-scope and De-scoped Scenarios through Execution Calendar and Updating in ALM.
• Defect triaging meeting with E2E and CSP Teams. Defect Triage- Referred to ISM specification, Requirements from Doors, XML schemas validation for files formation according to Interface to find out the root cause.
• Referred to Test Plan, Use Cases-Scenarios, and Execution Calendar for finding defect in our Internal Document for unspecified behavior which have been encountered.
• Reviewing the previous 4 sprints in the Sprint Review Meeting.
• Coordinating with cross functional backend teams for Dependencies.
• Executing Java script from eclipse for taking the file from WINSCP in-archive and out-archive and uploading to SharePoint, validating and executing ALM.
• Defect triaging with Internal Application and CSP side for time constraints on Response generation and Error in Reports.
• Tested/Validated several XML Documents using XML Spy and generated XSD’s for corresponding XML documents.

Environment: ETL Informatica, Abinitio, SQL, PL/SQL, Oracle 10g, Autosys, XML Spy 2015, UAT, IBM ClearCase, IBM Clearquest, Doors, ALM 11.25, Unified Functional Testing, Eclipse, TOAD, UNIX

Confidential, Moline, IL

IT/ETL QA Analyst

Responsibilities:

• Involved in all phases of project starting from planning phase and contributed towards project scheduling and implementations.
• Involved in detailed analysis of business requirements and produced requirement artifacts.
• Collaborated with business and applications team in designing ETL solutions to meet the business requirements.
• Participated in Daily Scrum Meeting, Retro Meetings, PSI and Sprint Planning Meetings and giving Updates.
• Prepared Unit test cases executed them and documented the test results. Managed defect tracking log and resolved defects arising during UAT phase.
• Automation testing using Cucumber and DVO tool for Validation purpose on mapping per Business Rules and planning data for boundary analysis on each field.
• Experience using multiple RDBMS and flat file sources (UDB, Oracle, fixed-width files). Imported the source & target definitions in a shared folder and leveraged short cuts in various mappings and folders.
• Performed testing on data migration enforcement task by utilizing existing scripts and processes.
• Understand complex mappings using various transformations (Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations) to meet the ETL design specifications.
• Utilized mapping parameters and variables wherever possible for reusability and ease of enhancements.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like email, decision, command and pre/post SQL.
• Prepared command line programs using PMCMD for execution & automating of scheduling via esp. mainframe.
• Project had User interface via SQL queries or tools such as Business Objects and Tableau.
• Testing was on for machine readings - was working in an actual analytic environment.
• Dealt with big data - DB2 and Natezza databases using Toad and Aginity respectively.

Environment: ETL Informatica 9.1, Tableau, Sybase, BI Business Objects XR3.1, SQL, Teradata, IBM DB2, Natezza, Oracle, UNIX, UAT, Informatica DVO, Cucumber, Eclipse, SQL Server 2008, ESP Mainframe.

Confidential, Richmond, VA

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Participated in reporting summary documents reviews.
• Tested all the backend programs, Informatica Mappings and update processes.
• Assisted in generating post deployment scripts and UAT scripts for users.
• Reviewed manual test cases and determined which set of test cases suited an automation framework in QTP
• Verified the maintained- existing data migration program with upgrade and enhancements.
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI
• Managed and executed the test process, using Agile Methodology.
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Business Objects Reports.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Used SQL for Querying the Teradata database in UNIX environment
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Provided the Test status to the Tech lead, Project lead and the team mates.
• Effectively communicated testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested data from various sources like Oracle, flat files and SQL Server.

Environment: ETL Informatica 9.1, BI Business Objects XR3.1, SQL, PL/SQL, Teradata, IBM DB2, Oracle, XML Files, UNIX, CSV, UAT, VSAM Files, SQL Server 2008, Quality Center 10.0, QTP 10, MDM, PERL.

Confidential, Atlanta, GA

ETL Tester

Responsibilities:

• Did data profiling for multiple compliance feeds.
• Scheduled and managed QA/UAT execution activities and defined, wrote and prepared QA/UAT Test Strategy, Test Plan and Test Scripts.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Maintained Test Logs, Test Summary reports and participated in defect review meetings.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Made Change Requests for failed test cases and assigned them to responsible developers
• Developed complex SQL scripts/queries for data verification to compare the expected results with database and analyzed the data and the calculations in the mapping for its correctness.
• Executed campaign based on customer requirements and followed company code standardization rule
• Involved in creation of defect analysis report for system Test and UAT.
• Extensively used QTP to create tests, insert checkpoints, parameters, output values, use regular expressions, work with actions, and handled unexpected events that occur during a test run
• Responsible for different Data mapping activities from Source systems to Teradata
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Did lot of ETL testing based on ETL mapping document for data movement from source to target.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Performed extensive data validations against Data Warehouse
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
• Loading Flat file Data into Teradata tables using UNIX Shell scripts.
• Worked with non-transactional data entities for multiple feeds of reference data using MDM
• Tested several Informatica Mappings to validate the business conditions.
• Preventing occurrences of multiple runs by flagging processed dates
• Written Test Cases for ETL to compare Source and Target database systems.

Environment: ETL, BI Business Objects, SSIS, SQL, PL/SQL, Excel Pivot, Oracle, Teradata, Mainframe, VSAM Files, Copy Books, Teradata, MDM, DB2 UDB, WinSQL, UNIX, UAT, Quality Center, QTP

Confidential, Atlanta, GA

ETL Tester

Responsibilities:

• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Conducted manual testing, compared actual and expected results and logged defects using the defect tracking tool Quality Center.
• Automated and scheduled the Informatica Mappings using UNIX Shell Scripting
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in gathering and analyzing the user requirements in coordination with Business.
• Worked with business team to test the reports developed in Business Objects
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Worked with XML transactions for multiple feeds.
• Used parameterization and used checkpoints like text, standard, table, database and Image and Accessibility checkpoint in QTP
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load, update Processes and Batch processes.
• Tested whether the reports developed in Business Objects are as per company standards.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Used Quality center as the defect-tracking tool to enter defects regarding the issues found during testing
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Performed performance tuning by optimizing Target, Source, Mapping and Session.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Written test scripts to compare OLTP vs OLAP for ETL testing
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

Environment: ETL Informatica, SQL, PL/SQL, Oracle 10g, XML, XSLT, XML Spy 2008, UAT, Shell Scripting, Quality Center, QTP, BI Business Objects, Oracle 9i, UNIX.

Confidential, Marietta, GA

ETL Analyst

Responsibilities:

• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting with senior peers or subject matter experts to learn more about the requirements
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Ensured data integrity and verified all data modifications and calculations
• Developed test cases to accomplish ETL data migration
• Conducted data validation testing
• Tested Informatica Mappings and worked on Staging area to validate the data with SQL Queries.
• Tested various jobs and performed data loads and transformations using different stages of Informatica and pre-built routines, functions and macros.
• Extensively involved in writing & execution of SQL statements for back-end testing and eventually automating them using QTP
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Validated Crystal Reports by running the SQL queries based on the business rules.
• Testing the source and target databases for conformance to specifications
• Written SQL scripts to test the mappings.
• Create and execute test scripts using Mercury Test Director parameterized scripting
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Validating the Target data based on the test cases.
• Involved in creation of defect analysis report for system Test and UAT.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto Oracle 10g with high volume data
• Extensively used Toad to verify records that has been populated by ETL process.
• Tested/Validated several XML Documents using XML Spy and generated XSD’s for corresponding XML documents.

Environment: ETL, SQL Server 2005, BI Crystal Reports, XML, SSIS, TOAD, UNIX, UAT, Shell Scripting, XML Spy, Windows XP, Oracle 8i, Test Director, QTP, Load Runner