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).
Community management, proofreading, and miscellaneous tasks for Nikke (Shift Up).
Community management for Honor of Kings (TiMi Studio Group).
Social media reporting for Wuthering Waves (Kuro Games).
Community management around Path of Exile 2 (Grinding Gear Games).
Community, social, and event management and miscellaneous tasks for other games such as NBA Infinite (Lightspeed Studio), Tarisland (Level Infinite & Locojoy), Undawn (Lightspeed Studios), etc.
More about this position... Less about this position...
History
I first joined ZAM in July 2022 as a contractor, based in France, to support the Western European launch of Tower of Fantasy. Following my relocation to the United States, my contract concluded in January 2023 when Tower of Fantasy WEU chose not to renew its agreement with the agency. In April 2023, ZAM hired me full-time to support an expanding portfolio of games, starting with PUBG MOBILE and growing to encompass a wide range of titles across community management, social media, sentiment analytics, and localization.
Tower of Fantasy – Western Europe
During the contract period, I assisted with the day-to-day management of the game's Discord server and other social media platforms for the Western European market. My responsibilities included community engagement, content moderation, management of the content creator program, and localization and proofreading work, primarily but not exclusively in French. I also performed limited localization work for PUBG MOBILE WEU during this period.
PUBG MOBILE
I began supporting PUBG MOBILE in April 2023, initially focusing on the Global and North American channels through social media engagement, responding to player posts and comments to maintain an active and positive community presence. Over time, my role expanded to include the production of regular sentiment reports tracking community mood and feedback trends, using SproutSocial for social media monitoring and analytics.
Following staff changes within the company, I took on broader ownership of the PUBG MOBILE North America community, becoming responsible for the management of its Discord server and the oversight of its moderation team. I also oversaw three distinct programs within the server:
World Builders: a program dedicated to players who enjoy creating custom in-game maps.
Spanish-speaking community: a dedicated space for the game's Spanish-language player base.
Core Feedback Group: a curated group of approximately 50 selected players providing structured feedback on upcoming features ahead of their release.
PUBG MOBILE is the world's highest-grossing mobile shooter.
Tower of Fantasy – Global
Tower of Fantasy Global was my first fully owned project. I was put in charge of the game's official Discord server, managing it and overseeing its moderation team. My responsibilities included supporting event management and producing sentiment reports, with a particular focus on community reception around game updates. Both the client and the moderation team responded positively to my work throughout the project, and our cooperation only ended when management of the title was transferred from its publisher back to its developer.
Honor of Kings
Honor of Kings became my second fully owned project, where I was entrusted with building the game's official Discord server from the ground up. I grew the server to a healthy community of over 60,000 members, assembled and mentored a moderation team that remained active and engaged well beyond the end of the project, and organized monthly community events that fostered strong player loyalty and satisfaction. My work was well-received by the community, and the development team has since expressed interest in engaging me as a freelancer to resume my responsibilities on the server.
Several of the community events I organized featured custom Discord bots that I designed and developed myself, drawing on my software development background to create interactive experiences for the community.
Honor of Kings is the world's highest-grossing mobile game.
Additional Games
Throughout my time at ZAM, I have also contributed to a number of other titles in various capacities:
Goddess of Victory: NIKKE – Sentiment reporting; Discord event management.
NBA Infinite – Discord bot development; assistance with Discord server management.
Tarisland – Assistance with Discord server management.
Wuthering Waves – Social media and community sentiment reporting and analytics.
Path of Exile 2 (Western Europe) – Sentiment reporting and analytics; Discord server management; assistance with European contractor management (French and German); case studies.
Tides of Annihilation – PR support; sentiment reporting; Discord market research and case studies.
Monster Hunter Outlanders – Beta support; bug report and feedback collection; sentiment reporting.
Codename Crime (final name pending) – Beta support; bug report and feedback collection; sentiment reporting.
Dying Light (Western Europe) – Support with KOL activation.
Undawn – Assistance with Discord server management.
Additional Responsibilities
Beyond game-specific work, I have taken on internal management duties, overseeing two permanent contractors hired to support the social and community teams and coordinating their workload, providing guidance, and ensuring consistency across deliverables.
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
By mutual agreement with the laboratory's director, I switched to this role from my previous one at the beginning of 2019 as my former division was scheduled to be transferred out of 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 relocate to the United States.
Workplace
The workplace is one of the country's six forensic police laboratories, performing all types of forensic analyses (biological/DNA, drugs, ballistics, digital, etc.). About 150 people work there, amongst whom 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 application with a REST API used by other applications to manage users and their access roles.
A medium-sized 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 retention period has expired.
A large-scale application used to track all incoming and outgoing communications (calls, physical mail and email, 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 database of the laboratory's inventory management system (LIMS) 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 forensic police laboratory.
By mutual agreement with the laboratory's director, I switched from this role to my next one at the beginning of 2019 as my former division was scheduled to be transferred out of the laboratory later that year, and the development team could use an additional resource.
Workplace
The workplace is one of the country's six forensic police laboratories, performing all types of forensic analyses (biological/DNA, drugs, ballistics, digital, etc.). About 150 people work there, amongst whom, at the time, four technicians and two engineers performed digital forensics operations requested by police officers or magistrates.
Forensic Operations
During my time at this position, I have performed general digital forensic operations, including the enhancement of images and video footage. I have also assisted in performing special digital forensic operations such as recovery and analysis of deleted files on various digital storage media. I assisted extensively with drafting the analysis reports that would be sent to the requesting police officers or magistrates.
Software (Forensic 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 forensic 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 for generating all possible license plate combinations based on plausible character sets, and another for listing analysis steps based on a case's status and assigned technician, among 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).
Reporting vandalism.
Providing information and assistance to trail users.
Ensuring all visitors can enjoy the natural beauty of the city's greenway trails.
Moderation of the support forums.
Providing mid-level support to users.
Participating 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).
Community Discord server of more than 300 members.
Centered around a custom-made Pokémon game bot, developed in PHP, that has evolved through many updates over the years and has seen more than 900 unique players.
Bachelor's Degree, Electronics and Computer Science for Industry