QA/BA tester - Automation and Manual both

Deepti Saxena

Mobile: 440-***-**** Email: ***********@*****.***

Summary:

11+ years of IT experience as a Business and Functional Quality Analyst.

Proficient in creating business use cases for technology and functional teams

Experienced in analyzing business, system and functional requirements.

Proficient in automated testing tools like Quick Test Pro 9.1, QC and HP ALM 11.52.

Good understanding of Agile and waterfall SDLC.

Proficient in conducting Integration, System, Functional, Regression, GUI, Stress, and Performance Testing.

Proven ability to support multiple projects, under tight deadlines, often with competing priorities and complexities.

Experienced in testing of both Web and Client-Server applications.

Participated in Agile DevOps implementation for test automation and code quality

Excellent communication, strong sense of organization, effective time management and good team player.

Managed testing resources and mentored junior Business Analysts for Project transitions

Tested regulations like Dodd Frank for Public fiancé and Corporate finance business.

Architected a firm wide defect tracking system and process flow, wrote QC based scripts to send alerts and warnings to the dev., business users or QA teams across the department.

Scrum Master certified. License # 000656710

Professional Experience:

Fitch Ratings, Wall Street, NY, Sr. IT Analyst, Nov ’10 – Pres.

Project Description: Public Finance Ratings: This process involved recalibration of certain of its U.S. public finance credit ratings, it includes several aspects like global finance instrument rating and some specific functions like reassessment of the Municipal Ratings Framework, the rating engine includes interacting an testing with several service interfaces like look-up services, assessment modules, prefunded rating, secondary market derivative, bank substitution, MSF surveillance and bond update service, My responsibility also included testing financial instruments like securitized products, munis and bonds. Worked on the rating logic for variety of ratings like long term and short term ratings and related rating actions. The intent of the recalibration is to ensure a greater degree of comparability across Fitch’s global portfolio of credit ratings. This recalibration will affect ratings in the state and local government tax-supported, water/sewer, public power distribution-only, and public higher education sectors.

CFC - CFWC stands for Corporate Finance Work Center. It is a web based application used by Corporate Finance team to record and maintain their workflow and scheduling. The system enables users to schedule, record and update management meetings/rating committees against entities, create minute sheets, create content job for publishing reports/RACs/NRACs via DPC and upload documents to DMS. The system also provides a suite of management reports used for team performance management and reviews.

DPC - DPC stands for Document Publishing Centre. It is responsible for the workflow and submission of the press releases and research reports published by Fitch Ratings and Solutions.

Against both press releases and research reports exist workflows that must be completed in order for the content to be published. These workflows are carried out in parallel to each other.

When submitting RAC/NRACs the analyst would submit the initial Word document to the Press Team, and once the text has been agreed, it then gets approved by a business approver, and then finally it is published by the Press team.

When submitting research, the analyst submits the initial word document, then editors and formatters carry out their work, followed by publishers. Then business approvers will approve the work, and then finally the research team will publish the report.

DPC is responsible for RAC/NRACs & reports being disseminated onto the public website, and also the RAC/NRACs being sent via email to recipients as well as via FTP/SOAP to newswires.

Designed the test plan and prepared vendor-specific test scenarios and cases to verify the Extraction, Loading and Transformation of asset data originating from vendors such as Moody's, S&P, Bloomberg, CUSIP, ISIN, Factset, GICS, ICB, ISID and Fitch

Verified that the incoming vendor asset data was stored correctly in the Staging Tables and tested the implementation of the Mapping Rules and Attribute Harmonization schemes used to commingle data across vendors

Wrote test scripts to verify the Locate Asset and Preferencing Transformation functions

Locate Asset checks the daily incoming asset data for the presence of new records, primary and non-primary changes to existing records and removal of existing records, and updates them accordingly

Preferencing ensures that the Golden Copy of data was produced correctly as per the rules set up in the database

Checked the Exception tables for failure to load data into Staging Tables, failure to harmonize data and failure in Asset Identifier matching

Used SQL Developer to extensively query the backend Oracle database to verify the output of the ODI run

Used WinSCP, an open-source FTP client for Microsoft Windows, to create and edit the vendor test data on a remote server

Tested the scheduling of the ELT jobs using the Cybermation Job Scheduler

Defects were tracked, reviewed, analyzed and compared using Rational Clear Quest

Prepared the Software Test Plan for Functional, Regression and Integration testing in accordance with the business and functional requirements, to verify the ability to create deals for ABS, CMBS, RMBS and CDO business units

