SUMMARY

• 8 years of extensive experience in Information Technology with emphasis on Quality Assurance, Data Warehousing Testing, Business Intelligence Testing, Oracle Business Intelligence Applications (OBIA) testing and knowledge on ERP tools like EBS (E - Business Suite) and JD Edwards.
• Experience in the areas of Insurance & Retail domains.
• Worked on testing the Implementations of BI Apps in Oracle Financial Analytics, Oracle Sales Analytics and knowledge on Oracle Procurement and Spend Analytics, Oracle Project Analytics and Oracle Supply Chain and Order Management Analytics.
• Experienced in Preparation and Execution of Test Strategy, Test plan, Test Scenarios, Test Cases, Test Procedures, Test Scripts, Test data for SIT and UAT and write the BCOE for them.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies.
• Implemented various Test cases for the Functional Testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT).
• Used Mercury Quality Center for maintaining the Test Plans, Test Cases, Test Execution, Defect management, and Bug Reporting an experience in writing automated scripts, designing Test procedures, Manual Test cases.
• Experienced in analyzing Functional Requirement Specifications (FRS), Mapping Document, Technical Document and conversant with System Design Specifications (SDS).
• Extensively used Load Runner for Performance and Load Testing. The Avg. CPU usage, Response Time, and TPS are analyzed for each scenario.
• Excellent understanding and expertise in writing complex SQL queries, PL/SQL to perform back-end testing on databases like Oracle, SQL Server.
• Experience in Data Modeling, Star Schema, Snow Flake Schema, Dimensions and Fact tables.
• Experience in Data Analysis, Data Validation (Table Structure Validation- Count Validation- Data Element Validation- Scenario Validation), Data Profiling, Data Verification, Data Loading, Data Warehousing/ETL testing and BI Reports testing thorough understanding various Requirements, Analysis and Design.
• Working knowledge on Informatica Power Center (Designer, Workflow Manager Workflow Monitor), Data warehouse Administration Console (DAC), OBIEE and have working knowledge on Tableau Desktop and Tableau Server.
• Experience in designing, developing and testing Mappings, Mapplets and Reusable transformations using various transformations like Connected /Unconnected lookups, Source Qualifier, Joiner, Rank, Sorter, Router, Filter, Expression, Aggregator and Update Strategy etc. Worked on OBIEE rpd development and reports Testing.

TECHNICAL SKILLS

Integration Tools: Informatica Power Center 9.0.1, DAC 10.1.3.4.1, OBIA 7.9.6.3/7.9.6.4, SSIS

ERP Tools: EBS R12 / R11

OLAP Tools: OBIEE 11.1.1.5 / 11.1.1.6, Tableau 8.0

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl.

Data Modeling: Erwin, MS Visio.

Databases: Oracle11g/10g, Teradata 8.2, DB2 8.1, MS SQL Server 2008/2005

Testing Tools: QTP 10, Quality Center 10/9.0/8.2, TestDirector9.0/8.0/7.5, Win Runner 7.6/8.0, Load Runner 7.8/8.0

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QA / ETL Tester

RESPONSIBILITIES:

• Work with the business team in the requirements walkthrough implementation of OOTB Oracle Financial Analytics, Oracle Sales Analytics.
• Work with the offshore team for the day to day work and review the tasks done by them get the status updates in the daily meetings.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager and also through DAC.
• Prepared Test Cases and Test Plans for the mappings based on the Functional, Source - Target Mapping Document and Technical Document. Also responsible for creating the Test Strategy.
• Executed the developed Test Cases and Test Plans and also coordinate with the development team to run the workflows if needed and write the SQL scripts to test the test cases.
• Reported the Bugs/Defects using Quality Center 10 defect management tool.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Tested different detail, summary reports and on demand reports. Extensively used Reporting tool for report generation.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Ensured data integrity and verified all data modifications and calculations during database migration.
• Performed Manual Functional testing with QC.
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved in Unit testing, integration testing, coexistence testing.
• Performed Functional testing, System testing, Regression testing and Back end testing.
• Most of the part involved in Query execution whenever needed as per the requirement.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL, PL/SQL, Excel Files, Windows NT & UNIX, Quality Center 10, OBIEE, Tableau, Business Objects

Confidential, Bloomington, IL

DWH ETL - QA Analyst

