Jeremie - Consultant ORACLE APPLICATIONS
Ref : 091126B004-
37000 TOURS
-
Consultant, Consultant technique, Consultant fonctionnel (48 ans)
-
Freelance
Ness Global Services Pte Ltd (********/) September 2007 – November 2009
Working as Senior Oracle Consultant
Fuji Xerox Singapore (********/) Oracle Application V11.5.9 25 months
Support (Corrections and enhancements) of distribution and finance customizations.
Involved in application tuning, purge and archiving projects.
Involved in single sourcing project using Oracle XML Gateway and Oracle Application Server InterConnect.
Modules covered: OM, WSH, INV, PO, BOM, WIP, AR, GL, ECE, ECX, CLN
Elatior Consulting (Reg # 440 062 552 R.C.S. PARIS) December 2001 – July 2007
Company created to be able to work as an independent contractor
All missions sub-contracted through Epifit (********)
Essilor Europe (********) Oracle Application V11.5.10 12 months
Functional and technical analyst on Order Management, Advanced Pricing, Purchasing, Receiving and Oracle Receivables.
Responsible for implementing drop-shipment and back-to-back flows.
Worked on application tuning for high volume processing.
Involved in post go-live support and gave training to the technical support team in Thailand.
Areas covered:
- Advanced Pricing in Order Management, Purchasing and Inventory (intercompany pricing)
- Requisition Import, PO Auto-Creation, Receiving using open interface.
- Interfacing with an external warehouse management system (Gold).
- Auto-Invoice customization to respect specific business grouping rules.
- Interface with an external invoice printing system.
Essilor Brazil (********) Oracle Application V11.5.9 23 months
Main functional and technical analyst on Order Management, Advanced Pricing and Shipping Execution.
Involved in application tuning and post go-live support.
Worked both on-site and off-site.
Areas covered:
- Order import, Order keying, Defaulting rules, Processing constraints, Workflow order
- Reservations, Advanced pricing OM.
- Picking Packing Shipping customizations, COGS, Interface Trip Stop.
Essilor Ireland Limited (********) Oracle Application V11.5.8 9 months
Functional and technical analyst on Order Management, Inventory, Shipping Execution and Receivables.
Gave training to the technical support team in Thailand.
Worked both on-site and off-site.
Areas covered:
- Order Integration pre-Interface.
- Picking Packing Shipping customizations.
- Inventory management, backorder management, cycle count reservations.
- AutoInvoice, Invoice Printing.
Essilor Europe (********) Oracle Application V10.7 3 months
Worked on the logistic flow reconciliation process in order to track discrepancies between quotations and invoices.
Essilor of America (********) Oracle Application V11i 19 months
Detailed technical analysis on Order Management, Shipping Execution and Oracle Receivables.
Worked both on-site and off-site.
Areas covered:
- Order Import pre-Interface, Processing constraints, Dependences
- Interfacing with an external warehouse management system (PkMS)
- AutoInvoice, Invoice Printing, AR extractions
- Purging of Inventory, Order Management and Receivables transactions
Unilog (********/) August 1999 – November 2001
Work as a developer/analyst
Brandt (********/) Oracle Application V11i 8 months
Technical analyst on Order Management, Advanced Pricing, Inventory, Bills of Material, Purchasing.
Did customizations on the Workflow for Order Management.
Supervised junior developers.
Bull (********) Oracle Applications V11 8 months
Support (Corrections and enhancements) of logistic and finance customizations.
Responsible for Logistic customizations (group of customizations and developers).
Supervised and trained a new developer.
Bull (********) Oracle Applications 10.7 characters 7 months
Support (Corrections and enhancements) of logistic and finance customizations.
Responsibility of all the invoicing flow. Actor of the quality insurance process.
Honeywell (********/) Oracle Applications 10.7 SC 3 months
Technical support of Order Entry customizations.
Core Expertise
Functional/Technical analysis, specifications
Integration and Unit Testing
Training of end-users and support team
Post “Go-live” Functional and Technical Support
Code review, development (SQL, PL/SQL, Workflow, Forms, Reports)
Tuning (High volume processing, concurrent processing and hints to name a few)
Functional/Technical Skills
In-depth knowledge and understanding of Oracle 11i modules: Order Management, Advance Pricing, Shipping Execution, Inventory, Purchasing.
Good knowledge of Oracle 11i modules: Bill of Materials, Receivables, Payables.
Customizations using Open Interface Tables, API’s, Workflow, Forms Personalization.
Application integration using XML Gateway (Oracle XML Gateway Message Designer), Oracle Application Server InterConnect (iStudio) and E-Commerce Gateway.
Basics of Java: write small java stored procedures in order to interact with the operating/file system, or custom transformation for InterConnect adapters.
Oracle Certifications
Applications - Oracle 11i Supply Chain Certified Professional Consultant, Order Management
- Oracle 11i Workflow Certified Expert
Middleware - Oracle Forms Developer Certified Professional
- Oracle PL/SQL Developer Certified Associate
Database - Oracle9i Database Administrator Certified Associate
EDUCATION AND KNOWLEDGES
1999 Unilog IT Training (********)
Oracle Applications engineering, Quality Insurance, Testing methodology
1999 Master of Engineering Degree : Industrial System Engineering
French Engineering School: Ecole d’Ingénieurs du Val de Loire (********/)
Languages spoken : French, English (Fluent)