Address : Delhi, India
SUMMARY
With over 7 years of experience in risk management, I've excelled in both finance and insurance sectors. In finance, my role involves risk analytics, using advanced tools like SAS, SQL, and BI for asset classification. In the insurance sector, I specialize in catastrophe risk analysis, estimating losses and quantifying risks using RMS tools.
Overview
8
years of professional experience
Work History
SBI Card
Senior Manager
09.2022 - Current
Job overview
Responsible for asset classification basis IndAS (IFRS9) daily as per regulatory requirements and established timelines and also derived month end NPA estimator
Perform quarterly ECL model validations and refresh by calculating PD, LDG and EAD into the model for complete and segmented portfolio, Utilize the same for ECL based provisioning
Support and respond to auditor queries of the Function (Internal Audit) and Risk areas for External audits (including RBI, CAG, Stat) and resolve the same
Automation / standardization and migration of existing risk analytics within in house Risk Data Mart
Hands on experience on BI tools, Risk tools, like Tableau / SAS VA
SME with direct responsibility of managing and executing any ad hoc related analysis with regards to any sudden shifts around asset movements in portfolio lifecycle
Understanding of Bureau data and leveraging same for risk segmentations, reporting and strategy
Contributing to credit cost decisioning by sharing actionable insights on impacted cuts by utilizing answer tree SPSS framework
Projects :
Identify stressed portfolio and recommended targeted action
Monthly identification of stressed portfolio and provide the targeted actions that can be taken to mitigate stress in the portfolio segments
Recommend actions to be taken like blocking /limit reduction , Changing collections strategy, and adjusting sourcing mix
Identify stressed portfolio and recommended targeted action
Responsible for asset classification basis IndAS (IFRS9) daily as per regulatory requirements and established timelines and also derived month end NPA estimator
Understanding of Bureau data and leveraging same for risk segmentations, reporting
RMS, A Moody’s Analytics
Lead Analyst/Technical Specialist
01.2021 - 01.2022
Job overview
Risk Management (Cat Risk)
Roles and Responsibilities
Interacting with prominent UK, USA based Insurance client to understand Business requirements
Working closely with project managers to understand and maintain focus on the client’s analytical needs, including identifying critical metrics and KPIs, and deliver actionable insights
Preparing risk analytics detailed reports with RP numbers, EP curve, graphs in Excel and providing reason for movement of losses to underwriters within deadlines
Performing data wrangling through Alteryx and Leveraging advance excel for data management and analysis
Comprehend and apply complex insurance terms in client property portfolio and software products
Run the financial module to estimate the losses for policies understand and quantify risk from the natural perils like Windstorm, Earthquake etc
Provide the assessment of losses to assets using the in-house Product of the RMS (RiskLink, Risk Browser)
Developing queries for daily data processing and automation using SQL
Guided small team of analysts by providing support in queries and trainings
AXA-XL, AXA
Risk analyst
01.2018 - 01.2021
Job overview
Responsibilities
Interpreting and analyzing the data received from Underwriters/Brokers
Analyzing catastrophe risk information aimed at various catastrophe events
Processing submission data files within stipulated time frames by entering them into cat modeling systems, translating and coding to model recognizable formats and assessing and correcting addressees and geocoding
Modeling Risk Exposures to estimate losses from all perils using multiple catastrophe models
End to end processing and sending out expected loss reports also generate TVAR’s and location level AAL’s and deliver analysis results to the underwriters
Performing audits of tasks related to analysis reports
Performing pre portfolio checks and outliers checks
Being responsible for multiple lines: Programs Business , Lloyds business , NAPC business also training and mentoring new joiners
Creating MOM’s, SOP’s, process update tracker and solving underwriting queries over client calls
Projects
Primary Building Tool
Solely developed an excel based tool using advance excel and VBA for handling the process of manual application of campus functionality in primary building account that lead to process efficiency and FT saving
Won i2i (innovation) award
Accounts Database Model
Solely developed a tool using power query and VBA that provides relevant information regarding different set of accounts processed with few user inputs from a centrally placed access database that restricts and dividing user access using User forms (VBA)
Approved by the management and universally used within the domain
Xceedance Consulting, Berkshire
Process Expert – Insurance Support
01.2016 - 01.2018
Job overview
Roles and Responsibilities
Process Work Allocation and reconciliation on weekly reports to be shared across with client
Being responsible for preparing team accuracy and utilization reports
Working on duck creek and genius for capturing submission details and analyzing the status
Creating MOM’s, SOP’s for new projects and operating as a SPOC for all the meetings and training sessions
Working on Risk Data tool for coding the limits and deductibles with regards to each peril based on slip reading
Data cleaning and working on large and complex data sent by underwriter and converting it into Touchstone/RMS readable format
Handling client calls and giving walk through to the clients
Projects Clearance Tool:
Responsible for giving ideas for development of automated clearance tool to reduce the manual efforts on policy clearance checks performed
I-Next
Responsible for giving ideas for designing & developing a tool to reserve a policy automatically without any manual input of values into systems.Decline
Performed as a SPOC from my region working on reduction of AHT for declined business
Education
Indra Gandhi National Open University (IGNOU)
M.A from Economics
01.2018
University Overview
GPA: 70%
Financial Modelling (Certification)
FM institutes
01.2018
University Overview
KAMALA NEHRU COLLEGE (DU)
French Language Course (Certificate
01.2016
University Overview
KAMALA NEHRU COLLEGE (DU)
B.A(Hons) from Economics
01.2016
University Overview
GPA: 76.82%
V.V.DAV PUBLIC SCHOOL
XII Class- CBSE
01.2013
University Overview
GPA: 90.40%
V.V.DAV PUBLIC SCHOOL
X Class- CBSE
01.2011
University Overview
GPA: 79.8%
Skills
SOFT SKILLS
Good in number crunching and problem solving
Good communication skills, collaboration & interpersonal skills
Good at handling multiple priorities with being consistent on accuracy and output
TECHNICAL SKILLS
Expert knowledge of
Advance Excel and Dashboards
Expert knowledge of Microsoft Office tools
Expert Knowledge of VBA and Macros
Intermediate knowledge of SAS,SQL and Microsoft access
Intermediate knowledge of ETL tools like Power Bi and Tableau, SPSS-Answer Tree
Reporting oversight
Cross-functional collaboration
Documentation and reporting
Business planning
Budgeting
Financial Management
Business Development
Languages
Languages
Known – English, French, Hindi, Bengali(Spoken)
Quote
Far and away the best prize that life offers is the chance to work hard at work worth doing.