Back to WorkCASE_STUDY // rf-attendance
Mobile Application · Production Backend · Administrative SystemsDeployed · In Use

RF-Attendance

Production music school management system built for Rockfarm School of Music.

ProductionActive Usage Status
13+Iterative Software Releases
70%Admin Time Saved
Mobile ClientCross-Platform Application
01 // EXECUTIVE OVERVIEW

Context & Objectives

RF-Attendance is an operational software solution engineered specifically for Rockfarm School of Music. It replaced legacy paper registers and fragmented spreadsheets with a unified, highly reliable mobile application used daily by staff and administrators.

02 // PROBLEM STATEMENT

The Problem

Before RF-Attendance, managing student enrollments, tracking daily attendance across multiple faculty schedules, monitoring monthly fee payments, and generating financial audit summaries required hours of error-prone manual bookkeeping.

03 // OPERATIONAL ENVIRONMENT

Context

Designed directly around live operational workflows at Rockfarm School of Music and deployed into an active production environment.

04 // SCOPE & CONTRIBUTION

My Role

Product Designer & Full-Stack Developer — Partnered directly with school leadership to map operational edge cases, design user-friendly touch interfaces, build database schemas, and deploy 13+ continuous updates.

05 // UX RESEARCH & INSIGHTS

Research & User Testing

Spent 2 weeks observing daily administrative workflows in studio environments to document operational requirements: walk-in trial sessions, pro-rated fee structures, substitute teacher tracking, and parent communication patterns.

06 // ENGINEERING & ARCHITECTURE

System Architecture

Engineered for cross-platform mobile operation, backed by relational database engines with cloud functions for background schedule processing and role-based access control.

Implementation Details

Built automated fee engine logic for pro-rated billing, embedded report generation for monthly financial auditing, and integrated zero-friction notification flows.

07 // OBSTACLES & CONSTRAINTS

Technical Challenges

Maintaining relational state integrity across multi-device edits while supporting offline buffer sync during poor cellular coverage in music studio rooms.

08 // ARCHITECTURE TRADE-OFFS

Key Decisions

Implemented transactional database locking and auto-reconciliation hooks to prevent conflicting fee status records.

09 // OUTCOME & IMPACT

Results

Successfully deployed and currently powering the day-to-day operations of Rockfarm School of Music. Reduced weekly administrative overhead by over 70% and eliminated fee calculation discrepancies.

10 // REFLECTION & LESSONS

Engineering Takeaways

Building software that runs in a real physical business taught me the critical importance of zero-downtime database migrations, resilient offline state handling, and designing for real operational friction.