Sangeetha Patnam

Email:admfkt@r.postjobfree.com Contact: 774-***-****

●10+ years of progressive experience in testing Web-based / PC-based and Client-Server applications on different environments

●Involved in entire SDLC Life Cycle, which includes Requirement Gathering, Use Cases Preparation, and preparation of Automation Test Strategy

●Experience in Test Automation Framework and Performance Engineering methods

●Extensive experience in working different Software Methodologies (Waterfall, Iterative and Agile)

●Extensive experience in design and development of Test Plans, generate test Case and Traceability Matrix based on Business Requirements

●Expert in Design & Execute Automated and Manual test cases for Web based applications

●Experienced in preparing and maintaining Test Strategy, Test Plans & Test Design Documents

●Highly experienced in designing the test documents like detailed Test Plans, comprehensive Test Cases, Defect Reports and Test Summary reports and well versed with the entire test management using HP Quality Center.

●Prepare Manual and Automation Test Suites, Test Cases, Test Procedures, Test Scripts, Test Execution, and Defect Logs and Bug Reports for the application.

●Worked on End-To-End (E2E) Testing that involves coordinating and testing chain of different applications.

●Experience in Manual & Automated testing using Mercury testing tools (Quick Test Pro, Ranorex, Win Runner, Load Runner)

●Extensive Working Experience in Functionality Testing, GUI Application Testing, Backend Testing, Front-end Testing, Positive Testing, Negative Testing, Web Services Testing, Integration Testing, Usability Testing, Regression Testing, Performance Testing, User Acceptance Testing (UAT), Load Testing, Boundary Value testing, Data Driven Testing, Stress Testing, Sanity Testing, Smoke Testing, Black Box Testing, White Box Testing, Systems Testing, Database Testing, End to End testing, Unit Testing and Cross Browser Testing

●Expert using defect tracking tools like Quality Center ALM and Jira

●Hands on experience with HP Mercury Quality Center for Test Management and QTP for functional Test Automation Experience in sending Execution status report to Client Management.

●Expertise in Bug Tracking system and Involved in Defect Review Meetings

●As a Systems Analyst responsible for collect requirements, define scope, assess project impacts, quality assurance and conduct meetings for root cause analysis

●Experience in back-end testing developed and executed SQL Queries for data validation and verification

●Knowledge in Relational Database Management Systems (RDBMS) and experience writing Data Manipulation and Data definition queries

●Have Strong Experience on intended usage of Team foundation server and Microsoft Visual Studio for QA Testing purpose on application development

●Experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.

●Experience with working on UNIX / LINUX, Windows XP Operating Systems

●Excellent Knowledge of Database Systems – Oracle 10g, SQL server, DB2 and Data ware house concepts.

●Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.

●Experience working with business users to understand business cases and setup data based on business requirements

●Coordinated the test efforts of both onsite and offshore team members and managed the test efforts meeting the schedules and expectations

●Have extensive experience in Financial, Health care and Retail.

●Have Knowledge on Automation tool Selenium and Mobile Testing

●Ability to work independently as well as part of team, Quick Learner having Strong analytical, interpersonal, leadership and management skills

Work Authorization:

U.S CITIZEN

Technical Skills

Tools & Utilities

Quick Test Pro (QTP/UFT), Ranorex, Test Director, Load Runner, Win Runner, Quality Center, Test Manager, Automation Framework, ETL, Salesforce, Maximo, Workforce Management, QC ALM

Languages

C#.Net, ASP.Net, SQL, VB.Net, VB Script and JAVA

Database

Oracle 11/9/8.x, SYBASE, MS-ACCESS

Configuration Management

VSS, CVS, SVN, Star Team

Scripting Languages

Java Script, Test Script Language, VBScript

Operating Systems

MS DOS, Win-XP, Vista, Win-NT, UNIX, Linux

Client: National grid, Waltham July 2019 – Till Now

Role: QA Lead

Project: Gas Business Enablement

●Developing Test plans, Test Strategy document and distinct test cases and execution of Test cases.

●Performing UI Testing and Functionality Testing on web based applications

●Documented test cases, test results, test procedure and reported to client.

●Coordinated with development team for Bug fixing.

●Actively involved in review meetings.

●Participating meeting with Business users and Stake Holders for Requirement Gathering

●Leading and Co- ordinating multiple Projects

●Strong testing Quality Assurance Experience within Agile Environment

●Leading a group and facilitate work as a team

●Ability to multitask and prioritize work to meet deadlines

●Ability to draft reports for Management

●collected Project information and submitted al reports to project manager and lead developer

