Menu

Laurent SERRA

En résumé

Avec 35 ans d'activité professionnelle dont 22 en informatique, je suis sérieux, organisé et autonome. Ayant évolué de technicien à directeur/chef de projet, reponsable SI, mes connaissances et compétences en informatique sont trés étendues et me confèrent un profil technico-fonctionnel: Je maîtrise tous les aspects d'un projet et peux m'impliquer à divers niveaux. J'ai eu la chance de participer à des projets d'envergures, stratégiques, internationnaux, comprenant des SI hétérogènes ainsi que des équipes multi culturelles, ce pour des clients grand compte. Je suis rompu aux méthodes ainsi qu'a la qualité. Cadre depuis 2002, mon métier ma naturellement orienté vers les ERP (SAP, Navision) autant en TGE qu'en middle market. Je maîtrise les technologies WEB, celles ci progressant dans ce secteur depuis une dizaine d'années et impactant toutes les activités.
Maîtrisant les SI, les technologies, ayant acquis méthode, pratique de l'organisation et du management je suis à même de garantir la réussite de tout projet de son étude de faisabilité à sa recette finale. Ces dernières années j'ai travaillé en FREELANCE puis j'ai créé ma société qui a grossie peu à peu.

Mes compétences :
Anglais
Comptabilité
Conseil
DotNet
ERP
Immobilier
Informaticien
Informatique
Microsoft Dynamics
Microsoft Navision
Santé
Web
Direction de projet
Gestion de projet
Gestion de projets internationaux
Conduite de projet
Gestion
ITIL
Ingénierie
Industrie
Formation
SQL
Java EE
Management
Oracle
JavaScript
Microsoft Dynamics NAV
Audit
SAP
MySQL
Microsoft Access
Microsoft Windows 2000 Server
Navision
Microsoft Excel
Visual Basic for Applications
SQL Server Reporting Services
SAP FI
Personal Home Page
Microsoft SQL Server
Microsoft Project
Database Design
Business Intelligence
budgeting
Visual Basic
SAP R/3
SAP MM Information System
SAP MM
SAP CO
SAP ABAP
Project Management
Microsoft Windows NT
Microsoft Windows
Microsoft Office
Linux Red Hat
Gap Analysis
EDI
C++
Apache WEB Server
solution design
screen maintenance
sales management
maintenance
extensive skills
eCommerce
double skills
defect analysis
common costs analysis
business processes analysis
budgets
Website Design
VPN
UML/OMT
Supply Chain
Software installat

