Database Administrator & Data Analyst

Role and background

As a versatile data specialist, I lead complex data analysis and database administration (Oracle, PostgreSQL, SQL Server), transforming insights into strategic drivers. With expertise in Python, Power BI, and Looker Studio, I optimize the performance and security of information systems. I am immediately ready to contribute tangible value to your European projects, in both French- and English-speaking environments.

Professional Experience

Technical Assistant, Data Analyst

Since August 2023 • Digital Governance Unit (UGD) and National Social Security Fund (CNaPS) • Madagascar

Work in the public sector, primarily in the fields of education, social protection, and IT security.

Performed complex data processing and cleaning using Python (Jupyter Lab), as well as designing and populating data warehouses using Oracle PL/SQL and PostgreSQL.

Development of dynamic reports and interactive dashboards using Looker Studio and Power BI, in connection with the Education, Individuals, and Identity projects.

Implementation of automated ETL processes in accordance with best practices for data governance and quality.

Responsible for data integration, processing, and reporting, from designing ETL flows to developing visualization tools.

Occasional collaboration with international partners in a multilingual environment, particularly during meetings conducted in English.

These efforts reduced data duplicates and errors by more than 80% and cut report production times in half through automation.

Database Administrator

September 2020–July 2023 • BASAN Group • Madagascar

Worked in the field of information systems and ERP management, with a focus on administering databases related to Sage 100, X3 v6, and X3 v12 solutions.

Comprehensive management of critical aspects: security, backups, restores, maintenance plans, migrations, and performance optimization.

Conducted database audits and performed advanced T-SQL development (scripts, stored procedures, views, functions).

Configured advanced features such as WSFC, SQL Server Always On, Proxy, and PostgreSQL ETCD.

Responsible for database administration across the entire group, ensuring the availability, security, and continuous performance of the systems.

Participated in a comprehensive project to optimize the database infrastructure.

Collaborated with international teams on certified training programs and incident management through the SRA (Support and Response to Anomalies) system.

These efforts led to a significant reduction in downtime and a marked improvement in the overall performance of the systems.

District IT Center Manager

June 2016–September 2020 • Independent National Electoral Commission (CENI) • Madagascar

Worked in the field of information systems management applied to electoral administration.

Administered the electoral database via the SIGLE (Computerized Electoral Roll Management System), handling all computerized processes related to electoral roll management.

Participation in a strategic project to migrate the database from SQL Server to Oracle, aimed at enhancing the system’s reliability and performance.

Responsible for the comprehensive management, security, and optimization of electoral data.

Regular maintenance of the databases to ensure their integrity and availability.

Collaborated with the UNDP team during training sessions.

This assignment ensured rigorous and effective management of electoral data, contributing to the reliability of the electoral process.

ICT Manager

April 2016–September 2020 • MINSAN - University Hospital • Madagascar

Worked in the healthcare sector at a University Hospital, with the primary responsibility of administering IT infrastructure and managing hospital information systems.

Administered medical and organizational data, with a constant focus on security and availability.

Oversaw the development of a hospital ERP system to optimize internal processes.

Responsible for supervising IT infrastructure, ensuring the reliability of hospital data, and training staff in the use of ICT (Information and Communication Technologies).

These efforts led to the implementation of a high-performance hospital information system, promoting better management and coordination of services.

GIS Trainer (Consultant)

October 2018–December 2018 • FIANTSO Madagascar

Worked in the field of geomatics and geographic information systems (GIS) as part of the design and implementation of a comprehensive GIS.

Conducted theoretical and practical training on geographic data, map calibration, reference systems, and spatial networks.

Supervised the field collection and processing of geographic data, as well as the creation and editing of maps using QGIS.

Responsible for GIS management, facilitating training sessions, and map production.

This project resulted in the establishment of a structured system and the production of high-quality printed maps, facilitating territorial analysis and decision-making.

IT Data Manager

July 2015–November 2016 • ICCO Coopération Madagascar

Design and implementation of an information system for managing data from several partners in Madagascar (Bionex, Fiantso, Sangany Café, Heri Madagascar, CMPP, etc.), using the Akvo Flow and KoBo Toolbox platforms.

Conducted training sessions on using Akvo Flow, collected and processed survey data, and mapped geolocated data using Carto DB and QGIS.

Responsible for managing and maintaining the information system, providing user support, analyzing collected data, and producing cartographic representations.

This project led to the implementation of an integrated system that facilitates the visualization of field data and supports informed decision-making.

Head of the Documentation and Database Management Division

January 2012–December 2013 • Ministry of Relations with Institutions (MRI) • Madagascar

Worked in the field of database management and administrative documentation for a ministry.

Administration of the MySQL database and structured organization of institutional documentation.

Implementation and optimization of data and document management systems to enhance administrative efficiency.

Responsible for the availability, security, and proper organization of official data and documents.

This assignment significantly improved access to information, thereby facilitating decision-making and the management of administrative processes.

Head of the District IT Center

March 2011–August 2011 • Independent National Electoral Commission (CENI) • Madagascar

Worked in the field of election management and information systems, with responsibility for administering the SQL Server database and maintaining the SIGEM application (Computerized Election Management System in Madagascar).

Computerized management of voter roll processing, ensuring the reliability and continuity of operations.

Responsible for ensuring the integrity, security, and availability of election data, as well as the efficiency of automated processing.

This project optimized and secured the election management system, contributing to a significant improvement in the conduct of election operations.

Skills

Hard Skills: Database administration, high-availability database solutions, business intelligence, Windows Server and Unix environments, T-SQL, SQL languages

Strengths: Data Expert, Complex Data Analysis, Information Systems Security, Leveraging Data as a Strategic Asset, Strategy Optimization and Decision Support

Degrees and Training

Advanced Degree in Information and Communication Technology Administration

January 2021 to January 2022 • ENAM

Master’s Degree in Geomatics and Decision-Support Information Systems

January 2014–January 2015 • EMIT

Bachelor’s Degree in Computer Systems and Networks

January 2007–January 2009 • CUFP

At a glance

Field of expertise

IT & AI

Experience

14 years of experience

Working languages

French · C1English · B2

Tools and software in use

Postgres — 3 yearsOracle Database — 2 yearsSQL Server — 10 yearsPostGreSQL — 4 yearsPython / JupyterLab — 2 yearsSSIS — 2 yearsPower BI — 3 yearsLooker Studio — 3 yearsWindows Server — 5 yearsUnix — 5 years

Markets covered

France