Mauricio Obando

Experience

• 

  Itaú BBA

  Jul 2014 - Apr 2015

  Finance Intern
• 

  BRM S.A.

  Jun 2015 - Jan 2016

  Research & CRM

  · Built PHP framework for API consumption and centralized information of different marketing platforms like google analytics and Twitter content.Page 2· Build a centralized Mongodb table mixed with an entity-relationship model to build a centralized way to store historical data coming from Instagram and Twitter.

• 

  Old Mutual Group

  Feb 2016 - Jul 2018

  Portfolio Analyst

  · Designed, and developed pipelines for extracting information from Bloomberg in order to run portfoliooptimization models.· Applied methodology of CAP modeling for portfolio optimization, to distribute portfolio after themarket closes.· Elaborate with python dash, report about the performance of investment during the day, and monitorprices to check for data anomalies.

• 

  Banco Itaú

  Aug 2018 - Mar 2020

  Sr. Analyst of Strategy Management

  · Build tool in SAS with logit model classifying the risk for medium-income companies in Colombian and Brazil.· Implementation of data warehouse modeling using Kimball methodologies.· Supported data warehouse by responding to job failures, building new fact and dimension tables, andworking with business users to help answer questions using data warehouse queries.· Worked closely with application development, server, and storage teams to ensure optimal performanceand efficiency. Show less

• 

  Prodigious Worldwide

  Sept 2020 - Jul 2021

  Sr. Data Analyst Advanced Analytics Spain

  · Modernized BI architecture - migrating R shiny app to Power bi, using python as a scripting tool for datatransformation.· Build EDA for different types of clients analyzing possible efficiencies on marketing income andexpenses for final client delivery.· Creation of data management initiatives using excel and VBA macros for connecting and creatingreports coming from SQL server database.· Time series analysis for creating reports related to lagging information of tv and sms impact onmarketing budget.· Developed pipelines for data analysis and modeling, using Pentaho, R, and spark. Show less

• 

  Globant

  Jul 2021 - Feb 2023

  · Developed framework with Pyspark for PII protection and encryption.· Assisted in Privacera for Databricks usage with Kubernetes cluster to do PII scans on AWS S3 in thecross-region operation of the Company. · Assisted with setting up CI/CD process for the COP project team for deploying code· Utilized cloud engineering skills by assisting with the DBT remote container execution process· Optimized existing pipelines to reduce overall runtime and improve accuracy

  • Datascientist

    Jul 2022 - Feb 2023

  • Data Arquitect

    Jul 2021 - Jul 2022
• 

  Publicis Groupe

  Feb 2023 - Apr 2024

  · Developed critical, efficient data pipelines for Stellantis as well as lead implementations of ReferencedArchitectures for data pipelines implementation using GCP and AWS· Create Architecture solutions for Dashboards, using Tableau and looker and all the Data ingestion andtransformation pipelines in order to create insights for the DataScience team.· Propose solutions for monitoring different pipelines in order to adjust billing and all the frameworkusage in each individual case so that it could standardize performance and homologate versions interms of software. Show less

  • Data Engineer Specialist

    Oct 2023 - Apr 2024

  • Lead Data Engineer

    Feb 2023 - Nov 2023
• 

  Amazon Web Services (AWS)

  May 2024 - now

  Technical Account Manager