RAJAT GUPTA

Developing a global solutions toolkit which generates accuracy scores on client’s data. Testing derivative product using sample data creation, simulation runs and analysis of modeling results. Creating PowerBI dashboards on loss trends for various stakeholders. Automating technical solutions using Python and SQL which reduced the complexity and compress cycle time by 65%. Involved in hiring, coaching, and mentoring new joiners.

Conducted research using open-source data to create exposure data for various countries. Validated the data against the industry’s heuristics using document reading and creating algorithms in Python/ SQL. Automated the day-to-day tasks using Python to provide the team with quality datasets on stringent timeline.

Independently handled client portfolio and delivering analytical solutions, leveraging deep business understanding and analytical expertise. Managed work of One-Off projects which includes Client communication, enhancement of client reports, data integrity, and quality assurance. Leaded team of 2 new hires and successfully trained them on the process workflow within 3 months.

Analyzed in-house models runs results to calculate probabilistic losses of client’s portfolio. Achieved a QA score 99.7%. Contributed as a 100% stakeholder to successfully deliver a high value project of $250K (approx.) revenue, which helped the organization in retention of that client for next FY. Highlighted an anomaly of duplicated data entries in client’s data which was appreciated by client and helped the company generate an additional $10K. Developed SQL query sets and VBA macros for the team to enhance the quality of reports and save manual efforts. Creating dashboards representing loss maps and vulnerability charts using ArcGIS.

Simulated various probable terrorism events and creating its loss estimates report. Reviewed and validated client’s binder book for any anomaly. Coding member accounts having multiple levels of limits and deductibles. Created policy mapping files in standard RiskLink format.

Worked with regional teams for portfolio roll-ups. Created and analyzed loss output of CAT loss distribution tables: probable maximum losses (PMLs) and average annual losses (AALs). UAT testing of ‘Global Exposure Solution (GES)’ an internal tool. Analyze and prepare reports for Live CAT events in US/CAN region.