SUMMARY:

• Over 8 years of IT experience in the Data Analysis, design, testing and Implementation of Data ware housing and 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.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), AutoSys, Control M and Maestro.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab Initio &Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads for testing practices.
• Extensive experience with Reporting Tools like OBIEE, Cognos, Business Objects
• Extensively used ETL methodology for testing data extraction, transformations and loading in a corporate-wide-ETL Solution using Data Stage
• Expertise in Testing complex Business rules with the help of mapping documents and transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Knowledge on Excel Pivoting and VBA macros for implementing various business scenarios.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

ETL Tools Informatica: 8.6.1/ 8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), Data stage 8.1, Ab Initio (GDE 1.15, CO>Op 2.15)

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata V2R6

OLAP Tools: Cognos 8.0/7.0/6.0

Business Objects: XIR3/XIR2/6.x/5.x,SSRS 9.0

Languages: SQL, PL/SQL

Tools: Toad, SQL* Loader, SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools Quality Center: 0, Test Director

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, Lanham, MD

ETL UAT Tester | QA Analyst

Responsibilities:

• Extensively involved in Testing Return Review Program (RRP) to help identify instances of tax return fraud, potential improvements in the Confidential approach to prevent, detect, and resolve pre-refund tax fraud.
• Responsible in all testing activities including: Developing Test Cases, Developing Test Scripts, Executing the Test Scripts, Creating System Test Reports, Reporting Defects and Incident Reports.
• Involved in end-to-end functional and integration testing of multiple Components of Return Review Program (RRP).
• Responsible in processing large no of files from multiple source systems containing extremely large volume data and loaded to the target tables using workload automation tool- Control-M as a part of ETL Testing.
• Reviewed database business and functional requirements, reviewed mapping transformations.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Wrote UNIX Shell Scripts, commands and SQL scripts during source to target data validation in day to day basis.
• Extensively used SQL queries, UNIX Shell Scripts, commands for data validation and backend testing.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Identify and document deficiencies in the proprietary information management system during initial implementation.
• Collected requirements and tested several BOE reports.
• Worked extensively in Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Performed end-to-end testing for business case scenarios covering all the subject areas.
• Involving in analysis, research, and troubleshooting of software defects.
• Worked on requirement traceability matrix, provided support for integration and user acceptance testing

Environment: Informatica, UNIX, Control-M 8.0, Oracle 10g/11g, SQL Developer 4.x, Business Object. 11.5

Confidential, Milwaukee, WI

ETL-EDW Tester |QA Analyst

Responsibilities:

• Performed duties under general supervision and Provide feedback to Business Analysts on the quality and feasibility of business/functional/technical requirements.
• Worked collaboratively with Business Analysts, Development Team, and Customers to develop and execute test cases that validate a delivered technical solution meets the business/functional/technical requirements.
• Identified, communicated, and assisted in analysis of defects found in system changes using defect tracking tool JIRA.
• Communicated issues and risks around the quality of a system directly to the project manager, technical lead(s), service owner, and QA leadership.
• Created documentation on an application’s readiness for deployment to a Production environment.
• Worked with QA leadership on larger project efforts, and takes direction on assignments to assist in the completion of the project on schedule and on budget.
• Worked independently on small to medium sized project efforts to assist in the completion of the project on schedule and on budget.
• Developed automation test cases for the use in regression testing and smoke testing.
• Executed automation test cases to validate that no new defects are introduced to the system.
• Performance testing of system to measure the scalability of requirements test, approaches for assigned maintenance work requests and Develop test Plans for WBMI’s strategic initiatives.
• Utilized SQL and data analysis skill sets to ensure data quality and accurate BI analytics.
• Applied QA Best Practices and actively looks for process improvement opportunities.
• Tracked defects using Service Manager for Production Existing tickets.
• Experienced in writing test cases based on ETL mapping document for testing the entire ETL workflow.
• Involved in preparing Test scripts and Test cases based on the functional specifications
• Tested all the Informatica jobs and ETL flow for Data Validation and also reconciles data for all the Informatica jobs for testing needs.

Environment:: Informatica 9.x, SQL*Plus, Quality Center, Rational Clear Quest, Clear Case, PL/SQL, SQL Server 2012, Java, UNIX shell scripting, JIRA, UNIX, Autosys scheduling tool.

Confidential, Austin, TX

ETL | Backend QA Tester

Responsibilities:

