Scroll To View More
Diogo Miguel Martendal, Software Developer in São José - Santa Catarina, Brazil
Diogo Miguel Martendal

Software Developer in São José - Santa Catarina, Brazil

Member since December 29, 2016
Diogo has over 16 years of experience working with analysis and Oracle database development (data modeling, PL/SQL, SQL, Forms, Reports, Discoverer, Data Integrator, BI Publisher, EBS and Designer). He's especially passionate about producing great performance complex routines. Diogo is well-versed in planning and developing custom systems and has knowledge of administrative business areas such as accounting and finance. (EU citizen)
Diogo is now available for hire

Portfolio

Experience

  • SQL Performance, 16 years
  • Data Modeling, 16 years
  • Oracle PL/SQL, 16 years
  • Oracle Forms & Reports, 16 years
  • Oracle Discoverer, 13 years
  • ETL, 7 years
  • Oracle Data Integrator (ODI), 4 years
  • Oracle E-Business Suite (EBS), 2 years
São José - Santa Catarina, Brazil

Availability

Full-time

Preferred Environment

Oracle Database

The most amazing...

...thing I've done was on an ODI KM—simplifying the new data load creation with an improved runtime, enabled log, and data gap resolution.

Employment

  • Freelance Software Engineer

    2017 - PRESENT
    Various Clients (via Toptal)
    • Worked as a freelance developer, specifically with Oracle.
    Technologies: Oracle
  • Systems Analyst

    2017 - PRESENT
    Portobello S.A. (Portobello Group)
    • Provided internal support to financial systems: Oracle EBS (AP, GL, Internet Expenses), Oracle EPM, Mastersaf, and Gesplan.
    • Implemented customized solutions on Oracle EBS and EPM using PL/SQL, Forms, Reports, Discoverer, ODI (Data Integrator), and BI Publisher.
    • Installed Oracle EPM (Enterprise Performance Management) on a project.
    Technologies: Oracle, E-Business Suite, Mastersaf, EPM
  • Systems Analyst | Oracle Consultant

    2010 - 2017
    Supero TI Ltda.
    • Performed custom Oracle systems analysis and development—worked on creation, support, maintenance, and improvement projects.
    • Acted as a technical reference on Oracle technologies implementation and performance improvement (PL/SQL, SQL, Forms, Reports, and Discoverer).
    • Implemented Oracle EBS integrations and customizations—participated in the Oracle EBS upgrade project to version R12 and the WMS (warehouse management system) module setup.
    • Improved the performance in systems involving travel control, accounting, finance, access control, and systems related to power generation and commercialization.
    Technologies: Oracle Database, Oracle Tools, Git, Jira, MS Project
  • Database Analyst

    2008 - 2010
    Suntech S.A.
    • Built and maintained database structures and routines for the SATCEL project—collecting, storing, and querying over telecommunication networks' measurement data.
    • Created an Oracle Data Integrator customized process to improve the management and performance of data loads from different sources and technologies.
    Technologies: Oracle Database, ODI
  • ODI Solutions | Systems Analyst | Software Engineer

    2007 - 2008
    Compasso Tecnologia Ltda.
    • Integrated the data with FLEXCUBE ERP (banking) using ODI.
    • Created ODI solutions and customizations for development optimization.
    Technologies: Oracle Data Integrator
  • System Analyst

    2006 - 2007
    Driver Informática Ltda.
    • Performed project analysis and Oracle development at a customer's food branch.
    • Maintained and improved legacy systems involving several technologies like Oracle Database, Forms, Reports, Discoverer, Designer, Pro*COBOL, and Shell Script.
    Technologies: Oracle, Pro*COBOL, Shell Script
  • Oracle Developer

    2005 - 2006
    Inside System Ltda.
    • Developed an Oracle system at a customer's power generation branch.
    • Maintained and improved legacy systems involving several technologies like Oracle Database, Forms, Reports, and Discoverer.
    Technologies: Oracle
  • Oracle Developer

    2002 - 2005
    Driver Informática Ltda.
    • Developed a Oracle system at a customer's food branch.
    • Maintained and improved legacy systems involving several technologies like Oracle Database, Forms, Reports, Discoverer, Designer, Pro*COBOL, and Shell Script.
    Technologies: Oracle, Pro*COBOL, Shell Script

Experience

  • Credit Card Invoice Reconciliation (Development)

    Handled the credit card invoice import into a proprietary system for reconciliation of expenses and integration with Oracle EBS: accounting entries (GL) and invoice for payment (AP).

  • Interfaces with FLEXCUBE ERP (Development)

    Integrated databases and files with a FLEXCUBE ERP using Oracle Data Integrator. Mapped the interfaces, implemented, and defined the best practices and customizations.

  • Satcel (Development)

    Integrated telecommunication network telemetry data from different tech databases into the customer's system. The imported data enters the lower level of the network topology every hour and also stores the summarized data in daily tables and at the higher levels of the topology. There are also formulas whose values are calculated at load-time and stored at all levels. Data is made available to the application through queries assembled by database routines at runtime.

  • Use Cost of Power Transmission Lines (Development)

    Made improvements in the payment process of the cost per use of power transmission lines by withdrawing or reducing analysis and manual actions needs.

    This was an external product that was used to download and digitally read the collection documents and generate spreadsheets which are then imported into the system. The system makes a consistency between the values and due dates defined by the responsible organ and the collection documents. This information (that once used to be analyzed and manually entered) are then passed forward into the process—saving a lot of time. Collection documents that once needed to be printed for conference and payment are now kept digitized and archived at the end of the process—bringing environmental sustainability to the process.

Skills

  • Languages

    SQL, XML, HTML, Jython
  • Tools

    Oracle Reports, Oracle Forms, Oracle SQL Data Modeler, SourceTree, Microsoft Project, Oracle EBS General Ledger, Oracle BI Publisher, Oracle Designer, Git, Microsoft Office, Bitbucket, Oracle E-Business Suite (EBS), Oracle Enterprise Planning & Budgeting Cloud Service (EPBCS)
  • Storage

    SQL Performance, PL/SQL, Oracle SQL Developer, Oracle PL/SQL, PL/SQL Developer, XML Publisher
  • Other

    Oracle Forms & Reports, Oracle Discoverer, Data Modeling, Software Development Lifecycle (SDLC), ShellScript, English-Portuguese Translation, Shell Commands, Accounts Receivable, Accounts Payable
  • Paradigms

    Oracle ODI, ETL, PMBOK
  • Platforms

    Oracle, Oracle Data Integrator (ODI)

Education

  • Bachelor’s degree in Computer Science
    2000 - 2008
    Universidade Federal de Santa Catarina - Florianópolis, Brazil
Certifications
  • Oracle PL/SQL Developer Certified Associate
    MAY 2016 - PRESENT
    Oracle
  • Oracle Database SQL Certified Expert
    AUGUST 2015 - PRESENT
    Oracle
I really like this profile
Share it with others