Oracle Senior Consultant

Repsol YPF. (Area Business Intelligence).
Designed and developed the applications for the Data Warehouse for Business Intelligence Corporative (pl/sql-shellscript en Unix).
Designed and developed for MicroStrategy.
Designed and developed for Oracle Express.
Analysis and development for the management BI in Oracle Express.
• Claro. (Area developed Business Intelligence).
Analysis and development for Oracle Warehouse Builder.
Analysis and development for process ETL for Data Warehouse - Business Intelligence Corporate (OWB/plsql-shellscript).
• Barceló Viajes. (Grandes Cuentas)
Designed and developed the applications for the Corporate Booking, Booking on-line, and self-loads of data and maintenance.
Modification and improvements in the implementation of the economic proposals. Analysis and development for the management and auditing of invoices.
Improvements in the process of settlements, billing and calculation of consumption.
Establishment of processes for extracting details of expenditure, diversion of the proposals vs. Liquidations real simulation of liquidations, details of transactions made with credit cards and study of transactions.
Analysis and Implementation processes to nutrition of Data Warehouse (ETL Pentaho) to the structure of Corporate Business Intelligence.Meeting with end user, collecting requirements and converting into technical specification.

Barceló Viajes. (Big Customers)
Designed and developed the applications for the Corporate Booking, Booking on-line, and self-loads of data and maintenance.
Modification and improvements in the implementation of the economic proposals. Analysis and development for the management and auditing of invoices.
Improvements in the process of settlements, billing and calculation of consumption.
Establishment of processes for extracting details of expenditure, diversion of the proposals vs. Liquidations real simulation of liquidations, details of transactions made with credit cards and study of transactions.
Analysis and Implementation processes to nutrition of Data Warehouse (ETL Pentaho) to the structure of Corporate Business Intelligence.
Meeting with end user, collecting requirements and converting into technical specification.

Functional analysis of the applications necessary for the client as well as updating and improvement of existing ones, ensuring their proper operation and to support different users.
Conducting meetings with the client to determine the objectives of the systems to develop.
Identification of business opportunities and future needs of the client, as well as assessing the technical feasibility and economic developments of applications.
Support and training to users.
Analysis and Implementation of Web applications (. Net) according to the WorkFlow: Control Assistance, Claims Management, Management Orders for orders, Interface Data Providers (Bloomberg, Thomson), Management corrective pricing, Investment Funds Management, ETL procedures for supplying the DataWarehouse.

Development in Forms 6i/9i/10gR2
Development of procedures and packages, applets in JDeveloper.
Development of Reports 6i/9i/10gR2 for Swiss Life S.p.A (Insurance Company).
Implementation, modification and maintenance of applications for the management of the company.
Application development in the commercial area, data transmission for the ISVAP, development and maintenance of the interface with SAP.
Installation and subsequent migration to 10g of applications in Swiss Life Spa (updates to java from all the features in C + + / VB).
Analysis and Implementation for WorkFlow: Accounting records, Complaints Management, Loans Management, Letters Postel, Management RID / MAV, corrections budget proceedings of acquittal, Management Tax Payments, Formal Control (BBAN, IBAN), procedure standardization and automatic update CAP

Coop Lombardia (Retail)
Meeting with end user, collecting requirements and converting into technical specification. Developed Server side PL/SQL (Stored Procedures, Functions & Packages) for implementing complex business logic.
Created data entry Forms using oracle Forms 10g for entering data related to Order Information and inventory.
Created and customized analytical reports for existing system using Reports 10g.
Converted data from legacy system to Oracle 10g using SQL*Loader and PL/SQL programs.
Responsible for tuning of SQL queries written in procedures/functions at the back end which are called from the front end forms.
Responsible for creating complex views for EUL of Oracle Discoverer10g.
Documentation of user manual and other generic documentation required for the module.
Training the new resources and knowledge sharing by in-house training sessions.
Created XML reports using XMLDOM Package.
Worked extensively to formalize the logical design using ERWIN and physical creation of database objects like tables, view, sequences, function, packages, procedures etc.

