We provide IT Staff Augmentation Services!

Test Lead, Sql Developer Resume

5.00/5 (Submit Your Rating)

Austin Tx, J

PROFESSIONAL SUMMARY

  • 8+ years of professional experience in Software Quality Assurance, Manual and Automation testing of Web based, Client - Server applications running on UNIX and Windows Platform.
  • Expertise in Software Test Life Cycle Methodologies and validations to ensure the Quality Assurance Control.
  • Expertise in Manual and Automated testing which includes writing Test plans, Test cases/scripts using Testing tools like Quality Center, Quick Test Pro (QTP) and Selenium Webdriver
  • Extensively worked on Database Testing for Credit Risk Applications Database
  • Expertise in GUI, back-end, Functional, Webservices and Automation testing
  • Excellence in database validation and testing using SQL Queries
  • Expertise in testing life cycle (TLC) phases which includes Planning, Test Planning, Defect tracking and Reporting
  • Expertise in using test management tools like Quality Centre/ALM, Silk Central Manager and Ap Test Manager

TECHNICAL SKILLS

Platforms: Windows, UNIX, MAC

Languages: C, JAVA

Query Languages: SQL

Markup Languages: XML, JSON

Scripting Language: VB

Databases: Oracle, SQL Server

Tools: Selenium Webdriver, TestNG, SOAP UI, Eclipse, QTP, Quality Center, Ap Test Manager, Perforce, VSS, Toad, Silk Central, JIRA, ITAA, Toad, IBM BPM, Process Designer, IBM Process Portal/Center, SQL Developer, Rally

Products: Amdocs CRM (Clarify), AMSS, OMS, Confidential, Salesforce CRM, IBM BPM

PROFESSIONAL EXPERIENCE

Confidential, Austin TX 

Test Lead, SQL Developer

Responsibilities:

  • Create and maintain UFT scripts for Workflow APIs smoke testing
  • POC for physical DM(DataModel) design, implementation and for any Database changes(as SQL Developer Role)
  • Create the Logical DataModel diagrams for the SMC Database using Oracle DataModeler as part of iteration deliverables to client
  • Test the REST API’s using SOAP UI and validate the webservices using Database, IBM Process Designer and Process portal/center
  • Perform System testing on the Confidential SMC(Staff Management Center) portal to ensure the quality as per the requirements
  • Validate the SMC portal integration with the BPM API’s(REST) and verify if the workflow is working correctly
  • Perform end-to-end database testing for new functionalities/modules using SQL developer
  • Create test cases in QC and perform functional, integration tests for each test cycle
  • Report defects in QC and do a IA after every cycle to reduce the regression defects
  • Discuss the defects with developers and track the defects to closure
  • Run the workflow APIs smoke test scripts for any new build provided

Environment: UFT 12.2, IBM BPM, Process Designer, Process Portal, QC, SOAP UI 5.0, Mozilla Firefox, Internet Explorer 8, Notepad ++, SQL Developer Data Modeler, SQL Developer, Rally, Oracle, DB2

Confidential, Weehawken, NJ

Test Analyst

Responsibilities:

  • Core QA member to test various functionalities, perform End-to-End Database testing
  • Perform data validations between source system tables and ZEUS system, and to validate the calculated exposures exposed to front end application(IRIS)
  • Maintain and execute Business Readiness Tests(BRT) using QTP/QC, which is key during production deployment for different applications
  • Develop macros to automate the DB testing, to ease the manual effort on regression/data driven testing
  • Have created a data driven framework with excel VBA for DB automation, which has been reused for different projects to help on regression, data driven testing
  • Work closely with the client to validate the implementation with a walkthrough of QA test scenarios, results before every release and obtain the sign-off on the same
  • Have created test scripts for Cross Browser testing using Selenium Webdriver, Java, TestNG for some business flows used as part of Smoke Testing during release activities
  • Have created the Page Object Oriented framework for cross browser test automation using Selenium

Environment: Toad, Quality Center (QC), QTP, Windows, IE7, Selenium Webdriver, Firefox, Chrome, Test NG

Confidential

Test Analyst

