Summary
Overview
Work History
Education
Skills
Certification
Tools and methodologies
Recent professional experience
Sector & CLients
Timeline
Generic

Jesús Ruiz Guzmán

Systems Engineer
Bogota

Summary

System Engineer and database development specialist with over 13 years of experience. Extensive knowledge and active involvement in data architecture projects, analysis, data integration, business intelligence, and data governance models using the DAMA framework. Skilled in designing architecture solutions for data integration, utilizing the Kimball methodology and adapting to various sectors such as banking and oil & gas. Proficient in incorporating data quality elements, data profiling, and Data Quality Indicators into solutions. Currently leading Data & Analytics initiatives, driving innovation and spearheading projects involving analytics, data integrations, cloud technologies, and statistical modeling to enable companies to make informed decisions and transition into data-driven organizations. Experienced in managing both agile and traditional methodologies for project management, while also contributing expertise in defining policies, standards, guidelines, and best practices in data architecture. Possess a wide range of hard skills in technologies including Netezza, Oracle Database, Vertica, SQL Server, MySQL, Google Cloud Platform, Oracle Data Integrator, Oracle Warehouse Builder, Integration Services, Talend, Informatica Power Center, Tableau, PowerBI, and Hive. A naturally curious individual with a dynamic approach focused on achieving results. Vast experience in resolving complex situations and challenges that arise during data solution implementations by incorporating innovative solutions into projects.

Overview

15
15
years of professional experience
17
17
years of post-secondary education
5
5
Certifications

Work History

Techical Product Manager

Dichter & neira // Market Research
1 2022 - Current
  • Manage different projects inside of area Research & development
  • Estimate effort of team Support the Design of database and data pipelines
  • Data solution definition Governance Data model definition Manage budget and execution.
  • lead a developers team of data architects , data engineers and data visualizations to create analytics solutions in retail sector.
  • Spearheaded initiatives for evaluating new technologies, ensuring competitive advantage in a rapidly evolving market landscape.
  • Enhanced team collaboration, implementing agile methodologies for more effective project management.
  • Mentored junior team members, fostering growth in their technical knowledge and project management skills.

Lead Data & Analytics

everis [NTT DATA]
Bogotá, Bogota D.C.
1 2013 - 1 2022
  • Project Lead in information management and Analytics
  • Business Case and Project Estimation design
  • Data integration processes Design Data solutions and architecture Design and implementation
  • Data Governance model assessment and definition Report (BI) design and implementation Data integration architecture: Design and implementation.
  • Resolved issues and escalated problems with knowledgeable support and quality service.
  • Provided expert support for end-users, ensuring optimal system performance and user satisfaction.
  • Trained junior engineers on best practices related to system administration, providing guidance and mentorship for their professional growth.
  • Collaborated closely with developers to ensure seamless integration between application systems and databases.

Business Intelligence Consultant

Intellego
01.2011 - 01.2013
  • Data Warehouse Solutions Design Survey requirements for Business Intelligence solutions Design data models for data warehouses Implement development of dashboards with OBIEE Implement data integration processes with Oracle Data Integrator / Oracle Warehouse Builder tools.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Designed customized data collection models for specific visualization tasks.
  • Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
  • Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
  • Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.

Integrations Consultant

Soporte Lógico
01.2010 - 01.2011
  • Implement processes of integration and loading of data models (Data Warehouse) / SQLServer
  • Design a data model for the analysis of human resources information Implement data integration processes for migration (PL / SQL).
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.

Education

DATABASE DEVELOPER SPECIALIST -

Universidad Jorge Tadeo Lozano
11.2011 - 02.2018

SYSTEM ENGINEER - undefined

Fundación Universitaria San Martin
10.2007 - 02.2018

Skills

Product Roadmapping

Business process improvement

Product Backlog Management

Data-driven decision-making

Sprint Planning

Teamwork and Collaboration

Self Motivation

Decision-Making

Certification

Digital transformation Course, Univeridad La Sabana, 2022-06-01

Tools and methodologies

Oracle, SQL Server, Vertica, Netezza, Teradata, Oracle Data Integrator, Integration Services, Data Stage, Talend, Informatica Power Center, Power BI, Tableau, OBIEE, SAP B.O., SpotFire, Python, R, GCP, True, SCRUM

Recent professional experience

  • Techical Product Manager, Dichter & neira // Market Research, 2022-01-01, 2022-12-31, Manage different projects inside of area Research & development., Estimate effort of team, Support the Design of database and data pipelines., Data solution definition, Governance Data model definition, Manage budget and execution.
  • Lead Data & Analytics, everis [NTT DATA], 2013-01-01, 2022-12-31, Project Lead in information management and Analytics., Business Case and Project Estimation design., Data integration processes Design, Data solutions and architecture Design and implementation., Data Governance model assessment and definition, Report (BI) design and implementation, Data integration architecture: Design and implementation.
  • Business Intelligence Consultant, Intellego, 2011-01-01, 2013-12-31, Data Warehouse Solutions Design, Survey requirements for Business Intelligence solutions, Design data models for data warehouses, Implement development of dashboards with OBIEE, Implement data integration processes with Oracle Data Integrator / Oracle Warehouse Builder tools.
  • Integations Consultant, Soporte Lógico, 2010-01-01, 2011-12-31, Implement processes of integration and loading of data models (Data Warehouse) / SQLServer., Design a data model for the analysis of human resources information, Implement data integration processes for migration (PL / SQL).

Sector & CLients

BANKING: BANCO POPULAR, DAVIVIENDA, BANCO DE OCCIDENTE, COLPATRIA

OIL & GAS: PROMIGAS, TERPEL

RETAIL: ABI INBEV

ENERGY: ENEL

TELCO: CLARO, UNE

EDUCATION: SENA (Servicio Nacional de Aprendizaje), MEN( Ministerio de Educación Nacional), ICFES

Timeline

DATABASE DEVELOPER SPECIALIST -

Universidad Jorge Tadeo Lozano
11.2011 - 02.2018

Business Intelligence Consultant

Intellego
01.2011 - 01.2013

Integrations Consultant

Soporte Lógico
01.2010 - 01.2011

SYSTEM ENGINEER - undefined

Fundación Universitaria San Martin
10.2007 - 02.2018

Techical Product Manager

Dichter & neira // Market Research
1 2022 - Current

Lead Data & Analytics

everis [NTT DATA]
1 2013 - 1 2022
Jesús Ruiz GuzmánSystems Engineer