●conduct daily scrum meetings

●Co-Ordinate Onsite and Offshore Work

●Create and Execute the test cases using QC ALM

●Create Defects and track the defects in QC ALM

●Comprehensive application testing for various sales order entry modules.

●Gathered business process requirements and utilize Salesforce functionality to automate and achieve those .

●Customized user Roles, Role hierarchies, Profiles and Sharing settings to ensure that the protected data is available only to the authorized users.

●Provide Salesforce best practices and customizations with regard to SDLC

●Configured workflows and approval processes to enhance business logic.

●Created new sandboxes and deployed Components and Data from one environment to another and Managed sandbox refreshes and release testing.

●Involved in various user stories and worked with QA team to test in various sandbox environments and update fields in Production

●Good knowledge on Salesforce Cloud, Service cloud and marketing cloud

●Good Knowledge on Force.com apps

●Proficient in Salesforce.com Functional Testing

●Possess comprehensive understanding of CRM processes like order management, Case Management

●Good knowledge about Reports, Dashboards, Record types

●Expert in working with different Testing methodologies like Agile - Scrum Model

●Eliminate duplicate Accounts after merging parent and child organization data, using fuzzy match

●Create and Execute Work orders from Salesforce

●Execute Work orders using FSL

●Create and Execute Work orders from Maximo

●Validate workflow from Salesforce to Maximo and Vice Versa

●Experience with setting up FSL data model (Work orders, Service Appointments, Service Resources, Territories, etc)

●Ability to configure Service Rules and Objectives in support of Field Service business processes

●Experience installing FSL managed package and guided setup configuration

●Manage agent scheduling (i.e., shifts, training, vacation, meeting, overtime, off-line work, exceptions, etc.) using Workforce Management System to ensure that daily service level objectives are met.

●Create daily, weekly, and monthly contact volume forecasts by analyzing inbound call activity/historical trending

●Create and maintain real-time, historical and custom reports and analyze trends in a timely manner to improve the efficiency and effectiveness of the organization

●Proactively seek opportunities to improve processes that lead to greater operational effectiveness and a positive merchant experience

●Recommend service and operating improvements to the Workforce Manager and key business partners in the contact center

Perform Mobile devices testing using Mobiles and I pads and Tablets

●Perform E2E Testing

ENVIRONMENT: Agile, Salesforce, Maximo, Workforce Management, SAP, Cross browser testing, Mobile Devices(IOS and Android), Quality Center, MS-Office, Share point, VB Script, Oracle, PL SQL, Toad, Microsoft Visual Studio, Web applications

Client: Eversource, Westwood APR 2018 – July 2019

Role: QA Lead

Project: Customer Web Analytics

●Analyze business and system requirements, mange development of specifications to create and execute detailed test plans and verify bug fixes on web applications

●Developed test plans, test cases, test scenarios using the Quality Center and prepared test data.

●Create and Execute Automation Test Scripts using Automation Tools QTP, QC, Adobe and Decibel Frame works. Galaxy, Mainframe

●Develop Automation Scripts from the scratch using VB script

●Perform in-depth quality assurance reviews on software, finding all bugs and taking careful notes of where they are and how they can be reproduced.

●Perform Cross browser testing using different browsers IE, Google Chrome, Safari

●Perform testing on different mobile devices

●Participated meeting with business users

●Working on Onsite and offshore model

●Detected Defects, communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Center.

●Executed manual test cases and identified the test cases to be automated

●Extensively used Quality Center for test planning, bug tracking and reporting.

●Uploaded Business requirements, test scenarios, test cases and defects to Quality Center

●Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions.

●Involved in testing the backend Database retrieved the data from the tables using SQL.

●Identified bottlenecks, and discussed the same with business analysis team, developers and technical architects and attended meetings.

ENVIRONMENT: Agile, Adobe Framework, Decibel Insight, Galaxy, Mainframe, Cross browser testing, Mobile Devices, Quality Center, MS-Office, QTP, Share point, VB Script, Oracle, PL SQL, Toad, Microsoft Visual Studio, Web applications

Client: State Street inc, Boston JULY 2015 – APR 2018

Role: Automation Engineer

Project: Multi Currency Horizon & IRIS

●Worked in Agile methodology. Attended Daily standup meetings. Developed Test Plan and Test cases based on the user stories (Functional requirements)

●Detected Defects, communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Center.

●Executed manual test cases and identified the test cases to be automated

●Extensively used Quality Center for test planning, bug tracking and reporting.

●Uploaded Business requirements, test scenarios, test cases and defects to Quality Center

