Summary
Overview
Work History
Education
Skills
Total Work Experience
Personal Information
Disclaimer
Technical Skills - Industry Related Tools
Accomplishments
Timeline
Generic
Aparna Mahapatra

Aparna Mahapatra

Senior Analyst for Natural Catastrophe Modeling and pricing
Bengaluru

Summary

Highly motivated commerce graduate with a keen interest in general insurance and reinsurance analytics. Eager to apply skills and knowledge in insurance data analytics to make meaningful contributions to a dynamic organization. Currently employed as a NATCAT Modeler at Accenture for the Talbot project, a key component of the AIG Cat Modeling Team. Previous experience includes working as a NATCAT Modeler at Genpact on the Ironshore and Hamilton projects, as well as at Infosys on the Brit Global Specialty Project, among others.

Overview

7
7
years of professional experience

Work History

Senior Analyst

Accenture India Pvt Ltd
02.2021 - Current
  • Engaged in analytical tasks supporting AIG's Property & Casualty insurance initiatives.
  • Utilized targeted exposures focused on global regions outside the United States.
  • Applied specialized platforms like GLMS, POP, and GES to streamline pricing evaluations.
  • Performed peer reviews to ensure compliance with standards.
  • Analyzed regional data across EMEA and APAC specific to multiple LOBs including Property, Energy, Binder, Terrorism, and Cargo.
  • Engaged in Post bind operations leveraging underwriter-issued slips for financial policy utilization.

Process Developer

Genpact India Pvt Ltd
09.2019 - 02.2021
  • Contributed to analytics project in Property & Casualty, Marine, Cargo and Terrorism insurance for Hamilton Insurance Group.
  • Executed binder data processing and modeled analyses to present actionable insights.
  • Leveraged Excel's advanced capabilities like pivot tables along with VLOOKUP and HLOOKUP for effective data preparation.
  • Utilized Risk-Link and Touchstone models for effective risk assessment.
  • Utilized geospatial ring-analysis within Touchstone for enhanced data insights.
  • Conducted advanced data evaluations leveraging both Risk-Link and Touchstone platforms.
  • Utilized Touchstone's Hazard Analysis modeling to evaluate coastal proximity.
  • Compiled Exceedance Probability curves with percentage probability details showing potential losses.
  • Communicated drivers behind annual changes through detailed post-modeling reports shared with underwriting teams.

Data Analyst

Infosys Technologies Ltd
07.2018 - 08.2019
  • Collaborated with underwriting team by generating catastrophe risk analysis.
  • Optimized transformation of broker-provided raw data into structured formats aligned with model requirements.
  • Streamlined model inputs by uploading cleaned data to NATCAT systems.
  • Implemented requested underwriting terms, including limit and deductible, after geocoding process completion.
  • Processed financial data and uploaded it to Risk-Link and Touchstone for hazard analysis.
  • Organized analytical outputs for enhanced assessment of potential risks through structured templates.
  • Ensured accuracy of figures by comparing data with submission document specifics.
  • Analyzed YoY changes to identify variations in renewal accounts.
  • Drafted comprehensive modeling summary emails detailing input data and key assumptions for accuracy.

Process Associate

Viztar International
10.2017 - 04.2018
  • Served as Logistics and Transportation Data Management Analyst at Dun & Brad-Street Information Services India Pvt.
  • Contributed effectively in a short-term position in Dun and Brad-Street between October and November 2017.
  • Provided actionable insights on transportation markets through detailed analysis.
  • Crafted comprehensive reports tailored to client specifications.
  • Analyzed challenges faced by company and identified potential solutions to support client business growth.
  • Functioned as a data analysis and reporting analyst for The Times of India Group from Dec 2017 to Feb 2018.
  • Assessed prospective candidates by reviewing application details for scholarships.
  • Compiled comprehensive report for management review.
  • Executed dual roles of market researcher and data analyst at Marico Industries Ltd in the timeframe from February to March 2018.
  • Performed comprehensive analysis on product data for premier Marico brand.
  • Generated comparative studies and developed reports, offering innovative solutions to maintain competitive edge.
  • Handled analytical tasks at Amazon India Pvt Ltd during March-April 2018.
  • Performed data collection and analysis on applicants to identify top candidates for Amazon's project.

Education

Commerce Graduate - undefined

Sterling College of Arts, Science and Commerce
Navi Mumbai

Skills

Excel

Total Work Experience

7+ Years (Out of which 6.5 years in Natural Catastrophe Modeling)

Personal Information

Date of Birth: 03/15/94

Disclaimer

02/22/25, Bangalore, Karnataka.

Technical Skills - Industry Related Tools

  • Excel
  • Advance Excel
  • SQL Server Management Studio (SSMS)
  • Risk Link
  • Touchstone

Accomplishments

Spot-Award from Infosys for best performer of the quarter in 2019.


Bronze-Award from Genpact for performer of the quarter in 2019.


Spot Award from Accenture for best performer of the quarter in 2024.

Timeline

Senior Analyst

Accenture India Pvt Ltd
02.2021 - Current

Process Developer

Genpact India Pvt Ltd
09.2019 - 02.2021

Data Analyst

Infosys Technologies Ltd
07.2018 - 08.2019

Process Associate

Viztar International
10.2017 - 04.2018

Commerce Graduate - undefined

Sterling College of Arts, Science and Commerce

Similar Profiles

CREATE PROFILE
Aparna MahapatraSenior Analyst for Natural Catastrophe Modeling and pricing