Resume

Sign in

QA Analyst, Functional and Integration Testing, Agile,DB&ETL Testing

Location:
Pittsburgh, Pennsylvania, United States
Salary:
80,000
Posted:
March 11, 2018

Contact this candidate

Resume:

Experience Summary

Working as QA Analyst with ** + years of experience in Functional Testing, Automation and DB Testing

Expertise includes manual and Database testing, QA methodologies and Exposure to all stages of SDLC, STLC.

Hands on experience in Design, writing, reviewing and execution of test cases and test scenarios

Experienced in testing Client/Server and Web applications.

Extensively involved in Regression, Functional, Sanity, Integration and System testing

Responsibilities include, Test Plan formulation, Test Spec creating, Metrics, Estimations for Manual testing projects.

Extensive Experience in Black Box Testing - User Interface, Functional Testing, Regression Testing.

Good Experience in SQL Back-end Database Testing and ETL Testing

Good experience on automation testing using QTP

Developed test cases from test scenarios, executed test cases, Generated bug reports.

Good knowledge on Agile Testing Process

Responsible for defect reporting, tracking and closure and also for generating debugging procedures.

Documentation of test cases, test reports, Bug-tracking, daily status reports.

Experienced in SOAP-UI testing using Postman.

Strong analytical and problem solving, interpersonal and communication skills, self-starter, quick learner and able to adopt new technologies as needed in rapidly changing IT environment.

Domain Knowledge on Financial, Banking products.

Committed, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

Good Knowledge on Agile methodology Process(scrum)”.

Used version one, Rally, sharepoint, ALM for Project Management.

Extensively used ALM for :

Creation/Review of Test sets for Manual Test case preparation and mapping the requirement to test cases (Traceability metrics).

Test Case Execution.

Export/Import of projects/test scripts and Defect tracking in ALM.

Test Report preparation and Review of manual test cases.

Technical Experience

Database : SQL server, Oracle, TOAD

Domain Knowledge : Financial, Banking

Testing Tools : Quality Center 11.0,UFT, SOAP-UI

Documentation : MS Word, MS Excel, Power point

Client / Server Technologies : HTML, VB script, PHP

Configuration management tools: VSS, Version one

Methodologies : Agile(SCRUM), Kanban, Waterfall

Experience Details

Working as QA Analyst at Ness USA Inc,USA from June,2014 to till date

Worked as Senior Software Engineer at Ness Technologies, India since July,23rd 2007 till Aug,02nd 2013.

Reference

1.Sampath Kumar Buragadda : Manager QA, Ness USA Inc, USA (ac4rw0@r.postjobfree.com)

QUALIFICATION DETAILS

Bachelor of Technology in Computer Science & Engineering from Vardhaman College of Engineering affiliated to JNTU.

Project Details

Project Name : CCST(Corporate Criteria Scoring Template)

Customer : SPGLOBAL, USA

Duration : 08/2016 to till date

Environment : VB Excel, Oracle, HP-ALM Quality Center, Version One

Role : QA Analyst

Team Size : 3

Description:

The Corporate Criteria Scoring Template (CCST) is a Credit Ratings Model to help S&P Global Ratings credit analysts to record the criteria driven assessments in developing a recommended rating under Corporate Methodology. Corporate Criteria Scoring Template is a dynamic risk analytics system that encompasses the Issuer and Analyst and their respective credit score with respect to Industry and Country risk scores.

Roles:

Design test cases for carrying out tests of the project at various stages.

Perform smoke, sanity and adhoc, functional, system, Regression and integration testing.

Executing test cases of several modules and logging defects into HP QC and Version one

Maintaining Defect tracking, Bug reports, and Release summary QA documents.

Verification of data between Excel template and TOAD data base.

Verification of data flow among integration of different applications.

Project Name: CST(Criteria Scoring Tool)

Customer : SPGLOBAL, USA

Duration : 12/2014 to till date

Environment : PEGA, Oracle, HP-ALM Quality Center, Version One, Windows XP

Role : QA Analyst

Team Size : 4

Roles:

Design test cases for carrying out tests of the project at various stages

Perform smoke, sanity and adhoc, functional, system, Regression and integration testing

Executing test cases of several modules and logging defects into HP QC and Version one

Maintaining Defect tracking, Bug reports

Estimate, plan, develop and maintain manual and automated test cases web based applications

Updating automation scripts, executing scripts, maintaining.

Verification of data between Excel template and TOAD data base.

Verification of data flow among integration of different applications.

Project Name : USPF Security ID

Customer : SPGLOBAL, USA

Duration : 06/2014 till 10/2014

Environment : PEGA, Oracle, HP-ALM Quality Center, Version One, Windows XP

Role : Senior QA Engineer

Team Size : 5

Roles:

Description:

Testing is conducted on requirements defined by Business. Business Team is to provide Validation rules for Test Team. DSO Team provides Test Data for all validations. All Rules are tested according to Validation rules. Defects are reported to Development Team. Following steps are created to test.

Roles:

Use Shell in Guvnor to create, run and validate ASID, EASID Scenario Rules based on Acceptance Criteria.

SOAP UI used to leverage service level testing for all listed services.

Validate relationtionships between EASID and its enhancers at DB level.

Validating Schematic at Revenue, Pledge, ASID and EASID level and their attributes.

Data mapping, Data validating, at core and APR DB through Onetime process, Sync Process in order to validate EASID creation for all maturities.

Create a SOAP Project using WSDL and associated request in SOAP UI.

Validate hierarchy in Response against Database.

Validate starting point object and its dependents.

Validate object properties on mouse hover.

Validate hierarchy links between objects

Validate Ratings, Rating type code, Outlook, Credit watch for each object in the hierarchy.

Validate SMART_KEY text for objects

Validate dependent and independent objects in the SOAP response.

Data checks from APR DB against MRC DB

Creating ESID names (PEG Names) for Maturities available in CORE DB

Data Mapping between CORE DB and APR DB

Perform DML Operations in DB and validate Response accordingly at Service Level

Perform DML operations to validate Prod Notification Error

Project Name : RPM(Rating Process Manager)

Customer : Standard & Poor’s, USA

Duration : 01/2013 till 08/2013

Environment : PEGA, Oracle, HP-ALM Quality Center, Version One, Windows XP

Role : Senior QA Engineer

Team Size : 5

Description :

A credit rating is Standard & Poor's opinion on the general creditworthiness of an obligor, or the creditworthiness of an obligor with respect to a particular debt security or other financial obligation. Over the years credit ratings have achieved wide investor acceptance as convenient tools for differentiating credit quality. S&P uses Rating Process Manager (RPM) Application that manages activates in the ratings process and eliminates the duplicate data entry to S&P Analysts. The RPM Application brings ratings process administrative data together in one interface while increasing data quality, providing analytical teams with one time data entry in a single, integrated tool. The application facilitates the end-to-end ratings process including initial data entry, document upload, ratings approval by different user roles and create press release to publish the ratings for Specific Regions

Roles:

Prepare Software QA Test Plan

Check / Review QA artifacts

System, Integration and User Acceptance prepared by test engineers.

Get involved in analyzing requirements during the requirements analysis phase of projects.

Keep track of the new requirements from the Project.

Forecast / Estimate the Project future requirements.

Arrange the Hardware and software requirement for the Test Setup.

Develop and implement test strategies.

Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager / QA Manager

Assign task to other QA Team members and ensure that all of them have sufficient work in the project.

Attend the regular client call and discuss the weekly status with the project leadership team.

Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.

Assist in performing any applicable maintenance to tools used in Testing and resolve issues if any.

Ensure content and structure of all Testing documents / artifacts is documented and maintained.

Document, implement, monitor, and enforce all processes and procedures for testing is established as per standards defined by the organization.

Review various reports prepared by QA Engineers.

Log project related issues in the defect tracking tool identified for the project.

Check for timely delivery of different milestones.

Identify Training requirements and forward it to the Project Manager/ QA Lead

Create Requirement traceability Matrix (RTM).

Getting involved in all phases of Defect life cycle.

Ensured proper sign-off at all stages of the QALC (QA, UAT and Prod)

Participated in User Acceptance Testing and Production Sanity Testing

Performed Root Cause Analysis for all the defects raised for the ease of Dev team to fix the issues

Project Name : ARROW GLOBAL

Customer : Standard & Poor’s, USA

Duration : 09/2010 till 12/2012

Environment : Java,C#, .Net, Oracle, Quality Center, VersionOne, RFT 8.1

Role : Senior QA Engineer

Team Size : 5

Description :

Arrow Global provides a centralized global system to capture, store, analyze, forecast and report on financial operating econometric market and other data including (and/or integrate with) various tools and models used to forecast cash flow and earnings, predict probability of default, identify anomalous data, etc., Arrow Global integrates (link, hook, connect) with a number of other systems and databases at S&P, such as CORE and the Ratings Gateway. Arrow Global provides a centralized system and standard process for determining ratings and will replace many of the existing processes and systems currently used.

Roles:

Design test cases for carrying out tests of the project at various stages

Perform smoke, sanity and adhoc, functional, system, Regression and integration testing

Executing test cases of several modules and logging defects into HP QC and Version one

Maintaining Defect tracking, Bug reports

Estimate, plan, develop and maintain manual and automated test cases web based applications

Develop highly optimized code in VBScript, following keyword driven, data driven frame works.

Understand milestones in the release cycle and have high level plans to process the same

Interpret business requirements and high level designs to create detailed test cases

Take ownership of the entire bug resolution life-cycle

Collaborate with product management and development to deliver functionality that meet requirements

Take ownership of product functionality and provide guidance on its implementation to colleagues and customers

Actively provide suggestions for improving product quality

Executing RFT automated regression scripts on a daily basis

Verifying change requests, Defect management, documenting and tracking issues

Sending daily status reports to client

Build management and follows agile scrum methodology

Project Name : CLAS(Commercial Loan Application System)

Customer : M&T, Buffalo, USA

Duration : 05/2008 till 08/2010

Environment : ASP.Net, VB.Net, SQL Server 2005, Window workflow foundation,

Crystal Reports, AJAX and java Script

Role : Senior QA Engineer

Team Size : 4

Description :

The Commercial Loan Approval System is a web-based application used by M&T Relationship Managers and support staff to approve commercial loans for their customers.

The commercial loan approval process is a complex series of steps that involve adherence to credit policy and business process steps to mitigate the risk that the Bank enters into a relationship with a borrower that is unable to repay the debt.

The CLAS request will contain one or more customer records (profiles). The profile consists of unique information that identifies the customer and the Relationship Manager responsible for the account. There will be one or more loans (facilities) in the request. Each facility has critical data that is required in the approval process and to book the loans to the accounting systems that calculate interest and generate invoices to the customer.

Input to the request comes from information housed in other systems and direct data entry from the users. Output from the request includes queue requests to back office areas to complete process steps.

Roles :

Participating in client calls and team meetings for better understanding the requirements

Involved in consulting, development, execution and verification of test cases to guarantee that business requirements are fully met

Reviewing the Scenarios and Test cases.

Execution of test cases to check the Functionality of the application.

Validating test results, generating defect reports using Bug Tracker.

Status reporting to onsite.

Mentoring the Team members and clarifying the functional doubts

Performing Database Testing using SQL

Follow-up on the defect status for closure. Clarify on flow\Severity\Priority

Submitted weekly test and bug status reports to management.

Tested all the major functionalities in multi browsers (IE, Netscape and Mozilla).

Interacted with developers for timely resolution of the issues relating to testing.

Project Name : DPS & RMR Workflow

Customer : M&T, Buffalo, USA

Duration : 08/2007 till 05/2008

Environment : Windows XP, Java, J2EE Technologies, SQL Server 2005, FileNet (CE

3.5.2, AE 3.5.2), Kofax client 7.0

Role : QA Engineer

Team Size : 4

Description :

The Deposit Product Services (DPS) project has adopted a technology initiative for developing an electronic workflow and document management software solution. This workflow provides a way to easily route the document from one processor to another, to a supervisor etc. depending on the routing rules set for every document type. At the end of the process, the documents either get stored in the archive or will be deleted depending on the document type. A Search Interface will be provided to retrieve Documents easily based on index fields. Three departmental areas have been identified for this process namely Account Services, Pension Services and Deposit Services.

The proposed system implements automation of document and routing, queuing, work tracking, completion of tasks and addresses the auditing requirements as part of the proposed solution. FileNet Business Process Management (BPM) is responsible for defining, automating, integrating, performing, managing, and analyzing business processes like tracking of a work item and audit history, event log. In addition, the ability to search on index fields will be provided by the proposed system.

RMR Workflow (Records Management Repository)

• Legacy System Interface – Query HOGAN/SFA DB for valid Account Number or SFA Profile Number or TIN.

• Workflow – Process the document to Completion

• Search & Retrieve - will be provided for both Managers and Associates based on their Access Rights. Additional search templates will be provided for Self Service Customers.

• Generate Reports - will be customized to provide daily statistics, workflow and management reporting and will be used by Managers and Associates based on their Access Rights.

Roles:

Participating in client calls and team meetings for better understanding the requirements

Involved in consulting, development, execution and verification of test cases to guarantee that business requirements are fully met

Reviewing the Scenarios and Test cases.

Execution of test cases to check the Functionality of the application.

Validating test results, generating defect reports using Bug Tracker.

Status reporting to onsite.

Mentoring the Team members and clarifying the functional doubts

Performing Database Testing using SQL

Follow-up on the defect status for closure. Clarify on flow\Severity\Priority

Submitted weekly test and bug status reports to management.

Tested all the major functionalities in multi browsers (IE, Netscape and Mozilla).

Interacted with developers for timely resolution of the issues relating to testing.

Personal Profile

Name : Surekha Karampudi

Marital status : Married

Nationality : Indian

Visa status : Green card



Contact this candidate