Insurance Oracle

Lakshmi Gunti

Windsor, CT

[pic]

Experience Summary

5+ years of experience in Oracle APPS (HRMS and Advanced Benefit

modules), Oracle Forms 6i, Reports 6i, VSS, Quality Center 9.0, QTP,

SQL

Knowledge of databases like Oracle 9i/10g.

Strong in OAB(Oracle HRMS).

Good knowledge of testing and design aspects of Oracle advanced

benefit modules -Eligibility, premium, rates/coverage, Life changing

events etc.

Strong Knowledge in all phases of Software Development Life Cycle

(SDLC) such as designing, developing, testing, Migrating,

Administrating, security management and production support.

Working Experience in Insurance Projects.

Have good domain knowledge on HealthCare Insurance Projects.

Good experience with configuration management tool - VSS.

Involved in system integration and customer accepting testing phases.

Automated testing experience using quality center.

Good at Reporting and Prioritizing Incidents. Communicating with the

Development & QA Managers.

Good outstanding ability to quickly understand the requirements,

master the latest & upcoming technological metamorphosis.

Estimation of effort and preparation of schedule, tracking the project

progress.

Excellent communication, interpersonal, analytical skills, and strong

ability to perform as part of a team.

Self-starter, pro-active, energetic & goal oriented

Technical Skills

Languages: SQL

Databases: Oracle 10g/9i

Operating Systems: Windows 2000, HP-UX11

Tools Oracle Forms 6i, Oracle Reports 6i

Configuration Management Tools VSS

Testing Tools Quality Center 9.0,QTP

Education

Bachelor of Technology in Computer science- JNT University, India

Work Experience

Fidelity Employer Services Co (FESCO) Aug' 09

- Jul' 10

Software Developer. Nashua,NH

The project involved in testing for production defects in annual enrollment

system for Pfizer and TEXTRON. Team was also responsible for validating

whether the participants has got the correct healthcare plans according to

the provided requirements.

All the employees of the FESCo clients (In this case - Pfizer & TEXTRON)

are provided with an opportunity to revisit their benefits that would be

effective from the next plan year during a cycle in the

current plan year. This cycle is called the Annual Enrollment Cycle. The

objective of the project was to test whether the system is able to handle

any Benefit changes, Life Events, Eligibility & Rates, Accounts Payable,

Accounts Receivables, Payroll and Carrier extracts available to the

employee during the enrollment cycle period as per the requirements. Test

whether the participants has got the correct plans under medical, dental,

vision and other insurance plan types as per the provided requirements for

the specific life event.

Technologies

Oracle 10g

HRMS

Oracle Advanced benefit module

SQL

Responsibilities:

Understanding the issues with business.

Understanding the requirements.

Understanding the eligibility criteria for insurance plans on various plan

types like Medical, Dental, Vision and Insurance Plantypes.

Creation and execution of unit and system test plans- Quality center.

Code versioning using VSS.

Conduct Defect triage meetings with Development and BA teams to track

defects to closure.

Communicating with all the stakeholders through standup meetings, Status

reports,

teleconference and Video conference

Fidelity Employer Services Co (FESCO) Aug' 08

- Jul'09

Software Developer,Nashua,NH

All the employees of the FESCo clients (In this case - TEXTRON) are

provided with an opportunity to revisit their benefits that would be

effective from the next plan year during a cycle in the

current plan year. This cycle is called the Annual Enrollment Cycle. The

objective of the project was to test whether the system is able to handle

any Benefit changes, Life Events, Eligibility & Rates, Accounts Payable,

Accounts Receivables, Payroll and Carrier extracts available to the

employee during the enrollment cycle period as per the requirements. Test

whether the participants has got the correct plans under medical, dental,

vision and other insurance plan types as per the provided requirements for

the specific life event.

Technologies

Oracle 10g

HRMS

Oracle Advanced benefit module

SQL

Responsibilities:

Understanding the requirements.

Understanding the issues with business.

Understanding the eligibility criteria for insurance plans on various plan

types like Medical, Dental, Vision and Insurance Plantypes.

Creation and execution of unit and system test plans- Quality center.

Code versioning using VSS.

