Marcio Ruaro da Silva, PL/SQL Tuning Developer in Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil
Marcio Ruaro da Silva

PL/SQL Tuning Developer in Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil

Member since February 14, 2018
Marcio has worked with Oracle in the IT field for his entire two-decade-long career. During that time, he's gained an expertise in database design, PL/SQL coding and tuning, forms and reports development as well as Delphi and some Java development—either in legacy or ERP as Oracle EBS (upholding RICE standards).
Marcio is now available for hire




Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil



Preferred Environment

Windows, Linux, PL/SQL Development

The most amazing...

...project I’ve coded was a complex RICE, where it was coded for Oracle EBS R12 ERP with an automated information transfer on modules OPM & OM using forms, PL/SQL.


  • EBS Analyst Programmer

    2017 - PRESENT
    HQS Plus |
    • Developed several software customizations for a major chemicals company regarding the sales agreements, factory relabeling of chemical products with sales automation, the creation of a customized freight costing system for OPM and PAC, personalized holds on accounts payable, a master item XML interface output integration, and an XML customer integration importation, among others.
    • Worked on RICE development in Oracle E-Business Suite (EBS) R12 using PL/SQL, Forms, Reports, Business Events, XML Publisher, APIs, and interfaces in several modules (AR, INV, OM, PO, AP, OPM) as well as creating documentation (AIM) and a native patch for EBS.
    Technologies: Oracle, EBS R12, SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Workflow, Oracle Application Framework (OAF), XML Publisher, EBS, Oracle Business Events
  • Tax and Fiscal Integration Analyst Programmer – EBS

    2015 - 2016
    Innovative Consulting |
    • Developed a tax interface for the Renner company, a major retailer in Southern Brazil; the interfaces are between Mastersaf fiscal/tax software and Oracle E-Business Suite (EBS) versions 11i and R12 as well as the Oracle RETAIL/RETEK (RMS) using Oracle PL/SQL and Oracle ODI.
    Technologies: Oracle, EBS 11i, EBS R12, SQL, PL/SQL, ODI
  • EBS Support Team Manager | JDE Project Manager

    2011 - 2014
    KPIT Infosystems Brazil |
    • Managed a team of support analysts (functional and technical) across Brazil and India for EBS production instances of an automotive corporation dealing with tickets, support project transitions, and SLA, improvements to the software.
    • Led a support team of JDE ERP for a watch production company.
    • Managed a large (+15,000 hours) implementation/rollout project of JDE ERP for a fluid and motion control tech company; communicating with teams in the US, UK, and Brazil.
    Technologies: Oracle, EBS R12, JDE
  • E-Business Suite Team Leader | Oracle Analyst/Programmer

    2007 - 2010
    Safetech Ltda. |
    • Developed software and made adjustments for the store back office software for Paquete (a shoe company with a focus on the retailer division in Porto Alegre) with Oracle PL/SQL, Forms, Reports, Delphi (point-of-sales enhancements), and PDV (insurance sales, customer profiles, payments).
    • Created and coded customizations for Oracle E-Business Suite 11i and R12 using PL/SQL, Forms, Reports, PL/SQL APIs, form personalization, XML Publisher, and Workflow.
    • Led a team of Oracle developers for three EBS implementations.
    • Reviewed code and accounted for +100 customizations delivered in AR, OM, PO, AP, INV, RI, and WIP modules.
    Technologies: Oracle, PL/SQL, Forms, Reports, Delphi, EBS 11i, XML Publisher, Oracle Workflow


  • Mastersaf Tax Interface for EBS 11i/R12 | Retail Business (Development)

    An update to the interface to Mastersaf's fiscal/tax software where the data source was on EBS 11i for one of the major retailers in the South of Brazil.

  • Mundial S.A EBS 11i RICE Customizations (Development)

    Created and coordinated the development of more than 20 RICE customization groups with several sub-components (PL/SQL packages, forms, reports, triggers, and more)—accomplishing several business goals such as controlling the stock in third parties, barcode generation, sales order access control, personalized reports for due payments, personalized packing complement for shipping, and more.

  • Trombini EBS R12 RICE Customizations (Development)

    Developed several customizations in EBS R12 for the Trombini company—accomplishing business goals such as an extended hold control for sales orders regarding work-in-progress (WIP) orders, a personalized code for master items, hierarchical access control for sales orders for sales team, customized sales commissions creation and control, customized customer form for fast entry, and more.

  • RICE Customizations EBS R12 | Chemicals Industry (Development)

    Developed several customizations on EBS R12 for an implementation for a major chemical corporation in four locations (US, Mexico, Brazil, and Uruguay). Several business goals were accomplished such as product relabeling control, XML generation for the master item interface, sales order agreement automation, and more. This was also done in three languages (English, Portuguese, Spanish) all the while respecting Oracle EBS standards.


  • Languages

    SQL, Delphi 7
  • Tools

    Oracle Reports, Oracle Forms, EBS11i, Oracle Workflow, Oracle E-Business Suite (EBS) R12, Oracle E-Business Suite (EBS)
  • Platforms

  • Storage

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

    Oracle Forms & Reports, Oracle Performance Tuning, PL/SQL Tuning
  • Frameworks

    Oracle Application Framework (OAF)


  • Bachelor's degree in Business Management (Information Technology)
    1990 - 1994
    Pontifícia Universidade Católica do Rio Grande do Sul | PUC-RS - Porto Alegre, RS, Brazil

To view more profiles

Join Toptal
Share it with others