Peter Schilling Email & Phone Number

Denver, Colorado, United States

-Provided automated solutions to for a wide range of departmental projects from evaluation and consultation through the development pipeline, into production and ongoing support. -Automated solutions were developed primarily in Blue Prism, but also included automated excel solutions and other systems.-Performed operational diagnostics in conjunction with department leaders to evaluate and analyze current procedures and to prioritize optimization of operational efficiency

Denver, Colorado, United States

The below stated responsibilities in addition to: -Design, improvement and maintenance of standard reports and templates, including macro enabled Excel templates, Workiva Wdesk reports, PowerPoint and Word documents-Database systems analysis and troubleshooting (Oracle Essbase/Hyperion Smart View)-Supporting the implementation and transition of new forecasting database systems-Leading database systems and VBA training with various departments-Variance analysis training for on-boarding of new hires

Denver, Colorado, United States

The below stated responsibilities in addition to: -Increased accuracy of assigned budget and forecast areas leading to faster production andfacilitating executive decision making-Ad hoc reporting for executive decision making, external auditors and various departmentsPreparation of earnings release schedules

Denver, Colorado, United States

Maintain and improve standard reports for budgeting and forecasting areas including:-Property management, affordable low income housing real estate, interest income, debt covenant coverages and funds from operations.-Periodic variance analysis of the above mentioned areas for forecasting changes and budget evaluation.-Run and distribute Oracle PeopleSoft reports and maintain property attributes.

Responsibilities included interpretation and evaluation of hospital contracts with insurance companies on the basis of language content, rates, terminology, and reimbursement methodology as well as construction and maintenance of payment models built from insurer contracts to track expected reimbursement for accounts receivable and to facilitate analysis of patients' accounts after payment is received. Additional responsibilities included providing spreadsheet creation and support, database support, and large data-set analysis for a variety of projects, both alone and in a team environment. Maintenance of contracts, models, and other projects were performed in accordance with standard health care reporting and compliance procedures.

Responsibilities included payment trending analysis and modeling systems analysis as part of reporting and compliance procedures (Sarbanes-Oxley). In addition, provided spreadsheets and analysis support for managed care and governmental care departments as well as ad-hoc projects in a team environment.

Richmond, Virginia Area

Responsibilities included maintenance of patient accounts and analysis of payment discrepancies to facilitate billing, appeals and collection processes.