Business Analyst and QA Lead

Sreelatha Ketineni

Ph: +1-786-***-****

Email ID: *************@*****.***

Professional Summary

Business Analyst and QA Lead having 12 years of IT experience in software testing of Web-based Applications on ORACLE Applications (ERP) and Domain knowledge of CRM, Banking and Finance, Health care.

Played the roles of QA Analyst, Business Analyst and Module Lead in CISCO projects and shown expertise in managing projects over the years.

Participated in Sprint Planning, Sprint Reviews, Scrum Meetings and other agile activities. Good Knowledge of Agile Methodologies.

Expertise in Requirement gathering, writing Story Documents, Business Requirements and Functional specifications.

Proficient in Regression testing, System Integration testing, End to End Testing and UAT Testing.

Good Knowledge of Selenium and QTP.

Worked on POC for Model Based Testing using Designer and Creator tools.

Proficient in Test/Defect management tools like HP-QC/ALM. Good Knowledge of JIRA and IBM Rational.

Proficient in analyzing requirements coming from the client. Suggested many improvements to the Client in the existing functionalities by thinking in user-perspective and most of them have been considered and implemented.

Strong Knowledge of SQL.

Improved the project management process by implementing customized Work Breakdown Structure helping the managers to plan the resource bandwidth effectively there by reducing cost

Trained in Six Sigma Green Belt program

Good Analytical, Communication, Interpersonal skills and Flexible with work environments.

Pragmatic, Self-Motivated and a good Team player. Key Responsibilities handled:

Execute all the testing phases stating from planning and creating test scenarios and Test scripts. Ensure continuous Regression and Quality throughout the project.

Ensure that all product processes are performed professionally and in adherence to quality standards from start to finish, assuring customer satisfaction.

Extracting bulk sets of data through SQL queries which will be used in BAT, UAT and Automation Testing.

Handled BAT testing, Reviewing and writing story documents, Reviewing and writing Business requirement documents, Functional Design Documents and Defect Analysis.

Mentoring team in understanding requirements and writing Test scenarios and Test cases.

Working with Automation teams to understand and execute test scripts in Automation Tools like QTP and Selenium.

Preparation of Test Plan and Test Strategy reports

Work allocation( Preparation of Work Breakdown Structure and allocation of work on individual basis) and tracking on weekly basis

Preparation of Daily Execution baselines (Start of a project)

Project monitoring on daily/weekly basis (DSR Calls with CISCO BIZ/DEV and other QA teams)

Preparation of daily/weekly status reports ( Test Preparatory and Test Execution reports)

Maintaining Issue Logs (Module wise)

Maintaining project related documents in a CISCO provided LIVELINK (Workspace)

Delivering Quality Metrics as part of project closure activities

Preparation of QA Exit Summary Report

Requirements mapping in Quality Center

Driving knowledge transfer sessions and CISCO Induction programs for the new joiners Certifications

Certified Software Test Engineer (CSTE).

Achievements

Received BRAVO Award for the POC done in Cisco OCM application for Model Based Testing.

Received appreciation certificates from Cisco client.

Lead the project(C2C) and was a part of big success with 95 % Defect Removal Efficiency in Production

Driving the initiative called the SME CONNECT which is a Subject Matter Expert forum that constantly strives to provide ideas and suggestions for QA process improvement

Along with regular deliverables worked for Six Sigma green belt project on reducing effort loss caused by environmental issues as part of QA process improvement

Implemented the customized phase wise Work Breakdown Structure (WBS) report which tracks the work allocation for individuals on weekly basis

Promoted to Band T1 in due course and was assigned the role of Test Lead based on the performance delivered as Module Leader

Successfully handled parallel modules across projects during the crisis period of Satyam, when there was no one to lead them

Was identified as Key Associate under the Key Associate Retention Scheme of Mahindra Satyam

Received “Pat on Back” from Mahindra Satyam.

Received Certificate of Achievement from GSK Client for the work done in Point Project Technical Skills:

Automation Tools : Selenium, QTP 9.2

Test Management Tools : QC 9.2 (Quality Center)

Programming Languages : C, CORE JAVA, VB Scripting. Database : Oracle11i, SQL Server 2005/2008

Other Tools : TOAD, Onramp

Projects Handled:

1. Business Analyst, San Jose, CA (Dec 2014– June 2017) Client: CISCO Systems

Project: CISCO Service Contract Center (CSCC)

Number of Modules: 3

Project Description: CISCO Service Contract Center (CSCC) is a web application used to create estimations, quotes and contracts for the customers on the various products and services provided by CISCO. This application follows 1-tier architecture of CISCO wherein, between the End Customer and CISCO, there is a Partner. Post the contract creation, this application also provides management of those contracts through the Online Contract Management tool.

Opportunity Management(part of CSCC) provides information of all those contracts which are about to expire within a year and renewing services for such contracts will have opportunity to generate revenue in coming year.

Business to Business (B2B) is one more tool which achieves quote creation, ordering and contract management functionalities of CSCC via XMLs.

2. QA Analyst, San Jose, CA (September 2011– Dec 2014) Client: CISCO Systems

Project: CISCO Service Contract Center (CSCC)

Team Size: 24 (21 Offshore and 3 onsite)

Project Description: CISCO Service Contract Center (CSCC) is a web application used to create estimations, quotes and contracts for the customers on the various products and services provided by CISCO. This application follows 1-tier architecture of CISCO wherein, between the End Customer and CISCO, there is a Partner. Post the contract creation, this application also provides management of those contracts through the Online Contract Management tool.

Opportunity Management(part of CSCC) provides information of all those contracts which are about to expire within a year and renewing services for such contracts will have opportunity to generate revenue in coming year.

Business to Business (B2B) is one more tool which achieves quote creation, ordering and contract management functionalities of CSCC via XMLs.

3. Module Lead, Mahindra Satyam, Hyderabad(December 2008 – August 2011) Client: CISCO Systems

Project: Cisco Service Contract Center (CSCC – QA) Module: Online Contract management (OCM)

Team Size: 8 (7 offshore and 1 onsite)

Project Description: OCM is a custom tool used to perform Online Contract Management (OCM). OCM performs the following the following functions. OCM is used by both internal & external users. Moves between contracts and within contracts

Adds to Contracts.

Changes to contracts

MMAT (Mass Additions and terminations) is used for product addition and termination in large numbers. AM (Access Management) is tool for granting and revoking access to contracts for different users. C2C (Chassis to chassis) application deals with major and minor products and the transactions performed with them.

4. QA Engineer, Satyam Computer Services LTD, Hyderabad(June 2007 – November 2008) Client: CISCO Systems

Project: AR & PR2S Interface Testing

Team Size: 3 (2 offshore and 1 onsite)

Project Description: AR & PR2S interface Testing involves the regression testing where in some changes in design exits. In this we have Inbound and outbound interfaces which comes under PR2S. We have Oracle applications and a tool called SVO to be used in this project to execute the test cases. Inbound Interface: The changes in inbound interface handles RMA Updates coming from Everest/QTC. The PR2S inbound interface processes RMA updates from Everest. Everest publishes RMA data (header, lines and notes) which is then transmitted via Cisco Data Bus to C3. A concurrent program polls the header table periodically then launches a concurrent program which spawns off the interface workflow. The workflow contains the validation logic for header, line, and note as well as routines to complete Product RMA line flow activities.

Outbound interface: The outbound (C3 to QTC) interface informs QTC when a receipt has been completed in C3. As part of the Everest release, the PR2S interface will be upgraded to meet the new functional requirements and will be re-architected to meet the standards for a near-real time interface between two OLAP databases.

