QA

Geeta Sharma

** ******* ***** *** ***

Baltimore, MD 21201

Contact No: 410-***-**** (cell)

SUMMARY:

Having 6 plus years of Quality Assurance Analyst IT experience, domain knowledge with Financial, Insurance, Investment and Health Care industries in web based systems and application based traditional client server architecture.

Experience in System Analysis and Design over complete system development life cycle process using industry standards in SDLC methodologies.

Good knowledge in Business Analysis, requirement gathering, interviewing stakeholders including writing detailed business requirements, segregating functional and non-functional specifications, and maintaining appropriate documentation including use cases and producing system design documentation.

Experience in software quality Assurance and Software testing including manual and automated testing of financial business software applications.

Excellent logical skills for understanding and developing system workflows and well suited for communicating with both technical and functional professionals

Extensive knowledge of QA methodology, standards, standards and procedures such as creating Test Strategy, Test Plans, test cases, test scripts generation for regression and user acceptance testing.

Specialized in analyzing the functional specifications and writing detailed test plans, test cases, execution of test scenarios, analyzing the actual results with the expected results.

Creation of test data and Automation of test cases for system and analyzing bug tracking reports.

Excellent knowledge in Load/stress testing and expertise with Load Runner, VUGen, Controller and Analyzer.

Strong Skills in using testing methodologies and Functionality Testing, Integration Testing, System Testing, Business Function Testing, Performance Testing, Stress testing and Configuration Testing.

Extensive working knowledge of Front end GUI, End to End and Back-End testing.

Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.

Extensively involved in Back end Database testing using ORACLE, DB2, PL/SQL AND MS SQL.

Extensive experience in Oracle Back-end (server-side) PL/SQL Packages, Stored Procedures, Indexes, Functions & Triggers using SQL Developer and Toad development tools.

Design, development, implementation of automated functional testing strategy with HP suite (Quick Test Pro, Load Runner, Quality Center), Rational Suite (Test Manager, Clear Quest, Clear Case).

Comprehensive understanding of Quality Center Defect Module, which supports the entire defect lifecycle from initial problem detection through fixing the defect and verifying the fix.

Experienced in understanding data modeling concepts, TOAD, SQL, creating XML data and working knowledge of XML.

Highly experienced in testing on cross platforms e.g. HP Unix/Oracle, Windows, MS SQL, Java, UNIX, XML, Oracle and data modeling.

Successfully implemented Automation Frameworks (Data driven, Keyword driven & Modular) for QTP.

Used Win runner, Quick Test Professional for Automating test scripts for regression suites.

A true team player that believes in creating open communication channels among team members, client, vendors and system owners. Kept system business owners and program manager updated with project progress status reports.

TECHNICAL SKILLS:

Operating System: Windows NT, 2000, 98, 95, Unix Sun Solaris.

Application Server: BEA WebLogic, IBM WebSphere, MTS Server.

Server S/W: Apache Webserver, Microsoft IIS, IBM WebSphere Commerce Suite (v4.1), Web Logic.

Software: DICOM, J2EE (Servlets, JSP, JDBC, EJB, Swing, JavaBeans), Swing, Applets, C, C++, VC++, COBOL.

Middleware: JMS, Java RMI, COM/DCOM, Corba using Visibroker.

Scripting Languages: HTML, Java script, XML, XSL, DHTML, Shell scripting.

RDBMS: Oracle, SQL Server, and DAO.

S/W Tools: Sun Forte, Visual Age for Java, Visio 5.0, Microsoft Project, Symantec Visual Café, FrontPage 2000, Microsoft Office Tools.

Libraries: IAP Libraries (Image Access Process Library), Rouge Wave Libraries, and MFC.

QA Tools: QTP, LoadRunner, Quality Center, Test Director and Winrunner.

Other Tools: RequisitePro, RationalRobot, Visual Source Safe, RationalRose (UML), System Architecture, STP (Software through Pictures), OOPS (Object Oriented Programming Structure), Clear case, Clear quest SQA.

PROFESSIONAL EXPERIENCE

Client: MetLife Insurance, NJ. April 2014 – June 2015

Role: Quality Assurance Tester

Worked on Mainframe’s Vantage –1 application for Retirement and Savings products, designed to cater to annuitants. It helps in creation of new annuitants; update Fund Transfers, Fund withdrawals, issuing payments to annuitants and helps in creation of reports.

Responsibilities:

Involved in developing Test Methodologies, Test Strategy, Test Plans and test cases, Design and developed the manual tests for Retirement and Saving products.

Analyzed system requirements specifications, developed Test Cases, and Test Data for manual testing of the functionality, GUI, Compatibility, performance, usability and User Acceptance of the application.

Created Test scripts and UAT test cases and coordinated with the UAT Team and Project manager and performed User Acceptance Testing with the Users.