• Extensively worked with the Business Analysts in understanding the requirements and participated in HLD walkthroughs between BA and developers.
• Experienced in identifying defects in testing environment by using defect tracking tool HP quality center communicating with developing team.
• Performed manual testing of the Application.
• Tested all the Informatica jobs and ETL flow for Data Validation and also reconciles data for all the Informatica jobs for testing needs.
• Experienced in writing test cases based on ETL mapping document for testing the entire ETL workflow.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into source, mainly involved in ETL developing.
• Experience in defining and implementing approaches to load and extract data from database using Informatica.
• Worked closely with data warehouse architect and Business intelligence analyst in developing solutions.
• Performed ETL coding using Hash file, sequential file, Transformer, Sort, Merge, Aggregator stages, complied, debugged and tested. Extensively used stages available to redesign data stage jobs for performing the required integration.
• Uploaded test cases into HP ALM 11.0 and performed manual/automation testing.
• Involved in preparing Test scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries and conducted system testing for each phase of application.
• Used defect Tracking System Test Director to report bugs found in different stages of testing.

Environment:: Oracle 11g, Informatica 9.x, SQL*Plus, SQL, Quality Center, SQL Server 2000, PL/SQL, Flat Files, SQL * Loader, MS Access, MS Excel, OBIEE.

Confidential, Kansas City, MO

ETL/Data warehouse Tester

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Preparation of test scenario’s and test cases based on FD and TD documents
• Generating and validating the Cognos reports based on functionality
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and warehouse
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and migration of risks prior to formal acceptance.
• Performed Interface and Integration (SIT) Testing
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Track Sheet Maintenance and map the use case to requirement.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.
• Work closely with the software engineers to ensure successful, high quality releases.
• Working with Tivoli job scheduler for submitting the jobs and monitoring the jobs
• Preparing the SQL queries to fetch the data from databases.
• Worked with job scheduler tool Tivoli for running the ETL batch jobs and monitoring the batch jobs
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Gathering the requirements and preparing the case generation.
• Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Knowledge on Data validation, Data merging, Data cleansing and Data aggregation activities
• Execute the ETL jobs sessions and workflows
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
• Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica
• Perform User Acceptance Testing with UAT test scenarios.
• Build deployment activities and participate in design (spec) reviews with the Core team.
• Evaluate and suggest improvements to the software development process.
• Conduct Project Domain and Internal Project Functionality Training Sessions.
• Understand Business Requirement Specifications and System Requirement Specifications.
• Extract data from different source systems using Data Services tools.
• Create the universe based on the Reporting specification document.
• Prepare the SQL queries to fetch the data from databases.

Environment: Informatica Oracle SQL Developer, .Net 4.0, ASP.net 4.0, Web Methods and Web Services, UNIX, IBM COGNOS, HP Quality Center, Tivoli, SQL, PL/SQL, SOUPUI

Confidential, Denver, Colorado

DWH Tester/SQL Tester/BI Tester

Responsibilities:

• Tested the data warehouse with the help of data mapping document for various data feeds.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Coordinated between offshore and onsite team and managed the entire project for testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive data validations against Data Warehouse
• Logging and tracking defects on a release basis using HP Quality Center.
• Tested several Informatica Mappings to validate the business conditions
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Did extensive work with ETL testing including strategies like Data Completeness, Data Transformation & Data Quality for various data feeds coming from different source systems.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested Business Objects reports and written test cases using HP Quality Center.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions and tested the source and target databases for conformance to specifications.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Conditional testing of constraints based on the business rules.
• Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project.
• Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.
• Tested several reports developed in Business Objects XIR3
• Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Extracted certain column of data from a number to files using PERL.

Environment: Informatica 8.6.1, XML, XSLT, PERL, Business Objects XIR3, SQL Server 2008, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10g, PL/SQL.

Confidential, Pittsburgh, PA

DWH/ETL/SQL Tester /BI Backend Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
• Conducted Black Box - Functional, Regression and Data Driven.
• Tested whether the Business Objects reports developed in OLAP are as per company standards.
• Defects tracking, review, analyze and compare results using Quality Center.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Developed UNIX Shell scripts to automate repetitive database processes
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Extracted data from flat files and RDBMS tables and upload into targets Oracle tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
• Involved in testing timeline scheduling with the lead.
• Did testing of SOA end to end, Service by service and Interface by Interface
• Helped in identifying effort estimations related to testing efforts to Project Management Team
• Tested SOA application interface and communication paths.
• Tested data feeds from XML to Database.
• Development of test plan, test case and test scripts in Quality Center after for functional, system integration, Usability, security testing.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity.
• Generated XML data files using XML Spy.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: SOAP, SOAPUI, Web Services, Informatica 8.6, SQL Server 2005, Quality Center 9.2, PERL, Business Objects XIR2, Oracle 10g, Java, TOAD.

Confidential, Clayton, Missouri

DWH Tester

Responsibilities:

• Developed business data feeds document for data mapping needs for ETL and BI purpose to migrate the data.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Written extensive PERL scripts for various needs including text processing, data parsing and database connectivity.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Responsible for testing Business Reports developed by Business Objects XIR2
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: PERL, UNIX Shell Scripting, Mercury Test Director 6.5, SQL *Loader, XML, Cognos 7.0, Oracle9i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7