Evolutionary maintenance and support tasks for the Oracle Financials Cloud application.
Perform in a management role, both functional and as a solution architect, and work on Oracle Financials Cloud (ERP Financials), support and project activities including upgrades, enhancements, integrations and other support / project needs involving Oracle tools, XML Publisher, Reports BI Publisher, Reports OTBI, Dashboard, Personalization Page sandbox, Customization flat file for print checks
Oracle Integration Cloud, Customs Process Builder BPM Cloud, APEX Rest, ORDS, TIBCO.
Also designed and developed the applications for the Data Warehouse for Business Intelligence Corporative (Jedox), for local customers.

I am currently with a multinational electric power company, providing evolutionary support and maintenance, as well as new developments
We work on some projects with agile methodology and others with waterfalls.
In the area of Data Process there are 10 different applications, several interfaces with different systems (SAP and Legacy), as well as the packages and processes of the Oracle database.
My responsibilities include reporting to the steering committee (progress of developments, risks), meeting proposed dates and avoiding possible deviations.

Management teams, with different profiles: eBS functional, Java developers,
Pl / Sql, Idefafix, which is on Support, Implementation and Development projects for different projects.
I carry out the planning and assignment of tasks, estimation and quotation of the required values requested by the clients to comply with the agreed dates in the different projects.
Managing technical development by acting as a liaison between the technical team and the user community.
Experience training and supporting end users, Experience in managing onshore and offshore teams.
Experience in independently managing client Director and above relationships.
• Grupo Garbarino.
Oracle EBS Senior Consultant EBS R11 and R12/Implementation of R12:
Coordinate the different planning tasks for the implementation of eBS, extractors and subsequent initial load.
Responsible for the interface development team for different modules (AR, SLA, GL, AP, PO, INV).
Responsible for the development group of legacy system extractors (Aurus, Ideafix, Nexus, Auditar) and subsequent data consolidation.
Migration from R11 to R12 for the company Digital Fueguina:
Relegation of customs.
Installation of customs through standard patch and adaptation to R12.
Support, analysis, implementation and maintenance of processes R11 and R12.
• Prosegur SA.
Implementation and development of the Corporate and Countries website at Oracle UCM.SMOG project, prevention of Money Laundering and Financing of Terrorism.
• Grupo Imas.
Implementation of R11, development of customer adaptations for interfaces and modules, screens, reports and requested processes (CE, AR, AP, GL).
• Grupo SHV (Hipermayorista Makro).
Management of support, maintenance and evolutionary development for the company. Permanent allocation of 3 resources on site. Follow-up of resources and assignment of tasks to them. Support and maintenance of the client's customs applications.
• Grupo Newsan.
Management of the resources allocated for the evolutionary maintenance, support and maintenance of the company.
Permanent allocation of various resources on site, in charge of the support table and evolutives for the eBS R12. Follow-up of resources and assignment of tasks to them. Support and maintenance of the client's customs applications.
• PepsiCo
Management of the resources allocated for the evolutionary maintenance, support and maintenance of the company. In charge of the support desk for Latin America for the application Ebs R12 and other customs applications with Oracle technology, with compliance with SLA's standards for incident resolution.
• Adecoagro
Management of assigned resources for the Oracle BI area. Management of resources assigned to the client and control of assignments.
• Hospital Alemán
Analysis and Implementation of AR and migration of legacy's.
Comprehensive survey for the migration of legacy systems to implement the Oracle AR module and carry out the relative interfaces and integrations.

Development of Reports 6i/9i/10gR2 for WEB (Yenny / El Ateneo - Argentina)
Implementation, modification and maintenance of applications for the management of the company.
Requirement capture, analysis of requirements, design solution based on client's needs.
Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
Involved in the management of customer logged issues by providing priority based timely resolution.
Extensively involved in the development Forms 6i, Reports 6i & PL/SQL packages for Inventory and sales management System.
Documentation of user manual and other generic documentation required for the module.
Review and assignment of issues for team members.
Responsible for designing, developing, specification of test plans.

Complete development of Modules of Statistics in Developer 2000.
Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
Documentation of user manual and other generic documentation required for the module.
Creation of new reports to suit customer needs.