Sales Test

Kishore Garikapati

Ph: 818-***-**** Email: *************@*****.***

SUMMARY:

Over 12+ years of experience in IT as QA Lead / Test Manager, Sr QA Analyst.

Knowledge of AGILE w/ SCRUM and Waterfall Methodologies

Experienced in Health care insurance and Finance/Banking industries.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, ETL

Experienced in preparing the Test Plan, Strategy and Scope documents.

Implementing REST/SOAP Web Services Framework using SOAPUI, JMeter, JAVA Framework for Backend API, to test web services and automation of web services.

Experienced in the Regression Testing, System Testing, Risk Based Testing, UAT Testing, Quality Management, Requirement traceability Matrix and Root Cause Analyses.

Cross-browser, cross-platform and functionality testing of Flash/Flex Applications, video streaming, and rich media banners.

Experienced in Defect Tracking and Reporting using Test Director, ALM Quality Center, Team Track.

Experienced in Team Management Activities of Team Building, Methodologies and Techniques, Project Meetings, Estimations, Issues Resolution, Test Data Availability, Tracking, Audit, Resource Plans, and Schedules

Experienced in Financial Services (Sales and Retirement) Applications – Sales force, Wholesaler Compensation, Data ware House, Congo’s, Mobile, Nevis’s, Licensing and Internet Applications

Experienced in Financial, Insurance and Manufacturing Domains.

Prepared and documented Manual/Automated Test Scripts, Test Scenarios, Use cases based test case design and Test Cases for both Manual and Automated testing.

Involved in Agile methodology with Scrum Process for the product development.

Extensive Experience in all phases of Software Development Life Cycle and QA Life cycle.

Experience in Black Box Testing of applications related to Insurance, Healthcare, Finance, Automobile and Banking verticals.

Expertise in software management tools, Quality center, Test Rail, Rally, Test Director, PVCS tracker and Clear Quest for Defect tracking and reporting.

Solid Back End Testing experience by writing and executing SQL Queries.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Experienced in Web Services Testing using SOAP UI Tool, Jmeter

Experienced in preparing the Reports with all the Metrics.

Extremely dedicated, self-motivated, proactive and willing to take up the responsibility.

Self starter approach with proven problem solving skills.

Experience in Web & Client / Server application, Internet, Intranet, ETL and Databases.

Solid Backend Testing experience by writing and executing SQL Queries.

Skilled in data manipulation using SQL queries and writing PL/SQL procedures.

Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Experience in UNIX commands and executing them on different LINUX flavors.

Assign and schedule QA Analyst tasks and operational duties, working with onshore/offshore resources.

Good experience in understanding of testing methods, tools, and software testing best practices and business requirements. Ability to perform effectively and efficiently in team and individually.

Ability to communicate technical issues or project details with QA Team and Development Team.

Lead the test effort for assigned projects/applications.

Manage multiple concurrent project priorities and Interact with the client, users, and other team members.

Lead the QA efforts related to the assigned project and prepare release notices for daily/weekly build content.

Drive testing efforts of multiple projects simultaneously work with QA, Development, and end user personnel to identify & resolve issues.

EDUCATIONAL QUALIFICATION

Bachelor of Engineering

Masters Diploma in Computers

Certified Scrum master

PROFESSIONAL EXPEIRIENCE

Fox Networks (Contractor) Playa Vista, CA

QA Lead Jan 16 to Present

Interacting with the Client directly and understanding the Business Requirements.

Created Manual and Automated test scripts using Key word driven/Module oriented frame works for web applications, Siebel application, Unix applications, Web services,, web/mobile applications and Data base applications

Involved in Black Box/Grey Box Testing against large-scale database systems.

Responsible for identifying, logging, tracking and escalating bugs/Defects and verifying the bug fixes through Regression testing and updating the QA documents.

Participated in gathering all business and functional requirements to develop test plan and test cases for manual, strategies and scenarios for automation testing

Used Rally (Agile Project Management tool) for creating user stories, test cases, tracking defects.

