Ishan Gupta

About Ishan Gupta

Transforming Data into Decisions | Bridging Actuarial Science & AI I began my journey in actuarial science, mastering risk modeling, pricing strategies, and financial analytics. While automating calculations and optimizing actuarial processes, I realized the immense power of data-driven decision-making. This curiosity led me to explore predictive analytics, automation, and artificial intelligence, ultimately shaping my career in actuarial data science. With 3.5+ years of experience, I specialize in statistical modeling, automation, and financial optimization, leveraging Python, SQL, VBA, and Power BI to build scalable solutions. My expertise lies in translating actuarial insights into data-driven strategies that enhance risk assessment and business performance. At HCLTech, I developed automated actuarial tools that reduced manual errors by 30%, optimized 50+ pricing models, and assisted in system migrations, ensuring seamless integration of legacy actuarial systems. I also contributed to financial modeling enhancements, improving forecast accuracy and regulatory compliance. Previously, at Care Health Insurance, I designed a pricing tool in compliance with UAE regulations, improving turnaround time by 24 hours and automating weekly reports, increasing efficiency by 30%. My experience in health insurance pricing and claims analytics has given me deep insights into risk assessment and portfolio optimization. AREAS OF EXPERTISE Actuarial Science & Risk Modeling – Pricing strategies, reserving, and financial risk assessment. Predictive Analytics & Machine Learning – Developing AI-driven risk models for better decision-making. Automation & Process Optimization – Enhancing actuarial calculations and reporting with VBA & Python. Data Visualization & Business Intelligence – Creating dashboards in Power BI, Tableau, and Excel to translate complex data into actionable insights. Financial & Statistical Modeling – Leveraging data science techniques for forecasting and risk analysis. TECHNICAL SKILLS Languages: Python, SQL, VBA, R Visualization & BI Tools: Power BI, Tableau, Excel Machine Learning: NLP, Clustering, Time Series Forecasting Now, I’m ready to bring my expertise to a dynamic team where I can bridge actuarial science with advanced analytics to solve real-world business challenges. Let’s connect and drive data-driven innovation together!

Experience

1. Actuarial Analyst

   HCLTech

   Feb 2023 — Present

   Automated spreadsheet calculations using VBA, reducing manual errors by 30%. Developed and tested Bonus Rates, Projection Rates, and Indexation updates for regulatory compliance. Optimized 50+ spreadsheets to align ALPS models with internal calculations. Assisted in migration projects by analyzing legacy systems and documenting specifications. Resolved policy-related issues by debugging automated calculations using SQL and VBA.

Education

• Bal Bharati Public School - India

  Commere with Maths

  2003 — 2017

• International Institute of Information Technology Bangalore

  Executive Post Graduate Program in Data Science

  2023 — 2024

• School Of Open Learning

  Bachelor of Commerce - BCom honours

  2017 — 2021

• Institute of Actuaries of India (IAI)

  CB1,CB2,CB3,CS1,CM1

  2019