Romain Porcheron

Freelance · Remote

• Data visualisation for a major video game company (through Wizenco): seasonal KPI analysis. SupersetBigQuery
• AI application that extracts and structures data from Instagram, TikTok and YouTube. FlutterGeminin8nSupabase
• Ongoing maintenance for Shirogames and Village People Games: HR tool, website, UTM tracking, dashboards, in-game data connector.

Village People Games · Remote

• Data pipeline from Unity to the data warehouse, centralising gameplay and sales. UnityGoCloud RunBigQuery
• Standardised in-game event tracking in JSON, for reliable collection and delivery.
• Medallion data structure, industrialised transformations and automated deployments. dbtBigQueryCI/CD
• Paid media data integration and KPI dashboards: monetisation, gameplay, user acquisition, performance. SingularSuperset

Shirogames · Bordeaux

• In charge of web, data and marketing projects, first for the marketing team, then for the whole company.
• In-game data: triggers in the games and delivery through a REST API to a server that filters and organises the data. HaxeUnityNode.jsMySQLMongoDB
• Data visualisation: on-premise open source tool and dashboards for games, marketing and KPIs. SupersetTrinoPython
• Marketing tools: CRM with weekly scraping of the 2,500 Steam games, wishlist tracking and estimator, in-game news, moderation, player accounts, publisher CRM, website redesign. Node.jsDHTMLXn8nWordPress
• Automation of administrative tasks and coordination. n8nSlack APIClickUp API
• In-house HR tool: leave, events, accounting, meeting notes. HaxeNode.jsn8n
• GDPR compliance for the marketing department.

Ahdoc / Ohara · Lyon

• Founded a company providing technical support for GDPR compliance, working with DPOs and CIOs.
• SaaS for data mapping and automatic purge of personal data. SQLNode.jsPythonn8nML

• Scheduling tool for the volunteers.
• Occasional help of all kinds.