We provide IT Staff Augmentation Services!

Sr.oracle/etl Tester Resume

2.00/5 (Submit Your Rating)

West Des Moines, IA

SUMMARY:

  • 8 years of experience in the field of Software Quality Assurance, manual and automated testing.
  • Good Knowledge on Test Management Tools like HP ALM.
  • Extensive experience in implementing QA Methodologies, Test Strategy, Test Plan, Test Scenarios, Test Cases and Test Deliverables for various applications to ensure proper business compliance.
  • Good Expertise in Financial, Insurance and Health Care Domains.
  • Proficient in all Forms of Testing: Black Box, Integration, System, Acceptance, Regression, Functional, Compatibility and Negative Testing.
  • Good Expertise in VB Script and Automation infrastructure Development.
  • Experience in conducting Parameterization/Data - driven testing for both Web-based applications and Windows Applications in a Client-Server environment.
  • Worked closely with development and Technical Support teams to resolve quality issues.
  • Experience in executing SQL queries in order to view successful transactions of data and for validating data.
  • Good interpersonal skills, commitment, result oriented, hard working and possess excellent analytical skills with good communication and self-organizing skills, assertive and a committed team player.
  • Authorized to work in the US for any employer

WORK EXPERIENCE:

SR.Oracle/ETL Tester

Confidential, West Des Moines, IA

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases
  • Tested New Features and their impact on existing functionality before each release.
  • Created Invoices using oracle application in R12
  • Creating Traceability between Business Requirements and Test cases using HP ALM.
  • Attending stand up meetings on regular basis.
  • Conducted source to target data mapping.
  • Identified defects and errors in data prior to data processing.
  • Mitigated existing issues and provided solutions.
  • Collaborated with back end and database testers.
  • Performed data validation testing writing SQL queries.
  • Checked the data flow through the front end to backend and used SQL queries, to extract the data from

Environment : HP ALM, MS Office, Agile, Oracle R12, SSMS, SQL, Windows 7.

Sr. QA Analyst

Confidential

Responsibilities:

  • Tested New Features and their impact on existing functionality before each release.
  • Conducted Functionality testing during various phases of the application.
  • Created Test cases from Business Requirement, Functional Requirements & UI using Test Track Pro
  • Experienced in working Agile model.
  • Takes care of Functionality, Regression and Integration testing of the application using Black Box.
  • Creating Traceability between Business Requirements and Test cases using Test Track Pro.
  • Attending stand up meetings on regular basis.
  • Involved in testing application monthly releases.

Environment: Test Track Pro, MS Office, Agile, ALM, Windows XP, Win 7.

Sr. QA Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Developed Test Plan, Test cases, Test Scenarios, expected results and prioritized tests
  • Wrote test cases, test conditions and test scripts in MS-Excel and exported to Quality Center
  • Tested New Features and their impact on existing functionality before each release.
  • Conducted Functionality testing during various phases of the application.
  • Executed the test cases and compared the expected results with actual results
  • Involved in Test case review meetings and requirements walkthroughs.
  • Executed Test cases on different OS and browser combination (Cross Browser Testing)
  • Worked on onsite/offshore model coordinating with team members.
  • Performed various types of testing including functional, system integration, smoke, adhoc and Regression testing for the release
  • Validated the Cash Transaction when the echecks are deposited
  • Validated the account based on the cash transaction.
  • Validated the customer information front end and backend.
  • Documented problems found during test on the Quality Center system and communicated recorded problem to the responsible QA Manager.
  • Involved in maintenance releases for third party applications.
  • Tested application on Mac OS(Safari), Windows XP, Vista, Win 7.
  • Prepared application workbook for the beneficial of newly joined team member.

Environment: Quality Center 10.0, MS Office, ACH, Payments, Online Banking, Windows XP, Win 7, Vista, Mac.

Sr. QA Analyst

Confidential, Charlotte, NC

