Adam Hendrickson Email and Phone Number

• Integrate and Manage Data across application landscape (D365FO/EDI/SFTP/Salesforce file exchange)• Data Management Framework (DMF)• System and 3rd party managed application services administration • SQL extraction/reporting• Reporting Automation & Transmission SSIS, API, SFTP, Power BI

• Planned and executed data migration from SAP B1 to D365• Gather & Implement: Functional business processes and requirements • Lead & Assist: Design, configuration, and implementation of business applications that meet user requirements• Build, Deploy & Migrate: Dynamics 365 solutions across development, test, pre-production, and production environments• Post-Implementation Development: Create proactive reporting solutions across all business units utilizing SQL, Power BI, and Common Data Services• D365 Modules Competency - AP,AR,Accounting, Advanced WMS, procurement, discrete and process mfg, all sales modules

• Created ROI reporting for member outreach programs: executive reporting suite articulating program effectiveness of outreach initiatives utilized by internal and external audiences• Developed HEDIS Quality Measurement Key Performance Indicator reporting for senior and executive management• Developed intake system for healthcare provider sourced data compliant with HEDIS® requirements. Fulfilled a spectrum of responsibilities for this project including: provider liaison, business analyst, and intake systems developer

• Developed HEDIS production reporting compliant with NCQA/Federal Requirements• Provided technical guidance on SQL development• Integrated third party provider supplemental data

• Maintained and built referral relationships with CPAs, bookkeepers, banks, and merchant services provider• Provided small businesses guidance and solutions for payroll and human resources

• Built and maintained relationships with internal and external stakeholders and clients• Adapted quickly to ACA healthcare standards through rapid ad-hoc reporting and value add analysis of health code changes• Managed and administered CMS Retiree Drug Subsidy Programo Prepared, validated, and reconciled cost datao Managed retiree eligibilityo Automated final rebate calculationso Served as external liaison to participating employer groupso Increased Employer subsidy returns by 5% through process improvement• Developed business trend reporting for Director and VP level managemento Integrated multi sourced data into a demographic based suite of reportingo Optimized existing reporting and removed waste via LEAN (Rapid Process Improvement)

• Consulted and created reporting for Senior Management, Finance, Actuarial, Customer Service, and Claims Processing• Produced and implemented efficient standard reporting processes for internal and external stakeholders• Created adhoc reporting and reconciliation utilizing multiple source systems: SQL Server, Mainframe, and third-party Data Marts• Developed peer review documentation: business purpose, validation and reconciliation