HemaMalini Jarugula

210-***-**** / acxdb4@r.postjobfree.com

Summary:

Over 9 years of experience in Information Technology, which includes Manual Testing, Automation for functional, regression with Rational Functional Tester, Quick Test Professional, GEARS, Win Runner and performance testing LoadRunner of diverse applications on various OS’s is such as Window, UNIX / LINUX with client/server and web based environments.

Strong experience in writing Test Plans, Test Strategy’s, Test Cases, Test Reports for both manual and automated tests. Expertise’s in analyzing Business Specifications, Testing Models, develop Test Cases, Test Scripts and execute them.

Worked with Potential Domains such as Insurance, Health Care, Financial, Banking, Manufacturing and Mortgage. Expert in understanding of SDLC, PDLC, Software Test Life Cycle, Agile Model and different Test Methodologies.

Strong experience in tracking and reporting of defects using defect tracking tools such as Quality Center, Test Director, Manual tester, TRAC and IBM’s Rational Clear Quest. Hands on experience in developing and maintaining test scripts for functional and performance with HP/Mercury tools QTP, WinRunner, Rational Functional Tester and LoadRunner.

Hands on experience with writing complex SQL Scripts by analyzing data models and strong knowledge on PL/SQL, DBMS and RDBMS concepts. Extensive experience in relational database testing (Back-end) to ensure data consistency on front-end by writing and executing SQL queries on ORACLE, SQL Server, DB2 databases.

Experience in Smoke, Sanity, GUI, Functional, Non Functional Requirement, Web Testing, System Integration Testing (SIT), Regression, Ad-hoc Testing, User Acceptance (UAT), AUT, End-to-End (E2E), Grey Box, Black Box and White box testing, Proactive Testing, Stress, Load, Security, Browser compatibility, Risk Analysis and performance testing.

Good expertise on Fixed Income, Portfolio Management, Trade Order Management and Assets Management, Bonds, Mutual funds, Fund to Fund Accounting, Fixed Income Loan/Mortgages, web application. Knowledge on Software Configuration management, ISO, CMMI Levels and Six-Sigma standards. Strong Web Services testing Experience using SOAP.

Excellent communications, problem solving, interpersonal and client coordination skills, desire and ability to quickly adapting to newer technologies and ability to works individually or group of teams.

Technical Competencies:

Test Automation Tools: Quick Test Prof, Load Runner, Rational Performance Tester, Win Runner, Test Manager, Silk Test, QA Load, Rational Functional Tester, WorkSoft, Selenium, GEARS.

Test Management Tools: Quality Center, Test Director, ClearQuest, Test Partner, LISA, JIRA, TRAC

MS Technologies: ASP. Net, VB. Net, C#, .Net and VB.

Languages: VB, SQL, PL/SQL, C, C++, JAVA, SOAP, J2EE, XML and HTML.

Scripting Languages: VBScript, TSL Script, Java Script, Shell Scripting.

Data warehousing tools: Cognos, Informatica, Business Intelligence, ETL, Business Objects and Data Stage.

Application Business Servers: Web Logic and Web Sphere.

Application Software: MS-Excel, MS -Word, MS-PowerPoint, MS Project, Silverlight and MS Outlook.

Databases: SQL Server, Oracle, DB2, TOAD and MS-Access.

Operating Systems: Windows-98/2000/07/XP, Windows Server-NT/2000/2003 and UNIX / LINUX

Others: Clear Case, WATIR, Data Stage, TIBCO, FIT, People Soft, Mainframe, Share Point, HTTP Watcher-6.1.42, Minionz, SAP

Education:

Master’s in Business Administration from APIM India – 2002

PG Diploma in Computer Application from JNNYC India 2000

Achievements:

Awarded as Employee of the quarter by NTT Data for State Farm account.

Awarded as ‘Excellent Performance’ by OMUS IFRQ Redesign Project, State Farm

MAJOR ASSIGNMENT:

NTT Data Jan 2011-Current

Client: State Farm Insurance, Dallas TX

