• Develop Functionality of EPSi Tool for the decision support team• Program extracts in SQL from Clarity to load Data into EPSi using Visual Studio Integrated with Team Foundation• Manage ETL processes and Data Validation• Program complex data extracts using TSQL, Access and other tools for internal and external Clients• Create Dashboard reports using Excel and Tableau• Create Ad-hoc reports as needed• Analyse Big Data and generate reports

Create reports using FRX to prepare financial statements including balance sheet, income statement and statement of cash flows and stockholders’ equityProvide audit support work papers for external auditorsPrepare work papers supporting SEC filingsComplex monthly account reconciliationsLead developer for design and implementation of SQL queries and reporting between external billing database and Great Plains Financials: Created AR aging analytic supporting reserve (85% gross billings collectible)Built “lead/lag” analytic to track and monitor DSOAutomated payment entry process allowing for elimination of dual postings and integration into GP (formerly requiring manual over two weeks by four full time employees)

Managed payment entry department of up to eight full time staffDeveloped metrics for measuring productivity and evaluating performanceWrote SOP guides to delegate reconciliation processesContinued assistance with quarterly and annual inventory reporting for audits.

Customized AR Aging reports from MS Great Plains to include insurance mappingCreated reconciliation tool for Payment Entry to assist with balancing depositsAutomated Payment Entry processes through macro creation and VBA scriptingCreated Rental Aging report used in quarterly and annual inventory analysisCreated Sales Report cards used to monitor sales and trendsSystem Administrator for Microsoft Dynamics accounting system

I entered payables, expense reports and processed the weekly check run. I also managed entering claim payments and daily balancing of their satellite pharmacy.

Worked Contract-to-hire for WellDyneRx. Assumed same responsibilities as when hired on full time as Accounts Payable Administrator.

Contractor assignment assisting with part set up while the department was transitioning to India.

Contractor assignment. Reconciled unapplied accounts payable of $32 million project. Uncovered flaw in their accounting system, causing duplicate checks and images to be unmatched. Recovered several million in unmatched payables through use of MS Access and Excel.

Inventory Management, POS face to face transactions with students. VA Reimbursement preparation. Employer Reimbursement preparation. Management of past due receivables.