Sangeetha P.S

acwmge@r.postjobfree.com

719-***-**** (Mobile)

Summary

. Around 10 years of IT experience as software tester and developer

. Extensive knowledge in Software Development Life Cycle (SDLC), Software

Testing Life Cycle (STLC)

. Experience in all phases of software testing life cycle, including

Requirements gathering, Planning, Scheduling, Testing, Defect Tracking,

Management and Reporting

. Good experience in HP Quality Center and Test Director

. Proficient in developing Test Plans, Test Scripts, Test Designs and Test

Coverage Matrices.

. Expertise in web based and Mainframe testing

. Experience in performing Mainframe, System, User Acceptance,

Integration, GUI, Database, Smoke and Regression testing

. Extensively worked on backend testing and strong knowledge of writing

and executing SQL queries to verify the data

. Extensively used HP Quality Centre for Test Planning, Test Execution,

Defect tracking and Test Evaluation

. Extensive experience in mainframe technologies - COBOL, DB2, JCL,VSAM,

CICS, PL/1, IMS DB/DC etc

. Ability to interact with developers and BAs regarding testing status.

. Expertise in Problem solving and Tracking Bug Reports using various Bug

tracking Tools.

. Exposure to different operating systems like Windows 95/98/00 and NT and

OS/390

. Responsible for mentoring resources technically and training other QA

Team Members. .

. Strong Problem analysis and resolution skills

. Good communication and interpersonal skills.

. Worked in Insurance and Investment Banking domains

. Worked for T Rowe Price, CO

. Worked for insurance major companies USAA and Thrivent Financial for

Lutherans

. Worked for Brokerage and advisory department of Deutsche Bank, Germany

. IBM Certified Database Associate - DB2 Universal Database V8.1

Family

. Passed INS21 exam in Property and Causality insurance by AICPCU

Technical Skills

Testing Tools Quality Center, QTP

Defect Tracking Quality Center, Jira

Tools

Web technologies HTML,VB Script

Databases Oracle, DB2, MS Access

Programming SQL,COBOL,JCL,PL/1, Core Java, C++, VC++

Languages

Operating Systems Windows 7, XP/NT, OS/390

Documentation MS Office utilities and Adobe Acrobat

Tools

Professional Summary

. Worked as a Consultant in FedEx, CO

. Worked as a Consultant in T Rowe Price, CO

. Worked as a Consultant in USAA, TX

. Worked as Senior Quality Analyst in HCL Technologies, Chennai

Awards

. Received award for outstanding performance in DB-BASA project

. Received award of excellence for outstanding performance from USAA

Education

Bachelor of Engineering (Information Technology), Manonmaniam Sundaranar

University, Tamil Nadu, 2003, First class with Distinction with an

aggregate of 77.6%.

Major Project Assignments:

Jan '15- Sep '15 FedEx, CO

Position Quality Analyst

Environment: Java, XML, Oracle, QTP

Application - Supply Chain

Manage Critical Inventory logistics across stocking locations

Responsibilities:

. To help evaluate set QA process around the System and UAT test phase.

. Actively participate in the Requirement and Design sessions with the

business and development team

. Responsible for Understanding the scope of each release and

Identifying possible test scenarios

. Automated testing using QTP

. Testing of reports by comparison on source and target system data

. Functional testing of the Warehouse management application

. Test case execution and Defect reporting using ALM.

. Creation of Test plan, Test Metrics test case execution and defect

reports

. Responsible for smooth execution of QA system test phase and UAT

handover to the business team

. Test case review and test case execution. Publish daily defect report

using ALM and JIRA

. Assist the business users during the UAT testing phase.

. Post production smoke test execution

Feb '14- Nov '15 T Rowe Price, CO

Position IT Analyst

Environment: z/OS, VS COBOL II, DB2, JCL, VSAM, MVS TSO/ISPF, SPUFI

Application - Retirement Plan Services

T. Rowe Price is a global investment management firm. The Retirement Plan

service of TRP has lot of custom process for different clients. In order to

make the system generic and to reduce the operation costs, TRP is making

architectural level changes to the RPS system.

Responsibilities

. Research on different plans mainly in the eligibility, maintenance and

contribution sides

. Making program/JCL updates whenever there is gap between business and

IT system

. Coding of new programs/ modification of existing programs

. Performing Unit testing by creating Unit test plan

. Performing Integration Testing by creating Integration Test plan

. System testing support

. Production implementation

Apr'10 -APR '11 USAA (United States Automobile Association), San Antonio,

TX

Position Quality Analyst

Environment: J2EE, Struts, EJB, Oracle, Quality Center, MS Office

Application Wealth Management

The United Services Automobile Association (USAA) is a Texas-based Fortune

500 diversified financial services group of companies including a Texas

Department of Insurance regulated reciprocal inter-insurance exchange and

subsidiaries offering banking, investing, and insurance to people and

families that serve, or served, in the United States military

Financial Crimes Enforcement Network (FinCEN) has included mutual funds in

rules for the Bank Secrecy Act (BSA) on the filing of Currency transaction

Reports (CTR). Mutual funds must meet requirements of creation and

retention of records when transmitting funds to other financial

institutions in the payment chain under the Travel Rule. Mutual funds will

be subject to Travel Rule and other related record keeping requirements.

This project implemented the capability to transmit and store required data

elements when initiating mutual funds transmittals with other financial

institutions.

Responsibilities

. Involved in gathering Business specifications from Business Analyst.

. Analyzed the user/business requirements, use cases and functional

specs documents.

. Created detailed Test Cases in the Quality Center.

. Performed Integration Testing on all system components and internal

and external interfaces to validate all the system components

interfaces with each other modules.

. Involved in Functional testing and Regression testing.

. Performed Smoke testing for each build.

. Created and executed SQL statements to extract data from tables and

verify output.

. Executed the Test Cases and reported the defects in QC.

. Generated Defects Reports, tracking the status of each defect (New,

Open, Fixed and Failed) and analyzing the defect.

. Interacting with developers to resolve issues regarding defects.

. Manually conducted cross-browser testing.

. Tested broken links, navigation, forms and other web content.

Oct' 07 - Mar '10 Deutsche Bank, Germany

Position Programmer Analyst

Environment: COBOL, CICS, JCL, VSAM, DB2

Application: BASA (Brokerage and Advisory)

Deutsche Bank is a leading bank providing financial solutions for private

and business clients. The products are global equities, foreign exchange,

fixed income, commodities, corporate finance, trust and security services,

global trade finance, global cash management, asset financing and leasing,

private wealth management, DB real estate etc.

IAS (Investment and Shares Savings Schemes) is Brokerage and Advisory

system of DB. The main objective of the project is to provide RTB and CTB

services to IAS System.

Responsibilities

. Preparation/ modification of technical design documents.

. Execution of enhancement projects

. Level 3 support and bug fixing

. Coding

. Performing Unit testing by creating Unit test plan

. Performing Integration Testing by creating Integration Test plan

. System testing support

Jun' 05 - Sep' 07 USAA (United States Automobile Association), San

Antonio, TX

Position Quality Analyst

Environment J2EE, Struts, EJB, Oracle, HTML, AJAX, Websphere, Quality

Center.

Application Home owners Insurance

USAA a fortune 500 Company, with a working strength of 20,000 plus is one

of the leading Property and Casualty Insurance Company serving the US

Defense Personnel and their dependents in the US and abroad, and is a

leading provider of Life Insurance, Financial and Banking service. The

Company is in the process of doing regulatory and non -regulatory business

changes to its existing system due to changes in law specific to the states

in US. On addition to that they have regular maintenance and enhancement

support activity going on regular basis.

This project is to increase the number of Homeowners tiers and make changes

to the criteria used in USAA's tiering model. The new tier placement

criteria will include introducing new factors (for example Age of home,

corporate tenure and weather and non-weather losses etc.) and new rules in

tier derivation. These new factors and rules will make the homeowner's

policies to get a more appropriate rate for each risk so that policies can

be rated with more appropriate premiums.

Responsibilities

. Coordinated with development teams to gather testing requirements and

prepared test plans

. Created detailed Test Cases using Quality Center

. Involved in review of Test plan and Test objectives with the solution

design team

. Involved in defect tracking and assigning the defects to the

respective development team

. Executed SQL queries against Oracle & SQL Server to test the data in

the Back-end, designed test plans and defined cases for functional,

integration system, and user acceptance testing

. Attended weekly defect report meetings and presented progress updates

. Performed Smoke testing for each build

Nov'04 - MAY' 05 USAA (United States Automobile Association), San

Antonio, TX

Position: Programmer

Environment: COBOL, PL/1, JCL, CICS, IMS, DB2, HCLT inventory and

impact analysis tools, File-Aid, BTS

Application: Claims System

USAA's Employee ID is an identifier field composed of 5 digits used in a

vast number of applications, spanning many technologies and environments

including web-based applications, mainframe applications, client server

software, and desktop applications. USAA anticipated that by early 2008, it

will exhaust the current sequence of available unique Employee IDs.

To address this problem USAA has decided to convert the Employee ID format

from 5 numeric digits to 5 alphanumeric characters. All those applications,

which utilize the Employee ID, is converted to this new format

Responsibilities

. Inventory Analysis using HCLT tool

. Impact Analysis using HCLT tool

. Impact analysis of DB2 and IMS databases

. Conversion of fields for impacted programs, files, JCLs and copybooks

. Unit Testing

. Integration Testing

. System Testing

. Production Implementation Support

Sep' 03 - Oct ' 04 Thrivent Financial for Lutherans, USA

Position Programmer

Environment MVS/ESA, Windows NT, CICS, DB2, JCL, COBOL, File Manager,

Panvalet, Xpeditor

Application Finance on Integration

Thrivent Financial for Lutherans is the result of a merger of Lutheran

Brotherhood and Aid Association for Lutherans. AAL/LB is the largest

fraternal benefit society in the United States. Because of the Merger, many

systems had to be consolidated and rebuilt. The scope of the Project is

to develop new programs and modify existing programs for merging their

financial operations. The Project involves removal of redundant system and

integrating the Finance operations related to premium payment. This project

allowed Thrivent to achieve significant benefits through reducing costs,

eliminating redundancies, improving cross-marketing opportunities, and

increasing quality through adoption of the best practices of both

organizations. Integration of the premium processing, accounting and

reporting areas.

Technical requirements:

Integration of the premium processing, accounting and reporting areas

Consolidating all suspense processing within one system from the current

systems

Consolidating all General Ledger within one system. Thus addressing

internal control concerns and potential audit exposures, apart from

improved reporting

. Apply lean manufacturing concepts within the service operations

through process and technology optimization, thereby reducing costs,

improving quality and eliminating redundancy

. Moving toward providing a single Thrivent Financial "face" to the

customer without distinction to the originating company (LB or AAL).

This should be seamless as the organizations are run out of two

locations

Responsibilities

. Preparation of Low Level Design

. Coding

. Preparation of Unit Test Plan

. Unit Testing

. Integration testing

Contact this candidate