Patrice Decroux

Experience

• 

  GFI Informatique

  Jan 1998 - Oct 2001

  Business Intelligence expert

  Creation of 2 datawarehouses using ETL GENIO and Business Objects reporting tool for Philip Morris on financial and commercial domains (projects named CORAS : Consolidated Orders Reporting and Analysis System and DME : Direct Marketing Expenses)My tasks were :• Coordinate interfaces development between SAP or SUN Affiliates (25 Affiliates for DME project) who send data to Philip Morris via text files.• Analyse and create the database model on the SQL Server DB according to datawarehouse properties (star schema) in order to increase performance.• Write ETL program specifications following Philip Morris conventions concerning ETL development.• Create ETL programs with GENIO based on specifications.• Build Business Objects universes in collaboration with Supply chain users to allow them extracting their business data.• Create and manage data access authorisations by users via Business Objects supervisor tool.• Create standards reports.• Give training and support users.• Create Business Objects scripts to automatically publish reports in PDF format on the Philip Morris Intranet Show less

• 

  Philip Morris International

  Nov 2001 - Sept 2010

  Migration to SAP V6 of the WCP system used by PMI:30 Affiliates worldwide18 Factories16000 users• Project leader in the OTC area at the head of a team of 4 persons:• Definition of the Scope of the upgrade in collaboration with the business community• Presentation & Validation of the scope to customers head of function• Analyze of unit tests • 80 Integration Test scripts written• Planification of 80 IT with 90 users• Coordination with the Central group in Poland & India for bug fixing• Cutover week-end to ensure data consistency at go-live• Post go-live support Show less Supervisor of 2 SAP R/3 SD, MM and 1 BW systems consultants on a complex SAP Plateform used by PMI worldwide (> 700 bio. Of cigarettes / year), responsible for 5 SAP companies, more than 50 users on the sales and supply chain areasI was in charge of:• Coordinating correction / changes in a continuously evolving business environment (write detailed specifications / customizing, follow-up development, tests and deliveries to customers)• Organize the interface monitoring between all partners (idocs driven environment)• Provide direct support, write user guide, give training to users Show less Responsible of the reporting system of the Supply chain department of Philip Morris International based on the tools Business Objects and Genio for the upload of sales and financial data (16 years of data, 15 dimensions, more than 20 indicators). My tasks were:• Ensure consistency of the SQL server reporting database• Create standard and adhoc reports for the user community• Establish procedures and give training on Business objects tools• Ensure the adaptation of the DWH according to the business evolution (new OLAP cubes or OLAP cubes evolution)• Webmaster of the trading department using Frontpage and then TeamSite (Interwoven) Show less

  • Project leader in the OTC area for the SAP P1 upgrade project to SAP V6

    Jan 2010 - Sept 2010

  • SAP System Analyst SD-MM

    Jan 2005 - Dec 2009

  • Supply chain - Reporting Analyst

    Nov 2001 - Dec 2004
• 

  Philip Morris International

  Dec 2010 - Jan 2012

  Responsible of the SAP configuration for the Project to move business between 2 warehouses

  Responsible of the SAP configuration for the Project to move business between a warehouse in Germany to a warehouse in Holland for a major Philip Morris entity:• Responsible for the SAP customization for the purchasing, sales flows & stock transfer order between the WHs.• Preparation of the specifications & validation with the business• Coordination for the development with shared service center in Poland and India• Development of an automatic interface for deliveries between the PMI entity in SAP and the new logistics provider outside SAP. Around 200 shipments each month are organized. Thanks to the interface, data is automatically transmitted to the new WH for preparing & shipping the goods.• STO configured between the 2 warehouses with VAT management.• Configuration & transmission of main information of the STO to an external system used for tracking purpose.• Testing and validation with the business• Cut-off activities• Post-go live period• PMI ABCD award (Above and Beyond the Call of Duty) received for the successful implementation of this project Show less

• 

  Philip Morris International

  Mar 2012 - Jul 2021

  Supply chain specialist with project management skills, in charge of collecting business requirements, project planning, cost estimation, writing / reviewing specifications, coordinating tasks with the developers, performing UAT with key users for the implementation of several below digital projects for PMI Duty Free department (>15 bio sales vol. incl. RRP in 2019, 2000 SKUs, 170 markets, 370 users)• "Demand Dashboard" system: Demand planning tool to forecast sales volume on 18 months horizon, having visibility on COT & IMS volume, customer stock & sufficiency, orders already placed by date of shipment (ETS) and arrival (ETA),… with the target of high Sales Forecast Accuracy. • Design and realization of a dashboard with Tableau reporting tool to calculate the Sales Forecast Accuracy indicator per different dimensions (time, geographic, customers, product type RRP or conventional,…) in order to focus attention and actions on markets with low SFA. • "Oasis" system: Customer order management web tool with full interface to SAP system for B2B processing flows, deliveries, shipments and billing documents including automatic email management for customer request & approval, communication with PMI teams like Order management, accounting & credit team. PMI “Recognition for Excellence Award” received for this project.• "Allegro" system: Documents storage repository for customer service team to centralize on one sharepoint plateform all documents linked to one customer order (communication with the customer, warehouse/factory, logistic service provider, credit management, bank,…and corresponding documents like customer approval, bill of lading, credit release approval, bank payment statement,…). PMI “Recognition for Excellence Award” received for this project.• Full Interface SAP SD flows including B2B specificity with local Duty Free environment in order to be able to use SAP data within local dashboards, reports and tools described above. Show less Responsible of the global SAP system for PMI Duty free and PM Switzerland domestic markets regarding the OTC / sales area – 2012 sales volume: >15 bio cigs (PMIDF) & >4 bio cigs (PMSA)Global SAP system: 30 Affiliates worldwide / 18 Factories / 16000 users• Project to interface customized materials descriptions into SAP outputs.• Algorithm written for the SAP program to upload customized materials descriptions into SAP material master tables.• Integration of the customized materials descriptions into the interface with the logistics provider in Holland.• Change management in coordination with IBM India & shared service center in Krakow.• Testing, deployment, training to users and post go-live support. Show less Migration from IBM AIX to MS Windows NT Operating System & from Oracle to MS SQL Server Database:• Testing scope defined & validated with business• 31 UAT Test scripts written & run with production security profiles• All Interfaces connected to SAP were tested & corrected (via idoc, text file, PI connection, MOVEit, RFC…)• Coordination with the Central group in Poland & India for issues resolution.• Cutover week-end to ensure data consistency at go-live• Post go-live support Show less

  • IT Project leader in the Supply Chain area

    Apr 2014 - Jul 2021

  • Team leader in the SAP OTC area

    Sept 2012 - Apr 2014

  • Team leader, SD/MM/LE areas, for the WINTEL Migration

    Mar 2012 - Aug 2012