Preethi Reddy

Ph: ***- ***- **** ***, Golden Horseshoe Circle Email: arz47x@r.postjobfree.com Morrisville, NC 27560 ______________________________________________________________________

SUMMARY:

• Over 8 years of IT experience in system analysis, design, and development of Software Quality Assurance of Client/ Server, Network and Web based applications. Excellent professional skills to prepare test plans, scripts and sound in writing and executing test cases for manual and automated testing using Mercury Tools like Win Runner, Test Director, Load Runner, Quick Test Professional, Quality Center.

• Experience in writing Test plans, defining Test cases, developing and maintaining Test scripts.

• Complete understanding of QA methodologies. Expertise and experience in performing different kinds of testing like black box testing, white box testing, functionality testing, GUI testing, unit testing, integration testing, backend testing, performance testing, load testing, stress testing, regression testing, System testing, UAT and bug tracking system on both Windows and Unix environments.

• Experience in Software Development Life Cycle and Testing Methodologies.

• Strong testing and development skills in VB, .NET, Java, JUnit, C, C++.

• Experienced in testing Installation packages on various platforms for Consistency and Usability.

• Very Strong Oracle, DB2 skills that include build/maintain tables and indexes; build/maintain SQL scripts, PL/SQL, Stored Procedures and Functions.

• Have experience in various sectors including Health Care, Financial, Child Support, Telecommunication, Banking, and Insurance Projects in different roles.

• Expert in documentation using MS tools (Word, Excel, Project, and Access).

• Experience in using Agile technology for testing process.

• Experience with data ware housing and OLAP concepts.

• Expertise in Data Driven Testing & Writing test scripts. Possess a strong desire for maintaining quality in all the phases of software development life cycle.

• Experience in UNIX Shell Scripting, VB Script and Java Script and testing the XML tags.

• Expert in installing and configuring Automated Tools and Setting QA Test Environment

• Responsible for monitoring resources technically and training other QA Team Members.

• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems.

• Experience working individually and in team environment.

• Developed strong communication and interpersonal skills while working in diverse team environments.

EDUCATION:

• Bachelor of Technology in Computer Science Engineering in Jawaharlal Nehru Technological University, INDIA.

TECHNICAL SKILLS:

Testing Tools: Mercury Test Director/ Quality Center 8.2/9.2/10.0, Win Runner, Load Runner, QTP 9.5/10.0

Databases: Oracle 8i/9i/10g, MS SQL Server 2000, DB2, MS Access.

Languages: C, C++, VB 6.0, SQL, PL/SQL, ASP, HTML, Java Script, .NET, XML, TSL.

Operating Systems: Windows 98/NT/2000/XP/Vista, HP UNIX, Linux, Macintosh.

Internet Technologies: HTML, CSS, ASP, XML, VBScript, MS Front Page, Photoshop.

Utilities: SQL *Plus, Toad, SQL Loader, Cognos, AQT, Micro strategy.

Packages: MS Office, Acrobat Reader, Visio Prof., Trend Micro /Norton/McAfee Anti Virus.

Web Servers: Web Sphere, Java Web Server.

WORK EXPERIENCE:

Premier HealthCare Inc, Charlotte, NC Feb 10 – Present

Sr.QA Analyst

Owned by non-profit hospitals, Premier operates one of the largest healthcare purchasing networks and the nation's largest comprehensive repository of hospital clinical and financial information. In addition to offering solutions to the recent healthcare reform provisions, Quality Advisor supports AHRQ Patient Safety & Inpatient Quality Indicators and CMS Hospital Acquired Conditions. Worked on QA, QM, CA measures for Patient Safety Indicators, Inpatient Quality Indicators and Pediatric Quality Indicators. Also worked on In-house tools PCM, Transform and AE. PCM is mapping tool for Transform and AE data.

Responsibilities:

• Reviewed the AHRQ documentation for Indicators standards to understand the QA, QM, CA measures.

• Involved in manual testing and Automation testing of application.

• Developed and executed test scripts & test cases for all three measures.

• Executed Test cases using Quality Center in Test lab.

• Involved in Understanding of ETL Mapping document (Ab Initio) and to validate source database to Target.

