• 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.
• 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.
Correction des composant s packages PLSQL ,scripts shell et
reports impactés par la migration.
Automatisation des créations de db-links et synonymes permettant
l échange de donnée avec les autres environnements satellites.
Debug , correction et tests de composants métiers spécifiques
Sièges , agents à l activité de CMA CGM
Support niveau 3 des anomalies remontées par les utilisateurs post migration.
Tuning des programmes présentant des problèmes de performance Hints, création d index, calculs de stats..
Développement d outils spécifiques de calculs de stats par modules
ou objets tables de travail, tables partitionnées, index ..
• 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.
Support fonctionnel assistance et formation utilisateur, paramétrage ERP.
Assistance à la TMA, Support technique
Supervision de la chaîne de production et calcul de prévisions
Mise en place d'évolutions sur le système existant analyse du besoin, rédaction de
spécifications fonctionnelles, paramétrage, réalisation de tests, rédaction de guide
utilisateur.
Participation à la mise en place de nouveaux projets en tant qu'analyste analyste
du besoin, rédaction de spécifications fonctionnelles, réalisation de tests.
Assistance aux contrôleurs logistiques.
• Requirement analysis, writing technical and functional specifications.
• Implementation of an information system providing the following functionalities
Assets Management, Contracts management
• 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.
Project Finavigate : Direct Debit for Millipore France
Modules: AP, AR, PO, GL.
Environments: Oracle Applications 12i, Oracle DB 10g, AIX.
• Developed an automatic direct debit program for all MILLIPORE customers.
Project Atlas: Technical and functional support for Oracle Applications system.
Developed of new reports, Forms and financial reconciliation interfaces for SAP
• 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.