Yatharth Garg
Actuary | CM1 | CM2
Jaipur
Summary
Diligent aspiring Actuary with background as Data Analyst Intern and Health Insurance process associate. Developed valuable insights from datasets and contributed to data-driven decision-making processes. Demonstrated ability to use Power Query, VBA and Excel for data manipulation and visualization.
Overview
1
1
year of professional experience
Work History
Data Analyst Intern
Art India
03.2025 - 05.2025
- Cleaned and transformed big datasets using Power Query.
- Prepared reports explaining overstocking and shipping delays.
Process Associate
Knack Global
04.2024 - 10.2024
- Used to analyze U.S. medical claims and handle claim denials.
- Communicated with US Insurance representatives and convinve them to reprocess claims.
Education
Bachelor of Science - Mathematics
University of Leicester
Correspondence 04.2001 -
Skills
- MS Excel
- VBA Coding
- Power Query
- Data cleaning and transformations
- Mortality Risk projection
- Income statement forecasting
- Health Insurance
- IBNR Reserves Calculations
Timeline
Data Analyst Intern
Art India
03.2025 - 05.2025
Process Associate
Knack Global
04.2024 - 10.2024
Bachelor of Science - Mathematics
University of Leicester
04.2001 -
Projects
1. MORTALITY PROJECTION : On a big dataset calculated approximate claim amounts for each client.
2. IBNR RESERVES PROJECT: Calculated IBNR Reserves needed for a health insurance dataset.