SUMMARY:

• Strong background in QA/ETL with analysis, coding, development and execution of Test Cases and Test Scripts.
• Experienced with Test Plan, Test Case, Test Script, Change Request and Defect Request.
• 7+ years of experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB 2 8.0/7.0/6.0, MS SQL Server 2000/7.0/6.5, Sybase and MYSQL.
• 6+ years of experience in data warehouse concepts and technologies like OLTP, Normalization/Denormalization, ETL, OLAP, Data Models(Star/ Snow Flake Schemas), Datamarts(Dimensions and Facts) and Reporting.
• Extensive Experience with Utility Tools like TOAD, SQL Server Management Studio, SQL Developer, SQL* Plus, SQL*Loader and Rapid SQL, SQL Query Analyzer, SQL Assistant
• Familiar with managing the defects and change requests through Testing Tools like Quality Center/Test Director, Clear Quest and StarTeam.
• Experienced with ETL tools like Informatica, SSIS, Datastage.
• Extensive experience with Reporting Tools like OBIEE and Siebel Analytics.
• Experienced in testing Cognos and Business Objects reports.
• Familiar with Excel for developing Requirements Traceability Matrix(RTM) and Capturing and Updating Change Requests.
• Experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.
• Extensive understanding of Business Requirements/Rules, Functional and Technical Specifications.
• Experienced with Transformations like Filter, Joiner, Union, Router, Look up and Sorter.
• Experienced with reports like DrillDown, DrillUp, Narrative View and Pivot/CrossTab reports.
• Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like Toad and SQL Query Analyzer.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Experienced in scheduling and kicking off ETL jobs using workflow manager.
• Knowledge in Performance Tuning of SQL and PL/SQL using Explain Plan and Trace Files.
• Documentation of Requirements, Test Case, Test Scripts and Results using Excel.
• Experienced with System, Integration, Regression and User Acceptance Testing.
• Familiarity in various software systems and platforms with good understanding of Object Oriented Programming (OOP) and ERD.
• Excellent problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.2/8.0/Test Director, Borland StarTeam, Manual Testing, Clear QuestDatabases: Oracle 8i/9i/10g, DB 2 8.0/7.0/6.0, SQL Server 2000/2005, MySQL, MS Access, MS Excel, Sybase, Teradata V2R5/V2R6

Utility Tools: TOAD 8.5, SQL Server Management Studio, Rapid SQL, SQL*Plus, SQL*Loader, SQL Developer, SQL Query Analyzer, SQL Assistant, WinSCP

ETL Tools: Informatica 8.1/7.1./6.2/6.1/5.1, SSIS, DataStage 7.0/6.1

Reporting Tools: OBIEE, Siebel Analytics, SSRS, BI Publisher.

Operating Systems: Windows 95/98/2000/XP, Linux and UNIX.

Microsoft Office: Excel, Access, Outlook and Power Point

Programming Languages: SQL, PL/ SQL, T - SQL, C, C++, Java

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

Data Warehouse /QA Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Testing included unit, system testing, regression testing Cognos reports testing.
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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.
• Data Quality Analysis to determine cleansing requirements
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Extensively tested the Cognos report by running the SQL queries on the database by reviewing the report requirement documentation.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Reported software bugs to the development team using Rational Clear Quest
• Developed PL/SQL procedures & triggers.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in developing Unix Korn Shell wrappers to run various Informatica Scripts
• Developed the strategies for analyzing the data for ETL Team
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: OS/390, JCL, COBOL II, Test Cases, Test Scripts, Test Plan, Copy Books,, Informatica 8.6.1, Oracle 10g, Teradata 12.0, Teradata SQL Assistant, SQL Server 2008, Flat files, XML Files, XSD, XML Spy 2010, Clear Quest, PL/SQL, QTP, TOAD, SQL, UNIX, Quality Center 10.0,, Cognos 8.0 Series

SQL/ETL Tester

