ETL Developer

• Mar 2021 - Present

Data Warehouse Engineer

• Aug 2017 - Jun 2020

Responsible for the maintenance and development of the integration processes to the different platforms of the company, such as billing, reconciliation and costs. Active participation in the design, development, testing and implementation phases of the company's data warehouse project, using tools such as Pentaho - Spoon 5.7 and 7.1, MySQL, PostgreSQL, Redshift, S3 AWS, and Jira as Management tool for the use of scrum and repositories. Responsibilities: • Active participation in the design, develop, testing and implementation phases of the company's data warehouse project • Maintenance and development of the integration processes such as billing, cops and reconciliation. • Technical involvement for improvement projects across the company. • Prepare data and information for making regular report data analysis. • Perform data analysis for complex data and files. • Database maintenance, redshift. • Creating internal customer reports. • Python scripting to validate information created by ETL processes. • Participation in the project for the migration of Pentaho to Scala processes. Show less

ETL Developer - BI Consultant

• Oct 2015 - Aug 2017

Responsible for new developments and optimization of existing developments of DWH area of Claro Colombia, using tools such as IBM Cognos Datamanager for ETL and IBM Cognos Framework Manager, Report Studio and Analysis Studio for Reports. Responsibilities: • Estimation, planning, functional analysis, and monitoring requirements of Claro Colombia. • Design the solutions with the best practices and applying my previous experiences to create efficient solutions. • Create customized solutions that meet user requirements, using ETL (Extraction, Transformation, Load) process and generate reports or files which help users to take decisions. • Complete unit test to the solution created, based in the user requirements, and verifying the quality of the all developments created (ETL, Reports and files generated) • Accompany and guide the operational users in the implementation of the solutions created. Show less

ETL Developer - BI Consultant

• May 2013 - Oct 2015

Responsible of support to business clients, from different economic sectors, participating especially in implementation and development of projects, with tools such as Oracle Data Integrator, Oracle Warehouse Builder y Oracle BIEE (RPD, Answers, Dashboards). Responsibilities: • Responsible of support to business clients from different economic sectors • Participating especially in implementation and development of business intelligence projects • Customizing module Students of BIAPPS (Pre-built) in Oracle Data Integrator 11g • Support and development of the data warehouses to different clients and economic sectors. Show less

ETL Developer

• Dec 2012 - May 2013

Responsible for the properly functioning of the developments of 6 interfaces which are AS400, CRM, SIIF, HOST, VISA and SISCAR, either by own developments or with the management of suppliers. These developments were to be unified by ETLs through Oracle Data Integrator 11g.Responsibilities:• Responsible for the properly functioning of the developments of 6 interfaces which are AS400, CRM, SIIF, HOST, VISA and SISCAR.• Participation in integration projects using ETL tools• Management of suppliers. Show less

Training Professional

• Jun 2012 - Dec 2012

Responsible of the administration of the Service Manager tool and preparing the reports of the quality indicators of the service desk analysts. Additionally, developing, as practice project.Responsibilities:• Administration of the Service Manager tool.• Preparing the daily, weekly, monthly, bi-monthly and semi-annual reports of the quality indicators of the service desk analysts.• Developing, as practice project, a VBA application to facilitate the performance of a daily activity Show less