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 MumbaiSkills
Excel
Advance Excel
SQL Server Management Studio (SSMS)
Risk Link
Touchstone
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