Post Job Free

Resume

Sign in

Qa Analyst Oracle Pl

Location:
Centreville, VA
Salary:
80k to 85k
Posted:
June 22, 2021

Contact this candidate

Resume:

Vasantha Apparaju

adnamo@r.postjobfree.com 703-***-**** U.S. Citizen

Profile

•QA Tester with 10+ years of IT experience, managed software testing in various industries with extensive experience in Business analysis, Software Quality Assurance and Maintenance of reporting environments.

•Experience in Software Development Life Cycle and Testing Methodologies from project definition to post-deployment documentation.

•Extensive exposure to data related projects with Healthcare, insurance and telecom industries that include hands on experience in building data sets and conditioning data for automation testing.

•Excellent knowledge of system integration testing, software testing methods, and performing 508 compliance test plans and test cases.

•Proficient in automated tools using Mercury Interactive/HP tools (Quick Test Pro, Win Runner, Test Director, Quality Center) Century Test Automation (CTA)) and Rational Tools ( Rational Clear Case, and Rational Clear Quest).

•Experience in testing data migration and applications upgrade projects with ETL and reporting tools.

•Experience as SOAP Web Services Tester and expertise in testing web services via SOAP, using the open source testing tool SoapUI.

•Ability to manage and track the requirements through Requirements Traceability Matrix.

•Experience in Defect tracking tools like Bugzilla, Jira, Test Director and Internal tools.

•Strong Experience in GUI Testing, Functional Testing, Regression Testing, Integration Testing, Compatibility Testing, Performance Testing and User Acceptance Testing.

•Motivated and hardworking individual with excellent organizational and time management skills with strong work ethics.

•Excellent analytical and problem solving skills.

Skills

PL/SQL, T-SQL, VB, C, C++, Java, JavaScript, VBScript, TSL, HTML, CSS, XML, Word, Excel, PowerPoint, and Visio, MS SQL Server, Oracle, MS Access, Informatica, Business Objects, MS-SQL Server Reporting Services (SSRS), QTP, Century Test Automation (CTA), Century Shield, Win Runner, ALM, SOAPUI, Test Director and Quality Center, Bugzilla, Jira, Test Director, SoapUI, Agile Scrum, Waterfall, Windows, MS-DOS, UNIX

Certificates and Training

CompTIA Security+ certified,

Brainbench Certified in Software Testing,

Brainbench Certified in WinRunner,

Quality Management (Quality Planning, Quality Assurance and Quality Control) training.

Education

PGDCA (Post Graduate Diploma in Computer Applications) August 2001

M.S (Master’s post graduate degree in Science) August 1993

B.S (Bachelors graduate degree in Science) August 1991

Experience

Senior Test Engineer Census Bureau Hillcrest Heights, MD Jul 2019 – Present

Wrote test plans, test scenarios, test cases and software documentation from business, technical and function requirements

Logged the defects with proper priorities and severities, analyzed and reported the defects using ALM.

Writing complex queries to validate the data as per the requirements in backend testing against Oracle database.

Modified and executed stored procedures to prepare the data for testing different test scenarios as required.

Developed queries for the applications as required and Coordinated with support team in providing the inputs to resolve the issues.

Environment: Oracle PL/SQL, ALM, UNIX.

Senior Test Engineer United States Patent and Trademark Office Alexandria, VA Jul 2018 – Jul 2019

Performed (508 compliant) verification testing by using WAVE tool.

Developed automated scripts using complex sql and oracle functions for testing in order to support the automation strategy.

Environment: Oracle PL/SQL, ALM,UNIX, RALLY, SOAPUI, Wave tool.

QA Analyst/Test Food and Drug Administration Silver Spring, MD Jan 2017 – Sep 2017

Coordinated with customers in gathering the requirements and prepared and executed test plans, test cases and test automation scripts.

Investigated and resolved technical issues in the QA environments and communicated issues with various departments.

Provide technical analysis and QA related design for migrating the in scope assignments from DARRTS to panorama.

Worked on open assignments in the following applications: NDA/BLA Original, Efficacy supplement, Labeling supplement, and OND owned Manufacturing supplement submissions in pending status

Environment: ALM, Jira, Oracle PL/SQL 9i/10g, Sharepoint, Informatica, Java

App Support Functional Tester Accenture Federal Services Washington DC Aug 2015– May 2016

Developed input test data, executed test scripts, maintained and prioritized issues using Test Director, Team Track, and Remedy applications

Peer reviewed other team members’ test scripts and worked with the development team to resolve all the issues that occurred during the testing process.

Communicated the status, risks, and issues to team lead in a timely manner to minimize the impact on the delivery schedules and produced high-quality deliverables

Environment: QTP, ALM, Jira, Oracle PL/SQL 9i/10g, UNIX HP/Solaris, Informatica, Java

QA Analyst/Tester Quality Software Services, Inc. (QSSI) Columbia, MD Oct 2014 – July 2015

Logged the defects with proper priorities and severities, analyzed and reported the Defects using ALM (Application Life Cycle Management).

Involved in end to end testing from account creation to enrollment in health plans which included writing test plans, executing test scripts and writing defect reports for issues encountered during the testing process.

Performed Functional/Regression testing, Unit testing, Integration testing and User Acceptance testing.

Environment: QTP, ALM, Jira, Oracle PL/SQL 9i/10g, UNIX HP/Solaris.

QA Analyst/Tester Verizon Philadelphia, PA Nov 2011 – July 2014

Developed, executed and verified test plans, test cases and test automation scripts and created QA Project Plans for all phases of the Life Cycle for Resources located in India.

Coordinated with customers in gathering the requirements and worked with management to plan, schedule, execute and deliver high quality solutions.

Reported the defects through Quality Center and documented the successes and failures of all executed test procedures.

Environment: CTA, Century Shield, Century Gateway, JIRA, SQL Server, Share point, Java2.0, Windows XP.

Senior Analyst QA Nationwide Children’s Hospital (NCH) Columbus, OH Sep 2009 – Jul 2011

Developed and executed various end-to-end scripts using QTP for automated testing of each individual Functionality & Regression Testing of the applications.

Analyzed user requirements, prepared test plans and test cases, and utilized SQL queries to test the backend database.

Executed the Automated and Manual Test Cases, reviewed the defects, and documented test cases corresponding to business rules and other operating conditions in Test Director.

Environment: Quality Center, Test Director, Win Runner, QTP, Oracle 10g, BOXI 3.1, MS SQL Server 2005, Manual Testing

QA Analyst /Tester Geico Bethesda, MD Sep 2007 – Jul 2009

Analyzing the Business Requirements, Functional Specification and Design Documents.

Involved in Functional Testing and Regression testing by using Mercury Automation tool QTP.

Creating, executing, coding and enhancing the Automation test scripts using QTP

Uploading the Manual and Automated Functional Test Cases into Test Plan Tab in the Quality Center.

Mapping the Test Cases from Test Plan Tab to Test Lab Tab under Quality Center for Execution.

Performed Regression testing for the various modules of the application and Preparation of Defect Summary report and Daily Status reports.

Developed scripts for the applications as required. Coordinated with support team in providing the inputs to resolve the QTP issues.

Reported defects through Quality Center.

Environment: Quality Center, Test Director, WinRunner, QTP, ASP.NET, HTML, MS SQL Server, Manual Testing



Contact this candidate