In charge of taking care of data engineering ingestions for Audlab.Audlab is a department of Auditor in Gerdau Company.Gerdau is one of most important enterprise in Brazil that works with iron and steel, producing several tools for different segments in the world.In this Tech department I provide a full control of repository in gitlab, deploying the respective scripts to be processed.However, the main tool to monitor and generate EMR cluster and process general scripts in python and pyspark through different assets is Control - M.Right here we do ETL and Data Science Scripts for machine learning and data transformation.I was one of core people that helps data migration steps from AWS ETL tools to Databricks.All scripts excuted by EMR clusters were replicated accordingly in Databricks.The migration was well successed!Finnaly working in Databricks!

GCP - Google Cloud PlatformStellantis - Datalake projectResponsible for creating tools to interect data at plataform.Tools used:Terraform;Google Storage;BigQuery;Google Functions;Airflow;Python;SQL.

Via Consulting - Project - Zendesk ReplicationContinuous pushing of data in a AWS environment using tools like: Pyspark Spark Glue jobs; Cloud Formation; AWS Athena; Apache Hudi metadata for data governance.Unimed Insurance - Project - Stuffed Wallet (Carteira Recheada)Colaborating with the team in a ETL process using tools like: Informatica Powercenter; PLSQL - Oracle.The idea of ​​the project is a campaign that supports the score of the company's brokers.Smiles S.A. - Project - Gol Spend & GetAWS Python lambda function that validates a files to be called by an API.Resources: Cloud Formation; Python with unit tests; Github release info; Jenkins to observe github uploaded code; Sonar for code quality; End of Devops stack with deploy.

AWS Management asset,Responsible for creating data pipelines to push data in S3 using python AWS lambda funtions.Using packages such as awswrangler, xmltodict, json and much more.Being involved in great projects with the relevant skills, accessing different APIs from several providers.Some of these ones are Volvo, Nuntec, Komatsu - Komtrax, Caterpillar and many others.Transforming XML and JSON API extrations into tabular data to be recorded in parquet table format, grating a better use of S3 bucket as much as gaing performance in a compressed file format.

Systems Management:Responsible for managing the SARA system, Logix, My Checklist & Customer Service Portal;Application of SARA customs system update packages;Updating of stored procedures in SQL;SQL Trigger Updates;Module Reviews among others;Creating a Python script to insert and update ships and related data on the Customer Service Portal;BI ManagementCreation of reports in Power BI as:Registration management and control;Unit management and control;Transport management and control;Ship management and control;The above reports are synchronized and loaded into Power BI containing data from 02 different databases and a loading of data from a Python Script connected to an API available by Porto Itapoá containing the dates of ship movements, thus making it possible to cross all information among those different data to better management of customer assets.

Aulas para turmas, básicas, intermediárias e avançadas.Classes for basics, intermediate and advanced students.

In charge of Container Terminal Statistics.Creative KPIs Based on Excel Pivot tables and several graphics.Combination of datas imported from the system Navis N4 and and SQL tables.Tableuau BI software use.Creating through the BI softwareintelligent pivot tables.Interesting bar, pie, map charts to view from different angles Terminal numbers.Knowledge in MS Power BI for same assets.

Vessel and Yard Planner Responsible to plan and arrange a correct sequence of instructions dividing with excellence the balance of gangs minimizing yard impacts and restow moves. Constant contact with Chief Officer of vessel to guarantee safety. Ensure together with Vessel’s Provider Central Planner ways to improve the plan when necessary.SPARCS N4 & XPS – Strong skills of the system managing. Following the software engineers from the beginning of system implementation before Itapoá Port start operations.STATISTICS (NEO BI - Operational Core of Intelligence - BI)General Statists, monthly and weekly dashboards productivity report (moves per hour and quantities); Sale Statistic dashboards Creation, every data from Itapoá Port in (2011) to COO analysis for presentation to terminal shareholders; Team Statistic dashboards Creation, Productivity Performance of terminal teams and others data; Creation of several tools in MS Excel files for an effective Operational moves performance history for customer payment.Jobs made for Finance and others departments of Facility.

Several reports to finance and line opators as TDPR, Loading report, Discharging Report, openning, organising and closing documents to terminal control.Constant support to dispatcher planing units to customs for general inspections.Supporting Terminal Planners importing files to the system and ensure that the information is in good condition for planning.Update of Vessels Schedule for next berthing maneuvers.

CBR - Consolidated booking report - Final Closing releasing cargo, quantities, weigh, especial IMO & Over dimensions units information;TDPR - Terminal departure productivity report - Final Report conference, launching of loading & discharge quantities units separated by discharge ports, crane productivities and any additional information to Ship Owners payment every data described for releasing tax to each one;ESTATISTICS - Year & month Terminal quantities control, Vessels & crane productivities, movement steps separated by Ship Owners and Pool-service, control of general bills payment to stevedores, yard occupation, Reefer yard occupation, Monthly ABRATEC file launching, percentage of Brazilians Port Operators. General presentation of percentage data & Graphics to Terminal CEO.

Logistics - Daily moving control of containers; gate in & out, loading & discharge;Operations - Cargo lists making up, loading & discharge confirmation. Husbandry responsible for Captain, Officers and Crew requests;IBR - Individual booking report - Launching data through commercial updates for a future loading operation in a focused port;Line Up - Daily Updates of Deadlines, Vessels information to coordinate Vessel’s Operation;Import - Releasing of Transshipment documents delivery to Brazilian customs, mails & phone contacts.