Used JMeter scripts to test the Tablet applications on a Motorola set top box and cable television head end at the Cable Labs, Colorado.

AIG Financial Services Woodland Hills, CA

QA Lead Jan 12 to Jan 16

Worked in the Sales force Project from scratch. Involved in Siebel to Sales force Migration Project, Wholesaler, Compensation, Rewrite Project, Siebel Upgrade from 7 to 8.x, Fixed Annuity Data Migration, Fixed Annuities Website (Western National) Migration to AIG Annuities Website (AIG Sun America), Database Upgrade Projects (SQL Server, Oracle),Infrastructure Projects (Application Server Migrations, Server Upgrades),Sales force and EDGE (OMS) Integration Project, Outlook Integration with Salesforce, Pyxis Mobile (IPAD) Integration with Sales force

Developed and managed release strategies, processes, procedures, and production delivery schedules for multiple software applications.

Leading a team of 6 QA Engineers (2 onsite and 4 offshore) - Assigning duties, obtaining updates, and providing guidance when needed.

Involved in Project Management, Test planning, Resource planning & code walkthroughs, Release Management, Risk analysis, Point-to-Point Coordination

Provided QA Estimates for all Projects

Responsible for tracking status and progress of all testing phases for the Project.

Testing performed in all the Unit Testing, Dev Testing, QA, UAT and Production Environments.

Created and executed Automated Tests for both the Back end and the Front-end applications. Backend (API/Databases), Front-End (UI, Web/Mobile/Android/IOS applications)

Join SCRUM team and keep good collaboration with Dev, PO, manager and other team members to complete tasks in good deliverables

Performed Functional and Performance Testing using JMETER and SOAPUI for APIS/UI with JMETER (PROXY).

Created automated test scripts for the Front end Applications and Data base applications using SELENIUM Web Driver.

Involved in UAT, End to End Testing of the Applications, cross-browser testing

Responsible for identifying, logging, tracking and escalating bugs/Defects and verifying the bug fixes through Regression testing and updating the QA documents.

Worked with Mobile Applications (IOS, Android) and automated the applications using APPIUM/Selenium Web driver, Simulators, XCODE.

Worked with JENKINS Build Server

Worked on Deploying the New Builds Daily and Checking the Logs for any Deployment errors

Worked on Verifying the Logs to give detailed analysis of the issues to the developer which helps in identifying where the issue is exactly present in the code.

Fully integrated with RALLY/JIRA/TestRail for Test Management activities, created separate test sets for each release based on the severity.

Developed defect life cycle for Sales (Siebel, Sales force and Wholesaler Compensation), Data ware House (EDW), Congo’s and Mobile Applications in Team Track,

Work Assignments to the Onshore and Offshore Teams for All Releases,

Involved and handled Release Manager Tasks for Releases,

Generating Actuarial Audit Scripts

Environment: Sales Force, Siebel 7x,8x, IVR, Enterprise Data Ware House, Congo’s- BI 7x, 8x, 10x, Wholesaler Compensation, Data Stage, Nevis’s, ACES, Sircon (Licensing), SLIM, ALM Quality Center 9x,10x, Team Track, Peregrine, Oracle, SQL Server, Actuarial, IPAD, IPHONE, Black Berry, Mobitor, Sales Logic.

AIG Financial Services Woodland Hills, CA

Sr QA Analyst/ QA Lead Jan 08 to Jan 12

Annuities Data Ware House (ADW) Project, Web redesign Project, Cognos 7x to Cognos 8 Migration Worked in the EDW Nightly Cycles Improvement Project, Name Change projects for Sales and EDW Applications, Quarterly CBD Update Projects for Sales and EDW Applications, DCA Rate information Project Supported enhancement projects to the Sales force, Wholesaler Compensation, IPAD, Data ware House, Cognos - BI and Internet and Navisys Applications

Involved in Project Management, Test planning, Resource planning & code walkthroughs, Release Management, Risk analysis, Point-to-Point Coordination

Coordinates resources in several locations and with several different types of QA tasks.

Logically perform structured and exploratory testing

