SAIKAT GHOSH

Assistant Manager with almost 6 years of experience, interpreting and analyzing data with Risk Link and Touchstone to drive successful Catastrophe Modelling. Proficient knowledge in statistics, mathematics, and analytics. Impressive understanding of business operations and automation tools for effective analyses of data. Expertise in R, Python, VBA, SQL, Automation, MongoDB, SQL Lite and Machine Learning algorithms.

Team Reporting Dashboard (2019 – 2020)

• Developed a Dashboard on R Shiny and SQL for managing daily/monthly log, production and reporting status.

Bound Dashboard (2019 – 2020)

• Developed a dashboard for Bound Portfolio on R bs4Dash, Java Script, SQL and HTML in order to analyze and predict portfolio data.

RMS to AIR Transition (2019 – 2020)

• Contributed and developed various tools and SQL stored procedures for smooth transitioning to AIR from RMS.

DMT (Data Manipulation Tool) (2020 – Present)

• VBA based Tools along with Python and SQL to automate daily CAT Modelling process.

Bound Prediction (2020 – 2021)

• Predictive models based on R and python machine learning algorithms to predict the Bound probability of a Quote account.

High Hazard definition mapping tool (2020 – 2021)

• Created a Python based tool with text mining and NLP to automate marking of unstructured text based high hazard locations in SQL Database.

Reverse Geo-coding and Geocoding (2020 – 2021)

• A python-based tool to get validated address information from Coordinates and vice versa.

Claim Automation (2020 – 2021)

• Created a VBA and SQL based tool to automate the Claim ULID (unique location ID) process and created R Shiny based Dashboard to automate identifying expected locations from the SQL Database.

OCM and FEMA update (2020 – 2021)

• R, R-Shiny and SQL based tool to automatic update elevation and FEMA zones information in SQL database using different APIs.

Exposure Conversion Tool (2020 – 2021)

• SQL and R based tool to convert RMS portfolio or account database to AIR exposure format.

Reporting and pricing solutions (2020 – 2021)

• VBA, SQL, and Python based reporting tool to provide Internal model data and pricing in a structured manner to Underwriters using APIs.

Export to Import tool and pre import Touchstone geocoding (2020 – 2021)

• VBA and SQL based tool to create AIR import files from AIR export and using API getting Touchstone geocoding information before importing data into database.

Scrubbing Tool (2021 – 2022)

• Automated process for account cleansing and modeling of various COPE information, primary and secondary modifiers and financial terms using VBA, SQL, R, Python

Proxy Methodology (2020 – 2022)

• Developing complex methods and algorithms in CAT process to improve loss estimation for different LOBs namely Property, Energy and Marine.

Inland Flood and Wildfire API integration (2021 – 2022)

• Automated process flow of wildfire score and inland flood report generation with APIs using R, SQL, VBA.

SMB tool and Prometrix data integration (2022 – 2023)

• Automated import file generation process for small middle market business from website with web scraping and pdf extraction using text analysis and Selenium in Python. Automated location file generation and Google location identification from Prometrix website with web scraping and APIs using Python Selenium.

Soil-Raster Data Integration (2022 – 2023)

• Integrated soil raster data in import files of internal models using R.

YOY comparison Tool (2022 – 2023)

• Developed year on year report comparison tool along with any excel file comparison functionality using python and VBA.

Slip Extraction process (2022 – present)

• Extracting and storing insightful text data from pdf files with text mining, NLP and various pdf extraction process using Python, Fast APIs, SQL, SQL Lite and MongoDB

• Power of Innovation award
• Above and Beyond award
• Team member of the year award
• Inspire scholarship
• Ranked in the Merit List in Xth standard
• State Level Table Tennis
• Inter College cricket tournaments