senior qa automation engineer

VENKATA SURAPANENI

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

Ph: 703-***-****

Phone: 703-***-****

Professional Summary:

Over 12 years of experience in analysis, design, development, architecture and testing of Client/ Server and Web based applications in Financial, Trading, investments, Insurance and Identity Access management (Information Security) verticals

•Complete understanding and hands-on experience with QA and Testing Methodologies. This includes Test Planning, Execution, Bug tracking and Analysis.

•Developing Test Strategies, Test Plan and Test Cases.

•Unit, Integration Testing, System Testing, Load Testing, Performance Testing, Functional Testing, Regression Testing, Smoke Testing, Database testing, User Acceptance testing and End to End Testing.

•Database testing using SQL, PL/SQL

•Extensively used Quality Center as a Defect tracking system, Defects reporting system.

•Hands on experience in Black box and White box testing.

•Functional/GUI/Regression automation, using Mercury Interactive tools (Win Runner, Quick Test Professional).

•Defect tracking and change management using Test Director, Rational Clear Quest, and PVCS, QA Director, QA Run, File Aid

•Worked in different models of software standard V-Model, Agile Model

•Training in Six Sigma Methodology- Green Belt.

•Integrating four Quality Management modules - Requirements Management, Test Plan, Test Lab, and Defects Management using Test Director - to allow for a smooth information flow between various testing stages.

•Comprehensive understanding of Test Director’s Defect Manager, which supports the entire defect lifecycle from initial problem detection through fixing the defect and verifying the fix

•Integrating Test Director with Win Runner using Test Director Connectivity.

•Expert in documentation using MS tools (Word, Excel, PPT, Project, Visio, Access)

•Possessing excellent communication skills and an ability to work as a team member, as well as independently.

•Ability to cope up with tight schedules.

•Self-motivation and Strong Analytical Skills set.

• Involvement in complete life cycles of various projects like Enterprise Web Systems, Client/Server applications, & Database Applications,

TECH SKILLS

Operating Systems

Microsoft Windows, Linux, Android OS, iOS

Languages

SQL, Core Java, VBScript

Databases

MySQL, Oracle

Web Technologies

HTML 5.0, XML,CSS 3.0

PROJECT METHDOLOGY

Agile-Scrum, Waterfall

Tools& Utilities

Web, Windows and Mobile application testing, Test Tracker, Buganizer, Android Debug Bridge, DB testing, Agile Testing Methodology (Scrum-XP), Perfecto Mobile, Iovation, HP –UFT 12.5 -formerly QTP, Test Complete ALM 12.01 formerly HP QC, JIRA, Selenium Web driver, Eclipse, Firebug, Fire path, Maven, Jenkins, Apache POI, JMeter, TFS, Putty, IBS Rumba, FICO, Appium, REST API

Frameworks

TestNG, Page Object Model, Data driven and Keyword driven frameworks

BROWSERS

Mozilla Firefox, Internet Explorer, Safari, Google Chrome

Packages

MS-Office Suite (Word, Excel, Access), MS-Project and MS-Visual Studio

Domain Knowledge

Communications, Insurance, Banking, Logistics, Telecom and Financial domains.

EDUCATION & CERTIFICATIONS:

Bachelors of computer science, (Math, Statistics, Computers) 1993

Six sigma Certified (Green Belt).

PROFESSIONAL SUMMARY:

Project: ServiceNow Sep 2014 to Present

Client: FannieMae

Sailpoint/ServiceNow UAT Lead

Program for Information Security department supports several key processes at FannieMae Using IIQ Sailpoint for Access Recertification, Provisioning and deprovisioning and Replacing Service online platform to Service now by migrating all the online request for the interfaces using COTS (Commercial of the shelf) Sail point and ServiceNow.

Responsibilities:

Sailpoint.

•Lead the effort in the integration of the Access Recertification and external products for Sail point.

•Lead the effort for integration of roles from IIQ to Service now

•Prepared UAT test cases and testing estimates

•Involved in coordinating with Users and performed User Acceptance Testing.

•Worked with business analysts regarding Role Management and Role-based Access Control (RBAC)

•Validate data from OIM from the source system for IIQ.

ServiceNow

•Worked with Business Users to develop Business Requirements and Use Cases.

•Worked closely with IT and business teams to plan testing approach, cycles and strategies.

•Responsible for creating test data and coordination between SIT and UAT teams.

•Involved with implementing the Change, Problem, Incident, HRCM Modules

•Data Migration testing, Wrote SQL Queries to check the data from Source and Target.

•Created the test plan and requirement traceability matrix.

•Used Descriptive Programming to create VB Script functions (Keywords).

•Involved in reporting the manual and automation test case execution results to the project team.

•Extensively used SQL for backend validation.

•Maintained the Automation Frame Work for the project.

•Developed automated test scripts for Regression testing of My Services application using QTP 11.0.

Environment: Java, VB Script, QTP 11.0, UFT 12.01, ALM 11.5 Jira, TOAD, MySQL, XML, OIM

Project: Identity Access Management July 2013 to Sept 2014

Client: Yale University

IAM Program Test /UAT Lead

Yale University implementing Identity access management COTS product Sailpoint which facilitates the Provisioning of internal user IDs, accounts and recertification for, quarterly and/or annual security reviews on all Yale University deployed applications by replacing the current OIM system.

Responsibilities:

•Estimation of work, Prioritization of work, Work assignments, Resource Planning.

•Develop Schedule, Identify Risks and mitigation plan

•Provided Status reports to upper Management on a regular basis.

•Execute batch jobs/online function codes and verify the report on day to day basis

•Develop and Execute Test cases in HPQC ALM.

•Defect Tracking in Quality center

•Working with the team of developers in prioritizing issues

•Working closely with IT and business teams to plan testing approach, cycles and strategies

•Managing testers work throughout test plan, test cases development and test execution

•Worked with business analysts regarding Role Management and Role-based Access Control (RBAC)

•Validate data from Virtual Directory from the source system

•Web services testing using SOAP UI validated the rest queries

•Responsible for test data and coordination between multiple infrastructure teams

Environment: Active Directory, SOAPUI 4.63, XMLSPY, OIM, Sailpoint, Enterprise Directory, Unix, VDS, SQL Plus, HPQC ALM

Project: Sail Point Nov 2012 to July 2013

Client: OfficeMax

Chicago, IL

QA /UAT Lead

OfficeMax implemented Identity access management COTS product Sailpoint which facilitates the recertification of internal user IDs, accounts and resources by conducting monthly, quarterly and/or annual security reviews on all OfficeMax deployed applications by replacing the current usermax system.

• Lead the effort in the integration of the Access Recertification and external products for Sailpoint.

•Responsible for accomplishing software quality assurance of the product

•Managed team of SIT and UAT testers, provided guidance and mentoring to testers in identifying scenarios from complex requirements.

•Prepared UAT test cases and testing estimates

•Assured software delivered meets all requirements and expectations of final UAT test plan

•Responsible for producing test artifacts like Test Plan, Test Strategy, Test Scripts, Test data, Test Summary Reports, Test Results, Test Metrics and Requirements Traceability Matrix

•Coordinated efforts in onsite/offshore model

Environment: Active Directory, SAP, Oracle, Sybase, Mainframe, Sun IDM, IBM Web Logic, HPQC ALM Clear Quest

Project: SailPoint Sep 2010 to Nov 2012

Client: Freddie Mac

McLean, VA

QA Lead

The SailPoint facilitates the recertification of internal user IDs, accounts and resources by conducting monthly, quarterly and/or annual security reviews on all Freddie Mac deployed financial applications, databases and platforms to ensure access confidentiality, integrity and appropriateness.

Responsibilities

• Lead the effort in the integration of the Access Recertification and external products for Sailpoint.

•Responsible for accomplishing software quality assurance of the product for 3 releases

•Managed team of testers, provided guidance and mentoring to testers in identifying scenarios from complex requirements, design/architecture driven testing and risk based testing

•Guided team in writing negative/boundary tests and end-to-end tests

•Guided team in testing various aspects of the system like ETL (Data loads), JavaWeb-based application testing, COTS customizations, conditional logic, reconciliation processes etc

•Prepared decision tables to analyze complex condition logic in workflows

•Prepared test design document that is meant to bring a new tester quickly up to speed

•Reviewed/Analyzed Requirements and design and provided feedback from quality assurance perspective

•Responsible for producing test artifacts like Test Plan, Test Strategy, Test Scripts, Test data, Test Summary Reports, Test Results, Test Metrics and Requirements Traceability Matrix

