Oracle EBS Developer

Marcio Ruaro Silva - Resume

Personal Details Email: yzcvz8@r.postjobfree.com / Skype: marcio.ruaro.silva

Phone(s): +55-11-292*-**** (São Paulo-Brazil)

Mobile(s): +55-11-630*-**** (São Paulo-Brazil)

Address: Rua Carlos Weber nº 890/202 bloco A - Vila Leopoldina

São Paulo-SP CEP 05303-000

Citizenship: Brazilian.

Visa Status Australia: Australian Permanent Resident.

Visa Status for other countries: Need sponsorship.

Objective Work as a techno-functional consultant or developer employing technical and functional skills to provide meaningful customizations and/or software programming on complex systems such as Oracle ERP (E-business Suite). I want to perform software design and development remotely using VPN or such as in the non-geographic model being adopted today by several companies.

Summary I have been working with Oracle technology (database design, PL/SQL, forms, reports) since 1993 creating software from requirements to deployment going through entire development cycle. More recently I have been working as a leader and also main developer of a software factory having the duties of design, schedule measure and creation of customizations for Oracle EBS 11i (module such as AR, AP, OM, INV, WIP, Quality, RI, PO, CRM, TeleSales) since Mar/2007 (and also R12 version since Nov/2009). I also have 6 months of Java experience since I like to gather some new skills quite often.

Key Skills • Oracle ERP E-Business Suite 11i and R12 customization: modules AR, AP, INV, OM, WSH, WIP, Quality, PO, RI.

• Oracle tools and DB (all versions from 1993 to now): Forms, Reports, SQL & PL/SQL Programming (with also triggers and packages use), Case/Designer2000, DBA, IAS and Web Toolkit PL/SQL.

• Use of AIM 3.x to create MD50 and MD70 documents.

• Expert of Tuning in applications based in SQL and PL/SQL.

• Coding of software products from conception trough distribution (entire software lifecycle).

• Conceptual/logical data modeling and physical implementation of database objects.

• Qualified in Project Management and Team Leadership.

• Java technology: JEE 5.0, EJB 3.x, Glassfish Sun Server, Eclipse Ganymede, JPA Eclipse-Link, JSF, Rich Faces JBoss 3.x, Jscript & DHTML.

• Good knowledge in Oracle and SQL Server database administration (DBA).

• Delphi knowledge: Win32, Client-Server, Multi-Tier MIDAS, Components creation and OOP development.

Oracle

E-Business

Suite

Skills

Details I have a more technical profile than functional – sort of 60% technical and 40% functional. I am familiar with several interfaces, package api’s and native EBS tables in order to be able to create customizations in several modules. I don’t have full functional knowledge to realize all the necessary setup’s for a roll-out, such as total functional information in a specific track such as “order to cash” or “procure to pay” although I am very close to have this in such tracks.

In the projects I have worked I used to create MD50 detailed specifications from basic business requirements gathered from key users by functional consultant. Then after that I measure the effort to produce customizations and the deadlines and slipt those among the team getting the most complex for coding myself. I have worked in EBS versions 11i and R12 recently.

So, I can detail a little bit more my technical knowledge of modules and overall tables, interface tables and package API`s:

*** Level from None/Basic/Regular/Intermediate/Good/Very Good

iProc : Regular

PO : Good

AP : Good

GL : Basic

FA : None

AR: very good

Order Management: Very good

Inventory: Very good

WIP: Good

Quality: Intermediate

Telesales : Good

HR: Basic

WSH-Shipping: Very Good

BOM: Basic

Technologies (Basic/Regular/Good/Expert):

PL/SQL : Expert

Forms (also in EBS standards): Expert already created several custom forms.

Reports (also in EBS standards): Expert already created several custom reports.

Forms EBS Personalizations (introduced in rollup 4 for native forms): Expert already created several.

Concurrent creation for PL/SQL and/or reports: Expert, created many for both.

OAF: Regular

Java: Good

Workflow: Basic

XML Publisher: Good

Education Bachelor Degree: Business Management with major in Systems Analysis 12, 1994 Pontifical Catholic University of Rio Grande do Sul (PUC). BRAZIL, RS

Training • Oracle Tools: Forms, Reports, Graphics, Case/Designer2000, SQL-Loader, Tuning (explain plan, tkprof, optimizer hints, …).

• Oracle and SQL Server DBA: installation, tuning, development (procedures, packages, triggers

• Delphi (IDE, Component’s creation, pascal, …).

Experience

SYSTIME GLOBAL SOLUTIONS LTDA-ME (www.systime.net) – São Paulo/SP/Brazil (09/2011 – Current)

Position: EBS Support Team Manager / Project Manager

Duties: Manage a team of support analysts (functional and technical) for EBS production instances dealing with tickets, support project transitions, SLA, improvements to software. Conduct other software projects regarding customizations on JDE ERP.

SAFETECH LTDA (www.safetech.inf.br) – Porto Alegre/RS/Brazil (03/2007 – 10/2010)

Position: E-Business Suite Team Leader & Developer

Duties: In a B2B relation with consulting firm Safetech Limited I have done software development/coding, consulting in Oracle tools, team and project management and system’s analysis. Some projects history:

Oracle E-Business Suite (11i and R12) – 4 projects acting as a developer and team leader for the software factory in Safetech:

• 11/2009 – 11/2010: Software team leader for the development of several customizations in EBS R12 for Trombini Company (www.trombini.com.br). The customizations were in modules such as AR, PO, OTN/OM, INV, WIP and RI. Development was made in PL/SQL, packages, forms and reports 10g according with standards of Oracle E-Business Suite R12. Also several EBS forms personalizations were created.

• 09/2009 – 10/2009: Development and adjustment of customizations to Dell Company (www.dell.com) in Oracle EBS Suite ERP 11i modules AP and PO. Mostly PL/SQL concurrent processes involving frequent migration/feed of data from other legacy systems to modules AP and PO using interface tables and API packages.

• 09/2008 - 05/2009: Development of several customizations to Mundial S.A. Company (www.mundial-sa.com.br) in Oracle EBS Suite ERP 11i. I was a Team Leader of a software team composed by 4 analysts / developer’s (including me). Oracle EBS 11i Customizations are in modules AR, AP, OTN/OM, INV, WIP, Quality. Development was made in PL/SQL, packages, forms and reports 6i according with standards of Oracle E-Business Suite 11i. Also some EBS forms personalization’s and some customizations using custom.pll were created.

• 03/2007 – 08/2007: Development of several customizations to Avipal Company (www.avipal.com.br) in Oracle EBS Suite ERP 11i. My Position was a Team Leader of a software team composed by 3 analyst’s (including myself) and 3 developers. Oracle EBS 11i Customizations are in modules AR, AP, OTN/OM, INV, WIP. Development is made in PL/SQL, packages, forms and reports 6i according with standards of Oracle E-Business Suite 11i and Oracle On-Demand support.

Others – 2 projects acting as developer:

• 09/2007 - 08/2008: Customization of Store software (vending point functionalities) to sell insurance products for Paqueta Company (www.paqueta.com.br) retail. The necessary features are made using Delphi 7 and Oracle 10g database (SQL, PL/SQL with packages and triggers) technologies.

• 05/2009 - 08/2009: Development of standards and patterns using Java technology: JEE 5.0, EJB 3.x, Glassfish Sun Server, Eclipse Ganymede, JPA Eclipse-Link, JSF, Rich Faces JBoss 3.x, Jscript & DHTML. Two web sites were created with different features, using JSF + Rich Faces and interacting with EJB’s and a 10g Oracle database.

MRUARO CONSULTORIA EM INFORMATICA LTDA – Porto Alegre/RS/Brazil (01/2005 – 02/2007)

Position: Delphi 7 Developer and Stocks Trader - Owner

Duties: Enhancements of the Trading system platform software and development of new trading strategies. Also some short term contracts of Oracle consulting (one or two weeks each).

AREZZO SHOES – Campo Bom/RS/Brazil (01/2004 – 12/2004)

Position: IT Manager, Project Manager and Main Oracle Systems Analyst

Duties: Systems/Software development, consulting in Oracle tools, development team coordination, suppliers commercial and technical control, project managing, information systems analysis, infrastructure managing and control. First person in responding for several systems of the company such as store’s control, WMS control, orders – production – invoicing control, CRM control, financial, etc.

MRUARO CONSULTORIA EM INFORMATICA LTDA – Porto Alegre/RS/Brazil (09/2002 – 12/2003)

Position: Delphi 7 Developer and Stocks Trader - Owner

Duties: Development of a Trading system platform in Borland Delphi 7 tool. The software goal is to analyze stocks through testing of market strategies in a deeper way that is possible to do with Metastock or Tradestation software.

NOVABASE (NBO) Lisbon – Portugal - Europe (09/2001 – 08/2002)

Position: Oracle Consultant and Functional Systems Analyst

Duties: Validation of Systems specifications in the Treasure-house System of Social Security of Portugal. Implantation of the system/software, training teachers who trained the final users and had supervised the production deployment in +- 300 Treasure-houses overall the Portugal country, accounting for approximately 700 users.

MRUARO CONSULTORIA EM INFORMATICA LTDA – Porto Alegre/RS/Brazil (05/2000 – 08/2001)

Position: Independent Oracle Consultant - Owner

Duties: Working on my own limited company for several short term contracts acting usually on the tuning of PL/SQL applications and installation of Oracle databases and application servers in clients.

GATE SERVER INFORMATICA LTDA – Porto Alegre/RS/Brazil (06/1994 – 05/2000)

Position: Managing-Partner, Consultant and Systems Analyst Duties: Systems/software development, consulting in Oracle database and tools, team coordination or Oracle consulting, commercial proposals, Oracle course administration (creation of material and instructor also), project management, information systems analysis.

ORACLE DISTRIBUTOR FOR SOUTH BRAZIL (01/1993 – 06/1994)

Position: Oracle Developer

Duties: Development of applications in Oracle Tools for character mode (forms3, reports2, PL/SQL) in Oracle6 and Oracle 7, Technical Support for clients about oracle tools.

Languages Portuguese (native), English (fluent)

References Joelson Casagrande – Director at Safetech LTDA,

yzcvz8@r.postjobfree.com (Porto Alegre Brazil, Speak in Portuguese)

Leo Silveira – Director at Safetech LTDA,

yzcvz8@r.postjobfree.com (Porto Alegre Brazil, Speak in Portuguese)

Melquior Chaves – DataStage Consultant located at Brisbane, yzcvz8@r.postjobfree.com (Brisbane, Speak in English)

Contact this candidate