• Lead content design sessions with subject matter experts (SMEs) to determine whether Epic Foundation System Go-Live-Critical reports in the Hospital Billing and Hospital Claims areas will meet their needs.• Make appropriate changes to Reporting Workbench (operational) reports from the Epic Chronicles hierarchical database as requested by SMEs in the Hospital Billing and Hospital Claims areas.• Make appropriate changes to Crystal Reports (analytical) reports from the Epic Clarity relational database as requested by SMEs in the Hospital Billing and Hospital Claims areas.• Serving as point person on design and development of Epic report intake process being coded in Microsoft SharePoint by an independent consultant.• Designed, coded, tested, and implemented a Visual Basic/SQL Server database for Process Improvement Engineering which allows management personnel to display information concerning pre-Epic vs Post-Epic workflows by facility, application, and/or change type.• Coded an Access VBA (Visual Basic for Applications) project that executes SQL queries on the legacy billing system (Stockell Insight) relational database, calculates ten KPIs for the three-month period prior to Epic Go-Live, programmatically starts Excel, and outputs the KPIs to worksheets for comparison to Epic Go-Live data.• Radar (dashboards) Administrator for ProMedica Information Technology Services. • Reporting Workbench (operational reports) Administrator for ProMedica Information Technology Services.

• Performed both regularly-scheduled and ad-hoc SQL queries of billing system (Stockell Insight) relational database for both month-end close and Medicare Cost Report Purposes, as well as for auditor data requests.• Performed both regularly-scheduled and ad-hoc queries of the GL system (Lawson) using the interface, as well as the Query Wizard within Lawson Add-Ins, for both month-end close and Medicare Cost Report Purposes.• Prepared month-end-close journal entries and account reconciliations, as well as running month-end financial statements in Lawson for second largest ProMedica hospital.• Prepared Medicare Cost Report for second largest ProMedica hospital.• Completed Meaningful Use Attestation process for Medicare, Ohio Medicaid, and Michigan Medicaid EHR Incentive Programs, as well as monitoring timeliness and accuracy of incentive payments.• Conducted annual look-back analyses by facility to determine self-pay payment rates for AR reserve models.• Coded an Access VBA (Visual Basic for Applications) project that executes SQL queries on the legacy billing system (Stockell Insight) relational database to prepare a database of month-end AR balances by hospital, and by payor within hospital, programmatically start Excel, and prepare trend graphs of month-end AR dollars over a selected time period for acute-care collections managers.• Coded an Access VBA (Visual Basic for Applications) project that executes SQL queries on the legacy billing system (Stockell Insight) relational database to extract late-charge-entry data, programmatically start Excel, and prepare late-charge-entry reports for CDM analysts, saving approximately eight hours per month, per analyst.

• Ran month-end reports, prepared month-end-close journal entries and account reconciliations, and ran month-end financial statements for ProMedica retail DME business unit in DME billing system (Brightree).• Ran month-end reports, prepared month-end-close journal entries and account reconciliations, and ran month-end financial statements for ProMedica retail pharmacy business unit in pharmacy billing system (QS1). • Ran month-end reports, prepared month-end-close journal entries and account reconciliations, and ran month-end financial statements for ProMedica home infusion business unit in home-health billing system (CPR+).• Coded an Access VBA (Visual Basic for Applications) project that executes SQL queries on the legacy billing system (Stockell Insight) relational database to prepare a database of month-end AR balances by skilled nursing facility (SNF), and by payor within SNF, programmatically start Excel, and prepare trend graphs of month-end AR dollars over a selected time period for SNF collections managers.• Coded an Access VBA (Visual Basic for Applications) project that executes SQL queries on the legacy billing system (Stockell Insight) relational database to identify DNB (Discharged, Not Billed) visits past min days, programmatically start Excel, and prepare reports of accounts, by facility, sorted by days remaining until timely-filing deadline for the HIM department. Coders are then able to prioritize the accounts, work to resolve the issue, and drop a bill in a timely fashion, thus savings thousands of dollars in potential write-offs.• Assisted third-party vendor handling out-of-state Medicaid collections in the compilation of information required to complete out-of-state Medicaid applications.

Designed, coded, tested, and implemented a financial analysis system to rank investment potential of common stocks using the Standard & Poor's Compustat database for Dominion Trust Company of Roanoke, Virginia. Monthly customized reports produced by the system were provided as a service to other firms and individuals offering investment analysis and advice.

Involved in the design, coding, testing, and implementation of new wire transfer systems (Bank Wire, Fed Wire, and Telex/Twx) with an average daily volume of $6 billion. Project Leader for batch processing portion of system, supervising the activities of several programmers. Also responsible for coding and testing of several on-line modules used by wire-transfer operators.

Coded, tested, and implemented application programs (demand deposits, time deposits, installment loans, mortgage loans) for data center operation operated by a consortium of small banks in the Pittsburgh area. Customized systems requirements and report formats for each bank.