TECHNICALSUMMARY

Testing Tools: Quality Center 8.0, 9.0 Test Director 7.x, Quick Test Pro 6.x/8.x/9.x, Win Runner 6.x/7.x, Load Runner 7.x,8.x, SQA Test Suite, Silk, Rational Suite
Data migration: SQL* Loader, TOAD 8.6.1
Languages: C, C++, SQL, PL/SQL, XML, ASP, .Net, Java 2.0
Data Access: ODBC, ADO (ActiveX Data Object), RDO (Remote Data Objects), DAO (Data Access Objects)
RDBMS: Oracle 7.x/8i/9i, SQL Server 7.0/2000, DB2, MS Access
CRM: Siebel (Tools 7.X/6.3, Sales, Call Center)
GUI: VB 5.0/6.0, Developer 2000, Forms 4.5 and Reports 2.5
Operating System: UNIX, Windows N.T 4.0, Windows XP, Windows 95/98/2000
Mainframe: COBOL, JCL, MVS, CICS
Internet Technologies: HTML, DHTML, VB Script

PROFESSIONAL SUMMARY

• Over 10 Years of experience, in ITanalysis, design, development, customization and Testing of software applications.
• Around 8 years of experience in Testing, Data Migration, Configuration, Integration and Customization of Siebel 7.x/6.x, CRM Sales, JAVA
• Experience with backend testing, strong SQL skills and knowledge of UNIX
• Extensive experience in preparing Test Plans, Test Scenarios, Test cases, Test Reports and Documentation both Manual and Automation.
• Strong skills in planning & executing Regression Test, Function Test and Integration Test.
• Strengths include excellent interpersonal and communication skills and the ability to provide solutions from a functional and technical perspective, meet deadlines.
• Extensive experience in QC (Quality Center), QTP (Quick Test Professional), Win Runner, Test Director, Load Runner, PVCS Tracker.
• Experience in load, stress, and performance testing using Load Runner.
• Worked in different software environments and can easily fit into new environments if required.

EXPERIENCE

Mar 2009 – Sep 2009 Confidential,Simi Valley, CA
Senior QA Engineer

The applications is web-enable additional enhancements such as Billing Inquiries, Policy types, Policy Laps Time, Policy Maturity Date and an Enquiry of different types of Policies available. The application has different modules like Policy Details, Payments, Agents Comments, Policy Validations, Vehicle Coverage and Customer Communications.

• Analyzed user requirements and system specification documents.
• Performed BlackBox Testing based on the Functional requirements and product specifications of the application.
• Developed Manual Test Cases for the Functional testing
• Executed Test Cases, maintained Defect Report using Quality Center and updated weekly status reports
• Identified high priority test scripts from the functional test cases to develop Automation scripts in QTP for the Regression Master Suite
• Inserted GUI checkpoints test scripts and performed the Data Driven Test that deals with different sets of data
• Written SQL Queries to retrieve data from the database.
• Performed Compatibility Testing on Internet Explorer, Mozilla Fire Fox to verify the browser Compatibility

Environment: .NET, Siebel 7.7, SQL, J2EE, TOAD 8.6.1, QTP 9.0 and Quality Center 9.0, Oracle 9.i and Windows XP

May 2005 –Confidential,

Nov 2008 Irvine, CA
QM Analyst/Engineer

Wisdom 7 Application
Capital Group Companies is one of the leading Mutual Funds Investment organizations in US. The Siebel Sales Force (WISDOM) application upgraded from S6to S7.7 with enhancements. The application deals with the Sales Representatives whose activities are logged. Some of the features of system are Wholesalers/Area Sales Rep calls/visits of Offices are tracked, Meeting Planner forums, Conferences, Sales and Proposals.

