Summary:

• Reporting using OBIEE, Hyperion, Enterprize Performance Management EPM 11 , Business Object
• Data warehouse Using Oracle Data Integrator ODI , Informatica and Data Stage
• Applications built using Web services based on Service Oriented Architecture SOA
• Over seven years of experience in the information technology as a Software QA professional including test management.
• Extensive experience good understanding of SDLC, STLC, Software Quality Assurance, Software Configuration and Releases Management
• Extensive experience in analyzing Business Requirement, Functional and Technical Specifications
• Strong working experience in Black box, White box, Functional, Regression, System, Integration and End to End testing
• Expertise in writing and documenting Test Strategy, Test Approach, Test Plan and Test cases
• Experience in Testing Database Applications of RDBMS in Oracle, SQL Server, DB2 and MS Access
• Hand on experience in Data warehouse testing including ETL testing using ETL tool Oracle Data Integrator ODI , Informatica Power center and Data Stage
• Hand on experience in BI report testing using OBIEE, Hyperion, Enterprize Performance Management EPM 11 and business object
• Good understanding of Data Modeling in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling, Data Mapping, Data Conversion, and Data Cleansing
• Good understanding of OBIEE repository Physical, Business Model and Mapping and Presentation layers for both Stand-Alone and Integrated and analytics implementations
• Hand on experience in writing complex SQL DDL, DML and DCL queries for back-end data validation testing
• Extensive knowledge on ETL process, OLAP, OLTP and N tier data architecture and RDBMS
• Hand on experience in test and defect management tools such as Quality Center, JIRA
• Hand on experience in developing an Automation framework leveraging Test Automation Tool Quick Test Professional QTP
• Built a dynamic relationship with the client, development and other teams to insure the highest quality deliverable possible and to deliver them on time
• Proficiency in Testing progress reporting, Defect tracking and maintaining using management tools like Quality Center, JIRA,
• Defined and followed processes according to ISO standards and Quality Management System, experience in working CMMI and ISO process environment

Technical Emphasis

• Testing Tools : Quick Test Pro QTP , Quality Center and LoadRunner
• Middleware : Tibco, Business works, Designer, Smart mapper, SeeBeyond ICAN suite
• ERP : Oracle 11i, Siebel, Oracle e-business suites, Peoplesoft and SAP
• Data warehouse : Oracle datawarehouse builder, Oracle Data Integrator, Informatica
• Reporting tools : OBIEE, Business Object, Hyperiaon, Enterprise Performance Manage EPM
• Operating Systems : Windows XP/2000/NT, Windows 2003 and UNIX
• Languages and scripting : Java, TSL, Shell, PL SQL
• RDBMS : Oracle , DB2, SQL server 2005
• Application Server : WebSphere, WebLogic
• Web Technologies : JSP, XML, J2EE, Microsoft .net and C

PROFESSIONAL PROJECTS

Confidential

Role: Sr. ETL/Report QA Analyst

Responsibilities:

• Participate in requirements definition reviews and functional specification reviews to ensure that critical information is included and testability requirements are met
• Participate in gap analysis for the given requirement, Mock up reports and dashboards for review by the business users
• Developed Test Approach and Test plan document for different Data Marts testing
• Participate in production issues review meetings with business and development team
• Analyze the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test overage accordingly
• Responsible for conducting QA entrance and exit criteria meetings with project stake holders
• Responsible for developing the test cases to validate the ETL process, business rules, Data transformation rules, Reports layouts and data
• Create requirements and Test matrix for ETL and Reporting Test cases in Quality Center
• Create integration test scenarios and tested application areas developed on SOA architecture and web services
• Develop test cases using standard test case template in Excel sheet and upload in Quality Center
• Validated the access to the System Security, navigation to a particular screen, dashboard, page, and report
• Validate access to the right data, screens, dashboards, pages, and reports, response time to access the application, particular dashboard, page and report, capability and ease of using prompts to select data on a report with specific attributes, use of drilldown and navigation on Reports for OBIEE
• Document software defects in defect tracking system Quality Center and keep defects up to date
• Write and execute SQL queries using SQL developer, TOAD, Microsoft SQL Server
• Prepare test progress and defect report and communicate to the management
• Identify, create and communicate Issue and Risk using Microsoft SharePoint
• Facilitate defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status
• Preparing and maintaining the release and cycles to keep track of code movement and testing using Quality Center

Environment Oracle Data Integrator 11g/10g, Oracle 11i, OBIEE 10.1.3, EPM 11, Hyperion 8.5, Erwin 3.1, TOAD, SQL Assistant.NET, Microsoft SQL Server 2008, SQL Server Management Studio, MS office 2007, Share Point, Subversion, Quality Center 11.0, Quick test professional QTP

Confidential

Role: Sr. QA Data Analyst/Test lead

Responsibilities:

• Defined requirements, designed and documented standards, procedures, and implementation plans for Software Configuration Management
• Managed requirements gathering and technical design for Data warehouse and reporting
• Administrate testing ids setup and maintenance using identity management tools.
• Manage resource allocation team members to design and execute test procedures
• Customized and maintained Test management tool Quality Center
• Led requirements definition and dimensional modeling for Oracle 11g ODI and OBIEE implementation. Utilized Oracle Warehouse Builder and early ODI ETL implementation Manage test lab resources and processes to allocate ETL testing and to simulate customer production environments.
• Responsible for Test cases development, Execution, defect management and tracking
• Facilitate defect review meetings and improved existing defect management process, driven team to work in faster manner by reporting defects status.
• Co-ordinate and execute the ESP jobs and ODI packages in test environment
• Responsible for writing and executing the in SQL queries using TOAD
• Responsible for ETL validation, Data validation between source to target, Report validation
• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application
• Requirement validation of the reports and drill downs with business users
• Validated the customization of the OBIEE Repository Physical, Business and Presentation layer
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down
• Tested the user level security for intelligence dashboards based on Business Requirement
• Validated the Dashboards with Dashboard prompts, Charts, Pivot tables
• Performed Data Validation of data in the reports and dashboards for OBIEE
• Responsible for Defect life cycle process, maintain and track Defects using Quality Center.
• Generate Defect reports using Quality Center API and SQL statements, on daily and weekly basis in the form of tables Graphs using Microsoft Power Point, prepared associated action plans and documented, distributed across the various project teams.

Environment Oracle Client Software 11g , SQL Developer, Oracle EPM 11.1.1 Web Client, ODI Release 10.1.3, Oracle Business Intelligence Enterprise Edition OBIEE , Hyperion EPM 11, Informix Client, Microsoft SQL Server 2008, SQL Server Management Studio, Windows Vista, Excel 2007, Word 2007

Confidential

Role: Sr. QA Tester/QA Engineer II

Responsibilities:

• Understand system requirements, design approach, technical design and detailed technical design document to generate the High Level Test Approach HLTA document and then create the detailed test scripts and test cases for each item in the HLTA.
• Created test scripts and executed them for the front-end Siebel UI where the New Agreements were entered into the system
• Generated Test case scenarios for the Agreements which already exist in the system and are converted from Mainframe to Siebel.
• Managed the tool Empirix which is used as the Testing tool and used for mapping the Requirements, tests and issues
• Wrote complicated SQL queries to verify the data between the Siebel UI and SQL Server.
• Manually performed Ad-Hoc testing, end-to end testing and System testing.
• Performed manual testing by entering positive and negative values to the application. Updated test case document with the results.
• Wrote SQL queries to test the initial load data from STAGE, WAREHOUSE, DATA MART for the record counts and data for various scenarios
• As a part of QA testing, worked with the Siebel UI and the Data modeler to test the ETL process.
• Created elaborate test scripts for testing the data mapping between the STAGE, WAREHOUSE AND DATA MART.
• Identified and logged the defects and issues into Empirix and JIRA and closely worked with development team to fix and re-test the defects.
• Worked with the Business Analysts to verify the issues and create PCR when needed
• Conducted QA testing of ETL data transformation and data warehouse for reporting solutions
• Created the test scripts for testing complicated Financial Reports SSRS which have location based an position based hierarchy rolled up for the reports
• Conducted regression tests for the existing pieces of the application and tracked the bugs using Empirix and JIRA.
• Was responsible for weekly status updates showing the progress of the testing effort and open issues to be resolved.
• Performed a QA team lead role and responsible for allocation of work and monitoring the test status.

Environment: Mercury Quality Center 9.2, QTP, Oracle 11i enterprise business suite OHRMS , Informatica Power center, Tibco, Oracle 9i on Sun Solaris 2.8 Hardware, Linux OS, Websphere Application server 5.1, MS Share Point, MS Power Point MS Project, Knowledge Xchange, MS Share Point and MS TFS.

Confidential

Role: Senior QA analyst

Responsibilities:

• Involved in writing test plans based on the project plan.
• Assigned the test areas to QA team and monitored, tracked the test status.
• Created test cases in Test Director.
• Conducted regression and functionality testing.
• Reported bugs and done defect tracking using Defect tracking and Management tool.
• Updated test progress to Project Manager and prepared weekly work status reports.
• Updated Project Plan based on QA Plan using MS Project.
• Executed test cases, compared and analyzed actual results against expected results.
• Tested database running SQL queries to verify data storage matches with the data entered in the application.
• Separated Manual testing areas and Automated testing areas.
• Defined Test automation frame work, Created test scripts using QTP and executed the scripts.
• Done smoke and acceptance testing.
• Reported and tracked defects in Test Director.
• Moved already existing defects in PVCS tracker to Test Director.
• Performed web browser compatibility testing using IE, Firefox, Mac Safari and Netscape.

Environment: QTP, Test Director, PVCS Version Manager I-Net 7.5.1.0 and PVCS Tracker, Internet Explorer, Firefox, Safari, Sun Solaris 7, Windows XP, WSAD, J2EE, EJB, Struts, SSJS, Vignette, Sun one directory Server, Oracle, Websphere, iPlanet, DHTML, javaScript, Macromedia Flash MX.

Confidential

Role: QA analyst

Responsibilities:

• Maintained and updated test plans using Test Director based on feature sets of different product versions.
• Developed test cases from architecture and design documents
• Executed test cases and interacted with programmers to resolve issues and bugs.
• Reported bugs and done defect tracking using Test Director
• Reported weekly progress to Testing Manager, including issues found and suggestions.
• Tested functionality, GUI and performance requirements using multiple browsers.
• Executed test cases, compared and analyzed actual results against expected results.
• Conducted regression testing, identified bug