STAFF ACCOUNTANT Experience August 2013 Current Company Name City State Accounting Manger Report CFO Manages 4 colleagues. The accounting department consists 2 Accounting Clerks, 1 Financial Analyst, 1 Volunteer. Lead person aspects close, including preparing entering 30 journal entries preparation 35 balance sheet reconciliations. Developed new easier ways journal entries month end process, using Microsoft Excel. Have reduced journal entry keying day half, allowing time analysis. Revamped old cost reporting 990 templates, using Excel, make process easier colleagues would enter information system. Have cut lead processing time each, making entire submission time faster system senior leadership. Selected point person help system office install run PeopleSoft Finance St. Mary's Hospital. Directly responsible training staff hospital, assisted system developing financial statements used today. Assisted hospital directors planning execution departments AOP next fiscal year. Assisted making $5 million dollar turn around total hospital EBIDA fiscal year 2015. Responsible maintaining tracking $75 million hospital fixed assets. Developed new FTE position control productivity report using complex queries reports Microsoft Access. June 2006 August 2013 Company Name City State Staff Accountant/ IT Report Finance Supervisor Assisted financial month end close, preparing 20 journal entries 25 Balance Sheet reconciliations. Developed various sales, TGP, contribution margin reports, using Microsoft Access Excel. Led division creating projects would strip relevant information report put Excel, using Monarch data mining software. Developed 30 models division use. Developed Excel macros help make entering journal entries easier month end. Corporate office started using month end close. Assisted developing automated reporting system would distribute reports sales force, senior management every morning. Led IT department helped maintain division IT infrastructure. Developed reports track IT assets give check list case hard drive crash maintenance activity. This report still used day division. Created sales report Excel used links, macros, formulas, show sales persons sales, TGP, cases, using drop box selecting name. December 2003 June 2006 Company Name City State Accounts Payable/ IT Report Controller Accountable coding paying Accounts Payable invoices. Including getting management signature, along following invoice discrepancies. Assisted getting purchase orders warehouse entering purchase order system. Developed new spreadsheet help track fuel expense tracking operations. Assisted month end close process, asked take sales tax beverage tax journal entries division. Accountable 5 Balance Sheet reconciliations division. Developed spreadsheet keep track customer credits, salesman reimbursements. Developed report show many purchase order shorts were, vendor warehouse id. Staff Accountant March 2001 December 2001 Company Name City State Reported Assistant Controller. Accountable inventory 15 Sprint stores area. Led month end inventory counts, store would send results I would match purchase order sales make sure everything tied out. Accountable process stolen, warranty damaged phones, making sure received correct credit back Sprint. Education IRS 990 Tax Reporting Submission *CMS Cost Reporting Submission *Property Tax Exemption Submission *AOP Budget Planning Bachelor Arts Accounting May 2000 Western Illinois University City State Accounting Associates Degree Accounting May 1997 Black Hawk College City State Accounting St. Mary's Hospital Leadership Team Skills Accounting, Accountant, Accounts Payable, balance sheet, Budget Planning, CMS, Controller, credit, data mining, senior management, Finance, financial, Financial Analyst, financial statements, fixed assets, hard drive, inventory, leadership, macros, Microsoft Access, Microsoft Excel, Excel, office, Monarch, month end close process, month end close, next, PeopleSoft, coding, reporting, sales, spreadsheet, Supervisor, Tax, phones