Deanna Coonen Email & Phone Number

Texas, United States

Chicago, Illinois, Us

 Create and maintain accrual report for all Tronc business units in Xactly system at the start of each pay period Work directly with internal Audit to create payroll reconciliation processes for commissions for all sales reps in Xactly for Tronc business units to comply with SOX requirements and submit to Payroll. Assemble and summarize data to structure sophisticated reports on commission status and payout Utilize data mining and advanced spreadsheet skills to quantify analysis of commission activities  Employ best practices of data analysis and validation to ensure data results are accurate Special Project Teams – Implementation and testing of Xactly and CRM applications Conduct ad hoc research projects incorporating project design, data collection and analysis, summarization of findings, and presentation of results Data analysis and spreadsheet modeling and reporting utilizing advanced Excel functions such as Vlookup, Hlookup, data filtering, linking, pivot tables and macros Design and implementation of procedures, templates and dashboards used companywide for consistency across departments Train sales teams on tools for reports and templates including travel to business units Daily interaction with Finance Directors, Advertising VP’s and Managers related to various issues Conduct and manage User Acceptance Testing for new software implementation and integration Consolidation and testing of multiple compensation plans to enhance company productivity Using Excel, Xactly, Microsoft Dynamics AX, WorkDay, Citrix Receiver, Office 365, Territory Management, CRM (SQL Database) and Adit!

Savannah, Ga, Us

• Projected monthly forecasts and overhead using pivot tables• Reviewed non-revenue daily• Tracked indirect and capital expenses• Created an asset inventory system for the storage facility • Improved the process for overtime reports and forecasts to significantly reduce time spent on reports by creating macros, pivot tables, using V-lookups and formulas

• Reviewed commission for all of CPG and compare to make sure that commission matches by utilizing Excel pivot tables, formulas and lookups• Found any discrepancies and investigate as to why they are there and correct them• Created the commission analysis process using advanced Excel and creating an Access database• Backup on 6 groups for purchase orders, flyers, marketing, etc.

• Accountable for all income calculations and analysis including self employment• Reviewed employment verifications for all borrowers• Responsible for analysis of loans with debt to income issues• Analyzed homeowners insurance, appraisals and title work• Complete post-closing conditions

• Responsible for accounting functions in multiple interrelated business groups consisting of seventeen locations across the Midwest• Entered in and processed accounts payable and accounts receivable including reviewing all invoices and creating invoices while maintaining good standing with all vendors• Processed payments for invoices and tracked credit memos for the return of goods • Responsible for answering any questions or variances on accounts and contract• Created reports for financial analysis such as Profit and Loss Statements, Balance Sheets and reviews of accounts

Minneapolis, Mn, Us

• Analyzed escrow accounts • Researched and paid taxes and insurance for escrow account holders• Performed maintenance and processed payments for customer escrow accounts • Received the Employee of the Month award for work in Excel to help track Escrow accounts and keep accounts up to date

Chicago, Illinois, Us

• Provided quality service and support to the branch office and its customers.• Performed post-closing document review and editing.• Ensured accuracy and quality of documentation.

Chicago, Illinois, Us

• Performed account maintenance including loan editing, payments, payoffs, and draws.• Reviewed loan documents and entered new and renewed loan information into the computer system.• Resolved discrepancies between the system and existing documentation.• Performed multi-system balancing of all monetary transactions and maintenance throughout the day.

Chicago, Illinois, Us

• Performed exception tracking data entry and exception report research.• Reviewed and sorted incoming mail and overnight deliveries.

Chicago, Illinois, Us

• Provided document control services.• Performed general maintenance and storage of files using a terminal digit system.• Retrieved documentation and files; performed customer service research.

Appleton, Wisconsin, Us

• Processed transactions, encoded checks, and filed account information.• Provided exceptional customer service.

Bachelor’S Degree, Accounting

Associate’S Degree, Business Management