Description

Senior data scientist and Actuarial manager with over 10+ years of experience driving risk management for financial and Insurance institutions. Strong IT capabilities in machine learning, statistical modeling, big data and AI adoption, supporting scalable automation and continuous improvement across multinational insurance portfolios. Expert in advanced Financial and statistical modelling with strong capabilities in AI driven analytics. Proven ability to strengthen governance, enhance data integrity, and build high quality MI to influence scalable systems.

Industry field of expertise

Languages

Spanish
Native or bilingual
English
Native or bilingual

Workplace preferences

Can work on-site

Madrid (up to 50km)

DUAL Group,
Actuarial & Analytics Manager
BANKING AND INSURANCE
January 2024 - March 2026 (2 years and 2 months)
Madrid, Spain
● Create new data pipelines including raw data from different sources to implementing ETL and analytics with azure databricks, SQL, Python and C++
● Develop new Power Bi dashboard for Executives to track business performance.
● Evaluate new AI frameworks in actuarial development such as, Microsoft AI studio, LLM deployment for underwriting, Claims Analysis and actuarial automation.
● Evaluate portfolio performance, underwriting metrics and new business initiatives.
● New pricing solution end to end solution implemented in -Hyper exponential platform in python.
● Ultimate's estimation and reserving analysis for all lines of business in ResQ,
● Calibrate, maintain and enhance current pricing models and develop new pricing tools for emerging lines of business.
● Conduct a profitability analysis for executive management on current business lines in Spain and Italy, including DO, PI, Surety, Cyber, General Liability, Financial lines, Contingencies and Medical Malpractice Business across all geographical locations: Continental Europe, Latin America, the United Arab Emirates, and Singapore.
Data integration (ETL, ELT and data warehousing) Python Databricks Actuarial Business Intelligence (BI) Strategy
DUAL Group,
Data Scientist Actuary
BANKING AND INSURANCE
February 2022 - September 2024 (2 years and 7 months)
Barcelona, Spain
● Create and maintain Power BI Dashboards for the executive committee and chief actuary.
● Workloads automation al over actuarial pipeline, from raw data to actuarial modeling and advanced analytics in Power BI.
● Develop and maintain Statistical and Machine learning models for Insurance risk management.
● Actuarial reserve reviews in ResQ, Ultimate's estimation, LDF fitting and reporting to management
● Actuarial reviews of new Binders for Lloyd's of London to achieve capacity in new geographical locations.
• ● Semiannual pricing and profitability review for Medical Malpractice Business across all geographical locations: Continental Europe, Latin America, the United Arab Emirates, and Singapore.
• ● Continuing improvement of pricing modules and analysis of the actuarial concerns and limitations of the pricing models.
Actuarial Business Intelligence (BI) Strategy AI and Advanced Analytics Databricks Microsoft Power BI
Caixa d'Enginyers,
Risk Management Actuary
BANKING AND INSURANCE
January 2021 - February 2022 (1 year and 1 month)
Barcelona, Spain
● Databases data processing and analysis.
● Models pipelines automation with Azure cloud and database management with delta lake for Azure Databricks to aggregate raw data.
● Business tasks Automation .
● Validation of the position statements of life savings products, validation of the information required by the supervisor. In addition to intervention in department projects, such as: IFRS'17
• ● Solvency II, Capital requirement modeling and IFRS17 Reporting and Reinsurance control and validation.
• ● Cash Flow matching calculation and ALM model Development and testing.
• ● Mathematical reserves and Assets portfolio calculation and validation.
Solvency II IFRS 17 Microsoft Power BI Python SQL

Check out Juan Carlos's experience

Be the first to recommend Juan Carlos

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Master on Actuarial science and Quantitative Finance
Universidad De Barcelona
2021
Master of Science
Maters On Machine Learning and Data Science
Universidad De Barcelona
2021
Maters On Machine

Check out Juan Carlos's education

Juan Carlos Forero

Actuarial & Analytics Manager

About Juan Carlos

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories