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 requirements, automate workflows, and deliver insights for informed decision-making.• 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.• Documented Oracle EPM Studio system requirements and served as a subject matter expert for troubleshooting.• Modernized hours-tracking processes for project-based work, improving accuracy and information delivery by 30%.• Provided dynamic, entity-level product data for cashflow projections and pricing analysis across six life insurance products, leveraging OLAP tools and Excel while collaborating with pricing teams.• Partnered with the Chart of Accounts team to update Dodeca-Essbase rollups, ensuring consistent treatment across Actuals, Forecast, and Budget scenarios.• Mapped the Investment Income workflow in Microsoft Visio, refining it based on management feedback to improve clarity and alignment with organizational goals.

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. Collaborated across departments to resolve accounts payable issues, manage expense reports, and address accounting discrepancies, all while supporting the Dynamics AX system structure and Sarbanes-Oxley compliance.• 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 divisions.• 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 operational challenges.• 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 identifying trends through actionable insights.• Compiled and validated financial documentation for quarterly Sarbanes-Oxley (SOX) compliance testing, ensuring adherence to internal control standards and regulatory requirements.• Automated complex financial workflows and journal entries using advanced Microsoft Excel functions, achieving a 50% increase in process efficiency and reducing manual intervention.

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 reconciled accounting data for completeness and accuracy.• 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.• Supported Financial Analyst and other department heads in monthly budget analysis to provide accounting explanations for variances.• Resolved US and Canadian currency outages in intercompany accounts and prepare supporting documentation for monthly cash settlement.• Created instructional resources utilizing video recordings, PowerPoint presentations and D365 interactive examples to train accounting staff across 15 national resorts.• Reconcile 145+ balance sheet accounts monthly

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, reconciliations, and financial reporting. Collaborated cross-functionally with management to streamline workflows, implement systems or tools to enhance efficiency, and address specific business challenges. • 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 procedures. • 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.• Reduce backlog by entering accounts payable/receivable billings 50% faster and 98% more accurate than predecessor. Restored delinquent accounts to current status and leveraged opportunities to save money on vendor purchases. • Tabulated $100,000+ in damages for class action lawsuit in embezzlement case. Audit purchase data over 4-year timespan to document supporting evidence in cooperation with Internal Affairs investigation.• Increased operational efficiency 95% by researching technology infrastructure and implementing improvements for cloud-based ERP accounting system.