G

Gustavo Perez

About

Detail

Data analyst - Business intelligence senior - Data visualization specialist
Bogotá, Bogota, Colombia

Contact Gustavo regarding: 
work
Full-time jobs
Starting at USD4.5K/month

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • Unosquare
    Principal BI
    Unosquare
    Jul 2022 - Current (3 years 9 months)
  • Schlumberger
    Consultor Senior BI - AAS/PowerBI
    Schlumberger
    Feb 2022 - Jul 2022 (6 months)
    - Gathering requirements to perform migrations from Oracle systems to Microsoft Azure. - Modeling dimensional models in PBI to guarantee a better performance in the Data model. - Create dynamic ETL that allow migrating and exploiting all the data in Power BI. • Made variables and measures on Dax if the data model requires. • Create workflows and pipelines in Data Dactory to load data daily and monthly in the Data Model.
  • Globant
    Engineering Specialist
    Globant
    Mar 2020 - Feb 2022 (2 years)
    - Globant Colombia BI Consultant- (EY and Disney clients (Feb 2020-Jan 2022)) Power BI – Microstrategy - Azure - Worked alongside designers, project managers and technical leaders in the information gathering, design and construction of 6 reports from scratch. - We built a relational data model that exploited the information hosted in Azure Data Base, along with flat files in Excel. These reports allowed the visualization of data related to the taxes of the oil wells that EY advises on in each county in the state of Texas, in terms of the productivity and monetary values of each EY assessor. • Create a SQL Server repository database in an Azure cloud space, to be the database engine to exploit the information with Anaslysis services and the
  • Banco Popular
    Data architect
    Banco Popular
    Apr 2019 - Mar 2020 (1 year)
    - Banco Popular MDM, Data Lake (Mar 2019-Feb 2020) Data Lake on AWS, IBM Master Data Management - Led the stabilization of the Master Data Management project, also worked as a data architect for this IBM tool in the integration of the 19 data sources of the bank in the MDM. - Also, as a functional and testing leader best MDM practices was applied. The objective of the project was fulfilled by collapsing all the duplicate records that the bank had in all its sources, thus achieving quality and veracity in all the information of its customers and products. • Led the Operational Decision Management implementation in the bank, worked hand by hand with IBM consultants and all the functional areas in the bank. That project allows to make predicti
  • Periferia IT Group
    Administrador MDM
    Periferia IT Group
    Jan 2019 - Apr 2019 (4 months)
  • IBM
    Functional lead
    IBM
    Feb 2017 - Jan 2019 (2 years)
    - IBM MDM - Grupo Aval (Feb 2017-Mar 2019) Functional Leader – IBM MDM - Worked with IBM MDM, IBM RDM, IBM PME, Oracle DataBase 12g. - Clients: Banco Popular, Banco de Bogotá, Banco de Occidente, Banco AvVillas, Porvenir y Grupo Aval. Implemented the IBM MDM in the 5 entities of Grupo Aval in Colombia, in order to detect and collapse all duplicate records of clients and products of each entity. For this project I worked together with a team from IBM China and IBM Canada, where I learned to implement the RDM and the PME for the probabilistic detection of such records that would be candidates for collapse.
  • N
    Consultor BI
    NTT DATA, Inc.
    Nov 2015 - Feb 2017 (1 year 4 months)
    - NTT DATA - Colombia BI Consultant (Nov 2015-Feb 2017) FrotEnd - BackEnd - Worked with Informatica MDM, Tableau, Talend, Teradata, Oracle 11g, SAS, Cobol, Obiee 11g, ODI 12. - Clients: Claro Colombia, Terpel, Allianz, Consejo Superior de la Judicatura. Worked as a BI consultant in different projects, with different clients, in which the focus was on building flat and analytical reports using various technologies, in addition to migrating through ETL
  • ProCibernética
    Ingeniero BI
    ProCibernética
    Aug 2014 - Nov 2015 (1 year 4 months)
  • SETI S.A.S
    Consultor BI
    SETI S.A.S
    Jul 2011 - Aug 2014 (3 years 2 months)
    - SETI BI Consultant - Worked with Obiee 10g, Oracle Data Base 11g, ODI 11, PL/SQL, Microsoft Integrator, Transact SQL, Power Center Informatica. - Was the first job focused on Business Intelligence, where learned different back and front technologies, also obtained a lot of dynamism with to deal with the clients with whom worked. Clients: Colpatria, Entelgy, Banco de Occidente, Tigo Telecomunicaciones.
  • B
    Ingeniero de Procesamiento
    Bienestar Familiar
    Dec 2009 - May 2011 (1 year 6 months)
Education verified_user 0% verified
  • Universidad Autónoma de Colombia
    Ingeniería de Sistemas, Information Technology
    Universidad Autónoma de Colombia
    Jan 2005 - Jan 2012 (7 years 1 month)