Jeryl Smith Email & Phone Number

Michigan

Evaluate data and redesign spreadsheets for internal customers.

Michigan

Downloads, edits & analyzes large amount of data. Formats data into useable documents for finance department. Uses Excel & Access on a routine basis. Uses multiple business analytic tools. Builds dashboards for high level professionals. Builds SQL Teradata queries and intermediate development of Access queries with expressions. Intermediate user of Trans-SQL in Access.

Maintained, tested and audited contract models in the Enterprise Performance Systems (EPSi) for theDecision Support/Cost Accounting departments, improving the accuracy of net revenue figures andenhancing the monthly processing speed of net revenues and payment variances.* Applied EPSi training when computing expected payments to assemble contract models with minimalassistance and accuracy.medical codes and applying proposed net revenue factors to quantity desired and reimbursement figures fromfee screen system.Worked in EPIC software reviewing patient detail & financial data.* Organized and provided interactive EPSi training for finance staff and management teams.* Utilized procedure codes from database to predict future net revenue and made financial recommendationsto hospital physicians.* Established high level Access queries to support financial documentation, which generated Medicare costreports to be more efficient and made reporting a smoother process for input into cost report software.* Assisted patients in determining financial qualifications for procedures by developing and maintaining afinancial service process.* Analyzed detailed patient records to determine payments, write offs and adjustments.* Analyzed income statements and balance sheets resulting in the break out of sources of income from theincome statement and various named assets.* Modified, ran and analyzed Crystal reports to determine variances and percentage changes on paymentmeasures.

*Developed and modified Cognos Impromptu queries to determine membership at GM facilities*Reviewed claims in NASCO system using HIPPA guidelines*Developed Power Point presentation based on membership data for upper management

* Updated monthly revenues using Time Sharing Options (TSO) and Job Control Language (JCL), resulting inimproved reporting time and increasing turnaround for management by 24 hours.* Presented numerous hands on training sessions teaching PeopleSoft Accounts Payable module, resulting inincreased workflow and organizational efficiency.