Overview
About the Anvil Management Toolkit
The Anvil Management Toolkit is a suite of tools, documentation, and dashboards developed to support the management team of Ubisoft's Anvil Game Engine. It aims to centralize and standardize production processes across a 400 person department.
Over the course of my internship I designed and shipped a full wiki of documentation of standards for the management team and 3 different automated Power BI reports aggregating and presenting data from multiple SQL databases. Alongside the tooling work I also performed routine data analysis of team performance, contributed to sprint and milestone planning, identified and highlighted dependencies, and gained hands-on insight into how production pipelines operate at AAA scale.
Responsibilities
What I Did
- 01 Developed 3 Power BI dashboards actively used by Project Managers, Associate Producers, and Directors, eliminating manual reporting workflows
- 02 Designed and optimized data models using DAX and Power Query (M), measurably improving query performance and reducing report load times
- 03 Integrated data pipelines across multiple SQL databases and spreadsheets into unified, production-ready reporting systems
- 04 Engineered a centralized documentation platform on Confluence using HTML and CSS, and extended its functionality with custom JavaScript components beyond native capabilities
- 05 Owned the full development lifecycle of all tooling,from requirements gathering and design through implementation, testing, and technical documentation
- 06 Identified inefficiencies in reporting workflows and independently designed and shipped technical solutions without direction
- 07 Supervised a team of 15 programmers executing a full refactor of a core AAA engine tool, gaining direct insight into large-scale engine development practices and production pipelines