Avatar

Saphir

PHP/SQL Developer

Digital Forensics Analyst

English-French Localizer

Community Manager

Community Moderator/Administrator


contact@saphir.one Preferred Contact Method

(210) 294-5757

San Antonio, TX


Saphir#0001

@jdsaphir

jdsaphir

Work Experience

Associate Community Manager @ ZAM
July 2022 - January 2023
April 2023 - Current

Community management and localization for Tower of Fantasy (Hotta Studio) and its content creator program.
Community management and localization for PUBG Mobile (LightSpeed & Quantum Studio).

PHP/SQL Project Lead and Developer, Digital Forensics @ French National Police
January 2019 - November 2022

Project management, design, development and programming of utility and operational applications.
Development using Symfony 3 and up.
More about this position... Less about this position...

History
On a common accord with the laboratory's director, I switched to this role from my previous one at the beginning of 2019 as it was planned for my former division to be transferred away from the laboratory later that year, and the development team could use an additional resource.
I left this position in mid-November 2022 in order to immigrate into the United States.

Workplace
The workplace is one of the country's six forensics police laboratories, performing all types of forensics analyses (biologic/DNA, drugs, ballistics, digital, etc.). About 150 people work there, amongst which four technicians are developers in charge of the lab's software maintenance, overseen by two engineers, who are also in charge of the lab's network and IT matters.

Projects
During my time at this position, I have developed and successfully deployed multiple PHP applications (based on the Symfony framework) that are now used on a daily basis by everyone at the laboratory.
A small-size application with a REST API used by other applications to manage users and their access roles.
A medium-size application used to manage non-laboratory personnel coming in and out of the laboratory (police officers, magistrates, cleaning and maintenance company personnel, etc.), with entry/exit timestamping, badge generation, NDA signature, DNA profile tracking. The application also tracks DNA profiles for laboratory personnel and stores some information about them for HR purposes. A REST API exposes the DNA profile IDs when their conservation date has expired.
A large-size application used to track all incoming and outgoing communications (calls, physical and e- mail, meetings), with the ability to send emails directly from within the application for auto-tracking of replies in the future, automatic sending or printing of the laboratory's analysis reports, a complete and intuitive search feature, and the ability to display tracked communications per interlocutor or per case. The application is connected to the laboratory's inventory management system (LIMS)'s database to manage the reports' sending statuses and to display case information.
I have also made minor contributions to other projects, and assisted with IT matters when manpower was needed.

Software
PHP 7.2 and up for most of the code writing.
MySQL/MariaDB for Symfony applications.
Oracle SQL for the lab's LIMS.
HTML, CSS, JavaScript for the applications' views.
IDE: PhpStorm (for all the languages above).
Client: Firefox on Windows 7/10.
Server: Windows Server 2008 and up, Debian 7 and up (or forks thereof).

Analysis Operations Manager, Digital Forensics @ French National Police
December 2013 - December 2018

Recovery and analysis of deleted files.
Quality enhancement of pictures and videos, mostly CCTV footage.
Design, development and programming of utility applications.
More about this position... Less about this position...

History
After passing the competitive examination to become a digital forensics technician, I chose to join the digital forensics division of a forensics police laboratory.
On a common accord with the laboratory's director, I switched from this role to my next one at the beginning of 2019 as it was planned for my former division to be transferred away from the laboratory later that year, and the development team could use an additional resource.

Workplace
The workplace is one of the country's six forensics police laboratories, performing all types of forensics analyses (biologic/DNA, drugs, ballistics, digital, etc.). About 150 people work there, amongst which, at the time, four technicians and two engineers perform digital forensics operations requested by police officers or magistrates.

Forensics Operations
During my time at this position, I have performed general digital forensics operations, including enhancement of the pictures and videos. I have also assisted with performing special digital forensics operations such as recovery and analysis of deleted files on various digital storage hardware. I assisted extensively with the writing of the analysis reports that would be sent to the requesting police officers or magistrates.

Software (Forensics Operations)
X-Ways Forensics for recovery and analysis of deleted files.
Adobe Photoshop Lightroom for image enhancement.
Other internal or third-party specialty software for digital forensics operations.
UNIX terminal (Debian/Kali Linux) for low-level operations on digital storage hardware.

Development Projects
During my time at this position, I have also designed and developed PHP applications to facilitate forensics operations, QA processes and the division's case management.
An application displaying the current cases in a dashboard, connected to the laboratory's inventory management system (LIMS) to display case status and other information.
An application calculating statistics regarding the division's cases (volume, analysis time, response time, etc.).
An application automatically filling QA documents such as internal analysis sheets, and generating part of the analysis report depending on the operations performed.
An application used to track incoming and outgoing phone calls, limited to the division (at my next position, I developed a laboratory-wide application filling this purpose, with many more features).
I have also developed other minor applications such as a tool calculating all possible license plates given plausible characters on them, or another listing analysis steps depending on the case's status and assisting technician, amongst others.

Software (Development Projects)
PHP 5.4 and up for most of the code writing.
MySQL for PHP applications.
Oracle SQL for the lab's LIMS.
HTML, CSS, JavaScript for the applications' views.
IDE: Notepad++ (for all the languages above).
Client: Firefox on Windows 7/10.
Server: Debian 6 and up (or forks thereof).

English-French Localizer @ ZAM / Wowhead
December 2013 - April 2023

English to French localization of news articles and guides about or related to World of Warcraft (Blizzard Entertainment).

Volunteer Positions

Senior Moderator @ French MyBB Support Forums
August 2011 - Current

Moderation of the support forums.
Provision of mid-level support to users.
Participation in the software's French translation.

Discord Server Head Administrator @ Bulbagarden
November 2014 - August 2020

Administration and moderation of the Discord server.
French to English translation of news articles for the Bulbanews wiki project (discontinued).

Personal Projects

Elaria
March 2019 - Current

Community Discord server.
Centered around a Pokémon game bot.

Education

South Brittany University
2010 - 2013

Bachelor's Degree, Electronics and Computer Science for Industry

Paul Langevin High School
2007 - 2010

Baccalauréat, Scientific/Engineering Sciences Stream