RESPONSIBILITIES:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing through the ETL Informatica tool.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 9.2.
• Conducted a comprehensive use case analysis Policy table, Agents table and the data, which loads to the SRS (Sales Reporting Service) Data Mart.
• Responsible for verifying the log files using UNIX and database for the submitted application
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Bug reporting and Bug tracking using HP Quality Center.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programming to automate.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and ExecutedSQL statementsinToadto retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix,andparticipated in daily/weekly QA meetings.
• Used Quality Center for logging the defects.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Informatica Power Center 8.6, Data Stage Information Server 8.1.1, Oracle 10g, MS SQL, HP Quality Center 10.0/9.2, TOAD, MS Excel, UNIX.

Confidential, Albany, NY

QA / ETL Tester

RESPONSIBILITIES:

• Analyzed the Business Requirements and Rules and worked with Business Analyst and Business Users.
• Gone through the Functional Specifications and implemented their technical aspect In Functional Testing, System and Integration testing (SIT).
• Preparation and Execution of Test Plans, Test Cases for the mappings developed through the ETL Informatica 8 tool in the QA environment.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Designed testing approach for ETL process for Sales Data Mart and Inventory data mart and ensure consistent and effective communication among all parties.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested data warehouse ETL process using SSIS (SQL Server Integration Service).
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Strong in writing complex SQL queries to profile and analyze the data in Oracle 10g.
• Used SQL queries & Join operations to Test database tables.
• Used different Querying tools like SQL Developer, Toad 9 to query different databases.
• Reviewed the Functional specifications, requirements document to determine the functionality of the application.
• Created Test Plan, wrote Test Cases and executed them.
• Used HP Quality center to maintain requirements, Test Plan, Test Cases and to Log Bugs identified during testing of the application.
• Coordinated with Business, UAT, development and production support teams to oversee Test Execution.
• Used status reports, Test Summary reports and Test Progress report with various test metrics.
• Actively involved in conducting defect review meeting with Developers and Business Users.
• Involved in Signoff meetings and go or no go meetings with Business Users.
• Involved in preparation of Test data.
• Used Waterfall SDLC model.
• Performed Functional, String, Integration, Regression, Performance, System and Usability testing of the application.
• Conducted GUI and functionality testing using QTP.
• Conducted data driven testing using QTP to conduct backend testing.

Environment: Informatica Power Center 8, SSIS, Oracle 10g, PL/SQL, SQL*Plus, Quick Test Pro 10.0, HP Quality Center 10.0, Toad, SQL Developer

Confidential, Kansas City, MO

QA Analyst

RESPONSIBILITIES:

• Tested business rules to generate consolidated (fact/summary) data identified.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Was responsible for indexing of the tables in that data warehouse.
• Served as a resource for analytical services utilizing SQL Server, TOAD/Oracle, and SQL Developer.
• Developed and maintained the project plan using MS Project
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL on Windows platform to perform Backend Testing on databases.
• Developed deployment instructions to support the deployment of data marts and reports.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment: Oracle 9i, PL/SQL, TOAD, SQL*Loader, XML, SQL, PL/SQL, HTML, Windows NT/2000

Confidential

QA Tester / BI Backend Tester

RESPONSIBILITIES:

• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing
• Worked on mapping of MMSS Web services to Enterprise Interface Partners and coordinated with MSP Web Services environment to access and connect related tasks/issues.
• Implemented SDLC, QA methodologies and concepts in the Project .
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Expertise in testing Web services (SOAP Services), validating XML.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in testing the designing and development of data warehouse environment.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the messages published by ETL tool and data loaded into various databases
• Tested the data coming through various lines of business of JPMCHASE such as Capital Funding, Venture Capital, Trust Accounting System, Bank Owned Life Insurance etc.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Business Objects 6.5/XIR2, ETL Informatica 7.1, Oracle, SQL Server, DB2, TOAD 7.6, MVS, ISPF, COBOL II, Web services testing, Copy Books, Mercury Quality Center 8.2 (Test Director), AS 400, RPG COBOL, Teradata 12.0, Autosys, Rational (RUP, Clear Case, Clear Quest), WinSQL Professional, Windows XP Professional, Novell client 4.91, IBM AIX 5.1, MS Visio 2003, MS Excel 2003, MS Word 2003, PeopleSoft 8.