AddThis Social Bookmark Button
suman r ( Available )
chicago, Illinois - 60616 USA
Expertise :Siebel , QA tester
Status :Have Work Visa
Job Type :
All - Corp-to-Corp
Position :Computer and Mathematical, Healthcare Support, Sales and Sales Related

Resume
 
Summary





Over 6 years of experience in Manual testing, Automated testing, Functional, Performance and Stress testing in web based and client/server Siebel applications. Excellent knowledge of Test methodologies, Test strategies, Test planning and Test Implementation. Very good knowledge of Software Development Life Cycle, Software Testing methods and Object Oriented Programming. Experience working with applications developed in JAVA, VB. Net, ASP. Net, Visual Basic, Java Script, PERL, HTML, XML, Oracle and Sybase.
Over 3 Years of experience in CRM Testing which include Financial back ground, Siebel Call Center, Siebel Customer, Siebel eInsurance, Siebel eBussiness, Siebel Sales, Siebel eService Excellent oral and written communication skills with extensive experience in problem identification and resolution. Has proven ability to multi-task and work on multiple projects and thrive in a fast-paced, deadline oriented environment. Sophisticated analytical skills to solve technical and business related issues.
Technical and business document review
Extensive experience in software quality assurance and testing using Mercury Interactive automation tools like TestDirector7.6/8.0, Quality Center 8.08.29.0 Quick Test Pro 8.0, Rational ClearQuest, Rational Robot, Toad 9.0, Java refresh Request Utility
Tested Siebel Call Center Application on various platforms
Extensive experience in developing Test Plans, Test Cases, Test procedures and Test Scripts using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities
Experience in Telecommunications or Banking or Web hosting/ CRM Siebel systems and Siebel ePharma, Mobile Kits testing, Remote Client testing, Transaction routers, Remote Wireless mechanism for data transfer test validation.
Functional, Integration, Performance Validation testing, Acceptance, Regression and System Testing.
Production Validation of the Applications under test.
Experienced in Integration, Agile, System, Functional, GUI, Black Box, Regression, Smoke, Database Integrity, User-Acceptance UAT and Performance testing
ClearQuest, Test Director and PVCS tracker to report defects and generate reports and graphs.
Test Director and Defect Tracking Administration.
Extensive working knowledge in Unix, Linux and Windows platforms
An energetic individual with good work ethics, excellent interpersonal, writing, communication skills ability to handle projects independently, detail oriented and an effective team player


Employment

August, 2008 -  Present
Role : QA Tester

Company : APC West Kingston , RI

American Power Conversion APC. is a global leader in network-critical physical infrastructure NCPI solutions and It provides protection against some of the leading causes of downtime, data loss and hardware damage : power problems and temperature. APC sets the standard in its industry for quality, innovation and support. Its comprehensive solutions which are designed for both home and corporate environments, improve the manageability, availability and performance of sensitive electronic, network, communications and industrial equipment of all sizes.

Reviewed and analyzed Business Requirements and Functional design documents and derived Test cases from them.
participated in all phases of testing lifecycle Planning, Design, Development and Results.
Worked agrresively on the KABA interface testing Time sheets and manager approvals
Created Test Scenarios and test cases for End to End business process for AR billing, Revenue Reorganization and Time and Materials invoices which are part of Service Contract and Accounting Projects- Service Orders
Remote Client testing, Transaction routers, Remote Wireless mechanism for data transfer test validation, Mobile Kits testing
Worked extensively on Customer Support Projects Field Service Engineer- Dispatch Board-Service Scheduling which are the part of Enabling Execution Everywhere involved in Siebel- Oracle based testing
Tested MVG s, drill down, Links, views, Pick List, Pick Applets
Involved in smoke test in Test Env.& highly interactive with Business or SME with regards to Latest Enhancements

Created Regression suite and added key business test cases and tested in QA Env to make sure the application is consistent involved in Pre-Production and Post Production Testing Activities
Performed Database Validations using SQL Queries.
Modifying Object Repository to help QTP identify GUI objects and enhancing the scripts using VBScript in Expert View.
Created. vbs files for different functions and stored them in Quality Center.
Executed Regression Test cases using QTP 9.2
Interacted with the Business Analysts and Developers to resolve issues.
Worked closely with users and program developers to ensure that the application development met the user expectations
Identified and reported defects and managed defect tracking and reports in Mercury Quality Center.
Worked closely with Offshore ITC team members to complete the scenario on schedule and helped them understand the business process

Environment : Siebel 7.8, 8.0, Siebel CallCenter, Siebel eService, eSales, Oracle 9i, QTP 9.2, QualityCenter 9.2


January, 2008 -  May, 2008

Company : Medtronics , MN

Medtronics has implemented an SFA solution, MAX, to provide its sales reps with an easy way to access client information. This solution combines Siebel Systems Life Sciences 7.8.2.5 application with desktop and tablet technology to enable the Abbott PPD sales force and provide a paperless, one-stop servicing solution for the reps. The tablets will have MAX installed on them and is used for contact calls to record transactions, sample disbursements where applicable. The tablets is used to create and modify contact profile information. The sales force while in their personal home offices and in the field will use tablets. Relevant information from each sales person s tablet is synchronized to the Siebel application server at Abbott Home Office through an secured remote connectivity solution. The home office personnel will use a laptop or desktop to connect to the MAX application through the Intranet to perform their tasks.

Functional and Technical understanding of Siebel ePharma Application and various interfaces used tested Screens in Siebel Accounts, Contacts, Activities, Time off Territory, Samples Etc.
involved in Object Level Testing, Applets, Views, Business Components and Pick Lists Call Address in Siebel
Tested Access Control of Siebel ePharma application by login into Sales Force Automation Application using different user-ids and verified screens based upon responsibilities.
In Siebel Assigned Contacts, Professionals, Accounts, Samples and Employees from HO to Rep Tablet.

Tested the EIM Batch flows to validate the Data loading from other systems using TOAD tool by executing complex SQL queries involved in writing SQL and Select Statement and used where clauses to the specific output Queries for Creating, Updating, Deleting, Inserting, Searching. For Contact, Account, Creating Patient, Patient Number, CKD, Stage, CKD, PTH Test, PTH Frequency, Profile_ID. Etc.
Built the hardware machines, Tablet for Validation Testing
Created and Updated spreadsheets to keep track of passed and failed test cases in Cycle 12 and 3
Wrote Tester user guide for approving updating and signing test protocols non critical and critical for validation.
Designed and Updated Test Scripts as per the new and existing requirements
Executed Test Cases step by step by conducting various testing like Validation, Functional, System, Integration and GUI Testing.

Run the SQL queries in toad 9.0.1 to identify professionals and organization, state license status, patient type, Number etc.
Verified in QC Siebel 6.3 and 7.8 requirements are mapped to test cases are not.
Maintain traceability matrix, The purpose of this document to trace the functional requirement to the test protocols
Used java Refresh Request Utility Tool To Submit Account Row_ID s and Professionals Row_ID to verify in WBI database and verified in XML to make sure all submitted row_ID is displayed.
Perform Performance Validation Testing PVT
Developed new Test Cases for Regression Testing and executed Regression Test Scripts in QC

Environment : Siebel 6.3/7.8 SiebelePharma, Oracle 9i, Quick Test Pro 8.0, Quality Center 9.0.1 TOAD for Oracle 9.0.1 Oracle Database, XML Web Services, Word, Excel, Windows XP/NT.


August, 2006 -  December, 2007
Role : QA Analyst

Company : Wells Fargo Home Mortgage , IA

