Sergio Nicolás Ortiz Barreto

Sergio Nicolás Ortiz Barreto  new_releases

About

Detail

Business Intelligence Engineer
Colombia
Contact Sergio regarding: 
Finding co-founders
groups
Networking

Timeline

work
Job
school
Education
flag
Award

Résumé

Jobs verified_user 0% verified
  • Convatec
    Business Intelligence Engineer
    Convatec
    Jun 2024 - Current (2 years 5 months)
    As a BI Engineer at Convatec, I manage and develop critical Business Intelligence solutions using a mix of on-premise and cloud technologies like SSAS, SQL Server, Snowflake, dbt Cloud, and Microsoft 365 Suite. My expertise in these tools plays a vital role in driving key business decisions, ensuring our data systems deliver actionable insights that support the company’s strategic goals through the business analysis.
  • CepoBIA
    Business Intelligence & Analytics Developer public Remote experience
    CepoBIA
    Sep 2023 - May 2024 (9 months)

    In my role as a BI & BA Developer at CepoBIA, a consulting firm, I've undertaken diverse projects tailored to meet specific client needs. Notable projects include:

    • Enterprise Application Development for a Furniture Customer
    - Collaboratively with my team, we created a Power Apps-driven enterprise application for a furniture company, enabling them to transition from a costly manufacturing process tracking software to a more economical yet functional solution.
    - Designed the application's logic, UI, and UX to record and streamline information in the manufacturing process.
    - Integrated the application with external software for real-time visualization of critical metrics on Power BI.

    • ETL into Data
  • Natuera
    IT & Process Analyst
    Natuera
    Aug 2022 - Mar 2023 (8 months)
    In my role as an IT & Process Analyst, I embarked on diverse projects with notable achievements, such as:

    • Streamlining Workflows: I successfully optimized processes across various departments, ensuring a harmonized work methodology that led to error reduction and significant time savings.
    • Vending Machine Insights: Leveraging the power of ETL methodology, I extracted critical data from vending machines, the company's primary sales channel. By creating intuitive dashboards and reports, we visualized vital information, enabling data-driven decisions and establishing a robust sales funnel.
    • Innovative Interface Design: Collaborating with the IT team, I played a pivotal role in designing an engaging interface for vendin
  • Resistencias y Sensores Mandos Industriales
    Data Analyst
    Resistencias y Sensores Mandos Industriales
    Jan 2021 - Jun 2022 (1 year 6 months)
    In my role as a Data Analyst, I used Microsoft 365 to spearheaded the development of an advanced Excel accounting software, showcasing the following achievements:

    • Utilizing VBA for Apps in Excel, I created formats for quotes, purchase orders, referrals, and shipments, streamlining processes and enhancing efficiency.
    • I organized product records, establishing databases and optimizing queries to save time, resources, and minimize errors.
    • By implementing a comprehensive sales and supplier tracking database, I effectively monitored company finances and controlled fixed expenses.

    Moreover, the invaluable data provided by this software allowed me to:

    • Create an insightful Power BI dashboard, visual
Education verified_user 0% verified
  • Universidad de los Andes
    Análisis de Datos y Big Data
    Universidad de los Andes
    Jun 2024 - Jul 2024 (2 months)
  • Cymetria
    Bases de Datos Con SQL Server
    Cymetria
    May 2024
    Business Analysis
  • Universidad de Antioquia
    Visualización de Datos
    Universidad de Antioquia
    Nov 2023
  • Platzi
    Curso de Prompt Engineering con Chat GPT
    Platzi
    Jul 2023
  • HR Certification Institute - HRCI
    People Analytics Leader
    HR Certification Institute - HRCI
    May 2023
  • Platzi
    Curso de Análisis de Datos con Power BI
    Platzi
    Nov 2022
  • Platzi
    Curso de Análisis de Negocios para Ciencia de Datos
    Platzi
    Jul 2022
  • Platzi
    Cómo y Por Qué Aprender Data Science e Inteligencia Artificial
    Platzi
    Jun 2022
  • Platzi
    Curso de Fundamentos de Matemáticas
    Platzi
    Jun 2022
  • Platzi
    Curso de Excel Básico
    Platzi
    Jun 2022
  • Universitat Politècnica de València
    Curso de Diseño de Diques Rompeolas con Cubípodos
    Universitat Politècnica de València
    Sep 2020
  • Pontifical Xaverian University
    Degree in Civil Engineering
    Pontifical Xaverian University
    Jan 2016 - Apr 2021 (5 years 4 months)
Awards verified_user 0% verified
  • TOEFL
    TOEFL iBT
    TOEFL
    Dec 2023
    Obtained a score of 104/120 points in the test.