Etl Database Tester Resume
Dallas, TX
PROFESSIONAL SUMMARY:
- Around Six years of experience in teh IT Industry as a QA Analyst / Tester and diversified experience in ETL & Manual Testing of Web and Client/Server applications in Travel, Health Care & Research domains.
- TEMPHas Good Experience in SDLC (Software Development Life Cycle) and its methodologies such as Waterfall and Agile.
- Proficient in analyzing Business Requirement Documents and Functional Requirement Specifications.
- TEMPHas Good experience in writing, documenting and updating Test Strategy, Test Plan, Test Scenarios, Test Cases and RTM.
- TEMPHas Good experience in writing Manual test cases for Functional, Regression, Integration, System, Smoke and Usability testing.
- Experienced in Functional, System, Integration, Regression and Data Ware House Testing(ETL)
- Knowledgeable in diverse database testing and equally experienced in writing SQL queries to retrieve data.
- TEMPHas Good Experience in using Defect Management tools like HP ALM (Quality Center 11.1) & JIRA.
- TEMPHas good experience in conducting Triage Meetings wif Business, Development and Test Teams.
- Accustomed to working wif teh PMO’s, Business Analysts to understand both Clients and Business Requirements as well an overall Project infrastructure.
- Have Good Knowledge of EDI transaction types.
- Having Good experience in generating Test Summary Reports and Defect Reports
- Highly analytical and innovative to improvise and implement new ideas as well as tweaking conventional methods.
- A Leader and equally a Team player to rise above any obstacles and also in delivering group efforts.
- A person of strong character to distinguish between prioritizing and stagnating efforts.
- Have strong communication and interpersonal skills.
TECHNICAL SKILLS:
Testing Tools: HP ALM (Quality Center 11.1) & JIRA
Operating Systems: Windows (95, 98, 2000, NT, XP)
Languages: C/C++, Java, HTML
Methodologies: SDLC, Agile & Waterfall
GUI Tools: Sql Developer, TOAD 10.5, Oracle Express 10/11g
Web Internet: HTML, DHTML, XML, VBScript, Java Script
Web Servers: Web Logic, Web Sphere, Windows 2000 server
Tools: MS - Office suite (Word, Excel, Project and Outlook)
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
ETL Database Tester
Responsibilities:
- Designed and developed Test Scenarios, Test Cases and Test steps for various Functional Requirements.
- Involved in Functional Testing of CS2 and ARD (Altea Reservation Desktop) Applications.
- Designed SQL queries to test different Test Scenarios from PES Application.
- Wrote complex SQL queries for test data set up in RDBMS-Oracle & DB2, backend database testing and ETL data flow.
- Performed Regression, Database Testing on PES application.
- Extensively used Defect Management tool for Defect Reporting & Tracking using QC.
- Participated in Daily Stand up Meetings wif teh required parties after defect analysis to prioritize defect resolution.
- Generating Test Summary Reports and highlighting teh Differed defects and known issues in teh report to make a decision on Go/No Go.
- Publishing teh Weekly Status report to teh customer on Test Status and highlighting teh issues to be addressed immediately.
Environment: PL/SQL, Quality Center, JIRA, Gate Reader, CS2, Amadeus, ARD, Altea, Java, TIBCO.
Confidential, Stamford, CT
Data warehouse Tester
Responsibilities:
- Involved in Requirement Analysis and raised queries to make teh requirements clear and understandable.
- Developed Data Warehouse Test Plan document to plan teh testing activities.
- Designed and developed Test Scenarios, Test Cases, and Test steps for various Business Services/methods covering both Positive and Negative testing requirements.
- Designed SQL queries to test different Test Scenarios from ELOQUA and Contact Dashboard.
- Involved in teh project from teh requirement analysis phase till teh completion of UAT (Entire Test Lifecycle).
- Wrote complex SQL queries for test data set up in RDBMS-Oracle & DB2, backend database testing, and data validation and ETL data flow.
- Developed a Requirement Traceability Matrix from Requirements to Test Scenarios and Test Cases.
- Developed Test Estimates for designing Test Scenarios, Test Cases and Test Execution.
- Performed Data ware House, Functional, Integration and Regression Testing.
- Performed Cross Browser testing using different browsers like IE 8, Firefox, Safari and Chrome.
- Defect Reporting & Tracking using JIRA.
- Participated in Triage Meetings wif teh required parties after defect analysis to prioritize defect resolution.
- Generating Test Summary Reports and highlighting teh Differed defects and known issues in teh report to make a decision on Go/No Go.
- Publishing teh Weekly Status report to teh customer on Test Status and highlighting teh issues to address immediately.
Environment: Windows 8, Java, SQL Developer, TOAD 10.5, ETL, Seibel, Oracle 11G, IE 8, Firefox, Safari, Chrome and JIRA and Quality Centre.
Confidential, Parsippany, NJ
QA Analyst
Responsibilities:
- Analyzed Business Requirement Specification (BRS) and Technical Design Documents (TDD).
- Attended BRD walkthrough meetings and raised Queries through Query Tracker to track till closure.
- Developed Test Strategy to develop an approach for testing.
- Developed Test Estimates for designing Test Scenarios, Test Cases and Test Execution.
- Designed and developed Test Scenarios, Test Cases and Test steps for various Business Services/methods covering both Positive and Negative testing requirements.
- Testing and cross-verifying teh reports using SQL queries.
- Developed a Requirement Traceability Matrix from Requirements to Test Scenarios and Test Cases.
- Performed System, Integration and Regression Testing.
- Defect Reporting & Tracking using HP ALM Quality Centre.
- Participated in Triage Meetings wif teh required parties after defect analysis to prioritize defect resolution.
- Publishing Daily Status Reports and Weekly Status Reports and addressing teh issues to teh Management for their attention.
Environment: Windows 8, Java, SQL Developer, TOAD 10.5, Oracle 10G, IE 8 and HP ALM Quality Centre.
Confidential, Cincinnati, OH
QA Tester
Responsibilities:
- Analyzed Business Requirement Specification (BRS) and Technical Design Documents (TDD).
- Attended BRD walkthrough meetings and raised Queries through Query Tracker to track till closure.
- Designed and developed Test Scenarios, Test Cases and Test steps for various Business Services/methods covering both Positive and Negative testing requirements.
- Developed a Requirement Traceability Matrix from Requirements to Test Scenarios and Test Cases.
- Performed Functional and Regression Testing.
- Completely involved in test management in Quality Center
- Defect Reporting & Tracking using HP ALM Quality Centre.
- Publishing Daily Status Reports to teh QA Lead.
Environment: Windows XP, Java, Oracle 10G, IE 7 and Quality Centre 9.1.