Joseph D Kendall Email and Phone Number

Leading and developing the cost transparency initiative. DRI (directly responsible individual) for the project working across organizations and departments to bring the project to fruition.Developing code using Google BigQuery to create the machine-readable files.

Developed reports and dashboards in Power BI. Optimized and tuned SQL and SSIS packages.

Provided data and reporting on membership, claims, HEDIS, and Patient and Safety measures for Medicare, Medicaid, and Commercial members. Developed databases to increase proficiency in associates performing outreach to providers and to allow for easier reporting on outreach effectiveness. In the process of developing a dashboard for the team which will allow for better recognition of operational metrics and goals.• Developed a report in Power BI to track operational metrics for associates visiting providers• Created a HEDIS open gaps report that allows the quality team to close the open gaps and which will increase revenue by $29,000• Analyzed claims for ER visits to determine the cause of visits and the opportunities to reduce expenses

Consulting at Aspen Dental Management, Inc. (ADMI).Led effort to change from a mainframe backend for Finance and HR functions to using SQL Server. Performed functions such as business analyst, architect, and developer. Documented current state architecture and processes on SQL Server that interface with AS400. Provided guidance on future state development in SQL Server. Developed solutions using SQL and C#.

Review healthcare provider's contracts with health insurance companies to maximize profit. Provide contract analysis for Medicare Advantage and commercial insurances. Create analytical processes and small data warehouses/data marts to analyze and report on healthcare.

Managed teams remotely (WAH) with both a technical and analytical background within the Provider Strategy and Analytics department. Developed policies and procedures, documentation, and resource planning for multiple projects. Analyzed data and reported results using tools such as Access, Excel, VBA, Pivot Tables, SQL Server, Oracle, Tableau, Netezza, SAS, and SharePoint. Led data governance efforts for department.• Presented analytical results of historical and future unit cost trends for commercial and Medicare data to management. Met or exceeded SLA every time. • Reduced the process time for the biannual claims data submission for discount analysis by 97% due to implementing process improvements. The process originally required 3 associates to work on it all year. The new process required 1 associate one month out of the year.• Led project that sets benchmarks for contractors in relation to the unit cost trends. Provided data analysis and reporting on the progress toward the benchmarks to management. Led change management for the organization in relation to these benchmarks.• Created within the team a culture that my director wanted his other managers to implement. We had open and honest communication with one another. Associates were provided growth opportunities due to the projects they worked on or additional training that was provided. Goals were created that would help the associate grow while providing what was needed for the company.

Led team of consultants in programming, data management, and analytics. Served as a project manager to gather requirements, design and develop solutions, test and then implement the reporting and analytical solutions. Worked in an agile environment with a Scrum and Kanban development framework.• Developed analytical reporting that saved $5 million in one contract negotiation with a major hospital system and also continues to save money annually in contract negotiations.• Renegotiated a contract with a vendor that saves $150,000+ annually.• Led IT development for business unit to provide commercial claims data to actuarial firms that drives Humana's business with large customers.

Coached and managed multiple teams. Project manager for multiple projects making sure the projects are on schedule and to budget. Created process improvements that enhanced productivity of teams. Led development of applications and reporting solutions. Performed systems analysis including requirements gathering, design, development, testing, debugging, deployment, and maintenance on projects.• Developed part of the enterprise data warehouse for the new Medicare PDP program.• Decreased turnaround time for reports and data 50% from 8 days to 4 days for one team.• Trained team and implemented process improvements which allowed a reduction in staff that saved $200,000 per year.• Built dashboards/KPIs using tools such as Oracle Reports and Forms, Excel, and VB.NET.• Learned Oracle OLAP and created first Oracle OLAP implementation within Humana.• Managed project that reduced underwriting dependencies and implemented new technology solution to save time.

Led programming and reporting projects. Managed and led the effort to implement reporting on EPSDT for the state of KY. Shaped the way the state of KY reported after leading the effort.• Created various application and reporting tools for various departments.• Led effort to reduce time and costs with applications, tools, and reports.• Developed and managed applications with Visual Basic 5/6 and Access 97• Created and maintained company reports with SQL, Access 97 and Crystal Reports 4.5