Carlos Andrés Castaño Varela
Verified Expert in Engineering
Data Developer
卡洛斯是一位经验丰富的数据工程师，他利用了他以前的制造业经验, eCommerce, 和创业知识，有效地为客户提供有意义和高质量的解决方案. 卡洛斯对数据有很大的热情，渴望解决新的挑战，并随时提供帮助.
Portfolio
Experience
Availability
Preferred Environment
Windows Subsystem for Linux (WSL), Ubuntu, MacOS, Amazon EC2, Apache Airflow, Amazon RDS, Amazon QuickSight, Tableau, Visual Studio Code (VS Code), Git
The most amazing...
...我开发的是一个完整的端到端数据解决方案，为客户带来可见性和新的商业理念.
Work Experience
Power BI Developer
Molyworks Materials Corp
- 使用Azure SQL数据库(基于MS SQL Server)设计并实现了一个数据仓库.
- 在Azure Data Factory中构建了10多个管道，作为一个ETL进程，从不同的数据源(如Excel文件)提取数据, MS SQL Databases (on-prem), and Gsheets.
- 根据存储在DWH中的数据创建了10多个MS Power BI报告，这些报告提供了对流程的见解.
Senior Software Engineer
EPAM Systems
- 在客户的ETL工具中开发了几个管道，为进一步的数据分析提供信息，并迅速获得了客户基础设施的专业知识.
- 基于之前的流水线工作，创建并更新了几个Tableau仪表板.
- 设计复杂的SQL查询，从多个数据源中提取信息，为报告做准备.
Data Engineer
Water UX, Inc
- 使用规范化技术和Apache Airflow开发了一个ETL流程，用于将数据从PostgreSQL实例提取到另一个实例.
- 设计并实现了一个PostgreSQL数据库模式，用于存储web应用程序中使用的规范化数据.
- 使用Python和Pandas创建基于用水量数据的分析报告.
Data Analyst | Engineer
LaHaus
- Delivered an end-to-end data extraction, conversion, data quality, loading, and analytics solution to bring visibility to an entire company area.
- Managed ETL data available in different APIs, such as CRM and social networks, to provide insights into the marketing process.
- 使用数据创建有意义的仪表板，以支持公司不同领域的决策过程.
- 创建了一个机器学习模块，并在FastAPI端点中公开了结果.
PrestaShop Developer
Freelance
- 通过自定义修复严重影响用户体验的性能不佳的第三方模块，对网页加载时间进行了改进.
- 创建PrestaShop网站，存储在云位置，自定义集成，提供完整的电子商务解决方案.
- 对网站的各个方面和功能进行了一些定制, including themes, shipping, and pricing.
- 构建了生产和登台环境，以及用于开发和测试的简单CI/CD流程.
IT Coordinator
Acesco Colombia
- Managed high-level contracts of licensing renewal, IT assets procurement, and vendor services, 始终以最佳成本效率为目标，保持内部客户满意度.
- 创建带有业务数据的指示板、见解和报告，用于内部分析.
- 管理IT和安全审计，设计和执行安全策略.
Automation Engineer
Acesco Colombia
- 委托机器自动化工程数据存储网络，为机器故障和意外停机的过程变量的工程分析提供基础.
- 协助全球技术和机器的采购过程，与供应商互动，并确保以尽可能低的成本实施最新技术.
- 参与制造工艺设备的改造项目，以保持公司资产的理想状态.
Experience
Data Analytics Web App for the Water Sector in California
ETL Process for Marketing Data
Random Forest Model FastAPI
Data Extraction Tool for Process Engineering
eCommerce Website
Skills
Languages
SQL, Python, Snowflake, PHP, JavaScript
Libraries/APIs
Pandas, Scikit-learn, TensorFlow
Tools
Microsoft Power BI, Apache Airflow, Tableau, PrestaShop, Git, Power Pivot, GitHub, Amazon QuickSight, Amazon Athena
Platforms
Amazon EC2, Ubuntu, Windows, Amazon Web Services (AWS), Azure, SharePoint, MacOS, Visual Studio Code (VS Code)
Storage
Databases, PostgreSQL, Data Pipelines, Microsoft SQL Server, Memcached, Redshift, Azure SQL Databases, Azure Blobs
Other
Windows Subsystem for Linux (WSL), Process Automation, Power Electronics, Projects, Waterfall Methodology, Siemens PLC, Variable Frequency Drive (VFD), Motion Control, ETL Tools, Data Analytics, Dashboards, Data Analysis, Analytics, Data Visualization, BI Reporting, Data Scraping, Amazon RDS, APIs, Data Quality, Data Engineering, Data Management, Data Warehousing, Azure Data Factory, DAX, Dash, Networking
Paradigms
PMBOK, ETL, Business Intelligence (BI), Data Science
Education
Postgraduate Degree in Engineering Project Management
The University of the North - Barranquilla, Colombia
Bachelor's Degree in Electronics Engineering
The University of the North - Barranquilla, Colombia
Certifications
Data Science for All (DS4A)
Correlation One
How to Work with Toptal
在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring