VENKATA S. VELAGALETI

Visa Status: U.S. CITIZEN

Current Location: Phoenix, AZ, U.S.A.

Cell: +1-503-***-****; Phone: +1-503-***-****; Email: adcsq5@r.postjobfree.com

SUMMARY:

Sr. Quality Assurance Professional with 20 years of total IT experience in the area of Software Quality Assurance and Testing. Expert in automated and manual testing of Web, Mainframe and Client Server based applications including Banking(Banking operations, modules, Swift messages, Fedwire messages Chips messages ), Finance, Health care, Auto Insurance, POS(Point Of Sales), GPS, Mobile Applications, E-Commerce and Bio-Medical etc.

Instrumental in successful execution of several Turn-Key Software Testing Projects with extensive experience in Functional and Regression, End-to-End testing, downstream and Back-end testing in all stages of Software Development Life Cycle. Efficient in delegating, delivering and managing tasks with good communication and interpersonal and time management skills. Polished and professional with a passion for client success.

PROFILE:

Strong experience in all areas of QE Engineering, Automation Developer, Perforomance Tester, Backend/Databse tester, Webeservices Tester, Core Java Coder, SQL Developer, Test Lead & Test Manager

Expert in Automation Testing using Selenium WebDriver using Core Java, C# and QTP with VB scripting and Descriptive programming

Strong in designing and set up of Automation Frameworks in using Core Java, Selenium WebDriver, VB Script, QTP from scratch

Strong in Designing PageFactory and Page Object Model (POM)

Strong in ETL/Datawarehouse-Informatica testing

Extensive experience in Performance, functional/ regression and backend, Webservice testing.

Strong in End-To-End, Interface and Integration testing across many complex applications in complex environments

Strong Automation tester using: QTP, LoadRunner, TestNG, Selenium etc.

Strong in coding & scripting in Core Java script, Oracle/SQL/QTP/LoadRunner/KSH/Core Java/VB/ASP/C/C++ etc.

Expert in testing Web-based, Client-Server and Mainframes applications on different environments.

Knowledge of Software Development Life Cycle (SDLC), QA Methodologies like CMM and RUP and strong experience of Agile and Water Fall environments.

Expert in Software Verification, Validation and Testing Methodology taking active Role along with the Team Lead.

Expert in using Mercury Interactive Tools ( QTP, Winrunner, LoadRunner, Vugen, and Quality Center, Test Director) etc. taking active Role along with the Team Lead.

Extensively used VB Scripting and Descriptive Programming in QTP.

Expert in Black Box & White-Box Testing.

Extensively wrote Oracle/SQL queries, debugged scripts to extract data from backend and performed backend/database testing.

Expert in Functional, Regression, UAT (User Acceptance Testing), and Performance Testing

Strong in Analyzing Business specs, Requirements & Develop Comprehensive Test Spec & execute them.

Experience in testing Database Applications of RDBMS in ORACLE 11g/9i/8i, DB2 and SQL Server

Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining test scripts according to the business specifications.

Ability to interact with developers and product analysts regarding testing status.

Expertise in Problem solving and Tracking Bug Reports using various Bug tracking Tools.

Familiarity with C, C++, Visual Basic, HTML, XML, Core Java, J2EE, EJB, ASP, VB, .NET languages and applications.

Expertise with MS-Office Tools, MS- Visio, Excel Functions, Macros, PPT presentations, Demos

Experience and exposure with Insurance applications.

Knowledge of Medical subjects, Medical devices and instruments.

Good communication and interpersonal skills.

Good Exposure to Web Testing (Front end and Back end), Web Designing,

Graphic Designing using Macromedia Flash, Front Page, Dream Weaver, Adobe Photshop, Core Java Script, VB Script, HTML, DHTML

Good understanding of SDLC(Software Development Life Cycle) Methodologies.

Good knowledge and understanding of RDBMS(Relational Data Base Management Systems) concepts, Data Models

Comfortable with writing, analyzing, comprehension of Code, Script and SQL Queries.

Strong written and verbal communication skills.

Familiar with ERP/SAP Functional and Performance testing using LoadRunner and Rational Performance Tester

Strong in using Quality Center, QTP, LoadRunner, Rational Performance Tester, Rational Manual Tester, Clear Case, Clear Quest, Rational Manual Tester, SOAP UI, Irong Python, Extreme Tester, Fixkit, Toad, SQL Server Express Studio

