QA Lead

RAJESH DEVABHAKTUNI

Email – *************@*****.***

Phone – 610-***-****

SR.QA ANALYST/Lead

PROFESSIONAL SUMMARY

Experienced Senior QA Tester with 15 plus years of testing Software applications for functional, Automation, Web Services, Regression tests, UAT in Banking, Telecom, Health care, Pharmaceutical domain.

Extensive experience with Software Quality Assurance Testing on GUI based Client-Server & Web Based applications, ETL, Web Services, Data Driven Applications, Data Warehousing projects using Manual and Automated testing procedures.

Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model, and Agile, Iteration, Scrum methodologies.

Experience in HP/Mercury Interactive Testing Tools (Quick Test Professional, Win Runner, Test Director, Quality Center).

Worked on Web Services Testing using SOAP UI 4.0/3.0, Apache Axis Client 2.x, Eclipse 3.4,

and IBM RAD 7.0.

Experienced in Automation of Testing activity using QTP 10.x/9.2, Selenium IDE 1.3, and Selenium RC Server.

Possess expert level of understanding of WSDL, XSD, Schema, DTD, XML documents for Web Services Testing.

Experienced in Black Box, White Box, Smoke Testing, Sanity, Shakeout, Integration, Regression, Functional, Front End and Back End Testing.

Efficient in implementing QA processes, establishing standards, procedures and methodologies.

Able to work under pressure to meet deadlines and the ability to work in a cross-functional environment. Effectively able to work as a team member as well as independently.

Excellent verbal and communication skills with the ability to successfully work with all levels of IT professionals and end users.

Possess extensive experience in analyzing the Business Requirement Documents, Functional Specifications and Technical Specifications.

Proficient in developing/writing Software Test Plans, Test Case Design, and Test Scripts based on User Requirements, Specifications and System Requirements documents.

Experience in designing Test Cases/Test Scripts/Test Conditions for the Unit Testing, verifying and validating Web based e-commerce applications, like Boundary Value Analysis.

Responsible for Analysis and Defect Tracking using HP Quality Center, Test Director, Bugzilla, JIRA, IBM Clear Quest.

Experienced in writing JUNIT Test cases for Java and J2EE applications.

Experienced in software Analysis, Requirements Management, Quality Assurance, Configuration Management and Change Control.

Experience in Black Box, White Box, and Grey Box Testing, GUI Testing, Regression testing, Ad-hoc, Silk, Selenium RC and Selenium Grid, Compatibility and Website Testing

Very good understanding and experience on different POS platforms.

Experienced in Testing of ETL, Data warehousing projects.

Extensive working knowledge in Shell Scripting, UNIX, LINUX and Windows platforms.

Proficient in SQL Queries, Stored Procedures and PL/SQL programs.

Has good knowledge of web technologies like Web Services, SOAP, XML, HTML, Style Sheets, ASP, JSP, ASP.NET, .NET, JavaScript, Perl, VB Script, VB, Java, C, C#, and C++.

Experience in working on UNIX, Sun Solaris, Linux, Windows platform. Developed Shell scripts.

Excellent communication skills with good presentation skills

Education:

JNTU, India

Bachelor’s Degree in Computer Science 2001

Technical Skills:

Operating Systems Windows 95/98, Windows NT/2000, XP, UNIX, AS400

Database Oracle, SQL Server, MS Access 2000, DB2

Languages C, VB, SQL, HL7

Testing Tools Quality Center, QTP, Win Runner, Load Runner, and Rational Test Manager.

GUI VB5.0/VB6.0

Reporting/ETL Tools Crystal Reports, MS Excel, Informatica 7.1.3

ERP AS400, SAP/CRM

Internet HTML, XML, DHTML, CSS, JavaScript, VB Script, Java

Web Servers IIS Application Server, Web Sphere

Professional Experience:

COMCAST, PA Jul’11 – Jun’12 & Oct’13 – Till Date

Sr.QA Analyst/QA Lead

Project – Xfinity Home Security

