Senior Quality Assurance Consultant Resume
Franklin Lakes, NJ
Professional Summary
- 6+ years of experience in Quality Assurance in various capacities in the role of Quality Assurance Consultant.
- Expertise inBlackbox Testing includes Functional, System, Integration testing, Usability and Regression testing of Client Server and Web Based applications.
- Strong knowledge of Software Development Life Cycle, Software Testing Life Cycle and Bug Life Cycle.
- Expertise in developing Test strategies, Test scripts, Test cases, Test plans, Test procedures and testing standards
- Extensive experience in Automated Testing Quick Test Professional (QTP) tool.
- Quick Test Professional (QTP) automation includes Test Plan preparation, Test Automation script development, Debugging the Test script, Functionality & Regression Testing, Analyzing the test results.
- Experience using Weblogic for deployment purposes.
- Expertise in backend Database testing for applications developed with Microsoft SQL Server usingMS SQL Server and SQL Developer
- Good knowledge of database concepts-data integrity, constraints, transaction process systems, validity etc.
- Proficient in usingTest DirectorandQuality Center (9.0 and 10.0)for reporting and tracking software defects managing automation resources, executing automation tests from QC and saving the results in QC.
- Experienced in Monitoring Application servers, Web servers and Database server.
- Experience in grey box testing.
- Experience in UNIX Shell Script, Oracle PL/SQL andMS SQL.
Technical Skills
- Platforms: Windows 9x/NT/2k/XP, LINUX, UNIX.
- Database: Oracle 10g ,Sybase, MS SQL
- Languages Dev Env: VB .NET ,ASP .NET , C# , Java ,J2EE
- Automated Test Tools: Mercury QTP 9.2, 10.0, UTP
- Other Tools: Mercury Quality Center 8.0,TestDirector, tkdiff
- Scripting Language: VB Script,UNIX Shell Script
- Defect Tracking Tool: DETS| Front Office, Quality Center ,Bug at bank
- Application Servers: Weblogic 8.1 SP2, IIS,GetAccess
- Web Technologies: HTML, DHTML, XML
- Environment: CMM Levels, Agile
- Web Browsers: Internet explorer 8,7, Mozilla Firefox , Google Chrome
Education
Master of Computer Applications (M.C.A.)
Work Experience
Confidential,
Aug 2010- Till Date
Role: Senior Quality Assurance Consultant
Project: International Treasury Services
ITS is a comprehensive international payment and collection system used for processing international direct deposit payments to benefit recipients and both electronic and check payments to vendor, foreign payroll, and miscellaneous payment recipients. ITS.gov offers a government-wide common solution for issuing international payments in established and emerging markets worldwide.
Project: Shared National Credit Program
The SNC Program is a well-established interagency program with appropriate interagency coordination and documentation. The FDIC has a role similar to that of the other banking agencies in providing a periodic credit risk assessment of the largest and most complex credits held by insured financial institutions in the US.
Roles and Responsibilities:
- Performed smoke, system, regression, retesting of the various releases.
- Prepared and maintained traceability matrix for the various releases of the S/W.
- Performed compatibility and compliance testing of one release.
- Converting steps of Use cases into positive, negative test scenarios of Traceability matrix.
- Converting various requirements , mentioned in documents into test scenarios in Traceability Matrix.
- Preparing complex test data files before and during the release of S/W. Updating the test data file in coordination with development team.
- Involved in identify scenarios for regression and smoke testing and eliminating the regression test cases with course of time.
- Involved in back-end testing for the module – Asynchronous Data Transfer, of SNC Program and verifying mapping of various fields in data tables.
- Verified ETL process are copying the values in DB properly.
- Performed database testing of integrity constraints.
- Logged the bug at the internal software Bug@ bank. And updated the bug logged as required.
- Prepared complex SQL Queries in MS SQL Server 2007 for testing of different reports in SNC Program. Compare the gui values with the sql queries.
- Used inner joins, outer joins, left joins etc. to write SQL Queries for different business rules in reports.
- Used SSH Tectia Terminal to log in Unix Server and capture the error logs.
- Used UTP- internal automation tool to automate new , enhanced requirements of ITS.
- Executed UTP scripts at the virtual machine for major regression testing scenarios.
- Used HP mercury quality center for analyzing results failure.
- Used HP QTP to identify objects written in Internal tool UTP.
Environment: MS SQL Server, PL/SQL Win 2k/NT, Bug @ Bank,Jira,Oracle,Java.
Confidential,
Dec 2009- July 2010
Role: Senior Quality Assurance Consultant
Project: Product Configuration Management
This project was responsible for controlling Product life cycle or the SDLC process. It involved tracking new Product creations, Online Document creations, Release controls and Integration with TFS etc.
Responsibilities: -
- Prepare the testing documents as per the different phases of the testing.
- Preparing System, Regression, test cases, test scripts.Updating the test cases as required.
- Performed functional, Sanity,System,Integration,Regression,Retesting,End-to-End testing .
- testing the documented Test Cases.
- Shell Scripting and Code integration on Solaris.
- Developed and integrated monitoring and notification shell scripts on Solaris.
- Test Bed Set Up. Deploying various modules and various versions of modules on application server, Weblogic.
- Designed Regression Test Scenarios in co-ordination with QA and Development Teams.
- Wrote SQL queries to verify that data is being correctly stored in the database. Also used TOAD to insert/update data in tables to create different test scenarios.
- Used TOAD for making delta changes in the database.
- Verify data integrity, data constraints,data validity, data manipulation in the database.
- Testing of Procedure, triggers and functions.
- Checked outgoing data values from queries ,stored function and views.
- Used Mercury Quality Center 9.2 (QC)for Test Management .
- Used Mercury Quality Center for reporting,tracking,reviewing ,analyzing and generating Test reports.
- Tracked problems/bugs and fixes.
- Retest as needed.
- Maintain and update test plans, test cases and test environment.
- Used the BNY’S tool to verify the XML files output.
- Used VB Scripts to automate test cases in QTP.
- · Developed, Automated and Executed Test Scenarios using HP Quick Test Pro 9.5(QTP) features like Recovery Scenario Manager , Text Output value , object spy and Parameterization .
- · Used checkpoints and synchronization statements extensively to customize the Quick Test Pro(QTP) scripts. Parameterized the scripts and data driven them to improve the flexibility of the tests.
- Integrated the QTP with the Quality Center torun the scripts
Environment: UNIX, Win 2k/NT,Java VB Scripts, Web logic 9.2 ,Oracle, Mercury Quality Center, IIS, HTML
Confidential, Franklin Lakes, NJ
Dec 2008- Oct 2009
Role: SeniorQuality Assurance Consultant
PROJECT:Medcohealth.com
Confidential website can be used by registered members for various purposes like order prescription refills online,request a prescription renewal,Locate a pharmacy,Review prescription history,view and print your prescription expenses, transfer prescription from retail to mail.
Responsibilities :
- Prepare and updating test documents - test cases, test matrix, bug report etc. for different releases of the product
- Performed Functional testing -System testing, retesting and regression ,UAT etc to verify that the actual results are as per user requirements.
- Performed negative testing,
- Maintained and Upgraded test bed for different releases.
- Performed Database testing using SQL query analyzer and SQL Enterprise Manager.
- Performed regression testing to make sure that new functionalities are not impacting existing functionalities in the system.
- Performed follow-up testing to ensure that the defects have been fixed as per the Technical Specification Document.
- Setup the environment scripts in UNIX for LDAP.
- Used various commands of UNIX for checking status of LDAP.
- Used Quality Center to log and track defects.
- Created automation scripts in QTP 8.2 application.
- independently maintained and updated the scripts and automation entities (Object Repositories, Datasheets, Function Libraries, Reusable Actions) for new test scenarios.
- Involved in the upgrade from QTP 8.2 to QTP 9.0 .
- Managed and created scenarios for LoadRunner.
- Used LoadRunner to do performance testing of every release.
Confidential , USA
Client :AT&T, Atlanta
June 2005 - Aug 2007
Role: Quality Assurance Consultant
Project : Niku Clarity
Niku\'s Clarity provides the business portfolio planning, modeling and execution capabilities necessary for more informed decision-making organizations can manage the full portfolio lifecycle from investment selection to initiative delivery to results assessment -- all from within a single seamlessly integrated enterprise application.
Responsibilities:
- Designed and developed the High Level & Detailed Test cases using the quality standards.
- Created the test plan, test criteria and test cases.
- Developed the Test scripts for all the modules of the application using Mercury Quality Center.
- Utilized Mercury Quality Center as a test management tool for planning and executing Manual tests, and for defect reporting.
- Performed black box testing for the Application.
- Conducted regression testing, sanity testing and identified issues that may result from program modifications and escalated the issues as appropriate.
- Constructed SQL queries which are reusable and used that for Back End testing.
- Involved in Data comparison testing.
Environment: UNIX,,Web Logic, IIS, Oracle9i , Java Mercury Quality Center etc.
Confidential
March 2004-May 2005
Role: Quality Assurance Consultant
Project: Direcway
Direcway is an online application used for the purposes of distributing internet plan and packages to the various customers .
Responsibilities:
- Preparing test cases, test plan for different testing methods and phases .
- Maintain and update test plans, test cases, test environment, and testware through life cycle.Testing the documented Test Cases.
- Performed blackbox testing -Sanity,System,Integration,Regression,Retesting,End-to-End,User Acceptance (UAT )testing.
- Conducted Backend Testing by creating SQL queries to check data integrity, data constraints etc.
- Used DETS for Test Management and Defects tracking
- Test and Defect Status reporting to the Management.
- Implemented and automated regression test scripts based on business requirements using
- Winrunner.
- Used checkpoints and synchronization statements extensively to customize the Quick Winrunner scripts. Parameterized the scripts and data driven them to improve the flexibility of the tests.
- Used the Winrunner automation regression scripts and analyzing the results.
Environment: UNIX, Win 2k/NT, ASP .NET ,C#, VB.NET ,vb Script, Java, J2ee, Web logic,Oracle9i , Mercury Quality Center ,WebServices, SQL ,UNIX
Confidential
August 2003- March 2004
Role: Quality Assurance Consultant,
Project : Unified Testing Criteria for Java(TM) Technology-based Applications ("Java Applications") running on mobile devices utilizing the Java™ ME technology. It includes both MIDP 1.0, MIDP 2.0 and MIDP 2.1 and some additional JSRs included in different
manufacturers devices.
Responsibilities: -
- Monitored application behaviour during testing.
- Checked application compatability with handset devices.
- Performed user interface,locality,functionality,security testing , retesting, regression testing on the java applications running on handset devices.
- Used test director for defect management .
Environment: Test director,Java