SUMMARY:

• 9 + years of total experience in ETL, Data warehouse and UI testing.
• Good Knowledge of OLTP, OLAP and Data warehouse methodologies.
• Experience in Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Schema Modeling, Dimension, Fact and Aggregated tables.
• Expert in using the Agile, Scrum.
• Strong Testing Experience in Informatica and Abinitio.
• Tested the ETL Informatica mappings and other ETL Processes.
• Experience in testing coordination, writing test cases and executing test scripts, and logged defects in Quality Center (QC).
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Ability to perform end to end testing by understanding the entire system functionality.
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills
• Ability to work in fast pace environments.
• Worked on Web-services applications, using SOAP UI tool, to create a Web Service Test from SOAP request and validate the response against the database.
• Involved in developing the Test Cases, Test Plans and Test Scripts using the Business Requirement.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 10.0, ALM 11.0, JIRA.

ETL Tools: Informatica Power Center, Ab Initio 2.12, Data stage, SSIS

Languages: T-SQL, SQL, PL/SQL

Project Methodologies: Agile-Scrum, Waterfall, TDD

Databases: SQL Server, MS Access, Oracle, Teradata.

Operating Systems/Other Tools: Windows, LINUX, IBM Web Sphere Message Broker 7/IIB9.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

QA/ETL Tester

Responsibilities

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Assisted in the preparation of a validation plan and supported strategy.
• Documented all validation plans and protocols and ensured products met required needs.
• Develop and design data modeling concepts using OBIEE tools
• Developed and summarized all validation protocols for pharmaceutical manufacturing units.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Tested Informatics workflows for various ETL data mapping requirements.
• Involved in validating the data profiling and data analysis performed using data flux.
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.
• Involve in to STLC process for this project from Requirement Analysis to Execution. Responsible for total Quality for both ETL & Data QA team functionalities.
• Extensively used Rational Clear Quest to track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Conducted cleaning validation sampling in compliance with validation procedures.
• Prepared sample code and applications for displaying various outcomes of API applications.
• Extensively involved in testing the ETL process of data sources, SQL Server, Oracle, flat files into the target file, Oracle database as per the data models.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment:: Informatics 8.1,Abinitio, HP Quality Center, Rational Clear Case, Rational Clear Quest, TOAD, Putty, Oracle 10g, Agile, ALM, SSRS, SQL Server 2005, Perl, Linux, OBIEE.

Confidential, Atlanta, GA

ETL QA

Responsibilities:

• Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
• Verify the existing test cases and defining the scope for automation
• Involved in writing the Test Cases, Test Plans and Test Scripts using the Business
• Requirement
• Involved in Manual Testing of the Application.
• Involved in Positive and Negative Testing.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Database testing for the validity and visibility of data across all centric applications
• Completely involved in developing Test Plans and developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test
• Cases and Test Scripts.
• Used various SQL queries to validate the test case results for back-end test cases.
• Extensively used ALM Quality Center and created Test Cases in the Test Plan according to the specifications.

Environment:: Informatica 9.1 (Power Center, Power Exchange), Agile,Dat Files, Flat Files,Oracle 10g, SQL Server, Teradata, WINSCP 3, ALM Quality Center 12.1.

Confidential

ETL Tester

Responsibilities:

• Involved in understanding Requirement Documents.
• Wrote Test Plan, Test Strategy, Test Script, and Test Cases. Reported bugs and tracked defects using Quality Center
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detail, Drill Down and Score Cards
• Worked in an agile technology with Scrum
• Worked with business analyst and developers in setting up test data
• Involved in testing the batch programs by using the Autosys tool.
• Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Involved in testing the functionality of Abinitio Graphs.
• Responsible for different Data mapping activities from Source systems to Teradata
• Exclusively tested the inbound and outbound batch jobs.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Writing complex SQL queries for data validation for verifying the Mviews, Reports.
• Involved in extensive DATA validation using SQL queries and backend testing
• Involved in testing the Cognos reports by writing complex SQL queries.
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Created Test Plan, Test scripts for system validation and user acceptance testing (UAT)
• Tested and debug new enhancements and change requests using SQL, PL/SQL
• Worked with Automation tool Jenkins.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files and Oracle to load into the Teradata data warehouse
• Involved in Test scripts migration from Load runner to Performance Center.
• Tested ad hoc and standard reports for Cognos.
• Tested several dashboards and deployed them across the organization to monitor the performance
• Performed Input Validations, User Interface Validations, Browser Compatibility testing and Navigation testing.
• Worked on Xpath to find web elements
• Involved in querying using SQL and updating records and validate database records as expected.

Environment:: Ab Initio 2.12, HP ALM Quality Center 11.0, Agile/Scrum, Teradata, SQL Developer 3.1, Oracle 11g, MS PowerPoint, MS Excel, MS Word, MS-Visio 2007, MS Access, JIRA,DOOR

Confidential

ETL QA

Responsibilities:

• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of the entire QA Process and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts
• Involved in testing the data warehouse for both the initial load and the incremental loads of the target
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Setup test environment and test data for both positive and negative testing
• High level of experience with different Interface systems supporting our application and working with End-to-End testing
• Responsible for coordinating & executing the testing of entire system in accordance with test plan.
• Used web service description language (WSDL) to provide a model for describing web services.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.

Environment:: SQL, PL/SQL, Quality Center, ETL Informatica power mart 5.1, Toad, Test Director, Rational Functional, Tester, Rational Clear Quest, Oracle 8i, QTP, UNIX.

Confidential

QA Technical Analyst

Responsibilities:

• Quality review & validate the test Scenarios and test scripts of other team members.
• Attending overall review meetings before release to make sure all requirements are covered.
• Attending weekly Client’s Status calls.
• Attending daily calls with my team members to know update status about defects and daily plains.
• Execute the test scripts, raising the defects in HP Quality Center.
• Re-test the Defects and updating comments.
• Execute the Test cases and maintain the execution summary.
• Raise Defect in QC and map to the Test Case.

Environment:: Web Testing, Java, J2EE, JBoss, Webservices, Amdocs, Ensemble, EDW, DB2, Oracle DB, XML, Mainframe server (eBCCS, BCRIS), HP ALM, HP UFT,SOAP UI.

Confidential

QA Member

Responsibilities:

• Identification of Test Scenarios from given requirements.
• Preparation of test case coverage analysis sheet
• Uploading and execution of System test cases in Quality Centre.
• Raising defects in QC and tracking the same.
• Raise Defect in QC and map to the Test Case.
• Attending Defect Triage calls to get updates about Defects Status.

Environment:: Web Testing, Java, J2EE, JBoss, Webservices, Amdocs, Ensemble, EDW, DB2, Oracle DB, XML, Mainframe server (eBCCS, BCRIS), HP ALM, HP UFT.