Role: Test Analyst Technical – Functional

Projects: Internet Fire Rate Quote, Policy View Change and Claims (PVC)

Project Description: Internet Fire Rate Quote (IFRQ) is a web based internet application for the users to get their quotes online. It also provides customer to view/change their policy coverage. PVC has made several Accessibility enhancements to static pages that are under State Farm Internet Target Architecture. This project will provide System and regression testing for the SFS applications and project will complete accessibility enhancements for the Policy View/Change & Claims applications.

Responsibilities:

Involved in client interactions for gathering the requirements, enhancements and Change requirements.

Worked on Functionality Testing, System Testing, Smoke, Sanity, Exploratory Testing, Regression Testing, Performance testing for all releases of IFRQ and PVC.

Preparation and Maintenance of Test Cases using TCDM by analyzing Functional and Business Requirements. Creation/Review of Test Cases, Test Log and Test Data during Test Case Design & Execution phases.

Logging the defects in Rational Clear Quest / Trac. Performed Migration process from Rational Clear Quest to TRAC.

Responsible for reviewing the User Interface specification documents and creation of the Design documents.

Involved in parsing UI Spec excels sheets using SAX Parser and generating test cases in XMLs.

Developing Level1, Level 2, Level 3 and End to End Business scenario test cases for Product models using Java and Junit integrated with State Farm Proprietary Framework Gears.

Extensively used Project Manager tool to Perform Downstream Testing for EA testing, Activity Testing, Client testing, Third Tier Testing and prepared back end test schedules for all releases of IFRQ.

Used the Minionz - Testing workbench to verify submitted apps data.

Extensively used Perfecto-mobile to validate Application on all types of Mobile devices.

Prepared Tracking Sheets for Resource Management to forecast availability of Resources for various testing activities across the project, and Daily Status log, Issue Log for every phase to track issues/productivity of team.

Effective coordination with offshore team to complete the task well before the dead line and allocation of work.

Knowledge Transition to offshore teams on Insurance Domain to make sure awareness of project/business objective. Providing updates on Functional Knowledge gaps to Offshore on a regular basis through internal meetings.

Environment: Windows 2007, Share Point, TCDM, Project Manager, Rational Clear Quest 7.0.1, TRAC 0.12.1, Load Runner 11.00.0.0, Selenium 2.7.0, IBM Lotus Notes 8.5, Minionz- Testing workbench, Perfectomobile, HTTP Watcher-6.1.42, Java, J2EE, EJB, JSP, Web Services, Mainframe, GEARS, SQL Server 2005 SSRS.

Wolverine Technical Staffing Sep 2010 – Dec 2010

Client: HCR ManorCare, Toledo, OH

Role: QA Analyst

Projects: Kronos ROX Feed, Discharge Report, PCC, Patient Outcomes, SIMs / SAMs

Project Description: Kronos ROX Feed is intended to automate the load of Kronos data into ROX to streamline the ability to compare paid time to billable time and allow the center identify where productivity improvements are needed or if they can better utilize a therapist.

Responsibilities:

Reviewed the Functional Requirements and System Specifications to create Master Test Plans. Developed Test Cases, Test Scripts for Automation and did the verification according to FDA regulations.

Designed, implemented and published Test Plan based on product functional requirements and test data. Involved in designing the test procedure for GUI application.

Used the Rational Functional Tester for Functional Regression testing. Developing the test scripts for performance and data driven tests using RFT. Developing scripts for testing the future release of the application using RFT.

Created the Data Pool values for each script in RFT and performed the Batch Testing.

Performed database validation using SQL queries. Wrote SQL Queries to verify that the data is populated from the database matches with the front end screens.

Extensively used SQL Server Reporting Service to create rich reports and formatted them based on the requirements.

Interacted with the Business Analyst to understand the work-flow of various functionalities.

Preparation and Maintenance of Test Cases using Rational Manual Tester by analyzing Functional and Business Requirements.

