Experience

• Served as analysis lead for a five-person team, owning the project end-to-end from data extraction and dashboard development through final reporting and executive presentation, while coordinating biweekly meetings with Ducks and Rinks client stakeholders and our UCI faculty advisors.
• Designed and executed SQL queries in SSMS against the DASH (Rinks) and Archtics (Ticketmaster) schemas to build five analysis-ready datasets covering LTP registration records, 12-month cohort retention, pre/post-enrollment program participation, post-LTP program sequencing, and ticket sales crossover, applying client-defined business logic including revenue calculations across primary and secondary market channels.
• Built eight dashboard pages across three core analyses (ALTP Registration, ALTP & Program Retention, and ALTP Ticket Sales Crossover) for 1,285 LTP participants, using DAX and Power Query to support dynamic year-over-year KPI cards, cohort retention line charts, a ranked post-LTP program sequence analysis, and both calendar and fiscal year views aligned to the Ducks' June 30 fiscal year end.
• Delivered recommendations to formalize a structured post-LTP off-ramp experience, deploy a post-completion participant survey, and implement demographic-targeted ticket marketing, with the dashboards serving as the ongoing measurement tool for initiative success.

Soft Skills Developed: Team Leadership, Data Modeling, Cohort Analysis, Retention Analysis, Descriptive Analytics, Marketing Analytics

Software Used: SQL, SSMS, Power BI, DAX, Power Query

• Directed food security initiatives including CalFresh Assistance Appointments, Fresh Finances, CalFresh Enrollment Parties, and large-scale events such as UCI Orientation, Celebrate UCI, and the Mobile Pantry Grand Opening; managed end-to-end logistics including venue coordination, catering, transportation, and day-of execution in partnership with UCI Student Services, UCI Transportation, and Orange County Social Services.
• Scheduled and managed 100–200 monthly CalFresh Assistance Appointments using Acuity Scheduling, coordinating staff availability, adjusting for cancellations, and ensuring consistent appointment coverage; managed all CalFresh communications including the program email inbox, student-facing outreach, departmental and partner correspondence, and semi-weekly personalized SAR7 and RE deadline reminders segmented by applicant type.
• Managed data entry and analysis for CalFresh services, implementing a new Excel system with pivot tables, advanced functions, and conditional formatting that tracked eligibility data, reporting timelines, and confidential case details, resulting in a 50% improvement in data management efficiency.
• Overhauled the center's marketing strategy by shifting from content-first to a data-driven approach, using Meta Business Suite analytics to track post performance, audience engagement, and campaign reach; used those insights to refine content strategy across platforms, contributing to a 200% increase in social media engagement and a record-breaking Giving Day fundraising outcome.
• Restructured the center's data reporting system to standardize how CalFresh appointment trends, program utilization, and operational KPIs were tracked and formatted, aligning outputs with CSUN grant reporting requirements and simplifying the compliance process for external partners.

Soft Skills Developed: Program Coordination, Data Analysis, Event Logistics, Cross-Departmental Collaboration, Hiring & Training, Staff Scheduling

Software Used: Excel, Acuity Scheduling, Mailchimp, Meta Business Suite, SharePoint