Rajeswari Desingarajan
Email: ****************@*****.***
Mobile: 231-***-****
Professional Summary:
Having Twelve plus years of experience in business areas of Finance, Telecom and Manufacturing.
Having Extensive experience mainly emphasizing on Quality Assurance, Testing and Test Automation in Client/Server, Web-based Applications, PeopleSoft and Legacy System (Mainframes) using structured Methodologies.
Complete knowledge of all phases in the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
Experience in testing methodologies which includes, test plan development, test case development, test case execution, test results analysis, and defect reporting, that application processing complies with business and technical specifications
Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using HP ALM and Quality Center.
Extensive experience in Database Testing in Oracle using SQL.
Experience in design and implementation of automation frameworks (keyword driven frame work, hybrid framework) using QTP.
Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and Regression Testing.
Ability to perform extensive Data Warehousing :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).
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.
Good experience in Onsite-offshore model.
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.
Technical Skills
Functional Testing & Environments
DWH, Client Server, Web Based, PeopleSoft environments with Oracle, SQL and DB2 as Databases.
Automated Testing & Tools
Win Runner, QTP, Silk Test, Test Director and HP Quality Center and ALM.
DW Tools
Informatica Power Center 7.1, Data Stage, Business Object Reports XI 3.1,Xcelsius 2008
Management tools &
Languages
MS Project, Rational Clear Case / Quest, Visual Source Safe, C++, VC ++, Java, J2EE, Java Script, ASP, HTML, COBOL
Operating Systems
Unix, WIN XP/NT and MVS/ESA
Database Query Tools
TOAD, WinSQL,
Education: Master of Computer Application (MCA).
Experience Highlights
CITI Group, Long Island City, NY Sept 2011 to Till Date
Role: QA Lead
Project : CITI Trust Platform (CTP)
Description:
Citi Trust provides fiduciary services to various clients across the globe. Client On-boarding is one of the important activities in the chain of entire process life cycle. In order to address current pain areas like movement of physical paper across various groups, data quality with redundant details, more time to complete on-boarding process etc., it is required to develop automated solution through centralized, multi-user, secure, reliable and user-friendly system. Flexible workflows facilitating effective and efficient processes will play key role during solution designing. We as a IST team is responsible to test the functionality of system in all possible ways to make sure that the system is meeting the client requirements with quality.
Responsibilities:
Close interaction with Business Team to understand all business requirements for CTP.
Preparation of test strategy by foreseeing and Mitigating the Project Risks on time
Coordination with development and support team in order to resolve application issues
Coordinate client expectations to the offshore team and mentor offshore team to provide best testing solution for client needs. Attending teleconference calls with the offshore team
Prepared the scope and Estimation of Efforts for end to end testing.
Designing and executing the functional test cases
Execution of the sanity, functional and regression test scripts
Logging the defects and tracking the same till closure in HP ALM (QC)
Reporting the Project status to all stakeholders on daily and weekly basis using robust
Executed test cases manually to test Java applications as part of Functional testing activity.
Tested web base and UI applications extensively using QTP automation scripts for field validation and for broken Links.
Conduct QA review and walkthrough sessions with Testing team
Analyze errors and identify cause.
Used HP ALM to track and report system defects and bug fixes.
Coordinated with the Developers for Bug Fixing.
Participated in Audit programme
Philip Morris USA, Richmond, VA Nov-2010 to Sep-2011
Sr. 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:
Responsible for Reviewing the Requirements
Create Detailed Test Plan, Test Scenarios, Test cases and Traceability Matrix.
Adept at using Data validation Tool to validate the Xcelsius Dashboards using BO Reports.
Involved in daily SCRUM Meeting – Agile Environment
Performed Backend testing to validate the data using web Intelligence Reports, Tera data, and added SQL queries to the required Test cases.
Set up Test Environment for various user logins and Test configuration management.
Performed full cycle testing of Web interfaces, GUI Testing, Functionality Testing, Integration, System and Regression Testing.
Used Quality Center 9.0 for reporting and tracking Defects, and providing updates on resolved defects.
Attended weekly defect report meetings and presented progress updates.
Provided a weekly project report that includes Test Metrics and status reports.
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.
Philip Morris USA, Richmond, VA Jun-2010 to Nov-2010
Sr. QA Lead
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:
Testing the fixes on the test system before pushing them into the production system.
Smoke testing the Production system after the maintenance activities.
Performed full cycle testing of Web interfaces, GUI Testing, Functionality Testing, Performance & Stress Testing, System & Regression Testing, and Integration Testing.
Create Detailed UAT Test Plan and Test Approach document.
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.
Creating and Maintaining Test cases at Quality Center.
Recording the Test Results and Log the Defects at Quality Center
Prioritizing, Tracking and Verification of Defects.
Environment: SAP 6.0, Quality Center/Test Director, Oracle 10g.
Royal Bank of Canada May-2009 to Jun-2010
QA 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:
Preparation & review of test cases based on the business requirements document.
Perform functionality testing and user interface testing based on requirements specification document.
Interaction with the development team in regards to functionality clarification, bugs and general feedback.
Create Detailed Test Plan and Test Completion Report document.
Mapped the Traceability matrix for the Audit purpose.
Communication with various stakeholders
Environment: Java, J2ee, Apache, Tomcat, Quality Center/Test Director, Oracle 10g and Windows XP.
Union Bank, CA Mar -2008 to Apr-2009
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.
Roles and Responsibilities:
Responsible for Reviewing and frizzing the Requirements
Create Detailed Test Plan and Test Completion Report document.
Produced Estimation for the Project.
Involved in reviewing and reworking on the test cases
Test Environment and Test configuration management
Involved in reviewing the test cases
Mapped the Traceability matrix for the Audit purpose.
Liaise with System Manager, Project Manager, and Component Manager to identify the Risk, issues and Action to be taken.
Environment:Java,Apache,Tomcat,Test Director, Unix, SQL,Oracle8i, Java, Toad, MS SQL Server, HTML, XML, Windows NT/2000.
Union Bank of California, CA Jan -2007 to Feb-2008
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 known 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:
Responsible for Reviewing and frizzing the Requirements
Improved the process and procedures, to effectively raise the utilization of the team.
Create Detailed Test Plan and Test Completion Report document.
Mapped the Traceability matrix for the Audit purpose.
Liaise with System Manager, Project Manager, and Component Manager to identify the Risk, issues and Action to be taken.
Communication with various stakeholders
Prioritizing, Tracking and Verification of bugs.
Environment: Win Runner, Test Director, UNIX, SQL, PL/SQL, Oracle8i, Java, Toad, MS SQL Server, HTML, XML, Windows NT/2000.
JP-Morgan Chase: EMS System Feb-2006 to Dec -2006
IGATE Global Solutions, Bangalore
Senior QA
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
Involved in ETL process to transformation and loading of data from various data sources
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
Reports were generated using Business Objects according to the client requirements Generation of daily, weekly and monthly reports.
Implemented proper Security of Repository by creating user groups, users, privileges and short cut folders
Involved in Data Cleansing,Data Verification, Data Validation, Removing Redundancy and duplicate data from the system
Environment: Java, Apache, Tomcat, Test Director, UNIX, SQL, Oracle8i, Toad, MS SQL Server, HTML, XML, Windows NT/2000.
Pemco Insurance Corporation, PMS System Jan-2005 to Jan-2006
IGATE Global Solutions Pvt., Ltd., Bangalore, India
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
Worked as a member of a QA Team, responsible for testing the application.
Analyzed Test Cases, Developed Test Plans based on Testing Requirements.
Reviewed the complete Testing against the defined evaluation criteria.
Involved in Black Box, system, stress testing based on functional.
Conducted the Functional, System, Regression, UAT and Performance Tests of the client server.
Created and Executed both Manual test cases
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.