PROFESSIONAL SUMMARY:

• Around 8+ years of experience in Data Warehouse Quality Assurance BI Tools/Solutions testing, Web service testing, manual testing.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Test cases and Use Cases.
• Have solid understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
• Possess specific experience in the Banking, Retail, and health care Domains.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica, Data stage, BODS, and analytics tool like BO, Microstartegy, Cognos, Tableau.
• Exposure to Informatica/ETL development and monitoring environment(Designer, Workflow Manager and Workflow Monitor).
• Experienced in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Extensively used ALM for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Have tested several complex reports generated by Micro strategy, BO, Cogon’s including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly
• Status Reports. Heavy experience in testing Data Warehouse (DW/ EDW), Data Mart (DM), and BI reports. Highlighting about the issues, risks, limitations etc for the present and future deliverables.
• Proficiency in Defect management; including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center
• Expert in writing complex SQL queries for back - end testing.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Experienced in providing QA estimates, resources, and report testing status to project managers.
• Performed web services/XML testing using SOAP UI. Web services/API testing - Get and Post - XML validations and Postman.
• Self-starter, team player working on fast-faced development environments committed to the deliverables.
• Possess strong communication, presentation, problem solving and excellent interpersonal

TECHNICAL SKILLS:

TOOLS: HP Quality center 10.0. Scrum Works (Agile Methodology), Adobe Flex Builder, F-Secure, JAWS, FDT Tool, firebug, Micro strategy &Business Object Reports, BODS, BO Report

ETL tool: BODS, Informatica

BI Tool: Micro strategy, Business Object, Crystal report, SSRSDATABASE(S) Oracle 10g, SQL SERVER 2005,Teradata,Neteeza, IBM DB2

Testing Type: System Testing, Integrated system Testing, Regression testing

PROFESSIONAL EXPERIENCE:

Confidential, Schaumberg, IL

DW QA lead

Responsibilities:

• Analyzing Testing Requirements. Identify the Scope of testing and approach.
• Was involved in test strategy creation, test Plan creation, Design of Test scenarios, test case writing, RTM, test data creation, Retesting/Regression testing, Test Closure Report
• Test Lead handling 12 team members.
• Execution of the batch processes and the intra-day processes verify ETL graphs (jobs) status in UNIX environment.
• Performing API testing using Advanced Rest Client and Postman
• Testing the data in the generated output file and database for different feeds that involved reading flat files and database and fixed width flat files
• Defect reporting and analysis
• Estimates for change requests and planning their tests

Confidential

DW QA lead

Responsibilities:

• Analyzing Testing Requirements. Identify the Scope of testing and approach.
• Was involved in test strategy creation, test Plan creation, Design of Test scenarios, test case writing, RTM, test data creation, Retesting/Regression testing, Test Closure Report
• Test Lead handling 2 team members
• Writing SQL codes to verify and validate the Database, Data mart, DWH data.
• Well versed wif complex SQL, required on Teradata
• Experience in Teradata ETL using Fast load, MultiLoad, Fast Export, TPT and BTEQ Teradata utilities as well as Teradata SQL using SQL Assistant
• Execution of the batch processes and the intra-day processes verify ETL graphs (jobs) status in UNIX environment.
• Performing API testing using Advanced Rest Client and Postman
• Testing the data in the generated output file and database for different feeds that involved reading flat files and database and fixed width flat files
• Defect reporting and analysis
• Estimates for change requests and planning their tests
• Preparation of KT documents
• UAT support activities.
• Coordinating between Client and QA and DEV Team preparing the test reports, logs and provide it to Project Manager, Development Manager and QA manager

Environment: - Informatica, Teradata, Tableau, Control-M, Windows 7, UNIX, Rally, JIRA, ALM 12.1, Putty, WinSCP, Testing, Agile Project Methodology.

Confidential

DW/BI Tester

Responsibilities:

