Rakesh Kumar Mohapatra

About Rakesh Kumar Mohapatra

Responsible for hiring and training of new joiners in Treaty Modelling offshore Team. Responsible for Presenting entire reinsurance pricing process flow and natural catastrophe modelling terminologies to prospective clients. Assisting the onshore team in reinsurance Pricing and portfolio roll-up process. Modelling of Per risk treaties in Risk-Link and Touchstone. Creating the RPX files for surplus share,quota share,working excess treaties in Touchstone environment based on LOBs, treaty IDs,Occ and Agg layer info,%cover and %placed etc. Modelling of complex catastrophe treaty structures like Top & Drop, Cascading, Aggregate innuring, Reinsurance protection purchase, Retrocession etc. in Catrader and Tiger-Risk.Extracting the required data from AIR and RMS databases by writing SQL based queries.Downgrading and upgrading of Risk Link and AIR Touchstone databases as per requirement. Analysing the EP curves,AAL,RP Losses based on net-precat AIR and RMS results.Analyzing the Year on year net precat exposure by country and by area and loss change by peril for modelled accounts.EDM data conversion for accounts having no AIR data (Clf,cede db,location and contract files). Analysing and rigorous testings for model change and upgrade impact.Making documentation for SOP, test run findings,process flow.Helping the onshore team in development of SQL and VBA based tools. Quarterly portfolio roll-up, impact forecasting, validation check and reconciliation for both AIR and RMS portfolios at the end of each quarter.In-depth knowledge of Risk Link (V-15,V-16,V17), AIR Touchstone (V-4,V5) and Catrader databases.

Experience

1. Manager Reinsurance Solutions

   Aon

   Sep 2024 — Present · Bengaluru, IN

   Responsible for managing work allocation, quality monitoring, career growth, individual performance and year-end appraisals for 4 different teams in Single Risk modelling, Fac Reinsurance Modeling, Treaty Modeling etc with 25 headcount.

Education

• Pondicherry University

  Master of Business Administration - MBA, International Business

  2016 — 2018

• Biju Patnaik University of Technology, Odisha

  B-tech, Electrical Engineering

  2009 — 2013

Skills

• Yellow Belt
• Microsoft Office
• R Programing
• Reinsurance
• Sas
• Catrader
• Risk Browser
• Air Touchstone
• Vba
• Sql
• Microsoft Excel
• Air Catreader
• Tiger Eye
• Lean Six Sigma
• General Insurance
• Business Analysis
• Risk Link
• Risk Management
• Insurance
• Data Analysis