Superb bug tracking skills and analytical attitude towards work

Strong time management, accountability and organizational skills

Use of Charles Web Debugging Proxy/Firebug/Web console.

Current knowledge of mobile and web application testing and tools

On call support during the non-working hours

Drives the overall QA planning /tracking and reporting for assigned project(s).

Communicate test progress and summary metrics to the project team

Lead defect meetings and ensure accurate and timely status updates to project team

Verify entry criteria and exit criteria is complete

Assist testing team members where possible

Escalate issues to QA leadership that impede the test effort

Supervise data and environment coordination

Monitor testing progress and test execution schedule

Coordinate schedule for builds and fixes

Monitor and approve of builds in the QA environment

Created Test Plans for Application Interfaces and Data Interfaces Modules by referring to the Business Requirements and Functional Specifications.

Created test scenarios and test cases. Planned for test execution and resources.

Designed and Developed Backend Web services Data driven SOAPUI Automation Framework By using Groovy Scripting and Validating the Services data against Oracle database.

Created Automated test scripts for the Front end Applications and Data base applications using SELENIUM Web Driver.

Involved in UAT, End to End Testing of the Applications, cross-browser testing

Responsible for identifying, logging, tracking and escalating bugs/Defects and verifying the bug fixes through Regression testing and updating the QA documents.

Deployed code to the QA DEV, QA, Staging and UAT environments and package up software for production.

Analyzing business requirements and incorporating them into overall system testing.

Assisting in writing test plans, test cases and generating automated test scripts

Ensuring any unresolved problems or issues are properly documented, escalated and monitored

Providing detailed walkthroughs of defects to developers and other project team members and assisting them to understand and resolve open defects.

Coordinating with AVP/VP to ensure tasks are aligned with and follows the appropriate project delivery process for the testing phase.

Environment: Enterprise Data Ware House, Congo’s- BI 7x, 8x, 10x, Wholesaler Compensation, Data Stage, Navisys, ACES, Sircon (Licensing), Mainframe, SLIM, ALM Quality Center 9x,10x, Team Track, Peregrine,Oracle, SQL

AIG Financial Services Woodland Hills, CA

Senior QA Analyst /QA Lead Jan 04 to Jan 08

Sales logic to Siebel Conversion, Mobitor Implementation, Broker Dealer Mergers, Name Change projects for Sales and EDW Applications, Quarterly CBD Update Projects for Sales and EDW Applications, Supported enhancement projects to the Siebel, Wholesaler Compensation, Dataware House, and Navisys Applications Projects

Involved in Project Management, Test planning, Resource planning & code walkthroughs, Release Management, Risk analysis, Point-to-Point Coordination.

Created Traceability Metrics for requirements coverage.

Analyzing Business requirements/change requests to understand the business flow.

Regular interacting and coordinating with project managers to understand the business requirements.

Participating in design walkthroughs.

Used multiple operating systems -- Windows, Mac, Android and ios to test the functionalities of the application.

Providing input/status updates regarding test progress/results.

Performed testing for various Application Interfaces and Validated the reports from third party vendors

Interacting with the Client directly and understanding the Business Requirements.

Created Automated test scripts using Key word driven/Module oriented frame works for web applications, Siebel application, Web services,

Created and Executed Test Plans, test cases, test scripts, test matrixes and test procedures as per the user stories, business requirement docs

Created Manual and Automated test scripts using Key word driven/Module oriented frame works for web applications, Siebel application, Unix applications, Web services, Flash/Flex, web/mobile applications and Data base applications

Involved in Black Box/Grey Box Testing against large-scale database systems.

Responsible for identifying, logging, tracking and escalating bugs/Defects and verifying the bug fixes through Regression testing and updating the QA documents.

Participated in gathering all business and functional requirements to develop test plan and test cases for manual, strategies and scenarios for automation testing.

AT & T Wireless Odyssey

Sr. QA Analyst Jun 03 to Jan 04

Analyzing Business Requirements and creating the test cases around those requirements.

