Back Office Finance Applications operations Manager
• 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...).
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.
Building mini information system for Loan/mortgage broker
Helvetic Invest Sàrl. Geneva. Switzerland
• Requirement analysis, writing technical and functional specifications.
• Implementation of an information system providing the following functionalities
Assets Management, Contracts management
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.
• 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
Environments : Oracle Applications 11i, Oracle DB 9i, AIX, Mercury IT Governance Center, Peregrine, Windows, Report 6i and forms 6i designer.• Developed an automatic direct debit program for all MILLIPORE customers.
Environments: Oracle Applications 12i, Oracle DB 10g, AIX.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.