ZARO ILORSAINT

Data Analyst

Contact

(819) 5710510
ilorsaintzaro@gmail.com
Sherbrooke, Qc, Canada

Education

2025 - to date

Web Development (AEC)

Cégep Saint-Felicien, Canada

2021 - 2023

Advanced Master in Statistical Data Analysis

Gent University, Belgium

2021 - 2023

International Mastet in Rural Development

Gent University, Belgium

2009 - 2014

Licence en Agro-Économie

Université d'État d'Haïti

Languages Skills

English
Intermeddiate level(75%)
French
Avanced level (90%)
Creole
Native language

Hobbies

Musics
Football
Reading
Travel
Coding

Profile

results-driven data scientist, reliable and highly committed, with strong expertise in database design and management, data analysis, and statistical modeling. extensive experience in collecting, cleaning, transforming, and analyzing large-scale datasets to produce actionable insights for decision-making. specialized in SQL query optimization, statistical forecasting, and machine learning, with a strong command of both frequentist and bayesian approaches. holds a master’s degree in data analysis..

Skills

Data Analysis and Visualization

R, SAS, PYTHON, SPSS, EXCEL

Relational Database

SQL, PostgreSQL, SQL Server, Excel avancé, Access Python, Jupyter Notebook

Non-Relational and Graph Databases

Cypher, bases de données orientées graphes, Neo4j

Geospatial Data Analysis

QGIS, ArcGIS Pro, OpenLayers

Statistics and modeling

Descriptive, inferential statistic, predictive modeling, Marchin Learning

Collaboration and Professional Tools

Git, GitHub, outils Microsoft (Teams, Outlook)

Développement web

HTML, CSS, JavaScript, jQuery, Node.js, Express, EJS, Django, VScode

Portfolio

2025–2026

Database project

  • Designed a complete relational database to centralize and manage registrations
  • Performed conceptual and relational data modeling, with normalization up to Fifth Normal Form (5NF)
  • Created, modified, and optimized the database structure
  • Developed complex SQL queries for data extraction and analysis
  • Utilisation de SQL Server / SSMS

Tools used: Looping, SQL Server, SQL Server Management Studio (SSMS) 2022

2024-2025

Transactional Financial Management Web Application

  • Budget and Expense Tracking Platform (Monthly & Annual).
  • Developed a platform to track, analyze, and manage monthly and annual budgets and expenses.
  • Performed financial data analysis, including data extraction, transformation, and visualization to produce decision-support reports.
  • Implemented transactional logic, analytical queries, and automated reporting systems.

Tools used: HTML, CSS, JavaScript, Python, Django, PostgreSQL, SQlite3, VS code

2024-2025

Lettuce Field mapping and analysis Platform - Montérégie (Interactive Dashboard)

  • Collected, processed, and analyzed spatio-temporal data
  • Extracted and cross-validated multi-source climate data (ERA5-Land, NASA POWER, and Agri-Environmental Canada)
  • Managed and processed GeoJSON, shapefiles, and data from WMS/WFS services
  • Developed asynchronous queries to extract and aggregate data in real time
  • Built an interactive dashboard with automated reports and graphical statistics
  • Implemented advanced data visualization using OpenLayers and Highcharts

Tools used: HTML, CSS, JavaScript, jQuery, Bootstrap, OpenLayers, PostgreSQL, VS code, Power BI

Experiences Professionnelles

2017 - 2019

FONDATION CARIS, Haïti

Mutual Solidarity officer

  • Collection, structuring, and updating of beneficiaries’ socio-health data (treatment follow-up, home visits, program adherence). (suivi des traitements, visites à domicile, adhésion aux programmes)
  • Analysis of financial and operational data to identify trends, risks, and group performance.
  • Preparation of periodic reports (participation indicators, treatment adherence, activities carried out).
  • Monitoring and evaluation of mutual solidarity groups using quantitative indicators (savings, loans, training participation)

Tools used: Looping, SQL Server, SQL, Sever management studio, SSMA Excel avancé

April 2016 – December 2018

COMPLEXE KM, HAÏTI

Senior Data Analyst

  • Migration of database from Microsoft Access to SQL Server
  • Design of a relational database using Looping
  • Structuring tables (clients, loans, payments, guarantees, groups) and defining relationships to ensure data integrity
  • Collection, entry, and updating of financial and client data in the database via SQL Server
  • Improvement of data quality, accessibility, and loan repayment tracking
  • Reducing the report time by around 25%

Tools used: SQL, PostgreSQL, Access, Excel

2015 - 2016

FOUNDATION INTERNATIONAL COMMUNITY ASSISTANT, Haïti

Credit risk analyst

  • Collection, structuring, and analysis of financial and socio-economic data of farmers.
  • Evaluation of loan applications using quantitative indicators (income, repayment capacity, risk assessment).
  • Management and updating of a client database and loan portfolio.
  • Developed predictive models to improve the company’s decision-making

Tools used: Excel, PostgreSQL, Microsoft office

Certifications & Formations

Mai 2025

Udemy

Python Django- The Practical Guide, Udemy

Janvier 2025

CEF, Canada

ArcGIS Pro

Novembre 2024

Udemy

Web Development Masterclass - Beginner to Pro in under 20hrs

Octobre 2022

SAS

SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling

Octobre 2022

SAS

SAS Certified Specialist: Base Programming Using SAS 9.4