• Performed Data driven testing by passing data initially through Ab Initio mapping and then through SAS code.

• Verified the reports generated according to AHRQ standards from Microstrategy.

• Logged defects in Jira and Quality Center.

• Updated data tables in Oracle for Data driven testing.

• Performed testing in Agile scrum methodology and involved in daily scrum meetings.

• Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.

• Managed the overall testing effort, including coordination of testing personnel and test lab resources.

Environment: Windows XP, Oracle, Advanced Query Tool V9, Quality Center 10.0, Jira, Ab Initio, Micro strategy.

Citi Bank N.A, NYC Oct 08 – Jan 10

Sr. QA Analyst

Citi Bank offers a full range of financial services to commercial and business customers and consumers. Worked for Fixed Income group on the UST Government trading applications. Worked on different Flow based trade applications. These applications integrate with other applications using API or STP Interfaces. Currently working on the Trading application supported on MMI.net platform. VMO (Virtual market Order) application is a Vendor (ION) product. Citi is currently trying to use ION platform for all the existing Trade flows.

Responsibilities:

• Reviewed the Business Requirements document with the business team to understand the functionality of the application.

• Involved in the manual testing and Automation testing of the application.

• Involved in writing the Integration, System and Regression Test Cases.

• Executed Test cases using Quality Center in the Test lab.

• Bugs were reported to developers using Quality Center after rectification from developers and then Regression testing was performed.

• Wrote Integration Test Plan and tracked daily activities by getting updates for each task and following up on any open issues resulting from integration testing step.

• Involved in testing the application of FIX Protocol used in the trading applications.

• Involved in testing the financial orders placed, using the Order Management System (OMS).

• Verification of data at backend (UNIX ) and front-end (windows)

• Verification of data stored in the Database (ORACLE) using TOAD.

• Checked the data flow through the front and backend and extensively used SQL queries to extract the data from the database

• Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.

• Managed the overall testing effort, including coordination of testing personnel and test lab resources.

Environment: Windows XP, Quality Center 9.2, QTP9.5, Html, Oracle11g, PL/SQL.

Ohio Department of Job and Family Services, Columbus, OH Oct 07 – Sep 08

Sr.QA Analyst

Office of Child Support - Support Enforcement Tracking System (SETS) is a joint effort involving federal, state and local agencies administered in Ohio by the Ohio Department of Job and Family Services and Office of Child Support (OCS).

Projects:

• Cash Medical: Cash Medical is to support the legislation and address medical support, redefine ‘reasonable cost’ for private health insurance, and evaluate the ‘accessibility’ of the private health insurance being provided.

• ECOBOL: The purpose of the Enterprise COBOL Conversion initiative is to upgrade from the current COBOL language compiler used in SETS applications from “IBM VS COBOL II RELEASE v 3.2” to “IBM Enterprise COBOL for z/OS 3.4.0”.

• ODT: The purpose of this release is to correct the differences between Federal Law and Ohio Administrative Rules and the ODT taxes offset submittal logic, and bring the SETS ODT tax offset submittal logic into compliance with Federal and State laws.

Responsibilities:

• Reviewed the Business Requirements and System Requirement documents with the business team and Design team to understand the functionality of the application.

• Involved in all the phases of Project development Life cycle.

• Prepared the Test Plan and Test Metrics.

• Worked with Development team to analyze the software and its application in Mainframe.

• Involved in writing test plan and test cases by reviewing System requirements document and use case models and used Quality Center to write the test cases.

• Performed the testing process according to Agile technology.

• Involved in System testing, function testing and Configuration testing.

• Written Data Driven test to handle the scenario requiring multiple data set.

• Involved in writing customized functions based on the application functionality using QTP.

• Involved in automating the test scripts utilizing QTP.

• Maintained log of defects during testing phase.

• Tested in mainframes applications written in COBOL and JCL.

• Performed White Box, Black Box, Positive and Negative Testing.

• Created test scenarios and executed Performance tests.

• Worked closely with development team to fix the defects raised during the testing phase.

• Responsible for creating production support document.

• Verified the test results on Cognos Reports.

• Involved in UAT with the customer.

Environment: Windows XP, Mainframe, COBOL, QTP 9.5, Java, Java Scripts, DB2, Quality Center 9.2, Cognos.

Infrastructure, DMS & TSI, Austin, TX Apr 06 – Sep 07

QA Analyst

Child Support is the division of the Attorney General Office. IBM portal was implemented on three stages. Portal contained many reports and file transfer functionalities which were accessed by all the 254 counties in the state. The application had several components through which the data was being populated .Mercury tools QTP were used for function testing. There were many bottle necks identified in the Entire X, DB2 & Web sphere servers using Automation. Coordinated with a team of 10 people from different divisions (Training, Engineering, QA, Business &Database) to build out infrastructure for Automation test capabilities, including requirements based test planning, automation strategy.

Responsibilities:

• Involved in writing test plan and test cases by reviewing requirements document and use case models

• Involved in System testing, Business function testing, Configuration testing.

• The following methodology was adopted:

i) Test Scripts were created from the business perspective.

ii) All bugs identified during the process, were submitted using Test Director.

iii) Testing was done through different phases i.e., Functional Testing and Regression.

• Involved in testing different types of Portal Application modules like infrastructure, EOS.

• Written Data Driven test to handle the scenario requiring multiple data set.

• Involved in writing PL/SQL queries for data driven testing.

• Involved in writing customized functions based on the application functionality using QTP.

• Involved in automating the test scripts utilizing QTP and Test Director.

• Maintained log of software issues for Regression testing.

• Applied Change control procedures for mainframe applications.

• Tested in mainframes applications written in CORBA, CICS and JCL.

• Performed White Box, Black Box, Positive, Negative, End to End Testing..

• Created Scenarios and Executed Performance tests using Load Runner.

Environment: QTP 8.0, Test Director 8.0, Load Runner, Manual Testing, VB Scripts, Web Sphere, C#, IIS, JavaScript, Oracle, PL/SQL, Mainframes.

Progressive Insurance, Cleveland, OH Sep 05 – Mar 06

QA Analyst

Worked as a QA tester/Analyst during the testing phase of this Windows based Application. This is an Insurance Information System, which gives online quote for the customer Auto and Home Insurance in different States of USA. This application was developed using Visual Basic, ASP and Oracle. The system keeps track of all Automobile insurance Quote system, its customer details and related project etc. This system consists of different modules like Customer details, Benefits and Packages etc.

Responsibilities:

• Involved in the Quality Assurance Analysis and Testing of Insurance Information System.

• Interacted with users and vendors for full life cycle of the project.

• Prepared and executed Test cases based on User Requirements Document (URD) and prepared Test Procedures.

• Developed a test database in Microsoft Excel to conduct Data driven test.

• Developed Test cases for Auto and Property Modules (Home Owners, Renters and Condos).

• Involved in the Regression Testing of Property Module with different Data (Data driven Test).

• Verify Actual results against Expected results and investigate discrepancies.

• Report any defects using Test Director.

• Fix and component Test defects.

• Involved in the Quality Assurance Analysis and Testing of Insurance Information System.

• Actively involved in various phases of the testing cycle such as System, Functional, Regression, Integration, and End-To-End Testing.

• Test Director was used for tracking the defects.

• Carried out extensive testing with Win Runner, testing tool with different test cases, which reflects the various real time business situations. Test results analyzed and suitable corrective actions were suggested.

• Involved in Extensive testing of various situations along with the implementation team, resolved the issues and problems. Used Test Director for bug tracking.

• Performed Manual Testing of Insurance Information System.

• Involved in UAT with the customer.

Environment: IBM Pentium PC, Windows, SQL Server, Oracle, VB Script, Test Director, Win Runner.

AT &T, NJ July 04- Aug 05 QA Analyst

AT&T is one of the nation’s leading Communication service providers and also plays a major role in local telephone industry. Detailed information about there billing, services, new features, company information, due dates, minutes used, and payment information was provided to each customer.

Responsibilities:

• Reviewed and Analyzed the System Requirement Specs (SRS) and design documents.

• Reviewed and analyzed new user requirements, program design, coding, and Unit testing.

• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results.

• Extensively used Quality Center, for test planning, bug tracking and reporting.

