Freelancer profile translated to English.

Description

Expert in project and VBA Excel application development, data analysis and processing.

Expert with over 10 years of professional experience, I offer you effective solutions adapted to your needs at reduced prices.

DATABASE

data scraping
data extraction
data exploration
Microsoft Access
SQL database
MySQL
Postgress
Power BI

Excel and VBA MACRO

VBA Macro
Excel VBA/Excel Macro Debugging
Custom Excel Template
Excel Formula
Excel Data Analysis
Excel Pivot Tables and Charts
Charts and diagrams: bars, lines, scatter plots, pies, combination charts, etc.
website scraping
Data Entry
Excel Data Cleaning
Excel Spreadsheet
Excel Data Analysis
Excel Dashboard
data visualization
web search

EXCEL TRAINER

Beginner Level
Intermediate Level
Advanced Level

I also offer other services in Excel and Data Analysis, a reduced rate will be set after the presentation of your project.

Do not hesitate to contact me as I will build your project from A to Z with performance and respect for deadlines.

Industry field of expertise

Languages

French
Fluent
English
Fluent
Arabic
Fluent
Spanish
Conversational

Workplace preferences

Remote only

Primarily works remotely

AIRLINES
2020-2024
AVIATION AND AEROSPACE
January 2020 - Today (6 years and 5 months)
Commercial Analyst at MAI
Revenue Management, Booking Control, Pricing
Mission Challenges / Objectives
MAURITANIA-AIRLINES: APRIL 2022 to Present
 Development of quantitative reporting and analyses for the General Management/Commercial Department and sales departments
Ex: CR, PKT, SKO, RPKT, RSKO, sales report.
 Ad hoc reporting
 RM Analyst; (responsible for x routes to be defined)
 Flight creation during the program implementation.
 Flight management with monitoring and proposals regarding:
 Determination of the overbooking rate
 Quota management, (reopening/closing of classes) and parameter adjustment according to demand
 Creation of the seasonality calendar
 Participation in ad hoc projects such as the RMS project implementation at CT with scenario testing for BPT (Business Process Testing)
 Provide help and support in terms of methods, tools, and organization to the Sales / Marketing department (particularly the call center) and Pricing.
Technical environment: Amadeus (Reservation, Inventory, RMS, CM), VBA, EXCEL, SQL, BI
Amadeus Reservation & Inventory System Amadeus RMS Excel VBA Macro Microsoft Excel SQL PostgreSQL PHP/MySQL Data Analysis
Société Générale
database administrator, banking software and project management
BANKING AND INSURANCE
June 2017 - January 2020 (2 years and 7 months)
Assistance in debugging VBA, EXCEL, SQL, ACCESS, Word
Assistance with your VBA, EXCEL, SQL, ACCESS, Word projects
Implementation of VBA, EXCEL, SQL, Word applications
Tutoring VBA, EXCEL, SQL, ACCESS, Word
VBA EXCEL SQL Microsoft Word POWER PIVOT POWER QUERY POWER BI ACCESS