You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Jean-Laurent RoyerJR

Jean-Laurent Royer

Expert VBA/Ms Access/Ms Excel

€450/day
Saint-Philippe, RE
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Jean-Laurent

In the field of IT/Telecom/Banking/Multimedia/Internet/Research and development, I am looking for a mission with the management of projects in their entirety: analysis, development, testing and training and/or the creation of specific applications linked to an information system. Adaptable to any type of structure, I will support your teams to optimize the quality of their work and increase your productivity.
  • French

    Native or bilingual

  • English

    Conversational

Remote only
Primarily works remotely

Experience

  • L'Hôtellerie Restauration
    Expert VBA/Ms Access/Ms Excel
    PRESS AND MEDIA
    October 2023 - December 2023 (3 months)
    Paris, France
    My main missions were as follows:

    • Actively participate in the evolution of Access software solutions to interface them with a service-oriented platform via API.
    • Participate in the development of these services under .Net and their integration into the various Access programs.
    • Ensure interoperability between the two technologies.
    • Participate in the management, maintenance, and evolution of existing Access software solutions.
    • Manage existing databases, improve them as needed, and converge them towards the service platform model.

    Environment: Office 365, MS Access, Team Viewer, SQL Server, MSSMS, .NET C#, Git, Visual Studio
    VBA C# Microsoft Access Microsoft Office SQL Server
  • Bpifrance
    Expert VBA/Ms Access/Ms Excel
    BANKING AND INSURANCE
    May 2023 - June 2023 (1 month)
    Maisons-Alfort, France
    (IDL OMNIUM/NORMASYS)
    In the BPI France Export department, creation of an Access tool for calculating stabilization rates for various Banks based on a Macro model composed of two Excel files:

    - Implementation of backup and regeneration functions for Excel files.
    - Creation of Access tables for backing up Excel data.
    - Creation of forms with filters for automatic launching of Excel Macros.

    Environment: Microsoft Office 365, Microsoft Access 365, Microsoft Excel, Windows 11, Notepad++, Remote work
    Access VBA Excel VBA Microsoft Office Microsoft Excel Microsoft Access
  • EDF
    ENR Expert VBA/Ms Access/Ms Excel
    ENERGY AND UTILITIES
    December 2022 - January 2023 (2 months)
    Seine-Saint-Denis, France
    (IDL OMNIUM/INETUM)
    Due to the malfunction of 3 Excel macros (Office 365 compatibility issue) for managing technician schedules:

    • I retro-documented the 3 Macros so that the client could ensure corrective and potentially evolutive maintenance.
    • I corrected VBA errors and evolved the Macros by taking user requests into account and deployed the Macros.

    Environment: Windows 10, Office 365, Remote work, Teams.
    VBA Microsoft Excel Microsoft Office

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • COMPUTER SYSTEM AND NETWORK TECHNICIAN
    ORION
    2001
    Niveau : Contrat de Qualification SYSTEMES -DOS -UNIX -WINDOWS95 LANGAGES -C sous DOS, C sous UNIX -VISUAL BASIC -H.T.M.L., JAVA ++ RESEAUX -WORKSGROUPS -WINDOWS95 -NOVELL 3.12 / 4.10 -WINDOWS NT -UNIX, TCP / 1P -INTERNET BASE DE DONNEES -ACCESS -ORACLE -LANGAGE DE REQUÊTE SQL
  • DIPLOma of UNIVERSITY TECHNOLOGY in GEII, Electronics and Computer Science
    IUT DE VILLETANEUSE
    1996
    Niveau : 2 éme Année

Skill set

Categories