Rajeswari Desingurajan
Email: ***********@*****.***
Mobile: 231-***-****
Professional Summary
. Eight years of experience providing extensive support in tests
designing, tests development, tests enhancement and test execution of
Projects by using Automated and Manual Testing,
Functional/Regression/Integration /Accessibility testing and Web Based
testing methodologies (Domain : Banking Financial Services, Telecom &
Manufacturing).
. Formulated software development life cycle (SDLC) standards and
processes to measure the quality of product deliverables through Test
Matrices.
. Expertise in designing, developing and implementing scripts using
Quality Center and Test Link.
. Ability to perform extensive Data Warehousing Testing :Business Object
Xcelsius 2008 Dashboards - data Validation testing and analysis of
various modules and validating data in reports, data validation
between databases, end-end testing of data, data mapping, field
mappings and data warehouse testing/validation with Graphical User
Interface (GUI).
. Experience in Data warehousing Testing: ETL Tool - Informatica 8.6 to
validate the data.
. Good Experience in SAP6.0 Testing - SD.
. Good Experience in Agile environment and SCRUM
. Expertise in Test Processes, Test Coverage, Test Strategy, Test
Estimations, which help in decision making and Quality assessments.
. Expertise in developing Test Plans, Test Cases, Traceability Matrix
and analyzing Test Results, Experience in Setting up Test
Environments, Creating and managing Test Data for various phases of
testing.
. Expertise in Functionality Testing for the modules and conducted
Regression Testing during the various phases in Releases.
. Supported the production applications by analyzing and reproducing the
field issues.
. Extensive experience in preparing Test Plans, Test Cases in manual
testing for Web and Client-Server Applications.
. Extensively involved in Integration Testing, Regression Testing, Black
Box testing & UAT.
. Updating and Maintaining scripts - QTP 6.0.
. Proficient in testing/enhancing applications developed in Java,
J2EE,Apache, Tomcat, Web Sphere and also involved in Formal and Peer
Reviews, Walkthroughs and Inspections.
. Have demonstrated outstanding leadership, creative problem solving and
analytical skills in the areas of developing Testing functionality
incorporating assorted tools and worked with several groups across
multiple platforms.
Education
M.C.A. from Madurai Kamaraj University, India.
Certification
Certified IGATE Banking Certification Level - 1.
Professional Experience
Currently working as a Test Lead at Philip Morris USA, Richmond,
VA.
Technical Skills
Programming Languages C, C++, Java
Operating Systems Windows XP/2003/NT and Unix,
Test Reporting Tools Quality Center, Test Link, Team Track, Web
Defect Manager
Testing Tools WinRunner7.01, IBM Rational Functional
Tester, QTP
RDBMS Oracle 9i/10g, MS SQL Server, SQL Server
2000, Informix, MS Access and Teradata
GUI Java,J2ee Applications,Apache,Tomcat, Visual
Basic 6.0, Developer 2000
Web Technologies & CRM HTML, XML. SAP 6.0
Data warehousing Business Object Reports XI 3.1, Xcelsius
2008, and ETLTool - Informatica8.6.
Project Profiles
Project : CATMAN Phase II
Client : Philip Morris USA, Richmond, VA
Duration: Nov 2010 - Till date
Role : QA Lead
Description:
This Project is to Execute CATMAN Phase II enhancements for Altria Sales &
Distribution, using SAP Business Objects xcelsius 2008 to validate the
Dashboards. Designed test plans and defined Test Scenarios, Test cases for
Functional, Integration, System, and User acceptance Testing. The Objective
of this project is to develop and deploy enhancements and additional
resources to the new category management reporting system (CATMAN) that
incorporates multiple Tobacco categories to the ALS&D Field sales Force.
Roles and Responsibilities:
V Responsible for Reviewing the Requirements
V Create Detailed Test Plan, Test Scenarios, Test cases and Traceability
Matrix.
V Produced Estimation for the Project.
V Adept at using Data validation Tool to validate the Xcelsius
Dashboards using Business Objects Reports.
V Generating the Business Object Reports and validating the data display
in Reports.
V Involved in daily SCRUM Meeting - Agile Environment
V Performed Backend testing to validate the data using web Intelligence
Reports, Tera data, and added SQL queries to the required Test cases.
V Involved in reviewing and reworking on the test cases
V Set up Test Environment and Test data for various user logins and Test
configuration management.
V Performed full cycle testing of Web interfaces, GUI Testing,
Functionality Testing, Integration, System and Regression Testing,
UAT.
V Prioritizing, Tracking and Verification of bugs.
V Used Quality Center 9.0 for reporting and tracking Defects, and
providing updates on resolved defects.
V Attended weekly defect report meetings and presented progress updates.
V Provided a weekly project report that includes Test Metrics and status
reports.
V Liaise with System Manager, Project Manager, and Component Manager to
identify the Risk, issues and Action to be taken.
Environment: Business Objects Enterprise XI 3.1, Xcelsius 2008, Tera data
SQL Assistant 12.0, and Quality Center 9.0.
Project : Freight Consolidation
Client : Philip Morris USA, Richmond, VA
Duration : June 2010 - Nov 2010
Role : Test Analyst & UAT
Description:
This project is to enable ALS&D to pay freight charges on
finished goods for the manufacturing operating companies via SAP ERS. Pay
all finished goods freight out of company code and accurately chargeback
freight costs to the designated manufacturing operating companies.
Execute the freight payment process & Warehouse handling
charges for USSTB will be paid by SAP 6.0 autopay .consolidate freight
shipments to be paid by ALS&D via SAP6.0 autopay that are in the JDE and
SAP 6.0 Systems.
Roles and Responsibilities:
V Testing the fixes on the test system before pushing them into the
production system.
V Smoke testing the Production system after the maintenance activities.
V Developed Feature Test Plans, Test Strategy, and Test Cases from
technical and functional requirement specifications.
V Performed full cycle testing of Web interfaces, GUI Testing,
Functionality Testing, Performance & Stress Testing, System &
Regression Testing, and Integration Testing and UAT.
V Create Detailed UAT Test Plan and Test Approach document.
V Reproducing the issues on the test system that were reported by the
end user and help the development team in finding the root cause of
the issues.
V Creating and Maintaining Test cases at Quality Center.
V Mapped the Traceability matrix.
V Communication with various stakeholders
V Recording the Test Results and Log the Defects at Quality Center
V Prioritizing, Tracking and Verification of Defects.
V Communicate with Development team to fixing the Defects
V Conducting the Session for Quality Center process to Business Team
Environment: SAP 6.0, Quality Center9.0, Oracle 10g.
Project : Corporate Work Bench
Client : Royal Bank of Canada
Duration : May 2009 - Jun 2010
Role : Test Lead
Description:
The DOS Migration, CWB initiative comprises of 4 modules (Business
Banking Transaction Request, Collateral Security Monitoring, Client
Activities and Calls History), these modules mainly deals with the credit
processing.
Business Banking Transaction Request (BBTR): This module is
exclusively designed for the Account Managers (AM), Risk Managers (RM) and
Business Service Center (BSC). This module allows the account managers to
create a new Business Banking Transaction Request with the details provided
by the client and forward the Business Banking Transaction Request to the
next level of processing i.e. to the Risk Manager or to the Business
Service Center for the credit approval.
Client Activities: This module is used by Account / Risk managers, for
creating to-do and appointments for a particular client.
Calls History: This module is used by Account / Risk managers, to
trace the action items for every call happened with the client.
Roles and Responsibilities:
V Preparation & review of test cases based on the business requirements
document.
V Perform functionality testing and user interface testing,
accessibility testing (Screen Reader) based on requirements
specification document.
V Interaction with the development team in regards to functionality
clarification, bugs and general feedback.
V Create Detailed Test Plan and Test Completion Report document.
V To resolve any queries from Development team.
V Produced Estimation for the Project.
V Test Environment and Test configuration management
V Involved in reviewing the test cases
V Mapped the Traceability matrix for the Audit purpose.
V Communication with various stakeholders
V Prioritizing, Tracking and Verification of bugs.
V Sharing functional and testing knowledge with other team members in
knowledge sharing sessions.
V Performed full cycle testing of Web interfaces, GUI Testing,
Functionality Testing, Performance & Stress Testing, System &
Regression Testing, and Integration Testing and UAT.
V Updating and maintaining QTP Scripts for Call Reports and Business
Transaction Request as when required.
V Clarifying queries and mentoring the team for various module support
in application.
Environment: Java, J2ee, Apache, Tomact, Quality Center/Test Director,
Oracle 10g and Windows XP, QTP 6.0.
Project : Priority Web Online System & Mobile
Banking
Client : Union Bank, CA
Duration : March 2008 - April 2009
Role : Test Lead
Description
Union Bank of California (UBOC) is one of the nation's
leading commercial banks in online banking. The rising trend in online
banking is attributable to two major factors. The first is that as internet
users gain experience online, they are more likely to perform activities
that involve money, such as making online payments, purchases and travel
reservations, etc. The second factor is that online banking customers are
more profitable than offline customers not only because they have high
incomes and attractive long-term prospects but they are also at an age when
they are heavy users of a financial institution's most lucrative products,
such as mortgages and auto loans. As a result, banks have become more
aggressive in offering online services as an option (often times free of
charge) while at the same time investing time, money and resource to
improve their online services for customer retention, customer service, as
well as to potentially gain a bigger market share. In Mobile banking all
online transactions: Bill Payment, Funds Transfers, Custromer service and
Account summary actions are performed.
Roles and Responsibilities:
V Responsible for Reviewing and frizzing the Requirements
V Create Detailed Test Plan and Test Completion Report document.
V Produced Estimation for the Project.
V Involved in reviewing and reworking on the test cases
V Test Environment and Test configuration management
V Involved in reviewing the test cases
V Mapped the Traceability matrix for the Audit purpose.
V Performed full cycle testing of Web interfaces, GUI Testing,
Functionality Testing, Performance & Stress Testing, System &
Regression Testing, and Integration Testing and UAT.
V Prioritizing, Tracking and Verification of bugs.
V Updating and maintaining the QTP Scripts for Priority user lists
Environment:Java,Apache,Tomcat,Test Director, Unix, SQL,Oracle8i, Java,
Toad, MS SQL Server, HTML, XML, Windows NT/2000,QTP 6.0
Project : Integrated Credit Reporting System
Client : Union Bank of California
Duration : Jan 2007 - Feb 2008
Role : QA Analyst & Onsite Coordinator
Description:
ICRS gives the bank greater ability to analyze credit data
(events, balances, etc.) by customer, loan, etc. The goal is for the bank's
executives, managers and decision-makers to have greater insight into our
customer base so that proactive actions can be taken to increase retention
of desirable customers and increase revenue beyond what would naturally
occur. Integrated Credit Reporting System, commonly know as ICRS.
This subject area caters to providing the credit summary reports that
are of interest to the senior management. ICRS interacts with other
subject areas viz., CDW (the Warehouse), ARC & BRC systems. The Primary
users of the ICRS are the CPIS. ICRS primarily retrieves data from the
Warehouse (CDW). ICRS system is well integrated with ARC & BRC systems for
credit reconciliation & verification of the same.
Roles and Responsibilities:
V Responsible for Reviewing and frizzing the Requirements.
V Validating the data using ETL Tool - Informatica8.6 and applying the
Data Quality Factors and Transformation Rules.
V Validating the Data, once data migrated to Data mart / EDW.
V Generating the Business Object Report and validating the data display
in Reports.
V Involved in CR - Change Request Enhancements for BO Reports and ETL
Data Issues.
V Improved the process and procedures, to effectively raise the
utilization of the team.
V Create Detailed Test Plan and Test Completion Report document.
V To resolve any queries from offshore testing team.
V Produced Estimation for the Project.
V Creation of Release tracker & Progress Tracking
V Test Environment and Test configuration management
V Involved in reviewing the test cases
V Mapped the Traceability matrix for the Audit purpose.
V Liaise with System Manager, Project Manager, and Component Manager to
identify the Risk, issues and Action to be taken.
V Communication with various stakeholders
V Prioritizing, Tracking and Verification of bugs.
Environment: ETL Tool - Informatica 8.6, Quality Center, Unix, SQL, PL/SQL,
Oracle8i, Toad, MS SQL Server, Windows NT/2000.
Project : Expense Management System
Client : JP-Morgan Chase
Duration : Feb 06 - Dec 06
Role : Senior QA
Work Location : Bangalore
Description
EMS provides you with the tools and knowledge necessary
for managing telecommunications and information resources. EMS offers a
comprehensive package of integrated modules that share data files, request
for services, allow organizations to track inventory, productivity and
manage telecommunications cost without relying on multiple systems or
databases.
Centralized user provisioning allows data access rights to be
set by user at the field level. Reports can be viewed in a variety of
formats, such as HTML, PDF, and Microsoft Excel, CSV & Tab Delimited
formats, and users can schedule reports for secure distribution to any
destination. EMS collects information on voice and data transactions,
applies cost elements to each transaction, charges the cost back to the
appropriate internal or external department/group, and provides Web-based
access to business operation and telecom infrastructure analysis.
Roles and Responsibilities
V Design and Development the plan
V Involved in ETL process to transformation and loading of data from
various data sources
V Performed detailed source to target mapping, transformations rule
identification using source qualifier, expression, filter, aggregator,
rank, update strategy, lookup (connected & unconnected lookups),
stored procedure, sequence generator and joiner transformations
V Performed full cycle testing of Web interfaces, GUI Testing,
Functionality Testing, Performance & Stress Testing, System &
Regression Testing, and Integration Testing and UAT.
V Reports were generated using Business Objects according to the client
requirements Generation of daily, weekly and monthly reports.
V Implemented proper Security of Repository by creating user groups,
users, privileges and short cut folders
V Created drill thru access to link reports each other
V Involved in Data Cleansing,Data Verification, Data Validation,
Removing Redundancy and duplicate data from the system
V Testing the reports against data.
Environment: Java, Apache, Tomact, Test Director, UNIX, SQL, Oracle8i,
Toad, MS SQL Server, HTML, XML, Windows NT/2000.
Project : Client Conversion
Client : Pemco Insurance Corporation
Duration : Jan 05 - Jan 06
Role : Tester
Work Location : Bangalore
Description:
PMS system is the current system, which PEMCO uses for its
Insurance business. PMS has Mainframes Interface as front-end and compact
VSAM (Virtual Storage Access Method) files at Backend. And now Exceed
System is the Web based system with DB2 at backend, is planned to replace
the existing PMS system. To accomplish this migration is planned in a
series of steps. In phase 1 all the Client related data from the existing
PMS system is converted into Exceed System which is known as Client
Conversion.
All Client Demographic information from the PMIC needs to
be converted to the Client tables in Exceed DB2 Enterprise database. The
Client Conversion process converts all Client information, both individual
and business.
Roles and Responsibilities
V Worked as a member of a QA Team, responsible for testing the
application.
V Analyzed Test Cases, Developed Test Plans based on Testing
Requirements.
V Reviewed the complete Testing against the defined evaluation
criteria.
V Involved in Black Box, system, stress testing based on functional.
V Conducted the Functional, System, Regression, UAT and Performance
Tests of the client server.
V Created and Executed both Manual test cases
V Prepare Status Reports Every Week, which includes Revision History,
Test case status, metrics, QA Issues and Defects.
Environment: SQL Server, Visual Basic, Windows 2000, Manual Testing.
Project : Activity Scheduling and Activity Tracking
System (ASATS)
Client : ITI Limited, (Bangalore)
Duration : Jun 03 - Dec 04
Role : Tester
Work Location : Bangalore
Description:
This project is intended to make scheduling of projects
easier and have a track of the day-to-day project activities. As and when
an employee joins the organization, all details about the employee are
entered into the system. The project leaders have the privileges, to
create, modify or delete projects. The project leader, while creating a new
project can assign members to the team and fix up their responsibilities.
This project can be further scheduled, like the date on which it should be
kicked off, the expected date of completion, etc. Further, the activity
tracking system plays an important role to identify whether the project is
going on as per plan or whether there is any deviation. Each and every
detail about the proceeding of the project and the daily activities of the
members are entered into the system, which will be much of help, for the
project to move in the right direction.
Roles and Responsibilities:
V Manual and Automated Testing
V Prepare Test cases and executing it
V Functionality and Regression Testing.
V To create automation script for GUI, database check and Functionality
testing using Win Runner and verifying it.
V Analyzing Test Results and Preparing bug report on Test Director 5.0
Environment: SQL Server, Visual Basic, Windows 2000, Manual Testing.