JonFLopez
Actuary & Programmer with deep expertise in insurance and advanced analytics
Programming Skills
Technical expertise applied to insurance and actuarial projects
Python
Advanced proficiency in Python for actuarial modeling, data analysis, and automation. Extensively used for embedded value calculations, IFRS-17 implementations, and complex insurance analytics.
VBA
Expert in VBA for Excel-based actuarial models and automation. Applied to MCEV and TEV calculations, streamlining complex financial modeling processes in the insurance industry.
R
Proficient in R for statistical analysis and actuarial computations. Used for mortality analysis, predictive modeling, and insurance lifecycle optimization problems.
SQL
Strong SQL skills for database management and data extraction. Essential for handling large insurance datasets, policy administration systems, and actuarial reporting.
Professional Experience
A track record of excellence in actuarial consulting and education
Universidad Complutense de Madrid
Sep 2025 – Dic 2025Part-time Associate Professor
Teaching actuarial science and insurance mathematics to undergraduate and graduate students. Developing curriculum and course materials focused on modern actuarial techniques and regulatory frameworks including IFRS-17.
Grant Thornton España
Jun 2024 – PresentSenior Actuarial Consultant
Leading actuarial consulting projects for major insurance companies. Specialized in Embedded Value calculations including Market Consistent Embedded Value (MCEV) and Traditional Embedded Value (TEV). Developing sophisticated models for life insurance valuations and providing strategic advisory services.
SISnet
Feb 2023 – Jun 2024Programmer
Developed and optimized insurance lifecycle management systems. Solved complex optimization problems related to policy administration, pricing, and reserving. Created automated solutions for actuarial calculations and reporting.
MAPFRE
Sept 2022 – Feb 2023Actuarial IFRS 17
Gained hands-on experience in insurance operations and actuarial functions. Assisted in pricing analysis, claims reserving, and regulatory reporting. Contributed to the development of actuarial models for life and non-life insurance products.
KPMG
InternshipInsurance Advisory Intern
Supported actuarial consulting engagements for insurance clients. Participated in Solvency II compliance projects, risk modeling, and financial reporting. Developed analytical skills in a professional consulting environment.
Personal Actuarial Tool
Professional financial and actuarial analytics platform
AFinCalculator - Actuarial.es
A comprehensive financial and actuarial analytics platform with bilingual support (English/Spanish). This professional tool makes complex actuarial calculations accessible through an intuitive interface, serving pension actuaries, life insurers, actuarial students, and financial analysts.
Technical provisions calculation using Chain Ladder and Bornhuetter-Ferguson (BF) methods for IBNR estimation.
Stochastic modeling for ratemaking: Frequency (Poisson) and Severity (Lognormal, Gamma) distribution fitting.
Calculate present values with mortality probabilities, flexible frequencies, growth options, and generational tables.
Process actuarial annuity policies via CSV upload with category filtering, batch calculations, and portfolio analysis.
Single premium calculation for Whole Life, Term Life, Pure Endowment, and Term Endowment products.
Analyze actual vs expected (A/E) mortality ratios and compare portfolio experience against standard tables.
Interactive visual navigation of the Standard Formula with risk modules, shock scenarios, and educational data.
Visualizer for tables including PASEM2020, PASEF2020, PERM/F2020 with generational improvement factors.
Analysis of term structures with monthly spot rates up to 30 years for accurate discounting.
Complete English/Spanish interface with professional terminology.
Built with React 18, TypeScript, Tailwind CSS, and Recharts.
CSV downloads for all calculations to enable further analysis.