Wells Fargo is consolidating its 3 lines of business to have a single application processing system and to provide better servicing to the customers. CORE is a single interface platform where users can access loans from different business lines. Users can access and monitor the loan info. Wells Fargo provides various Mortgage Solutions like Refinance, Home Equity and Purchase etc. with competitively priced loans and outstanding customer service through a nation network of Wells Fargo Banks and through its Partners. Wells Fargo provides loans for Owning Home, Home Improvement and Reverse Mortgage for seniors through a variety of products like 15 year-Fixed Term, 20 year Fixed Term, FHA, 30 Year Fixed Term, ARM, 1 Year ARM etc. The AOW- AppTaker on the Web is a complete loan servicing and loan origination system developed using J2EE, Java Struts, Business Objects and Oracle. LIS Loan Information System is a mainframes application developed using CICS, COBOL, DB2, TSO, ISPF, JCL, File Aid, Oracle etc used for funding process of the loans. The AOW/LIS application is designed to follow various steps of loan origination, tracking and closing. The application contacts credit bureaus and then contacts borrowers to clarify details, makes decision and provides borrowers with requested loan amount.

Prepared Risk Analysis matrix to pririVerified Screens for their views and different fields in Applets.
Verified Screens for their views and different fields in Applets
Created different document and matrices like test log, test incident report, test coverage matrix, tractability matrix etc.
Worked on Apptaker on Web application AOW
Worked on various Loans types and Restructured how user requirements were gathered and translated into application requirements to formalize the process and better manage the client s expectations.
Processed FHA loans as per State Policies, LTV. TLTV Calculations, updated functionality enhancements as per specific Loan Documentation for IA, NE states
Used Test data of various types of Loans in different environments to test the behaviour with different portals with different data servers.
Worked on Documentation for Closing fees, Reverse Fees, ARM, Pricing Engine
Tracked requirements coverage into test cases using Quality Center
Involved in preparation of test data using Excel Sheet for End-to-End Scenario based testing in Web/Main-Frame environment and in validating the interfaces from Sales system to EO, Supreme/Unisys, Customer view and Credit Bureau systems

Prepared test summary reports every week to report the status of testing.
Created and executed test cases and test scenarios
Participated in Integration testing and also in User Acceptance testing along with business users and mentored them the Clear Quest tool
Performed Manual Testing of GUI application and automated by using QTP
Logged and tracked the defects using Clearquest defect tracking system
Logged defects using Clear Quest and defect Ids are recorded in QA Comments column in Quality center
Used various In house tools for regression testing, like, DD Qualgen, Test harness, with XML scripts
Performed Regression Testing using
Involved in functional testing of the application
Interacted with developers to resolve application Defects.
worked on projects GRD Get Risk Decision, EPO Eligible Products Opportunities, Loan Processing, Loan Decision engines, LIS

Environment : Siebel, HP Quality Center 9.0.1 Windows OS, Oracle 9i, XML Web Services, TOAD 9.0.1 XML Spy, MS-Visio, MS Outlook, Word, MQ Series, Excel, Rational Clearquest, Oracle 9i, Websphere SQL server.


January, 2006 -  June, 2006

Chase , OH
Role : QA tester.

Involved in analyzing the business requirements, system specifications, designing and development of Test plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
Gathered specifications and requirements from development personnel prior to System Testing
Validate the accounts in Siebel and verify the victim pointing to survivor
Involved in performing User Acceptance Testing UAT.
Created Traceability between Requirements and Test Cases.
Generated, Analyzed and published test results and documented the testing process
Performed Manual Testing of GUI application and automated by using QTP
Test Director is used for creating coverage between requirements and test cases
Interacted with developers to resolve application Defects.
Involved in functional testing of the application using QTP.
Performed End-to-End testing manually

Environment : Windows OS, J2EE, SAP, Siebel, Weblogic, Mainframe, JavaScript, VB Script, SQL, QTP, Test Director, Toad, PVCS Tracker and Oracle, HTML, XML. Rational Robot


May, 2005 -  December, 2005
Role : QA Tester

Fifth Third Cincinatti , OH

Project : Credit Card Member Services Group that deals to manage credit card accounts and resolve the issues of credit/debit business transactions between consumers of credit card issuer/members and merchants/acquirers
METHOD/1 Testing Standard is the American Express Testing standard and the methodology which all testing should follow during the software lifecycle. As a QA Analyst and Tester my responsibilities included :
Attend relevant project meetings and contribute to the development of the test plan.
Create and document Test Conditions, Test Data, Expected Results, Test Cycles, etc.
Create Test Scripts and Execute on-line Test Scripts.

