Profileimage by Leandro Lourenco Oracle EBS Systems Analyst - Modules - AR - AP - GL - CM  from Boituva

Leandro Lourenco

available
Contact

Last update: 24.08.2017

Oracle EBS Systems Analyst - Modules - AR - AP - GL - CM

Graduation: Graduated in Administration & Systems Analysis Bachelors
Hourly-/Daily rates: show
Languages: English (Full Professional) | Portuguese (Native or Bilingual)

Skills

?    16 years of experience with Oracle technology such as Forms, Reports and PL/SQL. 

?    9 years of experience with Oracle E-Business Suit (EBS) projects, acting as Oracle Developer among EBS modules such as AP, AR, FA, GL, INV and RI. 

?    Experience with Brazilian Tax Regulations – Nota Fiscal Eletronica.

?    Full domain of performance evaluation in Oracle with tools such as Explain plan, tkprof, etc.

?    Understanding of SQL access path's, hints and optimizer engine logic to adjust SQL's Recent knowledge of last advances in PL/SQL such as bulk collect and how to use properly

?    Have worked with terabytes databases.

?    Experience developing Oracle EBS R11 e R12. SQL, PL/SQL, FORMS, REPORTS and Oracle BI Publisher.

?    Academic knowledge of UML and experience with Essential Analysis.

?    Communication skills, presentation. Entrepreneurial profile and communicative. Skills in negotiation and intermediation. Ease of teamwork. 

?    Experience with electronic invoicing projects. Expertise in the areas of insurance, health and tax determination. 

?    Project and relationship management experience.
 
?    Domain on Oracle SQL and PL/SQL languages. Development tools Oracle FORMS, REPORTS and Oracle BI Publisher. Tools SQL*PLUS, PL/SQL Developer, SQL-NAVIGATOR, ERWIN. Stored Procedures, External Procedures, Tables, Views, Triggers e Libraries;

?    Knowledge on C, PASCAL, SHELL UNIX languages. Operating Systems Windows NT, 2000, Unix e Linux;

Project history

Business Application Analyst – Oracle EBS R12.
     LG CNS – Brazil – Nov. 2013. 

Member of LG CNS Business Application Team, my duties are:

?    First Level Support of LG Electronics do Brasil. Accounting Payables, Accounting Receivables, Cash Management, Accounting, TAX, RI and Nota Fiscal Eletronica.
?    Communicating with LG CNS Korea, reporting system issues and working as a go-between the LG Electronics do Brasil business departments and LG CNS Korea.
?    Leading LGE improvement projects, understanding of business needs, designing and suggesting system solutions.
?    Supporting Finance and Controllership departments on closing periods.
?    Designing and building customized reports for Brazilian requirements.
?    Supporting legacy systems that interface to Oracle E-Business Suite.


Oracle Developer – EBS R12.
     Stefanini Consultoria e Assessoria em Informatica S.A – Brazil – Jan. 2013. 

?    Responsible for customization development on Oracle EBS R12. 

     System Analyst Developer
     Cummins do Brasil - Guarulhos – Brazil – Feb. 2012 to Jan 2013

?    Responsible for customization development on Oracle EBS R11i. 
?    Coordination for optimizing custom applications on Oracle EBS R11i.

     System Analyst Developer
     Ninecon. São Paulo – Brazil – Oct. 2011 to Feb 2012

?    Responsible for customization development on Oracle EBS R11i for 3G Nextel Brazil project. 

     System Analyst Developer
     Alejandro Informática Ltda (IT Consultant Company). São Paulo – Brazil – Feb. 2008 to Dez. 2010.
In this period I worked for the following customers:

Gol Linhas Aéreas Inteligentes (Airline Company) - São Paulo – Brazil – Aug. 2010 to Dec. 2010.

?    Responsible for creating many kinds of reports about accounting.

Odebrecht Engenharia e Construção (Civil Construction Company) São Paulo – Brazil – Apr. 2009 to Jun. 2010.

?    Responsible for creating reports about fixed asset and maintenance of assets on Oracle BI Publisher integrated with ERP system Oracle EBS R12. O2 Project, Assets and Maintenance Teams.

Novelis do Brasil Ltda (Aluminum Rolling Company). São Paulo – Brazil – Feb. 2009 to May. 2009.

?    Creating reports on Oracle BI Publisher and Oracle EBS R11.

Mitsubishi Motors do Brasil (Automotive Industry). São Paulo – Brazil – May. 2008 to Jan. 2009.
 
?    Participation on Electronic Invoice Project.
?    Responsible by development of integration systems People Soft (ERP system) and  Easy(Import System) to Triangulus NFe (internet communication system).




TAM Linhas Aéreas S/A (Airline Company). São Paulo – Brazil – Dec. 2008 to Jan. 2009

?    Participation on Electronic Invoice Project.
?    Responsible by development of integration systems Oracle Applications 11i  X Triangulus to Triangulus NFe (internet communication system).

Karina Plásticos (PVC Compounds Company). São Paulo – Brazil – Feb. 2008 to Abr 2008.
 
?    Participation on Financial Project.


System Analyst Developer, Team leader of system maintenance team
Fujitsu do Brasil (IT Consultant Company). São Paulo – Brazil - Aug 2006 to Jan 2008.

?    Contact between staff and client technology team. 
?    Organization, distribution, monitoring, and control activities schedule.
?    Reporting to the factory management software. 
?    Consulting clients and making recommendations 
?    Internal technical Support. 


System Analyst Developer
Unimed Paulistana (Health Plan Company). São Paulo – Brazil - Apr 2006 to Jul 2006.

?    Maintenance and implementations on Registration System.


System Analyst Developer
Procwork Software Informática LTDA (IT Consultant Company). São Paulo – Brazil - Jul 2005 to Mar 2006.

?    Analysis, maintenance and implementations on tax calculation system. 


System Analyst Developer
TAM Linhas Aéreas S/A (Airline Company).  São Paulo – Brazil - Apr 2005 to Jul 2005.

?    Analysis, maintenance and implementations on accounting system.


System Analyst Developer
Elucid Solutions S/A (IT Consultant Company). São Paulo – Brazil - Mar 2000 to Apr 2005.

?    Database Support and Maintenance on Management System for the sectors of Utilities (Electricity, Water and Sanitation).
 

Contact form

Contact details