Customer Service Test
Resume:
Sujata Apte
***********@*****.***
Professional Summary:
. Talented professional with 2+ years of experience in the field of
Software testing and 5 years of experience in Mortgage industry
. Certified Software Tester by International Software Testing
Qualifications Board (ISTQB)
. Rich experience in manual testing of Client and Web applications.
. Involved in development of several test cases, test scripts and
test procedures.
. Expertise in analyzing user requirements, functional and technical
specifications, preparing test plans and writing test cases.
. Extensive Knowledge of Software Development Life Cycle (SDLC).
. Wrote SQL queries to test SQL Server to verify the data with the
GUI.
. Proficient in the tasks of Bug tracking and Reporting using Test
Director
. Performed Regression along with Black box and white box testing on
Web, Client-Server Applications.
. Experience in backend testing using SQL statements.
. Excellent team player with good logical reasoning ability,
coordination and interpersonal skills.
. Able to complete projects independently as well as within a team
environment.
. Excellent communication skills have always been an asset in
completing business venture and projects with success
TECHNICAL SKILLS:
Operating Systems: Windows, MS-DOS
Languages: SQL, HTML
Databases: Oracle 7.x/8i/9i, MS-SQL Server, DB2, MS-Access.
GUI: Visual Basic, Power Builder, Swing
AutomationTest Tools: Quick Test pro 8.2
Bug Reporting Tools: Test Director and Quality Center.
Packages: MS Office, MS Project. MS Outlook
Experience:
Telescient Technolgies, Mumbai, India Nov'10 -April 2011
QA Analyst
Customer Online Billing System (COBS) is a Web based application running on
Oracle database. It is used to generate the Customer bills based on their
billing Cycle date, Retrieve billing history, View transactions of Customer
etc., which will be published on internet for on line viewing by the
customers.
Responsibilities:
. Developed Test plans based on user requirements .
. Reviewed and analyzed requirement document for writing the Test cases.
. Performed Functionality, Integration, System, User Acceptance Testing,
Positive and Negative Testing.
. Documented and reported the defects to developers using the Test
Director.
. Prioritized the defects and the severity levels and discussed with the
developers to resolve the issues.
. Formulation of Traceability matrix, test plan, test cases, test data
and test scripts.
. Responsible for updating existing test cases against the requirements.
. Participated in meetings to discuss the status and issues.
. Used Test director for bug tracking and for maintaining the test
documents.
. Checked the data flow by using SQL queries to extract the data flow
from the database.
. Attended QA meetings to understand QA Test strategies, defining data
requirements for the testing and setting up QA Environment for
testing.
. Preparing the Test Plans, Test procedures and Test Scripts from the
decomposed requirements and Use cases.
. Assisted in automation of tests by creating and parameterizing tests
using Data Tables, creating standard and text Checkpoints for QTP
Environment:
Test Director/Quality center, JavaScript, HTML, XML, Oracle 9i, SQL/PL SQL,
Windows XP/2000, MS Office Suite
U.S.Bank Home Mortgage, Minneapolis, MN June 2010 - Oct
2010
Mortgage Final Doc Specialist
OMNI system is intended to store consumer's mortgage documents and enables
users to verify that correct documents are stored. Also application
generates reports daily and on weekly basis about the missing
documentation, or documents that would need more information.
Responsiblities-
. Formal review & inspection of all final loan documentation to ensure
accuracy and completeness adhering to investor guidelines (private or
government) & meeting the delivery deadlines.
. Logging deficiencies in the system, report monitoring to track
outstanding deficiencies & follow up for procurement of missing
documents.
. Communication with the title companies for verification and correction
of discrepancies & validation of the documents.
. Correct & timely delivery of loan docs with the corresponding
investor, pool, contract and sale.
. Performed various tasks, duties or new responsibilities as assigned by
the supervisor or department manager.
Telescient Technolgies, Mumbai, India Nov'08- May '10
QA Analyst
1
This was web-based application developed to provide online access to bank
information to the customer about the monthly transactions made and
accordingly produce the report for it. Tested various modules like
Transactions, Account Status, Account Statements, Reporting, etc. This
system helps the members enrolled with Indian Overseas Bank for Online
Services to get the account information from the web site print out the
Reports/Statements of the transactions made. It allowed money transfer
between different accounts with the bank. This application was developed on
Java, Java Script, ASP and HTML running on Windows 98/NT/2000 as a front
end and at back end it had Oracle 8.0 running on UNIX.
Responsibilities
. Provided Training to users for using the application installed on
Client side.
. Participation in peer review meetings to enhance product qualities.
. Preparation of Test Plan for various modules using business specs.
. Generated and Execution of Test Cases manually and editing the test
cases.
. Defect tracking & reporting .
. Performed GUI testing, Positive and negative testing, Functionality
testing, Performance testing, Regression testing.
. Reported defects detected in application and their repair progress
using Test Director.
. Performed Acceptance, Transaction testing of the application on
different versions of browsers (IE,AOL, NETSCAPE) in diverse
environments including Windows 95/98/NT.
Wells Fargo Home Mortgage, Minneapolis, MN April 2005 - Oct. 2008
Loan Servicing Specialist 2
. Review loans to ensure regulatory requirements are being met;
evaluation of monthly escrow account for individual & mass escrow
analysis in respect to RESPA guidelines.
. Completion of task request & GEM events received from other
departments like WFRETS, Customer Service, Hazard, PMI/Optional, Loss
Mitigation, Bankruptcy etc.to analyze or research loans or in some
cases to remove escrow accounts per homeowner requests. Maintenance
to customer accounts related to Taxes, Homeowner / Private Mortgage /
Mortgage Insurance & Optional Services.
. Setting up escrow accounts on Diamond refinance loans. Escrow
deletion, shortage spreads, assisting management with projects that
affects mass accounts.
. Research & resolve customer problems in regards to escrow analysis.
Justify escrow shortages/overages.
. Review All Port LNA report(Loans Not Analyzed) that captures loans
using narrower criteria than the reports identified by the trial
analysis team and analyze to keep them in compliance with regulations.
Contact this candidate