• Analyzed the Focus Area Requirements and Business Process documents
• Interacted with the BSA, BA on the workflow needed for the functional testing.
• Created test scenarios from design documentation and functional requirements
• Executed the Test Cases and filed the defect in Clear Quest
• Wrote the Test Scripts for the Reports and executed all the Reports
• Published the Reports Execution results for the Wisdom Jan 19 ‘2006 release
• Involved in the Regression Testing of the Releases Wisdom 1.1, 1.2, 1.3, 1.4, 3.0, 4.0, 6.0 and Backend Releases
• Executed 74 Actuate Reports and verified the backend data through TOAD
• Attending design development , QA Testing meetings and Report status meetings
• Involved in the Upgrade of the Wisdom 6.0 to Wisdom 7.7 and reported the data issues at the record level on the Views and Applets
• Involved in setup of Automation frame work of Wisdom application
• Developed Automation scripts in QTP for the modules Offices, Expenses, Correspondence and Hypo OE
• Executed Automation regression suite for Wisdom Release 3.0, 4.0

Environment: Siebel 6.0, Siebel 7.7, Quality Center 8.0, 9.0, TOAD 8.6.1, QTP 8.0, 9.0, Oracle 9i, Main Frame , UNIX, XML, SQL, Clear Quest 2003, Actuate 7, and Win XP/2000 mWisdom Application mWisdom is an advance technology application where user access WISDOM application data in the mobile phone(black berry).

• Analyzed the requirement for the Release 5.4
• Developed Test Cases for the Release 5.4
• Executed all the Test Cases in the mWisdom with the Blackberry 8660
• Verified the Wisdom7(Siebel) data in the mWisdom like Contacts, activities, sales, notes
• Involved in the mWisdom Upgrade 5.3 OS 4.05

Environment: Pyxis 5.3, Siebel 7.7, Quality Center 8.0, 9.0, Clear Quest and Win XP/2000

Confidential,
Analyzed the requirement for the Release 1.6 and 1.8

• Developed Test Cases for the Releases
• Executed all the Test Cases in Wisdom Hypo OE
• Verified the Hypo OE data in the Wisdom7(Siebel) like fund abbreviation , fund name, amount and type of hypo Order Entry Single, Standard, Rolling Period and Comparison
• Reported defects in Clear Quest

Environment: Java 2.0, Siebel 7.7, Quality Center 8.0, 9.0, SQL, TOAD8.6.1,Clear Quest and Win XP/2000

Confidential,
SOFI Application deals with the customer information Contact Name, Phone, Email and Comments, The source data comes from the Siebel Wisdom 7 application. Data validation is done for the Contact Name, Phone, Email and Comments.

• Automation frame work is developed
• Identified automation scripts for the Regression Suite
• Created Automation scripts in QTP for the Release 1.0.1, 1.0.2
• Executed Automation Suite for Release 1.0.1, 1.0.2
• Checked the usability of the application and graphical interfaces
• Contact Data validation is done for the source data on backend as well on the UI

Environment: .Net, Siebel 7.7, Java 2.0, J2EE, QTP 9.0 and Quality Center 9.0, Oracle 9.0 and Windows XP

Confidential,
Hypo IV is windows based application. Sales advisor are the prominent users of the application. Hypo Investment View gives the power to run a variety of illustrations based on several investment and withdrawal schemes.

• Analyzed the Requirements and prepared test cases
• Executed the Test Cases and filed the defects in Clear Quest
• Automation frame work is developed
• Created Automation scripts in QTP
• Executed Automation Suite for Thomson Release 7.2
• Attending Hypo Core meetings, QA Test meetings and Reported testing status
• Automation regression suite is developed for the Monthly IV updates

Environment: Hypo IV, Quality Center 8.0, 9.0, Beyond Compare, QTP 8.0, 9.0, and Win XP/2000

Confidential,
Confidential,is VisualAge Smalltalk based application. It is most user friendly application. Share system tracks the Share Inventory of customers.

• Created Automation 20 scripts in QTP for the Rain module
• Executed Automation Regression Suite for R56.0.1
• Executed Automation Regression Suite for the new Environment SHARE CTA and CTB

Environment: VisualAge Smalltalk 4.0, Quality Center 8.0, 9.0, QTP 8.0, 9.0 and Win XP/2000

Confidential,
(Transaction Processing Rewrite application)
The Transaction Processing system is an JAVA based application that processes all nightly and monthly transactions for AFD. These transactions are matched to profile data in DORIS and SIEBEL CRM for purposes of internal compensation, external sales force crediting and accurate sales reporting. The data is then sent to various subscribing systems for reporting and sales force crediting purposes. The transaction processing system is considered the book of record for all AFD transactional related data.

