Freelancer profile translated to English.
Back to original languageAbout Marcello
Consultant in ERP projects, change management and workshop facilitation, adherence to IT development practices and protocols (ITIL, Waterfall, Agile, AIM, etc.), SQL consultant, developer of databases, applications and interfaces, implementation of solutions and third-party integrations.
At AS Watson (London), I was responsible for all enhancements to our multi-org Oracle Financials EU instance as well as internal developments. I played a central role in a major transformation, undertaking consulting and development missions throughout the project (Oracle Financials 11.5.10 to R12.2.6 - 2-year cycle). In collaboration with our implementation partner, I defined the scope and specifications for a large number of enhancements, as well as transformed and redeveloped a significant number of UK and France-specific programs, packages, and customizations.
My responsibilities included supporting applications for several European business units, integrating BI systems, reporting, database and data warehouse development, as well as creating APIs, ETL scripts, and PLSQL packages for the finance, procurement, retail, and support functions.
I possess in-depth knowledge of stakeholder management, financial analysis, business application acquisition and integration, and IT development standards.
With over 15 years of experience in reviewing, managing, and collaborating with third-party providers, service providers, and implementation managers, including in support and development partnerships, I am accustomed to working in complex multidisciplinary environments.
English
Native or bilingual
French
Fluent
Italian
Fluent
Can work on-site
Marseille (up to 50km), Paris (up to 10km), Lyon (up to 10km), Toulouse (up to 10km), Montpellier (up to 10km)
Experience
- ALLOGA FranceIT Studies and DevelopmentLOGISTICS AND SUPPLY CHAINNovember 2023 - July 2024 (8 months)Marseille, France• Development and enhancement of PLSQL EDI procedures for the distribution of Alliance Healthcare products (pharmacies and hospitals)• Study and resolution of issues and bugs• Unit testing• Development of UNIX TRG scripts used to control incoming and outgoing XML and CSV interfaces (SQL loader, Oracle PLSQL procedures)• Enhancement and troubleshooting of OpenText ECS Delta EDI interfaces
- Airbus HelicoptersIT Product Manager EIIDAVIATION AND AEROSPACEMarch 2023 - August 2023 (5 months)Marignane, France• Development and enhancement of ServiceNow KPI reports• Participation in sessions on ITAR, Export Control, and Airbus data security• Familiarization with Airbus internal protocols• Updating CMDB records (ServiceNow)• Management of license renewals and improvement of spreadsheets (gsheets, Excel, Macro)• Familiarization with helicopter software suite, software platforms, and procurement process• Management of NoMachine Desktop license installations• Development of a KPI SQL extract and facilitation of the implementation of a Mantis BT application (Linux / Mongo DB/MySQL) designed for materials laboratory engineers
- AS WatsonSenior Oracle Financials AnalystRETAIL (SMALL BUSINESS)May 2013 - March 2020 (6 years and 10 months)Londres, United KingdomI was responsible for a highly customized Oracle Financials multi-org instance (R11 and 12).My responsibilities included overseeing all instance changes, maintaining the CEMLI codebase, applying ASW and AIM standards, supporting UK and France financial functions with reconciliations and month-end closes, troubleshooting the application for all business units, applying data fixes, developing application functionality (CEMLI), providing reports and data extracts, and developing third-party interfaces and integrations for the relevant business units:Superdrug, Savers, The Perfume Shop and Three Stores in the UK, Marionnaud France, A.S Watson (Health & Beauty) Benelux, Watsons Turkey, Watsons Russia and DrogasKey achievements and responsibilities:• Upgrade of Oracle Financials (11.5.10 to 12.2.6) for the EU-wide multi-organizational and multi-module instance, including CRPs, CEMLI transformations and specifications, and facilitation of UAT workshops (full cycle)• R12.2 functional expert for SLA and payment engine• Contractor evaluations and strategic business integrations with the Financial Management team Third-party integrations (P2P purchasing process and AP document flows)• Development and monitoring of Discoverer reports, Oracle Reports (RDF), BI Publisher, APEX• Performance optimization (SQL, PLSQL)• Technical data migrations (AP, AR, GL), including Euro Org (Latvia and Lithuania joining the Euro)• Functional and technical consulting for the implementation of the French FEC (Fichier des Ecritures Comptables) Development of Business Objects Web Intelligence reports• Consulting role in CRPs and workshops for the implementation of the Oracle Cloud payment module (UK project)
Recommendations
Be the first to recommend Marcello
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Mechanical Engineering with Energy and Aerospace Bac+4University Of Surrey1996Thermodynamique Mécanique (Statique et Dynamique) Mécanique des fluides (écoulements incompressibles et compressibles) Aérodynamique Analyse avancée des contraintes (contrôle non destructifs et destructifs) Matériaux Méthodes numériques Propulsion Math
- Mathematics in ComputingOpen University (M61)1999