Daniel Chaul, AWS Developer in Buenos Aires, Argentina
Daniel Chaul

AWS Developer in Buenos Aires, Argentina

Member since December 18, 2018
Daniel has over 20 years of IT experience with more than a decade working in large companies providing business intelligence, data warehousing, and data integrations expertise. He's skilled in data engineering and analytics projects with proven experience in several industries, including pharmaceutical, banking, mobile telecommunications, eCommerce, supply chain, and logistics.
Daniel is now available for hire

Portfolio

  • Elementum
    Amazon Web Services (AWS), Salesforce, Sumo, Tableau, Jira, MongoDB...
  • Neologics
    Amazon Web Services (AWS), Elasticsearch, MongoDB, Apache Airflow...
  • Novartis
    Amazon Web Services (AWS), Microsoft Power BI, AWS, Microsoft Project, Unix...

Experience

Location

Buenos Aires, Argentina

Availability

Part-time

Preferred Environment

Snowflake, Microsoft Power BI, Amazon Web Services (AWS), PostgreSQL, Python, Apache Airflow, Data Engineering, Database Design, Data Pipelines, Data Warehouse Design

The most amazing...

...project I've deployed is a BI regional solution for all Latam countries to one of the world's biggest pharma companies.

Employment

  • Data Engineer Manager

    2019 - 2020
    Elementum
    • Built and managed a team of integration engineers/data engineers, ETL experts, and staffing on the range of customer engagements with the ultimate goal of receiving, understanding, and onboarding the data that powers the platform.
    • Defined, designed, and implemented the data strategy and solution architecture for ingesting the data. Served as an expert and evangelist in the data management field.
    • Defined the best practices and coached team members as an Airflow expert.
    • Designed and developed ETL data pipelines using Python and Airflow to ingest data using multiple different types of sources and targets including S3, PostgreSQL, Elasticsearch, API's, Redshift, Redis, and MongoDB.
    • Served as an expert providing knowledge, hands-on, and experience in database modeling and design, tunning, and optimization, including complex queries optimization.
    • Provided hands-on and advisory assistance across multiple customers to define the data onboarding strategy, anticipating bottlenecks.
    • Defined best practices and coached team members as an Elasticsearch expert. Designed and built the process for ingesting data using an Elasticsearch API.
    • Designed reports and dashboards with Power BI and presented them to the senior management.
    Technologies: Amazon Web Services (AWS), Salesforce, Sumo, Tableau, Jira, MongoDB, Apache Airflow, Spark, Python, Elasticsearch, AWS, REST APIs, Reporting, PostgreSQL, MySQL, Agile Software Development, Agile Sprints, Scrum Master, Scrum, Database Design, ETL, ETL Tools, Key Performance Indicators (KPIs), Dashboards, Microsoft Power BI, Redis, JSON API, JSON REST APIs
  • Data Engineer | Architecture Manager

    2015 - 2019
    Neologics
    • Established data architecture and BI best practices, standards, and data models. Worked with all levels of external and internal business customers for development requirements.
    • Led architecture, design, and development for the data warehouse.
    • Worked on database design and administration (backups, roles, and permissions, optimization), tables, and queries optimization.
    • Designed data strategy and developed ETL processes and data pipelines using multiple types of different sources and targets including APIs, S3, PostgreSQL, Oracle, Elasticsearch, MongoDB, and SQLServer.
    • Improved and streamlined processes regarding the display, delivery, and use of analytical information through dashboards and visualizations in PowerBI.
    • Collaborated with teams to report customer insights for data-driven decision-making.
    • Designed and implemented reports and dashboards with Power BI.
    Technologies: Amazon Web Services (AWS), Elasticsearch, MongoDB, Apache Airflow, Microsoft Project, Control-M, Bash Script, MicroStrategy, Tableau, Microsoft Power BI, Teradata, Microsoft SQL Server, Oracle, Informatica PowerCenter, SAP, AWS, Spark, Hadoop, R, Python, PostgreSQL, REST APIs, ETL, Informatica ETL, ETL Tools, ETL Development, Python 3, Azure
  • Data Architect | Data Engineer Lead

    2014 - 2015
    Novartis
    • Designed and implemented effective database solutions and models to store and retrieve company data. Recommended solutions to improve new and existing database systems.
    • Examined and identified database structural necessities by evaluating client operations, applications, and programming.
    • Assessed database implementation procedures to ensure they comply with internal and external regulations.
    • Prepared accurate database design and architecture reports for management and executive teams.
    • Oversaw the migration of data from legacy systems to new solutions.
    • Monitored the system performance by performing regular tests, troubleshooting, and integrating new features.
    • Designed data strategy and develop ETL data pipelines to ingest data from multiple sources.
    Technologies: Amazon Web Services (AWS), Microsoft Power BI, AWS, Microsoft Project, Unix, Oracle, Python, Informatica PowerCenter, SAP, AWS S3, ETL, Data Pipelines
  • Data Architect | Data Engineer Lead

    2011 - 2013
    MSD
    • Led architecture, design, and development for regional BI projects in Latin America and Asia.
    • Provided data warehouse and the BI technology vision, roadmaps and blueprints, and project plans.
    • Established data architecture and BI best practices, standards, and data models.
    • Designed and implemented the Data Warehouse Model and the ETL processes using multiple sources and targets.
    • Defined the data strategy and performed queries and tables optimization.
    Technologies: Jira, Visio, Erwin, Microsoft Project, Bash Script, Oracle, QlikView, IBM Cognos, Informatica PowerCenter
  • Data Engineer Lead

    2007 - 2011
    Telecom Personal
    • Analyzed, designed, and developed new requirements for the Data Warehouse.
    • Implemented multilayer ETL data extracts, data load logic, mapping, workflows, and stored procedures.
    • Defined system specifications for the extraction, transformation, and loading (ETL) of the source-to-target data.
    • Developed the data migration and the data validation process from the old system to the new one. Defined the BI methodologies and good practices.
    • Managed a team of resources. Coordinated area activities, follow-up, and reporting. Managed the relationship with the internal client.
    Technologies: Microsoft Visio, Microsoft Project, SAP BW, SAP SD, Control-M, Bash Script, Microsoft SQL Server, Oracle, Informatica PowerCenter, ETL, Database Design, Databases, Database Modeling, Python
  • DBA | ETL Lead

    2005 - 2007
    Banco Santander
    • Worked on database design and administration, including tunning and optimization.
    • Designed, developed, and deployed ETL data pipelines to process large amounts of data into the warehouse from multiple sources.
    • Worked on database complex programming including views, triggers, stored procedures, partitions, and complex SQL queries.
    • Built, managed, and mentored a team of back-end developers, coordinated area activities and follow-up.
    Technologies: Visio, Microsoft Project, Control-M, Shell Scripting, Oracle, CRM APIs, Oracle PL/SQL, PL/SQL, PL/SQL Developer, PL/SQL Tuning, Databases, Database Design, Database Triggers, Database Modeling, Database Security, Database Administration (DBA), Stored Procedure, SQL
  • Project Leader

    2004 - 2005
    Globaltech
    • Led the development team. Coordinated area activities and follow-up. Analyzed, designed, and deployed regional projects in Latin America.
    • Recruited, interviewed, and hired contractors and employees to work on IT projects.
    • Handled project scheduling and reporting. Built and mentored the team.
    • Attended industry trade shows, exhibitions, seminars, and training sessions to promote products and services.
    • Defined methodologies and best practices for the full life software cycle.
    Technologies: Visio, Microsoft Project, Microsoft SQL Server, Oracle, C++
  • Business Analyst and Senior Developer

    1999 - 2003
    Intouch
    • Analyzed, designed, developed, and deployed regional projects in Latin America.
    • Customized applications based on local regulations (Argentina, Chile, Paraguay, and Colombia).
    • Trained the key users.
    Technologies: Microsoft Visio, Microsoft Project, Microsoft SQL Server, Oracle, C++

Experience

  • Data Architect Data Warehouse and Analytics for a Regional BI Solution in the Healthcare Industry

    I designed, defined, and implemented end-to-end solutions for the regional data warehouse of one of the most important companies in the pharma industry. This included database design, data ingestion strategy (ETL), and reporting using PowerBI.

  • DevOps and Data Engineer Lead for Design and Implementation of Airflow and ETL for a Gaming Platform

    I defined the best strategy and implemented an Airflow infrastructure in AWS in order to create staging and production environments.
    I also defined best practices in Airflow development and coached the rest of the team.
    I designed, developed, and deployed multiple data pipelines in Airflow including multiple sources and targets (API's, S3, and PostgreSQL).

  • Design and Implementation of Data Pipelines for a Supply Chain Management Company

    Defined and implemented data pipelines strategy in order to process data from different sources into different targets including S3, PostgreSQL, and Elasticsearch using Elastic API.
    Technologies: Python, Airflow, AWS, PostgreSQL, and Elasticsearch

  • Design and Implementation of an End-to-end Solution for a Legal Tech Startup

    I designed and implemented a solution to integrate more than 300 different sources with different formats and types.
    I also designed and implemented a NoSQL database to store the data in Google Cloud using Cloud Firestore.
    Then, I defined the data strategy and implemented the data pipelines to ingest the multiple sources into the database.
    I extracted data from multiple sources, including web scraping (static and dynamic sites), REST API, JSON, CSV, Excel, and PDF files.
    Finally, I deployed a configured Apache Airflow environment using Google Composer and managed Kubernetes in GKE to deploy Selenium RemoteWebDriver.

    Technologies used: Python, Airflow, Google Cloud Storage, Google Cloud Composer, GKE, Google Cloud Firestore (NoSQL DB), Airtable API, specific domain libraries for scrapping (Beautiful Soup, Selenium), among others.

  • Data Pipelines Design and Implementation for One of the Most Important eCommerce Companies

    I led, designed, developed, and deployed ETL data pipelines for extracting data from multiple sources including Snowflake and S3 to be ingested in multiple targets, such as S3, Elasticsearch, Redis, and Snowflake using Python and Airflow.

  • Database Architect and DBA for Design, Deployment, and Administration of Learning Management System

    As the database architect and DBA, I was in charge of the model and design of the database, tables, roles, and permissions for a learning management system.
    The DB is a PostgreSQL deployed in Azure.
    I was responsible for the administration (backups, optimization, authentication with Azure), analytics, and DB analysis and reporting using a complex SQL.

  • DBA ( Security, Backups, Tunning and Optimization) in The Banking Industry

    Responsible for database administration, including:
    •Security via roles and permissions and authentication
    •Backup policy
    •Tunning and optimization (index creation, partitions, SQL queries tunning)
    •Store procedures

  • Led, Designed and Developed ETL Data Pipelines for One of The Most Important Banks

    Defined the data strategy, designed, developed, and deployed data pipelines to ingest large amounts of data from multiple types of sources into the warehouse including APIs, S3, PostgreSQL, Oracle, and Redis.

  • NoSQL Solution Design and Implementation for an eCommerce Company

    I defined, designed, and implemented a NoSQL solution for the catalog of an eCommerce company using MongoDB and Elasticsearch.
    I defined data strategy, design and implemented data pipelines to ingest data into the DB using Python and Airflow.

Skills

  • Languages

    Python, SQL, Stored Procedure, Snowflake, C++, XML, Excel VBA, Bash Script
  • Libraries/APIs

    Slack API, Twitter API, Telegram Bot API, JSON API, RequireJS, Flask-RESTful, REST APIs, Pandas, PySpark, Selenium WebDriver, Beautiful Soup
  • Tools

    Apache Airflow, Microsoft Power BI, Toad, Jira, Informatica PowerCenter, Informatica ETL, MongoDB Shell, SSRS, AWS CloudFormation, AWS IAM, Kibana, Microsoft Excel, Microsoft Visio, Excel 2016, SQL Server BI, DTS, Oracle Warehouse Builder (OWB), Control-M, Microsoft Project, Erwin, Visio, Google Kubernetes Engine (GKE)
  • Paradigms

    Business Intelligence (BI), Database Development, Procedural Programming, ETL, ETL Implementation & Design, Database Design, Requirements Analysis, API Architecture, REST API Architecture, Agile, PMBOK, Agile Software Development, Scrum, Split Testing, DevOps
  • Platforms

    Amazon Web Services (AWS), Jupyter Notebook, Oracle, Azure PaaS, Databricks, Heroku, Docker, Firebase, Anaconda, Unix, Linux, QlikView, Azure, Google Cloud Platform (GCP), Windows, Salesforce, Blockchain, Google Cloud SDK, Kubernetes
  • Storage

    Data Pipelines, Database Architecture, Redis, Azure SQL, JSON, Oracle RDS, PL/SQL, PL/SQL Developer, Oracle PL/SQL, ANSI SQL, MySQL, PostgreSQL 10.1, Databases, Database Modeling, Database Triggers, Database Backups, Database Replication, MongoDB, Elasticsearch, Google Cloud, NoSQL, Azure SQL Databases, Redshift, SQL Server Reporting Services (SSRS), Firebase Realtime Database, PostgreSQL, Teradata, Teradata Databases, MSSQLCE, Sybase, SQLite, Database Administration (DBA), Oracle DBA, SQL Server DBA, SQL Server 2008, IIS SQL Server, Database Security, AWS S3, Microsoft SQL Server, Cloud Firestore, Google Cloud SQL
  • Industry Expertise

    Banking & Finance, Trading Systems, Project Management, Healthcare
  • Other

    AWS, Analysis, Analytics, Data Analysis, Data Engineering, CSV File Processing, Data Architecture, Data Cleaning, Data Cleansing, Complex Data Analysis, Equity Investment, Logistics, Supply Chain, Reporting, Key Performance Indicators (KPIs), Dashboards, Investments, Capital Advisory, Financial Options, Futures & Options, Options Trading, Stock Trading, Options Theory, Option Pricing, Stock Price Analysis, Stock Analysis, Stock Market, IT, Information Technology, Software Design, Software Development Management, Software, IT Operations, Software Development, Software Project Management, Dashboard Design, Data Reporting, Data Analytics, Database Analytics, Supply Chain Management (SCM), Azure SQL Data Warehouse (SQL DW), Telegram Bots, JSON REST APIs, Unix Shell Scripting, PL/SQL Tuning, Project Lifecycle, Project Planning, Project Delivery, Project Design, IT Projects, Project Timelines, Office 365, Informatica, ETL Tools, ETL Development, ETL Testing, Warehouses, Data Warehousing, Data Warehouse Design, Leadership, Leadership Development, Team Leadership, Technical Leadership, Project Leadership, Cross-functional Team Leadership, Integration, IT Support, Requirements, Requirements & Specifications, User Requirements, Business Requirements, Projects, Product Demonstrations, Jupiter, Google BigQuery, APIs, Big Data, Finance Reports, Investment Banking, Commercial Banking, Bonds, Futures, Market Risk, Stock Exchange, MWAA, Infrastructure, IT Infrastructure, AWS DevOps, Pharmaceuticals, Azure Data Lake, Azure Data Factory, Airtable, Firebase Cloud Functions, Machine Learning, SQL CTEs, SAP, SAP BW, SAP SD, Cognos 10, MicroStrategy, QA Leadership, Quality Assurance (QA), Apache Cassandra, Agile Sprints, Scrum Master, Certified ScrumMaster (CSM), Project Management Professional (PMP), PMI, Shell Scripting, Sumo, Amplitude, Trading, IT Project Management, Scraping, PDF Scraping, Web Scraping, Selenium IDE, Database Schema Design, BI Reporting, Analytical Dashboards, Data Analyst
  • Frameworks

    Django, Flask, Spark, Selenium

Education

  • Financial Market Expert in Economics
    2015 - 2016
    National Technological University (UTN) - Buenos Aires, Argentina
  • Bachelor of Engineering, Information Technology in Systems Engineering
    1998 - 2015
    Buenos Aires Engineer University (UBA FIUBA) - Buenos Aires, Argentina

Certifications

  • Astronomer Certification for Apache Airflow Fundamentals
    MARCH 2021 - PRESENT
    Astronomer
  • Project Management Professional (PMP)
    NOVEMBER 2017 - PRESENT
    UTN
  • SAP BW
    MARCH 2010 - PRESENT
    SAP
  • SAP SD
    JANUARY 2010 - PRESENT
    SAP
  • Database Tunning and Optimization
    MAY 2009 - PRESENT
    Oracle
  • Oracle Database Designer
    JANUARY 2000 - PRESENT
    Oracle
  • Oracle PL/SQL Developer
    JANUARY 2000 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others