CV/Mission de Consultant oracle hrms freelance

Exemple de missions de Karim,
Consultant oracle hrms habitant Paris (75)

EXPÉRIENCES PROFESSIONNELLES

Jan-2020 – Aujourd’hui
FDJ – Française des jeux
Back Office Finance Applications operations Manager

Environnements : Oebs R12, Oracle Hypertion, Oracke Control-M, IRBM, TERADATA, SAGE, FRP TREASURY
Modules : AR, AP, ETAX, GL, HRMS, Iprocurement (ICX), SLA.

• 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)

Sept2019-December2019
CNP ASSURANCES. Saint Cloud.
Senior Oracle e-business technical - functional Consultant

Environnements : Oracle Applications 11i, Oracle DB 9i, 11G Unix, Windows, Dimension, RQM
Modules : OKC, OKS, AP, AR, ETAX, GL, SLA.

• 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.

Sept2016-August 2019
SIACI SAINT HONORE GROUP PARIS – ACTIVUS BRISTOL UK
Technical Project Manager

Expats Health Insurance Broker back office
Migration V9 (Oracle Db) towards Actisure (Sql Server).

Environnements: Oracle9i, Sql Server, XML, C#, SSIS, Microsoft Visuals Studio, Web Services

• 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.

Sept2014–Déc2015
CMA CGM Pre-prod Department. Marseille
Technical-Functional Oracle e-Business Suite

Oracle Database Upgrade (9i to 11g)
Oracle Applications Upgrade (11.5.8 to 11.5.10)

Environnements : Oracle Applications 11i, Oracle DB 9i, 11G Unix, Windows, Dimension, RQM

• 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...).

Janv2013 – Juil2015
ESSILOR INTERNATIONAL. Creteil
Oracle Apps Functional Consultant

Functional Support Inventory, Focasts and Production

Environnements: Oracle Applications 11i, Oracle DB 9i, UNIX, Windows, PVCS

• 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.

April 2012 – Dec 2012
Building mini information system for Loan/mortgage broker
Helvetic Invest Sàrl. Geneva. Switzerland
IT Consultant

Environnement : WINDOWS, Easyphp,Apache Dreamweaver, PHP, HTML, MYSQL ,OFFICE2000, MERISE ,POWER AMC

• Requirement analysis, writing technical and functional specifications.
• Implementation of an information system providing the following functionalities
Assets Management, Contracts management

Jun 2010 – Jul 2011
Abbo informatique SA (Geneva-Switzerland) :
Oracle Applications technical-functional Consultant.

Oracle to SAP Migration for Merck Serono( (Davinci Project)
Modules: AP, AR, PO, IPROC, GL.
Environments: Oracle Applications 11i, Oracle DB 9i, AIX.

• 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.

Oct2007 – Oct2009
Merck Serono (Geneva-Switzerland):
Technical-functional Oracle Applications Consultant

Modules: AP, AR, PO, IPROC, GL

Environments : Oracle Applications 11i, Oracle DB 9i, AIX, Mercury IT Governance Center, Peregrine, Windows, Report 6i and forms 6i designer.

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.

Sept2014 Sept2015 Consultant fonctionnel Oracle Applications
Préproduction CMA CGM. Marseille. France

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.

Environnements Oracle Applications 11i, Oracle DB 9i,11G Unix, Windows, Dimension , RQM

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 ..

Jan2013 Fev2014 Consultant fonctionnel Oracle Applications
Essilor International. Créteil. France
Support fonctionnel sur l application de logistique et gestion de stocks.

Environnements Oracle Applications 11i, Oracle DB 9i, Unix, Windows, PVCS

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.

Avril2012 Déc2012 Consultant système d information
Helvetic Invest Sàrl . Genève.Suisse

Environnement WINDOWS ,Easyphp,Apache Dreamweaver, PHP, HTML, MYSQL ,OFFICE2000, MERISE ,POWER AMC

Analyse de besoins, spécifications fonctionnelles.
Conception du MCD, MLD et MLP pour le SI composé de données clients, prêts et assurances.
Développement d interface Web intranet pour la manipulation de données

Juin 2010 Mars 2012 Consultant technico -fonctionnel Oracle Applications.
Abo informatique SA. Genève .Suisse

Environnements Oracle Applications 11i et R12, Oracle DB 9i, AIX.

Projet Davinci de Migration Oracle to SAP pour Merck Serono .
Modules AP, AR, PO, GL

Développement d outils de migration Oracle Apps vers SAP et SCALA pour les données suivantes Clients, fournisseurs, transactions lnventory, Transactions Balances GL
Pour les pays suivants Turquie, Isra l, Grèce, Australie, Suisse.

Projet Finavigate Direct Debit pour la filiale Millipore France
Modules AP, AR, PO, GL

Développement d'un outil automatique direct debit pour les clients de Millipore.

Oct2007 Oct2009 Consultant européen technico-fonctionnel Oracle Applications
Merck Serono. Genève. Suisse.
Support technique et fonctionnel Oracle Applications finance et logistique.
Projet Atlas Développement de nouveaux reports, Forms et interfaces de réconciliation financière..

Modules AP, AR, PO, GL
Environnements Oracle Applications 11i, Oracle DB 9i, AIX, Mercury IT Governance Center, Peregrine, Windows, R...