HDFC ERGO

Internship

HDFC ERGO

Internship

I interned at HDFC ERGO General Insurance (non-life insurance) company in India in 12th grade (April to June). I was guided by the senior Vice President, and 2 other mentors. There, I worked on a project to create an API using python programming language to encrypt and validate the insurance premium quote excel template.

Our objective was to create an API to automate the process of validation, extract, and store of data from Insurance Quote Excel into Database, thereby removing manual data entry of up to 1.5 - 2 hours and expediting the policy insurance process.

Over the span of two months, I made this API that could check for a unique, hidden, encrypted value in the excel sheet provided to salespeople by underwriting teams (UW), could validate the quotation templates for various products like Fire & Engineering, could read the data from the excel sheet, and could transfer it to respective tables in the Oracle database.

The software we used were Python - 3.8.8 with Oracle - 19c as Database, Flask - 2.1.2, Pandas - 1.4.2, NumPy - 1.22.4, Os - 0.6.3, SQL alchemy - 1.3.24 (Using this version is critical as some of the functions for executing queries using python from this version are deprecated in higher versions), Openpyxl - 3.0.9, Werkzeug - 2.1.2, Cx_Oracle - 8.3.0

Completion Certificate

Project Presentation