Marcio is available for hire
Hire MarcioMarcio Ruaro da Silva
Verified Expert in Engineering
PL/SQL Tuning Developer
Lajeado, Rio Grande do Sul - State of Rio Grande do Sul, Brazil
Toptal member since June 18, 2020
Bio
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).
Portfolio
HQS Plus | HQSplus.com.br
Oracle E-Business Suite (EBS), XML Publisher...
Innovative Consulting | Innovativeservices.com.br
Oracle Data Integrator (ODI), PL/SQL, SQL, EBSr12, EBS11i, Oracle
KPIT Infosystems Brazil | Kpit.com
JDE, EBSr12, Oracle
Experience
- PL/SQL - 20 years
- Oracle - 20 years
- PL/SQL Tuning - 20 years
- EBS11i - 15 years
- Oracle E-Business Suite (EBS) R12 - 11 years
- PL/SQL Developer - 10 years
- XML Publisher - 4 years
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
Experience
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.
Education
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
Skills
Tools
Oracle Reports, Oracle Forms, EBS11i, Oracle Workflow, Oracle E-Business Suite (EBS) R12, EBSr12, Oracle E-Business Suite (EBS)
Languages
SQL, Delphi, Delphi 7
Platforms
Oracle, Windows, Linux, Oracle Data Integrator (ODI)
Storage
PL/SQL, Oracle SQL, PL/SQL Developer, XML Publisher
Frameworks
Oracle Application Framework (OAF)
Other
Oracle Forms & Reports, Oracle Performance Tuning, PL/SQL Tuning, JDE, Forms, Reports
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