Tested the various SOA CoreServices, such as those used for reading and saving services and ratings data, getting lookups information like available service types, ratings types etc, using Mindreef SOAPscope Server

Used WebLoad to test the response time of requests under load and to verify the reliability of the application under extended runs

Performed extensive database testing using SQL queries in SQL Developer

Automated the regression and smoke test suite in QTP by customizing the scripts using VBScript

Tracked and reported upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status and performance baselines to the project manager

Actively involved in weekly status, product delivery and defect review meetings.

Environment: JBoss (for SOA Integration), Windows 2000/XP, SQL Server 2005, QTP 9.1, Quality Center 11.52, JIRA

Progressive Insurance, Cleveland OH, Sr. QA, Feb ’08 – Oct ’10

Project Description: CRG: Worked on the intranet web app for the Comparative Rating Group (CRG), the software is used to create and analyze rules for comparing insurance rates of several providers like Allstate, Geico, State Farm and Nationwide etc. Rules and rate filings were provided to the team by third party vendors, the team would then compare these filings with the current system data followed by programming the new changes as per business specifications and new requirements, and Filing updates are based on several parameters like accidents, violations, discounts and surcharges. Once the BR’s are finalized they are incorporated by the development team into the downstream systems.

Responsibilities:

Interacts closely with business analyst and technical peers in the system analysis process and develops requirements that facilitate testing.

Manually creates and input test data or uses tools, programs or extracted production data to execute test cases.

Modifies test cases in accordance to changing requirements and design.

Recording and playing back the scripts for regression test modules using QTP.

Updating test plan repository and test case execution results in QC

Claims Station: CS is a client-server application developed for the claims rep to handle several automated processes related to a claim, CS collates several independent in house apps (web based and client server), all these apps form a part of the several steps in processing a claim like entering events related to the vehicle repair completion and initiation process, generating tasks and task management for the reps, handling automated payments for the third parties and service centers, this app utilizes the single sign on facility to access all the claim parameters.

Responsibilities:

Writing test specification and guidelines documents.

Preparing auto run reports and tests for development and QA smoke tests.

Scripting regression test plans and automation scripts.

Recording and playing back the scripts for regression test modules using QTP.

Working with Business analysts to identify the story card success criteria.

Work with business to prioritize defects based on business and technical requirements.

Tested web services manually with a UI and with in-house automation tool.

Integrated QTP automation tools with Quality Center and executed scripts via QC.

Working on DB testing using SQL server 2005 management studio.

Created out of the box test plans and execution scenarios.

Updating test plan repository and test case execution results in QC.

Creating XML files for testing web services.

Developed process flows for progressive testing methodologies and processes.

System Test cases development and execution.

Environment: Windows 2000/XP, SQL Server 2005, QTP 9.1, Quality Center, CTH (In House Automation Tool)

Dell Inc, Austin TX, Sr. QA, Mar’06 – Feb’08

Project Description: IT application for the Online Cart and Checkout pages

The Online Cart and Checkout is an application using which the customers are able to manage items under consideration for purchase, as well as provide all information necessary to place an order. This project introduces a new interface in addition to the existing cart and checkout interface. The new interface has significantly more dynamic capabilities and includes the express checkout which is a one page summary view of defaulted order information with emphasis on remaining fields to be completed and ability to make edits as needed.

Responsibilities:

Creating and maintaining test plans and test cases for the app and documenting bugs.

Reviewing the SRS with the Business team & the Developers.

Developed and performed the high level test scenarios, test cases using Test Director.

Involved in Functional & Regression testing using QTP.

Responsible for both manual and automation testing of the application.

Created process templates for test results and daily defect status updates.

Preparation of status reports after complete SIT.

Automate complex test scenarios in order to reduce manual work.

Performed POC. Identified the scenarios to be automated/ not automated.

Created global data table using data driven tests

Created user defined functions, reusable functions in QTP and created library files.

Actively participated in weekly meetings, conferences and walkthroughs to understand the business and testing requirements and to plan the testing process on a regular basis.

Environment: Windows XP, Oracle 9i, Test Director, QTP 8.2 & 9.1

Technical Skills:

Operating System

Windows XP/ 7, UNIX

Database

SQL Server 2005, Oracle, MS-Access

Web Technologies

XML, HTML, Java script

Langages

C, C++, PL/SQL, T-SQL

Testing Tools

Quick Test Professional 8.2 & 9.1, Quality Center 10, HP ALM 11.52

Utility Tools

MS Office 2010, SonarQube, JIRA

Educational Qualification:

Bachelors of Computer Science ICG, Jaipur, India

MBA – International Business IBMT, Bangalore, India

Contact this candidate