YANDRAPU KIRAN KUMAR
Vijayawada
Summary
Dynamic Senior Risk Analyst with expertise in catastrophe modeling at Chubb, leveraging SQL and data visualization to enhance risk assessment accuracy. Proven track record in team collaboration and process improvement, successfully supporting reinsurance decisions and optimizing exposure databases. Committed to delivering high-quality insights and fostering strong client relationships.
Overview
7
7
years of professional experience
Work History
SENIOR RISK ANALYST (CATASTROPHE MODELER)
CHUBB
03.2023 - Current
- Perform quarterly and monthly roll-ups of the personal lines and other small books' exposure, analyzing and monitoring catastrophe risk via third-party catastrophe models, internal tools, and software.
- Update and maintain the exposure databases for catastrophe modeling, improving data accuracy and completeness. Utilize third-party property data and internal risk engineering inspections to improve and enhance modeling capabilities and accuracy.
- Prepare and analyze exposure to aid in reinsurance purchase decisions, working closely with the internal Ceded Re group and reinsurance brokers.
- Monitor and respond to catastrophic events in real-time, quantify potential impacts to in-force exposure and communicate to senior management.
- Work on post event claims analytics to assess model performance, model misses, strengths & gaps.
- Worked as a subject matter expertise and handled multiple time bound ad hoc projects like sensitivity testing of cat models, model version changes analytics, model change management, Pricing etc.
- Extensive use of SQL, Risk modeler, Risk Link and Geospatial softwares such as QGIS/ArcGIS.
RISK ANALYST (CATASTROPHE MODELER)
EXCEEDANCE
08.2021 - 03.2023
- Working as a Treaty modeler with profound knowledge of Reinsurance and its types.
- Extensive use of AIR Touchstone, AIR Touchstone Re, Tiger Eye and SQL for analyzing cedant exposure and modelled results received from U/W & brokers import in vendor risk modeling environment.
- Preparing modelling results and pricing sheets for Underwriter assistance.
- Applying complex reinsurance treaties like CAT XOL, QS, Surplus share, aggregate structures for multiple LOBs on global cedants.
- Maintaining the outflow of reinsurance businesses on a daily basis.
- Helped in setting up the new client and built strong and positive business relationship with them.
- Worked in the field of Catastrophe modelling with respect to Property & Casualty insurance.
- Gained experience in Global Property, Energy R, and Terrorism LoBs.
- Understand location information, prioritize high value and high-risk location.
- Format, scrub and arrange data in a manner understood by model and ensure all logical checks are in place in data.
- Policy coding from insurance slip (i.e. Layers, limit, deductible, etc.).
- Assessing data quality and making necessary assumptions for modelling, analyzing changes in exposure and the associated impact of catastrophe model results.
- Providing high quality risk assessment of individual accounts or portfolios based on information provided in schedule or modeling data and ensure the highest levels of exposure data accuracy and completeness.
- Enhance efficiency of the process by continuously evaluating and improving the end-to-end catastrophe modeling process.
- Maintain exposure databases and analyze it completes and accuracy of the information.
- Support underwriters in all queries, exposure movement year over year.
- Contribute ideas for process enhancement and improvement and understand and interpret model results, provide risk specific observation to the underwriter.
Intern
RELIANCE GENERAL INSURANCE
05.2020 - 07.2021
- Assess the client's financial status, spot problem areas and offer solutions to rectify these.
- Proficient in all the company's products, including Life Insurance, Auto Insurance, Property Insurance and Annuities.
- Understand what the client's immediate and future financial requirements are and accordingly integrate this into the suggested plan.
- Seek out new clients and develop clientele by networking to find new customers and generate lists of prospective clients.
- Also taken a part in Risk inspecting.
- Property & Casualty
Jr Accountant
INFOSYS
09.2018 - 08.2019
- Worked for Central processing center (CPC) client.
- Worked as a business enabler by way of analyzing Information and data of taxpayers through MIS, MySQL and involved in pre and post - production deployments of Income Tax rules.
- Provide and create intimation to the taxpayers and deal with clients and get their approvals.
- Provide presentations to the client regarding the Intimations and rules.
Education
P.G.D.M - Insurance Risk Management
IIRM
Hyderabad01.2021
B.COM - Financial Servicing and Auditing
Krishnaveni college of commerce
01.2018
Intermediate - Commerce and Economics
Sri Vidya college of commerce
01.2015
S.S.C -
Bhashyam Public School
01.2013
Skills
- Team collaboration
- Attention to detail
- Microsoft Office Suite
- Database management with MySQL
- Data visualization using Tableau
- Statistical analysis with R
Languages
- Hindi
- Telugu
- English
Personal Information
Date of Birth: 09/24/97
Projects
A Study of Indian Mutual funds, To study the Mutual Fund Industry in detail., To attain deep knowledge of the concepts of Mutual Funds and get learning of various major players in the Indian Mutual Fund Industry., To study investor preference regarding Investment in Mutual Funds. Insurance A Tool for managing business risks in MSMEs, Identify what business risk(s) MSMEs face., Examine the response of MSMEs towards the use of non-life insurance to mitigate pure risk(s)., Assess the benefits MSMEs derive from using insurance as a risk management tool., Identify any problems MSMEs encounter in using insurance., Find out solutions to the challenges that SMEs encounter in using insurance.
Core Competencies And Soft Skills
- Team player
- Due diligence
- MS Office
- MySQL
- Tableau
- R
Additional Qualifications
- Cleared Insurance Licentiate exam from IRDAI.
- Pursuing CII and CPCU certifications.
Timeline
SENIOR RISK ANALYST (CATASTROPHE MODELER)
CHUBB
03.2023 - Current
RISK ANALYST (CATASTROPHE MODELER)
EXCEEDANCE
08.2021 - 03.2023
Intern
RELIANCE GENERAL INSURANCE
05.2020 - 07.2021
Jr Accountant
INFOSYS
09.2018 - 08.2019
P.G.D.M - Insurance Risk Management
IIRM
B.COM - Financial Servicing and Auditing
Krishnaveni college of commerce
Intermediate - Commerce and Economics
Sri Vidya college of commerce
S.S.C -
Bhashyam Public School