• Led the research and design of project for police patrol distribution optimization and creating an institutional capabilities index, to offer a greater understanding of risk to customers.• Enhanced Python package for news extraction using OpenAI's tools, improving event classification to identify high-risk locations. Additionally, developed a news translation package achieving 95% accuracy in translating from Spanish to English.• Enhanced a Risk Index Model for cargo and passenger transportation by integrating geographic data and critical event occurrences, utilizing a Poisson Model implemented in R. This improvement facilitated road risk identification and enabled effective risk scoring of road segments.

• Implemented Python code into R to facilitate cross-platform compatibility, resulting in more efficient data analysis workflows.• Restructured a comprehensive historical dataset into a segmented database categorized by city and crime type over three-month intervals, enhancing data accessibility and accuracy.• Conducted district clustering based on population and geographic proximity, merging smaller cities with neighboring areas to ensure data completeness and accuracy.• Designed and implemented a new scripting language for automated crime report generation, making the reports more accessible for clients.• Learned and applied advanced SQL techniques to perform complex database queries, significantly improving data analysis capabilities.