• Analyzed the business requirements and rules from business requirements document.
• Attended meetings with architects, developers and business analysts to understand data model, data flow and warehouse design.
• Reviewed the Mapping Document thoroughly and analyzed the mappings, mappings and design specifications.
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts
• Validated that the design specifications meet the requirements and data flow.
• Written test cases developed the validation steps and reviewed them with test team lead.
• Developed test scripts using SQL and PL/SQL according to the mappings and rules specified in mapping document.
• Reviewed test cases, validation steps and test scripts with business users and team lead.
• Worked with Borland StarTeam to open Change Requests to business analysts.
• Requested CRs to data architects to make changes in DDL via StarTeam tool.
• Attended Daily Release Planning Meeting with Developers and QA Team to discuss Software changes and configuration management.
• Scheduled and Kicked off Workflows and Worklets in Workflow Manager.
• Used Workflow Monitor to monitor the workflow runs in Gantt Chat and Task Views.
• Analyzed workflow statistics like throughput, Source to Target Success and Failure rows.
• Read the Workflow Session Logs to find warnings and error messages in case of failure.
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• Used Microsoft Excel to test small amount of data imported from different database management systems.
• Functioned as Project Lead to implement an effective and efficient test regression test bed. Test Automation using QTP
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.
• Communicated with DBAs to backup the data and discuss the query performance.
• Written complex SQL queries and executed them to validate the incremental ETL Loads.
• Used Synonyms and DB Links to validate the data from different schemas and databases.
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Experienced with data models Start Schema and Snow-Flake Schema
• Analyzed Data Marts and tested several Dimension and Fact tables.
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE.
• Involved in System and Integration testing, Regression Testing and Report Testing.
• Used StarTeam to report bugs to developers and track them from time to time.
• Used Microsoft Outlook to schedule meetings and communicate with the project team.
• Attended Daily Status Call with Manger, Development Team and QA Team to discuss the project updates.
• Documented test cases, test scripts and test results in Microsoft Excel.

Environment: Oracle 10g, SQL Server 2005, SQL, PL/SQL, Borland StarTeam, Informatica Power Center 8.1(Workflow Manager, Workflow Monitor), Flat Files, Mapping Document, TOAD for Data Analysts 8.5, SQL Server Management Studio, Windows XP Professional, Unix, Test Case, Test Script, OBIEE, Microsoft Office(Excel, Power Point and Outlook)

Senior QA Analyst/ETL Tester

• Understood and analyzed the Requirements and Rules from DOORS.
• Read the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Discussed complex requirements with Business Analyst and Business Users.
• Analyzed each ETL with OLTP source data, staging and target data.
• Understood the Data Model in the Data Warehouse that consists of Dimension and Fact tables.
• Developed Test Cases for each ETL according to the business requirements and rules.
• Reviewed the Positive and Negative Test Cases with Test Team Lead.
• Mapped the Requirements with Test Cases in Requirement Traceability Matrix (RTM).
• Developed Test Scripts using complex SQL and PL/SQL queries, according to Mapping Document.
• Reviewed the Test Cases and Test Scripts with Business Users and made some corrections.
• Worked with QA team members on updated test cases and change requests to prepare the Final RTM.
• Created and modified test data using File-Aid
• Assisted in kicking off Datastage ETL jobs using UNIX and analyzed the data in dimension and fact tables.
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
• Also worked with MS Access database for testing the data from two different schemas.
• Discussed database log file issues and the Query performance with DBAs.
• Performed the Query Tuning for complex SQL and PL/SQL codes using Explain Plan and Trace Files.
• Worked with Developers on Defects until the test case is passed.
• Requested Change Requests (CR) to Business Analyst and updated Legend work sheet in RTM.
• Worked with Quality Center and Clear Quest for Defect Management.
• Attended weekly TSR (Test Status Review) meeting with test team lead.
• Attended Daily Status meetings with Project Manager, Business Analyst, Developer and QA Team.
• Worked on Regression Testing for each new release of code until the code meets OLAP requirements.
• Tested the reports like DrillDown, DrillUp and Pivot reports generated from OBIEE.
• Tested the reports functionally and non functionally to meet the OLAP standards.
• Worked on MS Excel for Documentation with Requirements, Test Cases, Test Scripts and the Results.

Environment: SQL, PL/SQL, Oracle 10g, SQL* Loader, Quality Center 9.2, UNIX, DOORS, DB2 8.0, TOAD 8.5, OBIEE, Sybase, Datastage 7.0, Clear Quest 7.1, RTM(Requirements, Test Case), Test Script, MS Excel, MS Access, RTM, Mapping Document, Flat Files, Windows XP.

Confidential, Lakewood, CO

ETL/SQL Testing

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database for testing the business rules imposed on data movement.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Performed front-end testing on OBIEE Executive Dashboard portal
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Written SQL Queries, according to mapping document to validate the code written for the data movement into the database tables.
• Retesting the resolved defects/issues after the developers fix the defects
• Kicked off the informatica workflows and monitored them in Gantt chat and Task View from workflow monitor.
• Developed the strategies for analyzing the data loaded by Informatica Workflows
• Accomplished the assigned work and updated the status of the testing to the QA team,

Environment: Oracle 10G, SQL Server 2005, SQL, TOAD 8.0, SQL* Loader, XML, Flat files, SQL Server Management Studio, Informatica Power Center 8.1/ 7.1.4(workflow manager, workflow monitor), OBIEE, Teradata V2R5, Teradata SQL Assistant,UNIX, RTM, Test Cases, Mapping Document, Test Scripts, Test Plan,HP Quality Center 8.0, MS Excel, MS Access.