5. QA Engineer, Satyam Computer Services LTD, Hyderabad(June 2006 – June 2007) Client: CISCO Systems

Project: GSO Dashboard

Team Size: 3 (2 offshore and 1 onsite)

Project Description: The GSO dashboard project will be taking data from Xelus, SPO and C3 into business Layer (and ultimately Siebel Analytics) for Dashboard reporting. The architecture which has been decided upon is to put the required from xelus and SPO into C3 first, and then pull all of the required data from C3 into the Business Layer. It consists of eight interfaces which are independent with one another.

The project involves authorizing and execution of test cases of these 8 interfaces and their data flow using SQL queries and UNIX.

6. Team Member, Satyam Computer Services LTD, Hyderabad(Jan 2006 – June 2006) Client: Merrill Lynch, USA

Project: IDS QA.

Team Size: 11 (9 offshore and 2 onsite)

Project Description: IDS QA is a testing, QA certification effort. The team at offshore is responsible for testing applications/products. Applications are released for QA Testing either as a Minor Upgrade, Major Change Release or a service pack release. The QA team has the responsibility for certifying any release

(Minor/Major/Service Pack). The QA Team is also responsible for automating certain Applications/Products using Rational Robot/Test Manager. Merrill Lynch Europe Plc. is one of the major financial investments company in the US. The SMLADC (Satyam Merrill Lynch Alternate Development Center) develops software for ML as part of the offshore software development activities of the client. We have many internal applications under IDS QA.

7. Team Member, Satyam Computer Services LTD, Hyderabad(July 2005 – Jan 2006) Client: GSK, UK

Project: Hyperion Planning Custom Solution

Team Size: 2 (1 offshore and 1 onsite)

Project Description: HPCS facilitates the cost center managers to view their Scenarios, cost centers, add, delete and update employee, contingent worker and contract information. This system provides an input capturing facility to update information pertaining to head count for a cost center in a scenario for a year. 8. Team Member, Satyam Computer Services LTD, Hyderabad(Feb 2005 – July 2005) Client: GSK, UK

Project: HARP

Team Size: 2 (1 offshore and 1 onsite)

Project Description: The HARP (Harmonization for Analysis and Reporting Program) System provides a set of applications that support analysis and reporting activities associated with the drug discovery and development process. The system provides a controlled repository for SAS programs and data used in the production of data displays and reports, automates the creation of Case Report Tabulation packages for FDA submission, and provides a set of utilities to support pharmacokinetic analysis. The HARP system is comprised of two parts: HARP Application Suite and HARP Reporting Tools. 9. Team Member, Satyam Computer Services LTD, Hyderabad(Feb 2004 – Jan 2005) Client: GSK, UK

Project: POINT

Team Size: 4 (3 offshore and 1 onsite)

Project Description: The GSK POINT system is a GlaxoSmithKline internal web-based commerce system that includes the ability for sales representatives to order promotional items and supplies, as well as place convention orders. The system incorporates the use of an eligibility check that will provide a catalog of those products available to the specific sales representative. The sales representative will be able to track their monthly usage of a product, against their defined order maximums. The system will also provide integrated capabilities for Administrators to manage Promotional items, the limits available to a given Selling Face, and the ability to create Temporary Teams that can promote an item. Also, Administrative users will have the capability to place orders for a single rep, mass orders, and convention order. Communication:

Ensuring continuous interaction with the customers through conference calls for various problems & make sure that area of concern can be worked upon for improved service levels

Rendering viable solutions to the clients; assessing the customer feedback, evaluating areas of improvements & providing critical feedback on the same

Educational Background:

Master of computer applications from Osmania University, Hyderabad in 2003 with 78.5%

Bachelor of science(MSCS) from Osmania university, Hyderabad in 2000 with 85%

Intermediate from Board of Intermediate Education, Hyderabad in 1997 with 76%

10th class from Central Board of Secondary Education with 64%

Contact this candidate