Dawn Davis
Centralia,MO
Summary
Results-driven grants professional with extensive experience in managing grant programs and ensuring compliance with funding requirements. Known for fostering team collaboration and consistently achieving desired outcomes. Skilled in budget oversight and regulatory compliance.
Overview
25
25
years of professional experience
Work History
Senior Accountant
Columbia Insurance Group
04.2021 - Current
- Reconcile AS400 & other software systems, NEAM Investment reports, bank statements, and Payroll/Benefit reports to various general ledger accounts; investigate and correct discrepancies as needed
- Prepare numerous month-end journal entries and reports from the various AS400 systems, NEAM Investment advisors, Fixed Asset software, and Paycom Payroll reports
- Assist with preparation of Quarterly and Annual Financial Statements and with the filing of those statements with state insurance departments and other regulatory authorities
- Prepare various premium tax and other statistical filings to state insurance departments throughout the year
- Responsible for areas of ceded reinsurance processing which includes preparing month-end/quarter-end journal entries, filing the monthly or quarterly bordereaux/summary reports with the reinsurers, and completing year-end contingent commission calculations on several treaties
- Responsible for areas of assumed reinsurance processing which includes preparing month-end/quarter-end journal entries, preparing monthly, quarterly & yearly summaries of assumed reinsurance transactions for use in financial statement preparation
- Responsible for the preparation of year-end Investment reports for use in financial statement preparation; completion of the Investment confirmations requested by the outside auditors
- Responsible for the maintenance of the Fixed Assets system and all applicable general ledger accounts; for the preparation of year-end Fixed Asset reports needed for financial statements
- Responsible for the maintenance of the Unclaimed Property system and all applicable general ledger accounts; perform due diligence in locating the owners of unclaimed property; prepare reports needed for the filing of the unclaimed property with the appropriate state
- Perform various daily tasks which could include, processing of daily banking activity, approval of Positive Pay Exceptions, process and reconcile premium refunds and paid claims checks, process insufficient funds transactions, and balancing of daily EFT, Lockbox & internet payment activity
Accountant
Columbia Housing Authority
06.2020 - 04.2021
- Process first and mid-month landlord and utility payments for Housing Choice Vouchers, Project Based Vouchers and Continuum of Care programs transmitting electronic files for direct deposits and printing/mailing checks
- Ensure receipt of expected HUD funding and prepare journal entries to record revenue
- Reconcile bank statements in accounting software and match with bank statements, balancing to General Ledger; reconcile General Ledger accounts monthly
- Review and authorize rental assistance and utility adjustments for Housing Choice Vouchers, Continuum of Care programs and Emergency Housing Vouchers
- Review and authorize subsidy/rent adjustments to tenant accounts based on Project Based Vouchers rental assistance adjustments
- Set up new landlords and maintain any changes to their information in the accounting software, including contacting landlords for any corrections requested by the IRS regarding incorrect 1099 information
- Review of pro-rates posted in accounting software by program staff for monthly landlord and utility payments ensuring accuracy of each transaction
- Oversee and manage Notification of Overpayments sent by program staff to landlords; Ensure overpayments are repaid by landlords or deducted from future housing assistance payments
- Prepare monthly vacancy loss spreadsheets for LIHTC Vacancy Losses and Vacancy HAP
- Process journal entries and online bank transfers to record vacancy losses
- Prepare monthly journal entries and online bank transfers to record management fees (AMP 1, CHA Business Activities LIHTC, COCC's Amp 1 and Section 8, NSP and McBaine)
- Prepare monthly journal entries to record PILOT and allocate shared building expenses
- Prepare, mail, and transmit electronic files for all 1099-MISC and 1099-NECs
- Prepare and submit financial data to invoice the City of Columbia for TBRA funding
- Prepare and submit monthly Voucher Management System (VMS) reporting in HUD's REAC system
- Ensure all records are well maintained, organized and available for the annual financial audit
Rate Analyst
City of Columbia
04.2019 - 06.2020
- Collect, compile and analyze electric and water financial data of the utilities to serve as basis for rate setting and accurate fiscal management and to assist in budget preparations, cost of service analysis, rate design analysis, and forecasting
- Analyze customer service billing and usage data to determine equity and accuracy of rate classes and user fees
- Collect information to prepare the Capital and Operating budgets for electric and water Utilities
- Prepare excel reports to assist Division Managers with preparation of budgets
- Review estimates, base budget and supplemental requests for compliance with management guidelines and verify completeness, analyze trends, and report discrepancies and areas of concern
- Monitor and troubleshoot utility billing software related to rate calculations and bill presentation
- Conduct research, prepare comprehensive reports, and present complex financial and statistical information in a clear and concise manner
- Perform on-going financial reviews of utility expenditures and revenues and educate division managers and their staff, as needed on proper accounting and fiscal procedures
Full-Charge Bookkeeper
Missouri United Methodist Church
04.2018 - 04.2019
- Responsible for managing and accounting for the financial resources of the Church working in close collaboration with the Senior Pastor and the Finance Team
- Lead the process of creating the annual budget for submission to the Lead Team for final approval and monitor financial performance against budget throughout the year
- Prepare and monitor internal controls and financial policies and procedures
- Administer and oversee the automated, double-entry, accrual, fund accounting system
- Maintain member giving, reconcile gifts to the GL and provide giving statements to members quarterly
- Maintain vendor records, prepare AP checks, obtain required signatures, monitor adherence to payment policies and procedures, reconcile AP to the GL
- Reconcile bank and investments accounts monthly and submit to Treasurer and Office Manager for review and approval
- Account for and logistically manage investment funds, monitor and record investment activity in the GL
- Maintain accuracy and integrity of financial data in the GL through periodic review and regular reconciliation
- Maintain and process bi-weekly payroll utilizing Paycor ensuring accuracy and compliance with policies
- Manage new hire onboarding and administration of benefit plans (medical, dental, 401K, etc.)
Business Manager II
MU-Truman School of Public Affairs
10.2015 - 12.2017
- Division Fiscal Officer for all HR and business functions for the Truman School and the Institute of Public Policy
- Preparation and management of an annual budget of ~$3.5 million
- Prepare Hyperion/Cognos budget, financial and salary reports for the Director
- Tracking, monitoring expenditures for appropriateness, approving expenditures, preparing, reviewing and approving journal entries and perform as signature authority; performing all finance functions; fiscal year-end closing; advise management on all fiscal matters
- Perform all pre and post-hire recruitment of faculty, staff and students and provide HR advisement
- Work with International Center to assist faculty, staff and scholars processing required immigration documents
- Develop, implement, and provide interpretation of Campus/University policies to faculty and staff
- Performed all pre- and post-award activities for proposal preparation and submissions, prepared monthly financial reports, effort verification, and ensured compliance with OMB Circular A-21 cost principles and sponsor guidelines
Sr. Business Support Specialist
MU-College of Education
03.2013 - 10.2015
- Served as the administrator for all fiscal/HR functions for the Office of Academic Affairs, Office of Research Support and the ReSTEM Institute
- Preparation and management of an annual budget of ~$3.2 million
- Prepare detailed financial reports for unit directors and Associate Deans
- Manage the process of hiring faculty, staff and students and provide human resource advisement
- Support the College's programs and activities by providing fiscal advisement
Administrative Associate II
MU-Physical Therapy
07.2002 - 03.2013
- Served as the administrator for all HR and fiscal functions
- Prepared, managed, and reconciled an annual budget of ~$1.9 million
- Tracking, monitoring expenditures for appropriateness, approving expenditures, reviewing and approving journal entries and perform as signature authority; performing all finance functions; fiscal year-end closing; advise management on all fiscal matters
- Performed all pre- and post-award activities for proposal preparation and submissions, prepared monthly financial reports, effort verification, and ensured compliance with OMB Circular A-21 cost principles and sponsor guidelines
- Performed all HR functions for faculty, staff and students and provide human resource advisement
- Perform all pre and post-hire recruitment of faculty, staff and students
- Work with International Center to assist faculty, staff and scholars processing required immigration documents
- Supervised support staff and student workers
Grants/Contracts Specialist
MU-Child Health, School of Medicine
01.2000 - 07.2002
- Served as the administrator for all department fiscal functions and supervised fiscal staff
- Performed all post-award activities for grants and contracts, including preparing monthly financial reports, effort verification, and ensuring compliance with OMB Circular A-21 cost principles and sponsor guidelines
- Prepare detailed financial reports for unit directors and Associate Deans
- Created and maintained a web page for the fiscal office
Education
Bachelor of Science - Accounting And Finance
University of Missouri
Columbia, MO12-2006
Skills
- Grants management
- Proposal development and submission
- Budget preparation and monitoring
- Financial reporting
- Strategic planning
- Grant compliance
Timeline
Senior Accountant
Columbia Insurance Group
04.2021 - Current
Accountant
Columbia Housing Authority
06.2020 - 04.2021
Rate Analyst
City of Columbia
04.2019 - 06.2020
Full-Charge Bookkeeper
Missouri United Methodist Church
04.2018 - 04.2019
Business Manager II
MU-Truman School of Public Affairs
10.2015 - 12.2017
Sr. Business Support Specialist
MU-College of Education
03.2013 - 10.2015
Administrative Associate II
MU-Physical Therapy
07.2002 - 03.2013
Grants/Contracts Specialist
MU-Child Health, School of Medicine
01.2000 - 07.2002
Bachelor of Science - Accounting And Finance
University of Missouri
Similar Profiles
Michelle SellsMichelle Sells
Workers Compensation Specialist at Columbia Insurance GroupWorkers Compensation Specialist at Columbia Insurance Group
Brooke BeasleyBrooke Beasley
Corporate Claims Coordinator at Columbia Insurance GroupCorporate Claims Coordinator at Columbia Insurance Group
Brooke BeasleyBrooke Beasley
Commercial Lines Processor at Columbia Insurance GroupCommercial Lines Processor at Columbia Insurance Group
Brian ReamsBrian Reams
Sales Manager at Mattress FirmSales Manager at Mattress Firm
Jaren JohnstonJaren Johnston
Sheet Metal Fabricator at Questec MechanicalSheet Metal Fabricator at Questec Mechanical