Robinson Lovatto

Supported the Marketing and Sales data warehouse using Oracle Database 19c and Oracle APEX for datasets with tables exceeding 1 billion records. Implemented Git repository structure and automated deployment scripts, provided technical guidance, and identified gaps in requirements to improve solution robustness.

Built customized data integrations for the Oracle Merchandising Foundation System using PL/SQL, ORDS, and APEX, reducing integration time by 40%. Developed and optimized PL/SQL/ORDS data pipelines, tuning queries and processes to improve performance by 70%.

Implemented ETL processes for client data migration, including normalize, validate, transform, and load steps to improve data accuracy and reduce quality check time. Built data pipelines using Oracle Integration Cloud (OIC) to move data via SFTP, RESTful APIs, or direct database-to-database transfers, and guided junior developers to complete their projects.

Refactored legacy PL/SQL code to support new features for the National User Registry, aligning the application with user needs and improving client satisfaction.

Maintained health-area applications by adding validations and reducing defects from several per day to a few per week. Automated administrative batch processes in Oracle Database and helped deliver systems for patient biometrics authentication and vaccination campaign management, including an 80% increase in campaign effectiveness.

Migrated data from a third-party tax system to another using PL/SQL on-demand batches, ensuring continuity of client operations and reducing license-related costs. Implemented payroll system changes to automate child support and labor union payments and integrate them with the financial module, optimizing manual processing time by 50%.

Earned a BSc in Information Systems at Feevale University in Novo Hamburgo, Brazil, from 2008 to 2013.