PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Information Technology with emphasis on Software Testing/Quality Assurance. Experience in using Quality Assurance for ETL, Backend, Web based, Client/Server Applications using Manual and Automated testing tools .
• Good understanding of QA methodology and Software Development Life Cycle ( SDLC ).
• Involved in analysis, design and quality assurance of Client/server and Web applications for Confidential, Health Insurance, Confidential, Retail and gaming industries.
• Developed Test Plans , Test Scenarios , and Test cases , Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
• Diverse experience in Information Technology with emphasis on Quality Assurance, Manual Testing, Automated Testing .
• Excellent knowledge in ETL validation, Data Model Validations.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive experience in client/server and web application testing using System Testing , Functionality Testing (White & Black Box), Integration Testing , Regression Testing , Smoke Testing, GUI Testing , Data base Testing and User acceptance testing.
• Extensive experience with Data warehouse applications.
• Strong experience in automating the test using QTP and modifying the script code using VB Script .
• Strong knowledge in Automation tool QTP and Quality Center .
• Experience in BPT (Business Process Testing) by using QTP.
• Expertise in Problem solving and Bug Reports using Bug Tracking Tools.
• Strong skills in backend (in both Relational & Hierarchical database) testing. Writing SQL queries, generating reports to ensure data integrity and validating business rules.
• Experience in working with Databases and using SQL, SQL Server, and Oracle.
• Good Knowledge in design/testing and implementation of stored procedures , triggers and functions at database level using PL/SQL.
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, COGNOS and Business Objects.
• Ability to handle multiple tasks and work independently as well as in a team.
• Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

Testing Tools: Quality Center10.0/9.0, Quick Test Pro 9.2/ 10.0

Languages: HTML, TSL, SQL, PL/SQL

Operating Systems: Windows 9x/2000/ NT/XP, DOS, UNIX

Methodologies: SDLC, Agile

Databases: Oracle (SQLPLUS), SQL Server, MS Access

Data warehousing Tools:: Informatica, Business Objects, COGNOS, OBIEE

Office Software s: : MS Office (Word, Excel, PowerPoint). MS Project

GUI: C, C++, .NET, Java, JUNIT, J2EE, Java script, Visual Basics

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

Sr. ETL QA Tester

Responsibilities:

• Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test Execution Metrics .
• Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
• Involved in writing Complex queries using SQL for Data Integrity checks .
• Participation in Requirement / Use Case analysis, Risk analysis and configuration management .
• Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test Manager.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
• Developed presentation and testing implementation learning to other testing resources for cross functional training.
• Extensively tested the OBIEE report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the Data files from source to make sure correct data has been captured to be loaded to target tables.
• Validating the load process of ETL to make sure the target tables are populated according 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.
• Validate the SELL In, SELL Thru data models and validated the OBIEE reports with oracle source systems Demantra and Fusion.
• Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis.
• Actively participating in project specification reviews, writing and maintaining QA technical documentation.
• Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.

Environment: Informatica, Oracle, Oracle SQL developer, Toad 9.0, OBIEE and Windows XP.

Confidential - ALPHARETTA, GA

Sr. ETL QA Tester

Responsibilities:

• Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
• Exclusively worked with ETL team to analyze the source and Target Database systems.
• Exclusively worked with PEGA source system Business people to gather the requirements.
• Exclusively worked on ETL test case scenarios with business functionality and generated the reports for business users.
• Translating business requirements and technical specifications into test cases, test script.
• Identifying the gaps between the requirements and use cases.
• Creating and managing system testing schedule and executing the test cases against the functional specifications.
• Created manual and automated tests by conducting functionality testing, regression testing.
• Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment.
• Developed Test cases for different Loan scenarios (Conventional\\High balance\\Jumbo).
• Executed test cases manually to verify the expected results, as well as using automation tool Quality Center and QTP.
• Involved in preparation and enhancement of automated scripts for the identified automation scenarios using QTP .
• Analyzed and helped in modifying the Use Cases and created the Test cases based on them.
• Used Quality center to track, analyze and document defects.
• Reporting and tracking defects using test management.
• Involved in developing Entry & Exit criteria and defined the pass and fail standards.
• Performed Positive & Negative Testing.
• Participated in various meetings and discussed Enhancement and Modification Request issues (Change Requests).
• Performed Functional , Smoke, Integration, and System testing of Data warehouse application.
• Involved in Data testing by writing SQL queries in database tables to ensure UI result match the Database results.
• Validated Source -Target mappings applying various transformation rules and Business Rules.
• Involved in testing various reports created using Cognos.
• Effective co-ordination between development team and testing team.

Environment: Quality Center, QTP, Informatica, Cognos, XML, Oracle TOAD, UNIX, PEGA, Excel.

Confidential, Providence, RI

ETL Tester

Responsibilities:

• Involved in leading and participating in the full software life cycle for testing ( STLC ) activities - from test planning, test execution to test monitoring, status reporting, documentation and Business Objects report validation.
• Reviewed requirements documented (mapping document/Report Specs) by Business Analyst for thorough understanding of the application.
• Validating the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Validating the external data source by connecting thru Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
• Testing included Unit , System , Regression testing, Business Objects reports testing.
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & ad hoc reporting issues.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules .
• ETL validation, Data Model Validation.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Developed automated scripts for functional and regression testing.
• Reported the bugs through email notifications to developers using Quality Center.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Environment: Informatica, Business Objects, Mercury Quality Center 9.0, Java, HTML, XML, Oracle 9i/10g, MS-Office2003.

Confidential

ETL Tester

Responsibilities:

• Involved in the review and analysis of Business design summary, Use case document and Screen definition documents.
• Analyzed the functional requirements of the callidus application and true comp repository sales data.
• Exclusively worked on EIM (Enterprise Incentive Management) Data structures analysis reports.
• Developed test strategy for the Callidus True Comp application and involved in preparing Test plan document and developed Test cases.
• Exclusively worked with ETL team to analyze the EIM True Comp Data sources and prepared ETL test cases with SQL queries.
• Exclusively worked on True Comp ETL test case scenarios with business functionality and generated the reports for business users.
• Worked with ODS (operational data storage) system to analyze the Historical data.
• Responsible for performing Functional testing on the Callidus True Comp application by creating automated test scripts using Test Script Language (TSL) scripts and Quick Test Pro.
• Extensively used customized functions in the compiled module.
• Extensively used Quality Center for requirements tracking and functionality tracking.
• Responsible for tracking defects using Quality Center and made sure those defects are efficiently passed from one layer to another.
• Tracked and compared the data set results in different phase like SIT, UAT and PROD.
• Documented the test results for each build of testing in all phases.
• Enhanced and modified the scripts according to the test case scenarios.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Liaisons with the Management Team, Business Analysts, and developers for implementing new approaches and techniques.
• Responsible for documenting the process for future references .

Environment: Informatica , Quality Center, QTP, Oracle9i, TOAD.