Design, development and implementation of ETL's in Visual Studio SSIS, for the migration project of the entity Consejo Superior de la Judicatura – CSJ. Design, development and implementation of dashboards in Power BI, for the project "Design the integration and interoperability of data and advanced analytics of the Colombian energy mining sector - Ministry of Mines and Energy". Perform technical and functional documentation.
Design and development of ETL's for generating Predictive Dialer reports, belonging to the Collections process, in Informatica PowerCenter. Design, development and implementation of reports in the Power BI tool. Design and development of ETL's for customer information, coming from CODENSA and the G&G application. Design, development and elaboration of Sources, Targets, Mappings and Workflows, reference tables, data profiles, quality rules and validation nodes.
Administration, data loading and development of the tool for monitoring and auditing the Call Center process at Banco Scotiabank Colpatria (ETL), using the Informatica Power Center and Informatica Data Quality (Analyst and Developer) tools. Design and development of the general architecture for the project "Public Expenditure Control and Surveillance Observatory - OCVGP", of the Comptroller General of the Republic (CGR).