Tushar Shinde

• Finalization Reinsurance treaty and Addendums like Premium rates, including Products, etc.
• Reviewing and guiding team for preparation of Monthly reports for Finance, internal and external teams.
• Reviewing and guiding team of new products and Premium rates setup in Cessions environment.
• Maintaining a proper process document of every monthly activity and taking backup of tables every month.
• Liaising with reinsurer’s bordereaux team to ensure correctness in process long-term.
• Preparing Reinsurer-wise Bordereaux of Premiums and Claims with Statement of Accounting (SOA) for 
each quarter and submit to reinsurer within 15 days TAT after the quarter ends.
• Understanding of numbers, effective communication and sharing understanding to different internal 
stakeholders, reinsurers, IRDA (Insurance Regulatory Development Authority).
• Track Due to Reinsurers (RI Payable) and Due from Reinsurers (RI Recoveries).
• Accounting Payable, Receivables Treaty slips from Reinsurers and raising to Third Party vendor for payable 
payments to reinsurers and receive recovery payments from reinsures within TAT.
• Assisting in Regulatory Audit and Internal Audit of Reinsurance profile.
• Understanding of the particulars of CAT treaty and exposure calculation.
• Preparing & Submitting LR 8,11 forms quarterly on IRDA BAP portal.
• Preparing & Submitting LR 1,2,3,4,5,6,7,9,10,12,13 forms, CEO Declaration and RI Statistics with 
Reinsurance Program annually on IRDA BAP portal.
• Persistency Analysis on Renewal Policies movements of 13,25,37,49,120 months for Appointed Actuary.
• Experience Analysis on Claims movements with mortality Actual/Exposure ratio for Appointed Actuary.
• Annually assisting in Monte Carlo Model for Retention limit analysis for Appointed Actuary.
• Hired, managed, developed and trained subordinates, established and monitored goals and conducted 
performance reviews.

It's been more than 7 years in ReInsurance Data Analysis and Performing CRUD operations (Create, Read, Update, and Delete) operations on local and cloud database, Handling Covid Claims and Complaince requirements. Ensure the data quality and integrity in databases, Working on Data with Ms Excel and VB Micros, R and Python for data cleaning, Working on Tableau and Power BI for data reports. Writing SQL queries to generate Business Requirement data for internal stack holders and outside organisation ceding clients. 

M Tech in Computer Science and Engineering