Cost Accounting • Managerial Analysis

Opera Production Pricing & Repertoire Case Study

Conducted an in-depth cost accounting analysis to determine optimal production pricing and seasonal repertoire selection for an opera company. Evaluated fixed venue overhead, cast and crew wages, variable production costs, and ticket demand elasticity to recommend a profitable pricing strategy and maximize contribution margin across performances.

Cost Accounting Pricing Optimization Contribution Margin Break-Even Analysis Case Analysis
Financial Accounting • General Ledger

Mock Bicycle Company: Full Accounting Cycle

Executed the entire operational accounting cycle for a simulated commercial bicycle enterprise. Managed and recorded daily business activity including credit sales and cash receipts, vendor purchase orders, inventory tracking, adjusting and closing entries, and multi-tier payroll calculations and tax withholdings.

Full Accounting Cycle Sales & Cash Receipts Payroll Processing Purchases & Payables Trial Balance
Relational Database • SQL

Beauty Store Relational Database Architecture (MySQL)

Designed and implemented a normalized relational database in MySQL for an e-commerce beauty retail store. Structured relational tables linking customer records, product catalogs (productID, categories, unit prices), purchase orders, and itemized transaction lines, writing structured SQL queries to analyze customer order trends and track inventory levels.

MySQL Relational Schema SQL Queries Data Normalization E-Commerce Schema
Data Visualization • Tableau

LinkedIn Job Posting Drivers: Visual Analysis & Presentation

Researched and built a visual analytics presentation investigating the key variables and market factors that drive job postings on LinkedIn. Leveraged diverse Tableau capabilities—including interactive dashboards, calculated fields, dynamic parameters, and visual storytelling—to uncover hiring patterns, demand by industry, and key job characteristics.

Tableau Data Visualization Calculated Fields Interactive Dashboards Labor Market Analytics