William Capps Email & Phone Number

Louisville, Kentucky, United States

Manage creation and submission of Dual Eligible Medicaid/Medicare DSNP reports across 20+ states daily/weekly/monthly. Review DSNP reporting regularly to remediate any issues to maintain compliance with state and CMS regulatory requirements.Meet with state health departments to discuss DSNP reporting and answer any relevant questions around processes and reports.Review state DSNP contracts annually and implement changes across reporting to maintain compliance.Utilize Microsoft Planner, Power Automate, Power Apps, SharePoint Online, Teams, Power BI, and other office apps to automate and streamline processes.Facilitate collaborative meetings with internal and external partners to ensure report submissions remain compliant. Provide regular updates to leadership regarding status of reporting and ongoing projects. Implemented new process to capture performance metrics around DSNP reports and created repository of historical information related to report data.Develop, test, and implement reporting for new states annually.Lead a team of associates overseeing DSNP reporting work by providing oversight and guidance on DSNP reporting and ongoing projects.Collaborate with IT to update reporting processes and remediate any data issues found by submitting change requests and completing UAT work.Maintain PowerBI report to review delegate data submissions to ensure all appropriate contributors are submitting reporting.

Louisville, Kentucky

Managed submission of delegate audit file submissions, which was more than 500 files monthly. Communicated with delegates to remediate issues with their audit submissions to maintain CMS compliance, and to determine the root cause of any errors with their audit submissions. Maintained and updated Departmental SharePoint sites, which includes managing the transition to the SharePoint Online platform.Transitioned all SharePoint Workflows to the Power Automate platform.Routinely completed UAT of updates made to systems and procedures in coordination with IT.Worked with Delegation Compliance, and Humana Market Contacts to determine the source of issues with delegate claims processes. Coordinated with multiple teams within Humana to supplement delegate audit submission files with data from multiple sources.Documented ORM processes and procedures across the multiple tools used to receive and validate delegate audit submission files.Continually participated in ongoing education revolving around Excel VBA, Access, SharePoint, Power Automate, Power Apps, and other Office 365 products.

Developed and maintained departmental website in SharePoint.Managed consultant billings and coordinated access to company systems and on-site visits.Involved in departmental strategy development and implementation.Developed administrative budgets for 9 departments within Senior Products Actuarial, and managed monthly spending.Developed tools and templates for budget development, tracking of departmental processes, and other Excel based projects.Lead teams that focused on internal peer review, and review of Medicare Advantage bids.Continually participated in continuing education revolving around Excel VBA, other Microsoft Office products, project management, and Oracle financial tools.Managed annual summer intern project.

Created, maintained, and managed processes to track development of medicare advantage bids as they are created prior to the CMS mandated submission date. Developed Sharepoint sites for multiple departments. Managed projects for development of summer actuarial interns. Also responsible for development, tracking, and managing of departmental budgets.

Louisville, Kentucky Area

Completed monthly reports for analysis of base cost, headcount, company issued credit cards, inter company billings, and program expenditures.Successfully created new program spend tracking method, presented it to the CFO of Consumer & Industrial, and implemented it among the three different businesses.Communicated on a regular basis with program managers and engineers globally to decrease discretionary spending.Booked journal entries and performed basic accounting.