Identify when the ordering flow/session begins for a customer. Verify Agent Profile with generate a unique session ID. The Session ID will track all states of a customer and subsequent selections throughout their lifecycle by linking all transactions together within the session. It will be passed back to Sales Channel Management Service throughout the ordering flow to ultimately, tie together and track all of the Customer's selections until order completion. Session ID will also be the mechanism for Comcast to retrieve the Customer's information and/or their Shopping Cart during the ordering flow. A new session should also be generated any time a new address is searched. Identify the Affiliate/Sub-affiliate/Channel/Store/Agent for Commissioning Reconciliation based on Commissioning Reporting rules. Identify the Affiliate/Channel to allow for any configurations required for a specific affiliate/channel.

Comtrac is a Web portal for DDP (Emulator) through which Customer sales representatives (CSR) perform different Billing task like order entry, modification of order, disconnection of order, registering trouble calls etc.

ACSR (Advanced Customer Service Representative) is a web portal application used for CSG Billing Application through which all the activities of Billing could be performed like creating a location, creating a customer and Order Entry functionalities like Installing a service, cancelling a service, restart etc.

Responsibilities:

Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reports Testing of Web, distributed, SOA, Reporting, legacy, J2EE applications.

Written user-defined functions and generated Test Matrix

Maintained central repository to determine the readiness of the application by combining Planning, Execution and Defect Tracking.

Used SOAP UI, WebLogic ANT task to test Web Services running on WebLogic Server.

Importing requirements, create test cases, validate requirements with test cases and generate reports using Quality Center

Manage the testing process, schedule batch tests, log and track defects using Quality Center.

Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.

Participate in review meetings to resolve bug related issues with developers

Involved in daily meeting with Team members to keep track of defects and provided update on Testing progress to the Team Lead.

Created JUNIT Testcases, Test Suites using JUnit for Java Service Layer which was developed using Spring, Persistence layer using Hibernate.

Developed and Executed JUnit Test Cases using Eclipse IDE.

Developed SQL queries to test the data after executing transactions like deposit processing and check processing in batches.

Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.

Participated in daily defect resolution status calls to discuss defects with vendors, project management and users.

Worked on Testing of Restful Web Services for iControl Portal.

Created training material for offshore team as well as trained the new hires on application and bringing them up to speed

Worked in Automation of two modules using QTP. Developed VB Scripts in QTP which was used later to Automate Check and Deposit processing modules.

Testing of Web Services using web services client generated using Apache Axis, SOAP UI, TCP Monitor to track request and response SOAP Messages

Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data.

Worked on UNIX environment in Test and UAT environment.

Worked during weekend during Production Implementation to perform Sanity Test, Shakeout testing by doing testing in production environment during User Shakeout process.

Testing different Order Entry scenarios like Install, Disconnect, Modify, Transfer, Restart.

Wrote SQL Queries to retrieve data from the database using PL/SQL

Environment: Quick Test Pro 9.2, Mercury Quality Center 9.0, Java, JDK 1.6, WebLogic Application Server 10.3, SOAPUI 4.0, Restful and SOAP, Web Services, XML, XML, Schema, XSD, WSDL, Oracle 11g/10g, JUnit, Excel, SQL, Putty.

Octagon Research an Accenture Company, PA Jun’12 – Sep’13

Specialist/Offshore Coordinator

Project – Quantum Application

IND and NDA Submission in eCTD Staff Augmentation for submission publishing for clinical submission: Upload files from Documentum into Submission Manager in which file tagging, leaf title change, create internal Hyperlinks, External Hyperlinks, and Bookmarks. Published module 1-5 documents according to study-specific publishing standards

Responsibilities:

Prepared test plan, test scenarios using Word.

Reviewed and analyzed Business Requirements, Project Plans, Flow Diagrams, Use Cases, System Design documents and created Detailed Test Cases

Used On time defect tracking.

Performing various types of testing, such as functional, regression, user acceptance, negative and installation testing.

Generated PDFs Bookmark And Hyperlinks In Accordance With FDA And ICH Guidance's

Follow Internal Standards Including Standard Operating Procedures,

