SUMMARY:

• Over5+ years ofexperience inIT industry, ETL testing and data warehousing applications.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience inIntegration, Functional, Regression, System Testing, Load Testing, UAT Testing,Black BoxandGUItesting.
• Experience in Web based applications like online banking, transactions applications.
• Experience inSQLandPL/SQL scripting
• Created ETL test data for all ETL mapping rules to test the functionality of theInformaticagraphs.
• Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Experience in creatingTest Readiness Review(TRR), Requirement Traceability Matrix(RTM)documents.
• Experience in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writingTest Scriptsby decomposing Business Requirements, and developingTest Scenariosto support quality deliverables.
• Experience inAutomationusingMercury Interactive Toolssuch asWin Runner, QTP, Load Runner and Test Director.
• Experience in usingBugzilla,Test DirectorandHP Quality Ce ntrefor Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolvingDefects,presenting theDefect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testingRDBMSsuch asOracle,MS SQL ServerusingSQL,PL/SQLfor data integrity.
• Experience in Reports testing in Crystal Reports XI Environment.
• Strong working experience inWindows NT/2000/XPandUNIXenvironments
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux

Languages: C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting

Testing Tools: HP ALM

Bug Reporting: HP ALM, JIRA

Databases: Oracle 11g, SQL Server 2012

ETL Tools: Informatica 9.6

Database Tools: TOAD, SQL Developer

Web Design: HTML, XML, Java, J2EE, JSP, ASP JavaScript, AJAX, VBScript

App Servers: BEA Web logic, JBOSS, IBM Web sphere, IIS, JWS, PWS

Reporting Tools: SSRS

PROFESSIONAL EXPERIENCE:

Confidential, CT

ETL tester

Responsibilities:

• Analysis of the business requirement and identifying the Gaps between FSD and BRD
• Participating in Scrum Ceremonies (DSU, Sprint Planning, Sprint Review, Grooming and Retrospective meetings)
• Worked withBusiness Analyststo define testing requirements to satisfy the business objectives.
• Responsible for creating completetest cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience inSDLCand Agile methodologies such as SCRUM.
• Analyzing requirements and creating and executing test cases
• Test Case Execution andAdhoctesting
• Performed Integration, End-to-End,systemtesting.
• Involving inFunctional Testing & RegressionTesting
• Involving in writing complex SQL queries to verify data from Source to Target
• Performed data validation testing writingSQLqueries.
• Written complex queries inSAStool check the data from Source and Target.
• UsedTSYSto update the accounts status.
• Using HPALMfor storing, maintaining the test repository, bug tracking and reporting
• Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Environment: Informatica 9.6, HP ALM, DB2, Oracle, SQL, SQL*Plus, UNIX,Quick Test Pro

Confidential

ETL tester

Responsibilities:

• Worked withBusiness Analyststo define testing requirements to satisfy the business objectives.
• Responsible for creating completetest cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience inSDLCand Agile methodologies such as SCRUM.
• Analyzing requirements and creating and executing test cases
• Test Case Execution andAdhoctesting
• Performed Integration, End-to-End,systemtesting.
• Involving inFunctional Testing & RegressionTesting
• Involving in writing complex SQL queries to verify data from Source to Target
• Performed data validation testing writingSQLqueries.
• Written complex queries inSAStool check the data from Source and Target.
• UsedTSYSto update the accounts status.
• UsedTSYSmainframes, for posting payment transactions for the card member to get enrolled by posting the monthly fix pay amount.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Using HPQuality Centerfor storing, maintaining the test repository, bug tracking and reporting
• Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Environment: HP Quality Center, DB2, SAS 9.3, Oracle, SQL, SQL*Plus, UNIX,Quick Test Pro

Confidential

Software Engineer

Responsibilities:

• Understanding the requirements and functional specifications of the application.
• Participated in identifying the required test scenarios
• Prepared and executed test cases as per system requirements
• Involved in preparing test strategy report
• Performed various black box testing methodologies like functionality testing, compatibility testing, database testing, usability testing, regression testing
• Extensively performed Manual Testing process to ensure the quality of the software.
• Involved in ETL testing activities like Count validations\data validations
• Extensively used various transformations like Filter\Router\lookup\Normalizer\Source Qualifier transformations.

Confidential

Software Engineer

Responsibilities:

• Analysing the requirements from the client
• Participating in preparing test plans
• Preparing test scenarios
• Preparing test cases for module, integration and system testing
• Preparing test data
• Analysing the test cases prepared by other team members
• Executing the test Cases
• Defect tracking
• Involved in preparing test strategy report
• Preparing summary reports