SUMMARY:

• 10+ years of experience in Quality Assurance in Information Technology, involving analysis of both Manual (Functional/Database) Testing and including 4+ Years of experience in ETL/Datawarehouse Testing of client server and web applications.
• Extensive experience in ETL/ Data warehouse backend testing
• Good exposure to Datawarehousing Concepts
• Expertise in testing Facts and Dimensions - based on mapping logic
• Strong in all the ETL (Transformation & Load) techniques, Dimensional Schema Models (Star, Snow-Flake, OLAP), Data Cleansing.
• Testing experience in Datastage, Informatica PowerCenter 8.6 tool (Power Center / Power Mart) (Designer, Workflow Manager and Workflow Monitor)
• Extensive experience in Design Mapping, Transformation rules.
• Good knowledge in Hadoop ecosystem components
• Sound knowledge in Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC)
• Extensive experience in creating Test Plans, Test Cases, Test Scenarios, Testing Methodologies(Sanity, Integration, Regression, UAT, System Testing) and Traceability Matrix, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Good experience on Product Testing.
• Excellent Knowledge of Database Systems - Oracle 11g, SQL server, Teradata.
• Extensive experience in developing SQL Scripts to validate the databases tables and reports data for backend database testing
• Extensive experience on Defect reporting and tracking with Quality Center and ALM
• Good experience Defect Analyzing and Reporting in Remedy
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Experience with Automation Tool QTP.
• Experience in Agile - (Scrum), Waterfall Model and V-Model
• As a QA Analyst - Worked on various industry verticals Healthcare, Banking, Insurance, Retail and Leisure & Hospitality, Oracle apps Domains.
• Experience on white box testing using .Net programming Language
• Basic knowledge on Phython programming language
• Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint).
• Around 3 years of extensive work experience in Leading Test team on Functional, Regression GUI Testing.
• Proven ability to work efficiently in both independent and team works environments
• Quick study with an ability to easily grasp new technologies and software IT architecture
• Excellent analytical skills and innovative problem solving ability
• Excellent communication and interpersonal skills

TECHNICAL SKILLS:

Testing: ETL/DWH Testing, Database Testing/ Functional Testing

ETL: Informatica Power Center 8.6/ 9.0

Reporting Tool: SAP BI, SSRS, Query Surge

Operating Systems: MS Windows

Automation Tool: QTP

Databases: Oracle 11g, MS SQL Server, Teradata

Test Management Tool: Quality Centre 10, ALM 11, Remedy, Jira

Programming Language: Phython

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Senior Testing Engineer

Responsibilities:

• Involved in reviewing test scripts based on the business requirements. Plan, Execute and Monitor the CRP Cycles in Development instances in Oracle ERP
• Extensively worked with Oracle application modules procure to pay, payables
• Responsible for managing and executing Oracle Apps planning and testing procedures
• Expertise in implementing test plans for the entire Oracle EBS implementation
• Experience in testing process flow of Finance General Ledger (GL) in Oracle ERP along with the other modules like Account Receivables, General Ledger.
• Strong Knowledge of Base Tables and Interface Tables in various modules like General Ledger (GL), AR, AP
• Expertise in Testing the Order to Cash life cycle with all the Standard items in Order Management (OM) and Financial Modules
• Involved in reviewing the Functional Design Document with Functional team members in Oracle ERP
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Developed complex SQL Queries for querying data against different data bases for data verification process
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Unit Testing, Integration Testing and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Debugging the Failed script & fixing for the same by using QTP tool.
• Prepared test data for testing
• Defect Analyzing and Reporting in QC
• Leading Testing teams & help achieve project delivery deadlines by monitoring testing progress and planning of the test schedules.
• Performed Knowledge transfer sessions on web application as well as application domain to newly joiners in the team.
• Interacted with BA & Dev teams to resolve the issues

Oracle Applications and Modules:

Oracle Application R12: Functional (GL,AR, AP) and Oracle Application 11i: Functional (GL, FA, AR, AP).

Confidential, PaloAlto

Senior Testing Engineer

Responsibilities:

• Performed ambiguity analysis of the business meaning of the data
• Understood Mapping document and Transformation Rules of Data Warehousing Application
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Involved in the Preparing of Test Plan for Data Warehousing Application
• Tested ETL Transformations by using AWS services.
• Involved in ETL process testing using Informatica ETL tool
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business & management teams to understand the Confidential project business requirements and ETL design document specifications.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Attended meetings with logical data modelers to enhance knowledge of Back-end Testing, like acquiring the data from different data bases by using Informatica tool.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Verified the data in target database after ETL process
• Performed column data mapping between source and target database
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Written test cases to test the application in Quality Center 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Worked on issues with migration of Data from development to QA-Test Environment
• Designed and executed functional test cases
• Prepared test data for testing
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications. Contribute in the development of knowledge transfer documentation.
• Defect Analyzing and Reporting in Remedy
• Interacted with BA and Dev teams to resolve the issues

