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