Lucas Guerrero

• Analyzed enterprise commercial insurance data across underwriting, claims, premiums, and broker operations, identifying data-quality gaps and improving the reliability of information used for business reporting and decision-making.
• Conducted quality assurance and data validation across internal dashboards and datasets, investigating missing, inconsistent, and inaccurate fields and communicating actionable findings to business stakeholders.
• Developed Excel-based data reconciliation and automation solutions to match employee records, validate information, and streamline recurring analytical processes across large datasets.
• Designed and presented “Sompo Echo,” an AI-powered knowledge management concept leveraging Microsoft Copilot and Azure AI Search to preserve institutional expertise, reduce administrative workload, and improve access to underwriting knowledge.

• Participated in consulting sessions with entrepreneurs, brokers, and investors
• Built summary reports and investor-style presentations using Google Docs and PowerPoint
• Developed skills in market research, cost analysis, and client communication