Life Insurance Service

Email Id: *********.*********@*****.***

Praveen. A Mobile No: +91-967*******

Having 11+ Years of experience in Mainframe Development and Mainframe Testing.

Part of independent test group involved in designing, developing and executing test cases.

Extensive experience in Manual, Database, Mainframe and Automation Testing.

Extensive involvement in Application Functional, Regression, System Testing

Experience in Mainframe Application development.

Knowledge of Banking, finance, insurance and Retail domain’s.

Good Experience in Ad-hoc testing

Exposure to Agile Methodology.

Experience on product testing

Experience in ETL Testing

Experience in conducting Test case Reviews.

Good experience in using Mainframe Testing tools

Involved in preparation of test summary and execution reports

Good knowledge in preparation of Traceability matrix to identify missing test cases

Ability to develop test scenarios in different stages of testing.

Hands on Experience with Unix testing

Experienced in using various Defect Tracking Tools and Defect reporting and Tracking

Experience on Mercury Quality Center

Experience with QTP /UFT tool

Good Query knowledge in SQL statements.

Good communication and interpersonal skills

Mentoring resources and Team Handling.

Working as Sr. QA Analyst COBOL/DB2 for Delta, Hyderabad from July 2014 to till date.

Worked as Mainframe Associate for JPMORGAN, Mumbai from May2011 to Nov 2013.

Worked as Mainframe Sr Tester for ZENSAR Technologies pvt ltd, PUNE from Dec2009 toApril2011.

Worked as Mainframe QA for TIETO Software Technologies pvt ltd, PUNE from Dec2008 to August 2009.

Worked as Software Engineer for CYBAGE Software pvt Ltd, PUNE from Jan2007 to Dec 2008.

Worked as Software Engineer for IBM, pune from June-2004 To Dec 2006

Examination

Board/University

Year

MCA

Dr. BAMU- Aurangabad(MH)

2004

Operating systems

MVS/ESA, OS/390

IBM Mainframes

Cobol, JCL, VSAM, CICS,Rexx

Database

DB2

Tools

TSO/ISPF, Smart test, Spufi, QMF,ENDEVOR, FILE-AID, OPC scheduler,,DB2-FileAid, File Manager and XPEDITOR, Change Man, Road Runner and job Scheduler and Manage now

Operating systems

Windows, Unix, Linux

Programming Languages

C, C++ and Java

Database

Oracle, Sql Server 200, and Mysql

Web Technologies

ASP.net, VB.net and PHP

Package

MS office

Testing

Manual and QTP/UFT

Testing Tools

Mercury Quality Center, Test Director & QTP

Mainframe Level 1 Certification internal JPMorgan

CSQM - Certified Software Quality Manager

Certified tester from Testing Sense Board.

QA-Lead Certified from Technology University recognized by many MNC’s.

Testing Certified from Brain bench.

MCP certified from Microsoft

PGDCA certified from IAST

IBM mainframes from Florida institute.

Thorough knowledge of all phases of job, Quick adaptation to technical and analytical processes. Volume of work above performance expectations, allowing time to cross train and move into other functions. Greatest strength is willingness and ability to learn new functions. Made use of spare time for self-improvement.

Project 1

Billing -APS

Type

Development - Business Applications

Employer

Delta Technologies pvt Ltd, Hyderabad

Client

APS,Arizona

Platform

IBM-Mainframe

Software

COBOL, JCL, VSAM, QMF, File-Aid,DB2, TFS

Domain

Energy

Description

The CIS Billing module provides the ability to select the services to be charged to the customer, process them based on predefined service plans and contracts, generate charges at the service account level, and produce a billing statement for each customer account. In general any utility customer will get billed on 3 parameters. The first parameter is Kwh usage, Second parameter is KW usage and Third parameter being flat rate per day. Customer can also billed as bundle rate or as unbundle rate. The main functions of Billing System are Select accounts for Billing by Cycle, Determine the consumption for each Service Account, Calculate consumption, charges based on service plan rates, taxes, and contract obligations,Produce Billing Exceptions to flag abnormal usage patterns, Format and generate a Customer Account Statement for each active CA in the system Maintain the Customer’s Billing History, Print a duplicate Customer Account Statement if requested and Generate Revenue Statistic Reports. APS generates bill for different meter type such as meter type non meter type, standard meter, TOU meter, commercial meter and general meter along with different service plans. The bill is generated against the meter as per the specific service plan chosen are provided by APS.

My Responsibilities

Monitoring the work at Lead/Peer level and adhere to the deliver timeline.

Analyzing the requirements and functional documents

Preparing the self understanding document and documenting the new things as learning.

Creating Test JCL’s and test data. Working with File-Aid, QMF tools.

Coding and tested COBOL programs and CICS screens.

Preparing and review the test scenarios and test cases.

Regular communication with onshore/offshore team for BAU activities.

Responsible for conducting Functionality and Regression testing

Review defects found by team and scheduling team meetings.

Maintaining communication with different UP/Down streams for testing activities.

Preparing and maintaining query log sheet to cover up issues/concerns.

Ensure all testing standards are being met

Preparing DSR and WSR reports and communicating with management.

Serves as a resource and communication point for decisions about test schedule changes

Training the new entries and ramping up the resources when required on functionality.

Preparation of test plan and test strategy documents.

Project 2

Liquidity

Type

Development - Business Applications

Employer

JPMorgan Services India Pvt. Ltd

Client

JPMorgan-Tampa

Platform

IBM-Mainframe

Software

Cobol,Jcl,Cics,QMF,FileAid,DB2,CA7,ZEKE,QC and QTP

