Project Insurance

ASHOK.P Email:***********@*****.***

Mobile:+91-929*******

PROFESSIONAL SUMMARY:

Having 3+ years of IT experience as a Database developer.

Strong in Database Architecture, Database Development, and Data Modelling.

Experience with data flow diagrams, data dictionary techniques, and Entity relation modelling and design techniques, database normalization theory.

Experienced in working SQL queries, understanding requirements, writing functional specifications.

Good experience in PL/SQL topics like cursor, triggers, functions, bulk collect and also in stored procedures.

Good Experience on PL/SQL to extract data from source systems.

Good Exposure On oracle performance tuning for the existing Database.

Good knowledge in RDBMS concept.

Part of a team responsible in developing “Practice Management Software” for small to medium sized medical practices.

Having diverse background with fast learning skills and creative analytical abilities with good communication and technical skills.

Ability to work effectively as a member of a team and ability to make decisions including the ability to prioritize tasks effectively.

Closely interact with clients to resolve issues upon software release.

WORK EXPERIENCE:

Working in Accenture Services Private Limited as a Software Engineer from May 2009 to Till Date.

EDUCATIONAL QUALIFICATION:

Bachelor of Engineering and technology from JNTU, Ananthapur.

SKILLS SET:

Software :Ms office(Excel, Word, Power Point, and Access).

Operating Systems : UNIX, Win XP/2000/98/NT.

Languages : PL/SQL, SQL,C.

Databases :Oracle 9i/10g.

Tools :Sql*Plus,Toad,Sql*loader.

PROJECTS OVERVIEW:

Project#1

Project Title : Cognode.

Client : Cognode Inc.

Environment : Oracle 10g, WINDOWS 2003 SERVER.

Role : PL/SQL Developer.

DURATION : August 2011 to till date.

Description: (this is a health care domain)

Cognode is a portal designed exclusively for psychiatric healthcare community. This portal can be used by the physicians or clinics providing psychiatric health care services and the patients who wish to avail the services. The key features of the portal are

• Facilitates online registrations of patients.

• Facilitates scheduling of Patient appointments.

• Allows the providers to access patient records

• Allows the providers to patient insurance claims.

• Provides for automation of billing process.

Responsibilities:

• Developing Stored Procedures, Functions, Cursors, Triggers, and Views.

• Creating Tables and Indexes as per requirement.

• Developed SQL queries for the manipulation of data.

• Include monitoring batch processes and error-mails and resolving immediately to errors/failures by changing scripts.

• Involved in Design & Development, coding and various PLSQL validations.

Project#2

Project Title : online insurance portal.

Client : ING Vysya life insurance, india.

Environment : Oracle10g, windows xp.

Role : SQL developer.

Duration : June 2010 to july2011.

Description: (this is an insurance domain)

Online Insurance Portal System is an integrated insurance system which links up all the channels within the insurance industry. It is a revolutionized insurance solution that can facilitate online processing and services to the insurance partners, agents and customers through the Internet. it is a web based application. Features of the project are

• It is an online service where the customer can buy any policy at anytime from anywhere.

• Providing a user-friendly interface to the agent.

• Payment can be done through online.

• Can be printed out immediately after the payment is done.

• Premium calculations are done online by the customers.

• Premium periods and the policy renewal dates are intimated to the customers through email.

Responsibilities:

• Understanding the client specifications and developing the jobs accordingly.

• Creating Tables and Indexes as per requirement.

• Developed SQL queries for the manipulation of data.

• Involved in resolving the errors and warnings while developing the jobs.

• Developed PL/SQL Procedures, Functions and Packages and Used SQL*Loader and PL/SQL, ETL Table functions to load into the database.

Project#3

Project Title : OVATION.

Client : Xchanging Technology, USA.

Environment : Window NT, UNIX, Oracle 8i/9i/10g, Forms 10g.

Role : SQL developer.

Duration : May2009 to june2010.

Description: (this is an insurance domain)

This is project is an worker compensation project which maintains the details of various claim processing information, Claim processing is the term used to describe the entire process of recording incident information and, if needed, creating a claim based on the incident. Claim processing includes recording claim information as an adjuster researches all aspects of the claim as the adjuster verifies the incident details, tracks how much time the employee loses from work because of injuries resulting from the incident, authorizes and tracks the employee’s medical treatment, and ultimately decides how much compensation is owed to the claimant. Claim processing might also involve recording information about legal activity initiated by either the adjuster or the claimant.

An incident is an event that injures or causes the death of an employee while he or she is performing work-related activities; a claim is a request for compensation for an incident

Responsibilities:

• Involved in Design & Development, coding and various PLSQL validations.

• Technical & Project reviews with client, coding, testing and Implementation.

• Development of Re-usable objects like General Procedures, packages.

• Created triggers for auditing purpose.

• Developed Complex SQL Queries using various joins and developed various Dynamic SQL's throughout the Project.

• Used Bulk collect feature to improve Performance.

• Analysed and computed statistics to improve response time.

• Prepared Unit Test Plan.

Contact this candidate