DEBORAH BEDOYA MANSILLA

•Analyzed regional insurance market data across 6+ Latin American countries, identifying variations in risk exposure, loss ratios, and underwriting performance

•Supported pricing recommendations by assessing client risk profiles and analyzing historical claims data across 50,000+ policies

•Organized and managed claims data, tracking $20M+ in outstanding liabilities and supporting timely processing of payments

•Utilized Excel to clean, structure, and analyze large datasets (10,000+ rows), improving efficiency and accuracy of internal reporting

•Collaborated with a team of 5+ analysts to interpret findings and contribute to client-facing insights and presentations

•Completed a rotational internship across 9 core banking divisions, including International Banking, Large Corporations, and Risk Management, gaining exposure to $500M+ in client portfolios

•Conducted analysis of Bolivia’s financial system, evaluating macroeconomic trends, regulatory frameworks, and competitive dynamics impacting 20+ financial institutions

•Supported risk assessment processes by reviewing financial statements and credit profiles of corporate clients with revenues ranging from $10M–$200M

•Assisted in developing customer service strategies by analyzing client data and feedback, helping improve response times and client satisfaction metrics