Fabián Hernán Melo Martínez

Experience

• 

  Diane & Geordi

  Apr 2004 - Aug 2010

  Analista de sistemas sénior

  I was a Systems assistant in this company. I began with my skills in SQL Server there.Fui asistente de sistemas en esta Empresa. Comencé con mis habilidades en SQL allí.

• 

  Valmy de Colombia

  Sept 2010 - Aug 2013

  Coordinador de Sistemas

  I worked as IT Manager. Valmy is a multinational cosmetics founded in Venezuela and they had presence in Colombia.Trabajé como Coordinador de Sistemas, Valmy es una empresa multinacional de cosméticos fundada en Venezuela y tuvo presencia en Colombia.

• 

  Observatorio Colombiano de Ciencia y Tecnología

  Dec 2013 - Dec 2015

  Analista de Bases de datos

  I worked as Database Analyst, I have developed ETL process from Pentaho PDI for populate the Datawarehouse in order to know the current status of the SNCTI (National System of Science and Technology) by their initial in Spanish. I have designed Data visualization under tools like Pentaho, Qlikview, Tableau.Trabajé como Analista de Bases de Datos. Desarrollé procesos de ETL a través de Pentaho Kettle para poblar el DWH con el fin de conocer el estado actual del SNCTI (Sistema Nacional de Ciencia y Tecnología), diseñé tableros de visualización mediante herramientas como Qlikview, Tableau y Power BI Show less

• 

  BRM S.A.

  Jan 2016 - Mar 2020

  Consultor experto en procesos de Negocio

  I was a Database analyst, extracting and management data from a Server Oracle 12c, for 150 concurrent users for the Datawarehouse for Customer Care Management. the data source is provided by AS400 IBM System, and the Data process are designed by Pentaho.Soy un ingeniero experimentado de bases de datos, extrayendo y administrando datos para la construcción de un DWH de Oracle 12c, para 150 usuarios concurrentes y visualización de tableros, para las diferentes áreas transversales de la compañía. Las fuentes están en AS400, archivos de texto, Excel, motores como SQL Server, las herramientas de explotación son Pentaho Kettle y Talend y de Visualización Tableau, Power BI. Show less

• 

  GLOBAL HITSS

  Mar 2020 - Feb 2021

  Ingeniero BI Senior

  I was an ETL, Script Developer, BI Engineer, for Data Extraction from differents sources, domain builder for Dashboards and Reports. I have skills in Deployments Environments, Data testing Quality, Dashboards and Algorithms for visualization of Data, I can transform simple text into powerful information for decision making.

• 

  Anheuser-Busch InBev

  Apr 2021 - Aug 2021

  Business Intelligence Developer

  I worked as an ETL Developer, responsible for understanding of the process, and building of ETL algorythms of demand planning, for Middles American Zone (Including 14 countries). Some of the most common tasks include:-Process documentation (Data mapping)-Data acquisition-Develop dataset processes-Use Azure Synapse and Data Factory as a main tool to data extracting.-Identify ways to improve data reilability, efficency and quality-Schedule task with triggers-Adjustment and fix of queries in SQL-Summarize the data for visualization in Power BI Tool Show less

• 

  Experis

  Apr 2021 - Aug 2021

  Digital Transformation Developer

  Freelance Contract to AB-InBev

• 

  Kantar IBOPE Media

  Sept 2021 - Oct 2022

  ETL Developer

  Responsabilities-Make tasks in all stages of lifecycle in development (Analysis, Coding, QA, and Deployment)-Management and development of ETL and Stored Procedures-Apply the best practices of development such as: code revision, refactoring, and continuing integration-Support in-production apps to ensure stability and availability of these systems-Know the necessities of business with internal customers, suggest solutions, and document these needs through functional specifications.Skills developed:ETL, SQL, T-SQL, SSIS, Git, Azure DevOps, Scrum Show less

• 

  Mobilize.Net

  Oct 2022 - Mar 2023

  Data Engineer

  Responsibilities-Data software development lifecycle experience including design, documentation, implementation, testing, and deployment.-Design, create and deploy data warehouses, and become a technical expert on all aspects of data warehousing to make it fits the specific business needs. Including ensuring knowledge transfer so that customers are properly enabled and can extend the capabilities of the cloud platform on their own.-Determine data storage needs to be able to analyze different options to figure out the best fit.-Develop solutions for extraction, transformation, and loading of data.-Guide customers through the process of migrating to Snowflake and develop methodologies to improve the migration process.-Understanding of complete data analytics stack and workflow, from ETL to data platform design to BI and analytics tools.Skills:Migration SQL Code, Teradata, Snowflake Show less

• 

  Snowflake

  Feb 2023 - now

  Solutions Consultant