SUMMARY:

• 7+ years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications using Manual testing tools.
• Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements Traceability Matrix.
• Experience using query tools for Oracle, Teradata and MS SQL Server to validate reports and troubleshoot data quality issues.
• Expertise in working in Agile (Scrum) and Waterfall methodologies and good understanding of the application throughout all phases of the SDLC .
• Experience using Test Management Tool for logging the Defects and Test cases HPQC 10.0 and Application lifecycle management (ALM) 11.0.
• Expertise in understanding Business Requirements, Functional Requirements and ETL Specifications into Test Cases for Positive and Negative test conditions.
• Experience in testing and writing SQL statements.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL.
• Expertise in multiple testing techniques including functional, regression, integration, system, parallel, data base, performance, smoke, User acceptance testing.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica. Solid Back End Testing experience by writing and executing SQL Queries.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Strong working experience in validating DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica, Data Stage.
• Good experience in Business Objects Reports testing .
• Performed backend testing for Database integrity by executing complex SQL queries for validating the data in the backend database tables.
• Committed team player, with excellent communication skills and self-starter, capable of working independently.
• Excellent business understanding and effective at working across multiple teams within organization.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL QA/BI Tester

Responsibilities:

• Gathered from Business Analyst both Functional (F-Specs) & Technical (T-Specs) and worked with
• Developers in understanding of ETL Mapping Applications.
• Written Test Cases to Validate the count, Business Logic, Functionality and Attribute check of the Application.
• Build & executed the complex SQL queries based on mapping logic provided and used HP ALM as test management tool to execute Test Cases and creating the defects.
• Validated Metric Calculation of the ProfitView of Credit, Deposit and Treasury Management as per the Measures, Business Processors and Rules in OFSAA
• Worked on the Manual File Uploads of ProfitView and validated the data movement from the Stage till Fact tables to make sure all data is reflected in the tables.
• Worked on the Front End Adjustments Module of Profitview like Portfolio Transfer, Product Mass Adjustments which will allow to transfer Portfolios from one officer to another.
• Worked on CAARP which provides the Portfolio of customers and the Profitability for compensation purposes.
• Worked on the data which are upstream to and downstream from ProfitView and validated the data as per the Business Rules.
• Validated different data mapping activities from OFSAA to Teradata
• Involved in testing the Wholesale Profitability OBIEE reports at different time frames, Org Level, Product Family, officer, year etc.
• Validated the DQ checks to make sure the data is Failed as per the DQ Rules.
• Validated different SOR’s data like AFS, LOANIQ,WFDS, Lucas etc as per the business rules.
• Validated Mandatory, Conditional and Optional field validation for different System of Records SOR.
• Involved in the Story Grooming session of DME track (Defects & Minor Enhancements) of the ProfitView.
• Validated the Defects and Minor Enchancements User stories which are in READY status.
• Expertise with Unix commands administering Unix server ensuring file system,memory and processes all in place using putty.
• Automated all regression Test cases from prior releases like Metrics and Data Integration using UFT.
• Followed Defect Life Cycle and raised the defects based on priority and severity level in QC.

Environment: Oracle SQL Developer 4.0.3, Teradata SQL Assistant 15.10.1, OBIEE 12.2.1, UFT 12.02, ALM 12.0, JIRA

Confidential, San Jose, CA

ETL QA Analyst & BO Reporting

Responsibilities:

• Understanding the Design, ETL mapping and the Documents provided by the development team for testing
• Writing test cases on the related scenarios to be tested such as Count, attribute checks, performance, functional, business logic checks and so on.
• Uploading these test cases written to Quality Center after review and accordingly passing them as per weekly goals and baselines throughout the test cycle.
• Comparing and Validation of the old code and flow with the new ones .
• Providing IT validations signoff for both the history and incremental data for QA end.
• Providing data to Business users for application level testing and ensuring data accuracy and consistency.
• Worked on several reports for Customer Orders which are not fulfilled as per the promise date, On Time Shipment, Supply Chain Operations audits Carrier provided shipment information to ensure that the milestone that triggers revenue recognition is received timely and accurately and Carton Tracking Report is to improve visibility levels of tracking the carton location in the Supply Chain.
• Supported the project and resolved many report defects which were logged on Rally, retested, fixed and closed them.
• Tested Business Objects checked for Attributes, Filters, Prompts, Drill options, Hierarchies Headers & Footers, Report Alignments, Formatting and compared the results to make sure data matches.
• Build Adhoc BO reports from BI Launch Pad as per the requirements to test the data

Environment: Teradata SQL Assistant 14, Oracle 11g, HP ALM 11.00, Business Objects 4.1 Rally, BI Launch Pad.

