Mason Coon

CorVel Corporation

Financial Analyst II                                    2019 - Present

• Enhance financial reports by adding additional data, visuals, and KPI’s.

• Support multiple internal units regarding financial analysis, data analysis, and market trends.

• Create annual market assessment reports to facilitate budget goals for mid-level management.

• Manage the calculation, distribution and disbursement of bonuses for 180 employees.

• Educate junior employees on industry knowledge and company best practices.

• Deliver monthly WIP reports to management and accounting for accrual purposes.

• Produce detailed analysis of prospective customer data to offer competitive pricing.

• Design flexible pricing models to estimate potential client profitability using incomplete data.

• Query internal databases using SQL for ad-hoc projects.

Financial Analyst I                                     2016 - 2019

• Distribute monthly financials to management and answer questions they have on roughly $50M of revenue.

• Calculate commissions to be paid on approximatlely $175M in sales revenue annually.

• Provide ad-hoc analysis for financial questions from various levels of management.

• Train new members on the team; specializing in Excel applications that utilize VBA to complete cross platform tasks.

• Streamline multiple processes to reduce the time and effort needed to complete.

• Determine profitability on new and current clients in order to maximize profits while keeping relationships healthy.

​

Hyundai Glovis (Glovis America, Inc.)

Business Planning Analyst                         2015 –2016

• Designed spreadsheets that automatically compile daily logistics reports to allow for time series analysis.

• Maintained up-to-date rate logs for all AR/AP transactions and record all contract changes.

• Provided any and all ad hoc analysis regarding port processing or maritime operations.

• Retrieved data from accounting and SCM programs to both analyze and check for discrepancies.

• Discovered major inefficiencies regarding long term vehicle storage and presented possible solutions to upper management.

• Compared budget to actual costs and reported findings to upper management on a monthly basis.

​