Scroll To View More
Diogo Miguel Martendal

Diogo Miguel Martendal

São José - Santa Catarina, Brazil
Member since December 29, 2016
Diogo has over 15 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)—especially being passionate about producing great performance complex routines. He also is well-versed in planning and developing custom systems and has knowledge of administrative business areas such as accounting and finance.
Diogo is now available for hire
Portfolio
Experience
  • SQL, 14 years
  • Oracle PL/SQL, 14 years
  • Data Modeling, 14 years
  • SQL Performance, 14 years
  • Oracle Forms & Reports, 11 years
  • Oracle Discoverer, 11 years
  • ETL, 5 years
  • Oracle E-Business Suite (EBS), 2 years
São José - Santa Catarina, Brazil
Availability
Part-time
Preferred Environment
Oracle Database
The most amazing...
...thing I've done was on an ODI KM; I turned a new data load creation into a simple setup along with an improved runtime, an enabled log, & data gaps resolution.
Employment
  • Freelance Software Engineer
    2017 - PRESENT
    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 Forms, Oracle Reports, SourceTree, Oracle SQL Data Modeler, Oracle BI Publisher, Oracle Designer, Git, Microsoft Project, Microsoft Office, Bitbucket, Oracle E-Business Suite (EBS), Oracle EBS General Ledger
  • Storage
    PL/SQL, Oracle PL/SQL, SQL Performance, PL/SQL Developer, Oracle SQL Developer, XML Publisher
  • Other
    Oracle Forms & Reports, Oracle Discoverer, Data Modeling, Software Development Life Cycle (SDLC), English-Portuguese Translation, Accounts Receivable, ShellScript, Shell Commands, Accounts Payable
  • Paradigms
    ETL, Oracle ODI, PMBOK
  • Platforms
    Oracle Data Integrator (ODI), Oracle
Education
  • Bachelor’s degree in Computer Science
    2000 - 2008
    Universidade Federal de Santa Catarina - Florianópolis, Brazil
I really like this profile
Share it with others