● Expertise in QA Testing in distributed Main frames Environment and Oracle databases as back end & performed end-to-end testing.

●Developed test plans, test cases, test scenarios using the Quality Center and prepared test data.

● Prepared Test Cases for GUI application. Developed test scripts for Data driven testing using parameterization in QTP/Ranorex by using Excel sheet for test data and Database Queries based on the functionality.

●Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions.

●Worked on Automated test scenarios for GUI, Functionality, Integration, Database, Boundary, Security and Regression Testing using Quick Test Professional and Ranorex.

● Involved in testing the backend Database retrieved the data from the tables using SQL.

● Worked on the high-level framework, identifying the functional areas and created different functions to make the scripts reusable in Quick Test Professional.

●Prepared test scripts using Quick Test Professional with checkpoints using regular expressions for handling windows with different names.

●Identified bottlenecks, and discussed the same with business analysis team, developers and technical architects and attended meetings.

●Maintain and develop the current Virtual environment implementations across all customer environments

●Develop the Virtual environment for the tech refresh roll out

ENVIRONMENT: Agile, Mainframes, VMware, Web based and Desktop Application, Quick Test Professional (QTP/UFT), Ranorex, Keyword Driven Frame work (TAF) Quality Center, MS-Office, TFS, RTC, Share point, VB Script, Oracle, PL SQL, Toad

Client: UNFI, RI APR 2014 – Dec 2014

Role: Senior QA Analyst

Lawson Account Receivable: The Lawson AR Implementation project is intended to provide UNFI’s Business teams the opportunity to standardize business processes on a national platform in measurable and enforceable ways. UNFI’s Accounts

department is currently split into three core business units (East, West and Albert’s). Each of these divisions performs their Accounts Receivable functions within a different business system or application. The goal of this project is to seamlessly implement and transition each of these business division’s Accounts Receivable functions out of their current environments into a unified Accounts Receivable application.

Responsibilities:

●Reviewed and Analyzed Business Requirement Document -- BRD and created detailed test scenarios to validate the application functionality.

● Drafted detailed Test Plan to drive the entire testing process and guided the entire team to meet the schedules. Designed detailed test cases to validate the application functionality and reviewed the same.

● Tested the entire application and performed various tests like Positive & Negative, Business Functionality, Integration, and Regression, End to End and also supported User Acceptance Testing (UAT).

● Used Quality Center for Defect Reporting and Tracking and also for managing the entire test documentation like Requirements Management, Test Case Designing, and Test Execution & Generation of the required reports. Participated in weekly status meetings and interacted with the developer team to discuss technical issues

●Created automated functional regression test scripts using QTP and scheduled, organized and executed the test scripts in QC-QTP integrate environment and documented the test results.

●Created automated regression test scripts using Quick Test Professional and managed the test beds using Quick Test Professional

●Wrote Complex SQL Queries to Oracle and My SQL Server Data base for Back end/Front end comparative analysis i.e., to check the correctness of the data stored in data base

●Worked on back end testing and has very good experience in writing SQL queries to verify and validate the data

●Create and Execute SQL Queries to ensure data accuracy and also verified the tables using SQL

●Knowledge in ETL Methodology for supporting data extraction, Transformations and loading Processing, in a corporate-wide-ETL Solution using Informatica.

●Strong Knowledge on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

●and transfer a transaction from one account to another account

●Perform Day End and Month End distributions Closing process and post these distributions into General Ledger

●Enter Invoices, Debit Memos and Credit Memos with in AR Application

●Develop and Utilize AR Standardized Disputes Codes across the Three Business Units

●Create and Produce a Statements and Dunning letters with in AR Application for each business unit

●Create a Unified Customer master file that removes duplicate customer numbers and allows for National accounts to be established across the 3 business units

●Verified and validated the functionality of product

●Responsible for prioritizing the defects and assigning to development, managed defect database

●Using QTP Performed Integration, Regression, End to End, Systems and Backend testing

● Developed automated test process using Quick Test Pro to create scripts for regression testing

●Upload requirements, test cases and requirement tracking document in Quality center

●Used Share point to create, manage documents and version controlling

●Communicate with developers as needed to isolate root cause of defects

Environment: Quality Center, UFT, Unix, Oracle 11G, Toad, SQL, Share point, Putty, VBScript, Java, MS-Office, TFS, Windows XP.

Client: BJs Oct 2012 – mar 2014

Role: QA Analyst

Responsibilities:

●Creation of Test Strategy, Test Plan detailed Test Cases and Test Scripts for both manual and automated testing

●Facilitated formal review meetings with developers to report, demonstrate, prioritize and suggest resolution to issues discovered during testing Cycles

●Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis

●Conduct meetings with business users and technical teams to understand requirements

●Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix

●Planning, scheduling and executing System testing

●Support business users during testing provide data for test scenarios

●Supervise regression testing Monitor all problems detected during execution

●Using QTP Performed Integration, Regression, End to End, Systems and Backend testing

● Developed automated test process using Quick Test Pro to create scripts for regression testing

●Execute Test steps from test scripts and report the defects and track them to the closure

●Reviewed Test Cases and Test Scripts. Prepared Test data required for regression testing

●Verified and validated the functionality of product

●Responsible for prioritizing the defects and assigning to development, managed defect database

●Upload requirements, test cases and requirement tracking document in Quality center ALM

●Tracked the defects using Quality Center ALM and generated defect summary reports

●Coordinated the test efforts of both onsite and offshore team members and managed the test efforts meeting the schedules and expectations.

●Used Star Team to create, manage documents and version controlling

●Developed SQL Queries for testing various Database validations.

●Prepared Test summary including the defect report.

●Communicate with developers as needed to isolate root cause of defects.

Environment: Quality Center ALM, QTP, Windows NT, J2EE, AS400, Oracle 11G, Toad, My SQL Server, Star team, Putty, Win SCP and web services, Agile methodology

AT&T, CA Feb 2011 - Sep 2012

Role: QA Analyst

User Content Management is a Cloud Storage Enabler for the consumer content storage and management. UCM enabler provides the capabilities for searching, sharing and managing user contents .UCM enabler provides REST APIs which enables application to functionally exploit the UCM enabler to develop application level features.

Responsibilities:

●Testing compatibility of software under various Internet Browsers (Internet Explorer, Netscape, and Fire Fox)

●Creation of Test Strategy, Test Plan detailed Test Cases and Test Scripts for both manual and automated testing

●Facilitated formal review meetings with developers to report, demonstrate, prioritize and suggest resolution to issues discovered during testing Cycles

●Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis

●Conduct meetings with business users and technical teams to understand requirements

●Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix

●Wrote Complex SQL Queries to Oracle and My SQL Server Data base for Back end/Front end comparative analysis i.e., to check the correctness of the data stored in data base

●Worked on back end testing and has very good experience in writing SQL queries to verify and validate the data

●Create and Execute SQL Queries to ensure data accuracy and also verified the tables using SQL

●Knowledge in ETL Methodology for supporting data extraction, Transformations and loading Processing, in a corporate-wide-ETL Solution using Informatica.

●Tracked the defects using Quality Center ALM and generated defect summary reports

●Using QTP Performed Integration, Regression, End to End, Systems and Backend testing

●Used Quality Center for creating merchandising data content for the beta website and tested to see if the website displayed the content as expected

●Participated the unit testing with the development team members for each build and pointed out issues with their fixes.

●Assisted in UAT Validation of the application and helping the business users with the site navigation

●Executing the test cases and validating the responses.

●Coordinating offshore & onsite activities.

Environment: Quality Center 9.0, Quick Test Pro, Windows NT, C# .Net, Oracle, Toad, Putty, ASP.Net, SQL Server

UHG, AZ (United Health Group) Jan 2010 – Dec 2010

Role: QA Analyst

MEMBERSHIP & O&M – Claims and Finance application

Ameri Choice, a business unit of UnitedHealth Group, serves more than 1.3 million beneficiaries of government health care programs (Medicaid and Medicare) in 16 states from Rhode Island to California. Ameri Choice uses Diamond (Information System for Managed Healthcare organizations) as its claim adjudication system and data store. There is a group of supporting applications for DIAMOND i.e. applications which process data before feeding to DIAMOND, create various extracts, load data from vendor after verification. This project looks at enhancing and maintaining these applications.

Responsibilities:

●Extensive knowledge in health care domain worked in Membership, Provider, claims

●and finance modules

●Written SQL Queries, procedures and triggers to retrieve the data from the database

●Developed Test Plan for functional testing as per business use cases

●Prepared gap analysis between functional requirements and business requirement documents

●Analysis of the specifications provided by the clients

●Preparing system test case and executing the same

●Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix

●Planning, scheduling and executing System testing

●Support business users during testing provide data for test scenarios

●Supervise regression testing Monitor all problems detected during execution

●Using QTP Performed Integration, Regression, End to End, Systems and Backend testing

●Wrote Complex SQL Queries to Oracle and My SQL Server Data base for Back end/Front end comparative analysis i.e., to check the correctness of the data stored in data base

●Worked on back end testing and has very good experience in writing SQL queries to verify and validate the data

●Create and Execute SQL Queries to ensure data accuracy and also verified the tables using SQL

●Knowledge in ETL Methodology for supporting data extraction, Transformations and loading Processing, in a corporate-wide-ETL Solution using Informatica.

●Strong Knowledge on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

● Developed automated test process using Quick Test Pro to create scripts for regression testing

Environment: Quality Center, QTP, Windows NT, J2EE, AS400, Oracle 11G, Toad, Putty, My SQL Server

Nationwide Corp, OH March 2009-Dec 09

Role: QA Analyst

Nationwide Corporation, a wholly owned subsidiary of Nationwide Mutual Insurance Company, purchased all of the outstanding shares of common stock of Nationwide Financial Services. To make banking and financing solutions for customers implemented Salesforce CRM Enterprise Edition to boost the effectiveness of its CRM. They used Salesforce CRM Enterprise Edition over CRM due to its ease of use and customization capabilities inherent in the on-demand model. The application was built on on-demand Force.com Platform using Salesforce Customer Relation Management.

Responsibilities:

● Developed Test Plan for functional testing as per business use cases

●Prepared gap analysis between functional requirements and business requirement documents

●Analysis of the specifications provided by the clients

●Preparing system test case and executing the same

●Worked closely with build integration team, business analysts and developers in order to perform testing activities as per schedules

●Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix

●Planning, scheduling and executing System testing

●Using QTP Performed Integration, Regression, End to End, Systems and Backend testing

● Developed automated test process using Quick Test Pro to create scripts for regression testing

●Verified and validated the functionality of product

●Responsible for prioritizing the defects and assigning to development, managed defect database

●Performed manual testing of the complete application and identified mismatches between actual and expected behavior of the application.

Environment: QC, QTP, Windows NT, J2EE, AS400, Oracle 11G, Toad, SQL

Western Health Advantage, CA Apr2008 – Feb2009

Role: QA Engineer

WHA has implemented the salesforce.com CRM application for customer relationship management (CRM), Sales Management, Sales Lead, Opportunity and Product Distribution Management. Standard real-time, web-based reporting provides and meets common notification needs for fulfillment services and marketing promotion programs. Analytics package offers executive-level dashboards that clearly display program results to help managers analyze performance and plot future strategies.

Responsibilities:

●Involved in reviewing the test cases written by the peers

●Developed Test Plans, Test Cases Test Scripts, Test Scenarios, Test Data and Traceability Matrix

●Planning, scheduling and executing System testing

●Support business users during testing provide data for test scenarios

●Supervise regression testing Monitor all problems detected during execution

●Extensively used Oracle SQL for database testing used SQL Navigator for Database testing.

●As Team member, was involved in System, Security, Regression Testing

●Documented the errors using Test Director and tracked them to completion by communicating and co-coordinating with the development as well as the support group.

●Responsible for Unit testing and functional testing for the application.

●Involved in GUI, Functional and Regression Testing.

●Tracking the Bugs through Bug Zilla

Environment: Bugzilla, QTP, Windows NT, J2EE, SQL, C, C++, Oracle, UNIX and Windows

Company: Celex Technologies, India June2007 – Feb2008

Client: Educate Online Inc

QA Test Engineer

Educate Online is one of leading providers of eLearning services in US. In the view of increasing users past March 2007 all the Current generation applications area developed as Next Gen for best enhanced business service organization. Educate Online Next Generation (NG) application suite consists of two systems naming NG Admin and NG LE (NG Learning Environment). Verified and validated Game technology as beta game tester.

Responsibilities:

●Analyzed Software requirements and Business Requirements document to get a better understanding of the system from both technical and business perspectives.

●Involved in developing test plan, test cases and also performed manual testing of web site.

●Preparing Detailed Test Plan and test cases for Functional, Integration, Security, GUI and laying out the procedures to test for manual testing using Test Director.

●Automated manual scripts using Win runner and created User Defined Functions to enhance the reusability of scripts.

●Tested the user interface to validate that the navigation of the application properly reflects business functions and specifications

●Inserted text, GUI, database, bitmap check points at various points in the scripts to check if the web pages correspond to the screen specifications included in the requirements using the baseline and the actual state of the objects in the application

●Place synchronization points as required in the scripts and updated them as the performance of the AUT increased.

Environment: C#.Net, Asp.Net, Sql-Server2005, Win XP, Test Director, Win Runner, Load Runner, Windows 2000, MS- Excel, TOAD, Oracle 9i, SQL and PL/SQL

Contact this candidate