Prasuna
abm3vk@r.postjobfree.com
Experience Summary
. Over 6 years of experience in Software Quality Assurance and Testing
of Database, Client/Server and Web based applications.
. Expertise in designing Test Cases based on User Requirement Analysis,
Functional Specifications, Use Cases and Business Requirements.
. Experience with QA Methodology and QA Validations to ensure the
Quality Assurance Control.
. Expertise in Backend Testing
. Exercise writes SQL queries to retrieve data from different tables.
. Expertise writes SQL queries using joins to retrieve data multiple
tables.
. Expertise and Experience in performing different kinds of Testing
like: GUI Testing, Functional Testing, Integration Testing, Regression
Testing and UAT.
. Expertise in Performing Validation Testing in different environments.
. Complete understanding of QA methodologies.
. Conversant with all phases of Project Life Cycle including Requirement
gathering, Analysis, Design, Development, Testing and Implementation
of Quality Software.
. Strong experience to work in UNIX and Windows NT/95/98/2000
environment.
. Knowledge of version control, configuration management and Change
management procedures with related tools.
. Experience in working with HP suite of automated test tools such as
Quick Test Professional(QTP), Winrunner, Quality Center, Test Director
. Extensively Used Quality Center, Test Director to design Test cases
and report Bugs in Defect Module.
. Experience running Batch jobs in scheduling.
. Ability to work under strict deadlines.
. Ability to work independently or as a team Member.
. Excellent Communication and Management skills.
. Knowledge of Point of Sales related to retail Industry
Technical
Skills
Defect Tracking Tool HP Quality Center 9.2/9.0, MercuryTest Director, Clear
Quest, Bug Tracker
Automated Functional Win Runner, Quick Test Pro, Rational Robot, Rational
and Performance Requisite Pro, Test Manager, Silk Test, Load Runner,
Testing Tools Silk Performer.
Operating Systems Unix/Linux, Windows XP, Windows 2000, Windows NT 4.0 and
MVS (OS/390)
Application Servers Web logic 5.1/4.7, IBM Web Sphere, Oracle Web
Application Server, Java Web Server and IIS
Databases Oracle 10g/9i/8i, Sql Server,
Visual SourceSafe 6.0, MS Office, MS Access, MS Excel
Languages C#, Visual basic, C, Unix.
ERP SAP HR
Software Development Systems Analysis & Design, Software Quality Assurance
Methods
Educatio
n
Master in Business Administration
Post Graduate Diploma in Computer Application.
Jackson National Life Insurance, Atlanta, GA
Jan'09 -Till Date
Jackson National Life insurance is one of the largest insurance company
contains a module called Wholesaler marketing which allows customers and
registered brokers to order the insurance products coverage for different
types as Fixed Annuities, Fixed Index Annuity, Guaranteed Life, Mutual
Fund, Variable Annuities, Curian,Variable Life and Corporate. Broker and
Customer can login and order the required product as per his requirement
and get the final confirmation via shopping cart action instantly.
Role: QA analyst
Responsibilities:
. Tharoughly reviwed and Analyzed Business requirements,Functional
specifications and Design documents understand them completely.
. Involved in developing the Integration Test Plan and System Test Plan
based upon the functional specifications
. Developed high level Test scenario's and test data based on the
specifications.
. Developed Test cases based on the scenario's and specifications.
. Developed Test Strategy and Requirements Tractability Matrix (RTM) to
ensure adequate test coverage.
. Involved in Walk through of test plan, scenario's and test cases.
. Performed Black Box testing, Functional Testing, Unit testing,
Integration, System Testing & Database Testing.
. Generate and maintain SQL scripts for database testing.
. Tested the HTML pages for the business rules of the application
. Performed validation testing for each field in the application for
different scenarios.
. Work closely with users and program developers to ensure application
development meets to users expectation.
. Maintained detailed test logs and report test results in Quality
Center.
. Checking the Log files for bugs/issues root cause analysis and
reporting the problem areas to the concerned Developer.
. Etensively used Quality Center for reporting bugs, defect tracking and
analysis.
. Involved in Regression Testing using Win Runner, Quick Test Pro.
. Interface with developers to resolve technical issues and investigated
the bugs in the application
. Participated in project sync meetings during all phases of testing
Environment: Quality Center 9.2,QTP,Java/J2EE, JSP, HTML, Oracle 9i, SQL,
UNIX and Windows NT.
Ernst & Young, NJ
Sep '07 -Nov '08
Ernst & Young is a global leader in assurance, tax, transaction and
advisory services. Ernst & Young provides a range of services such as
Accounting and Auditing, Tax Advisory, Business Risk services, Technology
and Security Risk services, Transaction Advisory and Human Capital
Services. Responsibilities included testing an eDocs application built on
Documents that is designed to support and maintain complete and accurate
files for US Tax and TAS Tax engagements. Engagement personnel have
immediate access to the engagement files and documents, and can view or
edit them as needed
Role:QA Software Tester
Responsibilities:
. Developed and maintain test cases, test plans, project plans and
traceability matrix and ensure all documentation and test cases are
complete and comprehensive.
. Development and Execution of Test Cases using Mercury Quality Center
9.2.
. Developed Test Strategy and Requirements Tractability Matrix (RTM) to
ensure adequate test coverage.
. Coordinate with development team to understand their requirements and
timelines under strict deadlines.
. Prepared weekly status reports, metrics and slides for management
reporting
. Developed SQL Queries in Toad for SQL Server Utility for database
verification
. Performed End-to-End testing on various tax files such as Advisory,
Business, Corporate, Individual, and ROCA
. Created Advisory, Business, Corporate, Individual, and ROCA Tax Files
using eDocs -Webtop application
. Used Java/J2EE technologies along with Websphere and Web Services for
testing the application.
. Plan and Tested eDocs core functions such as Create Tax Files, Import,
Save, Check-in, Check-out, ACL, Core Team, Recycle Bin, Search,
Knowledge Properties, Close Tax File, Re-Open Tax File etc.
. Support Upper Management to estimate LOE of each project, Resolved
each project outstanding issue from each phase of SDLC phase.
. Involved in preparing programs and also writing SQL, PL/SQL using
TOAD.
. Developed Automation Scripts using parameterization for testing the
future releases of the application using QTP.
. Strong experience in automating the test using QTP and modifying the
script code using VB Script.
. Conducted System,UAT, Stress and Regression Testing Cycles &
logged/Documented Test Results
. Support production problem, assist production support team in staging
testing to understand process.
. Re-tested defects found under UAT, Functional, Integration,
Performance.
. Ability to prioritized difficult project with time line by maintaining
highest quality.
. Performed QA process Management, assist User and trained new hired and
standardized local testing procedure by developing QA hand book for
regression testing.
Environment: Mercury Quality Center, Java, QTP 9.0, Load Runner 9.0, Oracle
10g, Toad, Web Services, Web sphere, Documentum, Team Track
SunTrust Mortgage, Richmond, VA.
Jun '06- July'07
Description:
SunTrust Banks, Inc. is a financial holding company that through its
flagship subsidiary, SunTrust Bank, provides deposit, credit, trust and
investment services to a broad range of retail, business, and its
institutional clients. Additional subsidiaries provide credit cards,
mortgage banking, credit related insurance, asset management, brokerage,
equipment leasing and capital market services.
SunTrust Mortgage, Inc. is a wholly owned subsidiary of SunTrust Bank
offering residential mortgage products nationally through its retail,
broker and correspondent channels. These products are held in the Company's
residential loan portfolio or securitized and sold in the secondary market
with servicing rights retained. This line of business services loans for
its own residential mortgage portfolio, as well as for others.
Role: QA analyst
Responsibilities:
. Analyzed Business requirements, Process Change Requests and Test case
preparation.
. Created Testing Strategy and Test Plans for Integration Testing of all
affected business systems.
. Created and updated Test Plans, Test Cases and Test Procedures,
Regression Test specifications.
. Performed validation testing for each field in the application for
different scenarios.
. Performed extensive back- end testing.
. Created SQL queries for retrieving data from various Database schemas
as per requirement..
. Conducted database testing using TOAD and SQL Plus to query the
database, and validating the data in the various database instances.
. Checking the Log files for bugs/issues root cause analysis and
reporting the problem areas to the concerned Developer.
. Extensively used Quality Center for reporting bugs, defect tracking
and analysis.
. Reviewed existing Test cases to ensure that they are clearly Testable
and designed new Test Cases with developers/end users as well as
collate into overall test cases.
. Participated in the Acceptance testing of new functionality
implemented, including the preparation of test cases, test data,
reporting.
. Involved in Developing User acceptance Testing strategy and
participation in completion of UAT.
. Daily interaction with Business users for updation and modification in
the requirements and change the test cases to test the new features of
Mortgage.
. Analyzed specifications and Developed Test Cases for the enhancements
given as per the release.
. Involved in testing of environments to check the stability of
Environments for pre and post apply of various patches.
. Coordinated in Execution of Test Plans and Schedule including
environment setup.
. Resolved the Issues raised during User Acceptance Testing in Break-
Fix, QA (Quality Assurance) environment.
. Involved in Regression Testing using Win Runner, Quick Test Pro(QTP).
. Executed of Test cases using Winrunner to check the Product pricing
and eligibility rules avoiding the User Interface of system by
providing the test data, default data, decision engine to check the
eligibility for different products of Mortgage
. Reporting the failed test case data to Business users and application
developers to make the appropriate changes in the system till all the
eligibility norms are fulfilled.
. Consolidating test results and reporting the management for weekly
meetings.
. Attended regular project meetings and weekly team meeting to discuss
the project Milestones.
. Ensure that functionality, as defined in requirements, is the intended
behavior of the product.
. Perform actual testing after verifications are completed.
Environment: SQL, PL/SQL, Oracle 10g, XML, File Aid, SQL Server, Quality
Center 9.0, Winrunner,QTP, UNIX,, Windows NT/2000.
Next Telecommunication, Herndon, VA
Oct' 04 -Apr '06
Description:
Nextel Communications is nations leading provider fully integrated all
digital wireless services. The web application enabled customers to
interact online with various services provided through their web site.
Application was written in ASP using Oracle.
Role: QA Analyst
Responsibilities:
. Defined Test Objectives by studying the Software requirements
documents. Wrote Test Plans, Test strategy, Test Scenarios and Test
cases.
. Attended walkthroughs for reviewing the software requirements and Test
Plan proposal.
. Implemented CMM level 3 standard in all Phases of SDLC.
. Created Test Plans for the Sanity testing, Functionality testing,
System, Integration testing.
. Wrote test cases in Test Director for the Sanity, Regression,
Performance testing based on the high-level design documents and
Technical design documents.
. Executed the test cases and updated the test results in Test Director.
. Reported bugs in the Team Track after analyzing, interpreting the test
results.
. Proven analytical skills in executing any assigned task such as
creating Test case scenarios and using workarounds to test any given
functionality or defect.
. Conducted Sanity testing, Regression testing, System, Integration
testing of the various versions of Enabler.
. Executed JUnit Test cases as part of the white box testing.
. Performed extensive back- end testing.
. Conducted database testing using TOAD and SQL Plus to query the
database, and validating the data in the various database instances.
. Importing and exporting database tables using TOAD and SQL PLUS among
different database instances/schemas
. Checking the Log files for bugs/issues root cause analysis and
reporting the problem areas to the concerned Developer.
. Resolved open issues by coordinating with developers and client during
QA and UAT testing.
. Used XMLSPY to check the XML files in the database to investigate the
defects.
. Presenting daily status reports of the testing activities for the Day.
Environment: Unix-HP Oracle 9i, TOAD, SQLPLUS, XML, XMLSPY, Tivoli, Junit,
Quality Center 8.0, MS Excel.
Virichi Technologies, India
Sep'03 -Aug '04
Description: Qfund is an integrated Loan processing web-based application
that covers payday Loan processing in a payday loan company. This
application enables all the employees at various locations of the company
to carry out transactions on the web. Major functionalities other than Loan
procedures include customer registration, setting up locations and related
configurations, setting up security groups, rules and rule values, carrying
out core transactions like advance / loan, rollover, buyback, payments
etc., risk assessment integrating with Third party Risk Assessment agencies
like Teletrack, etc., cash management, employee maintenance, report
Generation, etc.
Role: QA Tester
Responsibilities:
. Defined Test Objectives by studying Software Requirement Documents.
. Wrote Test plans, Test strategy, Test scenarios and Test cases and
executed Test cases manually.
. Reported the bugs to Teal Lead and resolved the bugs in Bug tracker
. Performed extensive back- end testing.
. Conducted database testing using TOAD and SQL to query the database,
and validating the data in the various data base instances
. Executed the test cases and updated the test results in Bug tracker
. Checking the Log files for bugs/issues root cause analysis and
reporting the problem areas to the concerned Developer.
. Resolved open issues by coordinating with the concerned developers and
client during QA testing.
. Attended regular project meetings and weekly team meetings to discuss
the project milestones.
. Performed validation testing for each field in the application for
different scenarios
. Ensure that the functionality, as defined in requirements, is the
intend behavior of the product
. Performed actual testing after the verifications are completed
. Performed daily status reports of the testing activities for the Day
Environment: Java, EJB, JSP, JavaScript, JBoss, Oracle 9i, Toad, SQL,
HTML, MS Excel, Bug Tracker.