Freelancer profile translated to English.

Description

Welcome to my Malt profile 👋

I support the development of data-oriented solutions by helping to make data accessible and relevant through visualization, automation, and the implementation of solid and scalable governance. My goal: to transform data into levers for growth and efficiency.

📈 Data Analytics

Advanced data processing (Python, SQL, Excel) to provide relevant insights.

Design of interactive and dynamic reports (Power BI, Looker Studio).

Strategic recommendations based on advanced analysis and statistical forecasting.

Real-time detection and monitoring, with advanced DAX modeling.

Time series analysis for forecasting (AR, MA, SARIMA, Pandas, Numpy).

Automation of reports and KPIs

📒 Data Engineering

Data integration from various sources (Web, API, IoT).

Creation and optimization of high-performance pipelines (Airflow, Azure Data Factory, Azure function).

Development and optimization of data processing - Python/SQL - Data processing

Implementation of quality controls and rigorous documentation.

Project management and deployment with Git and GitLab CI/CD to ensure workflow efficiency.

Making data available to Data teams

💻 Automation

Eliminate repetitive tasks with advanced automation solutions (Power App, Power Automate, Webflow, Make, Airtable).

🚀🚀🚀

Languages

French
Native or bilingual
English
Fluent
Portuguese
Conversational
Spanish
Conversational

Workplace preferences

Remote only

Primarily works remotely

HYPR Eneregy
Senior Data Analyst
December 2021 - January 2024 (2 years and 1 month)
Dubaï, United Arab Emirates
In collaboration with the HYPR Energy teams, I led data analysis and performance monitoring initiatives for our on-demand clean energy service. This project deployed hybrid microgrids, including HYPR Pod and HYPR Charge units, which powered mobile HYPR Cell units, 425 kWh batteries charged by solar energy, intended for construction sites in dense urban areas and extreme weather conditions.

Key Contributions:

- Close collaboration with Operations and Engineering teams to ensure data accessibility and accuracy, and definition of key performance indicators
- Development of real-time performance monitoring dashboards for integrated IoT devices

- Design and implementation of a PostgreSQL Django database and an ETL pipeline on Microsoft Azure, using Data Factory for secure and scalable data processing
- Design and deployment of an energy forecast time series model, optimizing the replacement of transportable energy storage units, which significantly improved operational efficiency
- Creation of interactive dashboards in Power BI to visualize various indicators, facilitating data-driven decisions and operational improvements.
Power BI Services Power BI DAX Power Query Django ARIMA Time Series Forecasting PostgreSQL Agile project management Azure Data Factory
Siraj Power
Data Analyst | Data Engineer
February 2020 - December 2021 (1 year and 10 months)
As a rapidly growing solar company, Siraj Power expanded its grid-connected solar systems, leading to an increase in operational data requiring efficient processing, storage, and dissemination. My main responsibilities:

- Design and optimization of ETL/ELT pipelines to transfer diverse data from SCADA connected devices to Azure cloud platforms
- Development of data cleaning and validation processes, ensuring accuracy and consistency
- Cleaning, reorganizing, and securing SQL databases
- Monitoring, securing, and optimizing the performance of Azure resources

In collaboration with the Operations team, I transformed raw data into actionable insights through the development of dashboards and KPI reports, making data easily accessible.

- Establishment and documentation of key indicators
- Development of automated programs in Python
- Creation of real-time and historical dashboards and visualizations in Power BI
- Implementation of a demand forecasting model to anticipate energy consumption.
Python Programming Microsoft Power BI Power Automate Extract, Transform, Load (ETL) Azure Cloud Azure SQL Database SCADA
Siraj Power
Data Analyst
December 2019 - May 2020 (5 months)
Siraj Power provides solar energy solutions, and I collaborated with the Maintenance team to implement a data-driven alarm management strategy. The goal was to configure alarms by severity level and push notifications so technicians could quickly address on-site issues.

Main Responsibilities:

- Identification of priority levels and alarm types
- Development of automated pipelines to meet alarm needs
- Design of dashboards for real-time monitoring and historical analysis
- Creation of documentation and guides to ensure smooth operation

Technologies used: Python, SQL database, Azure Data Factory, Power BI, Twilio.