• Monitoring Control –Invoicing and Accounting weekly and daily batchs on the productions environements;
• 2nd level support / analysis and troubleshooting for technical and functional incidents.
• Creation and Tracking Tars and Patching the environments
• Homologation and deploying RFCs on the productions environnements
• Developed a range of alerts to the pro-activity in the treatment of transactions before maturity of fences accounting using Oracle Alert.
• Tuning the production through statistics calculations (db, Gts, Weblogic) and tables partitioning
• Keys Users support on the Accounting monthly closure.
• Supervision of the differents inbound, outbound interfaces between Oebs and others systems like Terradata (big data analysis), Sage, (Treasury), TRADESHIFT (dematerialized edi invoices)
• Second level support on incidents reported
• Writing functional and technical specifications
• Fix component (PLSQL packages, shell scripts, and reports)
• Creation of automatic invoices, adjustments and legal fiscal reports.
Expats Health Insurance Broker back office
Migration V9 (Oracle Db) towards Actisure (Sql Server).
• Identification of functional objects to migrate (Brokers, Providers, Claims, Exchanges rates, Procedures Codes, Clients, Insurers, Carriers.
• Definition of migrations samples, data trans-coding schemes, depth of recovery, pre- cleaning operations, and post-migration operations.
• Writing the data migration roadmap, establishing Gantt diagram and highlighting the migration critical path and objects precedence constraints
• Implementation of extraction, cleaning and recovery preparation processes.
Oracle Database Upgrade (9i to 11g)
Oracle Applications Upgrade (11.5.8 to 11.5.10)
• Fix component s (PLSQL packages, shell scripts, and reports) impacted by the migration.
• Writing functional and technical specifications
• .Fix component s (PLSQL packages, shell scripts, and reports) impacted by the migration
• Automation of db-links creations and synonyms allowing the exchange of data with other satellite environments
• Second level support on incidents reported by by post-migration users.
• Tuning programs with performance problems (Hints, index creations, stats calculations…)
• Development of specifics scripts for stats calculations by modules or objects (partitioning tables, functions indexes...).
Projet d upgrade du SI OCEAN de CMA CGM Migration de la base de données Oracle de la version 9i vers 11g.
Migration de la partie applicative de 11.5.8 vers 11.5.10.
Functional Support Inventory, Focasts and Production
• Evaluative and corrective maintenance of Oracle Applications environments.
• 2nd level support / trouble shooting for technical and functional incidents
Within financials modules
• Design and Developed of interfaces for financial reconciliation.
• Developed and updating of forms, reports, specific PLSQL packages and stocked procedures.
• Developed workflows for processing expenses and establishment of new notifications.
• Supervision of monthly accounting closures.
• Assisting users.
• Requirement analysis, writing technical and functional specifications.
• Implementation of an information system providing the following functionalities
Assets Management, Contracts management
Oracle to SAP Migration for Merck Serono( (Davinci Project)
Modules: AP, AR, PO, IPROC, GL.
• Developed Oracle Apps to SAP and SCALA migration tools for the following items: Customers, suppliers, inventory transactions, GL Balances Transactions, writing technical and functional specifications.
Concerned countries: Turkey, Israel, Greece, Australia, Switzerland.
Modules: AP, AR, PO, IPROC, GL
• Evolutive and corrective maintenance of Oracle Applications environments.
2nd level support / analysis and troubleshooting for technical and functional incidents within Financials modules
• Design and Developed of interfaces for financial reconciliation.
• Developed and updating of forms, reports, specific PLSQL packages and stocked procedures.
• Developed workflows for processing expenses and establishment of new notifications.
• Supervision of monthly accounting closures.
• Assisting users.
Modules: AP, AR, PO, GL.• Developed an automatic direct debit program for all MILLIPORE customers.
Environments: Oracle Applications 12i, Oracle DB 10g, AIX.