Ashish Mehta

Experience

• 

  GENPACT

  Dec 2005 - Sept 2017

  • Designing portfolio for different LOBs like Lawyers, Agents, Excess and surplus lines in order to maximize profitability and productivity• Performing comparative analysis of all the portfolios based on premium, losses, limit/deductible and ratios.• Making automation tools using technical skills using “R”, SQL, Access, Excel, VBA, Powerpoint• Automation of the projects on the ad-hoc basis leading to resource optimization• Expertise in MS-office utilized for: i) Creation of client presentations, ii) Excel formulas used for automation of trackers and visual management of HR, Learning & development and IT data for the team. Pivot and Lookup used for summarization and analyzing the data for continuous improvementsiii) Attractive SOPs created with flowcharts and hyperlink in WORD documents. Show less • Designing portfolio for different LOBs like Lawyers, Agents, Excess and surplus lines in order to maximize profitability and productivity• Performing comparative analysis of all the portfolios based on premium, losses, limit/deductible and ratios.• Making automation tools using technical skills using “R”, SQL, Access, Excel, VBA, Powerpoint• Automation of the projects on the ad-hoc basis leading to resource optimization• Expertise in MS-office utilized for: i) Creation of client presentations, ii) Excel formulas used for automation of trackers and visual management of HR, Learning & development and IT data for the team. Pivot and Lookup used for summarization and analyzing the data for continuous improvementsiii) Attractive SOPs created with flowcharts and hyperlink in WORD documents. Show less

  • Insurance analytics - MIS - Market Research

    Dec 2011 - Sept 2017

  • Collection analyst -reinsurance

    Dec 2005 - Jan 2012
• 

  Genpact Headstrong Capital Markets

  Oct 2017 - Dec 2024

  Senior Manager
• 

  Morgan Stanley

  Nov 2024 - now

  Senior Manager