Guidance Documents, And Polices Throughout The Submission Lifecycle

Utilize In-House Software To Produce Submissions In Electronic Format Reviewed and edited CMC Regulatory

Published, Bookmarked and Hyperlinked Submission at Different Levels.

Perform Quality Assurance On Submission Level Document

Responsible for final QA and/or final doc approval of all CRF documents.

Manage offshore team for rolling submissions

Testing of in-house software

Organize and assign tasks appropriately as well as managing daily Workflows of all team members.

Verified the xml backbones after the submission has been published.

Compared Source documents with New Regulatory CMC documents to ensure consistency

Published module 1-5 documents according to study-specific publishing

standards

Performed document level QA and corrective action on module 1-5 documents

Completed dataset manual reviews

Generated and published CRTs, DDT's and Define Files

Environment: Windows XP, Java,.Net, Ontime, PL/SQL, SOAPUI

ING DIRECT, DE Dec’10 – Jul’11

Sr. QA Analyst

Project – Orange Deposits/Secure Paper Checks

Orange Deposit project is an enhancement to the current pack of features that ING offers to its Electric Orange/Checking account. It enables customers to process their checks online. Customers can scan their checks and upload it on the ING direct site, saving them time and money. They can also view the uploaded past check images using their online account. ING Direct is leveraging the eCapture and Transaction Flow Management application build by industry leader J & B Software. ECapture automatically captures the check details such as check amount, routing number and check number directly from the check. Transaction Flow Management enables the sales associate to better manage the check queue in case there is inconsistency in the check that is being uploaded by the customer.

Responsibilities:

Writing and executing software system test plans and test cases. These scripts were developed after reviewing the business requirements documents and technical specifications documents.

Created test cases and for integration testing based on requirements

Primary liaison between Test Team and Project Managers.

Writing and executing software system test plans and test cases. These scripts were developed after reviewing the business requirements documents and technical specifications documents.

Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.

Collaborated with Workstream Test Leads to generate defect status reports and metrics within HP Quality Center.

Worked on Selenium IDE to Automate Testing of Web Application, developed test scripts which includes sequence of commands to be executed.

Involved in Web Services Testing using SOAP UI.

Conducted weekly Defect Status meetings with Workstream Test leads to ensure defects were following the Defect Life Cycle

Reported Defect metrics and measurements to all levels of management.

Worked with the Project Manager to identify resources, scope and limitations of testing.

Created and Manipulated data pools in File-Manager

Tested backend databases using SQL queries.

Installed, configured SOAP UI to test web services using WSDL file given by Development team.

Documenting and communicating test results using Mercury Interactive Quality Center

Maintain and provide status and progress of project activities

Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.

Used Mercury Interactive Quality center for defect tracking and reporting bugs

Designed Test Plans for Projects and work with Project Teams to obtain approval.

Worked closely with Project and Project managers to provide testing timelines.

Participated in early phases of projects to ensure input into testing can be translated into test plans and test cases.

Environment: Windows XP, Java, Quality Center, PL/SQL, Profile, Microsoft Suites, IE, FireFox, Safari.

EDS/HP/ACS, NJ Aug’07 – Nov’10

Sr. QA Analyst/Technical Analyst

Project – Health & Welfare (H&W)

Health and Welfare (H&W) module calculates Health and Welfare benefits for employees of different clients every year during Annual Enrolment and year long. This system keeps track of employment history, dependent history, beneficiaries, earnings, deductions and pension information for both Retirees and Active employee. This project is basically conversion projects from 6.3 to 7X The major clients are International Paper & Bayer, Raytheon, Sony Entertainment, Washington Mutual and Cardinal Health

Responsibilities:

Reviewed and analyzed Business Requirements, Project Plans, Flow Diagrams, Use Cases, System Design documents and created Detailed Test Cases

Coordinated with offshore teams and organized conference calls to update the management team regarding the project testing status

Prepared traceability matrix to map the requirements against the test cases and validated the test coverage analysis

Interacted with functional experts to understand the application

