Jorge Castillo

Developed data quality controls with SQL, Spark.SQL, and Python, ensuring data integrity and detecting unauthorized operations. Built dashboards, reports, and KPIs in Amazon Quicksight to meet stakeholder requirements. Led the Data Control Model team for the Mexico program, validating data ingestion into the lake and ensuring format and consistency checks. Coordinated with stakeholders to plan and prioritize control and KPI initiatives. Tracked project progress via Jira, managing epics and user stories. Supported cross-functional teams (Ops, IT, Data Lake, Data Science) with custom queries and data needs. Executed various ad-hoc tasks to support operational goals.

Data monitoring and analysis for asset recovery and management Elaborate queries through different programming languages (Visual Basic, SQL, SAS and Python) Elaborate slides of incidences and inconsistencies detected in the DB Automate and migrate processes using SAS and SQL Management and updating of control model

Build and analyze queries and databases in SQL, SAS, R and Excel Elaborate the calculation of reserves for outstanding claims Elaborate and analyze the technical result each month Execute inventory, persistency, statistics, portfolio profiling Calculating the reserve for catastrophic risks in the property and motor vehicle insurance business Prepare and analyze the annual forecast as well as the monthly presentation to the executive committee