Abraham Muro Lezama Email & Phone Number

Mexico

DATA MODELER AT OPENBANK SANTANDERAs a Data Modeler at Openbank Santander, I specialized in designing conceptual, logical, and physical data models to structure and organize information according to business needs. My role involved defining entities, relationships, and data structures to ensure efficient and scalable data storage. I focused on normalizing and optimizing these models to eliminate redundancies and improve data retrieval and storage performance. Collaborating closely with software developers, database architects, and business analysts, I ensured that the models aligned with organizational goals. I also continuously reviewed and updated data models to reflect changes in business requirements or technology, maintaining consistency and scalability. Additionally, I documented data models and upheld modeling standards to ensure compliance with corporate policies and regulatory requirements. My analysis of data usage helped identify trends and opportunities for improvement, and I utilized specialized tools like ER/Studio and ERwin to create and manage complex data models while staying current with industry trends.

DATA ANALYST AT MAPFREAdvanced Techniques in .dbf DatabasesI leverage Python to manipulate and optimize .dbf databases, focusing on enhancing the efficiency and accuracy of data analysis processes.Database Analysis and ImprovementI conduct in-depth analyses of databases to identify opportunities for improvement, continuously aiming to optimize data management and usage.Portfolio DesignI design portfolios by considering various scenarios and adjusting strategies to align with market and company needs.Business Cases for New ModelsI develop business cases for implementing new portfolio models, segmented by channels and market segments, ensuring decisions are backed by solid data and realistic projections.

México

Responsible for executing and leading the analysis required in the projects independently, using statistical methodologies and Machine Learning algorithms, adding value to the results in an innovative way and managing expectations with the manager and internal clients.

-Statistical management of crimes in Mexico 2020 - 2021-Leaflet Map Management-Creating an app in Shiny.An application was developed in RStudio for the experts, in whichthe filtering of the crimes of the entire Mexican Republic isfacilitated. (Crime, Subcrime, State, Municipality). Also taking outtheir statistics. (Variance, Min, Max, N, Average, etc...)