You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Sofiane OualiSO

Sofiane Ouali

Expert Excel: Internal Applications/Dashboards/VBA

€275/day
1 project
Paris, FR
3-7 years

Average response time: 2 hours

Freelancer profile translated to English.
Back to original language

About Sofiane

Passionate about data and with an engineering background, I specialize in developing internal Excel applications for SMEs. My goal is to automate processes, save time, money, and energy, and provide clear data visualization to facilitate strategic decision-making.

Thanks to me, leaders in any sector can finally make informed decisions with the help of good quality data and an outside perspective that I provide. Naturally, I will take into account the specificities of your market and produce the graphs and key performance indicators (KPIs) you need: profit, revenue, VAT and expense considerations, ROI, period comparisons, expense categories.

In addition to financial dashboards, I also develop other types of tools, including rapid invoice generation using only Excel, complex calculations, inventory and human resources (HR) management, and more!

My professional experiences have also allowed me to acquire expertise in Excel, SQL, Power Apps, and Power BI, while developing advanced skills in Python, Make, Airtable, and Zapier (no-code tools). My rigorous and versatile approach has enabled me to quickly adapt to various freelance projects, providing tailor-made solutions for each company.

My mastery of English (Master's in English from SciencesPo Paris and exchange at UCLA) allows me to collaborate easily in international environments.

Finally, my background combines sharp analytical skills with unwavering determination, qualities I have also leveraged in my sports career; I am indeed very good at middle-distance running (15'11 for 5km and 31'52 for 10km).

I am convinced that my expertise and rigor will bring real added value to your company. Looking forward to hearing from you!
  • French

    Native or bilingual

  • English

    Native or bilingual

  • Spanish

    Fluent

Can work on-site
Paris (up to 50km)

Experience

  • Auto-entrepreneur
    Data Analyst Freelance
    ENERGY AND UTILITIES
    September 2022 - Today (3 years and 11 months)
    - Definition and measurement of KPIs
    - Implementation and automation of reports and dashboards for activity monitoring
    - Analysis of the evolution of various indicators
    - Taking initiative for continuous improvement based on analyses performed
    - Measuring the impact of these initiatives on KPIs
    - Web scraping (Beautiful Soup / Selenium)

    Preferred sectors: Energy / Construction / Industry
    Python (programming language) Selenium BeautifulSoup Power BI Excel
  • Capgemini Nord
    Data Engineer
    CONSULTING AND AUDITS
    February 2023 - May 2023 (3 months)
    - Research and Development project
    - Cloud training (GCP), Python, SQL...
    - Use of Docker, Git

    Capgemini is a global leader in consulting, digital transformation, technology services, and engineering.
    Docker Git Google Cloud Platform (GCP) Python (programming language) SQL
  • Auto-entrepreneur
    Tertiary Decree Support
    ENERGY AND UTILITIES
    September 2022 - Today (3 years and 11 months)
    - Calculation of taxable areas
    - Calculation of the reference year and targets in absolute and relative terms
    - Report writing
    - Data entry on Operat (Ademe platform)

    The tertiary decree is new legislation that will require owners of tertiary buildings over 1000m² to achieve energy consumption reductions in the coming decades.
    In a few months, I worked on over 50 buildings with various uses (offices, hotels, shops, schools...).

Reviews

5.0

Out of 1 rating

No review details to display

Sofiane has chosen to keep their written reviews private.

Recommendations

Be the first to recommend Sofiane

Help this freelancer shine by sharing your experience working together.

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

  • Master of Urban Planning
    University of California, Los Angeles (UCLA)
    2024
    Échange universitaire d'un trimestre au sein des départements d'ingénierie et d'affaires publiques. Cours : - C&EE C181 - Traffic Engineering Systems: Operations and Control - URBN PL 260A - Environmental Assessment: Urban Design - C&EE 298 - Seminar: Engineering: Transportation Equity Analysis
  • Master Governing the Large Metropolis
    Sciences Po Paris
    Governing the Large Metropolis (GLM) est un master pluridisciplinaire (politiques publiques, sociologie, économie, outils méthodologiques, études régionales et sectorielles) qui forme à la gouvernance des grandes villes mondiales. Cours : - Urban History, Digital Politics - Urban Governance, Urban Planning, Housing and Land - Qualitative Methods, Introduction to GIS

Skill set

Categories