• Working as onsite coordinator, gathering all information’s from customers and provide to offshore.
• Work wif Business Analysts and Business Users in preparing Test Plans, Analyzed the
• Business Requirements and Rules
• Generate Requirement Traceability Matrix (RTM) by mapping Test cases, Test scripts wif the requirements.
• Worked on all the stages of SDLC, designed and executed Functional, Integration, Regression System (End to End) and Backend (Database
• Developed and executed test cases and test scripts.
• Used HP ALM defect management tool
• Prioritized the test cases based on the projected metrics and project deadlines.
• Performed Backend database testing; for Source to target data validations, by executing the
• Group functions, complex joins and sub queries.
• Created Test plans and executed tests for various Pre-load (initial), delta (daily) and reconcile table loads.
• Found the Defects when running the test cases and assign to ETL Developers using Defect tracking tool.
• Involved in testing the SAP business object reports which was used by the internal business team.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations wif the project manager.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Provided updates to Project Manager and other team members on testing activities. Attended daily standup meetings.
• Guiding offshore team on Test execution.
• Defect Reporting and Tracking and arranging the triage call.
• Execution of BO jobs and validation of Boxi reports and semantic tables
• Validation of all layers of data warehouse, including Semantic layers
• Validation of Dimensional and Fact tables.
• Validation of Change data capture and Initial load data.
• Validation of BI reports (Micro strategy/Boxi report).
• Designing the complex queries to validate the data in all layers of the project, as per the test scenario.
• Data preparation for Incremental load and responsible for End to End data validation and data integrity check
• Boxi Report Data & UI validation in Boxi reports.
• Part of UAT testing team to support the business users

Confidential

Tester

Responsibilities:

• Understanding the business process, Preparation of Functional and Technical test cases
• Verification of functionality test cases for regression test suit.
• Execution of Test Cases, Defect Reporting, Data Validation, Count Validation, RI Validation,
• RDM Validation, Sanity Check, Layout validation, Duplicate Check Validation.
• Manual functional testing and GUI testing.
• Execution of Test Cases, Defect Reporting, Data Validation, Count Validation, RI Validation Sanity Check, Layout validation, Duplicate Check Validation.
• Preparation of SQL queries to validate all business functionality to execute test cases
• Validation of Dimension layers, Fact tables, Views against BI reports
• Validation DW Warehouse tables against Source tables.
• Validation of Stage layers against the source tables.

Confidential

Tester

Responsibilities:

• Preparing the Test cases, understanding the business process.
• Verifying whether the code satisfies business requirements.
• Execution of Test Cases, Defect Reporting, Data Validation, Count Validation, RI Validation Sanity Check,
• Layout validation, Duplicate Check Validation. Execution of Test Cases, Defect Reporting, Data ValidationCount Validation, RI Validation Sanity Check, Layout validation, Duplicate Check Validation.
• Preparation of SQL queries to validate all business functionality to execute test cases
• Validation of Dimension layers, Fact tables, Views against BI reports
• Validation DW Warehouse tables against Source tables.
• Validation of Stage layers against the source tables.
• Manual functional testing and GUI testing.
• Data & UI validation in reports generated.

Confidential

Tester

Responsibilities:

• Involved in Functional testing, UI testing, Regression testing and Post deployment
• Performed ADA, Omniture, Browser compatibility
• Preparation of test cases.
• Reviewing Test Cases, Incorporating review comments.
• TEMPEffectively involved in Requirement analysis, Test case design, Reviewing the test cases, and defect discovery.
• Performed testing ofdifferent PFM FinApps (Flex Widgets).
• Involved ini18n Testing
• Knowledge sharing wif team members and execution of best practices to improve productivity
• Involved in Defect tracking and Bug reporting.
• Involved in UI testing using Pixel Ruler

Confidential

Tester

Responsibilities:

• TEMPEffectively involved in Requirement analysis, Test case design, Reviewing the test cases, and defect discovery.
• Knowledge sharing wif team members and execution of best practices to improve productivity
• Execution of Test Cases, Defect Reporting, Data Validation, Count Validation, RI Validation Sanity Check, Layout validation, Duplicate Check Validation.
• Worked closely wif DEV team to capture the requirement changes in every cycle.
• Preparation of SQL queries to validate all business functionality to execute test cases
• Validation of Dimension layers, Fact tables, Views against BI reports
• Validation DW Warehouse tables against Source tables.
• Validation of Stage layers against the source tables.
• Defect logging and tracking.

Confidential

Trainee

Responsibilities:

• Created test cases for sanity testing, GUI testing, regression testing, functionality testing,
• Integration testing
• Test execution for functional test cases, regression test cases, system test cases.
• Logged the defects using bug tracking tool.
• Retesting of fixed defects. Regression test execution. Traceability matrix creation
• Preparing the test summary report.

Confidential

Trainee Engineer

Responsibilities:

• Involved in functional testing, regression testing, Smoke testing, Browser compatibility testing, Regression testing
• Involved in Test case design, Traceability matrix preparation,
• Logged the defects using bug tracking tool.
• Writing SQL queries to validate the data in backend.
• Retesting of fixed defects.