Domain

Investment Banking

Description

The Liquidity solutions module provides extensive support for various businesses activates associated with liquidity and investment management, including providing visibility into cash position, inter-company loan tracking, and investment status. It enables users to create new deposits, view sweeps structures and inter-company loans and amend existing deposits. Liquidity solution provides standard, easy-to-use navigation menu options. Liquidity offers an effective and secure solution for short-term investments allowing clients to make more productive use of their excess balances. Liquidity also includes navigation tools that allow you to perform actions quickly and easily throughout the application. It offers a wide range of functionality that is scalable for local, regional and global solutions. Liquidity solution offers its clients a variety of overnight investment seep options, including placing funds with the bank under a repurchase agreement. Client may choose between several product options. Loan sweep, loan & investment sweep, pay only sweep, one to many DDA loan sweep and Equity sweep.

Responsibilities

Team Handling and Work in conjunction with the business analysis and development teams to ensure that applications meet requirements and are of high quality

Test functionality delivered across applications and workflows

Test script creation based upon business requirements and process, in line with use cases

Process transactions from system entry to exit

Review documents in order to test the application and verify requirements are successful met

Perform limited scope and end to end system tests

Test applications to demonstrate that relevant existing system functionality

Run maintenance procedures/analyze results and take appropriate steps as a result

Document test procedures and findings

Ability to automate test scripts utilizing automation tools such as QTP

Condition test data and execute scripts as planned with in allotted test cycle

Assess and revise test sequence and scope based upon test results and/or changes in product design

Assist application developers and technical support staff in identifying and resolving problems

Responsible for daily Testing status report matrix.

Condition test data and execute scripts as planned within allotted test cycle.

Project 3

Branch Number Conversion (BNC)

Type

Development - Business Applications

Employer

ZENSAR Technologies pvt Ltd, Pune

Client

JLP,UK

Platform

IBM-Mainframe

Software

Cobol,Jcl,Cics,QMF,FileAid and DB2,QC

Domain

Retail

Description

John Lewis Partnership (JLP) is the leading UK retail business group, owning 27 John Lewis department stores, 205 Waitrose supermarkets, an online and catalogue business – johnlewis.com, a direct services company – Green bee, a production unit and a farm with turnover of nearly £6.9 billion. John Lewis (JL) and Waitrose use a shared table for branch numbers. This table have the limitation of storing up to 9999 branches and JL uses 1-99 and 500-999 branch numbers for its DC’s, Department stores, outlets and numbers for identifying Service buildings and SSM, Non-SSM stocks. Whenever a JL branch is opened, 6 numbers from this shared table will be used. And in most of the JL supply chain systems branch numbers are limited to 2 digits.

This project implements in 2 phases. In first Phase, Volume and Value dependencies are removed so that the supply chain systems can cope with 3 digit branch numbers. Hard coding of branch numbers is replaced by SQL to perform the branch specific processing. And in second Phase, delivery locations are modified and are identified by location ID’s. And the released branch numbers will be used for future department stores.

My Responsibilities

Worked as a resource and communication point for decisions about test schedule changes

Ensured technical resources are organized for effective support of testing

Identify test resources, estimates test effort and defines test schedule and milestones

Responsible for conducting Sanity, Functionality and Regression testing

Communicates the test strategy to the Project Manager and Development Team

Define test process including required test activities and deliverables

Review Project Artifacts

Works with team to define & create overall strategy, ensures its being achieved

Ensure all testing standards are being met

Serves as an escalation point for issues involving testing

Serves as a resource and communication point for decisions about test schedule changes

Provides Daily &weekly status report that includes testing metrics

Conducts walk-through of Test Strategy

Project 4

Life Insurance Solutions (LIS)

Type

Development - Business Applications

Employer

TIETO India Pvt Ltd, Pune

Client

Finland

Platform

JAVA

Software

JSP,HPQC,HTML,DB2,QC

Domain

Insurance

Description

Life Insurance Solution (LIS) is a highly parameterized and flexible package solution, suitable for different life insurance companies, targeted for life insurance market. It is covering widely the insurance management functionality and policy life cycle management; from insurance sales through policy administration and claims handling. LIS is a scalable solution that supports handling of large amount of insurance policies. It includes core, country and customer layers. The system is based on Universal Life technique and can handle several insurance policy account types. In the future LIS includes also traditional life products.

LIS main processes that are common for all insurance product lines are Sales and marketing Sales channel management Commission management Offer and application management Offer handling Policy application handling Policy management Invoicing Processing policy changes Premium allocation and corrections Claims handling. LIS is logically layered into core, country and customer layers LIS core includes all the functionality that is common to every LIS installation e.g. common LIS package features. This also includes common functionalities related to product lines and policy life cycle management.LIS country layer includes all the functionality that is common to every LIS installation in a specific country. This includes for example reporting to national authorities and integration to country infrastructure.LIS customer layer includes all the functionality required by a specific customer.

My Responsibilities

Working with the team in testing activities in line with defined workflows and use cases.

Analyze Business, Functional, Technical and UI requirements of the project/release

Create Required Test Data and maintain Common Test Data sheet of the Project/release

Developed and Reviewed Test Cases as per the business requirements

Responsible for conducting Sanity, Functionality and Regression testing

Log defects in Quality center and verify defect fixes

Retesting the assigned defects and maintaining the defect status in Quality center.

Involved in preparing test plan

Responsible for preparing weekly and monthly status reports

Key resource for KT s and trainings

Responsible for reporting,tracking and re-testing of the bugs

Contact this candidate