SQL DEVELOPER
ICICI LOMBARD GENERAL INSURANCE COMPANY
HYDERABAD
02.2023 - 06.2023
- Streamlined operations of the renowned insurance project, EDISON
- Calculated commissions for policyholders who participated in client policies.
- Managed agent onboarding and calculated commissions, rewards, and terrorism fees based on IRDA norms for brokers and clients.
- Ensured compliance with IRDA norms by accurately calculating monthly commissions on the basis of IRDA log percentages.
- The percentage of benefits received from policies is primarily determined by the premium amount.
- Successfully managed policies in the areas of Health, Motor, Marine, Education, and Automobile. Calculated both commission and agent rewards to recognize exceptional performance. Implemented a rewards system that was primarily commission-based.
- Created numerous tables for Agent onboarding as part of the project, including the creation of a schema and indexes using procedures.