Evan H. Email & Phone Number

Manage relationship with analytics team to consult on best reporting practices, advise on project priority, sign-off on requirements, perform testing, and implement new data and reporting into population health operationsAnalyze provider quality, medical utilization, and HCC documentation rate performance metrics using PowerBI and Tableau to identify underperforming providers, practices, and regions for escalation to population health managers and physician leadershipImplemented a provider engagement documentation process to enable tracking of engagements for quality, documentation, and utilization purposes to help measure provider improvement post engagement performance

Created market profiles with market share, physician leakage, competitor, and demographic information for both new and existing markets and service lines as input into the strategic and financial planning processCreated quarterly market share reports and provide new market insights for leaders across IU Health to understand changes in market volumes, competition, and patient trendsDeveloped Tableau visualizations, maps, and dashboards for IU Health leadership to quickly understand market share and physician leakage trendsAnalyzed proposed physician practice locations using geospatial analysis in ArcGIS Pro by modeling patient, competitor, demographic, and drive time data

Indianapolis, Indiana Area

Responsible for mentoring and training new hires and interns on SQL, reporting and data analysis tools, data warehouses, and business intelligence best practicesDevelop Tableau dashboards for the revenue cycle business partners to analyze and drill down into data which enables them to measure financial impact of investments, quickly identify billing issues, and track progress on revenue cycle goalsDesign a new data warehouse for revenue cycle to enable more efficient reporting and analytics and move towards a self-service reporting environmentDevelop statistical models in R to predict the probability of a patient making a payment to enable the business to prioritize accounts

Milan, Illinois

Executed a self-service reporting strategy to enable the business to quickly create their own reportsImplemented a SAP Hana Business Objects and Tableau reporting environment to enable the business to get real-time data from SAP and non-SAP environmentsDeveloped a Business Objects Dashboard for a global parts group to compare performance of regions, manage the parts business, and view real-time dealer resultsDeveloped Business Object reports and Universes built on top of DB2, Netezza, and SAP Hana databasesAssisted in the upgrade of Business Objects from BI3 to BI4 by converting Deski reports to Webi reports and managed testing for Business Objects DashboardsSupported over 1000 reports and 100 Business Objects Universes to enable the business to make tactical and strategic decisions

Partnered with 4 non-profits in the Bloomington community to provide solutions to their technical needs: Area 10: Agency on Aging, Big Brothers Big Sisters, MCUM, and LifeDesignsManaged a team implementing a cloud based system for easy form entry for clients, elimination of paper and pencil method, and quick report generation Designed and developed two new websites with a team of 5 coworkers to promote the two organizationsVolunteered with the organizations to help understand and execute their missionIncreased social media following by over 50% by implementing a social media strategy to increase membership, donations, and community awareness

Moline, Il

I created and implemented a Business Objects Dashboard for a global parts group to compare performance of regions, manage the parts business, and view real-time dealer resultsI assisted in the upgrade of Business Objects from BI3 to BI4 by converting Deski reports to Webi, project managed testing for Business Objects Dashboards, and migrated dashboard files off the server to SharePoint.

I developed Business Object universes and reports for the financial and actuarial departments to use as a tool for analyzing Medical Protective’s current and historical performance.I designed monthly PowerPoint presentations that run off reports and are distributed to the company’s business leaders to present to investors, potential clients, and the CEO.

I developed Excel order, customer, and financial spreadsheets to improve efficiency and accuracy.I was also responsible for creating a database of client documents and information for ease of access and to go paperless.