luis ospina

Experienced and results oriented Systems Engineer with high analytical and execution capacity to optimize and design solutions that support business intelligence systems and process improvement initiatives. Effectively with Datawarehouse management, data migration, data quality control, SQL Server, Oracle PL, and ETL processes. My main focus has been on developing high quality information solutions to businesses needs. Effectively provides architectural assessments, designing and implementing integration services, and developing technology roadmaps. Experience with migration and configuration projects and evaluating and recommending technical solutions for complex projects. Able to conduct process mapping and analysis to identify opportunities with automation. Responsible for the development, maintenance, and quality control of centralized data warehouse, ensuring data integrity and accessibility across the organization. Ability to collaborate cross functionally to drive complex business needs to successful completion.

Some of my areas of expertise include:

- Business Intelligence
- Problem Solving
- Data analysis
- Data Migration
- Data Quality Control
- Data warehouse Management
- General Reporting and Analysis
- File Generator 
- Process Improvement

 

Nagnoi / Consultoría IT Puerto Rico 

Software Engineer II 

Client: Triple-S January 2022 – To Present

 • Business Intelligence development: in health systems such as the reconciliation process 

• Optimization, automation and implementation of process quality controls 

• Analysis and generation of Information through ETL processes 

• Development,Implementation and maintenance of T-SQL processes, SSIS (SQL Server Integration Services) Ahievements: 

• Total automation of the Triple S reconciliation process with the Administración de Seguros de Salud-Vital (ASES) which migrated from a manual process in EXCEL to a totally integrated ETL system with SSIS.

EVERIS Colombia / Consultoría IT Española 

Development Consultant 

Client: Proyecto Banco Bogotá October 2018 - October 2021 

• Business Intelligence development: in banking systems such as Garnishments 

• Expense and Collection Modules and Magnetic Media 

• Optimization, automation and implementation of process quality controls 

• Analysis and generation of Information through ETL processes 

• Implementation and maintenance of Oracle PL / SQL processes 

• Development and maintenance of UNIX BASH - Shell processes 

Ahievements: 

• Successfully contributed in damage control actions by recovering data and re-building a lost database in less than 45 days (initial phase) which included analyzing spreadsheets and mapping out all historic data to solve emergency loss of critical data. • Became a Senior Advisor and go-to person to detect failures in processes and solutions design.

System Engineer - B.A. - 2012

Database Development Specialist Postgraduate - 2019