PHP/SQL Developer
Digital Forensics Analyst
English-French Localizer
Community Manager
Community Moderator/Administrator
contact@saphir.one Preferred
San Antonio, TX
@saphir
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).
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).
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 to French localization of news articles and guides about or related to World of Warcraft (Blizzard Entertainment).
Moderation of
the support forums.
Provision of
mid-level support to users.
Participation in the software's French translation.
Administration
and moderation of the Discord server.
French to
English translation of news articles for the Bulbanews wiki project (discontinued).
Bachelor's Degree, Electronics and Computer Science for Industry