Responsibilities:

  • Tested New Features and their impact on existing functionality before each release.
  • Conducted Functionality testing during various phases of the application.
  • Checked the data flow through the front end to backend and used SQL Queries, to extract the data from database.
  • Ran manual tests in QC and "passed" them in the "Test Lab"
  • Exported test cases from Excel and requirements from MS Word to Quality Center.
  • Created re usable Business process testing(BPT) components in Quality Center.
  • Validated date checks to test Trade dates and Settlement dates for designated transactions.
  • Used Quality Center to develop test cases, and executed them in test lab.
  • Performed the data validation to meet all test condition requirements.
  • Wrote SQL commands extensively to check for integrity of data.
  • Experienced in Agile technology with Scrum.
  • Analyze, test and contrast HP ALM Quality Center 11
  • Takes care of Functionality, Regression and Integration testing of the application using Black Box.
  • Extensive experience in Back-end testing using SQL Queries.
  • Wrote SQL commands extensively to check for integrity of data.
  • Documented problems found during test on the Quality Center system and communicated recorded problem to the responsible QA Manager.
  • Performed review activity for test cases, UAT test cases, test scenarios, functional specifications and automated test scripts

Environment: Quality Center, QTP, MS Office, Agile, SQL, VB. Net, XML, UNIX, HTML, and Vb Script, Windows XP.

Sr. QA Analyst

Confidential, Chesapeake, VA

Responsibilities:

  • Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, Detailed Design Documents and Requirement Matrix.
  • Regularly interacted with Developers to discuss various problems and issues.
  • Involved in entering requirements, developing test plan tree, designing the test steps, writing test cases and running test scripts using Test Management Tool Quality Center.
  • Exported test cases from Excel and requirements from MS Word to Quality Center.
  • Prepared quick test planning with Test Strategies, test schedules, build acceptance, data preparations and UAT for Production Support Issues.
  • Enrolled members through online screens and 834 Transactions to Facets.
  • Modified the 834 file and then checked if the eligibility enrollment is properly loaded onto Facets.
  • Processed 837P, 837I and 837D transactions, verified those 837 transactions were converted correctly to XML file format and verified the claims data loaded to Facets for further processing.
  • Worked with Accumulators, Deductibles, Coordination of Benefits, Overrides of the Claim Line detail and used them for testing various claims scenarios in Facets.
  • Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
  • Checked the data flow through the front end to backend and used SQL queries, to extract the data from database.
  • Experienced in Agile technology with Scrum.
  • Used Built in functions of VBScript extensively.
  • Conducted Data Validation checks by comparing the UAT backend Database and the Production Database (this was done when the UAT database was updated and almost in synchronization with the Production database)

Environment: Quality Center, MS Office, Facets, UNIX, VB Script, SQL, XSD, Java, Microsoft Project.

Sr.QA Analyst

Confidential, Oklahoma City, OK

Responsibilities:

  • Involved in different phases of Software Development Life Cycle.
  • Responsible for analyzing Business Requirements and development specifications in order to create and execute test plans.
  • Develop detailed test plans from use cases and develop test cases for functional, integration, system testing, Security testing, Regression and user acceptance testing.
  • Defining the testing process for white box and Black Box testing.
  • Created and executed data driven test scripts in QTP.
  • Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP.
  • Applying security (controls that grant or limit a user's access to particular menus and functions in an application, controls that limit the data that a user can see or update)
  • Performed review activity for test cases, UAT test cases, test scenarios, functional specifications and automated test scripts.
  • Performing Security testing of the basic security levels in the Client Link application security mechanism.
  • Used SQL commands extensively to check for integrity of data.
  • Extensive experience in Browser Compatibility Testing using Fire Fox and Internet Explorer.
  • Attended meetings with developers in resolving the defects.
  • Extensive experience in Back-end testing using SQL Queries.
  • Involved in Security Testing of Website.
  • Conducted End to End and Black Box testing.

Environment: Quality Center, Quick Test Pro, SQL, VB.Net, VB Script, HTML, MS Office, Java.

Sr.QA Analyst

Confidential, New York, NY

Responsibilities:

  • Involved in gathering Business Requirement, studying the application and collecting the information from developers and writing the test plans.
  • Responsible for the creation and execution of manual/automated test scripts QTP.
  • Review test assignments, develop test plans and scripts, and conduct tests as assigned.
  • Application was updated twice a week, so that all the Test Procedures created as Baseline can be played back to perform Regression Testing.
  • Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP.
  • Tested application security features, including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels
  • Created User Defined Functions in QTP.
  • Used Parametrization for using various data to test the application using QTP.
  • Checked the data flow through the front end to back end and used SQL Queries, to extract the data from the database.
  • Verified and Validated the Automated Test script
  • Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing, Integration Testing, batch Testing, unit testing and Smoke testing of the Application, its interfaces and Client-Server Utilities using QTP.
  • Extensively used to SQA site check to track down the bugs in Web application.

Environment: Quality Center, QTP, SQL, MS Word, MS Excel, Windows NT.

We'd love your feedback!