Test Lead, Sql Developer Resume
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.