Test execution-using Rational Manual Tester. Extensively used Rational Clear Quest for reporting / tracking bugs and for document control. Coordinated with Team and developers for defect analysis and their fixes.

Environment: Windows 2003, Share Point, Rational Functional Tester 7.0, Rational Manual Tester 7.0, Rational Clear Quest 7.0, Biz Talk, Java, J2EE, EJB, JSP, Web Services, .Net 2005 Scripting, Shell Scripting, Mainframe, Data warehouse, ETL, Business Objects, Congo’s, MicroStratagy, SQL Server 2005 SSRS, SSIS.

Numbers Only Inc March 2008 to Aug 2008

Client: Visa, Denver, CO

Role: Sr QA Analyst

Project: IntelliLink

Project Description: The Visa IntelliLink product provides government agencies actionable, intelligent information to improve misuse management, enable more effective sourcing and to promote a more efficient overall program management.

Responsibilities:

Designed Test Cases based on Use cases and Wireframes. Responsible executing and updating TC for IntelliLink. More responsibility to complete manual testing of the AUT. Designed and creation of performance Test Plans and test suites. Developed the test scripts and test scenarios, test data preparation and Configuration of scenarios.

Involved in SIT, Regression, System, Non Functional Requirement, Ad- hoc Testing, Proactive Testing, Grey Box, Black Box testing, Compatibility Testing, Batch Testing, User Acceptance Testing phases for Release versions.

Work closely with various levels of individuals to coordinate schedule the project throughout SDLC. Implemented Cardholder Information Security Program and Payment Card Industry Data Security Standard. Worked with DOE, DOS, DOD, DHS Agency which helps to find misuse, abuse and fraud cases.

Followed Agile development methodology to work closely with development environment to run functional, acceptance tests regularly, weekly and builds wise to solve the issues. Performed in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA report using Test Director.

Developed descriptive programming in Test Scripts in QTP for different objects identification whenever QTP cannot identify the objects. Developed test scripts for performance and data driven tests using QTP.

Used QTP for Regression Testing and Data Driven Test for multiple sets of data. Created Test Scripts using QTP and enhanced scripts by adding functions in inserted Synchronization points and checkpoints in scripts whenever necessary. Developed scripts for testing the future release of the application using QTP.

Developed performance testing of the application using LoadRunner. Enhanced the VUser scripts with parameterization and correlation and incorporated to the Load Runner Scenarios by using the LoadRunner Controller.

Performed tests to identify and resolve performance related bugs. Designed and creation of performance test plans and test suites. Developed the test scripts and test scenarios Test data preparation and Configuration of scenarios.

Performed database validation using SQL queries. Wrote SQL Queries to verify that the data is populated from the database matches with the front end screens. Used T-SQL to back up and restore SQL Server user database.

Extensively used SQL Server Reporting Service to create rich reports and formatted them based on the requirements.

Interacted with the Business Analyst to understand the work-flow of various functionalities. Enhanced and modified the scripts according to the UAT Test Case scenarios. Performed the User Acceptance Testing (UAT) and Functional Testing of the project and raise concern, cautions and notify to development team through UAT results.

Preparation and Maintenance of Test Cases using Test Director / Quality Center by analyzing Functional and Business Requirements. Performed Migration process from Test Director 8.0 to Quality Center 9.2.

Performed test execution-using Test Director and Quality Center. Extensively used Rational Clear Quest for reporting / tracking bugs and for document control, as well as Deployment and Enhancement requests. Coordinated with Offshore Team and developers for defect analysis and their fixes.

Environment: Windows XP, Share Point, Visio, MS-Access, Quick Test Pro 9.0, Test Director 8.0, Quality Center 9.2, LoadRunner V8.2, Clear Quest 7.0, ASP.Net, .Net Framework 2.0, Web Services, Visual Studio. Net 2005, SQL Server 2005 SSRS, T-SQL

Numbers Only Informatics Pvt. Ltd. India Jul 2002 to Aug 2005

Project 1: Internet Banking System,

Role: Web Tester