Wrote user manuals for test cases and involved in Agile Methodology process.

Participated in daily scrum meetings and sprint review meetings with Executive Team

Participated in all the phases of Software Development Life Cycle (SDLC) like, Requirements Review, Test Documentation, Application testing, defect reporting and defect reporting

Interacted with the respective developers to explain the testing issues on behalf of the testing team and managed the entire testing effort

Used Quality Center extensively to write detailed Test Cases and organize the same using the Test Plan module.

Established connectivity between MS-Excel and Quality Center to Export Test Cases and other Test Documentation

Created and Executed Test Sets and Test Instances and documented the test results

Reported Defects and mapped the same against the respective Test Cases

Recorded various Functional Test Scenarios to automate the test and generated the Test Script

Wrote Detailed Test Scripts in VbScript using the Expert View of Quick Test Professional

Inserted various Check Points like Image, Database, Text, Table, Bit Map etc to validate the test results when executed against different builds of the software being developed.

Used I/O Tool to run the XML file to get Output records.

Wrote SQL Queries to retrieve data from the database using PL/SQL

Performed Functional, Integration and Regression testing of Web batch.

Created daily Issue Reports for Developers and Project Management

Environment: Windows XP, .Net, XML, Quality Center, PL/SQL, Star team, Quick Test Professional, I/O tool, Microsoft Access

Pennsylvania Department of Health, PA Apr’09 – Nov’09

Sr.QA Analyst (short term contract during a layoff and eventual rehire at HP/ACS)

Project – National Electronic Disease Surveillance System (NEDSS)

Pandemic data entry is a public health emergency system where a reporter reports if there is an emergency like swine flu and other diseases. The Investigator can manage the Aggregate reporting management and the reporter from the hospitals or labs can use the template and report about the emergency. ETL process needs to have Auditing and Reconciliation before being the Business Intelligence reports are build for various requirements.

Responsibilities:

Well versed with all types of manual testing like functionality testing, smoke testing, positive & negative testing, regression testing, integration testing, GUI testing, backend testing, browser compatibility testing, load and stress testing

Participated in all the phases of Software Development Life Cycle (SDLC)

Involved in Agile Methodology process

Interacted with the respective developers to explain the testing issues on behalf of the testing team and managed the entire testing effort

Organized peer review meetings, application and tools training sessions for team members and designed the required training material.

Good understanding of application build cycles and following the required test strategy to meet the testing requirements

Created XML and HL7 files to test messaging systems

Analyzed the requirements and coordinated with the other team members to develop Audit and Reconcile logic that confirm to the BIT (Bureau of IT) and enterprise standards.

Tested the Dimensions and Fact tables for new / changed records for Audit & Reconciliation logic.

Written the SQL queries to test the Cognos Reports and compare with Data warehouse Fact & Dimension tables.

Tested the data and data integrity among various sources and targets by writing the SQL Scripts.

Prepared the test data and documented the Unit test results for all possible business conditions.

Writing simple and complex SQL queries in databases like Oracle, SQL Server & Ms-Access

Executed SQL queries to extract the required test data and also to validate Front-end vs. Backend data values. Understanding knowledge of stored procedures, triggers, views etc

Used Quality Center extensively to write detailed Test Cases and organize the same using the Test Plan module.

Established connectivity between MS-Excel and Quality Center to Export Test Cases and other Test Documentation

Recorded various Functional Test Scenarios to automate the test and generated the Test Script

Integrated QTP with Quality Center and maintained QTP test scripts in Quality Center.

Fully acquainted with creating independent and re-usable actions and changing the action properties and call properties as required.

Tested the Star Scheme table by writing the SQL queries after the ETL Process

Prepared test data for UAT Team.

Environment: Windows Xp, .Net, Quality Center, Remedy, Cognos,HL7, XML, TOAD, Quick Test Professional, Microsoft Suites

Texas Medicaid & Healthcare Partnership (TMHP), TX Mar’07 – Jul’07

Business Analyst

Project – National Provider Identification (NPI)

