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

Amar C.

BI Consultant | Data Analyst | Power BI | ETL

€550/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Amar

With over 7 years of experience in the banking, audiovisual, telecommunications, and luxury sectors. Benefiting from expertise in data loading and integration, data visualization solution development, and databases.
  • French

    Native or bilingual

  • English

    Conversational

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

Experience

  • Groupe Les Echos - Le Parisien
    Data Analyst
    PRESS AND MEDIA
    November 2024 - Today (1 year and 7 months)
    • • Collaboration with business teams from various brands to understand their needs and adapt analyses accordingly.
    • • Leading regular follow-up meetings with stakeholders to present analyses and recommendations.
    • • Writing functional and technical specifications to improve performance monitoring and structure CRM data and internal subscription tools.
    • • Analysis of newsletter performance: implementing NL monitoring KPIs (number of NL sent, open rate, unsubscribes, clicks, conversions…).
    • • Monitoring customer subscriptions for the group's various brands by leveraging data from internal subscription tools and creating interactive dashboards on QlikSense Cloud to track customer acquisition, renewals, and customer schedules….
    • • Ensuring the reliability and standardization of CRM indicators to ensure consistency across the group's brands.
    • • Using SQL to extract, analyze, and structure data from internal subscription monitoring tools.
    SQL Qlik Microsoft Power BI Google Cloud Platform (GCP) DBT
  • L'Oréal
    Data Analyst
    LUXURY GOODS
    September 2023 - October 2024 (1 year and 1 month)
    Saint-Ouen, France
    • • Interrogating business units during the needs assessment phase: Meeting with stakeholders to understand and define functional requirements and detail user stories.
    • • Developing scripts in BigQuery (GCP): Designing scripts for data processing and analysis, optimizing performance within the GCP environment.
    • • Evolving the data model: Continuously improving the model to meet team needs, ensuring data integrity and efficient queries.
    • • Data model compliance: Adjusting the model to ensure compliance with standards and integration with existing systems.
    • • Automatic data exports: Implementing automated processes to export data to other environments, ensuring smooth synchronization.
    • • Semantic modeling for DirectQuery in Power BI: Participating in model design and performance testing of connections to data sources.
    • • Implementing KPIs in Power BI: Developing KPIs based on analysis axes (brand, product, dates, labs, countries...) to provide key insights.
    • • Technical documentation in Confluence: Writing technical documentation to describe processes, architectures, and configurations.
    Microsoft Power BI Google Cloud Platform (GCP) Git Power Query SQL
  • BOUYGUES TELECOM
    Data Analyst
    TELECOMMUNICATIONS
    June 2022 - September 2023 (1 year and 3 months)
    Meudon, France
    Within the Wholesale Fixed team at Bouygues Telecom, I am a technical-functional Data Analyst, responsible for supporting the business units in charge of monitoring the wholesale of B2B fiber equipment. My role consists of analyzing data related to the sale of ADSL, FTTH, FTTO, and FTTE solutions, in order to provide insights and optimize sales management and equipment monitoring processes for professional clients.
    • • Analysis of functional needs of business teams to adapt reporting solutions.
    • • Writing technical specifications.
    • • Participation in the choice of Dataviz tool with internal teams.
    • • Implementation of daily, weekly, and monthly KPIs from internal data (order portal and deployment tools).
    • • Implementation of deployment monitoring (Backlog) and order production monitoring.
    • • Development of a quote monitoring process for clients and installers.
    • • Implementation of SAP BO reports and automatic exports to Excel.
    • • Development of reports in Power BI and Tableau for performance and KPI monitoring.
    • • Training users on the use of data visualization tools.
    Microsoft Power BI SAP BO Tableau SQL Snowflake

Recommendations

Be the first to recommend Amar

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's Degree in Computer Science
    University of Le Havre
    2018

Skill set

Categories