Providing walkthroughs of the test plan to developers and analysts.

Creating/maintaining test scripts in QC test plan.

Executing test sets in QC test lab.

Ability to work on multiple projects simultaneously with aggressive schedules.

Create test requirements, test plan, test scenarios, test data with high testing coverage and pass rate

Execute QA testing, submit bugs, push bug resolved, analyze test failures, and deliver 100% test report

Defines standards for development of manual & automated test scripts, deployment and reuse

Participates in formal reviews of business requirements and application designs

Ensures proper test coverage exists based on requirements and design specifications.

Recommends strategies and methods to improve test plans and process

Create and executes manual and automated test scripts for most complex projects in a most efficient and modular fashion

Coordinates test schedules, work and resource plans; manages progress of all test activities against plan

Establishes testing entrance and exit criteria

Identifies and manages critical path of testing

Ensures execution of project regression testing tasks

Trains others within the immediate team on testing techniques and automation

Environment: Siebel 7.5.2, Test Director 7.6, QTP 6.0, Clear Quest 5.2, Clear case 5.0, Windows 00, XP, UNIX, Numeric Track, Vitria (middleware), Activation Manager (Switch manager) Atlys, Orbit, SOA, CODE-1, INFOFLO (Inventory and Shipping) And Fusion Works (Mediation)

BOECOM Replacement Project Boeing, Renton, WA

Sr. QA Analyst Oct 01 to May 03

The Commercial Airplane Services (CAS) Division of Boeing Commercial Airplanes (BCA) provides post-delivery support for its products and services. Post delivery support includes the submittal of technical requests by airline customer to Boeing for resolution.

Using Siebel eCustomer (eSales) and Order Entry to market and Sell a limited set of their products on-line. The Customer will view products on-line, add them to their shopping cart and perform checkout and payment on-line, which enables to implement, Work Flow, Assignment Manager, and map to Boeing business rules and processes Interfaces was built to legacy systems.

Responsibilities:

Functional and Regression testing for Entire Siebel Application Functionality including Views, Screens and Workflow Scenarios.

Extensively used Siebel Tools to Test the Configuration and it’s impact on the Performance.

Interaction with the Users, Business people, Clients Technical Team to gather the Functional/Technical Requirements.

Automated Test Scripts using QTP.

Involved in defining Responsibilities, Positions using Application Administration.

Tested Lov (List of Values), Lov Explorer using Application Administration

Responsible for writing Test Scripts test Procedures and execute them manually.

Creating effective Test Plans to ensure the proper functionality of developed component.

Involved in System Test, Integration Test, and User Acceptance test.

Developed of Test Plans, Test Cases and checking the screens for Quality Assurance.

Extensively involved in Object Level Testing including Applets, Views, Business Components, and PickLists etc.

Using Siebel Tools, Tested all relationships like Multi value Links, Multi value field, Multi value Group in application.

Tested the data in Siebel after the EIM Process Done.

Tested the real time Interface between Siebel and Legacy System, what are the Input & Output Parameters.

Tested the performance of Siebel EAI Process (Workflow).

Manually performed Ad-Hoc testing end-to-end testing, System testing, Regression testing, and Function testing.

Work with developers, business and Release managers to discussed ways to fix the Defects.

Uploaded manual test scripts into Test Director for Manual and Automation Execution.

Analysis, Generation and Customization of the Test Results Reports and Graphs using Test Director.

Generating the Documentation for the Test Results with Pass and Fail Results using Test Director.

Generating the all Level Reports (Requirements, Test Plan, Test Lab) using Test Director.

ENVIRONMENT: Test Director 7.6, QTP 5.6/6.0, Siebel 7.5.2, and Siebel Tools 7.5.2, Workflow Administration, Clear Quest 5.2, Oracle, Developer 2000, VISIO, UNIX, HTML, SQL, PL/SQL, Access and Visual Basic.

Bank of America Charlotte NC

QA Analyst Jun 99 to Sep 01

AEROSPAN wood dale, IL

QA Analyst Jun 96 to Sep 99

Contact this candidate