Familiar with Jprobe, SiteScope and Interscope tools

Strong in using Selenium script creation and automation using Java, C#.

Extensive Defect Management and Defect Tracking experience

Strong experience as Team Lead

Experience with gathering Business requirements and analysis and writing Business Requirements

Experience with testing Mobile applications.

Experience with HIPPA applications.

Familiar with Python and Ruby scripting automation

Trained in Big Data-Hadoop technologies

Strong experience in all areas of QA Analysis and Testing: Manual, Automation, Database/Backend, Validation, Security, Performance, End-To-End, Smoke, Regression, Boundary, Negative testing

Strong experience in Korn Shell(KSH) script modification, Batch jobs execution in Unix and Linux

Familiar with Adobe ExperienceManager (AEM)

Familiar and getting stronger in Machine Learning, Robotic Process Automation (RPA) Framework.

TECHNICAL SKILLS :

Programming Languages

Core Java, C#, SQL, PL/SQL, C, C++, Shell Scripts, TSL, UML, HTML, XHTML, VB Script, Core Java Script, .Net, NodeJS, AngularJS

TESTING TOOLS

SELENIUM WEBDRIVER, SELENIUM IDE, SELENIUM GRID, SELENIUM RC, Test Complete, Test Director, Win Runner, Load Runner, QTP, Rational Functional Tester, Manual Tester, Rational Robot, Clear Quest, Clear Case

Other Tools

Fitkit, Iron Python, Reflector, Extreme Tester, Protractor, TDM

Databases

Oracle 11g/9i/8i, DB2 8.1,MS Access, MS SQL Server 2000/7.0, Informix and MySql, T-SQL

Application Servers

IBM WebSphere 3.5/4.0.3/5.0/5.1, Weblogic 5.x/6.x/7.x/8.x, Oracle 11i as Application server, JRun 3.x/4.x, Tomcat 3.x/4.x

Web Servers

Continuous Integration(CI) tools:

Apache, Tomcat, Microsoft IIS 4.0, Core Java Web Server, IBM HTTP server. Middleware MQ Series / WebSphere M

Jenkins, Bamboo, Sauce Lab, BitBucket

Version Control /Design Tools

GITHub, SVN, Clear Case, RationalClearQuest, Telelogic CM Synergy, RUP

Operating Systems

Big Data-Hadoop

SUN Solaris v2.6, AIX, UNIX, Windows NT 4.0/98/95/2000, IDEWeblogic Workshop, IBM Web Sphere Studio (WSAD) 4.1.1/5.0, PowerBuilder 6.5, Visual Basic 6.0, Rational Rose, XML Spy, Visual Studio

Trained in Big Data-Hadoop technologies

TECHNICAL PROFILE :

Training in Software QA/Automation Engineering-Testing Tools (Automation and Manual)

Load Runner training by HP company June 2009.

Quick Test Professional (QTP) training by HP in August 2009

Diplomas in oracle, vb, asp, Core Java, vb script, Core Java script, html, dhtml, xml

Diploma in web, graphic, multimedia & animation designing

Diploma in computer hardware

Honor’s diploma in information and systems management (H.D.I.S.M.)

Training in CCNA

Training in MCSE

Trained in Big Data-Hadoop technologies

ACADEMIC PROFILE:

S.No.

Degree

University

Place

Year Passed

1

M.L.I.SC (Master's Degree in Library & Information Science)

Dr. B.R. Ambedkar Open University

Hyderabad, Telangana, India

2005

2

B.L.I.SC (Master's Degree in Library & Information Science)

Dr. B.R. Ambedkar Open University

Hyderabad, Telangana, India

2003

3

M.A. (Master's Degree in English)

Osmania University

Hyderabad, Telangana, India

1994

4

B.Ed (Bachelor’s Degree in Education)

Kakatiya University

Warangal, Telanganan, India

1988

5

B.Sc. (Bachelor’s Degree in Science)

Osmania University

Hyderabad, Telangana, India

1983

PROFESSIONAL EXPERIENCE :

American Airlines, Phoenix, AZ Test Analyst/Automation Developer-Lead 09/2019 – Till date

Vendor: TCS America

Projects: Airlines applications: Advocate, CIBRO, CR View customer relations, Booking, Customer support systems

Roles and Responsibilities:

Used Azure DevOps for user stories, test plan, test case management, execution, repositories, creating and building jobs, pipelines, Agents

Worked on Siebel applications

Developed Automation suites & scripts using BDD,Core Java, Java script and Selenium in Eclipse IDE

Developed Auto IT scripts using Core Java script for handling external windows

Performed Automation testing, creating automation scripts, modification and execution in UFT framework for Desktop applications

Created complex queries in Oracle PL/SQL and performed database testing.

Created scripts in feature branch and merged with Master after thorough verfication of the code into BitBucket repositories and executed them in Jenkins with auto scheduling of the execution.

Performed Admin role in CI & CD in BitBucket and Jenkins and created and maintained the repositories

Used Perfecto Cloud, Saucelabs and performed Web and Cloud testing applications

Performed Mobile device and Mobile application testing on Perfecto cloud using Appium

Executed Performance testing using Load Runner.

Developed Automation scripts in Protractor, Selenium in Angular JS, Java

Involved in setting up framework in Angular JS, NodeJs, Selenium

Performed ETL Datawarehouse testing using QuerySurge:

Verified that data transformation from source to destination works as expected

Verified that expected data is added to the target system

Verified that all DB fields and field data is loaded without any truncation

Verified data checksum for record count match

Verified that for rejected data proper error logs are generated with all details

Verified NULL value fields

Verified that duplicate data is not loaded

Verified data integrity

Worked in Robotic Process Automation(RPA) Framework

Environment: Siebel, Azure DevOPs (ADO), REST API, Postman, Swagger, HP ALM QC, HP UFT framework, Selenium WebDriver, Core Java, TestNG, Jenkins, GITHub, Eclipse, UNIX, Windows, Maria DB, Oracle, SQL, TOAD, SnagIt, Jira, ETL testing tools: QuerySurge, Informatica; CI-CD: Jenkins, GitHub, Gitbash Editor, HP LoadRunner, BDD, Cucumber Framework, Robotic Process Automation Framework (RPA)

Union Bank Automation Lead/Manager 11/2017 – 09/2019

Phoenix, AZ

Banking & Finance project: CBT(Core Banking Transformation), OASIS

This is an extensive Banking & Finance project with .Net, Core Java, Mainframes, Oracle technologies with front end portal.

Creation of customer accounts, maintenance, updation.

Roles and Responsibilities:

Developed Automation suites & scripts using BDD,Core Java, Java script and Selenium in Eclipse IDE

Developed Auto IT scripts using Core Java script for handling external windows

Performed Automation testing, creating automation scripts, modification and execution in UFT framework for Desktop applications

Created complex queries in Oracle PL/SQL and performed database testing.

Created scripts in feature branch and merged with Master after thorough verfication of the code into BitBucket repositories and executed them in Jenkins with auto scheduling of the execution.

Performed Admin role in CI & CD in BitBucket and Jenkins and created and maintained the repositories

Used Perfecto Cloud, Saucelabs and performed Web and Cloud testing applications

Performed Mobile device and Mobile application testing on Perfecto cloud using Appium

Executed Performance testing using Load Runner.

Developed Automation scripts in Protractor, Selenium in Angular JS, Java

Involved in setting up framework in Angular JS, NodeJs, Selenium

Performed ETL Datawarehouse testing using QuerySurge:

Verified that data transformation from source to destination works as expected

Verified that expected data is added to the target system

Verified that all DB fields and field data is loaded without any truncation

Verified data checksum for record count match

Verified that for rejected data proper error logs are generated with all details

Verified NULL value fields

Verified that duplicate data is not loaded

Verified data integrity

Environment: REST API, Fisheye, HP ALM QC, HP UFT framework, Selenium WebDriver, Core Java, TestNG, Jenkins, GITHub, Eclipse, UNIX, Windows, Maria DB, Oracle, SQL, TOAD, SnagIt, Jira, ETL testing tools: QuerySurge, Informatica; CI-CD: Jenkins, GitHub, Gitbash Editor, Confluence, HP LoadRunner, Protractor, Angular JS, BDD

Compu-Vis Inc. Test Automation Manger 07/2017 - 10/2017

North Brunswick Township,

New Jersey

Health Application project

This is a web application project for Health Insurance catering to the needs of U.S. Veterans. It has Front end web UI and middle tier Core Java and backend databases.

Roles and Responsibilities:

Team Lead Automating the applications

Developed Automation scripts using Core Java, Core Java script and Selenium in Eclipse IDE

Used Maria DB for backend testing and developing queries and validated the data from front end UI into the backend database records

Performed defect management using Test Manger

Managed and coordinated onshore and offshore teams, assigned and monitored the progress of tasks.

Prioritized the tasks and met with timelines and deadlines.

Used Agile Scrum methodology

Developed Automation scripts in Protractor, Selenium in Angular JS, Java

Developed Automation frameworks in Selenium and NodeJS

Performed Datawarehouse ETL testing to validate the integrity, accuracy of the data

Environment: HP UFT, POM framework, Selenium WebDriver, Core Java, TestNG, Jenkins, GITHub, Eclipse, UNIX, Windows, Maria DB, Oracle, SQL, TOAD, SnagIt, Jira, ETL testing tools: QuerySurge, Informatica; CI-CD tools: Jenkins, GitHub, Gitbash Editor, REST API

ProFocus Automation Manager 11/2016-06/2017

Portland, OR

Platform2- Educational Assessment Project:

This project is a huge Educational Assessement catering to the needs of School, college students and Educators making the students take online tests and be evaluated by educators helping them to have good understanding of the abilities, skills of the students and improve their areas of learning and skills.

This has frontend portal and middle tier of Core Java and backend databases of MongoDB, Oracle which communicate through Webservices.

Roles and Responsibilities:

Performed Automation testing using Core Java, Selenium, Eclipse

Developed Automated scripts using Core Java, Selenium, NodeJS, Protractor

Involved in setting up frameworks in Selenium and NodeJS

Performed Functional, Regression testing and identified bugs in functionality of the application.

Identified bugs and prepared Bug reports with Screenshots.

Performed ETL Datawarehouse testing using QuerySurge

Verified that data transformation from source to destination works as expected

Verified that expected data is added to the target system

Verified that all DB fields and field data is loaded without any truncation

Verified data checksum for record count match

Verified that for rejected data proper error logs are generated with all details

Verified NULL value fields

Verified that duplicate data is not loaded

Verified data integrity and accuracy

Environment: BDD-Cucumber, Selenium WebDriver, Selenium Grid, TestNG, Core Java, Core Core Java, Eclipse, Jenkins, GITHub(DevOps tools), Postman, Swagger, Mongo DB, Postgress SQL, PROTRACTOR, Linux, UNIX, Windows, Maria DB, Oracle, SQL, TOAD, TeamFoundation Server TFS 2012, Visual Studio 2010, Clarify, Putty, WinScp, FileZilla, SnagIt, Jira, Querysourge, LoadRunner11, ETL testing tools: QuerySurge, Informatica, TDD, Python, Jenkins, GitHub, KSH, Korn Shell scripts, Batch jobs, Unix, Linux, REST API, Confluence, Fisheye., HP Loadrunner, NodeJS, Protractor

QUALCOMM Automation Lead-Framework Developer/ETL Tester 03/2016 - 9/2016

San Diego, CA

USA

SharePoint/DocPoint, Agile, Cognidox applications:

These are Core Java, Dot Net based applications where in the users are able to create, migrate, upload documents with metadata of Electronic chip design from Cognidox into Sharepoint and then into Agile applications with middle tier of Core Java and .Net and Oracle SQL in the back end

Functionality of the applications is being automated and tested from end to end.

Roles and Responsibilities:

Test Lead leading QA team onsite and offshore

Created and executed Automated Test scripts using Core Java, Core Java script, Selenium WebDriver and logged defects in Jira and prepared bug reports.

Used Jenkins for continuous integration of the Automation code and deployed to the QA repository and continuously integrate the code into the Master branch

Used GITHub for Source Control Management (SCM)/Versioning and to push and pull the Automation code to the QA repository and provide access to check in and check out the code.

Used Selenium Grid for parallel and distributed automated execution of Automated scripts across multiple browsers and performed cross browsers automated testing

Made interactions and co-ordinated the QA teams, holding meetings, assigning and sharing tasks, monitoring their progress and preparing the reports for the QA Manager

Created Test Plans, Test Suites and Test scripts based on Business requirements, Technical Specifications using Jira

Created SQL queries to validate test conditions, scripts to verify the functionality of the application, databases.

Performed extensive ETL/Database/Backend testing using ETL Testing tools: QuerySurge and Oracle PL/SQL on Oracle Databases in different Schemas.

Created jobs in Clarify and executed Korn Shell (KSH) scripts to run procedures, functions.

Executed KSH scripts in UNIX environment

Verified the Log files created running the KSH scripts

Executed Procedures, Functions to verify the functionality of the databases.

Used Selenium WebDriver for automation testing and for code changes and change sets and testing the fixes

Performed Functional, Regression testing and identified bugs in functionality of the application.

Identified bugs and prepared Bug reports with Screenshots.

Debugged the code and scripts in KSH, SQL procedure, packages, functions, Shell scripts

performed UAT(User Acceptance Testing) and Test driven development

Performed End-To-End, Interface and Integration testing across many complex applications in complex environments

Performed Performance Testing using LoadRunner

Modified and executed Korn Shell(KSH) scripts, Batch jobs execution in Unix and Linux

Deployed the QA, Dev builds using NOLIO and DevOps

Performed ETL/Datawarehouse testing with Informatica using Querysourge and validated format and integrity of Source data from different sources across backend target interfaces of Datawarehouse

Developed automation scripts using Core Java, Core Java script, Selenium

Environment: Core Java, Core Java script, Selenium WebDriver, Selenium Grid, TestNG, Jenkins, GITHub, Eclipse, IntelliJ, UNIX, Windows, Oracle, SQL, TOAD, TeamFoundation Server TFS 2012, Visual Studio 2010, Clarify, Putty, WinScp, FileZilla, SnagIt, Jira, Querysourge, Python, Ruby, LoadRunner11, ETL testing tools: QuerySurge, Informatica, Python, Jenkins, GitHub

AllianceData Systems, AUTOMATION TEST LEAD 09/2013 02/2016

San Diego, CA

U.S.A.

Project: Automobile Marketing - AutoNation, DataHub

22nd Century Staffing AUTOMATION TEST/QA LEAD May 2013 – July 2013

New Jersey, U.S.A.

Client: DHS, Salem, OR

Project: HIX (Health Information Exchange) IT

Maxonic Inc., QA LEAD August 2012 – October 2012

Sunnyvale, CA, U.S.A.

Client: Intuit, San Deigo, CA, U.S.A.

Project: TURBO TAX- NUE(New User Experience)

Okaya Inc. QA/Automation Lead January 2012 to July 2012

Centereach, NY,

U.S.A.

Client: Mercury Payment Systems (MPS)

Durango, CO, U.S.A.

Project: CRM(Customer Relationship Management), IHP(In House Processing)

S & P Solutions QA Lead January 2011 to March, 2011

Willoughby Hills, OH, U.S.A.

Client: Progressive Insurance, Cleveland, OH

Project: SBR (Server Based Rating)

Amazon.com QA Analyst July 2010 to December 2010

Seattle, WA

Project: SEP(Search Experience Project)

Medtronic Inc. Performance Tester/QA Lead May 2010 – June 2010

Mounds View, MN

WIPRO Technologies/Empower TSI, U.S.A.

Project: Vualization POC Carelink (Proof Of Concept)- Medical Devices

Ciber Inc Performance Tester/QA Tester March 2010 – April 2010

Kirkland, WA. U.S.A.

Client: Boeing, Bellevue, WA U.S.A.

Portland General Electric (PGE) QA Lead May 2009 to August 2009

Portland, U.S.A.

Online Agency Web Portal

The Blue Cross Blue Shield Performance Tester/QA November2008 to April 2009

(BCBS)

Portland, Oregon, U.S.A

Project: PCM-Courier/Choreo:

Novel Team (McDowell Tucker & Co. Inc.) QA Analyst June 2008 to August 2008

Dallas, Texas

U.S.A.

Client: ACS(Affiliated Computer Services

ConneXion-Health Care Solutions:

Portland, Oregon, U.S.A

ACCENTURE Test Analyst-Technical/QA Analyst/ Sr.Programmer March 2006 – November2007

Bloomington, Illinois, U.S.A.

Config Software Solutions QA Tester August 1999 to October 2005

Hyderabad, AP, India

REFERENCES:

Reference Name: SYKEM REDEPPA REDDY

Email: adcsq5@r.postjobfree.com

Phone: 858-***-****

Reference Name: Raju Narasimha

Email: adcsq5@r.postjobfree.com

Phone: 330-***-****

Reference Name: Sudham BR

Email: adcsq5@r.postjobfree.com

Phone: 714-***-****

Reference Name: Krich David

Email: adcsq5@r.postjobfree.com

Cell: 858-***-****

Contact this candidate