Responsibilities:

  • POC for offshore automation team with a group of 2members.
  • Provide automation estimates for each sprint and assign tasks based on the capacity - Agile methodology
  • Automate Salesforce CRM which is integrated with SII app using QTP and ITAA framework( Confidential Test Accelerator Tool)
  • Create Test Scripts for different functionalities across Salesforce CRM using QTP
  • Working on Web Services Automation using QTP and test various Web Services & their methods.
  • Execute the test scripts with QTP and report defects if any
  • Send the project automation test status to the client

Environment: QTP, Salesforce CRM (Web), Quality Center (QC), ITAA, Windows, IE7

Confidential, Dallas, TX

Responsibilities:

  • Running smoke test and environment checker via QTP and prepare status report.
  • Involved in End-to-End testing,UAT for the Production Environment during the ASR releases.
  • Allocate scenarios to team members
  • Execute test cases in QC manually for the new functionalities
  • Create automation test scripts with QTP and add them to the regression pack
  • Run the regression automation pack in every iteration to ensure that the existing functionalities are working fine
  • Perform defect management; drive defects to closure by taking complete ownership for the defects raised.
  • Raise CR’s for any issues encountered during Shakeout testing in CQ.
  • Take decision whether any failure in execution requires defect or not
  • Update executive summary for every scenario Confidential the end of the shift
  • Work on RCA for closed as well as for cancelled defects for each ASR.
  • Handled another project alone, Confidential &T LS-PSE EF, for requesting/monitoring/back out the emergency fixes and work with Infra team, and ensure the fix is available for testing

Environment: Quality Center(QC), Toad, SQL Plus, QTP, Clear Quest, CRM-Clarify, AMSS, OMS, Oracle

Confidential, Philadelphia, PA

Responsibilities:

  • Involve in IVP(Internal Verification Procedure) - similar to smoke testing or BIT/BAT, ensuring the stability of the build.
  • Record and track issues logged into the defect-tracking system, JIRA.
  • Manual execution and review of test cases (Maintenance, CORE).
  • Authoring/Updating the test cases for the new functionalities.
  • Involve in Functional, GUI, Installation, System Integration, Regression, Smoke and Maintenance testing
  • Perform accessibility testing standards using JAWS and firefox accessibility extension
  • Installation/Updating of test builds and performing Installation Testing (Windows/Unix/Solaris).
  • Setup and Maintenance of test servers on a daily basis.
  • Involved in NERV Testing for tracking the quality and the status of the issues logged by the team.
  • System Integration Testing by integrating Academic Suite with Vista/CE4 products.
  • Create automated test scripts with QTP, VBS in Hybrid framework for the regression test cases
  • Update and maintain the regression test scripts
  • Execute the regression test scripts during every cycle and verify for any defects

Environment: Perforce, VSS, JIRA, Silk Central Manager/Client, DB Visualizer, Oracle, SQL Server, JAWS, Web Scrab, IE, FF, Safari, Google Chrome, QTP 10

Confidential

Responsibilities:

  • Involved in authoring and reviewing the test cases/test scripts based on the specifications.
  • Playing as POC/SME for eCommerce functionalities and leading a team of 6 members.
  • I am instrumental for Confidential Enviserv Transaction System Installation on Windows/Unix/Solaris environments.
  • Perform accessibility testing standards using JAWS and firefox accessibility extension
  • Manually execute the test cases and also review the test cases.(Maintenance, CORE).
  • Involved in functional, GUI, Installation, Integration, Regression, Smoke and maintenance testing.
  • Involved in NERV Testing for tracking the quality and the status of the issues logged by the team.
  • Record and follow-up of issues logged into the defect-tracking system, JIRA.
  • Prepared user guide and trouble shooting document for testing e-Commerce Functionality, giving insights on its functionality.
  • Taken initiative in Installation of the Enviserv Bb Transaction System and its documentation.

Environment: Perforce, VSS, JIRA, Quality Center, Clear Quest, Selenium IDE, Oracle, SQL Server, JAWS, Windows, Unix

Carnegie Learning

Confidential

Responsibilities:

  • Has undergone training on Software testing for manual and automation testing using QTP.
  • Have written the manual functional test cases in excel sheets on the basis of the application, Carnegie Learning.
  • Manually execute the test cases and draft the defects against a standard template.
  • Automated few basic flows of the application using QTP/VB scripting and learnt to code using QTP scripting.

We'd love your feedback!