Patrick SELLEM

En résumé

Entreprises

• ROLLAND S.A - JDE Finance consultant on site

  2017 - 2018 Applications
  • JDE Finance support and set-up on several finance applications from modules Account Payable, Account Receivable and General Ledger such as:
  - Drafts
  - Intrastat / DEB
  - FEC (French Accounting Writing File)
  - Customer and Supplier Balance
  - A/R and A/P Netting
  - VAT declaration (DAS report)
  - Indexed Allocations
  - Sales Update
  - Open A/P and A/R Amount - Asof date
  - Manual and Automatic Payments
  - A/P Bank Account set-up
  - Reminders letters
  - G/L Reconciliation with Debit/Credit Match
  - Intercompany Orders
  - Monthly and Annual Close
  - Match Voucher to Open Receipt
  - Credit Reimbursement
  - Customer Credit limit
  - Stock allocations
  
  Environment E1 - 9.2 Application Release
  

• Bureau Veritas - JDE Finance consultant on site

  Puteaux 2016 - 2017 Applications
  • Modification and restructuring the Chart of Account with new integrity rules for new affiliates
  
  Environment AS400 - World Software
  

• Pernod Ricard - Back Office Project Manager J.D Edwards & BI Publisher developer

  PARIS 2002 - 2015 JD Edwards Finance Expert , BI Publisher developer
  Knowledge of JDE finance modules (GL/AP/AR), Purchase Order (stock & non-stock), Fixed Assets
  - E1 Expert BI Publisher developer
  - Participation to the main ERP projects in affiliates of group Pernod Ricard (Ricard, PR Swiss, Pernod, PR Europe, Core Model):
  - Training and user tests
  - Writing of Book of Needs
  - Review system set-up
  - Tests interfaces and conversion of data from «legacy systems»
  - Evaluation, specifications and tests of specific developments
  - Support after go-live, analysis of the integrities and discrepancies
  - Help users during the monthly and annual closes
  - Review of the accounting during financial audits
  - Implementation and training on enhancements of JDE Net Change
  - Sharing of the good practices with affiliates:
  - Maintenance of Common platform Pernod-Ricard
  - Naming convention
  - Analyze of JDE finance functionalities and elaboration of workaround solutions
  - Follow of the Oracle cases logged by all Pernod-Ricard affiliates
  - First contacts with Oracle Response Line
  - Analysis, escalation of critical issues with Business Case
  - Tests of solutions proposed by Oracle on E1 Application Release 9.1 / Tools Release 9.1.3.1
  
  
  General Ledger
  - Account set-up : Business Unit , Object accounts and sub-account
  - Creating and Reviewing Journal Entries , Reverse Journal Entries, Reccuring Journal Entries
  - End of period closures
  - Setting up Constants for General Accounting (Inter-company settlements for multiple currencies. . .)
  - Currency Exchange rate
  - Fiscal Date Patterns
  - Creating and Updating Chart of Account (CoA) : building CoA template and upload it in JDE from Spreadsheets
  - Setting Up GL Automatic accounting instructions (AAIs)
  - Review GL allocations
  - Work with Budget Patterns and Annual Budgets
  - Account Reconciliations
  - Trial Balances
  - G/L reports and balance reports
  - Currency restatement
  - Reposting Account Ledger
  
  Accounts Payable:
  - Setting up constants for A/P
  - Setting up payment terms
  - Setting Up Next Numbers for A/P
  - A/P Automatic accounting instructions (AAIs)
  - A/P Tax Setup
  - A/P tax reporting
  - Supplier informations
  - Setting up Bank Accounts by supplier
  - A/P Voucher process (batches control, approval and posting)
  - Standart Voucher Entry
  - Speed Voucher Entry
  - A/P speed release
  - Revising and Voiding Posted Vouchers Entries
  - Logged Vouchers
  - Prepayments
  - Recurring Vouchers
  - Setting up Payment instruments
  - Automatic and manual Payments
  - Void automatic and manual Payments
  - A/P Draft process
  - A/P integrity reports
  
  Accounts Receivable:
  - Setting up A/R constants (batch approval , payment terms, next numbers)
  - A/R Automatic accounting instructions (AAIs)
  - Setting up A/R Tax rates
  - Setting up A/R Tax rules
  - A/R tax reporting
  - Customer informations
  - Invoice process (standart invoice entry, recurring invoices)
  - Approving and posing invoices
  - A/R speed status change
  - Standart Receipts and Speed Standart Receipts
  - Processing Automatic Receipts
  - A/R Automatic accounting instructions (AAIs)
  - A/R Drafts process
  - Credit and Collection management
  - Delinquency notices
  - Credit reimbursements
  - A/R reports and integrity reports
  - Batch invoice process
  - Manual and automatic Match payment invoice process
  - A/R and A/P Netting Process
  - A/R tax reporting
  
  Fixed Assets
  - Creating an Asset Master Record
  - Category codes of assets
  - Location of an asset
  - Process G/L to F/A (approval and posting Journal Entries to Assets)
  - Seting up Asset account (Asset cost accounts Accumulated depreciation accounts Asset disposal accounts)
  - Fixed Assets Balances
  - Depreciation Entries
  - Posting Depreciation to G/L
  - Calculating Asset Depreciation
  - F/A Journal Entry
  - Split F/A
  - Transfert F/A
  - Disposal F/A
  - F/A Automatic accounting instructions (AAIs)
  - Depreciation Projections
  - F/A reports and integrity reports
  
  JD Edwards technical skills
  - SQL statements
  - Web thin client E1 9.0

• SEAGRAM FRANCE DISTRIBUTION - BUSINESS ANALYST SUPPORT J.D EDWARDS FINANCE

  1996 - 2002 Applications
  • I investigate and research open application problems/issues escalated from local MIS and the Help Desk.
  • I coordinate with both the GBP development team and/or JDE directly, and present solutions and findings to users.
  • I participate in the implementation of common financial systems in Europe.
  • I assist in the implementation of financial projects (Y2K and EURO conversion) and potential upgrades of existing software, working closely together with other members of GBP Finance team, and project planning with the business.
  
  Environment AS400 - World Software
  JD Edwards One World Xe (B7333), since one year in Company RICARD, I realize the integration of main data from external CICS systems to Software JDE and I provide the global support of all financial JDE applications.
  JD Edwards World Software (7 years in Seagram Corporate)
  I provide the source of consultancy and advice in the J.D.E financial applications, namely: General Accounting, Accounts Receivable, Accounts Payable, Address Book, Fix Assets, Purchase Orders and additionally all reporting tools available within the J.D.E products (Dreamwriter, Worldwriter, and Faster).
  
  

Formations

• Université De Technologies

  Compiegne 1991 - 1992 MASTERE SPECIALISE "Conduite de projets informatiques"
  
  Mécanique / gestion de projets

• CNAM

  Paris 1983 - 1990 Génie logiciel

• Université Paris 13 Paris Nord Villetaneuse

  Villetaneuse 1980 - 1982 DUT Informatique de gestion

Réseau

• Bruno COULEAU

• Frank GAUDET

• Gilles BOISSY

• Guillaume DAUTRIF

• Hédi MERCHAOUI

• Jérémie MORITZ

• Raffaele CUSENZA

• Thibault PAUL-DAUPHIN

• Vincent MEUNIER