Germán Rodríguez

Data Engineer at Pangea Consultants – Microsoft® Partner
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Perímetro Urbano Medellín, Antioquia, Colombia, CO
Languages
  • Ingles Native or bilingual proficiency
  • Alemán Full professional proficiency
  • Español Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Curso de Backend con Rust: Bases de Datos, Controladores y Templates
    Platzi
    Feb, 2023
    - Nov, 2024
  • Curso Básico de Rust: Variables, Ciclos y Funciones
    Platzi
    Jan, 2023
    - Nov, 2024
  • Curso de SQL en Azure
    Platzi
    Apr, 2022
    - Nov, 2024
  • Fundamentos de la ciberseguridad
    LinkedIn
    Mar, 2021
    - Nov, 2024

Experience

  • Pangea Consultants – Microsoft® Gold Partner
    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Data Engineer
      • Dec 2022 - Present

      Design a, scalable and reliable, multi-user BI enterprise solution. Develop the solution architecture and define the cloud services to use, deploy cloud services and integrate with different information sources efficiently. Develop reliable and scalable data pipelines. Develop data pipelines to extract load and transform data from different sources, deploy pipelines to production and perform support and improvements. Achieving 99% availability for this pipelines. Model a DataWarehouse implementing best practices. Model and deploy the datawarehouse schema, implementing best practices for dimensional modeling. Integrate different type of data from financial to operational in the DW dimensional model. Design and deploy Power BI dashboards. Design Power BI dashboards based on the client's data and present relevant KPI's for the client financial operation, delivering powerful insight into its data. Show less

  • XM SA ESP
    • Colombia
    • Oil and Gas
    • 300 - 400 Employee
    • Data Engineer
      • Mar 2019 - Dec 2022

      Led a project to migrate an app SQL database from a local SQLite database to Azure SQL database, design the new architecture and flawlessly deploy it into production, increasing the software availability by 50% and reducing its transaction time by 70%. Implemented a cloud-based service on Azure for automatically publishing PDF certificates on the company web page. Integrating an Azure web app with SQL and OCR services. Defined database quality rules for transactional databases based on the DAMA - DMBOK methodology. Increased data accuracy, validity, and integrity from 70% to 99%. Redesigned an ETL process to populate a local data lake used to feed Power BI reports, diminishing the ETL process time by 60% by implementing multithread processing with python. Deployed a service used to compute a weighted outage factor for power plants. Designed the solution architecture and implemented the business rules, reducing the computation time by 90%. Deployed a software solution to keep track of forecast errors in real-time and define the criteria to retrain the model. With this solution, the forecast accuracy increased to 95% during operation. Show less

Education

  • Universidad Nacional de Colombia
    Energy Markets Postgraduate, Energy Markets
    2020 - 2021
  • Universidad del Norte
    B.S. Electrical Engineering, Electrical and Electronics Engineering
    2014 - 2019
  • Centro de Sistemas de Antioquia - CENSA
    Technical degree, System Analysis and Computer Programming.
    2012 - 2013

Community

You need to have a working account to view this content. Click here to join now