SUMMARY

• 10+ years of experience in quality assurance and software testing of various business applications inclient/server environmentsand ETL, data warehousing solutions.
• Expertise in writing and maintaining test plans, test strategy, test cases and it execution.
• Expertise in writing test cases and execution in HP Quality Centre.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient inSQAmethodologies for Waterfall, Agile.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Experience on UNIX commands and shell scripting.
• Experienced in functional testing, performance testing, load testing, integration testing, system testing, regression testing, and black box testing, stress testing, and smokes testing, recovery testing and GUI testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Very good understanding of data warehousing concepts.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, OBIEE including dashboards, summary reports, master detailed, drill down and score cards.
• Defect reports, daily and weekly status reports.
• Experienced in using the Oracle SQL* Loader features for loading the data from flat files to data base tables for bulk loading.
• Proficiency in defect management, including defect creation, modification, tracking, and reporting using industry standard tools like Quality Center(HP)
• Experienced in interacting with clients, business analysts, UAT users and developers.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Strong Knowledge of Essbase, Hyperion, OBIEE
• Analysis Cubes, Extract data from different Cube.
• Knowledge on the phases of Agile methodology and Scrum Methodology.
• Strong knowledge of Data Model, Data Mining
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

TEST TOOLS: ALM, Quality Center, JIRA, Rational Quality Manager(RQM), Clear Quest(CQ)

SCRIPTING: VBScript, JavaScript, XML, HTML

LANGUAGES: SQL & PL/SQL, Java (Script), JEE, C/C++, VB Script, Perl, Shell Script

WORK FLOW TOOLS: MS - Visio, MS - Project, MS - PowerPoint, MS - Word, MS - Excel

DATABASES: Oracle 9i/10g, SQL Server 2008, DB2, Teradata, Peoplesoft

OPERATING SYSTEMS: Windows 2000/XP/2003/Vista/Windows7/Windows8, Linux & UNIX

ETL Tool: Informatica Power Center 7.1, 8.1, 8.6, Data Stage

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Responsibilities:

• Expertise in creating, developing Test Plan and test strategy documents plus writing test cases and test scripts according to BRD requirements
• Execution of test cases and upload result in HP Quality Centre
• Execution of Test data form source to target
• Check report form workflow to verify data loaded successfully
• To verify the extracted data file from the developer
• Verify and report the ETL logs and reject/discard files for errors
• Analyze and prepare Test Results, Test Reports and Defect Reports
• Create Checklists for each build during the SIT Phase
• Conduct walkthroughs and joint sessions of documents with all stakeholders and respond to their queries and suggestions
• Perform White Box Testing, Black Box Testing, Regression Testing, System Testing and UAT
• Participation in daily defect status meeting with the testing team and developer
• Support Post Production Testing after the Release of implementation
• Regression testing and verified performance tuning
• Raise defect in HP Quality Centre
• Perform Business process and verified new mapping for requirement
• Testing ETL jobs as per business rules using ETL design documents
• Extensively tested several ETL Mapping using Informatica
• Execution of SQL Queries to verify the dataflow from the backend
• Perform quality control and user acceptance testing
• To checked all requirement cover in test cases through Traceability Matrices.

Environment: Informatica 8.6, Oracle 11g, TOAD SQL, PL/SQL, Access, SQL Server 2008, ALM, Quality Center (HP) 10, MS Visual Studio, Budget and plan Forecast, Unix, CSV Data Files, Windows 7.

Confidential

ETL Tester

Responsibilities:

• Analyzed business requirement documents (BRD) and BI technical requirement document (TRD)
• Provided input to test plan and test strategy documents
• Wrote test cases and test scripts according to user requirement
• Extensively involved in system testing / functional, regression testing and integration testing
• Wrote complex SQL queries and PL/SQL subprograms to support the test case results
• Involved in developed and maintained automated regression test cases in Quick Test Pro using descriptive programming language
• Managed and controlled the project by HP Quality Center (ALM)
• Performed database (Metadata) validation before loading the data into the target tables.
• Created SQL compare statements to validate actual results with the expected results and written complex SQL queries for validating Cognos reports
• Trackedand executedtheUser AcceptanceTest cases (UAT) with respect to the requirements to determine the featurecoverage.
• Involved in testing stored procedures, functions, triggers and packages utilizing PL/SQL.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Involved in Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Performed backend database testing, by executing the group functions, complex joins and sub queries
• Validated the data moving from multiple sources to target using Informatica data validation option.
• Estimated level of effort (LOE) for testing effort and reported to Test Leads.
• Performed quality assurance activities for data validation, data scrubbing, data profiling
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements
• Attended weekly defect review and defect status meetings. Provided updates to Team Lead on testing activities
• Check high node middle node and leaf level
• Checking Report in Preparing OBIEE and check data validation
• Reviewed Plan and Forecast report write test cases and execution test cases

Environment: Informatica 8.6, Informatica Data Validation Option (DVO), SQL, PL/SQL, DB2, ALM, Oracle 11g, TOAD, XML, Putty, Quality Center (HP) 10, MS Visual Studio, Cognos 10, SQL Server 2008, Windows XP, OBIEE, people Soft, UNIX.

Confidential

ETL Tester

Responsibilities:

• Responsible for study/analysis of Business Requirement Documents and Application Design Document and develop test cases on these requirement
• Presented in stand up meeting with business people, story huddle and other meetings for the updates, suggestion, comments to improve the velocity and refinement in QA Testing Approach
• Prepared test cases to validate data for flat file, landing and staging table and the target table
• Written several complex SQL queries for data verification and data quality checks
• Create scenarios and test cases to test the load data in data warehouse
• Prepare test plan, test cases and test execution in HP
• Reviewed and executed test cases written based on the Change Request Document
• Effectively coordinate with the development team for closing a defect
• Prepared test scenarios by creating mock data
• Perform defect tracking and reporting with strong emphasis on root-cause
• Tested data migration to ensure that integrity of data was not compromised
• Used Quality Centre (HP) ALM as defect tracking tool
• Analysis and data digging using SQL to find root cause of defects
• Prepared showcase to business/ client to make sure test is as per the business requirement
• Provided the management with weekly QA documents test metrics, reports, and schedules.
• Testing data from source to Landing, Staging and Target table
• Checked end to end testing
• Verified ETL processes to load data in data warehouse
• Verified logical and physical data flow models for ETL applications.
• Translate data access, transformation and movement requirements into functional requirements and mapping designs

Environment: Oracle 10g, Informatica 8.1, HP Quality Centre, SQL, PL/SQL UNIX, Session Log files, Flat files, XML files, Teradata, SQL Assistant, Micro Strategy

Confidential

ETL Tester

Responsibilities:

• Analyzed the requirements of the client and developedtest cases based on SIT
• Prepared test data for positive and negative test scenarios for data migration and business intelligence
• Verified and executed session logs to identify the ETL process
• Created test cases, traceability matrix based on mapping document and requirements
• Written several complex SQL queries for data verification and data quality checks
• Reviewed and executed test cases written based on the Change Request Document
• Preparation of system test results after test case execution
• Tested theETLData Stage mappings and otherETLProcesses (DW Testing)
• Effectively coordinated with the development team for closing a defect
• Used HP Quality Center as defect tracking tool
• Extensively used Oracle database to test the data validity and integrity for data validation.
• Validated the flat files, header, column, count record
• Done data validation for the OBIEE / Micro Strategy reports.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.

Environment: Oracle 11g, Data Stage, RQM, Clear Quest, SQL, UNIX, Session Log files, Flat files, XML files, DB2, Compare IT, OBIEE, SQL Server 2008, and TOAD.

Confidential

ETL QA/SQL Backend Tester

Responsibilities:

• Extensively worked with the Business Analysts and development team in understanding the requirements and participated in H walkthroughs
• Collected requirements and tested several business reports
• Developed Traceability Matrix of business requirements mapped to test scripts to ensure any change Control in requirements leads to test case update.
• Used Quality Center to create manual (IEEE format) and automated tests, build test cycles, run tests and report and track defects in HP Quality Centre
• Written test cases for ETL to compare source and target database systems and check all the transformation and business rules
• Assisted in kicking off Informatica ETL jobs using UNIX and analyzed the data in dimension and fact tables
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files
• Involved in installation of Business Objects XI R2 and assisted in creating users and assigning them appropriate access rights
• Tested several dashboards and deployed them across the organization to monitor the performance
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing
• Experienced using database query tools such as TOAD for Oracle, TeradataSQL Assistant for Teradata and WinSQL for DB2 and SQL Plus
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications

Environment: Quality center (HP), Windows XP, Linux, SQL * Plus, Oracle 10g, DB2, TOADV2R6 Teradata, SQL Assistant 6.0, Informatica, ER Studio, Unix