The Compass21 (C21) Cash Financial subsystem contains functionality within the Texas Medicaid Management Information System (TMMIS) related to payment transactions between the State and providers. This includes payouts, voids, reissues, account receivables, cash receipts, payment holds, levies, and backup withholdings. The subsystem generates several reports including 1099s, CMS reports, and Remittance and Status (R&S) reports. The Cash Financial subsystem includes functionality in C21, Phoenix, Electronic Data Interchange (EDI), Portal (TMHP.com), and TDHconnect. It also includes Third Party Recovery (TPR), Texas Automated Recovery System (TARS) and Tort. Phoenix is a windows-based application used by the Texas Medicaid Healthcare Partnership (TMHP) and State agency staff to enter, view, and maintain information in C21.

Responsibilities:

Interacted with Developers, discussing the requirement specifications provided by the analyst and also the discrepancies in the application.

Wrote Test Scripts and implemented Test plans, various Test Cases and Test Scripts based on functional specification and documented it for higher levels of management.

Performed Positive and Negative testing for system validations.

Performed manual testing of the application using numerous Test Scripts.

Developed and executed test scripts for AUTOMATED testing using Quick Test Pro for each individual functionality of the applications.

Used MS-WORD/EXCEL to export all Test Cases to Quality Center and developed Test results report for whole project.

Process claims through Claims Management System to check the new NPI functionality as per HIPPA Guidelines.

Generated the X12 files for 270/271,276/277,835, 837 through EDI.

Performed Security Testing using QA Inspect for various combination of claims (for XREF screens)

Used TDHConnect application to submit MESAV inquiries and view the responses.

Successfully implemented the change request and defect tracking Using Quality Center 9.2 for utilization of developers and QA Team.

Performed extensive Functional, Regression, and Volume & Performance testing.

Wrote SQL queries to retrieve data from Tandem database.

Performed Load/Stress Testing for estimating the performance of various services using Load Runner.

Validated back end mainframe system (HOST) testing and performed Functional, System Integration Testing (SIT), User Accepting Testing (UAT) and Regression testing of the web portal.

Used Quality Center for defect tracking and reports like test coverage matrix, defects report.

Participated in various meeting and discussed Enhancement and Modification request.

Documented bugs with evidence and reported them with detailed information to the development team.

Used LoadRunner Analysis tool to analyze the response times of the business transactions under load.

Coordinated with developers to fix the problem and enhancing the application.

Environment: Windows Xp, AS400, Java, J2EE, JSP, XML, Quality Center, Tandem, Quick Test Professional, Load Runner.

BlueCross BlueShield (BCBS), FL Feb’06 – Mar’07

QA Analyst

Project – Consolidated Billing Premium Payments (CBPP)

This is an online presentment of health and life bills to individual customers. In addition, Agents were given the capability to process initial payments electronically. Internal Users can cancel any payments when needed and also can make Premium Payments for customers. The purpose of this project is to create and deliver end-to-end, web-based premium payment transaction processes to our customers and members required to support an eBusiness model encompassing Health, Diversified Business and all Ancillary Products by:

Enabling the distribution of consolidated bills for all product lines

Simplifying the operating environment for benefit administrators, agents and individuals

Providing electronic payment and inquiry capabilities

Responsibilities:

Wrote Test Scripts and implemented Test plans, various Test Cases and Test Scripts based on functional specification and documented it for higher levels of management.

Involved in writing and execution of test scripts based on business requirements of the application using Mercury Quality Center.

Involved in testing of application at system level for quality of the software by using Test Manager after each build release of the application.

Developed and executed test scripts for AUTOMATED testing using Quick Test Pro for each individual functionality of the applications.

Designed and developed High level and detailed Test Cases based on the available Use Cases.

Tested SQL Statements against DB2 database for performance tuning and optimization.

Used strong technical ability and established quality standards to verify and validate assigned software products, components, or function sets throughout their development cycles

Used Siebel environment to generate check for payments.

Used AS400 systems to generate Invoices for premium payments

Assisted UAT team by providing test data and test scripts and involved in Regression testing after every build release.