Confidential, Columbus, Oh

ETL/BI Tester

Responsibilities:

• EDW (Enterprise DWH) structure is implemented at both Store level & Buy Online Return In Store where the Source is pulled from different systems like SAP, PIPE, JDA, MANU, People Soft, Flat Files and Teradata and loaded into the target EDW which is Teradata and reports are being generated using BO tool for business users for D ecision Making, Analysis, Costing, Purchases, Sales & Dashboards.
• Gathered from Business Analyst both Functional (F-Specs) & Technical (T-Specs) and worked with
• Developers in understanding of ETL Mapping Applications.
• A centralized repository called EMR is maintained to find the objects like Tables, Views, Aggregates and Metrics etc. and testing them based on the Mapping Documents.
• Experienced working with heterogeneous source systems where source is being pulled from SAP, PIPE, JDA, and MANU, People Soft, Flat Files and Teradata and loaded to Target is Teradata and compared the results in Excel sheet.
• Build & executed the SQL queries based on mapping logic in Teradata SQL Assistant and used HP QC as test management tool to execute Test Cases and creating the defects.

  Worked on testing different retail application like Vendor, Customer, Article, Sector, Category, Class, Sub-Class, SKU, Site, Geographical Area Hierarchy (District, Region, Zone), and Pricing & Promotions, Transaction (SKU, DAY, and WEEK Level).

• Validated POS transaction receipts for SOOS/BORIS against EDW Base & Aggregate tables to reflect the Bar codes, Location, Item Desc, Shopping Transaction (Date, Sale/Return, Payments, Unit Price sell Amt, Merchandise credit, Shipping Charges, Tax, Total Amt, Transaction Type Cd)
• Daily & Weekly jobs are scheduled through CONTROL-M since they are integrated with applications such as SAP and Oracle People Soft for the Full & Partial Loads into the Target Tables.
• Involved in testing of Business Objects Reports by comparing QA against PROD and exporting to excel for final comparison between two environments.
• Implemented Business Objects test reports against requirements and checked for Attributes, Filters, Prompts, Drill options, Headers & Footers, Report Alignments, Formatting and compared the results against Dev reports to make sure data matches.
• Validated Table Structure (DDL), Negative Validation, Field-by-Field validation, Scenario & Scheduling validations based on the ETL Mapping Logic.
• Followed Defect Life Cycle and raised the defects based on priority and severity level in QC.

Environment: Teradata SQL Assistant GL3 V2R6 13.10, SAP R/3, Quality Center (ALM) 11.0, MS Excel,MSAccess,BusinessObjects3.1

Confidential

ETL Analyst & BO Reporting.

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• 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.
• Formulate methods to perform Positive and Negative testing against requirements.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Tested Complex ETL Mapping Rules based on business user requirements and to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Involved in the Agile Scrum Process
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using Teradata SQL Assistant.
• Worked with business team to test the reports developed in Business Objects 3.1
• Tested whether the reports developed in Micro Strategy are as per company standards.

  Used Quality Center to track and report system defects

Environment: : Informatica 8.6, Oracle 10g, Teradata V2R6, Business Objects 3.1, BTEQ, Flat Files, XML Files, HP Quality Center (HPQC) 9.2, Windows XP, DB Visualize, XML, SQL, PL/SQL.

Confidential

ETL/SQL/Data Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements.
• Participated in fact and dimension table and implementation of Star Schema model based on requirements
• Performed system testing, regression testing, integration testing and documented results using Quality Center
• Involved in multiple projects and participated in meetings with SME and Business Analysts.
• Reviewed and tested database modifications as per Physical Data Model
• Extensive files millions of rows from legacy mainframe systems are merged and loaded into the

  database forming the data warehouse

• Coordinated with PM, BA's, Developers and functional teams and coordinated meetings
• Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently

  Work with internal customers to understand requirements for ETL processes

• ETL for various data structures including data marts, data warehouses, flat files, and OLTP sources
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation
• Reviewed Informatica mappings and test cases before delivering to Client
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Validated the ETL Scripts in the Target Database (Teradata) for creating the cube before migrating it to SQL Server.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping
• Generated test scenarios, test cases and test data. Executed tests, created problem reports Environment: Informatica 8.1, Micro strategy 9, Oracle 10g,Teradata v12 SQL,PL/SQL, HP Quality Center 10.

Confidential

ETL/BI Tester

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed ETL test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Validated cube and query data from the reporting system back to the source system.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules.
• Written test cases and completed unit test documentation. Environment: Oracle 10G, DB2, Windows 2000 Pro, XML, SQL, PL/SQL.