joao augusto -

Aubay / TAP Portugal – Remote | Senior Consultant ETL DataStage | 2024 – Present • ETL Developer for migration, process adjustments, and performance tuning. • Defined solution architecture, analyzed functional requirements, and created technical documentation. • Estimated development efforts and ensured process documentation in Confluence.

• Tuning and optimization of ETL and Oracle processes, PL/SQL. • Development of complex DataStage jobs, Oracle procedures, and Unix scripts.

Project: TAP Air Portugal ETL developer, working on creating and maintaining complex jobs on DataStage. I'm responsible for design and development Integrations using Datastage Jobs and SQL for extract source data from AMOS - SWISS AS

Responsible for design and development Integrations using Datastage Jobs and SQL for extract source data from ORACLE JDE for load in a new version for JDE E1 at CARGILL Argentina.

Customer TIM Brazil / Project BIG DATA • Collection of information for the creation of the documentation (Implementation Document, Functional Document) for the application of the Big Data solution in the project Evolution of BI involving the areas of Billing, Refills, PABX, CRC Service and URA. • Development of management reports using Power BI as Front-End tool.

Customer TIM Brazil / Project BI Factory • Development of several demands of the BI plant, among them the development of a project of high visibility • Requirements gathering, development of technical and functional specifications.

Customer TIM Brazil / Project BI Factory • Development and maintenance and new ETL DataStage and PowerCenter Intelligence process functionalities; • Creation of management reports using Oracle Discoverer; • Maintenance and development of Shell Script; • Coordinator of the Ongoing team with 24x7 attendance of all the projects in production; • Providing Ad-hoc reports for end user; • Responsible for gathering business and technical requirements, and writing technical and functional specifications of the Integration BI tools and developing the solution written (extraction, transformation and loading -ETL); • Multidimensional Data Modelling (Conceptual, Logical and Physical); • Tuning & Optimization practices of ETL and Oracle processes; • Development of complex programs in DataStage, Oracle and Unix scripts; • Responsible for the invoice deactivation and migration of the server on the processes scheduled in Crontab; • Responsible for various projects such as: Faturamento, Recarga, Régua de Incentivo, Tim Casa, Arrecadação, Siebel, Trafego, ChipOnly, Nono Digito São Paulo, Bollone, Carteira Cooperativa, Promoções, Relatórios esporádicos, CPCRM Ultimas Faturas, CRC.