Nishita Gupta
Claims Analytics Lead at Temple Insurance Company- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Spanish Elementary proficiency
-
Hindi Native or bilingual proficiency
Topline Score
Bio
Malcolm Cleugh
Nishita worked for me in 2013 - 2014 when was I was Head of Portfolio Risk for RSA Group and she was working in the data analytics team which was part of RSA Indian Actuarial. Nishita was pivotal in the development and implementation of the data analytic tool we introduced to provide Insurance Risk Oversight of our insurance businesses globally. This was demonstrated in her contribution to the design interpreting my initial thoughts into a working tool we could use with the business, suggesting ways to make it more effective, whilst also coding both the tool in Excel VBA along with the data gathering from key stakeholders in the local businesses which was from an online questionnaire. What was key to the success of the project was collating all the data and staking submissions, both scoring against criteria and text based further comments, and converting this into visual KPIs which could be shared with management to show and highlight key findings both strengths and area of weakness for which future management focus was required. All the way through the project Nishita fully committed, ensuring quality and on time delivery of the key tool components. She also conducted user training for the Insurance Risk team members globally who were to roll out the tool in their local business. This all led to the successful launch of the insight tool and it's use to review and challenge management of RSA in may parts of the global business.
Malcolm Cleugh
Nishita worked for me in 2013 - 2014 when was I was Head of Portfolio Risk for RSA Group and she was working in the data analytics team which was part of RSA Indian Actuarial. Nishita was pivotal in the development and implementation of the data analytic tool we introduced to provide Insurance Risk Oversight of our insurance businesses globally. This was demonstrated in her contribution to the design interpreting my initial thoughts into a working tool we could use with the business, suggesting ways to make it more effective, whilst also coding both the tool in Excel VBA along with the data gathering from key stakeholders in the local businesses which was from an online questionnaire. What was key to the success of the project was collating all the data and staking submissions, both scoring against criteria and text based further comments, and converting this into visual KPIs which could be shared with management to show and highlight key findings both strengths and area of weakness for which future management focus was required. All the way through the project Nishita fully committed, ensuring quality and on time delivery of the key tool components. She also conducted user training for the Insurance Risk team members globally who were to roll out the tool in their local business. This all led to the successful launch of the insight tool and it's use to review and challenge management of RSA in may parts of the global business.
Malcolm Cleugh
Nishita worked for me in 2013 - 2014 when was I was Head of Portfolio Risk for RSA Group and she was working in the data analytics team which was part of RSA Indian Actuarial. Nishita was pivotal in the development and implementation of the data analytic tool we introduced to provide Insurance Risk Oversight of our insurance businesses globally. This was demonstrated in her contribution to the design interpreting my initial thoughts into a working tool we could use with the business, suggesting ways to make it more effective, whilst also coding both the tool in Excel VBA along with the data gathering from key stakeholders in the local businesses which was from an online questionnaire. What was key to the success of the project was collating all the data and staking submissions, both scoring against criteria and text based further comments, and converting this into visual KPIs which could be shared with management to show and highlight key findings both strengths and area of weakness for which future management focus was required. All the way through the project Nishita fully committed, ensuring quality and on time delivery of the key tool components. She also conducted user training for the Insurance Risk team members globally who were to roll out the tool in their local business. This all led to the successful launch of the insight tool and it's use to review and challenge management of RSA in may parts of the global business.
Malcolm Cleugh
Nishita worked for me in 2013 - 2014 when was I was Head of Portfolio Risk for RSA Group and she was working in the data analytics team which was part of RSA Indian Actuarial. Nishita was pivotal in the development and implementation of the data analytic tool we introduced to provide Insurance Risk Oversight of our insurance businesses globally. This was demonstrated in her contribution to the design interpreting my initial thoughts into a working tool we could use with the business, suggesting ways to make it more effective, whilst also coding both the tool in Excel VBA along with the data gathering from key stakeholders in the local businesses which was from an online questionnaire. What was key to the success of the project was collating all the data and staking submissions, both scoring against criteria and text based further comments, and converting this into visual KPIs which could be shared with management to show and highlight key findings both strengths and area of weakness for which future management focus was required. All the way through the project Nishita fully committed, ensuring quality and on time delivery of the key tool components. She also conducted user training for the Insurance Risk team members globally who were to roll out the tool in their local business. This all led to the successful launch of the insight tool and it's use to review and challenge management of RSA in may parts of the global business.
Credentials
-
SAS Base Programmer
SASAug, 2014- Nov, 2024
Experience
-
Temple Insurance Company
-
Insurance
-
1 - 100 Employee
-
Claims Analytics Lead
-
Jan 2022 - Present
-
-
-
Munich Re Specialty Insurance
-
United States
-
Insurance
-
200 - 300 Employee
-
Analytics Partner
-
Mar 2020 - Jan 2022
• Act as a key advisor to Chief Claims Officer, by understanding claims business challenges, providing insights around key performance indicators and recommending solutions through data and analytics• Developed and deployed Claims Reporting by using tools such as MS Power BI and SQL to enable claims insights by leveraging skills and experience in predictive analytics, technical analysis and visualization. The claims reporting provided daily view of overall claims processed, reserve movements, adverse development etc.• Analyzed COVID -19 impact on past and current insurance policies by estimating claims frequency and severity. This data was analyzed by utilizing database management tools such as SQL Server Management Studio and MS Excel. These recommendations were leveraged by senior management to adjust annual reserves for future claims • Developed a data-driven frequency severity model using advanced SQL and MS Excel to project full time employees (FTE) required to handle estimated future claims and new business• Liaised with MRSI Claims Teams in US, Canada, London and Munich in order to extract data from relevant repositories to view consolidated results and develop benchmarks• Conducted research and gap analysis of claims data currently not captured in the database tables as compared to industry standards. I then provided guidance to data engineers on appropriate data fields to be captured for claims and bridge the gap of missing data from a future reporting perspective
-
-
-
Munich Re
-
Germany
-
Insurance
-
700 & Above Employee
-
Data Scientist
-
May 2018 - Mar 2020
• Refined claim review planning and file selection process by detecting anomalies in loss runs through text mining and financial rules. Reduced the time spent on claims selection from days to a few minutes now.• Built a predictive model to suggest possible debits and credits during Quick Quote Automated System renewals. Built a dashboard to measure the improved Hit Ratio after new enhanced pricing.• Trained 80+ colleagues on Foundation and Advanced Analytical concepts across Munich Re North America• Evaluated and analysed external macro economic indices that are correlated to market benchmarks using Excel and R language.• Generated useful insights by creating a dashboard in Power BI to visualize frequency, severity and loss trends on the data cube.• Built a predictive model to identify segments that are over and under-priced based on ISO’s rating plan.• Improved the bottom-line results by having more accurate benchmarks which in turn helped to price the business better.
-
-
-
Stevens Institute of Technology
-
United States
-
Higher Education
-
700 & Above Employee
-
Graduate Assistant
-
Jan 2018 - May 2018
-
-
-
RSA
-
Insurance
-
700 & Above Employee
-
MI Team Lead
-
Jul 2013 - Nov 2015
• Led MI & Analytics division by managing 4 direct reports and by providing key inputs to team members on their day-to-day project activities/tasks • Quality assured projects and deliveries completed by my direct reports, advised changes to improve quality of data solutions before handing over those solutions to Business • Developed customized data gathering tools like SNAP surveys, and wrote scripts/triggers to extract survey responses in MS Excel spreadsheets. Using MS Excel Macros, converted responses to summary reports for senior management decision making • Conducted research, developed data management training materials and delivered Software Analysis System(SAS) based data / program training to a class of 40 professionals at RSA Dubai • Analyzed 10-year insurance industry performance data in Excel using advanced functions such as HLOOKUP, COUNTIFS, OFFSET, SUMIFS, INDEX MATCH, etc. and recommended key findings to improve company’s financial performance in future • Improved RSA UK Claims capital position by 30% by building a dashboard using VBA, MS Access and SQL to highlight unnecessary reserves on outstanding inactive claims. • Designed and developed a data gathering IRO Tool by leveraging data management applications like Visual Basic (VBA) and MS Excel to provide oversight on managing insurance risk across business • Designed, built, tested and implemented Managed Information (MI) dashboards for various lines of business for RSA Hong Kong, by processing data in SAS and generating graphs, summaries and pivots in Power BI to track the movement in claims incurred, average settled claim cost, etc. • Liaised Business and internal team of Data Analysts by translating key business requirements into data solutions• Trained and on boarded new joiners on company standards and procedures, data policies and Analytics best practices
-
-
-
Bristlecone
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Consultant
-
Jul 2012 - Jun 2013
Expertise in SAP Business Objects(BOBJ) Platform and SAP Business Warehouse (BW)Working with cross functional team, delivering projects as a part of the offshore team for US clientsResponsible for managing projects with specialization in running day to day operationsLeading & coaching process improvement initiatives across the organization
-
-
Associate Consultant
-
Jul 2011 - Jun 2012
Created Web Intelligence reports and Dashboards using SAP BO BI suite for semi conductor companies, North American RegionCreated reports/dashboards with MS Excel, MS Access as the backend database with Universe as the middle layer.
-
-
-
-
Summer Intern
-
Jun 2010 - Aug 2010
Submitted a project on “Health Insurance Schemes by the Govt. for BPL families” by analyzing and processing data of various state schemes.Fact based recommendations to revamp the insurance sector were forwarded to the Dy. chairman Shri Montek Singh Ahluwalia.Participated in organizing the National Development Council meeting on “Mid Term Appraisal of 11th Five Year Plan” chaired by The Prime Minister of India. Submitted a project on “Health Insurance Schemes by the Govt. for BPL families” by analyzing and processing data of various state schemes.Fact based recommendations to revamp the insurance sector were forwarded to the Dy. chairman Shri Montek Singh Ahluwalia.Participated in organizing the National Development Council meeting on “Mid Term Appraisal of 11th Five Year Plan” chaired by The Prime Minister of India.
-
-
Education
-
-
Stevens Institute of Technology
Master of Science - MS, Business Intelligence and Analytics -
-
Institute of Actuaries of India
Actuarial Science -
-
St. Stephen's College
Master of Arts (M.A.), Mathematics -
-
Hansraj College, University of Delhi
Bachelor's degree, Mathematics -
-
Convent of Jesus and Mary, Delhi
High School
Community
