EDUCATION
BS – Confidential,University

RECOGNITION
Recognized and awarded for outstanding participation in the Drive to Web Program to promote
ESupport and ESR with IBM Clients.

SOFTWARE/TESTING SKILLS SUMMARY
Testing Tools : Quick Test Pro, Win Runner, Load Runner,
Reporting/ : Mercury Quality Center, Test Director, Change Synergy
Defect-tracking
Tools : TOAD, Microsoft Visio, Microsoft Office, Microsoft Project, SQL* Plus
OS : Windows NT/XP/Vista, UNIX, Sun Solaris, Red Hat Linux, IBM AIX
Database : DB2, My SQL, SQL Server 2000, Oracle 10i, MS Access 2003
Application Server : Websphere App Server, Sun application, server, windows Server2003, WMQ
Web Servers : Microsoft IIS, Sun Java system Web Server, Apache, IPlanet
Languages : Java, J2EE, C, SQL, PL/SQL, HTML, XML, Visual Basic
Version Managers : CVS, Clear Case, PVC

Training:

• Professional courses in Manual / Automated Testing, Business Modeling, Database Programming in Oracle, SQL, PL/SQL, Application Development in Developer 2000 (Forms, Reports and Graphics)
• Retek technical training on SQL, PL/SQL, Forms Developer, Forms Development standards 9.0 and Retek Merchandising System (RMS) 9.0 Fundamentals 1 and 2 from RETEK INC., Minneapolis.
• WebSphere MQ System Administration
• DB2 Universal Database Administration Workshop
• Linux Installation, configuration and edit file systems, setup user accounts and use system utilities.
• Completed CompTIA A+ training from North Carolina State University.
• Network + training from North Carolina State University.

PROFESSIONAL WORK EXPERIENCE
Confidential,IL Feb 09– Present QA Test Engineer Worked as QA Analyst at State Farm Insurance Company with many web based as well as PC based applications. This project deals with insurance plans and policies. This project technology initiative recognizes global needs to support agents and agency management in terms of their day-to-day operations as well as managing events in future. Involved in Integration Testing, GUI, Functionality and User Acceptance Testing effort. Used Test Director to report bugs and defect tracking.

• Analyzed user business requirements, functional specs and assisted QA Team in writing the Test Plan.
• Involved in writing test plan, test cases and responsible for executing the Test Scripts.
• Responsible for creation and execution of manual and automation test scripts.
• Worked closely with development staff to resolve the defects and testability issues throughout Software Test Life Cycle.
• Conducted peer reviews for high-level test scenarios, test plan and test cases.
• Involved in entering requirements, developing test plan tree, designing the test steps, writing TestCases and running TestScripts using Test Management Tool (Quality Center).
• Written Detail Test cases for automation and used QTP to automate
• Performed Regression Testing using Quick Test Professional (QTP)
• Used SQL queries to verify the integrity of the data in the database used for testing.
• Created the checkpoints and used the concept of data driven testing to test the functionality of the application.
• Provides Status updates to Project Manager.
• Ensure appropriate Test Environment and Test Data are available.
• Tested the application compatibility in different browsers like Netscape Navigator and Internet Explorer.
• Executed performance testing of application using Load Runner.

Environment: Mercury Quality Center, QTP, Load Runner, MS .NET, Oracle, SQL, Windows NT/2000/XP, UNIX, AIX, OS390.

Confidential,KS May 07 – Oct 08
QA Tester/Analyst
Worked as QA team member for Embarq and performed QA Testing on its billing system. Embarq is a leading provider of telecommunication services including traditional wireline, DSL, and Bundle packages(DISH Network Satellite TV & phone/DSL) for the consumers and businesses . It is the fourth largest landline and DSL service provider. The project involved with authorized system resources to process customers’ orders such as enter customer information, process credit application, activate wireless services, and perform changes to the existing customers.

• Analyzed user business requirements, functional specs and assisted QA Team in writing the Test Plan
• Analyzed and studied Use Cases and converted them to Test Cases.
• Written Manually Functional Test cases for manual testing.
• Performed Unit Testing along with developers.
• Written Detail Test cases for automation and used QTP to automate.
• Used Mercury Quality center for Test Management and Maintained the Test Cases and Test Scripts
• Used SQL queries to verify the integrity of the data in the database used for testing.
• Verified and validated weekly defects reports and addressed them to the QA Manager
• Set the QA Environment for Manual Testing as well as for Automation using Quick Test Pro.
• Developed QTP VBscript from manual test cases for Regression testing based on the written test cases to test the application manually in Quality Center and automate requirement documents using Quick Test Professional.
• Delivered Performance Assurance report at the end of project.
• Executed performance testing of application using Load Runner.

Environment: Mercury Quality Center, QTP, Load Runner, MS .NET, Oracle, SQL, Windows 2000.

Confidential, March 01 – April 07
Software Engineer
Worked as a software engineer for Websphere Transaction Systems Center in RTP, NC at WebSphere MQ product of family.

• Worked with customers at a high level of technical expertise which include: diagnosing, reproducing, troubleshooting, debugging and testing complex computer system and software issues across multiple platforms using RETAIN (MVS) system.
• Worked closely with the product development team to improve the scalability and manageability of the supported services and on new design issues and ifixes.
• Troubleshoot installation, configuration, performance, upgrade, and infrastructure setup problems of WebSphere MQ and Websphere App Server customers.
• Tested Beta versions of WebSphere MQ using Java testing tools and sent detailed reports of recommendations to the development team.
• Determined MQ code defects and implements resolutions.
• Created Error and Analysis reports after the run is complete.
• Assign, authorize, and review DCF items for the knowledge database to reduce redundancy and improve customer response times.
• Shared product’s knowledge with peers to enable overall improvement in product expertise as well as product direction.
• Interacted with both technical and non technical users to drive resolutions using emails, FTP

Clients, telephone, VPNs etc.

Environment: Websphere MQ, Websphere MQ Workflow, Websphere App Server, IBM HTTP Server, Windows NT/2000/XP, UNIX, MVS, J2EE, JAVA, XML/HTML, AIX, Linux.

Confidential,MN Jul 00 – Feb 01
Consultant
Worked as Consultant for IBM Global Consulting Practice in implementing of RETEK (Retail Software) ERP Package for one of the Largest Nationwide Retail Store Corporate Office located in Northeast around 700 stores, 7 Distribution Centers (D.C) located throughout Northeast USA. Retek is Retail Application, maintains merchandise system, reduce supply-chain costs, and improve perpetual inventory, reordering, and up sell of products.

• Responsible for requirements gathering (Analysis), design, coding, testing, and implementation.
• Upgrade - Retek Upgrade from Oracle 7.3 database to Oracle 10g database. Oracle forms 6.i to Oracle 9i Forms and Oracle 3.5 Reports to Oracle 9i Reports.
• Developed various process flow diagrams for business scenarios.
• Developed Functional, GUI, Integration Test plans and test scripts for all the test cases to be tested manually.
• Performed Functional, Front End GUI testing and Back-End database testing of various modules and enhancements for Retek Upgrade.
• Integration testing with other systems in the company to validate the flow of data between the systems.
• Modified and tested various reports that are invoked from various forms to implement web reports.
• Created procedures, functions, and packages using PL/SQL.
• Parameterized all the scripts to read data files for input.
• Performance testing of the application and the database by spreading the users across various scripts.
• Created Error and Analysis reports after the run is complete.

Environment: Oracle, SQL, PL/SQL, TOAD, SQL Navigator, Windows NT/2000/XP, UNIX, J2EE, JAVA, XML/HTML.

Confidential,VA March 98 – April 00
Developer
Developed, Designed and implemented a PRU (Provider Review Unit) application system for the Virginia State Hospitals that tracked agency and client information using Oracle developer 2000.This included designing and developing the graphical user interface (GUI\'s) for the new application and converted the existing database into Oracle database.

• Responsible for Implementation of these application systems greatly enhanced client access and allowed for more faster and efficient means of keeping track of client information.
• Responsibilities included logical and physical data modeling using entity-relationships methodology employing integrity constraints, normalization technique, creating table’s constraints, indexes and populating tables.
• This included designing GUIs and reports to facilitate information about tracking orders, orders shipped, orders invoiced and orders billed to carry out various daily routine operations, developing and evaluating submitted queries subprograms and adding functionality to the application by customizing Forms which included LOVs, Record Group, Alerts, Stacked Canvas, Parameters, customized menus and attached libraries.
• The interface was developed using Oracle Forms 4.5.The procedures, functions, and packages were developed using PL/SQL. Oracle 7.1 was used as data repository.
• Responsibilities also included manage data, retrieving and storing information-using SQL, writing adhoc queries and other reports based on day-to-day requirements.

Environment: Oracle, SQL, PL/SQL, TOAD, SQL Navigator, SQL Plus, Windows NT/2000/XP, UNIX

Confidential, IL Aug 97 – Feb 98
Developer
Developed and implemented a Custom Finance System for the Department of Aviation at Chicago Airports for their Finance department to integrate the existing stand-alone systems that can be viewed, updated and reported-on from a system-point of entry to eliminate for redundant data entry.

• The system also provide for an electronic interface to the City of Chicago (CAPS) system using oracle developer 2000 suite of tools that included designing of GUI interface using oracle Forms 4.5 and the data was populated from the legacy systems into Oracle database/repository using SQL* Loader.
• This involved in the designing of logical and physical data model using ERWIN 3.0 as a case tool.
• Created multiple master-detail forms that included designing Forms triggers, procedures and functions besides creating items, record groups, LOVs, customized menus and attached libraries using PL/SQL.
• Applied project methodology skills and experience to complete this project on schedule.

Environment: Oracle, SQL, PL/SQL, TOAD, SQL Navigator, SQL Plus, Windows NT/2000/XP, UNIX