SUMMARY OF QUALIFICATIONS
Over 9 years of experience in ETL processes, working in Data Warehousing and other kinds of data-driven projects;
Expert in Oracle Data Integrator (8 years’ experience), including:
Installation and configuration;
Repositories and user’s administration;
Knowledge modules (load strategies) customization;
Java, Jython and PL/SQL development;
Interfaces, functions and procedures implementation;
SQL performance tuning;
Change Data Capture implementation (CDC);
Slowly Changing Dimension (SCD) setup for DW projects;
Deployment and Load Plan management;
Installation, utilization and deployment guide documentation.
Demonstrated ability working with Informatica PowerCenter and Oracle Warehouse Builder (OWB);
Enthusiast of best practices and process improvements initiatives.
Senior Data Integration Consultant 2014 – Present
DBServer, Porto Alegre, Brazil. Contractor at Ticket Log.
ODI development team lead, responsible for implementation, maintenance, tuning, troubleshooting and administration of ETL processes, regarding the fields of Data Warehouse, Geoprocessing and others.
Highlighted achievements and performed tasks:
Improvements on Oracle Data Warehouse load processes: reduction of execution time of up to 50%. Techniques utilized: SQL tuning, table partitioning and ODI KMs customization (Java / Jython);
Java programing to integrate SAP Business Objects repository metadata into Oracle monitoring tables through ODI;
ODI repositories management for Disaster Recovery project;
Josué Borges Page 2 of 3
Responsible for providing customized architectural solutions for heterogeneous environments integration (Oracle, Sybase, PostgreSQL, xml, flat files);
Mentorship for less experienced developers.
Senior Data Integration Consultant 2012 – 2013
DBC Company, Porto Alegre, Brazil
Responsible for requirements gathering, modeling, developing and maintenance of Oracle Data Integrator interfaces to integrate ERP and legacy systems for the Rio Grande do Sul industries federation, also utilizing skills in PL/SQL, xml and java.
Software Development Sr. Analyst 2012
Stefanini IT Solutions, Porto Alegre, Brazil
Worked as contractor for Dell Inc. Brazil, responsible for requirements gathering, technical design specifications and data integration solutions development for several projects of Dell Financial Services department, in geographically distributed teams (Brazil / US / Asia). Technical skills utilized:
Processes implementation with Informatica PowerCenter;
Control-M jobs scheduling;
Oracle 10g procedures and data manipulation.
ETL/ODI Specialist 2011 - 2012
Getnet, Porto Alegre, Brazil
Responsible for requirements gathering and dimensional modeling for Oracle Data Warehouse specification. Also performed a set of ODI development tasks, including:
ETL processes implementation, extracting data from PostgreSQL, Sybase and Oracle databases;
Data Marts load processes tuning;
CDC and SCD implementation for DW load processes;
SQL execution plans optimization;
ODI load strategies customization for performance improvements;
Data quality processes development.
Josué Borges Page 3 of 3
ETL Consultant 2010 - 2011
Advanced IT, Porto Alegre, Brazil
Worked directly with customers on data-driven initiatives. Most relevant projects were the following:
Dimensional modeling and ETL processes implementation using ODI for Data Warehouse project at Getnet company.
Data integration processes development with Oracle Warehouse Builder for Brazilian energy power company’s Data Warehouse.
Also served as a technical instructor for Advanced IT employees, training them in Oracle Data integrator development.
Business Intelligence Consultant 2009 - 2010
Carpio Solutions, Porto Alegre, Brazil
BI Consultant at a banking sector customer. Worked with ETL processes implementation, troubleshooting and data load validations in an environment which aggregate an Oracle Data Warehouse and Hyperion Essbase applications used by
Corporate Financial Planning department. Technical skills utilized were related to PL/SQL, Hyperion Essbase applications and shell script development.
Systems Analyst 2008
Keyrus, Porto Alegre, Brazil
Worked as a systems analyst on a data integration project for the Brazilian National Council of Justice, to concentrate all the information of judicial processes coming from the national states in a unified Oracle datacenter.
Responsible for requirements gathering, artifacts nomenclature definitions and development of connections topology through ODI to make the integration processes feasible were the activities carried out in the project.
Undergraduate degree in Systems Analysis and Development (3 years) 2017
Universidade do Vale do Rio dos Sinos - UNISINOS
Available Upon Request