Enhanced the Regression model by adding scripts from system test, which can be used for regression after every release.

Involved in IVP after maintenance release and verified the Back end data & structure of tables using SQL queries.

Created Test Data by entering Invoices in to RBMS manually and by using automated script in Robot and created binders for System test, UAT and Regression testing.

Used Clear Quest and Quality Center as defect-tracking tool to track and also to follow up the defect status.

Environment: Windows Xp, AS400, DB2, Java, J2EE, JSP, Siebel, Rational Test Manager, Quick Test Pro, Quality Center, Clear Quest.

Verizon, VA Jul’04 – Jan’06

QA Analyst

Description:

This software is intended to assist in the setup of Verizon Online DSL hardware, install appropriate Verizon Online software, configure a Verizon Online account and finally launch the landing page. This software will be placed in predefined CD hierarchy. This software will install the network connectivity software and Visual IP Insight. Visual IP Insight will be downloaded from SFP server. For users on the PPPoE network (East), the software will install WinPoET and connect to the Project Launch site for account activation. For user running Win XP, the software will configure built-in PPPoE to establish a DSL session to connect to Project Launch. If the user has received a DDM enabled devices, the CD will detect these devices and will not install PPPoE software, and instead the PPPoE on the device will be configured. Software client code will be authored in C++ and uses Flash for GUI. This software will have the functionality to display HTML within a predefined space. The CD application will create an Installation Log. The log will be written to a file on local hard disk. All the activity of the flow will be written to logger.

Responsibilities:

Developed and executed test scripts for MANUAL testing and AUTOMATED testing using Quick Test Pro for each individual functionality of the applications.

Interacted with Team Members for reviewing and writing the Test Plans and Test Cases

Used Symantec Ghost for installing software applications and Operating systems. Transferring files is done either by Unicast, Direct broadcast or multicast.

Tested application on various hardware’s like IBM Series Intellistation, think centre, Dell Series 2300, 4500, 8200, Dell Laptops, and Apple computers.

Tested application under various OS Windows 98/ME/2000/NT/XPHE/XPPro including all Service Packs and on Apple Computers under Mac.

Tested DSL Software using various modems like Westell Wire Speed Ethernet, Westell Dual and DDM enabled routers like Linksys and Westell 2200.

Tested installation of WinPoET depending on connection made whether it is PPPoE network in the East will install WinPoET or DHCP network (west), the software will launch a browser and connect to the Project Launch site for account activation.

Tested for data validations, business validations and business logic workflow.

Documented the Daily Defects Status with the help of QA Metrics

Reported the bugs, Email notifications to the developers using the PVCS Tracker.

Used SQL to perform backend validation.

Used Mercury Quality Center 8.2 for Defect Tracking

Account Tracker an Internal tool is used to create test data.

Documented test results based on expected and actual test results.

Extensively communicated with developers using Test Director.

Environment: Java, J2EE, Web logic, JSP, SQL, Macro Media Flash 6.0, html, ASP, SQL Server, Windows (all Versions), Mac 10.x, UNIX, Quick Test Pro, Test Director, PVCS Tracker, Symantec Ghost Server.

Eminent Technologies, India Jun‘01 – May’04

QA Tester

Description:

Human Resource Management System deals with various facts of personal management such as Recruitment, Employee Information, Benefit Management, Carrier Succession Monitoring or Appraisal and Leave Management. It enables fast and effective information retrieval to the management. It also functions as an Excellent Decision Support System.

Responsibilities:

Analysis of Business as well as Technical Specifications.

Wrote and executed the test cases manually and automated them by using WinRunner.

Involved extensively in writing high-level Test plans.

Developed detailed system Test cases for the Application.

Performed extensive Functional, Regression, and Volume & Performance testing.

Automated the Regression Testing by creating the test scripts using Mercury Suite (WinRunner).

Responsible for documenting errors, their resolution, as well as performing extensive Regression Testing.

Environment: Visual Basic, Oracle 7.1, Manual Testing, WinRunner and Win NT.

Contact this candidate