Trouble shooting issues during business acceptance testing phase.

Conduct Defect triage meetings with Development and BA teams to track

defects to closure.

Communicating with all the stakeholders through standup meetings, Status

reports,

Tele-conference and Video conference

Environment: Windows (2000 SP3/2003 SP1/XP SP1 later/Vista/7), SQL,

Oracle Forms 6i, OCA 11i, HRMS and Oracle Advanced Benefits modules

Fidelity Employer Services Co (FESCO) Nov' 07

- Aug' 08

Software Developer, Nashua,NH

The project involved in fixing the production defects in annual enrollment

system for Pfizer. Team was also responsible for working on testing the

issues found in enhancement and business change requests.

All the employees of the FESCo clients (In this case - Pfizer) are provided

with an opportunity to revisit their benefits that would be effective from

the next plan year during a cycle in the current plan year. This cycle is

called the Annual Enrollment Cycle. The objective of the project was to

test whether the system was able to handle any Benefit changes, Life

Events, Eligibility & Rates, Accounts Payable, Accounts Receivables,

Payroll and Carrier extracts available to the employee during the

enrollment cycle period as per requirement. Test whether the participants

has got the correct plans under medical, dental, vision and other

insurance plan types as per the provided requirements for the specific life

event.

Technologies

Oracle 10g

HRMS

Oracle Advanced benefit module

SQL

Responsibilities:

Understanding the issues with business.

Understanding the eligibility criteria for insurance plans on various plan

types like Medical, Dental, Vision and Insurance Plantypes.

Creating incidents on the issues found in the testing and finding what

might be the issue in code.

Creation and execution of unit and system test plans- Quality center.

Code versioning using VSS.

Conduct Defect triage meetings with Development and BA teams to track

defects to closure.

Communicating with all the stakeholders through standup meetings, Status

reports,

teleconference and Video conference

Fidelity Employer Services Co (FESCO) Dec' 06

- Oct' 07

Software Developer

All the employees of the FESCo clients (In this case - Pfizer) are provided

with an opportunity to revisit their benefits that would be effective from

the next plan year during a cycle in the current plan year. This cycle is

called the Annual Enrollment Cycle. The objective of the project was to

test whether the system is able to handle any Benefit changes, Life Events,

Eligibility & Rates, Accounts Payable, Accounts Receivables, Payroll and

Carrier extracts available to the employee during the enrollment cycle

period as per requirements. Test whether the participants has got the

correct plans under medical, dental, vision and other insurance plan types

as per the provided requirements for the specific life event.

Technologies

Oracle 10g

HRMS

Oracle Advanced benefit module

SQL

Responsibilities:

Understanding the requirements.

Understanding the eligibility criteria for insurance plans on various plan

types like Medical, Dental, Vision and Insurance Plantypes.

Creation and execution of unit and system test plans- Quality center.

Code versioning using VSS.

Trouble shooting issues during business acceptence tesing phase.

Conduct Defect triage meetings with Development and BA teams to track

defects to closure.

Communicating with all the stakeholders through standup meetings, Status

reports,

teleconference and Video conference

Environment: Windows (2000 SP3/2003 SP1/XP SP1 later/Vista/7), SQL,

Oracle Forms 6i, OCA 11i, HRMS and Oracle Advanced Benefits modules

Infosys Technoligies Limited Jun' 05 -

Nov'06

Software Developer, Hyderabad

This Project involved in Creating and maintaining Telephone Directory

System for Infosys Technologies Limited. Developed integrated database and

created User friendly front end for modifying and updating the data.

Responsibilities:

Understanding and documenting requirements.

High level design of for the change.

Involved in development of PL/SQL stored procedures and functions.

Involved in changing Oracle Forms 6i for enhanced features.

Creation and execution of unit and system test plans- Quality center.

Code versioning using VSS.

Trouble shooting issues during business acceptence tesing phase.

Environment: Windows (2000 SP3/2003 SP1/XP SP1 later/Vista/7), SQL,

Oracle Forms 6i, OCA 11i, HRMS and Oracle Advanced Benefits modules,

Oracle 9i.

References: Available upon request

Contact this candidate