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.
• 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:

• 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.

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.
• 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.

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.
• 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.

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