• Analyzed the requirement for the Use Case Business Rule 9.11, 9.38, 9.40, 9.42, 9.48
• Analyzed the Data model LDM & PDM(Logical, Physical)
• Developed Test Cases and test data for the Business Rules
• Incorporated SQL Queries in the test cases to load the A22 file and validated the Business Rule 9.11, 9.38, 9.40, 9.42, 9.48
• Executed all the Test Cases in the UNIX box Schubert
• Verified the business rule A22, A95, RPO Schwab and RIA file data in the Toad
• Verified new transactions if it is an invoice, a direct settled or a reversal. Otherwise if it is a cancelled, paid, settled or paid & settled simultaneously then it is a corresponding part of the prior transaction.

Environment: UNIX, JAVA2.0, Siebel CRM Sales, Quality Center 8.0, 9.0, SQL, TOAD 8.6.1, XML, Clear Quest and Win XP/2000

Confidential,

• Analyzed the requirement for the WMS Change Request 27, 28
• Developed Manual & Automation Scripts for the Release
• Executed all the Test Scripts in the High Jump application
• In Advanced Dashboard module, tested the Inventory Items, Literature Orders and Batch Single Order

Environment: Java 2.0, Quality Center 9.0, QTP 8.0, SQL, TOAD 8.6.1 Clear Quest and Win XP/2000

Confidential,
Analyzed the requirement for the Vendor Source 2.8

• Developed Test Cases for the Release 1.6
• Executed all the Test Cases in the CICSALT mainframes
• Verified the Literature Order for the new Vendor in AE

Environment: Mainframe CICSALT, Quality Center 8.0, 9.0, DB2, TOAD 8.6.1, Clear Quest and Win XP/2000

May 2004 –Confidential,

April 2005 OH
QA Analyst/Tester

Siebel e-Sales Application
Procter & Gamble is the world largest consumer goods manufacturing company and it products are available in 150 countries. Procter & Gamble has Siebel e-Sales application for distributing his consumer goods.

• Analyzed the Business Requirements and User requirement document and developed test plan, which includes test strategies, test environment, test objectives, test priorities and test cases etc.
• Prepare test plan and test cases for business process.
• Record, play back and parameterize the QTP scripts.
• Integrate QTP with Test Director.
• Write System, Integration and Performance Test Plan for PDL (Product Distribution List).
• Prepared test report for PDL Nov’04 release.
• Execute system testing, integration testing and regression testing.
• Attend bug meetings and design development meetings.
• Interact with Off Shore Consultants on project status.
• Document Requirements and write Test Scripts using Test Director.
• Prepared Performance Test questionnaire for Siebel e-Sales Application.
• Defining the performance goals, objectives and user mix based on the client requirements and inputs.
• Tracking performance defects to its closure.
• Making Hardware sizing and recommendations to DB changes Benchmarking and base lining the application for user load under peak load conditions and stress testing to scale the application for volume testing.
• Schedule meetings and interacting with the persons aligned such as stake holder, Project managers, DBA, System/Network administrators etc.
• Identifying and defining the data setup needed.
• Business workflow modeling and defining the user mix in conjunction with the business Analyst to develop the right scripts.
• Extensively used LoadRunner 8.0 VuGen with Siebel correlation engine for generating the automated test scripts.
• Inserted Transaction and Rendezvous points to calculate transaction response time under load.
• Worked with Loadrunner specific monitors like the Oracle Database monitor, System monitors, Web/App Server monitor, Firewall Monitors etc.
• Analyzed various graphs like Transaction Response Time, Hits per second graph, Pages download per second, Throughput, Network Delay Time graph and generated reports using LoadRunner Analysis
• Generating, Analyzing and interpreting the reports post the performance test execution
• Suggesting Improvement areas in terms of performance enhancements

Environment: Siebel 7.5.3, Test Director 7.6, Quick Test Pro 8.0, QTC, SQL, TOAD 6.2.3.16, LoadRunner 8.0, Oracle 9i and Win XP