Environment: Datawarehouse(ETL)/Functional Testing, SQL Server, Confidential ALM, Remedy

Confidential

Senior Testing Engineer

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing )
• Involved in the Preparing of Test Plan for Data Warehousing Application
• Developed, reviewed, and executed Test Scripts and designed test data
• Run the jobs for ETL process
• Verified the ETL data in target database
• Verified the data which is loaded into target database
• Identified Test Scripts for Regression testing
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Worked with ETL group for understating mappings for dimensions and facts
• Written complex SQL queries for querying data against different data bases for data verification process
• Defects identified in testing environment where communicated to the developers using defect tracking tool ALM.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Attending Agile daily Scrum meetings
• Involved in adding tasks to sprint backlog
• Debugging the Failed script & fixing for the same.
• Interacted with BA and Dev teams to resolve the issues

Environment: Functional/ Datawarehouse(ETL)/Testing, Confidential ALM, SQL

Confidential

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations match aggregated data against staging tables and Granularity of data is as per specifications
• Developed ETL test scripts based on technical specifications/ Data design documents and Source to Target mappings
• Involved in ETL process testing using DVO ETL tool
• Performed column data mapping between source and target database
• Tested a number of complex ETL mappings
• Scheduled and automated jobs to be run in a batch process
• Run the Jobs/ Workflow for ETL process
• Worked on Mapplets and reusable transformations for daily data loads
• Worked with flat files such as .xls and .txt data sources
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Developed complex SQL Queries for querying data against different data bases for data verification process
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Unit Testing, Integration Testing and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Debugging the Failed script & fixing for the same by using QTP tool.
• Prepared test data for testing
• Defect Analyzing and Reporting in QC
• Leading Testing teams & help achieve project delivery deadlines by monitoring testing progress and planning of the test schedules.
• Performed Knowledge transfer sessions on web application as well as application domain to newly joiners in the team.
• Interacted with BA & Dev teams to resolve the issues

Environment: Datawarehouse(ETL)//Functional Testing, Automation Testing(QTP), Confidential ALM

Confidential

Senior Testing Engineer

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Developed, reviewed, and executed Test Scripts and designed test data
• Involved in ETL process testing using Informatica ETL tool
• Run the jobs for ETL process
• Verified the ETL data in target database
• Verified the data which is loaded into target database
• Identified Test Scripts for Regression testing
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Worked with ETL group for understating mappings for dimensions and facts
• Written complex SQL queries for querying data against different data bases for data verification process
• Defects identified in testing environment where communicated to the developers using defect tracking tool ALM.
• Extracted data from various sources like Oracle, flat files and SQL Server
• Attending Agile daily Scrum meetings
• Involved in adding tasks to sprint backlog
• Debugging the Failed script & fixing for the same.
• Interacted with BA and Dev teams to resolve the issues

Environment: Functional/ ETL Testing, Confidential ALM, SQL

Confidential

Senior Test Engineer

Responsibilities:

• Involved in functional study of the application
• Developed, reviewed and executed Test Scripts and Designed test data
• Involved in ETL process testing using Informatica ETL tool
• Run the jobs for ETL process
• Verified the ETL data in target database
• Involved in Source and Target data Mapping
• Verified the data which is loaded into target database
• Developed complex SQL queries for data validation for verifying the ETL Mapping Rules
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked with ETL group for understating mappings for dimensions and facts.
• Reviewing developed test cases and Execution of test cases.
• Preparing requirement traceability matrix.
• Mentoring new team members on the project
• Tracking and reporting the issues to project team and management during test cycles.

Environment: ETL/Manual Testing, Confidential QC, MS SQL Server 2005

Confidential

Software Test Engineer

Responsibilities:

• Understood the client Requirements
• Perform Ambiguity Analysis of the requirements.
• Analyzing the requirement specifications.
• Developing High Level Scenarios against requirements
• Reviewing developed test cases and Execution of test cases.
• Preparing requirement traceability matrix.
• Reviewing post execution and defect process
• Interaction with client through weekly calls.
• Sharing daily and weekly status reports to the project stake holders

Environment: Manual/Functional Testing, Bugzilla, MS SQL Server 2005

Confidential

Software Test Engineer

Responsibilities:

• Analyzed client requirement specifications
• Developed test scenarios based on the requirements
• Performed design and execution of test cases
• Identified and wrote test cases for the use cases
• Performed testing across different browsers for its compatibility
• Performed the preparation of Traceability Matrix
• Found Bugs and Bug Reporting using Bugzilla
• Documented and reported bugs found during testing process

Environment: Manual/Functional Testing, Bugzilla