Open to opportunities

Robinson Ramm Lovatto

@robinsonrammlovatto

Message

Experienced IT professional specializing in Oracle technologies and data integration.

Portugal

Message

What I'm looking for

I am seeking a role that fosters innovation, encourages collaboration, and offers opportunities for professional growth.

I am an experienced IT professional with over a decade of expertise in Oracle technologies, focusing on PL/SQL development, data integration, and ETL processes. My career has been dedicated to enhancing data pipelines and optimizing SQL queries to improve system efficiency and data accuracy. I have successfully implemented various data integration solutions that facilitate seamless data transfer between applications, significantly improving operational efficiency.

Throughout my career, I have developed a strong proficiency in Oracle Integration Cloud and PL/SQL, allowing me to build customized data integrations that streamline processes and reduce integration time. My work has led to substantial performance improvements, including a 70% boost in system responsiveness through optimized queries and PL/SQL refactoring. I am passionate about guiding junior developers and ensuring project success through mentorship and innovative problem-solving approaches.

Experience

Work history, roles, and key accomplishments

Current

Senior Consultant

Current

Oracle

Oct 2023 - Present (1 year 8 months)

Built customized data integrations to Oracle Merchandising Foundation System using PL/SQL, ORDS and APEX for enhance operational efficiency, streamlining processes and reducing integration time by 40%. Developed a data pipeline using Oracle’s framework, built in PL/SQL and ORDS, to enable suppliers of our client to upload products via templates created by themselves, automating data validation, en

Oracle Pl SQL SQL Apex ORDS MFC Git

Oracle Consultant

KCS IT

Jan 2019 - Sep 2023 (4 years 8 months)

Implemented ETL processes for migrating client data, normalize, validate , transform, and load the data to the destination. The validations ensured the accuracy of the data, improving the data integrity and reducing quality check time. Built data pipelines using Oracle Integration Cloud (OIC), moving data between applications via file integration, SFTP, RESTful APIs, or direct database to database

Oracle SQL ORDS RESTful APIs Git

PL/SQL Consultant

Everis

May 2018 - Jan 2019 (8 months)

Refactored PL/SQL code from the legacy system to accommodate new features to the National User Registry (a database of all users of the Portuguese public health system) and increase d client satisfaction making the application more aligned with the user needs.

Pl SQL SQL

System Analyst

FIERGS

May 2014 - Apr 2018 (3 years 11 months)

Maintained several applications in the health area, ensuring continuous improvements in the quality of code. I created validations and minimized bugs from several a day to a few per week . I a utomated administrative processes to freed time o f people and lowered operation costs , the schedule s w ere set in the Oracle Database to run in batches. Led a project to authenticate patients via biometri

Oracle SQL

Oracle Developer

Safetech Informática

May 2012 - May 2014 (2 years)

Migrated data from a third-party tax system to another using on-demand batches. This migration was done in PL/SQL and ensured the continuity of the operations of the client. The migration let them save money related to licenses of the software. Implemented changes in a payroll system to automate child support and labor union payments and also integrated these processes with the financial module. T

Pl SQL SQL