Used the automated tool QTP for Functional Testing and Regression Testing.

Enhanced and modified the scripts according to the test case scenarios.

Used Automation of regression testing QTP by creating verification points e.g., objects data, object properties, window and image verification, database verifications for testing functional, acceptance and limit validations. Also inserting synchronization points.

Responsible for inserting checkpoints to verify the functionality of page, text string, XML and table objects.

Created batch scripts to automate the execution of the recorded scripts.

Executed the defined performance test strategy, performance test cases, load scripts and documented the issues and re-tested software fixes to ensure the issues are resolved.

Created test data for validating scenarios based on functional requirements specifications.

Performed extensive back end Database testing using complex SQL queries in toad environment.

Analyzed Load pattern and created test scenarios to emulate the real life stress conditions.

Developed Vuser scripts using Web (HTTP/HTML)

Created customized LoadRunner VuGen scripts at API level with manual correlation

Enhanced Vuser scripts by adding correlations, parameters, condition controls, and checking/validation functions

Involved in performance testing, stress testing and regression testing of the application after every release and bug fix. Analyze the Transaction Response time and finding performance bottlenecks using Load runner.

Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation.

Worked with Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.

Create and maintain Test Activity, Test Results, Test Summary and Defect Tracking reports.

Conducted integration testing, identified application errors, resolved issues through bridge calls.

Provided management with daily status reports.

Worked closely with cross-functional teams including Users, development, marketing, validation, and technical writing.

Coordinate with the administrator, CM, PM and testing lead for the precise scheduling of the test runs.

Assisted external clients during the UAT. Conducted and created reports at the end of the UAT test.

Participated in Defect Review meetings and Quality Assurance meeting

Created Test data according to different Scenarios to verify Reports.

Generated Change Requests for failed test cases and assigned them to responsible developers.

Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Vantage-1, IBM Mainframe, IBM AS/400, QTP, Load Runner, QTP, Team track, Quality Center, Clear case, Web testing, toad, PL/SQL, MS EXCEL, MS Word 2003, HTML, Quest Tools, Excel.

Client : Merrill Lynch, NYC August 2012 – March 2014

Role: Quality Assurance Analyst

Worked on application, called “SPB” – a Client- Server application. It is a derivative synthetic prime brokerage product used by clients and brokers to book and sell stocks and bonds and generate reports regarding convertible bonds on daily, weekly and monthly basis. This product supports stocks, Bonds and other financial instruments in the financial market.

Responsibilities:

Responsible for all QA and QC processes, and testing procedures. Writing and validating functional specification using SRS document.

Worked on major applications including Instrument editor (which helped creating and maintaining equity swaps), Reset Tool (which helped to reset the stocks and equity for dividend, reset interest rates, partial terminate or terminate equity swaps). These applications provide brokers with exact cash flow, dividend flow, stock loan amount, interest rates, realized gain and loss to brokers and customer.

Created Portfolio Swaps for a single client with stocks belonging to varied underlying and added dividend and cash adjustment using Ram dealing app. These trades were booked in NTTestapp Application. The results of NTTestApp application were compared with manually calculated values of, total swap value till date i.e. present values of all stocks for the client, Equity returns, dividend return, and interest return. These stocks could be priced or marked daily through PLApp application. Equity Reset and Interest Reset were performed through Reset Tool. On Equity reset, interest reset, Cash Flow, Dividend returns, Interest Return and stock loan fee were displayed on Reset Tool and were compared with manually calculated value. On Interest Reset only rates were set. The Foreign exchange rates were displayed for stocks in Euro, GBP and SEK.

Involved in developing Test Plans and test cases, Design and developed the manual tests for Instrument Editor, Reset Tools and NTTestapp Application.

Analyzed system requirements specifications, developed Test Cases, and Test Data for manual testing of the functionality, GUI, Compatibility, performance, usability and User Acceptance of the application.

Performed regression testing of applications using automation tools like QTP.

Performed record-playback of applications using QTP.

Responsible for inserting checkpoints to check the basic functionality of the applications including the values of text string, page, table, database etc using QTP.

Maintained repositories of recorded objects for each action separately and collectively as required.

Responsible for Parameterization of objects verify the application with multiple sets of data. Test data was stored in Excel sheets

Developed and executed the manual and QTP test cases and documented the bugs using Quality Center.

Used Quality Center to store, schedule test cases and report bugs.

Developed detail Load Test plan, Created VU scripts to simulate transactions.

Performed load testing (HP - Load runner, Load generator, Load controller and Load Analysis tools) on the application by initially evaluating the system, develop test assets (use cases, test cases and test scripts), executed scheduled tests and analyzed the test results.

Performed Data Validation of the data flow from front-end to back-end using SQL queries.

