Marcio Ruaro da Silva, Developer in Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil
Marcio is available for hire
Hire Marcio

Marcio Ruaro da Silva

Verified Expert  in Engineering

PL/SQL Tuning Developer

Location
Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil
Toptal Member Since
June 18, 2020

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).

Oracle Performance TuningSQLPL/SQLOracleOracle SQLPL/SQL DeveloperEBS11iOracle E-Business Suite (EBS) R12XML PublisherOracle WorkflowOracle Application Framework (OAF)Oracle Forms & ReportsOracle ReportsOracle FormsWindows

Availability

Part-time

Preferred Environment

PL/SQL, Linux, Windows

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.

Work Experience

EBS Analyst Programmer

2017 - PRESENT
HQS Plus | HQSplus.com.br
  • 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 E-Business Suite (EBS), XML Publisher, Oracle Application Framework (OAF), Oracle Workflow, Oracle Reports, Oracle Forms, PL/SQL, SQL, EBSr12, Oracle

Tax and Fiscal Integration Analyst Programmer – EBS

2015 - 2016
Innovative Consulting | Innovativeservices.com.br
  • 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 Data Integrator (ODI), PL/SQL, SQL, EBSr12, EBS11i, Oracle

EBS Support Team Manager | JDE Project Manager

2011 - 2014
KPIT Infosystems Brazil | Kpit.com
  • 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: JDE, EBSr12, Oracle

E-Business Suite Team Leader | Oracle Analyst/Programmer

2007 - 2010
Safetech Ltda. | Safetech.inf.br
  • 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 Workflow, XML Publisher, EBS11i, Delphi, Reports, Forms, PL/SQL, Oracle

Mastersaf Tax Interface for EBS 11i/R12 | Retail Business

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

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

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

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, Delphi 7

Tools

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

Platforms

Oracle, Windows, Linux, Oracle Data Integrator (ODI)

Storage

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

Other

Oracle Forms & Reports, Oracle Performance Tuning, PL/SQL Tuning, JDE, Forms, Reports

Frameworks

Oracle Application Framework (OAF)

1990 - 1994

Bachelor's Degree in Business Management (Information Technology)

Pontifícia Universidade Católica do Rio Grande do Sul | PUC-RS - Porto Alegre, RS, Brazil

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring