Courtney C. Colvin Email & Phone Number

Denver, CO, US

Denver, Colorado, United States

• Leverage financial systems and data analysis expertise to optimize reporting, enhance forecasting/budgeting models, and support internal stakeholders. Collaborate with senior management and technical teams to define.
• Automated Statutory Reporting templates using OLAP cubes, Dodeca-Essbase, Excel formulas, and VBA macros, cutting delivery time and errors by 20%.
• Redesigned Excel workbooks for income allocation, optimizing 300,000-cell calculations and enabling accurate financial data delivery within tight 2-hour deadlines.
• Conducted Q/Q variance analysis on $950M statement changes, delivering detailed written explanations to improve transparency in management reports.
• Built custom SQL datasets and Power BI dashboards to enhance data visualization and reporting accuracy.
• Validated actuary model data for 7 insurance products using Azure PaaS analytics, collaborating cross-functionally to address system configuration errors.

Lakewood, Colorado, United States

• Worked effectively with Controller to support the financial operations of the organization by assisting with month-end closings, preparing financial analyses, and ensuring the accuracy and compliance of transactions..
• Directed the month-end close process, ensuring the timely entry of all journal entries and 100% accuracy in account reconciliations, resulting in reliable and precise financial reporting.
• Led the automation of contractor work tracking for 100+ projects within the Microsoft AX Purchase Order system, accelerating client billing cycles and improving cash flow through earlier collections.
• Collaborated with the Controller to analyze and manage financial operations, including budget preparation, forecasting, variance analysis, month-end close processes, and journal entry development for three company.
• Built and maintained cross-functional relationships with teams such as Content Creation, Project Management, HR, and Operations Directors, providing data-driven accounting solutions to address complex system and.
• Optimized labor tracking processes by implementing systems to monitor agency salaries, freelance wages, and contracted labor hours, producing detailed variance summaries by employee for a 70-person workforce, and.

Denver, Colorado, United States

• Served as Subject Matter Expert in areas of allocations, payroll, intercompany balancing, and FX currency activity for US and Canadian corporate entities. Transformed data in JDE/D365 into journal entries and.
• Reorganized monthly close process to reduce corporate close from a 5-day to 3-day process to meet FP&A deadlines and deliver key information early.
• Developed and deployed Microsoft Excel reconciliation template for 15-person team in OneStream, boosting department efficiency by approximately 10% and reducing system instabilities.
• Directly impacted business profitability though identification of $5 million+ in write-offs and adjustments to income statements in monthly reconciliation process.
• Revamped payroll entry process to record $6.8 million in payroll entries for the US and Canadian entities 1 day sooner and delivering key data for resort executives.
• Participated in UAT testing for D365 ERP system weaknesses and documenting solutions that enhanced system reliability and user satisfaction.

Greater Denver Area

Davenport, Iowa Area

• Deliver specialized accounting guidance and support to clients by analyzing and improving accounting processes, ensuring compliance with GAAP regulations, and assisting with complex projects such as audits.
• Audited and reconciled $2.5 million clearing account and lead efforts to collect $1 million in erroneous disbursements. Utilize audit findings to strengthen internal controls, compliance requirements and accounting.
• Reorganize inefficient client filing system to ease document tracking and uncover $500,000 in overlooked revenue as a result of restructuring.
• Oversee the operation of high volume accounts payable ranging from $850,000 to $1 million monthly. Manage full- cycle coding, entering, approving and batching of checks and ACH payments.
• Lead project to cut costs by reorganizing accounts payable process and converting 594 vendors to ACH payments for faster intra-company payments.
• Revamp inventory system to reclassify fixed assets and determine useful life. Utilized straight-line method to record the appropriate amount of depreciation and update depreciation schedules.