Debbie Prawl Email & Phone Number

Kansas City, Missouri Area

Client: USDA, Farm Service Agency, Fund and Commodity Management Office (FCMO) - Support Fund and Commodity Management Office by doing monthly reconciliation of accounts and funds, creating an Unliquidated Obligations (ULO) database, consolidation of ULO reconciliations, audit deliverables, and special projects as needed. Deliverables:• Maintained the program consolidation master manual for Farm Loans by using generally accepted accounting principles and standards.• Maintained and updated the Farm Loan monthly program consolidation for program years 2000-2017.• Redesigned and assisted with the ULO reconciliation.• Performed roll-up and consolidation for up to forty-five ULO reconciliation.• Drafted SOPs on reconciliations and ULO quarterly certification process.• Provide extensive support in the historical clean-up of the Loan Receivable Clearing Account for the Receivable Management Office.• Created and maintained a database process in Access.• Compiled and distrubuted data for ULO certification; colated and processed the responses.• Developed a Year-to-Date tracking system for the changes in the ULO for all CCC programs referred to as "The Delta". Presented "The Delta" to the Management in the FCMO area. "The Delta" is now a standard monthly report for Management insight.

Kansas City, Missouri Area

• Allocate Lease Crude production funds for issuance of over 15,000 payments monthly totaling approximately $150,000,000, with 100% accuracy, to lease owner and operators, including calculating interest on any payments held and performing continual review and reconciliation of payouts. • Maintain comprehensive pricing information for 900+ operators with separately negotiated premium pricing agreements through lease crude system, (BOLO | P2 Energy Solutions)• Prepare all departmental general ledger reports utilizing Oracle Financials, create semi-monthly cash projections with three month forecasting, and continually review and administer prior period tax adjustments. • Increase accuracy, production and profitability of Lease Crude field sales representatives and management by developing and providing specialized reports including pricing, analysis, comparison graphs, historical data, and customized system data reports. • Develop and present bi-annual system training to Field Offices including initial implementation and provide new employee computer systems instruction via distance training.• Compile Kansas Severance Taxes, including exempt and non-exempt status, impacting 6,000+ leases resulting in payment of $1,500,000 in monthly Kansas Lease tax. • Generate 1099’s, adjustments, changes in status and Form 945 detailing withholdings. • Continually improve systems capabilities through hands-on consultation and partnership with outside IT for system upgrades and modifications encompassing testing, change recommendations and final approval of custom system changes.• Coordinate with internal and external auditors on SOX Compliance.• Serve as Subject Matter Expert for management, field office personnel, operators and mineral interest owners regarding all aspects of domestic crude oil accounting.

Kansas City, Missouri Area

• Performed daily expense analysis and prospectus compliance including broker fees, Net Asset Value after expense, expense ratios, tolerance of price, yield, and distributions for a portfolio of large mutual funds. • Prepared schedule of investments (stocks utilized in fund) and investor packets, including fund prospectus for distribution to clients. • Awarded multiple incentive recognitions for outstanding performance.• Provided performance statistics including graphs based on year-to-year metrics. • Reviewed for accuracy quarterly financial reporting income statement, balance sheet, expenses, top holdings, fee schedules, and expense ratios.

Kansas City, Missouri Area

• Monitored day-to-day monetary operations of three funds including opening cash balance, preparation of bank statements, monthly general ledger activity and accounting control reports, Net Asset Value calculations, and researched cause of substantial percentage losses or gains for distribution to fund managers.

Bachelor Of Arts (B.A.), Marketing

Bachelor Of Arts (B.A.), Accounting And Business/Management