Summary
Overview
Work History
Education
Skills
Websites
Languages
Certification
Timeline
Generic

Daniel Andrés Alfonso O.

Bogotá

Summary

Systems engineer, with the capacity to analyze issues and opportunities, providing optimal solutions on a strategic level. Fast learning and familiarization with new tools and technologies, good teamwork, and adaptability to change. 8+ years' experience in tech areas with different tools and branches like web programming, design and development of databases (SQL Server), creation and administration of reports and design and development of ETL and Data solutions.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Accounting Data Reconciliation Sr Analyst

Clip
Bogotá
05.2024 - Current
  • Design and develop data pipelines for the transactional reconciliation between company data and external transactional data in Snowflake and Databricks SQL, making different data ingestions and outputs according to the stakeholders' necessities.
  • Create Databricks jobs for pipeline executions.
  • Create Apache Airflow DAGs for orchestration of job executions.
  • Develop Python solutions to extract reconciliation data to different targets (CSV, TXT, JSON, S3).
  • Design BI reports on the Sigma tool.
  • Support and optimize existing reconciliation processes with SQL and Spark SQL.

BI Consultant

Samtel Consultores
Bogotá
09.2022 - 05.2024
  • Design and develop the ETL process in SQL Server Integration Services tools (SSIS), using different sources and destinations, such as SQL Server, Oracle, text files, CSV files, Amazon Redshift, and Amazon DynamoDB.
  • Working with customers to develop new solutions to improve the quality of information flow to the DWH.
  • Create and modify objects in SQL Server (tables, stored procedures, views, jobs).
  • Analyze, design, develop, test, and deploy information projects made with SQL databases.
  • Support for existing customer developments made in SSIS.
  • Creating objects like tables, stored procedures, and materialized views in Amazon Redshift.
  • Design custom reports in Power BI.

Junior Consultant

SETI S.A.S
Bogotá
11.2021 - 09.2022
  • Develop the ETL process in SQL Server Integration Services tools (SSIS) and Informatica PowerCenter.
  • Support different company areas with functional assignments required by clients.
  • Analyze, design, develop, test, and deploy information projects made with SQL databases.
  • Create and modify objects in SQL Server (tables, stored procedures, views, jobs).
  • Support for developments made by SETI S.A.S in integration services (SSIS).

ODS Junior Developer

Banco de Occidente
Bogotá
07.2021 - 11.2021
  • Data extraction management directly from Oracle and SQL Server databases.
  • Modify and restructure existing ETLs in DataStage and ODI (basic).
  • Query construction for data extraction.

Developer

Equipos Técnicos y Logística S.A
Bogotá
11.2019 - 06.2021
  • Analysis and control of actual developments.
  • Improve and rebuild developments, giving them an MVC architecture.
  • Design and develop new web applications to improve the response time to the final client, and to generate reports to help in decision-making. All of this is under SCRUM methodology.
  • Design and creation of reports with Reporting Services (SSRS) and SQL Server, starting from writing the initial queries, stored procedures, jobs, etc.

Database Analyst

Megalinea S.A
Bogotá
06.2018 - 05.2019
  • Database support and development according to the intern's client requirements.
  • Analysis and QA of databases.
  • Promote ideas for new tools based on information from database analysis.
  • Design and creation of reports with Reporting Services (SSRS) and SQL Server, starting from writing the initial queries, stored procedures, jobs, etc.
  • ETL development for data transformation, reports, and dimensioning.
  • New developments deployment.

Junior Developer

Equipos Técnicos y Logística S.A
Bogotá
10.2016 - 06.2018
  • Data analysis, development, and support of operative control reports.
  • Keep ERP process documentation and his configurations.
  • Promote ideas for new tools based on information from database analysis.
  • Optimize area processes by the development of new web applications.
  • Design and creation of reports with Reporting Services (SSRS) and SQL Server, starting from writing the initial queries, stored procedures, jobs, etc.

Education

IT, Systems Engineer -

Corporación Unificada Nacional De Educación Superior - CUN
Bogotá
10.2020

Skills

  • T-SQL coding
  • Power BI
  • ETL
  • SQL Server
  • SSIS (SQL Server Integration Services)
  • SSRS (SQL Server Reporting Services)
  • PHP
  • Snowflake
  • Data reconciliation
  • AWS lambda
  • Apache Airflow
  • Databricks
  • Python
  • DBT
  • Sigma

Languages

Spanish
First Language
English
Upper Intermediate (B2)
B2

Certification

  • Snowflake – The Complete Masterclass (2023 Edition) - Udemy
  • The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero - Udemy

Timeline

Accounting Data Reconciliation Sr Analyst

Clip
05.2024 - Current

BI Consultant

Samtel Consultores
09.2022 - 05.2024

Junior Consultant

SETI S.A.S
11.2021 - 09.2022

ODS Junior Developer

Banco de Occidente
07.2021 - 11.2021

Developer

Equipos Técnicos y Logística S.A
11.2019 - 06.2021

Database Analyst

Megalinea S.A
06.2018 - 05.2019

Junior Developer

Equipos Técnicos y Logística S.A
10.2016 - 06.2018

IT, Systems Engineer -

Corporación Unificada Nacional De Educación Superior - CUN

Similar Profiles

CREATE PROFILE
Daniel Andrés Alfonso O.