Adam Bartel Email & Phone Number

United States

Indianapolis, Indiana, Us

Provide support to contractors by accurately pricing rate proposals from facilities, to best estimate the impact of any changes proposed and inform further negotiations.- Utilized previous claims experience to estimate the potential effect of future claims expense exposure, based on proposed rate and methodology changes.- Maintained databases for two states which tracked annual rate increases by facility. This allowed the company to track expected cost of care increases, and also to recognize contractors for positive negotiations.- Led project to create new plug and play model that would allow contractors to create scenarios and test different rate combinations, which was completed in a very compressed time-frame.

Cincinnati, Ohio, Us

Supported market business development functions. Develop reports to support executive decision making for market planning.- Developed reports to track year-over-year trends, budget variances, and forecasted volumes. Tracked overall volumes and revenue by market, service lines, and payer groups, to identify top and bottom line strength and weakness.- Served as the subject matter expert for multiple applications (hospital association database, forecast platform, demographics database, mapping application). Trained analysts and managers on how best to utilize the platforms/applications.- Provided quarterly market share reports to compare Mercy with competing systems. Used data to focus executive management on developing market trends, and to assess potential acquisitions.- Participated in initial rollout of Tableau software. Built workbooks to demonstrate utility of software. Worked with IT to develop field structure for vertical datamart, which allowed for faster processing speeds.- Maintained working relationships with various vendors, acting both as a liaison between them and analysts for functional issues, and with management to ensure contracts were updated and invoices were paid on time.

Cincinnati, Ohio, Us

Support the build of the Analytics function for HR. Work with vendors to develop an interactive platform to report on results.- Led effort to screen vendors, hold reference calls, and assist in decision making for the selection of the future HR analytics module.- Supported nursing workforce planning initiative; provided key analysis that identified potential retirement risks and nurse shortages, as well as showing areas of improvement that would lead to a better patient experience.- Collaborated with regional subject matter experts to complete data alignment projects, bringing data from eight markets and four Peoplesoft instances into a single database.

Cincinnati, Ohio, Us

Utilize decision support systems to pull data and create reports and analyses for all areas of the company.- Led and participated in the implementation and upgrade of both Horizon Performance Management data warehouse application, and Horizon Business Insight business intelligence application, which replaced individual market data warehouses.- Administered multiple system-wide scorecards that served as the primary resource for tracking entity and leadership performance, and were utilized to determine incentive payouts and executive compensation.- Played an integral role in the standardization of clinical statistical definitions in Hyperion financial software; worked with financial leaders of all regions to establish consistency across system, allowing financial reports to display apples-to-apples data.- Created and maintained reports used by multiple functional areas that measured market share, profitability, employee performance, and many other aspects.

Indianapolis, Indiana, Us

Directed the daily workload of three senior analysts. - Worked with technical support contacts to move data collection for yearly budget allocations process from Excel macros to a Lotus Notes database; saved customers over 100 hours of data entry.- Led several projects to help improve accuracy of cost allocations; coordinated with contacts throughout organization to utilize new sources of data, and verify accuracy of existing data.- Served as a technical resource for the Southeast regional office for Peoplesoft ABM (Activity Based Management), Business Objects, and general Anthem cost allocations practices.

Indianapolis, Indiana, Us

Support yearly cost allocations process. Create reports and analyses to identify impact of allocation variances related to support or driver changes.- Coordinated yearly FEP (Federal Employee Program) True-up for Midwest region, as well as supported government audits of program.- Implemented monthly allocations process that reduced month-end close workload by 5 hours.- Trained new hires on ABM and general allocations methodology; gave presentations to 150 managers on their role in the cost allocations process.- Analyzed financial results to identify trends to assist business segment consultants in making informed decisions to improve profitability.

B.S., Finance

Education record