Patrice - Développeur VBA

Expérience professionnelle


Janvier 2009 – Septembre 2011 : “Ariba France SAS” - Premium Support Customer Manager – « Paris, FRANCE ».
Décembre 2012 – Aout 2016 : “SAP France SAS” – Expert Care – « Paris, FRANCE ».
Décembre 2016 – Présent : “Carrette Consulting” – Consultant VBA Expert – « Paris, FRANCE ».
Mon Objectif : Intégré une équipe et développer mes compétences clés tout en échanges de mes atouts.


• Project management planning, budget & resource management, estimations, risk & relationship management, advice, organization, procedures, coaching, transformation management
• Functional & processes consultant advice, documentation, process re-engineering, specifications, training
• Purchasing Manager / Senior Buyer Procurement position following the PO ordering to Invoice reconciliation process and management
• Change Management advice and guide businesses through change in processes, ways of working, ways of using tools; animate advisory and change boards
• Technical roles advice, architecture, audits, design, development, technical lead, training, procedures
• Audit Role Check points and curve analysis as well as functional versus planned
Employment / professional experiences (most recent)
December 2016 Present Consultant at SENEZConsulting - Paris, FRANCE .
Entering all the aspects of the Spend Management Upstream & Downstream process.
• Training delivery on one shot basis.
• Advise on best practices and architecture; challenge, review and question
• Process design & prototyping
• Work out test scenario s
• Integrate processes into business as usual

October 2015 August 2016 Expert Care Manager - SAP France SAS Cloud department ARIBA - Paris, FRANCE .
Final acquisition of the French entity Ariba France SAS and knowledge transfer to delocalize to Check Republic. Built the team from 2 individuals to 6 to respond to the demand in Upstream & Downstream for new customer and implementations. Coded all the program in VBA to speed-up and automatized KPI s and its legal monthly report.
• Introduce staff to Reverse Engineering
• Supplier Enablement & Ariba Contents Strategy
• Organize & steer fully global 360 view on suppliers and spend
• Organize supplier and commodity data enrichment
• Provide continuous benchmarking
• Provide market index sourcing analysis options
• New single harmonized global instance SAP/Ariba on SAP HANA
• Accommodate visibility for Single European Business Entity SBE approach with buy/sell, central led and hierarchical procurement and sourcing
• Bridge business expectations with IT and project pace in parallel with impressive organizational changes while also going through a heavy expansion period
• Setup worldwide supplier enablement program to support full electronic exchange E2E from sourcing until e-invoicing,
• Flight plan analysis
• Planning, follow up and escalation + change management
• Ariba Network integration
• Technologies Procure-To-Pay, Ariba OnDemand, SAP HANA
 
December 2012 October 2015 Expert Care Manager - ARIBA AN SAP Company Paris, FRANCE .
In charge of the largest ARIBA account AstraZeneca and its 18 Realms for Procure-To-Pay as Support Engineer. From NA, Mexico, Brazil, UK, China, etc. and all the locations across the globe for this pharmaceutical company. Dealing and consulting on templates, following deliverables, catalog s implementations.
Gave advice to the iBuy supporting group from Infosys based in UK and Asia. With access to Inspector the download of data could be done in a simple manner with better accuracy as the UI was not able to overcome more than 2000 lines.
• Educate resources on how to approach a global procurement/sourcing/contracts/invoice processing project
• Help to avoid project, organizational, procedural and architectural pitfalls
• RFQ preparation & coaching of resources thereto
• Assist with vendor evaluation
• Planning
• Guide business through acceptance of new and changed approaches
• Provide process design expertise; offer pragmatic and usage friendly solutions to process problems
• Create Business Value Case
• Provide input into rollout scenarios for 100+ countries in a 3 years timeframe
• Technologies SAP SRM, Ariba Procure-To-Pay, Ariba OnDemand, xml, aql Ariba Query Language , ABAP
• Methodology UML

September 2011 December 2012 Student during sabbatical year - University of Paris Descartes FONGECIF for Ariba France SAS - Paris, FRANCE .
Decided to get external computer science training during a sabbatical year and rather than a Master in project preparation chose the university standard study of the basics of Information Technology. Acquired programming science and development assets very useful in the database understanding with relations to the Cloud.

February 2009 September 2011 Premium Support Customer Manager - ARIBA France SAS Paris, FRANCE .
A Max Attention position for the customers TOTAL SA Upstream migration preparation
& ALSTOMPOWER Now GE Power template and UI set-up for Hydro, Gas Power, Nuclear, Thermal & Steam. Sourcing to Contracts & SPM Supplier Performance Management procedures and trainings delivered via collaborative tools. TOTAL SA budget load for Procure-To-Pay and multiple ERP Code implementations as well as SSO set-up with certificate edification. The goal was to relay the engineering in Slovakia for functional customizations to the executive decision makers and escalate any issues with the technical engineer team in Bangalore for native regressions.
Total SA Business consultant and functio-technical analyst
• Deliverables follow-up against SOW.
• Advanced Ariba customization & maintenance
o Implementation of urgent bug fixes.
o Solve performance problems post Ariba 8.2 upgrade.
o Implement commodity code conversion software.
o Implement user folder reorganization software.
o Review full code base and advice upon improvements.
o Formalize recommendations on conversion towards dynamic parameterization + implementation.
• Ariba 9 re-engineering upgrade feasibility study
o Investigate a new re-engineered usage of Ariba in combination with an upgrade to version 9r1 and the integration through migration process.
o Implementation of a proof of concept.
o Preparation of extensive demos.
• Advanced Ariba customization & development
• Faxserver integration
• Coordinate regional & global supplier enablement
AlstomPower Business consultant, functional analyst, VBA architect and interim project manager
• Ariba eForms Expense eForm, User Administration eForm, Transportation Logistics eForms, Supplier eForm, CostCenter Approval eForm
• Ariba & SAP Functional and technical analysis, customization, advice
o Technical analysis and design.
o Implementation of customizations.
o Setup test plans.
o Performance analysis and improvements.
o Functional and process designs.
o Manage the project from the technical implementation perspective during sabbatical of PM & coaching of developers
o Functional and technical analysis to setup a business intelligence BI environment for analysing spend data
• Methodology
• Technologies Ariba Buyer 4.4 & 9r1, Ariba Contract Compliance, Ariba Contract Workbench, Ariba eForms, Ariba Sourcing, Ariba P2P, Oracle, SAP.

December 2007 January 2009 Customer Support Specialist ARIBA Inc Atlanta, GA. U.S.A. .
Transition period after Procuri acquisition by ARIBA. Introduction to the Ariba Contract Workbench and Ariba Contract Compliance. Sourcing adaptation and CRM changes from Footprints to Siebel Oracle . Handling the largest customers as US Navy with 5 Realms, Air France & Microsoft.
• Manage implementation of Contract Management System
o Manage functional team and business relationships
o Manage implementation team
o Manage relationship with operations
o Manage relationship with system integrator
o Challenge functional and technical designs and technical implementation
• Manage implementation of Reporting and Analysis work stream within the program
o Manage functional team and business relationships
o Manage relationship with reporting system team
• Co-lead functional architecture for the entire program
• Technologies Ariba Contract Workbench 9r1 ACW , Procuri TOTALSource & Procuri TOTALContracts

August 2007 December 2007 Customer Support Specialist Procuri Inc Atlanta, GA. U.S.A. .
Training period and UI interactive knowledge transfer to gather all the corners and aspects of the .Net application. Excellent results with the WOW and customer satisfaction.
• Training & methodology to analyze and categorize platform assets on a detailed scal
• Technologies Procuri TOTALSource & Procuri TOTALContracts .Net Application APS.Net

June 2006 July 2007 Buyer & ACCESS Specialist - Spectra Metal Sales Atlanta, G. U.S.A. .
In charge of the balance between weight and volume of metal coil and gutters for the shipping to 9 US States agencies. Created a VBA Macro to automatize the shipping and its weight versus volume against quantities level versus needs for purchase order.
 Macro & Access ordering, customization & maintenance
 Business consultant, project and change manager, commodity hierarchy reorganization lead
 SOX and BI implementation
 Business analyst & functional analyst and change manager-trainer
 country wide multi-site rollout
 ISO 9001 v2000 implementation project lead
 Design + feasibility and charge study
 Advanced customization and maintenance
• Methodology ITIL partially & agile scrum derivative
• Technologies VBA, cxml, html, apache, SQL

May 2005 June 2006 Purchasing Manager American Trends Decatur, GA. U.S.A. .
Purchaser & Functional Buyer for a company which provided pre-packed fundraising kits with most items purchased from China. Long term planning and logistics organisation up to 6 months in advance.
• Pre-ordering & ordering process
o Formalize recommendations for the sales staff.
• Technologies EOE electronic ordering exchange .

July 2003 March 2005 Purchasing Manager European Imports Ltd Atlanta, GA. U.S.A. .
When the company Classic Gourmet was acquired by European Imports, I directed the transition between two different computer systems and the addition of 8000 items referenced. Organized and coordinated European Imports first culinary competition, Southern Pastry Classic . Re-routed container importation from Georgia to Illinois. Flew perishable products at high cost to import exclusive and luxury delicacy.
• Advice Senior Management Team on business change impact and help plan appropriate actions to accommodate the changes
• Planning and follow up
• Change and relationship management
• Supplier follow-up
• Analyze local business processes and relate to global designs
• Map existing processes to target local processes
• Redesign processes and propose improvements
• Manage local testing
• Organize local change management and training
• Steer local master data activities
• Fulfill local primary contact role for and towards the central team
• Process documentation
• Technologies Advanced Customized & Tailored system

January 2002 July 2003 Marketing Director - Classic Gourmet Atlanta, GA. U.S.A. .
Quickly promoted to handle the purchasing and marketing departments. Created the new catalog and organized the show Southern Pastry Classic . As purchasing manager I was responsible for all container importation and domestic purchasing. I accessed an application in the system to advance inventory accuracy and sales reports that could permit the sales of the company.
• Advice the business on fresh ways of working and doing more with less
• Guide business through acceptance of new and changed approaches
• Setup a Core Process Design approach
• Provide process design expertise; offer pragmatic and usage friendly solutions to process problems
• Drive a return to standard functionality, avoiding complexity and excessive maintenance overhead
• Advice on outsourcing options
• Advice on Solution scenarios, including SAAS options
• Create Business Value Case
• Advice on RFP preparation
• Provide input into rollout scenarios for EMEA countries in a 4-5 years timeframe
• Technologies DOS Based ordering system

February 2001 December 2001 Inventory Control Clerk Brasserie Le Coze in Lenox Mall Atlanta, GA. U.S.A. .
In charge of the procurement for the whole restaurant.
• Business process design
• Functional analysis and design
• Process and functional architectures
• Technical architecture, design and implementation
o Work out of the technico-functional architecture of several new ordering projects in a scalable environment.
o Write designs and implement requirements using a SMART Specific Measurable Attainable & Time-Bound architecture.
• Technologies Standard ordering software