• Uploaded Business requirements, test scenarios, test cases and defects for MS Excel to Quality Center.

• Developed detailed Testing Methodologies, Test Matrices, Test cases and Test scripts,

• Worked on Manual Testing and Automation using Quick Test Pro and Quality Center.

• Developed various reports and metrics to measure and track testing effort.

• Master GUI Map is maintained in the central repository and changes are made to it for every version.

• Performed Functional/Regression testing and Black box, System Testing and User acceptance testing.

• Generated Automation Scripts and TSL Test Scripts using Win Runner for Regression Testing and the additional scripts are generated for each version.

• Data driven testing is performed and the scripts are enhanced.

• Documented all the performance results and regression tests results were compared at every new build. Analyzed and Presented Results.

• Interacted with developers to resolve for the savior priority bug issues which would affect income generating functionality in Production.

Environment: Win Runner, Quality Center, Quick Test Pro, Manual Testing, Windows XP,.Net,ASP.Net, Java, Web Sphere, XML, HTML, VB Script, and Oracle 8i, SQL.

State Bank of India, INDIA May 03 - Jun 04 QA Analyst

SBI offers a full range of financial services to commercial and business customers, and consumers. The Bank Online option on the web site enables the customers to access their accounts with the bank via the Internet. This enables them to check their current balances, instant transfer of funds, Invest Online and pay their Bills using the Online Banking Services.

Responsibilities:

• Involved in Front end and Back end testing of the application.

• Performed Manual Back End testing to verify data integrity and validate output data/files and (or) database.

• Extensively used SQL queries and created SQL scripts for backend testing and data validation.

• Performed automated testing using QTP for the front end part of the application.

• Developed data driven tests using QTP to test transactions with variable data.

• Developed various test scripts to perform Regression testing.

• Involved in all phases of testing.

• Maintained tests and built reusable scripts.

• Worked with business users to create system manuals.

• Managed Test cases, Tracked defects and reported the same using test management tool Test Director.

• Compilation and Presentment of Test status reports on regular basis.

• Experienced in administration of Mercury Test Director, maintaining the day to day Test Director Environment like managing Test Director Projects, Database monitoring etc.

• Created batch tests using Test Director during Regression testing.

Environment: PC-Pentium, Windows NT Workstation, Oracle, DB2, C, Java, VB Script, PL/SQL, HP UX, Quick Test Pro, Load Runner, Test director.

Life Insurance of India Jun 02- Apr 03

Insurance Information System

QA Analyst

This is an Insurance Information System, which gives online quote for the customer Life and Home Insurance in different States of INDIA This application was developed using Visual Basic, ASP and Oracle. The system keeps track of all Home insurance Quote system, its customer details and related project etc.

Responsibilities:

• Analyzing the Business requirements and the site specifications.

• Developed detailed Testing Strategy for the entire application and developed various test cases.

• Developed the test plans for GUI, Functionality Testing, System Testing and User Acceptance Testing.

• Performed System Testing and User Acceptance testing.

• Various Scripts were generated using Win runner for Functionality and System Testing.

• Performed Integration testing, regression testing, Black box and White box testing

• Was responsible for installation of Oracle 7.3,Visual Basic for the project

• Extensively performed testing using Win runner to test GUI objects.

• Background processing like SQL Query were tested on server using query builder

• Rigorously performed Technical evaluation of server data process from MS Access system to the Oracle.

• Interactive reports based upon Benefits Processing life cycles were tested and rectified the areas where changes are required to functional team members

• Test director 5.0 was used to generate various reports and the Win runner Scripts are invoked and were run successfully using Test Director.

• Using Load Runner 6.5 the load test, performance test and volume test is being performed.

• The tests were run by creating 100, 200, 400 virtual users for load, volume and performance test respectively and Performance Monitor was used to monitor and analyze the performance of the server by generating various reports for CPU utilization, Memory Usage etc.

• Also analyzed the Load Runner reports to calculate Response time and Transactions per Second (TPS).

• Performed database testing in Real Time Inventory module.

• Interacted with developers for analysis of the application.

Environment: Windows NT, Oracle 7.3, Visual Basic, Test Director 5.0, Win Runner 6.0, Load Runner 6.5.

Contact this candidate