•Involved in Data Migration testing Prepared SQL queries according to the business rules

•Contributed to improve Freddie Mac's Software Testing Process

•Developed QTP automation frameworks (using Descriptive Programming) for Request submission and Approval processing

•Written complex SQLs statements involving nested queries, sub queries, insert/update scripts etc

•Executed unix shell scripts to accomplish file loads

•Guided team in setting up test data for all possible data conditions

•Performed grey box testing inspecting the code in stored procedures, stored functions, packages and unix shell scripts

•Served as subject matter expert for auto-provisioning on Oracle & Sybase platforms

•Executed meetings like Defects Review Meeting and participated in meetings like Requirements walkthrough, Design walkthrough and code reviews

•Coordinated efforts in onsite/offshore model

Environment: Oracle Identity Manager, Sybase 15.x/12.x, Oracle 11i/10g, Unix, Tivoli Access Manager,DB2 UDB, Lotus Notes, Active Directory, Barclay's Capital UI, Quick TestPro 9.1, Sun IDM, IBM Web Logic, Mercury Quality Center, Clear Quest

Macy’s Atlanta, GA Feb 2010 to Sep 2010

QA Lead/Onsite Coordinator

Increase sales opportunities and ability to leverage existing MST and Macys.com systems, tools, and reporting. Provide capability for Bloomingdales.com to operate similar to the MLO operating division. This new region will provide pool stock for Bloomingdales.com and Bloomingdale’s stores.

•Estimation of work, Prioritization of work, Work assignments, Resource Planning.

•Develop Schedule, Identify Risks and mitigation plan

•Provided Status reports to upper Management on a regular basis.

•Execute batch jobs/online function codes and verify the report on day to day basis

•Develop and Execute Test cases in Quality Center

•Defect Tracking in Quality center

•Working with the offshore/onshore team of developers in prioritizing issues

•Working closely with IT and business teams to plan testing approach, cycles and strategies

•Managing testers work throughout test plan, test cases development and test execution to ensure testing is on time and on budget

Environment: IBM Mainframe, COBOL, File Aid, Quality center v9.2, 10.0, Oracle, DB2.

JP Morgan Chase Chicago, IL Mar 2009 to Jan 2010

QA Lead

JPMC Treasury & Securities Services (T&SS) is rolling application functionality with new Intranet Deal Model Wizards for deal making by updating, Service codes edited with change and propsed price and Volume any changes to the DDA & Liquidity Investments.

•Created Test strategy documents.

•Defect tracking in Quality Center

•Estimation of work, Prioritization of work, Work assignments, Resource Planning.

•Develop Schedule, Identify Risks and mitigation plan

•Provided Status reports to upper Management on a regular basis.

•Execute & provide PVT Implementation Support

•Working with the offshore/onshore team of developers in prioritizing issues

•Working closely with IT and business teams to plan testing approach, cycles and strategies

•Managing testers work throughout test plan, test cases development and test execution to ensure testing is on time and on budget

•Measuring and monitoring progress during each test cycle to ensure that the application is tested, validated, and that it meets or exceeds expectations

•Setting up check point meetings during testing, following up with the developers on issues and following up with the testers during all phases of testing

Environment: Apache (HTTP Server), AJAX, EJB, J2EE, SAP (GL), SAP (CO), Tivoli, Weblogic (Application Server), Quality Center 9.2, Quick Test Pro, Load Runner

National City Cleveland, Ohio Apr 2008 to Feb 2009

QA Lead

Marketing event Performance Analysis Reporting (MPAR) approach provides marketing sales specific analytics through an integrated multi-dimensional marketing portfolio data model, leveraging shared Business Intelligence/Reporting (BI/R) platform capabilities and assets. The goal of MPAR is to provide crucial insights into marketing dynamics, with proactive information delivery and self-service data analytics

Equifax Alpharetta, GA

Jun 2004 to Mar 2008

QA Lead

It’s latest solution,“ InterConnect product suite “ is an integrated suite of modular components that supports automation of various business processes, including application processing, decisioning, data acquisition and integration of various complex systems with minimal hardware and software requirements. It is credit decisioning solution which allows inputs from internal and external databases, including a variety of third-party sources. Inter Connect supports Application Processing, Advance Decisioning, Change control, Strategy Management, Integration Services, Data reporting and storage services.

Contact this candidate