About
With over 16 years of experience in technology projects, I have focused on various facets including data analysis, data engineering, data management, business intelligence, data science, cloud computing, integration, and legacy systems.
Senior Data Engineer
Highly experienced and extensive knowledge in multiple fields of data engineering, such as:
- Data architecture and modeling
- Data integration
- Data warehousing, BI, data analysis and visualization
In addition, I have a broad understanding and practical experience in cloud computing architectures, including:
- IaaS, PaaS and SaaS models
- Data platform AWS, GCP and Azure projects
- On-premises migrations and integrations to cloud systems
Furthermore, I have experience in aspects of general data management, covering:
- Master data management
- Data governance and maturity models
- Data quality
Languages
- Spanish – Native
- English – Full professional proficiency
Skills
Analytics and Data Visualization
Data Engineering
Cloud Data Services
Programming
Soft Skills
Problem-solving, Self-direction, Leadership, Adaptability, Research, Effective communication
Experience
Professional
Senior BI Engineer
2021 - Present
Scotiabank
- As a Senior BI Engineer at Scotiabank in Canada, I am responsible for leading technical initiatives, developing, and maintaining data projects within the risk management area. I utilize technologies such as SQL Server, SSIS, Python, and Power BI.
Data Engineer
2020 - 2021
Perficient Latam
- As a Data Engineer at a prominent healthcare company in the USA, I played a crucial role in constructing data pipelines within Google Cloud Platform (GCP), facilitating data transfer from Cloud SQL to BigQuery using Airflow. Additionally, I contributed to data modeling and created analytical views in Google BigQuery.
Data Strategy Consultant
2019 - 2020
Keyrus
- As a Data Consultant for the largest FMCG company in Costa Rica, I designed, developed, and implement processes, policies, and metrics pertaining to data governance and data quality. These initiatives served as the foundation for the successful implementation of Informatica MDM tools.
- As a Data Architect and Developer for companies in the USA and Colombia, I built end-to-end data solutions with a diverse set of technologies such as Snowflake, Tableau, MySQL, Python, AWS Aurora PostgreSQL, Azure Data Factory, Azure SQL Server, and Power BI.
Migration and Integration Leader
2018 - 2019
ASOPAGOS
- As a Tech Lead Data Dev at one of the largest healthcare groups in Colombia, I spearheaded a team responsible for migrating and integrating data from various legacy systems, including Excel, PostgreSQL, SQL Server, and other relational databases on Azure SQL Server. Additionally, I developed a customized and cost-effective data integration and quality solution utilizing T-SQL.
Senior Database Consultant
2013 - 2018
SBD SAS
- As a DB Consultant, I engaged with national and international companies, including the largest datacenter in Latin America. My work spanned data administration, Big Data, Data Quality, BI, Analytics, and large-scale migration projects, including an architecture overhaul from SQL Server 2008 R2 to SQL Server 2012 using Always On technology.
Data / IT Administrator
2010 - 2013
Carvajal Información S.A.
- As a Database Administrator (DBA) in a prominent marketing industry firm, my responsibilities included proficiently managing SQL Server 7, 2000, and 2005 servers. Within the Datacenter Migration Project, I was an important part of the migration of the database platform for web portals. This involved transitioning from a mixed environment (physical and virtual) to an AWS IaaS environment.
- Furthermore, in my capacity as an Acting Tech Lead, I took charge of the strategic dismantling and reconfiguration of database servers, orchestrating their relocation from the Carpathia Phoenix Data Center to the NAP of the Americas Miami Data Center.
Data / UNIX Consultant
2008 - 2009
SunGemini S.A.
- In my role as a Database Administrator (DBA) for two of the largest companies in the oil industry, my primary responsibility was the administration of Oracle servers, including versions 7, 8.0.3, and 10g. Additionally, I successfully executed full-scale server migrations, transitioning several servers from Oracle 7 and 8.0.3 to Oracle 10g
Data Analyst
2006 - 2008
Servicio Occidental de Salud
- In my role as a Database Administrator (DBA) at S.O.S., a healthcare organization, my responsibilities encompassed the administration of SQL Server versions 7, 2000, and 2005. Additionally, I played a pivotal role in the seamless migration of the company's core systems, transitioning them from SQL Server 2000 to SQL Server 2005 across all servers
Entrepreneurial
Co-Founder and CTO
2017 - 2021
SQL Dr.
- I served as the Co-Founder and CTO of SQL Dr., a startup where we pioneered a novel, cost-effective model for remote database administration tailored to medium and large-sized companies.
- In my role as a Developer, I conceptualized, developed, implemented, and administered a cost-efficient, fully functional tool for managing, inventorying, and reporting on multiple database servers.
- As a Data Analyst and Visualization Developer, I crafted a diverse array of dashboards and reports using Power BI and R.
Co-Founder and CTO
2009 - 2010
Binaryx
- Co-founded and held the position of CTO at Binaryx, a startup dedicated to delivering data-centric web portals for government agencies. Our company specialized in constructing and overseeing web portals featuring data statistics visualizations for various government entities.
Education
Academic Degree
BEng in Computer Engineering
2011
Universidad Cooperativa de Colombia
Certifications
- Microsoft – Microsoft Certified Professional: Microsoft Certified Professional
- Microsoft – Microsoft Certified IT Professional: Database Administrator
- Microsoft – Developing SQL Data Models
- Microsoft – Microsoft Certified Technology Specialist: SQL Server, Implementation and Maintenance
- Microsoft – Implementing a Data Warehouse using SQL
- Microsoft – Querying Data with Transact-SQL
- Microsoft – Analyzing and Visualizing Data with Microsoft Power BI
- HarvardX – Data Science: R Basics
- Alteryx – Alteryx Designer Core
- Tableau – Tableau Desktop Specialist
- Microsoft – Microsoft Certified: Azure Data Fundamentals
Courses
- Microsoft – Implementing a Microsoft SQL Server 2005 Database
- Microsoft – Maintaining a Microsoft SQL Server 2005 Database
- Red Hat – Linux Advanced, Red Hat Cluster Suite
- New Horizons – Oracle Advanced 10G
- Agein Consulting Services – ITIL V3 Fundamentals
- Microsoft – Double Take for SQL Server
- Microsoft – SQL 2008 for Administrators
- Amazon – Data Analytics Fundamentals