Sergio Andrés Ramírez Bravo Email & Phone Number

Madrid, Es

Madrid, Comunidad De Madrid, España

Responsibilities:• Planning and Execution of the Financial Data Analysis Team: Lead and coordinate the activities of the data analysis team at both technical and administrative levels, ensuring the fulfillment of objectives set by the CEO and CFO, using the SCRUM methodology.• Data Modeling and Design: Create and optimize data modeling to ensure an efficient structure, enabling its consumption by Business Intelligence (BI) tools.• ETL Development: Establish technical guidelines for the ETL (Extract, Transform, Load) processes necessary for proper data trace and processing.• Business Requirements Management: Understand and document business requirements, ensuring their adequate transmission and understanding by the analysis team.• Technology Evaluation: Evaluate and select the most appropriate technologies for necessary developments, ensuring efficiency and effectiveness in data tracing.Achievements:• Design of the Financial Data Relational Model: Creation of a comprehensive relational model of the company's financial data universe, improving information organization and accessibility.• Development of Profitability Dashboards: Development of profitability dashboards that allow detailed segmentation of costs and revenues by customer and service, providing a clear and actionable view of the company's profitability.• Implementation of Agile Methodologies: Successful implementation of agile development methodologies in a newly formed data team, enhancing team efficiency and collaboration within the company.

Responsibilities• Coordinate the data analysis and visualization process. I use tools like Python, Power Query, and Talend for data analysis, and Power BI and Tableau for visualization.• Develop data extraction, transformation and loading (ETL) in Python and Talend for data cleansing and transformation for different work teams.• Design and implement data models based on the needs of the work teams.• Perform analysis of requirements and data understanding needs for the Financial Laboratory and Cybersecurity teams of the client, Inter-American Development Bank (IDB).Achievements• Reduced dashboard processing times to real-time by implementing automated processes in Python that extract data directly from providers through REST services. Previously, processing took 5 to 6 hours, with some manual steps.• Reduced technical debt in data analysis and visualization to less than 10% by efficiently applying agile development methodologies like SCRUM.• Standardized the appearance and functionality of 100% of the finance team's dashboards and 70% of the cybersecurity team's dashboards for the client, the Inter-American Development Bank (IDB).

Bogotá, Distrito Capital, Colombia

Responsibilities• Develop data analysis and visualization for the financial team at the Superintendency of Companies using tools like Power BI, Tableau, and AWS QuickSight for data visualization, and Knime and Python for data analysis.• Lead and manage the data team in the migration of financial data sources for the Superintendency of Companies in Colombia.• Work on data requirements analysis and present the development, results, and insights to the client's executive team.Achievements• I developed and presented the first financial executive report dashboard on the impacts of the pandemic on Colombia's economy for the Superintendency of Companies, which helped provide timely information about which companies were at high risk of insolvency in the country.• I created data analysis and visualization for the set of companies supervised by the Superintendency of Companies, aiming to alert those at risk of liquidity or insolvency through their financial statements with a predictive model confidence of 82%.

Bogotá, Distrito Capital, Colombia

Responsibilities• Extract data from different databases such as Informix, MySQL, and Postgres.• Transform and load data in Python and AWS Redshift, respectively, to consolidate the single data model for acts of violence.• Design and develop dashboards in Power BI and Power Query that report the descriptive state of data related to the armed conflict in Colombia since 1950.Achievements• I developed 15 dashboards (from scratch, now publicly accessible) in Power BI with over 50,000 visits in the first 6 months.• Consolidated 4 on-premise data sources into a single relational database model for CNMH, which is now the largest database of armed conflict in the country.

Bogotá D.C., Colombia

Responsibilities• Develop ETLs in Python and dashboards in Power BI in conjunction with machine learning models.• Perform the presentation, negotiation, and contracting of customized data analysis and visualization projects using agile development methodologies.Achievements• Worked on the management and development of descriptive data dashboards aimed at modeling demographic risk profiles to understand the profiles susceptible to attrition in financial institutions with a classification model confidence of 79%.• Contributed to the planning, management, and development of a predictive analysis project that aims to understand the relationship between climatic variables to predict the weather conditions at different monitoring stations and explore the relationship that may exist between different geographical points to predict weather conditions in a network in the department of Santander, Colombia.

Bogotá D.C., Colombia

Responsibilities• Design software manual and automated testing processes.• Execute automated tests with Selenium on the backend and frontend of Easy Solutions and Cyxtera Technologies' web portals.• Manage and lead the QA team for Easy Solutions and Cyxtera Technologies' web portals.Achievements• Led the QA team in transitioning from manual to automated testing, increasing the number of tests executed by 450% in the first month.• Contributed to a 3% increase in online operation percentages for cybersecurity portals since the implementation of automated testing.

Responsibilities• Monitor and detect cyber fraud related to fraudulent campaigns targeting financial institutions.• Analyze threats and subsequently work on resolving cyber fraud related to phishing campaigns.• Generate reports on the statistics of fraudulent phishing site deactivation.Achievements• Implemented the fraudulent domain deactivation methodology using shell hacking techniques.

Master'S Degree, Data Science

Ingeniero Electrónico, Física, Matemáticas, Electrónica

Activities and Societies: Capitulo de Estudiantil de Sistemas de Control Rama Estudiantil IEEE Semillero Bioingenio E Innovacion