IT Ops Engineer

• Jan 2023 - Present

Service Ops Center (SOC) Engineer

• Nov 2021 - Dec 2022

Projects and missions 1- DELIVERY OF MVOLA SERVICE KPISTasks:• Development of KPIs on all Mvola services• Automate KPI deliveries with SQLPlus, Bash and AWK • Ensure the delivery of KPIs2- ENSURE THE OSS/BSS ROLE FOR MONITORING MVOLA WALLETS AND SERVICES Tasks:• Verification of wallets collected and disbursed with the upperlimit to ensure the availability of services. • Verification and monitoring of services and all MVola platforms (UTIBA, Talend, SelfCare, MVola Visa Card, MVola Avance, MVola Epargne, USSD)• Alert Financial services and MVola partners to release or refill wallets• Report to Operations team to verify incidents3- IMPLEMENTATION OF A NEW SOC MONITORING TOOL CENTER BASED ON ELASTICSTACK AND GRAFANATasks:• Development of the data collection tool from the main databases and relevant logs• Data formatting for Monitoring via logstash + elasticsearch and visualization on GrafanaTools and Technologies: SQL, PLSQL, MariaDB - MySQL, Oracle, SQL Server, SQL Plus, Bash, AWK, Talend, SQL Server, Grafana, Teams, Bash Linux, kApptivate, Kurve, Oracle, Elasticsearch, Logstash, Filebeat, Auditbeat, AWK, Linux Shell Show less

Data Engineer (Mediation Engineer)

• Sep 2020 - Oct 2021

Projects1- DEVELOPMENT AND IMPLEMENTATION OF A NEW CAMPAIGN BONUS AND SMS DELIVERY CATCH-UP TOOLTasks :• Development of the LMS LockDown tool and mail attachment extractor tool • Server configuration for the connection between AIR APIs• CRON for launching daily treatments• Treatment alerting system2- UPGRADE OF THE NEW MEDIATION PLATFORMTasks :• Design of a new architecture for the new mediation• Centralize all Mediation system configuration, build new tool for service startup• Deploy new Monitoring tool for all Mediation Process (tracking files in collection and distribution) • Development of the new kernel of the Mediation system• Data and Mediation servers administration3- MONITORING AND SETTING UP NEW VOICEMAIL CDRS FORMAT LOGS Tasks : • Development of data collection tool from new MEVO voicemail servers• Formatting data for monitoring collected CDRs via logstash + elasticsearch and visualization on grafana4- ROAMING NATIONAL BETWEEN ORANGE AND AIRTEL (MEDIATION SIDE)Tasks : • Development of new decoder for reporting CDRs coming from AIRTEL • Development of new data filtering for MSC, SGSN, CCN and OCC CDRs for Roaming Reporting • Sending CDRs of AIRTEL Roamers on ORANGE in the ORANGE-AIRTEL File Gateway • Collection of ORANGE Roamers CDRs on AIRTEL in the File Gateway • Distribution of Roamers’ formatted data flow for Datawarehouse CC Reporting • ROAMING’s real-time monitoring development on Grafana5- INSTALLATION AND DEPLOYMENT THE NEW MEDIATION FOR ORANGE RCA Tasks :• System configurations for the new mediation • Installation and configuration of the all new mediation tools• Setting up the new mediation kernel• Setting up Mail and SMS Alerting Tools and Technologies :Red Hat Linux Enterprise, CentOS, Grafana, Prometheus, Node_exporter, Process-exporter, Elasticsearch, Logstash, Filebeat, Auditbeat, Apache NiFi, Rundeck, AWK, C, Java, Talend, Perl, SFTP , Python, Bash Linux, DAVMail, iSync, RipMIME, Postfix Show less

Mediation/BI-Datawarehouse Developer Engineer

• Aug 2019 - Aug 2020

Projects1- SETTING UP A NEW DATAWAREHOUSE “CUSTOMER CENTRIC” PLATFORM IN MONGODB Tasks :• Installing and setting up the MongoDB database Customer Centric• Development of new data formats for the new DWH / BI platform• Data administration of the new DWH / BI platform• Database administration of the new DWH / BI platform2- DCH MIGRATION (ROAMING PROCESS) Tasks :• Develop and Deploy programs for generating new MBF file format• Monitoring TAP and NRTRDE collected from DCH and distribution to Billing System Tools and Technologies :Red Hat Linux Enterprise, MongoDB, Grafana, Prometheus, Node_exporter, Process-exporter, mongodb-exporter, AWK, Bash Linux, Grafana, Elasticsearch, Logstash, Filebeat, Auditbeat, Apache NiFi Show less

Information System and Research Engineer

• May 2019 - Aug 2019

Projects : • Studies of the establishment of the network park of the STAR NBM Ambatolampy factory • Mail migration and security to Microsoft 365 • Use scenario simulation and implementation of Sophos XG Firewall and Sophos REDS • Microsoft Windows installation and configuration with synchronization in Azure Active Directory / Microsoft 365 Tasks : • Design of the installation of network equipments • Windows Server environment administration and synchronization with Microsoft 365 (Local Active Directory, Exchange, DNS, DHCP, IIS, deployment, File Sharing ...) • Proxmox Hypervisor Server administration • Define hardware and software requirements • Creation of a subscription and domain name link with Microsoft 365 • VPN setup with Sophos XG Firewall and Sophos RED (IPSEC, SSL, L2TP, PPTP) • Routing configuration, DNS, AD integration captive portal with Sophos XG Firewall (STAS) • Project planning development # Tools and Technologies : Windows Server 2012/2016, Debian, Proxmox Virtual Environment, Microsoft 365, Sophos XG Firewall and RED, Microsoft Visio and Project, Autocad Show less

Setting up and migrating a new Datawarehouse /Business Intelligence environment of Orange Madagascar

• Jul 2018 - Jan 2019

Project : SETTING UP AND MIGRATING A NEW DATAWAREHOUSE / BUSINESS INTELIGENCE ENVIRONMENT (TALEND 7.0.1 AND MARIADB COLUMNSTORE) : Occupied post : Systems and networks engineer for setting up the new Datawarehouse/Business Intelligence environment Tasks : • Design of a new architecture for the new Datawarehouse/Business Intelligence environment • VM and OS installation of servers in the new environment • Network setup and flows opening between other internal platforms • Installation and setup of Talend components • Installing and configuring the MariaDB ColumnStore database • Security scan of new servers and services installed / Application of patches • Creation and setting up of shared NFS between JobServers Dev and JobServers Prod Talend • Set up of data backup and restore • Reconfiguration of other platforms for the reorientation of data storage to the new environment NFS System • Migration, validation and production setup of Talend Jobs 5.4.2 to the Talend version 7.0.1 of the new environment • Data migration and integration of TokuDB MySQL database from the old environment to the new BIG DATA data storage system "MariaDB ColumnStore" • Total migration of DWH/BI treatments to the new environment • Development of scripts for service log management and task automation. • Setup of a monitoring tool # Tools and Technologies : Red Hat Entreprise Linux, VMWare ESXi, Fortigate, MobaXterm, Talend Data integration, MariaDB ColumnStore, Coralys Tenable, NFS, SAMBA, Netbackup, MySQL TokuDB, Grafana, Prometheus, Node-Exporter. Contract : Internship Show less