Performed database testing by passing SQL queries to retrieve data records.

Created test data for various scenarios using SQL queries.

Analyzing the test results and identifying potential bottlenecks

Executing Smoke test to validate the scripts, environment and data.

Performed end to end functional testing, conducted Integration, System, Functional, Database Integrity, User-Acceptance (UAT) and Sanity testing.

Performed GUI, Positive and Negative testing.

Conducted integration testing, identified application errors, resolved issues through bridge calls.

Provided management with daily status reports.

Maintained Test Logs, Test Summary reports and participated in defect review meetings.

Created Use Case scenarios using manual testing for unit, module, integration and regression testing. Wrote detailed steps of cautions and expected failures and errors handled in current versions. Wrote detailed Test Scripts for the same. Version control for these documents was provided through Rational Clear case. Created PL/SQL scripts parallel to those in code in Toad environment.

Environment: Java, X-Motif, SQL, Clear Case, Rational Requisite Pro, Rational Rose, Test Director, QTP, Load Runner, Toad, PL/SQL, Oracle.

Client: ADP, Roseland, NJ October 2011 – July 2012

Role: Quality Assurance Analyst

Worked on “HR expert” payroll for a web based application. It helps to Enroll employees in different plans like Health & Welfare, Insurance, FSA, and Miscellaneous. It helps to calculate Employee’s total deduction in salary and help produce pay cheques for the same. The objective of testing was to provide the development and marketing department with supporting data of performance of the application and analyze for the performance bottlenecks associated with each test for various revisions of the application.

Also worked in trade clearance department application. The application used to provide trades cleared by ADP and rejected to Instinet Clearance Services by comparing data from SIAC and the customer actual trade information.

Responsibilities:

Managed team of four QA testers. Responsible for all the QA and QC process, testing procedures. Developed template for Test Plans and test scripts and created detailed Test Plans, Test Approach Strategy documents for the entire SDLC process.

Wrote requirement based Test Plans using SRS document and Use case scenarios for unit, module, integration and regression Testing.

Wrote detailed steps of cautions and expected failures and errors handled in current versions. Wrote detailed manual Test Scripts and Test procedures for the same.

Before creating automated regression test scripts in QTP they were manually executed to check the flow against the test scenarios.

Performed regression testing of applications with help of QTP tool trial version.

Performed record-playback of applications using QTP.

Wrote detailed test cases for XML data file transmitted between different databases and application.

Conducted data validation test by checking the accuracy of the data transmitted via XML file between Instinet database to ADP’s application and retrieval of updated or processed data via XML file. Verified whether data was getting updated accurately in the database. Manually performed unit, module and integration and back end testing for the same.

Created Hybrid framework for maintaining test scripts and other test files

Responsible for inserting checkpoints to check the basic functionality of the applications including the values of text string, page, table, database etc using QTP.

Maintained repositories of recorded objects for each action separately and collectively as required.

Responsible for parameterization of objects to verify the application with multiple sets of data.

Performed Data Validation of the data flow from front-end to back-end using SQL queries.

Performed database testing by passing SQL queries to retrieve data records.

Created test data for various scenarios in Excel sheets.

Conducted Back end testing using SQL scripts for Oracle, DB2 and SQL databases in Toad environment.

Developed detail Load Test plan, Created VU scripts to simulate transactions.

Performed load and stress testing (HP - Load runner, Load generator, Load controller and Load Analysis tools) on the HR Web application by initially evaluating the system, develop test assets (use cases, test cases and test scripts), executed scheduled tests and analyzed the test results.

Wrote User help document using process flow documents, functional requirements documents, use cases, use case diagrams, and other supporting documentation.

Analyzed the Transaction Response time and finding performance bottlenecks when the XML file was transmitted and read by different applications, clients and databases. Provided detailed defect reports and test result to development team and management.

Reported detailed defects and effects on the system using Test Director tool and shared QA documents using Rational Requisite Pro and maintained different version of test document in Clear case.

Environment: Java, Oracle, Toad, PL/SQL, Clear case, Rational Clear Quest, Rational Rose, Rational Requisite Pro, QTP, Test Director, LoadRunner.

Client: KPMG, NJ December 2010- September 2011

Role: QA Analyst

Worked on KPMG proprietary web based product, called "CMS" or "CAT". It helps the auditors in monitoring the business risk management processes of its clients& provides a reporting tool to how to avoid business losses.

Responsibilities:

Responsible for managing a team of 12 members in India. Wrote functional specifications, created data and process flow models and use cases using UML methodologies. Created test plans and test scripts for the customized modules and maintained different a copy for each version in Clear case.

Wrote detailed manual Test Scripts and Test procedures for the same.

Interacted with the testing team in India (offshore team) and development team in US to determine if the software solution meets the needs of the business requirements.

Before creating automated regression test scripts in TSL Win Runner they were manually executed to check the flow against the test scenarios.

Conducted manual testing including unit, module, integration, functional testing, security testing using data validation testing, Regression and GUI testing on each build or version of the application.

Performed functional regression testing of applications with help of Win Runner tool.

Performed record-playback of applications using Win Runner.

Performed integration testing on assigned products as needed.

Responsible for testing newly created tables by creating test data and validating against Data validation Test scripts by using SQL scripts. Used SQL scripts to test whether the data was updated accurately in Oracle and DB2 database.

Provided traceability matrix, defect reports and status report.

Provided detailed defect documents of QA output from India to Business managers and development team.

Responsible for suggesting and making improvement recommendations on current or proposed systems.

Wrote detailed steps of cautions and expected failures and errors handled in current versions.

Responsible for Testing whether Class Diagrams, Class Tables, and Object Interaction Diagrams meet business requirement.

Created and Maintained Test Activity, Test Results, Test Summary, Defect Tracking (Using Clear Quest) and QA documents (Shared documents for Quality Assurance Team using Rational RequisitePro).

Environment: VB, Erwin, Oracle, Clear case, Rational Clear Quest, RationalRose, Load Runner, ClearQuest, Rational RequisitePro.

Client:Siemens Medical Solutions, CA July 2009 - November 2010

Role : QA Analyst

Worked on Siemens proprietary product, called “PrimeView”. It is treatment delivery software for Siemens Linear Accelerators. Worked on RTT (Radiation Therapy treatment) workspace, which is used by the Radiation Therapist to apply the predefined treatment plan to the patient.

Responsibilities:

Participated regarding business requirements and functional requirements between the client and the project team.

Updated SRS documents.

Prepared detailed data flow models and object models.

Wrote requirement based Test Plans using SRS document and Use case scenarios for unit, module, integration and regression Testing.

Wrote detailed steps of cautions and expected failures and errors handled in current versions.

Wrote detailed and Test procedures for the same.

Wrote detailed manual Test Scripts for unit, module, integration and regression for PrimeView, RTT workspace and Portal Imaging.

Designed, developed and coded Interfaces test cases in C++ for Prime View.

Modifications were done to the current design and created new wrapper classes to replace existing IAP libraries functionality.

The existing C files were replaced with COM components.

CHARMNT database was used to store scanned images. Tested the effects of simulated Radiation therapy on images and checked its updates in database by comparing the images in Data validation reports created by Doctors.

Developed and conducted internal training programs for developed applications.

Created and maintained Test Activity, Test Results, Test Summary, Defect Tracking (Using Clear Quest) and QA documents (Share documents for Quality Assurance Team using Rational Requisite Pro

Environment: VC++, C++, C, COM, ClearCase, RationalRose, Purify, CHARMNT, Rational RequisitePro, DICOM, LANTIS, CMM 4.2, Clear Quest.

Client:Siemens Medical Solutions, NJ January 2009 – June 2009

Role: Software Engineer /QA

Worked on Siemens proprietary product called “Syngo”. It is used to provide common Software Architecture for all medical products that Siemens develops. It provides ease to use middleware.

Responsibilities:

Gathering, analyzing, and writing business requirements, creating work flow diagrams,

Wrote functional and non-functional requirements, conforming to UML processes and SOP in developing use cases, use case diagrams, and other supporting documentation.

Designed and created new classes in VC++ for Error management and deployed New Error Management COM component.

Used Clear case tool to maintain updated changes.

Wrote requirement based Test Plans using SRS document and Use case scenarios

Wrote test script in VC++ for unit, module, integration and regression Testing.

Wrote detailed steps of cautions and expected failures and errors handled in current versions.

Involved in manual unit and white box testing on the New Error Management COM component, to analyze and report all defects at an earlier stage.

Conducted Functional testing, Regression and GUI testing on each build or version of the application by executing VC++ files

Modifications were done to the current design and created new wrapper classes to replace existing IAP libraries functionality. The existing C files were replaced with COM components.

Assisted in streamlining and automating testing procedures for developed application software.

Interacted with the testing team to determine if the software solution meets the needs of the business requirements.

Created and Maintained Test Activity, Test Results, Test Summary, Defect Tracking (Using Clear Quest) and QA documents (Shared documents for Quality Assurance Team using Visual Source safe)

Generated Class Diagrams, Class Tables, and Object Interaction Diagrams using RationalRose.

Environment: VC++, C++, C, COM, Clear case, RationalRose, WinRunner, CMM 4

EDUCATION & PROFESSIONAL DEVELOPMENT COURSES:

Bachelor of Computer Sciences from Pune University, India.

Advance diploma in Software Engineering from Boston Institute, India.

Contact this candidate