Daniel Chaul
Verified Expert in Engineering
Software Developer
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.
Portfolio
Experience
Availability
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.
Work Experience
Data Engineer Manager
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.
Data Engineer | Architecture Manager
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.
Data Architect | Data Engineer Lead
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.
Data Architect | Data Engineer Lead
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.
Data Engineer Lead
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.
DBA | ETL Lead
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.
Project Leader
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.
Business Analyst and Senior Developer
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.
Experience
Data Architect Data Warehouse and Analytics for a Regional BI Solution in the Healthcare Industry
DevOps and Data Engineer Lead for Design and Implementation of Airflow and ETL for a Gaming Platform
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
Technologies: Python, Airflow, AWS, PostgreSQL, and Elasticsearch
Design and Implementation of an End-to-end Solution for a Legal Tech Startup
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
Database Architect and DBA for Design, Deployment, and Administration of 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
•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
NoSQL Solution Design and Implementation for an eCommerce Company
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, T-SQL (Transact-SQL), 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, AWS CloudFormation, AWS IAM, Kibana, Microsoft Excel, Microsoft Visio, Excel 2016, SQL Server BI, DTS, Oracle Warehouse Builder (OWB), Microsoft Flow, Microsoft Teams, Control-M, Microsoft Project, Erwin, Visio, Google Kubernetes Engine (GKE), BigQuery
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), Azure SQL Data Warehouse, Jupyter Notebook, Oracle, Microsoft Power Automate, Dedicated SQL Pool (formerly SQL DW), 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, PostgreSQL, Databases, Database Modeling, Database Triggers, Database Backups, Database Replication, MongoDB, SQL Stored Procedures, Database Migration, Elasticsearch, Google Cloud, NoSQL, Azure SQL Databases, Redshift, SQL Server Reporting Services (SSRS), Firebase Realtime Database, Teradata, Teradata Databases, MSSQLCE, Sybase, SQLite, Database Administration (DBA), Oracle DBA, SQL Server DBA, SQL Server 2008, IIS SQL Server, Database Security, Amazon S3 (AWS S3), Microsoft SQL Server, Cloud Firestore, Google Cloud SQL
Industry Expertise
Banking & Finance, Trading Systems, Project Management, Healthcare
Other
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 Management (ITOM), Software Development, Software Project Management, Dashboard Design, Data Reporting, Data Analytics, Database Analytics, Supply Chain Management (SCM), 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, Entity Relationships, Data Modeling, Jupiter, Google BigQuery, APIs, Big Data, Finance Reports, Investment Banking, Commercial Banking, Bonds, Futures, Market Risk, Stock Exchange, Amazon Managed Workflows for Apache Airflow (MWAA), Infrastructure, IT Infrastructure, AWS DevOps, Pharmaceuticals, Azure Data Lake, Azure Data Factory, Airtable, Firebase Cloud Functions, Machine Learning, SQL CTEs, SAP, SAP Business Warehouse (BW), SAP Sales and Distribution (SAP SD), Cognos 10, MicroStrategy, QA Leadership, Quality Assurance (QA), Apache Cassandra, Agile Sprints, Scrum Master, Certified ScrumMaster (CSM), Project Management Professional (PMP), PMI, Cloud, Microsoft Office, Shell Scripting, Sumo, Amplitude, Trading, IT Project Management, Scraping, PDF Scraping, Web Scraping, Selenium IDE, Database Schema Design, BI Reporting, Analytical Dashboards, RESTful Microservices
Frameworks
Django, Flask, Spark, Selenium
Education
Financial Market Expert in Economics
National Technological University (UTN) - Buenos Aires, Argentina
Bachelor of Engineering, Information Technology in Systems Engineering
Buenos Aires Engineer University (UBA FIUBA) - Buenos Aires, Argentina
Certifications
Astronomer Certification for Apache Airflow Fundamentals
Astronomer
Project Management Professional (PMP)
UTN
SAP BW
SAP
SAP SD
SAP
Database Tunning and Optimization
Oracle
Oracle Database Designer
Oracle
Oracle PL/SQL Developer
Oracle
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring