Summary:

• Proficient in analyzing the Business Requirements, System Requirement Specifications, Functional Requirement specification, Design Documents to formulate Test Plans, Test Strategies, and Test Cases
• 7 years' experience working as an ETL QA Analyst Tester in various domains like Banking and Healthcare.
• Experience in Full life cycle of software projects including system analysis, design, development, testing, implementation and user training
• Expertise in creating Test Plans, Test Cases and Test strategies by reviewing the mapping, technical design and business requirements.
• Prepared and documented Test Cases and Test Scenarios for both Manual and Automated testing. Tested dimensional data loads and fact data loads.
• Experience in conducting Integration, System, Functional, Regression, GUI, Stress, Performance Testing
• Experience with BI tools like Business Objects XIR2 and dynamic dashboards, scorecards and structured reports for operations and higher management.
• Expertise in creating and integrating BO reports and Cognos reports with the data warehouse.
• 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
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Expertise in validating data by writing complex SQLs to retrieve data from databases, based on the input mapping and Skilled in data manipulation using SQL queries.
• Experience in various web-based, client-server and distributed multi-tier applications deployed on multiple platforms.
• Proficient in developing ETL mappings using Informatica power center
• Strong working experience in Windows NT/2000/XP and UNIX environments
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple project and cross train sub-ordinates in other Functional areas

Technical Skills

Work Experience

Confidential

QA Analyst

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios
• As an ETL Tester responsible for the understanding the business requirements, creating test data and test case design.
• Part of daily stand up meetings to communicate any day-to-day issues.
• Tested several Cognos Reports of different types including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI's, Grouped List, Cascade and Web Reports.
• Tested and validated the Cognos reports on target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• 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 data
• Extensively written test scripts and complex SQL Queries for back-end validations
• Tested key data metrics and reports that help to determine mandatory and discretionary investments based on the prioritizations and tested the expected returns using MS Access.
• Created SQL queries to pull out data and metrics from the database.
• Analyzed business and functional requirements to derive test plans, test cases, procedures, and expected results for testing Teradata based data warehouse applications.
• Validated Extract/Transform/Load ETL processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Involved in unit, performance and integration testing of Informatica mappings.
• Used Informatica to schedule the mapping, testing and debugging its components, and monitoring the resulting executable versions.
• Involved in testing the XML files and checked the quality of data that is parsed and loaded to staging tables.
• Tested datasets using several stored procedures.
• 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 : Teradata 13, Quality Center 10.0, Cognos Series 8.0, Oracle 10g/11g, Unix IBM AIX 5.5, T- SQL, XML Files, XSLT, XML Spy 2010, SQL, PL/SQL. Excel, Informatica 9.0, Agile

Confidential

ETL QA Analyst

Responsibilities:

• Involved in the meetings from the requirements phase prepared the TRDs based on BRDs.
• Responsible for preparing the mapping specification documents and developing the mappings based on the TRDs.
• Prepared master Detailed ETL and BI Test Plan for the entire Project.
• Performed End-to-End testing for the entire ETL and Business Intelligence. Involved in deployment the reports to production and debugging of reports
• Developed Test Plans based on Test Strategies and Developed scripts utilities simulators data sets and other programmatic test tools as required to execute Test Plans.
• Developed a testing strategy for all upcoming data feeds for both ETL and BI arena.
• Prepared traceability matrix for point's requirements from the completed test cases
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports
• Tested queries/reports/documents using Cognos
• Involved with extraction routines to verify all the required data loaded into target systems.
• Processed reject records for business rules for both dimensions and facts
• Conducted walkthroughs with the customer project management development team and Business Analyst
• Create detailed test plans based on analysis of requirements and design documents
• Analyzed raw points data to ensure the data will meet the business need
• Loading Flat file Data into Oracle tables using Unix Shell scripts
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Tested Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice Drill Down Functions Cross Tabs Master/Detail and Formulae.
• Verified fields present in the reports are as agreed in the ETL specifications
• Extensively involved with backend testing by writing complex SQL queries
• Worked closely with business analyst and development group during the requirement phase and design phase to find out functional incompatibilities and software issues early in the QA process
• Worked closely with the development teams to replicate end user issues
• Supported Infrastructure Engineers Network Engineers Developers in creating testing checklists and coordinating testing for Projects Changes and Emergencies
• Communicated discrepancies determined in testing to impacted areas and monitored resolution

Environment: Oracle 9i/10g ,SQL, PL/SQL, Stored Procedures, DB2, Toad, Erwin, Cognos, Test Plans Test Scripts, Test Cases ,VSS, MS Office Suite ,Informatica Power Center, Tivoli, MicroStrategy

Confidential

Data Analyst ETL Tester

Responsibilities:

• Involved in Analysis Design and testing of various Enterprise Data Warehouse and Business Intelligence applications
• Attended the Requirements reviews Design reviews Code reviews to understand the overall process flow and Source to Target Mappings
• TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements
• Writing a SQL Queries to retrieve data from data base
• Tested various Transformations for Data stage.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs
• Developed and tested transformation functions and record formats for various input data files
• Prepared test data to verify the functionality of the Data stage.
• Generated the test data to perform the functional testing based on the DMLs and Record Formats
• Developed Test plans and Detailed Test cases TSD and TCD based on business requirements
• Used Test Director to maintain Test Scenarios and Test execution.
• Involved in tracking the Defects using the Test Defect Tracking Tool and reported the bugs in the Test Director
• Analyzed the process to ensure that Business requirements are met and adhere to standards imposed by DW operations.
• Performed SQL validation to verify the data extracts and record counts in the database tables
• Tested Auto Sys jobs through command level to run the jobs to perform various tasks like Extract Transform and Load
• Involved in Unit testing of the Schema objects to test the Integrity of the Target Database SQL server

Environment: Business Objects Data Stage Designer, Manager, C .Net, Web I 2.7, Oracle, Windows NT/2000, OWB.

Confidential

Data/QA Tester

Responsibilities:

• Reviewed the Business Requirement specification Document and the Specification of the application
• Created test requirements hierarchy to represent the features and functionality that needs to be tested in the application.
• Developed Test Objectives, Test Plans and Test Procedures.
• Created manual Test Cases.
• Successfully logged defects using the defect Tracking tool
• Work with developers to test the fixed defects
• Performed Manual Testing of the application which involves accounting of various customer accounts using numerous test scripts
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Created virtual users to check the load performance using Load Runner and evaluated the performance.
• Inserted rendezvous points to generate peak load on the server to ensure that the transactions are performed accurately under the scenario.
• Defects were tracked, reviewed, analyzed and compared using Test Manager.
• Attended weekly status meetings showing progress and future testing efforts to the project manager.

Environment: Windows 2000, ASP, HTML, MS SQL Server, Test Cases, Test Scripts, Test Plan, Load Runner, and Test Director.