Project Description: Internet Banking system contains Trading, Brokerage, and Wealth Management, Fund to Fund Accounting, Mutual funds and two types of transactions. They are customer transactions with the Lock-box application.

Responsibilities:

Worked in different stages of the Software Development Life Cycle, which involved gathering business requirements, developing use cases, Test Cases, UAT support, Production Support.

Involved manual testing of the application. Developed the test plans for GUI, Functionality Testing, System Integration Testing and User Acceptance Testing. Involved in full Functional, NFR and System Integration Testing, Regression, Ad-hoc Testing, Grey Box, Black Box, White box testing, Web Testing, Performance testing of the application.

Created Test Cases based on Test Plan, Business and functional requirement documents. Implemented Waterfall Model and different Test Methodologies. Reported Defects to developers and did Regression testing after the code fix. Planned, coordinated and monitored project levels of performance and activities to ensure project completion in all phases of STLC.

Validated the Web Services (SOAP), both Request and Response messages. Validated the protocols (TCP/IP, HTTP and HTTPS). Developed XML test files based on XML schema. Validated the J2EE Web services.

Created, altered different Oracle Tables in the Testing Server. Used MS Project to manage schedules, deadlines, and resources for the project. Involved in documentation during various phases of product life cycle and maintained all artifacts updated throughout each iteration execution and fallowed the software protocols.

Performed the User Acceptance Testing and Functional Testing of the project and raise concern, cautions and notify to development team through UAT results. Enhanced and modified the scripts according to the UAT Test Case scenarios.

Defects were tracked, reviewed, analyzed and compared using Test Director and JIRA. Worked closely with developers to translate any concerns regarding the requirements. Participated in walk through and defect report meetings periodically.

Environment: UNIX, Window’s 2000 Professional, Share Point, Test Director 7.0, MQ-Series, TSO/ISPF, DB2, JCL, QMF, Oracle, HTML, TOAD, JAVA, J2EE, JIRA, Web Services SOAP, PERL, XML, EJB, and Java Script.

Project 2: Mortgage System, Role: Web Tester

Project Description: Peoples Bank offers a wide variety of mortgage programs for Homeowners and first time home buyers. Homeowners and first time home buyer’s module that has sub modules like Apply, Finish Applying, Rate Watch and Rate Quote.

Responsibilities:

Performed Quality Assurance testing for the Mortgage system developed for a bank. Involved in testing the Mortgage system for Homeowners and first time home buyers module. Created and executed Test Cases for the Apply module from its Starting application phase to Submit application phase.

Involved in full Functional, NFR and System Integration Testing (SIT), Regression, Ad-hoc Testing, Grey Box, Black Box and White box testing, Performance testing of the application.

Validated the Web Services (SOAP), both Request and Response messages. Validated the protocols (TCP/IP, HTTP and HTTPS). Developed XML test files based on XML schema. Validated the J2EE Web services.

Used the XML to hold the data to transfer between source and destination of web service. Performed Web Services simulation and Mocking using SOAP.

Responsible for Regression testing, Integration testing using WinRunner. Developed test scripts using TSL supported by WinRunner. Extensively used Win Runner to check the functionality to the web application.

Worked closely with technical team to cater the requirements understanding and developed technical solutions and develop the software. Created and executed TC for both Online and Batch programs. Tested UNIX Commands extensively for writing the Test Scripts.

Performed the User Acceptance Testing (UAT) and Functional Testing of the project and raise concern, cautions and notify to development team through UAT results. Enhanced and modified the scripts according to the UAT Test Case scenarios.

Written modification request for the bugs in the application and helped developers to track the Problem and resolve the technical issues. Defects were tracked, reviewed, analyzed and compared using Test Director and JIRA.

Environment: UNIX, Win Runner 7.6, Test Director 7.0, TSL, Oracle, JCL, JAVA, J2EE, JIRA, XML, XML SPY, Web Services SOAP, EJB, TOAD, PERL, and JAVA Script.

Contact this candidate