Pipasa Pattanayak

• Managing a team of 7 members (Europe Region) with, management on day-to-day operation to meet KSM or SLA
• Develop Power BI reports and effective dashboards after gathering and translating end user requirements
• Good Knowledge on DAX, creating different charts and maps
• Monthly engagement with underwriters/Clients to provide insights on composite change in their portfolio across different years and quarters with attractive data visualization reports generated using power BI tool
• End to end process training on Excel, SQL and catastrophe data modeling concepts for the new hires
• Submission of monthly dashboard on productivity and QA score.

• Assessed risk of natural catastrophes for more than $30bn insured value via probabilistic loss estimate models and reduced loss estimates up to 30% by improving prior assumptions and modeling techniques
• Reduced project turnaround time by 40% by performing end to end risk modeling and bridging the gap between catastrophe modeling and underwriters by providing various analytical solutions to gain better insight of the catastrophe risks based on the exposures in EMEA region
• Knowledge on Joins, windows function and different SQL commands like DDL and DML with experience in Risk Link application integrated with SSMS in the backend
• Accounts data validation at portfolio level for the LOB-Commercial Property with SQL queries and visualization in Power BI thus determining the root cause of loss movement/accumulation every quarter
• Being Quality Analyst role responsibility was to perform RCA and ensure that quality standards are achieved along with adherence of SOP in the team
• Prepare and maintain documentation for KPI, metrics and processes.

• Cleansing/Scrubbing of data provided by Underwriter and preparing the data in model-ready format using Excel
• Apply various underwriting techniques and standards to ensure accurate analysis
• Run catastrophe modeling software for portfolio risk analysis in the different suite of model vendors like Risk Link, Risk Browser and in house tool GES (Global exposure solution)
• Presented results of analysis to support the pricing and underwriting process and to help clients better understand catastrophe exposure
• Respond to Brokers, clients, regional team on issues and questions relating to risk analysis of different catastrophic perils.

CGPA: 8.2