C

Capy Bara

About

Detail

Data
Bogotá, Bogota, Colombia
Contact Capy regarding: 
groups
Networking

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Foodics
    Data Engineer
    Foodics
    Jun 2022 - Jun 2023 (1 year 1 month)

    • Creation of a Lakehouse in Databricks. Build / Execute Spark Jobs. Cluster administration, monitoring and optimization. Use of multipurpose and job compute clusters (ephemeral). Usage of external Delta Tables in s3.
    • Create, deploy 100+ data pipelines and batch jobs in Python and Spark. Extract raw data from API's MySQL data sources and store them in the staging, landing zone (csv, json and xml files).
    • Log execution statistics into AWS RDS (MySQL). Implement alert system to monitor job status.
    • Define metrics to guarantee data consistency between all the company systems.
    • Build, schedule ETL jobs in AWS Glue Studio and AWS Data Brew to transform raw data into Parquet files and store them in the processed
  • Wizeline
    Data Engineer III
    Wizeline
    Jul 2021 - Nov 2022 (1 year 5 months)

    • Project Support Office: Staff Augmentation in Google BigQuery Community Support PSO to provide technical support for US, Canada, Mexico, and India Walmart teams in the migration of their Teradata Data Warehouse to BigQuery.
    • Supported the connection between Google BigQuery with BI and other external tools (Tableau, Power BI, Alteryx, Python, R) through JDBC, ODBC and API's.
    • Query translation and optimization: Application of good practices in DW and columnar databases: Clustering, Partitioning, Compression, Materialized Views, Denormalization. Processed tables up to 30 TB in disk size.
    • Analyzed GCP - BQ logging through Google Cloud Monitoring and used Information Schema DB to measure performance metrics (slots,
  • ProCibernética
    Data Science Manager
    ProCibernética
    Feb 2021 - Jul 2021 (6 months)

    • Coordinated the activities of the data team which was composed by six professionals between data scientists, data engineers and data analysts.
    • Managed the team and resources assigned to data science and BI projects. Estimated effort and time of projects and tasks.
    • Designed and architected data solutions in both cloud and on-premises environments.
    • Provided technical guidelines related with data modeling, data analytics and big data. Participated in RFI / RFP processes with private and public institutions.
    • Estimated size of Big Data clusters: number of worker and master nodes, memory and disk, distribution of tasks, roles and technologies per node, data replication factor, block size.
    • Guaranteed
  • ProCibernética
    Data Scientist
    ProCibernética
    Aug 2019 - Jan 2021 (1 year 6 months)

    • Developed software projects (design, programming, and testing). Applied SCRUM agile methodologies, DevOps strategies, and version control.
    • Developed consulting projects in Big Data and Data Analytics: o Descriptive and predictive analytical models. o Computer vision and natural language processing models. o Data ingestion and ETL processes. o Data cleansing and data quality processes.
    • Tested, explored, and researched market leading software, technologies, and tools in the fields of artificial intelligence, machine and deep learning, robotic process automation, cloud platforms, context-awareness / adaptive applications, etc.
  • Alianza CAOBA
    Researcher / Consultant in Big Data and Data Analytics
    Alianza CAOBA
    Feb 2018 - Jun 2019 (1 year 5 months)

    • Developed software projects (design, programming, and testing).
    • Developed consulting projects in Big Data and Data Analytics. Built Hadoop Data Lakes with HDP and CDP. Implemented supervised and unsupervised learning models.
    • Developed research projects in Big Data and Data Analytics. Publicized a research article about data anonimization in big data environments.
  • Sinnetic
    Business Analytics Executive
    Sinnetic
    Jan 2017 - Jan 2018 (1 year 1 month)

    • Managed analytical projects and consultancy processes.
    • Utilized SAS 9.4 suite for database administration and analysis.
    • Developed ETL and data quality processes. Programmed and Scheduled jobs and reports.
    • Designed and built OLAP cube systems, Data Warehouse, and Data Marts.
    • Implemented dynamic dashboards and KPI using Power BI. Executed DAX functions.
    • Monitored retention, collection, and sales campaigns using SAS Customer Intelligence.
  • Ipsos
    Data Processing and Scripting Assistant
    Ipsos
    Nov 2016 - Dec 2016 (2 months)

    • Data cleaning, databases validation, reporting and correction of data errors.
    • Handling of SPSS Data Collection software for the generation and transformation of databases.
    • Application of weighting files.
    • Developing and designing data rules and scripts testing.
  • Ipsos
    Research Assistant
    Ipsos
    Feb 2016 - Oct 2016 (9 months)

    • Giving support to analysts and project managers at Connect business unit, in the development of brand tracking, brand image and market research reports.
    • Handling of RUBY DP and SPSS Survey Reporter software for statistical analysis, generation of cross tables and creation of new variables.
    • Working in the automation and optimization tasks of the area internal processes.
    • Designing and formulation of excel formats for fast data extraction and visualization.
  • Ipsos
    Assistant
    Ipsos
    Jan 2016 - Feb 2016 (2 months)

    • Managing of EXCEL databases for developing and presenting graphs, statistical results and market analysis.
    • Reporting in Excel and PowerPoint.
Education verified_user 0% verified
  • Pontificia Universidad Javeriana
    Maestría en Analítica para la Inteligencia de Negocios, Ingeniería
    Pontificia Universidad Javeriana
    Jul 2018 - Dec 2020 (2 years 6 months)
  • Pontificia Universidad Javeriana
    Maestría en Ingeniería de Sistemas y Computación, Ingeniería
    Pontificia Universidad Javeriana
    Jan 2018 - Jun 2019 (1 year 6 months)
  • U
    Ingeniería Mecatrónica, Ingeniería Mecatrónica, Robótica y Automatización.
    Universidad Nacional del Colombia
    Jan 2010 - Jun 2015 (5 years 6 months)