Tableau Dashboard Development:• Developer of a total cost strategy dashboard, which has allowed practices to identify multiple areas of cost saving initiatives leading to positive outcomes, both financially and clinically, within VBC programs• Developer of financial analysis dashboard to determine appropriate levels of financial reserves• Developer of several market analytic dashboards for targeted market growth potential• Maintained and enhanced multiple existing dashboards for both internal and external facing customers Adhoc and standard reporting packages:• Program lead for evaluation and communication for impacts of new Medicare Oncology Model• Developer of financial model which estimated program savings for different VBC program initiatives• Developer of several utilization reports to help practices track actionable trends• Collaborate with practice administrators and physicians to identify KPI’s in support of key VBC metrics which resulted in many network practices receiving performance-based incentive payments• Creation of reporting tables to allow for standardization and consistency across dashboards, reports, and analyses

• Analyze and drill into the cause of high trending claim categories to identify savings initiatives• Partner with Provider Contractors to provide analysis for contract negotiations• Support UM staff to identify members in need of case or utilization management• Work with all levels of management to produce actionable adhoc reports and analyses

Development of data warehouse• Produced business requirements and lead the business effort for the creation of our integrated data warehouse which improved all reporting and analysis efforts• Produced technical requirements, performed as subject matter expert, and designed reporting specific tables which resulted more efficient, accurate and consistent reporting• Subject matter expert and main point of contact on both warehouse and source system data Dashboard and report development, data analysis• Developed multiple dashboards for all levels of management which provided the only source of information for the measurement of key performance indicators• Developed operational dashboard to give insight to operations staff performance• Created queries to extract data from multiple source systems for trending and analytical processes• Responsible for design and development of standard reports for new service models• Responsible for both internal and external client report requests• Participated in the development of a business glossary to define and standardize terminology which aided in a consistent understanding across all areas of the company

Develop standard and ad hoc reporting packages • Responsible for all corporate level cost of care reporting• Establish cost saving estimates to determine effectiveness and validate contractual agreements of third party vendors• Produce adhoc reports for most areas of the company which resulted in cost savings for the company and increased levels of service to our members• Automated a key company wide report eliminating the need for a full time employee and resulted in increased accuracy within the reportPlay a key role in multiple company wide process improvements• Developed database for Medical Management group which automated several previously manual processes and resulted in the elimination of 20 hours of manual labor and an increased accuracy within program• Developed database to track departmental projects which lead to increased efficiency and productivity within department while helping to manage and distribute work load• Represented Anthem West in company wide common data definitions task force which standardized reporting across all regions• Played key role in defining key fields in datamart which lead to standardized process of pulling data while making data more accessible to users

Software Testing

Client and Internal Reporting Needs

Small and Large Group UnderwritingActuarial Analyses