Report status or issues to testing coordinator, Identify, analyze, document and re-test incidents and document test results.
Create and monitor daily incident report and manage the completion of program fixes.

Monitor status of fixes and communicate estimated completion dates to test management.

Work with analyst and developers to correct incidents, report all system downtime, slow response and other environmental problems to Development Team.
Used Test Director extensively to maintain test cases and also for tracking the defects.
Used Test Director for maintaining requirements and maintained the Traceability matrix between the requirements and Test Cases.
Used WinRunner to automate the testing efforts of the application.

Environment : J2EE, WebLogic, TestDirector, Quick Test Pro, Windows NT/2000, UNIX, SQL, XML, MS-Word, MS-Excel


January, 2005 -  April, 2005
Role : QA Analyst

CNA Insurance , IL Fifth Third Cincinatti , OH

Working for SBC as QA Analyst, I are involved in the testing and validation for various web based applications. My responsibilities included :
Maintained requirements and created Tractability between Requirements and Test Cases.
Developed test cases based on functional specifications and design documents. Wrote various test scripts for system and integration testing. System Testing
Involved in Data Analysis, Planning and Setup of Data in Test Environment.
used SQL queries to verify the integrity of the database.

Involved in Coordination activities with Release Management and Environment Management team.
Tracked software bugs using Test Director and informed developers to resolve technical issues.
Involved in performing User Acceptance Testing.
Preparing test plans and writing test cases and scripts for automated testing.
Researching defects in baseline documents, database tools and QA tools. By executing SQL and PL/SQL statements.
Executed Data - Driven tests using Data Bank Wizard.
Used MS bug tracking system to log defects, make defects reproducible, Verify bugs fixes
Environment : Test Director, QTP, Win Runner, UNIX, J2EE, XML, SQL and Web Logic.


May, 2004 -  September, 2004
QA Tester

Reliance Infocomm India




Education

Bachelors in Computer Sciences , India



Skills

Testing Tools : Quality Center Formerly TestDirector 8.0, 8.2, 9.0, WinRunner 7.5, LoadRunner 7.8. Bug Tracking Tool : Mercury TestDirector, Quality Center, Rational Clear Quest Rational Robot Query Tool TOAD, SQL Loader, Visual Source Safe CRM Siebel Tools 6.37.8, Seibel ePharma, Call Center, Siebel Sales, Siebel eInsurance, Siebel eMarketing, Siebel eBussiness, Siebel eService, Telecommunication Languages : C, C++, Shell script, VBScript, Visual Basic 6, Java 2.0, JavaScript, XML, HTML, PL/SQL Databases ORACLE 9i/8i/8/7 .x, Sql Server 2000, MYSQL, MS-Access Operating Systems : Windows , UNIX V4.0, Solaris 2.6, Sun Solaris 7, Linux 6.2/7.2, MS-DOS, MacOS X, Symbian/S60, S40 Servers : IIS, Apache Application Server, BEA Web Logic, Server 6.1, WebSphere Application server Utilities : Word, Excel, MS PowerPoint, Snag it, Lotus Notes



Miscellaneous

Responsibilities : Responsible for analyzing the requirements and the critical areas of the application to setup and execute baseline tests, Mobile testing.
Generated and implemented templates for Test Plan, Test Cases, Test Scripts, Business Analysis, Test Defect Log, Test Case Checklist
Responsible for identifying the functional test cases for Regression Testing and automated these scripts using Mercury WinRunner.
Used Test director for defect tracking.
Involved in regression, GUI, functional, stress and usability tests.
Interacted with the developers and technical content writers on a daily basis to update the test documents.
Follow up with developers on defects status on a daily basis.
Environment : ASP, VB, Oracle, MS-Access, Windows NT/2000, Winrunner, Test Director MS-Access