Experience

Nagnoi, LLC

• Puerto Rico
• Data Infrastructure and Analytics
• 1 - 100 Employee

• Software Engineer II

  • Jan 2022 - Present

  Customer: Triple-S Achievements: • 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. Main responsibilities: • Responsible for Business Intelligence development: in health systems such as the reconciliation process. • In charge of optimization, automation, and implementation of process quality controls. • Responsible for the analysis and generation of Information through ETL processes. • Manage the development, implementation, and maintenance of T-SQL processes, SSIS (SQL Server Integration Services) • Manage and oversee data asset consistency and integrity. Show less



everis

• Spain
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Development Consultant

  • Oct 2018 - Oct 2021

  Customer: Banco De Bogota• 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.Main responsibilities:Business Intelligence development: in banking systems such as Garnishments,Expense and Collection Modules and Magnetic MediaOptimization, automation and implementation of process quality controlsAnalysis and generation of Information through ETL processesImplementation and maintenance of Oracle PL / SQL processesDevelopment and maintenance of UNIX BASH - Shell processes Show less

• Senior Development Consultant

  • Jun 2018 - Sep 2018

  Customer: Banco Popular (3 month project)Responsibilities:Developer in Data Quality Control ProjectOptimization, automation and implementation of process quality controlsAnalysis and generation of Information through ETL processesImplementation and maintenance of Oracle PL / SQL processesDevelopment and maintenance of UNIX BASH - Shell processes



Management And Quality

• Colombia
• Business Consulting and Services
• 1 - 100 Employee

• Development Engineer

  • Jun 2017 - May 2018

  Customer: Telefónica Movistar Colombia Responsibilities: Data Warehouse Project Implementation Process optimization and automation Implementation of quality controls DataStage Management in ETL processes Oracle PL / SQL management Development and maintenance of UNIX BASH - Shell processes Analysis and generation of Information Teradata Management Customer: Telefónica Movistar Colombia Responsibilities: Data Warehouse Project Implementation Process optimization and automation Implementation of quality controls DataStage Management in ETL processes Oracle PL / SQL management Development and maintenance of UNIX BASH - Shell processes Analysis and generation of Information Teradata Management



Nueva EPS

• Colombia
• Insurance
• 700 & Above Employee

• Junior Data Base

  • Dec 2016 - Jun 2017

  • Successfully contributed to complete annual report to the Health Department in one week by managing and processing high volume of data to classify it to comply with local government requirements and deadlines. Responsibilities: Process optimization and automation Implementation of quality controls Oracle PL / SQL management ETL process Analysis and generation of Information Internal customer support • Successfully contributed to complete annual report to the Health Department in one week by managing and processing high volume of data to classify it to comply with local government requirements and deadlines. Responsibilities: Process optimization and automation Implementation of quality controls Oracle PL / SQL management ETL process Analysis and generation of Information Internal customer support



Claro Colombia

• Colombia
• Telecommunications
• 700 & Above Employee

• Activations Analyst

  • Jan 2014 - Nov 2016

  Achievements: • Contributed to identify and alert proper authorities about fraudulent transactions involving 5K tablets provided to unauthorized clients. • Analyzed eight months of data to uncover fraud scheme involving the unauthorized transfers (port in and out) of multiple line blocks which resulting in escalating the situation and saving the company millions in fraudulent commissions. Responsibilities: Process optimization and automation Implementation of quality controls Oracle PL / SQL management Analysis and generation of Reports Internal customer support Administrator, application developer and In-house databases Analysis, extraction, transformation and loading of information in Datamart Show less