Freelancer profile translated to English.

Description

VBA developer with 5 years of experience, I have developed office automation tools for IT equipment companies allowing:

Automated management of quotation submissions to wholesalers, resellers, and end customers (VBA - EXCEL - OUTLOOK - HTML - CSS)

Creation and management of product quotations (VBA - EXCEL - ACCESS)

Managing the calculation and sending of reseller and wholesaler Paybacks (VBA - EXCEL)

Analysis, creation, and formatting of reports whose data comes from SAP, an SQL database, or the internet (VBA - EXCEL - ACCESS)

Gathering data on the internet for competitive intelligence (PYTHON - EXCEL)

Creation of a 100% personalized CRM system that meets business needs (VBA - ACCESS)

This skill is accompanied by my 6 years of experience as a business analyst/Pricer.

This skill translates into my ability to set up dashboards with relevant indicators, and to establish a coherent and effective pricing strategy.

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Société Générale
Senior VBA and C# .net developer
BANKING AND INSURANCE
September 2019 - Today (6 years and 9 months)
Courbevoie, France
Design, deployment, production of tactical tools according to client technical specifications:
Training clients on the use of tactical tools.
Taking over old code requiring updating or debugging.
Responsible for the following projects
1- Country risk analysis tool VBA, ACCESS, SQL
2- Budget analysis tool VBA, EXCEL, SQL, SHAREPOINT
3- Porting of VBA ACCESS SQL risk analysis tool to C# WPF ASP.CORE WEB API 3.1
VBA C# Microsoft Access EXCEL Microsoft Excel SQL Windows Presentation Foundation
Sharp Business Systems France
PRICER MANAGER
DIGITAL AND IT
May 2017 - July 2019 (2 years and 3 months)
Villepinte, France
Creation of quotation tools and KPI management Excel + VBA.
Creation of sales forecasts by machine and segment with sales directors.
Competitive intelligence to establish a continuous benchmark of our prices.
Creation of quotation tools and KPI management Excel + VBA.
Creation of sales forecasts by machine and segment with sales directors.
VBA Microsoft Excel Python Microsoft Office Response to tender pricing Microsoft Access Marketing
Bother France
KEY ACCOUNT PRICING PROJECT MANAGER
RETAIL (LARGE RETAILERS)
April 2015 - May 2017 (2 years and 1 month)
Roissy-en-France, France
Preparation and monitoring of responses to Key Account tenders.
Competitive intelligence dedicated to Key Account Pricing on the French & export market.
Privileged contact within the framework of the Group's internal financial control (Europe and Japan).
Monitoring of sales and results of Key Account business and calculation of economic balance sheets, then analysis and recommendations.
Development of IT tools under Excel VBA and various Python to automate, share information as quickly and efficiently as possible.
Microsoft Excel Microsoft Access VBA Pricing strategy Data analysis Business analysis Marketing study

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Master 2 : Économie, finance internationale et régulation Compétences acquises
Université Paris Nord, Sorbonne Paris Cité
2014
 Analyse modélisation, mesure et gestion du risque de crédit  Informatique financière : programmation VBA sous EXCEL  Économétrie des données de panel  Économétrie des séries temporelles  Économétrie financière : modèles GARCH et application à la Value-at-Risk

Data Analyst

Olivier Mandote

C#/VBA .Net .Net core Developer

About Olivier

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories