Team Operations App
Creator, Product Manager, Database Design, UI/UX, Continuous Improvement
Initially launched 2017, version 2.0 launched September 2023
Ford Next Generation Learning (Dearborn, Michigan)
Designed and built operations software to manage multi-year contracts for dozens of clients, including account management, forecasting, invoicing, payroll, and human resource allocation and utilization
Added features and updates over many years to make it more intuitive, collaborative, and efficient so colleagues had the information they needed at their fingertips
Implemented automations to streamline routine tasks and catch errors, as well as notify and prompt team members at key points in the workflow
Designed record templates for common contracts to expedite the proposal process that automatically generate associated team allocation, invoice, and contract milestone records
Added permissions and user-specific views
Provide ongoing training and assistance to team members
The software is built on a database with 13 tables:
Utilization shows aggregate data for individual allocations to each contract:
Templates allow for edits instead of creation: