Commercial Automatic Insurance Systems Nov’04-Jan’06

CAIS is a product developed for AIG insurance company to generate auto insurance policies. CAIS calculates e Premiums for the Auto’s based on the information provided by the client. Once the Premium is calculated then the Broker / Agent proposes the same to the Client, if the Client agrees for the Premium calculated then the Underwriter Binds the Quotation and then issues the Policy. CAIS also involves in calculating the Billing, Renewals and Endorsements of the Policies. CAIS also helps in maintaining the Customer Information up to date.

Responsibilities:

Ø Gathered the requirement from Business users.

Ø Designed and created logical data models, schema objects, validation code and performance-tuning strategy using various types of Indexes

Ø Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.

Ø Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.

Ø Developed Several Packages, standalone stored procedures and functions for various requirements from Business.

Ø Extensively worked with SQL scripts to validate the pre and post load data.

Ø Involved in migration, metadata validations, configuring autosys jobs in different environments.

Ø Create and schedule jobs as per new requirements, if any, support existing jobs.

Ø Involved in designing the logical and physical model of database objects using ER-Win

Ø Normalization of the Data Models for the applications

Ø Involved in Migration of Databases from One version to another version

Ø Worked with Oracle Enterprise Manager and Toad

Ø Designed and developed stored procedures/packages/triggers.

Ø Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus

Ø Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support

Ø Involved in transporting and storing data using XML and HTML.

Ø Involved in the design and development of Forms and Reports using Developer2000.

Ø Conducted requirements gathering meetings to determine how to integrate the operational data store feeds into the data warehouse.

Ø Used PERL to write Web server programs for such tasks as automatically updating user accounts and newsgroup postings, processing removal requests, synchronizing databases and generating reports.

Ø Involved in Trouble shooting the loading failure cases. Day-to-Day Production support.

Environment: Oracle10g/9i, PL/SQL, Dynamic SQL, C, C++, UNIX Loader and SQL Navigator, XML.