Data Architecture
Unified
Single source of truth eliminated fragmented spreadsheets across the academy.
Data Architecture
From fragmented spreadsheets to a unified relational data operating system.
W Fencing was drowning in disconnected records across fragmented spreadsheets, losing critical member data and revenue visibility. Kamilla architected a unified relational database operating system in Airtable, eliminating operational silos and delivering a single source of truth for executive leadership.
Airtable
Relational Schema
Data Architecture
Executive Dashboards
Operations Unification
Automated Rollups
Strategic Narrative
Data unification is infrastructure, not cleanup.
W Fencing's operational data lived scattered across disconnected spreadsheets, manual attendance trackers, and individual coach folders. Athlete records, class rosters, billing schedules, and tournament results existed in isolated silos with zero relational links between them.
Kamilla designed and implemented a normalized relational database schema in Airtable, connecting students, classes, coaches, billing statuses, and competition results into a centralized operating engine. Leadership gained comprehensive visibility across programs, coach utilization, athlete progression, and program revenue.
Systems, not spreadsheets. Relational architecture turns operational friction into executive clarity.
Operational Silos
Eliminated
Student, billing, schedule, and competition records relationally linked.
Schema Model
Normalized
Architected with foreign keys, rollup computations, and lookup validation.
Revenue Visibility
100% Real-Time
Executive dashboards tracking program margins and athlete retention rates.
System Architecture
A relational schema that replaced operational chaos.
Core Engine
Unified Airtable Operating System
Engineered a fully normalized relational schema connecting athletes, rosters, coaches, billing schedules, and tournament milestones. Every record cross-references related entities, unlocking cross-functional queries and real-time executive reporting that was previously impossible.
Entity Modeling
Student-Program Relational Links
Linked individual student profiles to enrolled class levels, assigned coaches, payment records, and competition results, surfacing the complete athlete development lifecycle in a single dashboard view.
Automation
Automated Executive Reporting Views
Configured tailored filtered views and rollup formulas tracking revenue by program, coach workload distribution, student retention cohorts, and upcoming national competition entries without manual consolidation.
Governance
Data Migration & Integrity Runbooks
Cleaned, deduped, and migrated historical club records into the relational structure while authoring standard operating protocols for staff to guarantee perpetual schema integrity and zero duplicate entries.
Operating Tooling
Unifying fragmented data required relational engineering.
System Execution
How the data operating system was built.
01
Data Audit
Inventoried every spreadsheet, coach logbook, and payment tracker to map all club data entities and dependencies.
02
Schema Design
Architected the normalized relational data model: entities, foreign key relationships, field types, and rollup logic.
03
Build & Link
Constructed the Airtable base with linked records, lookup fields, rollup formulas, and automated input validation.
04
Migrate Data
Sanitized, deduplicated, and imported legacy student records and financial histories into the unified base.
05
Train & Launch
Trained administrative staff and coaches on data entry protocols, ensuring lasting schema hygiene and adoption.
Strategic Leadership Takeaway
Spreadsheets track tasks. Relational systems scale businesses.
Growing sports organizations and boutique academies inevitably hit a data ceiling: as athlete counts and program tiers expand, managing operations through disconnected spreadsheets creates administrative paralysis, billing errors, and customer churn.
At W Fencing, replacing fragmented sheets with a normalized relational database demonstrated how foundational data architecture creates immediate executive leverage. By unifying student histories, billing status, and coaching assignments into a single source of truth, leadership gained the clarity required to scale sustainably.
Certified Digital Expertise
The Discipline to Scale
I bring an Olympic athletic background to fuel the relentless discipline required to execute, a deep research background focused on hyper-targeted strategy, and the grit of the immigrant experience. I rely on hard analytics and behavioral strategy to build resilient operational systems that help businesses actually run.