Entreprises

  • CENTAURE-ITS - Head of NAV department

    2010 - maintenant NORRIQ UK and NORRIQ BE: project Manager and Solution Architect.
    Dynamics NAV 2016 and 2017 implementation, beverage DRINK-IT add on implementation

    THE KNOWLEDGE ACADEMY (UK): Dynamics NAV 2009 and 2015, Dynamics NAV leader, head of NAV department.
    * Managing support and development for Dynamics NAV 2099 Classic client
    * Improving business processes (financial and sales) in accordance with the CFO
    * Leading and managing migration to Dynamics NAV 2016 ;
    * Migration plan
    * Architecture
    * Functional requirement, improvement
    * Technical specifications

    PRONATURA (France): Dynamics NAV 2015, migration from NAV 2009 classic client
    * Project migration leader: in charge to set the project and the migration plan, train the IT team on the new version (technical and functional), lead and support each phase.

    ANTSYS (France): Dynamics NAV 2015
    * Project manager, Dynamics implementation focus on financial and Sales & Purchase. ;
    * Training project teams to Dynamics NAV 2015, functional, technical and implementation method ;
    * Defining planning, milestone ;
    * Setting architecture (application, server)

    ITP-INTERPIPE (France): Dynamics NAV 2013 R2
    * Project manager, project focus on financial, supply chain and resources (Timesheets/projects/budget). ;
    * Leading the global solution ;
    * Implementing new functionalities ;
    * Supervising tests and sign off ;
    * Managing NAV supplier in charge of developments

    MARS / ROYAL CANIN (Italy): Interface Project manager, NAV consultant, Dynamics NAV 2009 and V4 :
    * CORE interfaces implementation lead using Agile Method. ;
    * Business and Interfaces fit gap analysis ;
    * Interfaces analysis / data: NAV tables per department to map with 3rd party software (production, banking, logistic, BI, web portal, PDA) using Xml files / BizTalk ;
    * Italy rollout

    ECORE / TRAFIGURA: International project (10 countries), Dynamics NAV 2013 implementation
    * Global NAV project leader and NAV consultant focus on sales, purchases and logistic and supervising Finance, manufacturing, interfaces. Using waterfall delivery method / Sure Step
    * Setting planning / phases ;
    * Global business and fit gap analysis lead (AS IS, To Be).
    * Leading BI implementation in relation with the BI supplier (QlikView)
    * Active in implementation and team leader: Data migration, security, training, UAT test
    * In charge to select and hire new NAV consultants according to milestone of the project.

    TECTURA UK / PUMA Energy (Europe, Africa): NAV consultant. Global Dynamics NAV 2009 Level 2 support for Africa, Europe.
    * Global functional support: Any NAV Department: Setting and workflow, defect analysis. ;
    * Global support manager deputy: Active in Team and support organization, implementing processes, SLA ;
    * PUMA Navision add-on: trainer for trainer

    TECTURA USA / HEINEKEN (Europe, Africa, La Reunion): BI expert in charge to optimize existing BI implementation / Dynamics NAV
    * In the scope: MS Server 2008, SQL Analysis services (OLAP cubes) /reporting services, Jet Reports, QlikView, NAV V5 ;
    * Audit ;
    * Analyzing both software (setting, code) and hardware architecture, providing preliminary Infrastructure and data processing solutions options

    HOMECOM (CPLE): Microsoft certified trainer. Official NAV trainer for Microsoft France (currently MCT for 3 years since 2011, currently MCT Alumni)
    * Dynamics NAV V5, 2009, 2013: Set up and Financial, Trade and inventory, BI For IT worker, Development, installation and set up ;
    * Sure step
    * Object oriented design and Dot.net
    * UML 2
  • Centaure-ITS - Dirigeant / Consultant

    2010 - maintenant Mon activité s'articule principalement autour de:

    MOE/MOA

    Expert Microsoft dynamics NAV 2015, 2013, 2009 et V5:
    Formations (MCT)

    Conseil en SI: Audit, analyse, optimisation, proposition et mise en place des solutions

    Conception d'outil d'aide à la décision, BI.

    Etudes et développement WEB

    Je dispose d'un service de traduction spécialisé de document IT (FR<->ENU):

    J'interviens principalement à l'international, dont notamment ces années passées pour:

    - Mars Incorporated / Royal Canin: Interface project manager (Italy)

    - ECORE/GDE( 15 countries): Global NAV Project leader: Business analysis, Fit analysis, design, deployment (data migration, security, training, application setting)

    - Tectura UK /Puma Energy (Africa, Europe): Dynamics NAV Support and team leader

    - Tectura USA / Heineken (Africa, Europe): BI manager

    Mais aussi:

    - ITP interpipe(Paris): Chef de projet recette NAV

    - ANTSYS (bordeaux): NAV implémentation leader

    - PRONATURA (Cavaillon): NAV Project migration leader

    - Homecom (PARIS): NAV MCT (3 ans)

  • Prodware - Project Manager / CIO

    Paris 2008 - 2010 , International and IS project manager (CIO), Consultant, developer, PRODWARE Dynamics NAV Financial consultant / Technical project manager:
    * Gap fit analysis, setting application ;
    * Developing required functions, Workflow customization, customizing forms and reports, data migrations.

    Project manager : Rebuild of the Information system of EUROGROUP Consulting (500 users):
    * Management and lead of the Dynamics NAV implementation and the contractor involved. Negotiating costs and time limit.
    * In charge of the internal department organization according to this new IS to guide any employee in this new way to do the job, setting workflow and method, organizing interactions between departments.
    * Organizing and managing many session with all services to simulate a production environment to get the solution/user validation
    * In charge of the BI solution mainly for financial purpose:
    * Determining Report specifications with each department manager: 80 reports ;
    * Implementation of MS SQL Reporting services ;
    * Developing 10 reports/80 using SQL studio ;
    * Audit with each department to determine role, permissions
    * Meeting with all department to set Role and permissions
    * Setting permissions and roles into Reporting services ;
    * Active in Training on Navision and the SQL Reporting services Administration to key Users and Administrator ;
    * Active in application set up ;
    * Providing user documentation and administrator documentation

    Program director / Project Manager: Global Navision implementation and BI leading:
    * Responsible of international projects, Project management and lead from the gap analysis to the sign off (Kick off, Review, WORKSHOP, resources and cost management, managing both technical and functional teams).
    * Implementing the best solution: Architecture, BI solution.

    CIO / Project Manager assuming BA, gap fit and NAV administration: Rebuild of the information system of the PRODWARE Group (1000 employees):
    * Role 1: Managing 3 Consultants and 3 Developers. In charge of the global Dynamics NAV implementation: Audit of each PRODWARE departments (Navision, Sage, Support and infrastructure, AX, Accountancy, Sales, Purchase and Marketing).From gap analysis, setting required developments and the validation workflow (DEV, Test, UAT, PROD database), deployments, user documentation and training.
    * Role 2: Lead of the EDI implementation: Auditing sales and purchase departments, analysis, setting solution in accordance with requirement, implementing EDI software, leading development to interface NAVISION with The EDI (Xmlport)
    * Role 3: lead of the BI. In accordance with the reporting required by the managers, setting SQL Reporting services based on NAVISION OLAP cubes ;
    * Role 4: Lead of the information system:
    Dynamics NAV administration and set up.
    Network management,
    Active directory management
    Microsoft servers management (operating system and database)
    This role 4 includes maintenance, back up, Architecture choice and evolution, the best running and performance day per day with emergency road map in case of server crash. This includes to set the system to metric the system performance
  • PRODWARE - Chef de projet ERP SI

    Paris 2008 - 2010 Chef de projet client : Rattaché au DSI, responsable de l’implémentation de NAVISION, conduite et gestion de projet, gestion des prestataires dans le cadre de la refonte du SI, définition des besoins, workshop et recette, formation des KeyUsers, rédaction des manuels utilisateur, analyse des coûts réels et prévisionnels

    Chef de projet interne : Refonte du système d’information du groupe PRODWARE et implémentation de NAVISION 5 ce comprenant la rédaction des fiches d’écart, le paramétrage fonctionnel, la prise en charge de certains développements, la formation et le support.

    Chef de projet / direction de projet : En charge de projet internationaux pour des clients, gestion et conduite de projet de l’analyse des besoins à la recette.
  • Thyssenkrupp Elevator | ALIANT - Chef de projet

    2006 - 2008 Projet international sur 27 pays. Etude des « process » business et IT de chaque pays afin d'analyser les temps d'installation des ascenseurs dans un objectif BI et optimisation des coûts. Conception spécifique d’outils visant à créer et exploiter une base de connaissance européenne interfacée avec les systèmes informatiques hétérogènes existant (SAP, NAVISION, ACCESS, LOTUS, Spécifiques), développement d'un outils WEB pour les pays n'ayant pas de SI (LAMP).

    Pilotage et gestion du projet. Prise en charge de la partie Européenne à la fois fonctionnelle et technique. Synchronisation par l'intermédiaire des DSI des modifications des systèmes d'information des différents pays, mise en place d’une harmonisation européenne de la production. Rédaction des documentations utilisateur et technique, déploiement.
    Langue de travail: Anglais.


    Projet national dans le cadre de la loi sur la protection du travailleur isolé.
    L’objectif étant de permettre un suivi constant de l’état de santé des installateurs d’ascenseur à un niveau national, régional et agences (50). Pilotage, gestion, analyse, choix des solutions et mise en oeuvre, Développement logiciel (LAMP) recette.

    Projet national de migration logicielle :
    Projet national de déploiement d'une nouvelle version d'un logiciel propriétaire de CRM/Gestion commerciale dans les 50 agences THYSSENKRUPP ascenseurs France. Pilotage, conduite du projet, gestion du prestataire éditeur.
    Projet d’étude: Passage d’une BD MySQL à ORACLE. Etude globale de la migration et gestion de l'impact sur l’ensemble des logiciels de gestion/production existants France. Evaluation coûts, Délais, étude analytique
  • ThyssenKrupp - International Project manager, thyssenkrupp elevator

    Saint Barthélemy d'Anjou 2006 - 2008 * International project within 27 countries in Europe. The goal was to metric elevators installation times / cost and to follow up technical installation.
    Fully responsible and decision maker managing and leading the project (2 Million Euros). The European information system had to be created to support a new BI from scratch; this project has been done completely alone concerning the European side even if it was possible to freely hire resources:
    * Situation at the beginning: Many different cultures, many different way to work, many different country information systems (based on SAP, NAVISION, proprietary software, Access, Lotus, MySQL, sometimes nothing), different data recorded according to country's needs hence missing information for the BI. 2000 users. Specifications in a few words and a very simple Excel Files.
    * Constraint: Information system in 20 languages option, network access everywhere with permissions according to roles, no access to the global active directory, no commercial solution, to decrease the cost as far as possible, avoid double entries for countries with an IT system, provide IT solution for countries without IT system.
    * Role:
    * Set Specifications with the senior managers ;
    * Audit of each country to determine if their information system can match with the data requirement for BI and to determine their business rules.
    * Making gaps analysis ;
    * Design of the European database (MySQL) ;
    * Choice and purchase of the server (IBM X series) ;
    * Operating system installation and setting (Linux Red hat 4 Enterprise) ;
    * MySQL server installation and setting
    * Apache server installation and setting
    * Mail server installation and setting
    * Ftp server installation and setting ;
    * OS Firewall setting under CISCO firewall and router ;
    * DNS setting and network
    * TSE setting
    * Maintenance and backup setting for all part ;
    * Developing a tool based on PHP with many forms in 20 Languages to provide software for country without IT system for their day job. Implementing permissions and role in the software according to a deep analysis with countries.
    * Setting with Countries' CIO the changes to do on their IT. Also Involved as Technical consultant to determine all customization to do on SAP, NAV, etc.
    * Interfacing the different countries' IT system with the European database to avoid double entries and to let employees work as they always did.
    * Developing all Reports (40) in PHP with export to Excels, this includes different level of report according to manager `role.
    * Concerning the Web software, lead of the tests involving Key user, writing test script, organizing multisession. Denmark was the first country in Production before to deploy to other countries.
    * Writing user, technical documentation ;
    * All the project long: Active in project implementation activities (Planning, rollout)
    Active in the management of country teams covering all aspects (planning, processes, budgeting, resources, risk and technical, human).
    Active participation at international workshops and meeting with ThyssenKrupp senior management. Monthly meeting for report cost and progress in Essen (Germany)

    Environment:
    European server: Red hat enterprise 4, apache, MySQL, PHP, Ftp, Qmail on an IBM server X series.
    Countries details:
    Operating system: Windows NT, 2003 server, XP
    Database: Oracle, MS SQL Server Flat files, MS Access
    Software: Navision - SAP: MM, FI/CO And CATS - proprietary software
    Other: MS Excel, Word, IE, MS Project


    * Deployment project of a new version of ThyssenKrupp software used in their 50 French branches (material maintenance, new installations, CRM, Sales and accounting).
    * Role: Responsible for the management covering all aspects (planning, processes, budgeting, resources, risk and technical, human). Organization and active participation at workshops. Writing test script and Leading test team (4 people).
    Management of defects with the software editor.
    Deployment of the new version in 4 test branches providing support in the meantime before the national deployment.
    Management and lead of the national deployment and setting the support team.

    Environnent : MS Project, Oracle data base, CITRIX, VPN

    * Lead for the development of an internet software. Its purpose was the protection of isolated worker for compliance with French laws for the 50 French branches
    * Management of 3 people: Mobile developer, PHP developer, tester. ;
    * Organization and active participation at workshops ;
    * Database design and software engineering, developing the Web tool.
    * Trainer on the Mobile software organizing training fort the 50 branches

    Environment:
    Windows Server, SQL server Mobile telephony (PPC), LAMP technology, Oracle database, Onebridge, some PHP and JavaScript programming, ASP Programming.

    * Migration from MySQL to Oracle database for ThyssenKrupp France. ;
    * Roles: Audit of the IT, determination of the ORACLE database design. Impact study for all relevant French applications using primarily the MySQL database

    Environment: MySql and Oracle database, C++ and Delphi based applications, PHP applications, Windows server, Wmare
  • Assystem - Ingénieur projet

    Courbevoie 2004 - 2006 Conduite et gestion de multi projets concernant l'amélioration du logiciel de gestion des coûts de la maintenance, sa mise en conformité avec l'évolution informatique internationale du groupe, son extension et déploiement à de nouvelles directions.
    Passage à un serveur SAP Maître localisé à Paris pour toutes les entreprises du groupe AREVA, Réorganisation de la comptabilité générale et du contrôle de gestion, homogénéisation de tous les modules SAP et codifications.
  • AREVA - IT Engineer Project manager, ASSYTEM SERVICES

    Paris La Defense 2003 - 2006 * Migration project of base decision (maintenance department/ Costs controlling) software according to the
    Implementation of the new International AREVA Core System based on SAP/ORACLE.
    * Role:
    * Audit of the new Core System: All standalone SAP servers from each AREVA company all over the world had to migrate to a Global server in Paris and become secondary servers in the forest. ;
    * Active in Code, account harmonization in the global database; checking data validation concerning the accountancy for Eurodif with the chief accountant
    * Active in the data transfer to the global server using a secured dedicated line.
    * Modifying the Interface with SAP to connect the software to the new global server
    * Modifying the Access database implementing the new Global server architecture
    * Modifying the coding to adapt queries and data processing
    * Adding new functionalities to the software ;
    * Was Responsible for all aspects of the project (planning, budget, resource, risk technical) during all phases of the software lifecycle. Analysis of new needs and determining new software functionalities after a business process analysis has been done. Management, solution design from the gap analysis to the documentation and support
    * The new updated based decision software has been used by EURODIF to validate their accountant data.

    * Implementation project: The software has to be also deployed to production department and so had permitted to have a global view of maintenance and production costs to quickly decide future budgets according to actual costs and history. This part is similar to the initial department software built in 2003
  • the IT department - IT Engineer Project manager, AREVA - EURODIF PRODUCTION

    2002 - 2003 * BI Project: Costs analysis (45 million Euros) for the maintenance department based on a SAP system (SAP/ORACLE), the goal was to metric costs of the past activity to set budget for the next years and year after year to metric the evolution.
    Designing and programming with MS ACCESS a new decision support system. Implementation into the EURODIF information system (network installation, training, help support, guides)
    Active in project implementation activities (Planning, rollout)
    Responsible for all aspects of the project (planning, budget, resource, risk, technical) during all phases of the software lifecycle
    Direct interface to all departments (accounting, maintenance, financial controlling, Purchase, depots, Manufacturing, Human resources) to analyze and define the need, to gather all information
    Analysis, design, test, installation, delivery and maintenance of the based decision software
    Onsite training of end-users and delivering helpdesk support and user guide.
    * Situation at the beginning: No BI, common costs analysis done with standard reporting of SAP R/3 (By cost centers, by account). specifications in 1 sentence ;
    * Constraints: No change in SAP, use of MS Access and VBA, no participation of the IT department except 1 ABAP developer for a light code helping and 1 SAP Cd ROM . Database with 20 Millions of record sets per Production table.
    * Role (more detail):
    * Defining specifications with the Manager ;
    * Audit of the IT system and business (all department: 50 Managers)
    * Analysis and carrying out an analytic method To provide all report
    * Manually testing the method to validate the output ;
    * Creating the IT and software to automate the method calculation ;
    * Designing a new database as data warehouse ;
    * Interfacing the database with SAP/R3 to feed the database with all mandatory data and table
    * Designing the software to use the data warehouse and output the 17 reports, using a Helix development cycle. Similar SAP report has been created to validate data of the application.
    * To manage big data (for MS access), creation of a compression algorithm based on an ascii data conversion and hashes.
    * Software validation with Cost controlling and accountant department
    * Writing all documentation, user and technical, creation of a CD Rom for installation on server.

    Environment: Windows NT, ORACLE, Documentum, ACCESS, EXCEL, SAP: CA, PM, MM, FI/CO, FI/GL. VBA ACCESS and Excel programming and some ABAP programming using Remote function call, MS Project
  • Sk2h - Web project manager

    2002 - 2002 * Creation of the company website. The site had to be easy to update. The goal was to build a new standard solution allowing an easy personalization of the Website and update without IT knowledge. It became a software product for customer.
    * Role:
    * Global Project management managing 2 people ;
    * Web site and database design including: Customer support, Marketing and CRM, Online item management and inventory functionalities.
    * Development done initially in PHP and then migration to ASP
    * Build of a template engine with user form to manage content
  • EURODIF PRODUCTION (AREVA) - : Ingénieur d'étude / adjoint au chef de projet

    2002 - 2003 Projet de développement d'un nouvel outil informatique d'aide à la décision, après l'étude d'une nouvelle démarche analytique permettant d'isoler les coûts de maintenance (45 Million d'Euros) par installation.
    Audit des services: une cinquantaine de personne sur 3 directions.
    Etude du système d'information (informatique/comptabilité sur SAP/ORACLE).
    Validation de la démarche analytique et modélisation informatique.
    Réalisation de l'outil informatique sous ACCESS avec interfaçage SAP (conception, programmation, tests, implémentation, documentation utilisateur et technique, déploiement).
  • Abbaye de Senanque - Web project manager

    2001 - 2002 * Design of their website to promote continuously adult training ;
    * Role:
    * Global project management, managing a team of 3 ;
    * Writing specifications after auditing ;
    * Active in developing ASP Site with CSS and JavaScript on IIS/windows server
  • SK2H INFORMATIQUE - TRAINER

    2000 - 2000 * Training group of 20 persons concerning Windows and Office PRO 97
  • DE SENANQUE - WEB PROJECT MANAGER, ABBAYE

    2000 - 2001 * Design of the Abbey web site according to 2 main axis : Monastic life and events ;
    * Role:
    * Global project management managing 2 people
    * Audit, selection of the provider ;
    * Developing the site in ASP ;
    * Creating an Online shop: Using credit card with secured payment ;
    * Developing a software in VB for an easy items management and inventory
    * Documentation and user guide for both site and software
  • Plusieurs sociétés - Chef de projet WEB, formateur

    2000 - 2002 Etude, conception développement de site WEB (LAMP, ASP et technologie associée)
    pour le conseil régional PACA, SK2K, l'Abbaye de Sénanque: Prise en charge de l'étude à la recette.
    Formateur (windows, OFFICE) chez SK2H.
  • DALLORTO IMMOBILIER - OFFICE MANAGER & CIO

    1999 - 2000 * Built of the IT system from scratch
    * Role:
    * Choice and Purchase of PC, printer, software, accessories
    * Installation and setting of computer including all software:
    * Windows NT, Win 95, SCO Unix, office 97, FNAIM software, etc.
    * Network hardware installation (Hub, cables, network cards, Switch) in the 2 offices of the estate agency
    * Network server installation, setting ;
    * Developing software with VB Studio for specific activity
    * Responsible for accounting, human resources management (planning, rota, holidays, hiring), commercial (decision maker for rental and sales)
    * Management of a group of 10 people.
    Working as a managing agent, organizing and animating meeting with homeowners
    Responsible for the information system: maintenance, evolution, purchase
    Network and database administrator
    Trainer on FNAIM software (rents and sales management)
  • Dallorto Immobilier - Responsable d'agence

    1999 - 2000 Gestion du personnel (10 employés)
    Responsable des locations/ventes
    Responsable comptabilité
    Syndic
    Responsable informatique
  • SOFTAGE - Technicien informatique

    1996 - 1999 Réparation matériel
    Formateur
    Installateur réseaux (physique et logiciel : Novel, NT)
    Développeur (VB)
    Audit/analyse
  • Softage - TECHNICIAN

    1995 - 1999 * PC, printer and screen maintenance
    Software installation, maintenance
    Software development using Visual basic and VBA (Access, Excel)
    Physical network installation and network server administration
    Organizing and animating individual and group training sessions.
  • Different companies - Nurse

    1982 - 1995
  • Hopital, clinique, maison de retraite - Infirmier

    1982 - 1996

Formations

Réseau

Annuaire des membres :